jdbc调用存储过程

		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();
		}