发表于 2009-1-5 19:48
| 
java.sql.SQLException: 鐢ㄥ敖鐨 Resultset
鍙戝竷: 2008-12-08 18:08 | 浣滆: webmaster | 鏉ユ簮: 鏈珯鍘熷垱 | 鏌ョ湅: 122娆
stmtstsy = coneadmin.createStatement();
PreparedStatement stmtUpdateJJB = coneadmin.prepareStatement("insert into 銆傘傘傘)"
+ " values(?,?,?,?,?,?)");
ResultSet rs = stmtstsy.executeQuery("select 銆傘傘傘");
ResultSet rsIN = null;
while ( rs.next() )
{
//stmtstsy1 = coneadmin.createStatement();
rsIN = stmtstsy.executeQuery("select * from 銆傘傘 " + String.valueOf(rs.getLong("id")));
if (rsIN.next())
{
rsIN.close();
stmtstsy.close();
continue;
}
rsIN.close();
stmtstsy.close();
stmtUpdateJJB.setLong(1 , rs.getLong(1));
stmtUpdateJJB.setString(2, rs.getString(2));
stmtUpdateJJB.setString(3, rs.getString(3));
stmtUpdateJJB.setString(4, rs.getString(4));
stmtUpdateJJB.setString(5, rs.getString(5));
stmtUpdateJJB.setLong(6, rs.getLong(6));
stmtUpdateJJB.executeUpdate();
i++;
System.out.println(i + " " + rs.getLong(6));
}
rs.close();
stmtUpdateJJB.close();
coneadmin.close();
閿欒鎰挎剰锛 涓や釜缁撴灉闆嗛兘鐢ㄧ殑鏄竴涓猻tatement锛屽綋涓涓粨鏋滈泦鍏抽棴锛屾妸statement鍏抽棴浜嗭紝浠や竴涓粨鏋滈泦浣跨敤灏卞嚭鐜拌繖鏍风殑閿欍
绋嬪簭澶嶆潅鐨勬椂鍊欑粡甯稿鏄撳嚭鐜颁竴涓湴鏂瑰叧闂璼tatement锛屼护涓涓湴鏂硅繕璋冪敤鍏剁粨鏋滈泦銆傝皑鎱庡鐞嗐
