Connection conn = getConncetion();//获取oracle连接的方法
ResultSet rs = null;
PreparedStatement ps = null;
String sql = "";
try
{
sql = "select * from tablename";
ps = conn.prepareStatement(sql);
rs.excuteQuery(sql);
while(rs != null && rs.next() )
{
String strNo = (String) rs.getObject(1);
String strName = (String) rs.getObject(2);
}
catch(Exception ex)
{
System.out.print(ex.getMessage());
}
finally
{
try
{
conn.close();
ps.close();
rs.close();
}
catch(Exception ex)
{}
}
ResultSet rs = null;
PreparedStatement ps = null;
String sql = "";
try
{
sql = "select * from tablename";
ps = conn.prepareStatement(sql);
rs.excuteQuery(sql);
while(rs != null && rs.next() )
{
String strNo = (String) rs.getObject(1);
String strName = (String) rs.getObject(2);
}
catch(Exception ex)
{
System.out.print(ex.getMessage());
}
finally
{
try
{
conn.close();
ps.close();
rs.close();
}
catch(Exception ex)
{}
}
我不是什么高手,不过我一般都不写rs!=null
你把这行去掉试试
不是rs=state.excuteQuery(sql); ??
try
{
rs.close();
ps.close();
conn.close();
}
catch(Exception ex)
{}
再有就是把数据库重启一下了
String strSql = "************";
try{
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(strSql);
}catch(Exception e){
}没出过问题,要不你也试试?
它是不管发不发生异常,都会执行的。这样你在第一个循环的时候就把rs流关闭了