Package org.springframework.jdbc.core.namedparam

Examples of org.springframework.jdbc.core.namedparam.MapSqlParameterSource

100
101
102
103
104
105
106
        account.setPassword(encodePasswd(pcr.getUsername(), pcr.getPassword1()));
        this.store(account);
    }

    public List<QxAccount> loadAll() {
        return jdbcTemplate.query(queriesProperties.getProperty("user.select.star"), new MapSqlParameterSource(), new UserMapper());
    }
View Full Code Here
111
112
113
114
115
116
117
    public void delete(String username) {
        if (username.toLowerCase().equals("admin")) {
            throw new IllegalArgumentException("admin account can not be removed");
        }
        jdbcTemplate.update(queriesProperties.getProperty("user.delete"), new MapSqlParameterSource("username", username));
    }
View Full Code Here
115
116
117
118
119
120
121
        }
        jdbcTemplate.update(queriesProperties.getProperty("user.delete"), new MapSqlParameterSource("username", username));
    }

    private SqlParameterSource prepareParameterSource(QxAccount user) {
        return new MapSqlParameterSource(user.toParametersMap());
    }
View Full Code Here
37
38
39
40
41
42
43
    public void setDefaultHost(String defaultHost) {
        this.defaultHost = defaultHost;
    }

    public ClusterConfiguration get(String alias) {
        return jdbcTemplate.queryForObject(queriesProperties.getProperty("clusterconfig.get.by.alias"), new MapSqlParameterSource("alias", alias), new ClusterConfigurationMapper());
    }
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
    public ClusterConfiguration get(String alias) {
        return jdbcTemplate.queryForObject(queriesProperties.getProperty("clusterconfig.get.by.alias"), new MapSqlParameterSource("alias", alias), new ClusterConfigurationMapper());
    }

    public ClusterConfiguration getActive() {
        List<ClusterConfiguration> configuration = jdbcTemplate.query(queriesProperties.getProperty("clusterconfig.select.star.wa"), new MapSqlParameterSource("active", true), new ClusterConfigurationMapper());
       
        //tutaj zrobic inaczej
        //jesli defaultConn nie jest pusty to dodaj config nadpisujac
        if (CollectionUtils.isEmpty(configuration)) {
            this.createDefaultConfiguration();
View Full Code Here
54
55
56
57
58
59
60
        return configuration.get(0);
    }

    public List<ClusterConfiguration> loadAll() {
        return jdbcTemplate.query(queriesProperties.getProperty("clusterconfig.select.star"), new MapSqlParameterSource(), new ClusterConfigurationMapper());
    }
View Full Code Here
66
67
68
69
70
71
72
    private void createDefaultConfiguration() {
        jdbcTemplate.update(queriesProperties.getProperty("clusterconfig.insert"), prepareParameterSource(new ClusterConfiguration("default", defaultHost, defaultClusterName, true)));
    }

    private SqlParameterSource prepareParameterSource(ClusterConfiguration configuration) {
        return new MapSqlParameterSource(configuration.toParametersMap());
    }
View Full Code Here
71
72
73
74
75
76
77
78
79
        return new MapSqlParameterSource(configuration.toParametersMap());
    }

    public void store(ClusterConfiguration configuration) {
        if (configuration.isActive()) {
            jdbcTemplate.update(queriesProperties.getProperty("clusterconfig.update.all.active.false"), new MapSqlParameterSource());
        }
        jdbcTemplate.update(queriesProperties.getProperty("clusterconfig.merge"), prepareParameterSource(configuration));
    }
View Full Code Here
77
78
79
80
81
82
83
        }
        jdbcTemplate.update(queriesProperties.getProperty("clusterconfig.merge"), prepareParameterSource(configuration));
    }

    public void delete(String alias) {
        jdbcTemplate.update(queriesProperties.getProperty("clusterconfig.delete"), new MapSqlParameterSource("alias", alias));
    }
View Full Code Here
302
303
304
305
306
307
308
309
   * @see
   * com.odb.core.dao.ODBDAO#getDataSourceByDataSourceID(java.lang.String)
   */
  public DataSourceInfo getDataSourceByDataSourceID(String dsID) throws SQLException {
    String sql = "SELECT * FROM ODB_DATASOURCE_INFO WHERE DATASOURCE_ID=:dataSourceID";
    SqlParameterSource param = new MapSqlParameterSource("dataSourceID", dsID);
    return jdbcTemp.query(sql, param, new DataSourceInfoResultSetExtractor());
  }
View Full Code Here
TOP

Related Classes of org.springframework.jdbc.core.namedparam.MapSqlParameterSource

  • at.compax.bbsng.dataimport.app.target.apprentice.JdbcApprenticeRepository
  • at.compax.bbsng.dataimport.app.target.company.JdbcCompanyRepository
  • at.compax.bbsng.dataimport.app.target.companyoccupationcombination.JdbcCompanyOccupationCombinationRepository
  • at.compax.bbsng.dataimport.app.target.contract.JdbcContractRepository
  • at.compax.bbsng.dataimport.app.target.district.JdbcDistrictRepository
  • at.compax.bbsng.dataimport.app.target.focalPoint.JdbcFocalPointRepository
  • at.compax.bbsng.dataimport.app.target.occupation.JdbcOccupationRepository
  • at.compax.bbsng.dataimport.app.target.occupationcombination.JdbcOccupationCombinationRepository
  • at.compax.bbsng.dataimport.app.target.office.JdbcOfficeRepository
  • at.compax.bbsng.dataimport.app.target.ruraldistrict.JdbcRuralDistrictRepository
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.