请先看我的代码: public Vector select(Object pojo,String condition , String conditionValue){
Vector v = new Vector();
GetConnection getConn = null ;
SQLFactory sf = new SQLFactory(pojo);
String sql = sf.createSql(
SQLFactory.SELECT,condition,conditionValue);
try{
getConn = new GetConnection();
conn = getConn.getConnection() ;
stat = conn.createStatement();
rs = stat.executeQuery(sql);
while(rs.next()){
Vector tempV = new Vector();
tempV.add(rs.getInt(1));
tempV.add(rs.getString(2));
tempV.add(rs.getString(3));
tempV.add(rs.getString(4));
v.add(tempV);
}
}
catch(Exception err){
err.printStackTrace();
}
finally{
try {
System.out.println(rs);
if( null != rs
&& !rs.isClosed() )
rs.close();
rs = null ;
if( null != stat && !stat.isClosed())
stat.close();
stat = null ;
} catch (SQLException e) {
e.printStackTrace();
}
getConn.close();
conn = null ;
}
return v ;
}
这个代码,报错如下:
oracle.jdbc.driver.OracleResultSetImpl@1dfc547
Exception in thread "main" java.lang.AbstractMethodError: oracle.jdbc.driver.OracleResultSetImpl.isClosed()Z
at dao.BasicDBOImpl.select(BasicDBOImpl.java:124)
at util.CheckData.isExist(CheckData.java:12)
at dao.BasicDBOImpl.add(BasicDBOImpl.java:26)
at dao.BasicDBOImpl.main(BasicDBOImpl.java:140)从报错情况看,输出:oracle.jdbc.driver.OracleResultSetImpl@1dfc547,
说明rs不为null,
与此同时,at dao.BasicDBOImpl.select(BasicDBOImpl.java:124),
说明问题出在第125&& !rs.isClosed()这里!-------------------------问题1,既然rs没问题,怎么会有错 ?问题2:怎么改 ?
菜鸟求教
Vector v = new Vector();
GetConnection getConn = null ;
SQLFactory sf = new SQLFactory(pojo);
String sql = sf.createSql(
SQLFactory.SELECT,condition,conditionValue);
try{
getConn = new GetConnection();
conn = getConn.getConnection() ;
stat = conn.createStatement();
rs = stat.executeQuery(sql);
while(rs.next()){
Vector tempV = new Vector();
tempV.add(rs.getInt(1));
tempV.add(rs.getString(2));
tempV.add(rs.getString(3));
tempV.add(rs.getString(4));
v.add(tempV);
}
}
catch(Exception err){
err.printStackTrace();
}
finally{
try {
System.out.println(rs);
if( null != rs
&& !rs.isClosed() )
rs.close();
rs = null ;
if( null != stat && !stat.isClosed())
stat.close();
stat = null ;
} catch (SQLException e) {
e.printStackTrace();
}
getConn.close();
conn = null ;
}
return v ;
}
这个代码,报错如下:
oracle.jdbc.driver.OracleResultSetImpl@1dfc547
Exception in thread "main" java.lang.AbstractMethodError: oracle.jdbc.driver.OracleResultSetImpl.isClosed()Z
at dao.BasicDBOImpl.select(BasicDBOImpl.java:124)
at util.CheckData.isExist(CheckData.java:12)
at dao.BasicDBOImpl.add(BasicDBOImpl.java:26)
at dao.BasicDBOImpl.main(BasicDBOImpl.java:140)从报错情况看,输出:oracle.jdbc.driver.OracleResultSetImpl@1dfc547,
说明rs不为null,
与此同时,at dao.BasicDBOImpl.select(BasicDBOImpl.java:124),
说明问题出在第125&& !rs.isClosed()这里!-------------------------问题1,既然rs没问题,怎么会有错 ?问题2:怎么改 ?
菜鸟求教
都一样,是这样的,这里,问题出在第27行和28行: if( null != rs
&& !rs.isClosed() )
如果把 !rs.isCloed()去掉,程序就正常了。很纠结!
【把"&&"改成" || "是不行的】
我的ResultSet是类变量,不是函数局部变量!
我的Connection \ Statement \ ResultSet是类变量,
方式如下:
conn = null ; stat = null ; rs = null ;
然后,在再函数内部创建相应空间,用完释放!
我的程序里面,是数据库连接是类变量这一级别!定义时显式定义为null
然后,在函数里面,创建相应的连接!
同样,在函数里创建,并在函数里释放!
与jar关系不大把 !
用的是oracle 10g里面jdbc自带class12.jar !
问题找到了,是Oracle自带的驱动有问题 !!!