Example usage for org.springframework.jdbc.core JdbcTemplate JdbcTemplate

List of usage examples for org.springframework.jdbc.core JdbcTemplate JdbcTemplate

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

Introduction

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

Prototype

public JdbcTemplate(DataSource dataSource)

Source Link

Document

Construct a new JdbcTemplate, given a DataSource to obtain connections from.

Usage

From source file:net.sourceforge.vulcan.jabber.JdbcScreenNameMapper.java

protected JdbcTemplate createJdbcTemplate() throws NamingException {
    return new JdbcTemplate(findDataSource());
}

From source file:info.naiv.lab.java.tool.sqlite.exporter.component.Destination.java

/**
 *
 * @param props//from  w  w  w.  ja va2 s  .  c o  m
 * @param dataAccess
 */
public Destination(Properties props, DataAccess dataAccess) {

    String dir = props.getProperty("export.directory");
    String base = props.getProperty("export.basename");
    String ext = props.getProperty("export.extension");

    Calendar date = ClassicDateUtils.now();
    String ts = (new SimpleDateFormat("yyyyMMdd-HHmmss")).format(date.getTime());

    String p = concatnate(dir, base, "-", ts, ".", ext);
    String url = "jdbc:sqlite:" + p;
    this.props = props;
    logger.info("dest url = {}", url);
    DriverManagerDataSource dataSource = new DriverManagerDataSource(url);
    this.jdbcTemplate = new JdbcTemplate(dataSource);
    this.dataAccess = dataAccess;
}

From source file:com.github.viktornar.migration.dao.DaoHelper.java

/**
 * Returns a JDBC template for performing database operations.
 *
 * @return A JDBC template./*w  w  w  . j a v  a 2  s  . c o m*/
 */
public JdbcTemplate getJdbcTemplate() {
    return new JdbcTemplate(dataSource);
}

From source file:uk.ac.kcl.it.SqlServerTestUtils.java

@Override
@PostConstruct//from www .  j  ava2  s. c o  m
public void init() {
    this.sourceTemplate = new JdbcTemplate(sourceDataSource);
    this.targetTemplate = new JdbcTemplate(targetDataSource);
    JdbcTemplate jobRepoTemplate = new JdbcTemplate(jobRepositoryDataSource);
}

From source file:org.thlim.castle.dao.BootstrapDataPopulator.java

public void afterPropertiesSet() throws Exception {
    // because we're using an in-memory hsqldb for the sample app, a new one will be created
    // each time the
    // app starts, so insert the sample admin user at startup:
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.execute(/* w w w  .j av a2  s.  c o  m*/
            "insert into role(id,name,description) values (1, 'platform admin', 'Overall admin for all levels')");
    jdbcTemplate.execute(
            "insert into role(id,name,description) values (2, 'agency admin', 'Overall admin for an agency')");
    jdbcTemplate.execute("insert into role(id,name,description) values (3, 'agency owner', 'Owns an agency.')");
    jdbcTemplate
            .execute("insert into role(id,name,description) values (4, 'project admin', 'Admin for project.')");
    jdbcTemplate
            .execute("insert into role(id,name,description) values (5, 'project owner', 'Owns a project.')");
    jdbcTemplate
            .execute("insert into role(id,name,description) values (6, 'operator', 'Operators for project.')");
    jdbcTemplate.execute("insert into permission values (1, '*')");
    jdbcTemplate.execute("insert into permission values (2, 'agency:*')");
    jdbcTemplate.execute("insert into permission values (3, 'agency:view')");
    jdbcTemplate.execute("insert into permission values (4, 'agency:edit')");
    jdbcTemplate.execute("insert into permission values (5, 'agency:create')");
    jdbcTemplate.execute("insert into permission values (6, 'agency:delete')");
    jdbcTemplate.execute("insert into permission values (7, 'user:create')");
    jdbcTemplate.execute("insert into permission values (8, 'role:create')");

    // project permissions created on the fly
    jdbcTemplate.execute("insert into permission values (9, 'project:*')");
    jdbcTemplate.execute("insert into permission values (10, 'project:create')");
    jdbcTemplate.execute("insert into permission values (11, 'project:view')");
    jdbcTemplate.execute("insert into permission values (12, 'project:edit')");
    jdbcTemplate.execute("insert into permission values (13, 'project:assign')");
    jdbcTemplate.execute("insert into permission values (14, 'project:delete')");
    jdbcTemplate.execute("insert into permission values (15, 'vm:delete')");
    jdbcTemplate.execute("insert into permission values (16, 'vm:stop')");
    jdbcTemplate.execute("insert into permission values (17, 'vm:start')");

    jdbcTemplate.execute("insert into role_permission values (1, 1)");
    jdbcTemplate.execute("insert into role_permission values (2, 2)");
    jdbcTemplate.execute(
            "insert into user(id,username,email,password) values (1, 'alice', 'sample@shiro.apache.org', '"
                    + new Sha256Hash("alice").toHex() + "')");
    jdbcTemplate.execute(
            "insert into user(id,username,email,password) values (2, 'bob', 'sample@shiro.apache.org', '"
                    + new Sha256Hash("bob").toHex() + "')");
    jdbcTemplate.execute("insert into user_role values (1, 2)");
    jdbcTemplate.execute("insert into user_role values (2, 1)");

}

From source file:com.company.project.service.dao.PersistentTokenDao.java

public void dropTable() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update("drop table messages");
}

From source file:pl.edu.icm.comac.vis.server.service.TestConfig.java

@Bean
public JdbcTemplate getJdbcTemplate(DataSource dataSource) {
    return new JdbcTemplate(dataSource);
}

From source file:com.ofbizian.infinispan.EndToEndCommitTest.java

@Before
public void setUp() throws Exception {
    camelContext.getRouteDefinition("createRoute").adviceWith(camelContext, new AdviceWithRouteBuilder() {
        @Override/*from   ww w  .ja v  a 2 s.c  o m*/
        public void configure() throws Exception {
            replaceFromWith("direct:start");
        }
    });
    jdbcTemplate = new JdbcTemplate(dataSource);
}

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

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

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    List<String> batchedStatements = new ArrayList<String>();

    String fileName = items.get(0).getResource().getFilename();
    String[] tableName = fileName.split("\\.");

    Object batchStart = stepExecution.getExecutionContext().get("batchStart");
    Object batchStop = stepExecution.getExecutionContext().get("batchStop");

    RawItem item = items.get(0);//from  ww w  .j  av a2  s.c om
    if (currentResource == null) {
        this.orderedHeaders = writeHeader(items.get(0));
        this.currentResource = items.get(0).getResource();
    }
    Resource itemResource = item.getResource();
    if (!(this.currentResource.equals(itemResource))) {
        this.orderedHeaders = writeHeader(item);
        this.currentResource = itemResource;
    }
    StringBuilder insertSql = new StringBuilder();
    insertSql
            .append(" MERGE INTO " + tableName[0] + " as target USING stg_" + tableName[0] + " as source ON (");

    List<String> tableKeys = metadataRepository.getRepository().getColumnMetadataRepository()
            .getTableMetadata(new TableReference(tableName[0])).getTableKeys();

    // There are a few external tables that don't (yet) have natural keys,
    // in these cases we've enforced the key on the staging table
    // so in cases where the external table does not have any keys, we look
    // towards the corresponding staging table for them
    if (tableKeys.isEmpty()) {
        tableKeys = metadataRepository.getRepository().getColumnMetadataRepository()
                .getTableMetadata(new TableReference("stg_" + tableName[0])).getTableKeys();
    }
    for (String key : tableKeys) {
        insertSql.append("target." + key + " = source." + key + " and ");
    }
    insertSql.setLength(insertSql.length() - 4); // trim comma

    insertSql.append(") WHEN NOT MATCHED AND source.batch_id >= " + batchStart + " and source.batch_id <= "
            + batchStop + " THEN INSERT (");

    StringBuilder valuesSqlBuilder = new StringBuilder();
    valuesSqlBuilder.append(" VALUES ( ");
    for (String header : this.orderedHeaders) {

        insertSql.append(header).append(",");
        valuesSqlBuilder.append("source." + header).append(",");
    }
    insertSql.setLength(insertSql.length() - 1); // trim comma
    insertSql.append(")");
    valuesSqlBuilder.setLength(valuesSqlBuilder.length() - 1); // trim comma
    insertSql.append(valuesSqlBuilder);
    insertSql.append(")");
    insertSql.append(" WHEN MATCHED AND source.batch_id >= " + batchStart + " and source.batch_id <= "
            + batchStop + " THEN UPDATE SET ");

    for (String header : this.orderedHeaders) {
        // We don't skip key columns b/c some tables are entirely keys.
        // so a bit wasteful, but makes statement building logic a bit
        // simpler than figuring out if we can leave the update
        // clause off altogether
        insertSql.append("target.").append(header).append("=source.").append(header).append(",");
    }

    insertSql.setLength(insertSql.length() - 1); // trim comma
    insertSql.append(";");

    batchedStatements.add(insertSql.toString());
    sayQuery(insertSql);
    try {
        int[] results = jdbcTemplate.batchUpdate(batchedStatements.toArray(new String[] {}));
        Integer numInsertedUpdated = (Integer) stepExecution.getExecutionContext().get("numInsertedUpdated");
        numInsertedUpdated = numInsertedUpdated == null ? 0 : numInsertedUpdated;
        if (results.length >= 1) {
            numInsertedUpdated = numInsertedUpdated + results[0];
        }
        if (results.length >= 2) {
            numInsertedUpdated = numInsertedUpdated + results[1];
        }
        stepExecution.getExecutionContext().put("numInsertedUpdated", numInsertedUpdated);

        say("******UPSERT******" + " batch start:" + batchStart + " batchstop:" + batchStop);
    } catch (Exception e) {
        throw new NotSkippableException(e);
    }
}

From source file:com.springsource.open.db.BaseDatasourceTests.java

@Autowired
public void setDataSources(@Qualifier("firstDataSource") DataSource dataSource,
        @Qualifier("secondDataSource") DataSource otherDataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
    this.otherJdbcTemplate = new JdbcTemplate(otherDataSource);
}