Example usage for org.springframework.jdbc.core.simple SimpleJdbcCall SimpleJdbcCall

Introduction

In this page you can find the example usage for org.springframework.jdbc.core.simple SimpleJdbcCall SimpleJdbcCall.

Prototype

public SimpleJdbcCall(JdbcTemplate jdbcTemplate) 

Source Link

Document

Alternative Constructor that takes one parameter with the JdbcTemplate to be used.

Usage

From source file:pkg.StudentJDBCTemplateStoredProcedure.java

public void setDataSource(DataSource dataSource) {
    this.dataSource = dataSource;
    this.jdbcCall = new SimpleJdbcCall(dataSource).withProcedureName("getRecord");
}

---

From source file:com.mec.DAO.Passport.UserDAO.java

public Usuario getUser(String nombre, String clave) {
    Usuario u = null;/*  w w w .  jav  a  2  s. c o  m*/
    SimpleJdbcCall jdbcCall = new SimpleJdbcCall(ds).withCatalogName("dbo")
            .withProcedureName("paValidarUsuario").withoutProcedureColumnMetaDataAccess()
            .declareParameters(new SqlParameter("NombreUsuario", Types.VARCHAR))
            .declareParameters(new SqlParameter("Clave", Types.VARCHAR))
            .declareParameters(new SqlOutParameter("UserId", Types.INTEGER))
            .declareParameters(new SqlOutParameter("ErrText", Types.VARCHAR));
    SqlParameterSource in = new MapSqlParameterSource().addValue("NombreUsuario", nombre).addValue("Clave",
            clave);
    Map<String, Object> r = jdbcCall.execute(in);
    Integer userId = null;
    String errText = "";
    for (Map.Entry<String, Object> entry : r.entrySet()) {
        String key = entry.getKey();
        if (key.equals("UserId")) {
            userId = (Integer) entry.getValue();
        } else if (key.equals("ErrText")) {
            errText = (String) entry.getValue();
        }
    }
    if (userId != null && errText.equals("Ok")) {
        List<GrantedAuthority> roles = getUserRoles(userId);
        u = new Usuario(userId, roles);
    }
    return u;
}

---

From source file:ru.org.linux.spring.StatUpdater.java

@Autowired
public void setDataSource(DataSource dataSource) {
    statUpdate = new SimpleJdbcCall(dataSource).withFunctionName("stat_update");
    statUpdate2 = new SimpleJdbcCall(dataSource).withFunctionName("stat_update2");
    statMonthly = new SimpleJdbcCall(dataSource).withFunctionName("update_monthly_stats");
    jdbcTemplate = new JdbcTemplate(dataSource);
}

---

From source file:com.team3637.service.MatchServiceMySQLImpl.java

@Override
public void setDataSource(DataSource dataSource) {
    this.jdbcTemplateObject = new JdbcTemplate(dataSource);
    this.addCols = new SimpleJdbcCall(dataSource).withProcedureName("addCols");
    this.addTag = new SimpleJdbcCall(dataSource).withProcedureName("addTag");
    this.mergeTags = new SimpleJdbcCall(dataSource).withProcedureName("mergeTags");
}

---

From source file:com.example.dfa.demo.service.DfaDemoServiceImpl.java

@Autowired
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
    this.jdbcTemplate = jdbcTemplate;
    findWorkflowsSpaCall = new SimpleJdbcCall(jdbcTemplate).withProcedureName("sp_findEmployeeWorkflows")
            .withCatalogName("demo_employee")
            .returningResultSet("workflows", BeanPropertyRowMapper.newInstance(DfaWorkflowsDTO.class));

    getWorkflowsSpaCall = new SimpleJdbcCall(jdbcTemplate)
            .withProcedureName("sp_findWorkflowAndCurrentSubWorkflows").withCatalogName("demo_employee")
            .returningResultSet("workflows", BeanPropertyRowMapper.newInstance(DfaWorkflowsDTO.class));

    getSelectedEventsAndStatesSpaCall = new SimpleJdbcCall(jdbcTemplate)
            .withProcedureName("sp_selectWorkflowEventsAndStates").withCatalogName("demo_employee")
            .returningResultSet("events", BeanPropertyRowMapper.newInstance(SelectedEventsDTO.class))
            .returningResultSet("states", BeanPropertyRowMapper.newInstance(WorkflowStatesDTO.class));

    processWorkflowEventSpaCall = new SimpleJdbcCall(jdbcTemplate).withProcedureName("sp_processWorkflowEvent")
            .withCatalogName("demo_employee");

    insertEmployeeInsertStatement = new SimpleJdbcInsert(jdbcTemplate)
            .usingGeneratedKeyColumns("DFA_WORKFLOW_ID").withCatalogName("demo_employee")
            .withTableName("EMPLOYEE_PROSPECT");

    startWorkflowSpaCall = new SimpleJdbcCall(jdbcTemplate).withProcedureName("sp_startWorkflow")
            .withCatalogName("demo_employee");
}

---

From source file:com.team3637.service.TagServiceMySQLImpl.java

@Override
public void setDataSource(DataSource dataSource) {
    this.jdbcTemplateObject = new JdbcTemplate(dataSource);
    this.mergeTags = new SimpleJdbcCall(dataSource).withProcedureName("mergeTags");
    this.deleteTag = new SimpleJdbcCall(dataSource).withProcedureName("deleteTag");
}

---

From source file:com.mec.DAO.Passport.UserDAO.java

public List<GrantedAuthority> getUserRoles(Integer userID) {
    SimpleJdbcCall jdbcCall = new SimpleJdbcCall(ds).withCatalogName("SqlSp")
            .withProcedureName("paRolesGetByIdUsuario").withoutProcedureColumnMetaDataAccess()
            .declareParameters(new SqlParameter("idAplicacion", Types.INTEGER))
            .declareParameters(new SqlParameter("idUsuario", Types.INTEGER))
            .declareParameters(new SqlOutParameter("ErrText", Types.VARCHAR))
            .returningResultSet("items", new MyRowMapper());
    SqlParameterSource in = new MapSqlParameterSource().addValue("idAplicacion", 1).addValue("idUsuario",
            userID);/*from   www .  ja va 2s  .  co m*/
    return (List<GrantedAuthority>) jdbcCall.execute(in).entrySet().iterator().next().getValue();
}

---

From source file:Implement.DAO.CommonDAOImpl.java

@Override
public AccountSession loginToYouTripper(String username, String password) {
    password = DigestUtils.md5DigestAsHex(password.getBytes());
    simpleJdbcCall = new SimpleJdbcCall(dataSource).withProcedureName("loginToYouTripper");
    SqlParameterSource in = new MapSqlParameterSource().addValue("username", username).addValue("password",
            password);//from  w w  w.  j a v  a  2 s .c  om
    Map<String, Object> record = simpleJdbcCall.execute(in);
    int id = (int) record.get("id");
    String name = (String) record.get("name");
    int type = (int) record.get("type");
    String image = (String) record.get("image");
    return new AccountSession(id, name, type, image);
}

---

From source file:Implement.DAO.CommonDAOImpl.java

@Override
public AdvancedSearchForm search(String searchText, int pageNumber, int pageSize) {
    simpleJdbcCall = new SimpleJdbcCall(dataSource).withProcedureName("searchPackages");
    simpleJdbcCall.returningResultSet("rs1", PackagesViewMapper.getInstance())
            .returningResultSet("rs2", new RowMapper<String>() {

                @Override//www  .ja  va2s.co m
                public String mapRow(ResultSet rs, int i) throws SQLException {
                    return rs.getString("Keyword");
                }
            }).returningResultSet("rs3", PopularPackageMapper.getInstance())
            .returningResultSet("rs4", LocationDTOMapper.getInstance());
    SqlParameterSource in = new MapSqlParameterSource().addValue("searchText", searchText)
            .addValue("PageNumber", pageNumber).addValue("RowspPage", pageSize);
    Map<String, Object> record = simpleJdbcCall.execute(in);
    List<PackagesViewDTO> packages = (List<PackagesViewDTO>) record.get("rs1");
    List<String> keywords = (List<String>) record.get("rs2");
    List<LocationDTO> locations = (List<LocationDTO>) record.get("rs4");
    List<PopularPackageDTO> popularPackages = (List<PopularPackageDTO>) record.get("rs3");
    return new AdvancedSearchForm(packages, keywords, locations, popularPackages);
}

---

From source file:Implement.DAO.CommonDAOImpl.java

@Override
public List<PackagesViewDTO> searchWithPageNumber(String searchText, int pageNumber, int pageSize) {
    simpleJdbcCall = new SimpleJdbcCall(dataSource).withProcedureName("searchPackagesWithPageNumber");
    simpleJdbcCall.returningResultSet("rs1", PackagesViewMapper.getInstance());
    SqlParameterSource in = new MapSqlParameterSource().addValue("searchText", searchText)
            .addValue("PageNumber", pageNumber).addValue("RowspPage", pageSize);
    Map<String, Object> record = simpleJdbcCall.execute(in);
    return (List<PackagesViewDTO>) record.get("rs1");
}

---

• «
• 1
• 2
• 3
• »