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

Introduction

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

Prototype

public NamedParameterJdbcTemplate(JdbcOperations classicJdbcTemplate) 

Source Link

Document

Create a new NamedParameterJdbcTemplate for the given classic Spring org.springframework.jdbc.core.JdbcTemplate .

Usage

From source file:com.ebay.pulsar.analytics.metricstore.db.RDMBSTest.java

@Test
public void testRDBMS2() {
    String driver2 = "com.mysql.jdbc.Driver";
    String url = "jdbc:mysql://locahost:3306/test";
    String userName = "root";
    String userPwd = "";
    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName(driver2);// ww  w .j  a va  2  s  .  c o m
    bds.setUrl(url);
    bds.setUsername(userName);
    bds.setPassword(userPwd);
    DBFactory.setDs(bds);
    List<String> result = new ArrayList<String>();
    result.add("result");
    NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(bds);
    RDBMS db = new RDBMS(bds);
    db.setDriver(driver2);
    db.setNamedParameterJdbcTemplate(namedParameterJdbcTemplate);
    db.setUrl(url);
    db.setUserName(userName);
    db.setUserPwd(userPwd);
    assertEquals(userName, db.getUserName());
    assertEquals(url, db.getUrl());
    assertEquals(userPwd, db.getUserPwd());

}

---

From source file:org.jasig.ssp.util.importer.job.staging.SqlServerStagingTableWriter.java

@Override
public void write(final List<? extends RawItem> items) {

    NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
    String fileName = items.get(0).getResource().getFilename();
    final String[] tableName = fileName.split("\\.");

    Integer batchStart = (Integer) (stepExecution.getExecutionContext().get("batchStart") == null ? null
            : stepExecution.getExecutionContext().get("batchStart"));
    Integer batchStop = (Integer) (stepExecution.getExecutionContext().get("batchStop") == null ? null
            : stepExecution.getExecutionContext().get("batchStop"));
    Object currentEntity = stepExecution.getExecutionContext().get("currentEntity");

    if (currentEntity == null || !currentEntity.equals(tableName[0])) {
        batchStart = 0;/*from w  ww.  j a  v  a2  s  .c  o m*/
        batchStop = items.size() - 1;
        currentEntity = tableName[0];
        stepExecution.getExecutionContext().put("currentEntity", currentEntity);
        stepExecution.getExecutionContext().put("batchStart", batchStart);
        stepExecution.getExecutionContext().put("batchStop", batchStop);
    } else {
        batchStart = batchStop + 1;
        batchStop = (Integer) batchStart + items.size() - 1;
        stepExecution.getExecutionContext().put("batchStart", batchStart);
        stepExecution.getExecutionContext().put("batchStop", batchStop);
    }

    RawItem firstItem = items.get(0);
    Resource firstItemResource = firstItem.getResource();

    if (currentResource == null || !(this.currentResource.equals(firstItemResource))) {
        this.orderedHeaders = writeHeader(firstItem);
        this.currentResource = firstItemResource;
    }

    StringBuilder insertSql = new StringBuilder();
    insertSql.append("INSERT INTO stg_" + tableName[0] + " (batch_id,");
    StringBuilder valuesSqlBuilder = new StringBuilder();
    valuesSqlBuilder.append(" VALUES (?,");
    for (String header : this.orderedHeaders) {
        insertSql.append(header).append(",");
        valuesSqlBuilder.append("?").append(",");
    }
    insertSql.setLength(insertSql.length() - 1); // trim comma
    valuesSqlBuilder.setLength(valuesSqlBuilder.length() - 1); // trim comma
    insertSql.append(")");
    valuesSqlBuilder.append(");");
    insertSql.append(valuesSqlBuilder);

    final AtomicInteger batchStartRef = new AtomicInteger(batchStart);
    final String sql = insertSql.toString();
    jdbcTemplate.getJdbcOperations().execute(sql, new PreparedStatementCallback() {
        @Override
        public Object doInPreparedStatement(PreparedStatement ps) throws SQLException, DataAccessException {
            for (RawItem item : items) {
                final List<Object> paramsForLog = new ArrayList(orderedHeaders.length);
                int counter = 1;
                paramsForLog.add(batchStartRef.get());
                StatementCreatorUtils.setParameterValue(ps, counter, SqlTypeValue.TYPE_UNKNOWN,
                        batchStartRef.getAndIncrement());
                counter++;
                for (String header : orderedHeaders) {
                    final Map<String, String> record = item.getRecord();
                    String value = record.get(header);
                    final Integer sqlType = metadataRepository.getRepository().getColumnMetadataRepository()
                            .getColumnMetadata(new ColumnReference(tableName[0], header)).getJavaSqlType();
                    paramsForLog.add(value);
                    StatementCreatorUtils.setParameterValue(ps, counter, sqlType, value);
                    counter++;
                }
                sayQuery(sql, paramsForLog);
                ps.addBatch();
            }
            return ps.executeBatch();
        }
    });
    batchStart = batchStartRef.get();
    say("******CHUNK SQLSERVER******");
}

---

From source file:org.jasig.ssp.util.importer.job.staging.PostgresStagingTableWriter.java

@Override
public void write(final List<? extends RawItem> items) {

    NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
    String fileName = items.get(0).getResource().getFilename();
    final String[] tableName = fileName.split("\\.");

    Integer batchStart = (Integer) (stepExecution.getExecutionContext().get("batchStart") == null ? null
            : stepExecution.getExecutionContext().get("batchStart"));
    Integer batchStop = (Integer) (stepExecution.getExecutionContext().get("batchStop") == null ? null
            : stepExecution.getExecutionContext().get("batchStop"));
    Object currentEntity = stepExecution.getExecutionContext().get("currentEntity");

    if (currentEntity == null || !currentEntity.equals(tableName[0])) {
        batchStart = 0;//ww  w .  ja va2s .  c om
        batchStop = items.size() - 1;
        currentEntity = tableName[0];
        stepExecution.getExecutionContext().put("currentEntity", currentEntity);
        stepExecution.getExecutionContext().put("batchStart", batchStart);
        stepExecution.getExecutionContext().put("batchStop", batchStop);
    } else {
        batchStart = batchStop + 1;
        batchStop = (Integer) batchStart + items.size() - 1;
        stepExecution.getExecutionContext().put("batchStart", batchStart);
        stepExecution.getExecutionContext().put("batchStop", batchStop);
    }

    RawItem firstItem = items.get(0);
    Resource firstItemResource = firstItem.getResource();

    if (currentResource == null || !(this.currentResource.equals(firstItemResource))) {
        this.orderedHeaders = writeHeader(firstItem);
        this.currentResource = firstItemResource;
    }

    StringBuilder insertSql = new StringBuilder();
    insertSql.append("INSERT INTO stg_" + tableName[0] + " (batch_id,");
    StringBuilder valuesSqlBuilder = new StringBuilder();
    valuesSqlBuilder.append(" VALUES (?,");
    for (String header : this.orderedHeaders) {
        insertSql.append(header).append(",");
        valuesSqlBuilder.append("?").append(",");
    }
    insertSql.setLength(insertSql.length() - 1); // trim comma
    valuesSqlBuilder.setLength(valuesSqlBuilder.length() - 1); // trim comma
    insertSql.append(")");
    valuesSqlBuilder.append(");");
    insertSql.append(valuesSqlBuilder);

    final AtomicInteger batchStartRef = new AtomicInteger(batchStart);
    final String sql = insertSql.toString();

    jdbcTemplate.getJdbcOperations().execute(sql, new PreparedStatementCallback() {
        @Override
        public Object doInPreparedStatement(PreparedStatement ps) throws SQLException, DataAccessException {
            for (RawItem item : items) {
                final List<Object> paramsForLog = new ArrayList(orderedHeaders.length);
                int counter = 1;
                paramsForLog.add(batchStartRef.get());
                StatementCreatorUtils.setParameterValue(ps, counter, SqlTypeValue.TYPE_UNKNOWN,
                        batchStartRef.getAndIncrement());
                counter++;
                for (String header : orderedHeaders) {
                    final Map<String, String> record = item.getRecord();
                    String value = record.get(header);
                    final Integer sqlType = metadataRepository.getRepository().getColumnMetadataRepository()
                            .getColumnMetadata(new ColumnReference(tableName[0], header)).getJavaSqlType();
                    paramsForLog.add(value);
                    StatementCreatorUtils.setParameterValue(ps, counter, sqlType, value);
                    counter++;
                }
                sayQuery(sql, paramsForLog);
                ps.addBatch();
            }
            return ps.executeBatch();
        }
    });

    batchStart = batchStartRef.get();

    say("******CHUNK POSTGRES******");
}

---

From source file:co.com.jj.appform.persistence.impl.generics.DataAccesGenericImpl.java

private void setNamedParameterJdbcTemplate() throws Exception {
    if (dataSource != null) {
        namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(txManager.getDataSource());
    } else {/*from w ww .  ja v a 2s  .  c  o m*/
        setDataSource();
        setNamedParameterJdbcTemplate();
    }
}

---

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

@Override
public User findUser(String username) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    String sql = "SELECT " + SELECT_USER + " FROM ocr_user WHERE user_username=:user_username";
    MapSqlParameterSource paramSource = new MapSqlParameterSource();
    paramSource.addValue("user_username", username);

    LOG.info(sql);//www . j  a v  a  2s .c  om
    logParameters(paramSource);
    User user = null;
    try {
        user = (User) jt.queryForObject(sql, paramSource, new UserMapper(this.getSecurityServiceInternal()));
    } catch (EmptyResultDataAccessException ex) {
        ex.hashCode();
    }
    return user;
}

---

From source file:com.artivisi.iso8583.persistence.dao.MapperDao.java

@Autowired
public void setDataSource(DataSource dataSource) {
    this.namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
    this.jdbcTemplate = new JdbcTemplate(dataSource);
}

---

From source file:in.sc.dao.ListGenerator.java

public NamedParameterJdbcTemplate getTemplate() {
    if (namedParameterJdbcTemplate == null) {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setSchema("smart_compare");
        dataSource.setUsername("root");
        dataSource.setPassword("root");
        dataSource.setUrl("jdbc:mysql://localhost:3306/smart_compare");
        //            dataSource.setPassword("rose@123");
        //            dataSource.setURL("jdbc:mysql://52.42.111.208:3033/smart_compare");

        namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
    }/* w w w.j av a  2 s  .c o m*/
    return namedParameterJdbcTemplate;
}

---

From source file:cherry.foundation.sql.SqlExecutorImpl.java

/**
 * SQL?/*from   w w  w  . ja  va 2  s .c o m*/
 * 
 * @param dataSource 
 * @param reader SQL??
 * @param paramMap SQL???
 * @param continueOnError SQL?????
 * @throws IOException SQL???
 */
@Override
public void execute(DataSource dataSource, Reader reader, Map<String, ?> paramMap, boolean continueOnError)
        throws IOException {

    NamedParameterJdbcTemplate template = new NamedParameterJdbcTemplate(dataSource);

    String sql;
    while ((sql = SimpleSqlParser.nextStatement(reader)) != null) {

        sql = sql.trim();
        if (sql.isEmpty()) {
            continue;
        }

        try {
            template.update(sql, paramMap);
        } catch (DataAccessException ex) {
            if (!continueOnError) {
                throw ex;
            }
        }
    }
}

---

From source file:com.joliciel.jochre.boundaries.BoundaryDaoJdbc.java

@Override
public List<Split> findSplits(Shape shape) {
    NamedParameterJdbcTemplate jt = new NamedParameterJdbcTemplate(this.getDataSource());
    String sql = "SELECT " + SELECT_SPLIT + " FROM ocr_split WHERE split_shape_id=:split_shape_id"
            + " ORDER BY split_position";
    MapSqlParameterSource paramSource = new MapSqlParameterSource();
    paramSource.addValue("split_shape_id", shape.getId());

    LOG.debug(sql);// w  w  w  .  j a  va2s .c  o m
    logParameters(paramSource);
    @SuppressWarnings("unchecked")
    List<Split> splits = jt.query(sql, paramSource, new SplitMapper(this.getBoundaryServiceInternal()));

    return splits;
}

---

From source file:org.jasig.schedassist.impl.owner.SpringJDBCPublicProfileDaoImpl.java

/**
 * @param dataSource the dataSource to set
 */// w  w  w. j  av  a2s  . com
@Autowired
public void setDataSource(DataSource dataSource) {
    this.simpleJdbcTemplate = new SimpleJdbcTemplate(dataSource);
    this.namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• »