delimiter $$ CREATE PROCEDURE demoSp(IN inputParam VARCHAR(255), INOUT inOutParam varchar(255)) BEGIN SELECT CONCAT('zyxw---', inputParam) into inOutParam; END $$ delimiter ; |
Connection conn = null; CallableStatement st = null; //list ResultSet rs = null; try{ conn = DBManager.getConnection(); st = conn.prepareCall("{call demoSp(?,?)}"); st.setString(1, "aaaaaaaaaaaa"); st.registerOutParameter(2, Types.VARCHAR); st.execu |