rs被stmt.executeUpdate(sql)冲掉了,可以这样
Statement stmt1 = conn.createStatement() ;
Statement stmt2 = conn.createStatement() ;
ResultSet rs = stmt1.executeQuery( sql ) ;
while(rs.next()) {
String sql="insert into messagebox (username,type)values('"+ rs.getString("username")+"','0');";
stmt2.executeUpdate(sql);
}
Statement stmt1 = conn.createStatement() ;
Statement stmt2 = conn.createStatement() ;
ResultSet rs = stmt1.executeQuery( sql ) ;
while(rs.next()) {
String sql="insert into messagebox (username,type)values('"+ rs.getString("username")+"','0');";
stmt2.executeUpdate(sql);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货