String count =
"SELECT * FROM wx_user";
PreparedStatement ptc = con.prepareStatement(count);
ResultSet rsc = ptc.executeQuery();
while (rsc.next()){
String t_count = String.valueOf(rsc.getInt("t_count"));
String callid = rsc.getString("callid");
String called = rsc.getString("called");
if (t_count == null){
String count1 =
"UPDATE wx_user SET t_count = ? WHERE callid = ? AND called = ?";
PreparedStatement ptc1 = con.prepareStatement(count1);
ptc1.setInt(1,0);
ptc1.setString(2,callid);
ptc1.setString(3,called);
ptc1.executeUpdate();
}
null 咋换成0呢