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

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

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

Introduction

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

Prototype

public MapSqlParameterSource addValue(String paramName, @Nullable Object value)

Source Link

Document

Add a parameter to this parameter source.

Usage

From source file:com.joliciel.jochre.security.SecurityDaoJdbc.java

@Override
public void saveUserInternal(UserInternal user) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    MapSqlParameterSource paramSource = new MapSqlParameterSource();

    paramSource.addValue("user_username", user.getUsername());
    paramSource.addValue("user_password", user.getPassword());
    paramSource.addValue("user_first_name", user.getFirstName());
    paramSource.addValue("user_last_name", user.getLastName());
    paramSource.addValue("user_role", user.getRole().getId());
    paramSource.addValue("user_failed_logins", user.getFailedLoginCount());
    paramSource.addValue("user_logins", user.getLoginCount());
    String sql = null;//from   w  ww. j a va  2  s  .c  o  m

    if (user.isNew()) {
        sql = "SELECT nextval('ocr_user_id_seq')";
        LOG.info(sql);
        int userId = jt.queryForInt(sql, paramSource);
        paramSource.addValue("user_id", userId);

        sql = "INSERT INTO ocr_user (user_id, user_username, user_password"
                + ", user_first_name, user_last_name, user_role, user_failed_logins, user_logins) "
                + "VALUES (:user_id, :user_username, :user_password"
                + ", :user_first_name, :user_last_name, :user_role, :user_failed_logins, :user_logins)";

        LOG.info(sql);
        logParameters(paramSource);
        jt.update(sql, paramSource);

        user.setId(userId);
    } else {
        paramSource.addValue("user_id", user.getId());

        sql = "UPDATE ocr_user" + " SET user_username = :user_username" + ", user_password = :user_password"
                + ", user_first_name = :user_first_name" + ", user_last_name = :user_last_name"
                + ", user_role = :user_role" + ", user_failed_logins = :user_failed_logins"
                + ", user_logins = :user_logins" + " WHERE user_id = :user_id";

        LOG.info(sql);
        logParameters(paramSource);
        jt.update(sql, paramSource);
    }

}

From source file:org.inbio.modeling.core.dao.impl.SystemUserDAOImpl.java

@Override
public void deleteUserByUsername(String userName) {
    String sqlStatement = null;//  w w w  .j a  v a2s  .com
    MapSqlParameterSource args = null;

    try {
        sqlStatement = "DELETE FROM " + this.table + " WHERE username = :username ";

        args = new MapSqlParameterSource();
        args.addValue("username", userName);

        getSimpleJdbcTemplate().update(sqlStatement, args);

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

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

public EvaluateItem findTheMatching(ObjectDictionary od, FieldDictionary fd, Map<String, Object> otherMap) {
    String jpql = "select t from UpAndDownEvlauateItem t where t.objectDictionary.id = :odID";
    MapSqlParameterSource params = new MapSqlParameterSource("odID", od.getId());

    String upEntityID = (String) otherMap.get(UpAndDownEvlauateItem.MAP_KEY_UP_ENTITY);
    if (upEntityID != null) {
        jpql += " and t.upEntity.id = :upID";
        params.addValue("upID", upEntityID);
    }// w ww. j av a  2  s  . c  om

    String downEntityID = (String) otherMap.get(UpAndDownEvlauateItem.MAP_KEY_DOWN_ENTITY);
    if (downEntityID != null) {
        jpql += " and t.downEntity.id = :downID";
        params.addValue("downID", downEntityID);
    }

    List<UpAndDownEvlauateItem> result = this.query(jpql, params);
    if (result.isEmpty()) {
        return null;
    } else if (result.size() == 1) {
        return result.get(0);
    } else {
        ObjectDictionary upEntity = getObjectDictionary(upEntityID);
        ObjectDictionary downEntity = getObjectDictionary(downEntityID);
        throw new RuntimeException("" + fd.getObjectDictionary().getDisplayname()
                + " ?="
                + (upEntity == null ? "null" : upEntity.getDisplayname()) + " ; ="
                + (downEntity == null ? "null" : downEntity.getDisplayname()));
    }
}

From source file:org.inbio.modeling.core.dao.impl.LayerDAOImpl.java

@Override
public void deleteById(Long id) {
    String deleteStatement = null;
    MapSqlParameterSource args = null;

    deleteStatement = "DELETE FROM " + this.table + " WHERE id = :identification ";

    args = new MapSqlParameterSource();
    args.addValue("identification", id);

    getSimpleJdbcTemplate().update(deleteStatement, args);

}

From source file:com.lixiaocong.social.MyJdbcConnection.java

public MultiValueMap<String, Connection<?>> findConnectionsToUsers(
        MultiValueMap<String, String> providerUsers) {
    if (providerUsers == null || providerUsers.isEmpty()) {
        throw new IllegalArgumentException("Unable to execute find: no providerUsers provided");
    }//from  ww  w  .j a v a2  s. c  o  m
    StringBuilder providerUsersCriteriaSql = new StringBuilder();
    MapSqlParameterSource parameters = new MapSqlParameterSource();
    parameters.addValue("userId", userId);
    for (Iterator<Entry<String, List<String>>> it = providerUsers.entrySet().iterator(); it.hasNext();) {
        Entry<String, List<String>> entry = it.next();
        String providerId = entry.getKey();
        providerUsersCriteriaSql.append("providerId = :providerId_").append(providerId)
                .append(" and providerUserId in (:providerUserIds_").append(providerId).append(")");
        parameters.addValue("providerId_" + providerId, providerId);
        parameters.addValue("providerUserIds_" + providerId, entry.getValue());
        if (it.hasNext()) {
            providerUsersCriteriaSql.append(" or ");
        }
    }
    List<Connection<?>> resultList = new NamedParameterJdbcTemplate(jdbcTemplate)
            .query(selectFromUserConnection() + " where userId = :userId and " + providerUsersCriteriaSql
                    + " order by providerId, rank", parameters, connectionMapper);
    MultiValueMap<String, Connection<?>> connectionsForUsers = new LinkedMultiValueMap<String, Connection<?>>();
    for (Connection<?> connection : resultList) {
        String providerId = connection.getKey().getProviderId();
        List<String> userIds = providerUsers.get(providerId);
        List<Connection<?>> connections = connectionsForUsers.get(providerId);
        if (connections == null) {
            connections = new ArrayList<Connection<?>>(userIds.size());
            for (int i = 0; i < userIds.size(); i++) {
                connections.add(null);
            }
            connectionsForUsers.put(providerId, connections);
        }
        String providerUserId = connection.getKey().getProviderUserId();
        int connectionIndex = userIds.indexOf(providerUserId);
        connections.set(connectionIndex, connection);
    }
    return connectionsForUsers;
}

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

@Test
public void testCreateSqlSetStringForNamedParameter() throws Throwable {
    testling = new Dao(dataSource) {
    };//from w w  w .j a  v a 2s. c om
    MapSqlParameterSource source = new MapSqlParameterSource().addValue("testling2", "value")
            .addValue("testling", "value");
    Assert.assertEquals("SET testling2=:testling2, testling=:testling ",
            testling.createSqlSetStringForNamedParameter(source.getValues()));
    source.addValue("nullable", null);
    Assert.assertEquals("SET testling2=:testling2, testling=:testling ",
            testling.createSqlSetStringForNamedParameter(source.getValues()));

}

From source file:org.aksw.gerbil.database.ExperimentDAOImpl.java

@Override
public int createTask(String annotatorName, String datasetName, String experimentType, String matching,
        String experimentId) {//from w ww  . j  a  v  a 2  s  .  c o  m
    MapSqlParameterSource params = createTaskParameters(annotatorName, datasetName, experimentType, matching);
    params.addValue("state", ExperimentDAO.TASK_STARTED_BUT_NOT_FINISHED_YET);
    java.util.Date today = new java.util.Date();
    params.addValue("lastChanged", new java.sql.Timestamp(today.getTime()));
    KeyHolder keyHolder = new GeneratedKeyHolder();
    this.template.update(INSERT_TASK, params, keyHolder);
    Integer generatedKey = (Integer) keyHolder.getKey();
    connectToExperiment(experimentId, generatedKey);
    return generatedKey;
}

From source file:org.aksw.gerbil.database.ExperimentDAOImpl.java

@Deprecated
@Override//  ww  w  .jav a2 s .  c om
protected ExperimentTaskResult getLatestExperimentTaskResult(String experimentType, String matching,
        String annotatorName, String datasetName) {
    MapSqlParameterSource params = createTaskParameters(annotatorName, datasetName, experimentType, matching);
    params.addValue("unfinishedState", TASK_STARTED_BUT_NOT_FINISHED_YET);
    List<ExperimentTaskResult> result = this.template.query(GET_LATEST_EXPERIMENT_TASK_RESULT, params,
            new ExperimentTaskResultRowMapper());
    if (result.size() > 0) {
        return result.get(0);
    } else {
        return null;
    }
}

From source file:org.jasig.schedassist.impl.statistics.SpringJDBCStatisticsDaoImpl.java

@Override
public List<AppointmentEvent> getEvents(IScheduleOwner owner, Date startTime, Date endTime,
        List<EventType> eventTypes) {
    MapSqlParameterSource parameterSource = new MapSqlParameterSource();
    parameterSource.addValue("ownerId", owner.getId());
    parameterSource.addValue("startTime", startTime);
    parameterSource.addValue("endTime", endTime);
    parameterSource.addValue("eventTypes", eventTypes);
    List<AppointmentEvent> results = this.simpleJdbcTemplate.query(
            "select event_id,owner_id,visitor_id,event_type,event_timestamp,event_start from event_statistics where owner_id = :ownerId and event_timestamp >= :startTime and event_timestamp <= :endTime and event_type in (:eventTypes)",
            new AppointmentEventRowMapper(ownerDao), parameterSource);
    return results;
}

From source file:ru.org.linux.tracker.TrackerDao.java

public List<TrackerItem> getTrackAll(TrackerFilterEnum filter, User currentUser, Timestamp interval, int topics,
        int offset, final int messagesInPage) {

    MapSqlParameterSource parameter = new MapSqlParameterSource();
    parameter.addValue("interval", interval);
    parameter.addValue("topics", topics);
    parameter.addValue("offset", offset);

    String partIgnored;// w  w  w.  j  av  a2 s . c  om

    if (currentUser != null) {
        partIgnored = queryPartIgnored + queryPartTagIgnored;
        parameter.addValue("userid", currentUser.getId());
    } else {
        partIgnored = "";
    }

    String partFilter;
    String partWiki = queryPartWiki;
    switch (filter) {
    case ALL:
        partFilter = "";
        break;
    case NOTALKS:
        partFilter = queryPartNoTalks;
        break;
    case TECH:
        partFilter = queryPartTech;
        break;
    case MINE:
        if (currentUser != null) {
            partFilter = queryPartMine;
            partWiki = queryPartWikiMine;
        } else {
            partFilter = "";
        }
        break;
    default:
        partFilter = "";
    }

    boolean showUncommited = currentUser != null && (currentUser.isModerator() || currentUser.isCorrector());

    String partUncommited = showUncommited ? "" : noUncommited;

    String query;

    if (filter != TrackerFilterEnum.ZERO) {
        query = String.format(queryTrackerMain, partUncommited, partIgnored, partFilter, partUncommited,
                partIgnored, partFilter, partWiki);
    } else {
        query = String.format(queryTrackerZeroMain, partIgnored);
    }

    SqlRowSet resultSet = jdbcTemplate.queryForRowSet(query, parameter);

    List<TrackerItem> res = new ArrayList<>(topics);

    while (resultSet.next()) {
        User author;
        try {
            int author_id = resultSet.getInt("author");
            if (author_id != 0) {
                author = userDao.getUserCached(author_id);
            } else {
                author = null;
            }
        } catch (UserNotFoundException e) {
            throw new RuntimeException(e);
        }
        int msgid = resultSet.getInt("id");
        Timestamp lastmod = resultSet.getTimestamp("lastmod");
        int stat1 = resultSet.getInt("stat1");
        int groupId = resultSet.getInt("gid");
        String groupTitle = resultSet.getString("gtitle");
        String title = resultSet.getString("title");
        int cid = resultSet.getInt("cid");
        User lastCommentBy;
        try {
            int id = resultSet.getInt("last_comment_by");

            if (id != 0) {
                lastCommentBy = userDao.getUserCached(id);
            } else {
                lastCommentBy = null;
            }
        } catch (UserNotFoundException e) {
            throw new RuntimeException(e);
        }
        boolean resolved = resultSet.getBoolean("resolved");
        int section = resultSet.getInt("section");
        String groupUrlName = resultSet.getString("urlname");
        Timestamp postdate = resultSet.getTimestamp("postdate");
        boolean uncommited = resultSet.getBoolean("smod") && !resultSet.getBoolean("moderate");
        int pages = Topic.getPageCount(stat1, messagesInPage);

        ImmutableList<String> tags;

        if (msgid != 0) {
            tags = topicTagService.getMessageTagsForTitle(msgid);
        } else {
            tags = ImmutableList.of();
        }

        res.add(new TrackerItem(author, msgid, lastmod, stat1, groupId, groupTitle, title, cid, lastCommentBy,
                resolved, section, groupUrlName, postdate, uncommited, pages, tags));
    }

    return res;
}