//创建存储过程
CREATE PROCEDURE get_eid_from_examSchool(parameter INT)
outer_block:BEGIN
SELECT e_id FROM examschool WHERE es_num = parameter;
END outer_block
//为存储过程赋予权限
GRANT EXECUTE on PROCEDURE examination.get_eid_from_examSchool TO 'Examination'@'localhost';
FLUSH PRIVILEGES;
//Java代码调用
private CallableStatement stmt;
for(int i=0;i<es_num.size();i++){
sql = "{call get_eid_from_examSchool(?)}";
stmt = con.prepareCall(sql);
stmt.setString(1, es_num.get(i));
result = stmt.executeQuery();
while(result.next()){
e_id.add(result.getString("e_id"));
}
}