学步园

jdbcTemplate.execute(<br /> new CallableStatementCreator() {<br /> public CallableStatement createCallableStatement(Connection conn) {<br /> try {<br /> CallableStatement cs = conn.prepareCall("{ call PROC_A(?, ?) }");<br /> cs.setString(1, bizType);<br /> cs.registerOutParameter(2, Types.VARCHAR);<br /> return cs;<br /> } catch (SQLException e) {<br /> e.printStackTrace();<br /> }<br /> return null;<br /> }<br /> },<br /> new CallableStatementCallback() {<br /> public Object doInCallableStatement(CallableStatement cs) {<br /> try {<br /> cs.execute();<br /> return cs.getString(2);<br /> } catch (SQLException e) {<br /> e.printStackTrace();<br /> }<br /> return "";<br /> }<br /> });