JDBC调用存储过程

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`add` $$
CREATE PROCEDURE `test`.`add` (in points varchar(20),in name varchar(20),out pid int)
BEGIN

insert into point(points,name)values(points,name);
select last_insert_id into pid;

END $$

DELIMITER ;

 

 

try {
   CallableStatement cs = null;
   Connection conn = null;
   String sql ="{ call add(?,?,?,?)}";
   cs = conn.prepareCall(sql);
   //注册输出参数
   cs.registerOutParameter(4,Types.INTEGER);
   //输入参数
   cs.setString(1, "points");
   cs.setString(2,"name");
   cs.executeUpdate();
   int id = cs.getInt(4);
   
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }