PreparedStatement prepareTemp;...
if(rs.next()){
Roleid = rs.getInt("p_roleId");
sql = "insert into LOG (l_userName,l_ipAddress,l_registerTime,l_success) values (?,?,getdate(),1)";
prepare.close();
prepareTemp= conn.prepareStatement(sql);
prepareTemp.setString(1,username);
prepareTemp.setString(2,ipaddress);
auth = SUCCESS;
}
...
prepareTemp.executeUpdate();
if(rs.next()){
Roleid = rs.getInt("p_roleId");
sql = "insert into LOG (l_userName,l_ipAddress,l_registerTime,l_success) values (?,?,getdate(),1)";
prepare.close();
prepareTemp= conn.prepareStatement(sql);
prepareTemp.setString(1,username);
prepareTemp.setString(2,ipaddress);
auth = SUCCESS;
}
...
prepareTemp.executeUpdate();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货