oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)数据库错误,看看数据库权限、网络连接有问题吗重启服务器试试
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)数据库错误,看看数据库权限、网络连接有问题吗重启服务器试试
while(answerrs!=null&&answerrs.next()){
Date currentTime = answerrs.getDate("Restore_date");//处理时间}
这个有差别,我在java中是用stmt = conn.prepareStatement(sql);
rs = stmt.executeQuery();这样写的返回result是成功的,但是不能answerrs.next();真是奇怪。jsp中的方法如下,就可以了:
Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY ,ResultSet.CONCUR_UPDATABLE);
String sql = "select * form a";
ResultSet answerrs = stmt.executeQuery(sql);
if(answerrs!=null){
while(answerrs.next()){
Date currentTime = answerrs.getDate("Restore_date");//处理时间
}
}
在java类中我将连接close了,应该为null