Skip to main content

Execute Stored procedure

Call Stored Procedure Using Spring JDBCTemplate​

    @Autowired
    private JdbcTemplate jdbcTemplate;

  /* Calling Stored Procedure using JdbcTemplate */
  public Map<String, Object> searchUserByName(String searchTerm) {
    List<SqlParameter> parameters = Arrays.asList(new SqlParameter(Types.NVARCHAR));
    
    return jdbcTemplate.call(new CallableStatementCreator() {
      @Override
      public CallableStatement createCallableStatement(Connection con) throws SQLException {

        CallableStatement cs = con.prepareCall("{call search_users_proc(?)}");
        cs.setString(1, searchTerm);
        return cs;
      }
    }, parameters);
  }

call stored procedure using jdbc callable statment​

CallableStatement cstmt = con.prepareCall("{call myProcedure(?, ?, ?)}");
cstmt.setString(1, "Raghav");
cstmt.setInt(2, 3000);
cstmt.setString(3, "Hyderabad");
cstmt.execute();