List of usage examples for org.springframework.jdbc.core.namedparam MapSqlParameterSource MapSqlParameterSource
public MapSqlParameterSource(String paramName, @Nullable Object value)
From source file:com.mir00r.jdbc_dao.EmployeeDao.java
public int SaveEmployeeByNPS(Employee employee) { String sql = " insert into employee(name, salary) " + "values( :name, :salary ) "; SqlParameterSource nameParameterSource = new MapSqlParameterSource("name", employee.getName()) .addValue("salary", employee.getSalary()); return namedParameterJdbcTemplate.update(sql, nameParameterSource); }
From source file:airport.database.dispatcher.airplane.RunawayDaoImpl.java
@Override public boolean checkAvailablerRunaway(int runawayId) { MapSqlParameterSource parameterSource = new MapSqlParameterSource(SQL_PARAMETER_RUNAWAY_ID, runawayId); boolean checkAvailableResult = jdbcTemplate.queryForObject(SQL_QUERY_CHECK_AVAILABLE, parameterSource, Boolean.class); if (LOG.isInfoEnabled()) { LOG.info("check available runawat. RunawayId : " + runawayId + ". Result : " + checkAvailableResult); }/*from www . j ava 2 s . c o m*/ return checkAvailableResult; }
From source file:tds.assessment.repositories.impl.ItemQueryRepositoryImpl.java
@Override public List<Item> findItemsForAssessment(final String assessmentKey) { SqlParameterSource parameters = new MapSqlParameterSource("key", assessmentKey); final String itemsSQL = "SELECT \n" + " item._key AS id,\n" + " item.itemtype,\n" + " item.scorepoint AS maxScore, \n" + " item.itemid AS clientId, \n" + " item._efk_item AS itemKey, \n" + " item._efk_itembank AS bankKey, \n" + " adminItems._fk_adminsubject AS segmentKey,\n" + " formItem._fk_testform AS formKey,\n" + " formItem.formposition AS formPosition, \n" + " strands.name AS contentLevel, \n" + " adminItems.groupid,\n" + " adminItems.groupkey,\n" + " adminItems.blockid, \n" + " adminItems.itemposition AS position,\n" + " adminItems.isfieldtest,\n" + " adminItems.isrequired, \n" + " adminItems.strandname, \n" + " adminItems.responseMimeType, \n" + " adminItems.notForScoring, \n" + " adminItems.isActive, \n" + " CONCAT(client.homepath, bank.homepath, bank.itempath, item.filepath, item.filename) AS itemFilePath, \n" + " CONCAT(client.homepath, bank.homepath, bank.stimulipath, stimulus.filepath, stimulus.filename) AS stimulusFilePath, \n" + " upper(adminItems.IRT_Model) AS irtModel, \n" + " adminItems.IRT_b AS irtB, \n" + " adminItems.IRT_a AS irtA, \n" + " adminItems.IRT_c AS irtC, \n" + " adminItems.bVector, \n" + " adminItems.clString, \n" + " adminItems.isprintable \n" + "FROM \n" + " itembank.tblsetofadminitems AS adminItems \n" + "JOIN \n" + " itembank.tblitem item \n" + " ON item._key = adminItems._fk_item \n" + "LEFT JOIN \n" + " itembank.testformitem formItem \n" + " ON formItem._fk_item = item._key \n" + " AND formItem._fk_adminsubject = adminItems._fk_adminsubject \n" + "JOIN \n" + " itembank.tblsetofadminsubjects segments \n" + " ON segments._key = adminItems._fk_adminsubject \n" + "JOIN \n" + " itembank.tblclient client \n" + " ON client.name = segments._fk_testadmin \n" + "JOIN \n" + " itembank.tblitembank bank \n" + " ON bank._fk_client = client._key \n" + "LEFT JOIN \n" + " tblsetofitemstimuli itemStimuli \n" + " ON itemStimuli._fk_adminsubject = segments._key \n" + " AND itemStimuli._fk_item = item._key \n" + "LEFT JOIN \n" + " itembank.tblstimulus stimulus \n" + " ON stimulus._key = itemStimuli._fk_stimulus \n" + " AND stimulus._efk_itembank = bank._efk_itembank \n" + "LEFT JOIN \n" + " itembank.tblstrand strands \n" + " ON strands._key = adminItems.strandname \n" + "WHERE \n" + " (segments.virtualtest = :key \n" + " OR segments._key = :key) \n" + "AND \n" + " adminItems.isactive = 1 \n" + "AND \n" + " (formItem.isactive = 1 OR formItem.isactive IS NULL)"; return jdbcTemplate.query(itemsSQL, parameters, (rs, rowNum) -> { Item item = new Item(rs.getString("id")); item.setSegmentKey(rs.getString("segmentKey")); item.setItemType(rs.getString("itemtype")); item.setGroupId(rs.getString("groupid")); item.setGroupKey(rs.getString("groupkey")); item.setBlockId((rs.getString("blockid"))); item.setPosition(rs.getInt("position")); item.setFormPosition(rs.getInt("formPosition")); item.setFieldTest(rs.getBoolean("isfieldtest")); item.setRequired(rs.getBoolean("isrequired")); item.setStrand(rs.getString("strandname")); item.setFormKey(rs.getString("formKey")); item.setItemFilePath(rs.getString("itemFilePath")); item.setStimulusFilePath(rs.getString("stimulusFilePath")); item.setPrintable(rs.getBoolean("isprintable")); item.setMimeType(rs.getString("responseMimeType")); item.setMaxScore(rs.getInt("maxScore")); item.setContentLevel(rs.getString("contentLevel")); item.setClientId(rs.getString("clientId")); item.setNotForScoring(rs.getBoolean("notForScoring")); item.setbVector(rs.getString("bVector")); item.setItemResponseTheoryModel(rs.getString("irtModel")); item.setItemResponseTheoryAParameter((Float) rs.getObject("irtA")); item.setItemResponseTheoryBParameter(rs.getString("irtB")); item.setItemResponseTheoryCParameter((Float) rs.getObject("irtC")); item.setClaims(rs.getString("clString")); item.setItemKey(rs.getLong("itemKey")); item.setBankKey(rs.getLong("bankKey")); item.setActive(rs.getBoolean("isActive")); return item; });/*from w w w. j av a2s . co m*/ }
From source file:org.string_db.jdbc.SpeciesRepositoryJdbc.java
@Override public String loadSpeciesName(Integer speciesId) { return namedParameterJdbcTemplate.queryForObject( "SELECT official_name from items.species where species_id = :species_id ;", new MapSqlParameterSource("species_id", speciesId), String.class); }
From source file:tomekkup.helenos.dao.AccountDao.java
@Override public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException { UserDetails userDetails = null;// w ww .ja va2 s .c om try { userDetails = jdbcTemplate.queryForObject(queriesProperties.getProperty("user.get.by.username"), new MapSqlParameterSource("username", username), new UserMapper()); } catch (EmptyResultDataAccessException e) { throw new UsernameNotFoundException(String.format("user '%s' not found", username)); } return userDetails; }
From source file:ar.com.springbasic.dao.AdminDaoImpl.java
@Override public Admin findById(int id) { return jdbcTemplate.queryForObject("Select * from admin where idAd=:idAd", new MapSqlParameterSource("idAd", id), new AdminRowMapper()); }
From source file:tds.assessment.repositories.impl.AccommodationsQueryRepositoryImpl.java
@Override public List<Accommodation> findAssessmentAccommodationsById(final String clientName, final String assessmentId) { SqlParameterSource parameters = new MapSqlParameterSource("assessmentId", assessmentId) .addValue("clientName", clientName); String SQL = "(\n" + "SELECT\n" + " DISTINCT 0 AS segment, \n" + " MODE.testkey AS segmentKey, \n" + " MODE.testid as context, \n" + " TType.DisableOnGuestSession AS disableOnGuestSession, \n" + " TType.SortOrder AS toolTypeSortOrder, \n" + " TT.SortOrder AS toolValueSortOrder, \n" + " TType.TestMode AS typeMode,\n" + " TT.TestMode AS toolMode, \n" + " TT.Type AS accType, \n" + " TT.Value AS accValue, \n" + " TT.Code AS accCode, \n" + " TT.IsDefault AS isDefault, \n" + " TT.AllowCombine AS allowCombine, \n" + " TType.IsFunctional AS isFunctional, \n" + " TType.AllowChange AS allowChange, \n" + " TType.IsSelectable AS isSelectable, \n" + " TType.IsVisible AS isVisible, \n" + " TType.studentControl AS studentControl,\n" + " TType.DependsOnToolType AS dependsOnToolType, \n" + " (SELECT count(1) FROM configs.client_testtool TOOL WHERE TOOL.ContextType = 'TEST' AND TOOL.Context = :assessmentId AND TOOL.clientname = :clientName AND TOOL.Type = TT.Type) AS ValCount, \n" + " TType.IsEntryControl AS isEntryControl\n" + "FROM \n" + " configs.client_testmode MODE \n" + "JOIN configs.client_testtooltype TType ON \n" + " MODE.clientname = TType.clientname\n" + "JOIN configs.client_testtool TT \n" + " ON TType.context = TT.context\n" + " AND TType.clientname = TT.clientname\n" + " AND TType.contexttype = TT.contexttype\n" + " AND TType.toolname = TT.type\n" + "WHERE\n" + " TType.contexttype = 'TEST'\n" + " AND TType.context = :assessmentId\n" + " AND TType.clientname = :clientName\n" + ") UNION ALL (\n" + "SELECT\n" + " DISTINCT SegmentPosition AS segment, \n" + " SEG.modekey AS segmentKey,\n" + " MODE.testid as context, \n" + " TType.DisableOnGuestSession AS disableOnGuestSession, \n" + " TType.SortOrder AS toolTypeSortOrder, \n" + " TT.SortOrder AS toolValueSortOrder, \n" + " TType.TestMode AS typeMode, \n" + " TT.TestMode AS toolMode, \n" + " TT.Type AS accType, \n" + " TT.Value AS accValue, \n" + " TT.Code AS accCode, \n" + " TT.IsDefault AS isDefault, \n" + " TT.AllowCombine AS allowCombine, \n" + " TType.IsFunctional AS isFunctional, \n" + " TType.AllowChange AS allowChange, \n" + " TType.IsSelectable AS isSelectable, \n" + " TType.IsVisible AS isVisible, \n" + " TType.studentControl AS studentControl, \n" + " NULL AS dependsOnToolType, \n" + " (SELECT count(1) FROM configs.client_testtool TOOL WHERE TOOL.ContextType = 'TEST' AND TOOL.Context = :assessmentId AND TOOL.clientname = :clientName AND TOOL.Type = TT.Type) AS ValCount, \n" + " IsEntryControl AS isEntryControl \n" + "FROM \n" + " configs.client_testmode MODE \n" + "JOIN configs.client_testtooltype TType ON \n" + " MODE.clientname = TType.clientname\n" + "JOIN configs.client_testtool TT \n" + " ON TType.context = TT.context\n" + " AND TType.clientname = TT.clientname\n" + " AND TType.contexttype = TT.contexttype\n" + " AND TType.toolname = TT.type\n" + "JOIN \n" + " configs.client_segmentproperties SEG\n" + " ON TType.context = SEG.segmentid\n" + "WHERE\n" + " SEG.parenttest = :assessmentId\n" + " AND TType.contexttype = 'SEGMENT'\n" + " AND TType.clientname = :clientName\n" + ") UNION ALL (\n" + "SELECT \n" + " DISTINCT 0 AS segment,\n" + " MODE.testkey AS segmentKey, \n" + " MODE.testid as context, \n" + " TType.DisableOnGuestSession AS disableOnGuestSession, \n" + " TType.SortOrder AS toolTypeSortOrder, \n" + " TT.SortOrder AS toolValueSortOrder, \n" + " TType.TestMode AS typeMode, \n" + " TT.TestMode AS toolMode, \n" + " TT.Type AS accType, \n" + " TT.Value AS accValue, \n" + " TT.Code AS accCode, \n" + " TT.IsDefault AS isDefault, \n" + " TT.AllowCombine AS allowCombine, \n" + " TType.IsFunctional AS isFunctional, \n" + " TType.AllowChange AS allowChange, \n" + " TType.IsSelectable AS isSelectable, \n" + " TType.IsVisible AS isVisible, \n" + " TType.studentControl AS studentControl, \n" + " TType.DependsOnToolType AS dependsOnToolType, \n" + " (SELECT count(1) FROM configs.client_testtool TOOL WHERE TOOL.ContextType = 'TEST' AND TOOL.Context = '*' AND TOOL.clientname = :clientName AND TOOL.Type = TT.Type) AS ValCount, \n" + " TType.IsEntryControl AS isEntryControl\n" + "FROM \n" + " configs.client_testmode MODE \n" + "JOIN configs.client_testtooltype TType ON \n" + " MODE.clientname = TType.clientname\n" + "JOIN configs.client_testtool TT \n" + " ON TType.context = TT.context\n" + " AND TType.clientname = TT.clientname\n" + " AND TType.contexttype = TT.contexttype\n" + " AND TType.toolname = TT.type\n" + "WHERE\n" + " TType.contexttype = 'TEST'\n" + " AND TType.context = '*'\n" + " AND TType.clientname = :clientName\n" + " AND NOT EXISTS \n" + " (\n" + " SELECT \n" + " toolname \n" + " FROM configs.client_testtooltype Tool \n" + " WHERE Tool.ContextType = 'TEST' \n" + " AND Tool.Context = :assessmentId \n" + " AND Tool.Toolname = TType.Toolname \n" + " AND Tool.Clientname = :clientName\n" + " )\n" + ")"; return jdbcTemplate.query(SQL, parameters, accommodationRowMapper); }
From source file:org.string_db.DbFacade.java
/** * evidence.sets_items table//w w w. ja v a 2 s. c om * * @param spcId */ public Map<Integer, Set<String>> loadProteinsSets(Integer spcId) { log.info("loading proteins sets"); Map<Integer, Set<String>> map = queryProcessor.selectTwoColumns("item_id", "set_id", "evidence.sets_items", TwoColumnRowMapper.<Integer, String>multiValMapper(), "item_id > 0 and species_id = :species_id; ", new MapSqlParameterSource("species_id", spcId)); log.info(map.size() + " proteins.sets records read"); return map; }
From source file:com.exploringspatial.dao.impl.CodeCategoryDaoImpl.java
@Override public void insert(final CodeCategory instance) { final String sql = "INSERT INTO CODE_CATEGORY (CATEGORY) VALUES (:category)"; final KeyHolder keyHolder = new GeneratedKeyHolder(); final MapSqlParameterSource params = new MapSqlParameterSource("category", instance.getCategory()); jdbcTemplate.update(sql, params, keyHolder); instance.setCodeCategoryPk(keyHolder.getKey().longValue()); }
From source file:airport.database.services.chat.ChatDaoImpl.java
@Override public List<Message> getMessageMiss(int number) { List<Message> resultMessages; SqlParameterSource parameterUser = new MapSqlParameterSource(PARAMETER_SQL_QUERY_NUMBER_MESSAGE, number); try {//from w w w. j a va 2s. co m resultMessages = jdbcTemplate.query(SQL_QUERY_GET_MESSAGES_MISS, parameterUser, new MessageMapper()); } catch (EmptyResultDataAccessException e) { if (LOG.isInfoEnabled()) { LOG.info("new messages aren't present. Number message : " + number); } return new ArrayList<>(); } if (LOG.isInfoEnabled()) { LOG.info("get messages miss. Number message : " + number + ". Result : " + resultMessages); } return resultMessages; }