在mysql 下写的存储过程

在mysql里写的存储过程：

DELIMITER $$

DROP PROCEDURE IF EXISTS `jdbc`.`addUser` $$
CREATE PROCEDURE `jdbc`.`addUser` (in pname varchar(45), in birthday Date, in money float, out pid int)
BEGIN
       insert into user(name , birthday , money ) values ( pname , birthday , money );
       select last_insert_id() into pid;  // last_insert_id()是mysql里的函数，查找最后一条的id

　    //意思是把最后一条的id查出来，放到pid里
END $$

DELIMITER ;

------------------------------------------

用java调用存储过程:

package com.itcast.jdbc; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Types; public class PsTest { /** * 存储过程 * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub ps(); } static void ps() { Connection conn = null; CallableStatement cs = null; //存储过程 ResultSet rs = null; // String sql = "{ call addUser(?,?,?,?)}"; try { conn = jdbcUtilsSing.getInstance().getConnection(); cs = conn.prepareCall(sql); // cs.registerOutParameter(4, Types.INTEGER); //注册输出参数 cs.setString(1, "ps name"); cs.setDate(2, new java.sql.Date(System.currentTimeMillis())); cs.setFloat(3, 100f); // cs.executeUpdate(); int id = cs.getInt(4); System.out.println(id); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } }