把sysdate换成date(),结果:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]'date' 不是可以识别的 函数名。这怎么办呀??
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]'date' 不是可以识别的 函数名。这怎么办呀??
String sql3="insert into querylog values(today,'"+userName+"','pc','"+rs5.getString("ckxx_xm")+"','"+rs5.getString("ckxx_gmzh")+"')";//**
rs3=stmt1.executeQuery(sql3);改用Date()也不行,异常如下:
fServer.java:122: reference to Date is ambiguous, both class java.util.Date in j
ava.util and class java.sql.Date in java.sql match
Date today=new Date()
^
fServer.java:122: reference to Date is ambiguous, both class java.util.Date in j
ava.util and class java.sql.Date in java.sql match
Date today=new Date()
^
String sql3="insert into querylog values(date(),'"+userName+"','pc','"+rs5.getString("ckxx_xm")+"','"+rs5.getString("ckxx_gmzh")+"')";//**
rs3=stmt1.executeQuery(sql3);
也有异常:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]'da
te' 不是可以识别的 函数名。
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]'da
te' 不是可以识别的 函数名。
救命呀,SQL中取当前日期是哪个函数呀?
String sql3="insert into querylog values(GETDATE(),'"+userName+"','pc','"+rs5.getString("ckxx_xm")+"','"+rs5.getString("ckxx_gmzh")+"')";//**
rs3=stmt1.executeQuery(sql3);出错行是rs3=stmt1.executeQuery(sql3);java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet s
et was produced.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet s
et was produced.
到底应该怎么改呀??
String sql3="insert into querylog values("+today+",'"+userName+"','pc','"+rs5.getString("ckxx_xm")+"','"+rs5.getString("ckxx_gmzh")+"')";//**
stmt1.executeUpdate(sql3);//老兄,insert 语句应该调用 executeUpdate
// 并且不会返回一个 ResultSet 的啊!
// getdate 是没有错的啊!