String aaa = "2007-02-02";
rs = st.executeQuery(" select adddate(" + aaa + ",1) as a"); while (rs.next()) {
System.out.println(rs.getString("a"));
}
我在java里有这么一段sql语句.我想打印adddate的结果.请问怎么写代码??
我这样写打印结果为null....郁闷
rs = st.executeQuery(" select adddate(" + aaa + ",1) as a"); while (rs.next()) {
System.out.println(rs.getString("a"));
}
我在java里有这么一段sql语句.我想打印adddate的结果.请问怎么写代码??
我这样写打印结果为null....郁闷
先把sql调对了。
Connection conn = DriverManager.getConnection(url,user,password);
conn.setAutoCommit(false);
CallableStatement proc = conn.prepareCall("{? = Call \"funSelectIpByCallerTime\"(?,?)}");
proc.registerOutParameter(1,Types.OTHER);
proc.setString(2,CallerNumber);
proc.setString(3,StartTime);
proc.execute();
ResultSet rs = (ResultSet)proc.getObject(1);
while(rs.next()){
String ReGenrationID = rs.getString(1);
String Ip = rs.getString(2);
int Port = rs.getInt(3);
System.out.println(ReGenrationID + "||" + Ip + "||" + Port);
}
rs.close();