return getJdbcTemplate().execute(new CallableStatementCreator() {
@Override
public CallableStatement createCallableStatement(Connection con) throws SQLException {
String storedProc = "{call update_empid(?,?,?,?,?)}";
CallableStatement cs = con.prepareCall(storedProc);
cs.setString(1, changeEmployeeId.getPeid());
cs.setString(2, changeEmployeeId.getOldEmpid());
cs.setString(3, changeEmployeeId.getNewEmpid());
cs.setString(4, changeEmployeeId.getGuid());
cs.registerOutParameter(5, Types.INTEGER);
return cs;
}
}, new CallableStatementCallback<Integer>() {
@Override
public Integer doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException {
cs.execute();
return cs.getInt(5);
}
});