Example usage for org.springframework.jdbc.core.namedparam MapSqlParameterSource MapSqlParameterSource

List of usage examples for org.springframework.jdbc.core.namedparam MapSqlParameterSource MapSqlParameterSource

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.namedparam.*
  5. MapSqlParameterSource
  6. MapSqlParameterSource

Introduction

In this page you can find the example usage for org.springframework.jdbc.core.namedparam MapSqlParameterSource MapSqlParameterSource.

Prototype

public MapSqlParameterSource()

Source Link

Document

Create an empty MapSqlParameterSource, with values to be added via addValue .

Usage

From source file:com.eu.evaluation.server.dao.eva.history.ResultDAO.java

public PageData<Result> findUnPassed(EvaluateVersion ev, AccessSystem system, int pageNo, int pageSize) {
    String jpql = "select r from Result r " + "where r.evaluateVersion.id = :evid "
            + "and r.position = :position " + "and r.status =:status "
            + "order by r.instanceType , r.instanceId , r.itemHistory.evaluateTypeEnum";
    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("evid", ev.getId());
    params.addValue("position", system.getCode());
    params.addValue("status", Result.STATUS_FAILURE);
    return this.query(jpql, params, pageNo, pageSize);
}

From source file:com.mesut.daopattern.OffersDAO.java

public Offer findById(int id) {
    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("id", id);
    return jdbc.queryForObject("select * from offers where id= :id", params, new RowMapper<Offer>() {

        public Offer mapRow(ResultSet rs, int i) throws SQLException {
            Offer offer = new Offer();
            offer.setId(rs.getInt("id"));
            offer.setName(rs.getString("name"));
            offer.setEmail(rs.getString("email"));
            offer.setText(rs.getString("text"));
            return offer;
        }//from   ww w .  j  av  a 2  s  . c  o m
    });
}

From source file:org.springmodules.samples.cache.guava.repository.jdbc.JdbcPostRepository.java

@Override
public void create(Post post) {
    Number id = insertPost//from w  w  w  .j av a 2s.c  om
            .executeAndReturnKey(new MapSqlParameterSource().addValue("user_name", post.getUserName())
                    .addValue("submit_date", post.getSubmitDate()).addValue("content", post.getContent()));

    post.setId(id.intValue());
}

From source file:org.inbio.ait.dao.sys.impl.SystemUserDAOImpl.java

@Override
public void updateUser(SystemUser user) {
    String sqlStatement = null;/*from w w  w . j  a v a  2  s .co  m*/
    MapSqlParameterSource args = null;

    try {
        sqlStatement = "UPDATE ait.users " + "SET fullname = :fullname " + ", password = :password "
                + ", enabled = :enabled " + ", roles = :roles " + " WHERE username = :username ";

        args = new MapSqlParameterSource();
        args.addValue("username", user.getUsername());
        args.addValue("fullname", user.getFullname());
        args.addValue("password", user.getPassword());
        args.addValue("enabled", user.isEnabled());
        args.addValue("roles", user.getRoles());

        getSimpleJdbcTemplate().update(sqlStatement, args);

    } catch (Exception e) {
        e.printStackTrace();
    }
}

From source file:com.xinferin.dao.DAOLicenceImpl.java

@Override
public String checkRevoke(int licenceId) {
    String sql = "SELECT can_revoke FROM xlicenser.licence WHERE id = :id";

    MapSqlParameterSource args = new MapSqlParameterSource();
    args = new MapSqlParameterSource();
    args.addValue("id", licenceId);
    int can_revoke = jdbcTemplate.queryForObject(sql, args, Integer.class);

    if (can_revoke == 1) {
        return "REVOKE";
    } else {/*from w w w  .ja  v a 2 s.c  o  m*/
        return "OK";
    }
}

From source file:tds.assessment.repositories.impl.ItemGroupQueryRepositoryImplIntegrationTests.java

@Before
public void setUp() {
    itemGroupQueryRepository = new ItemGroupQueryRepositoryImpl(jdbcTemplate);

    String insertSQL = "INSERT INTO tbladminstimulus (_fk_stimulus, _fk_adminsubject, numitemsrequired, maxitems, groupid) \n"
            + "VALUES ('200-1026', '(SBAC)SBAC-OP-ADAPTIVE-G5E-ELA-5-Spring-2015-2016', -1, 2, 'G-200-1026-0')";

    jdbcTemplate.update(insertSQL, new MapSqlParameterSource());
}

From source file:com.ignite.dao.ClientDao.java

@PreAuthorize("hasRole('ROLE_TELLER')")
public void saveClient(Client client) {
    logger.info("Saving client: " + client.getLastname());
    getSimpleJdbcTemplate().update(/*  w  ww .j  ava2s  . c o m*/
            "insert into users (firstname,lastname,username,password,pid) values (:firstname, :lastname, :username, :password, :pid )",
            new MapSqlParameterSource().addValue("firstname", client.getFirstname())
                    .addValue("lastname", client.getLastname()).addValue("username", client.getLogin())
                    .addValue("password", client.getPassword()).addValue("pid", UUID.randomUUID().toString()));

    getSimpleJdbcTemplate().update("insert into user_roles (username,ROLE) values (:username, :role)",
            new MapSqlParameterSource().addValue("username", client.getLogin()).addValue("role",
                    "ROLE_CLIENT"));
}

From source file:ru.org.linux.user.UserTagDao.java

/**
 *    ./*from www. j  av a 2 s.c om*/
 *
 * @param userId       ?
 * @param tagId        
 * @param isFavorite    (true)   (false)
 */
public void addTag(int userId, int tagId, boolean isFavorite) {
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("user_id", userId);
    parameters.addValue("tag_id", tagId);
    parameters.addValue("is_favorite", isFavorite);

    try {
        jdbcTemplate.update(
                "INSERT INTO user_tags (user_id, tag_id, is_favorite) VALUES(:user_id, :tag_id, :is_favorite)",
                parameters);
    } catch (DuplicateKeyException ex) {
        logger.debug("Tag already added to favs", ex);
    }
}

From source file:com.eu.evaluation.server.dao.dictionary.FieldDictionaryDAO.java

public FieldDictionary findByObjectNameAndProperty(String objectDisplayname, String propertyDisplayname) {
    String jpql = "select t from FieldDictionary t where t.objectDictionary.displayname = :displayname and t.displayname = :property and t.valid = :valid";
    MapSqlParameterSource params = new MapSqlParameterSource();
    params.addValue("displayname", objectDisplayname);
    params.addValue("property", propertyDisplayname);
    params.addValue("valid", true);
    List<FieldDictionary> result = this.query(jpql, params);
    if (result.isEmpty()) {
        return null;
    } else if (result.size() == 1) {
        return result.get(0);
    } else {//from  w w  w.j  ava2  s  . co m
        throw new RuntimeException("? " + objectDisplayname
                + "  " + propertyDisplayname + " ?");
    }
}

From source file:org.sakuli.services.forwarder.database.dao.impl.DaoTestCaseImpl.java

@Override
public void saveTestCaseResult(final TestCase testCase) {
    LOGGER.info("Save results for test case \"" + testCase.getId() + "\"");

    //create a map for the sql parameters
    MapSqlParameterSource tcParameters = new MapSqlParameterSource();
    tcParameters.addValue("sakuli_suites_id", testSuite.getDbPrimaryKey());
    tcParameters.addValue("caseID", testCase.getId());
    tcParameters.addValue("result", testCase.getState().getErrorCode());
    tcParameters.addValue("result_desc", testCase.getState());
    tcParameters.addValue("name", testCase.getName());
    tcParameters.addValue("guid", testSuite.getGuid());
    tcParameters.addValue("start", testCase.getStartDateAsUnixTimestamp());
    tcParameters.addValue("stop", testCase.getStopDateAsUnixTimestamp());
    int warningTime = testCase.getWarningTime();
    tcParameters.addValue("warning", (warningTime != 0) ? warningTime : null);
    int criticalTime = testCase.getCriticalTime();
    tcParameters.addValue("critical", (criticalTime != 0) ? criticalTime : null);
    tcParameters.addValue("browser", testSuite.getBrowserInfo());
    tcParameters.addValue("lastpage", testCase.getLastURL());

    //try to save the screenshot
    tcParameters.addValue("screenshot", getScreenshotAsSqlLobValue(testCase), Types.BLOB);
    tcParameters.addValue("duration", testCase.getDuration());
    tcParameters.addValue("msg", testCase.getExceptionMessages(true));

    //generate the sql-statement
    SimpleJdbcInsert insertTCResults = new SimpleJdbcInsert(getDataSource()).withTableName("sakuli_cases")
            .usingGeneratedKeyColumns("id");

    LOGGER.debug("write the following values to 'sakuli_cases': " + tcParameters.getValues()
            + " => now execute ....");

    int dbPrimaryKey = insertTCResults.executeAndReturnKey(tcParameters).intValue();

    LOGGER.info("test case '" + testCase.getId() + "' has been written to 'sahi_cases' with  primaryKey="
            + dbPrimaryKey);/*from w  ww . j a v a  2  s .co  m*/
    testCase.setDbPrimaryKey(dbPrimaryKey);
}