Connection conn = ConnectionManager.newConnection();
CallableStatement proc = null;
try {
for(int i = 0; i < userids.length; i++){
if(flag){
insertRoleUser(userids[i]);
flag=insertTeachUser(crb,userids[i]);
String sql = " {call t_smsapp_userInsert(?, ?, ? ) }";
proc = conn.prepareCall(sql);
proc.setInt(1, Integer.parseInt(crb.getRoom_id()));
proc.setString(2, userids[i]);
proc.registerOutParameter(3, Types.INTEGER);
proc.execute();
int temp = proc.getInt(3);
if(temp > 0){
flag = true;
} else {
flag = false;
}
System.out.println("flag : " + flag);
}
}
} catch (NumberFormatException e) {
e.printStackTrace();
}
jdbc调用存储过程
最新推荐文章于 2022-07-09 16:30:58 发布