jdbc调用存储过程

一：在mysql中编写存储过程

delimiter $$

CREATE PROCEDURE demoSp(IN inputParam VARCHAR(255), INOUT inOutParam varchar(255))
BEGIN
    SELECT CONCAT('zyxw---', inputParam) into inOutParam;
END $$

delimiter ;

二：得到CallableStatement，并调用存储过程

CallableStatement cStmt = conn.prepareCall("{call demoSp(?, ?)}");

•设置参数，注册返回值，得到输出

cStmt.registerOutParameter(2, Types.VARCHAR);

cStmt.setString(1, "abcdefg");

cStmt.execute();

System.out.println(cStmt.getString(2));