Example usage for org.springframework.jdbc.core JdbcTemplate 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:org.cloudfoundry.identity.uaa.scim.ScimUserBootstrapTests.java

@Before
public void setUp() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    builder.addScript("classpath:/org/cloudfoundry/identity/uaa/schema-hsqldb.sql");
    database = builder.build();/*from   w ww .  j a  va  2s . c om*/
    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    db = new JdbcScimUserProvisioning(jdbcTemplate);
    db.setPasswordValidator(new NullPasswordValidator());
    gdb = new JdbcScimGroupProvisioning(jdbcTemplate);
    mdb = new JdbcScimGroupMembershipManager(jdbcTemplate);
    mdb.setScimUserProvisioning(db);
    mdb.setScimGroupProvisioning(gdb);
    userEndpoints = new ScimUserEndpoints();
    userEndpoints.setScimGroupMembershipManager(mdb);
    userEndpoints.setScimUserProvisioning(db);
}

From source file:org.smigo.message.JdbcMessageDao.java

@Autowired
public void setDataSource(DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
    this.insert = new SimpleJdbcInsert(dataSource).withTableName("messages").usingGeneratedKeyColumns("id")
            .usingColumns("text", "submitter_user_id", "locale");
}

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

public void update(String series, String token, Date date) {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update("update into persistent_logins set token = ?, last_used = ? where series = ? ", token,
            date, series);//from w  w  w  .  j av  a 2  s.c om
}

From source file:org.cloudfoundry.identity.uaa.scim.test.TestUtils.java

public static void deleteFrom(DataSource dataSource, String... tables) throws Exception {
    for (String table : tables) {
        new JdbcTemplate(dataSource).update("delete from " + table);
    }//from ww  w  .  j a v  a  2  s .com
}

From source file:org.wso2.carbon.metrics.impl.JDBCCleanupTest.java

@BeforeClass
public static void setupDatasource() throws ScriptException, SQLException {
    dataSource = JdbcConnectionPool.create("jdbc:h2:mem:test-cleanup;DB_CLOSE_DELAY=-1", "sa", "");
    template = new JdbcTemplate(dataSource);
    ResourceDatabasePopulator populator = new ResourceDatabasePopulator();
    populator.addScript(new ClassPathResource("dbscripts/h2.sql"));
    populator.populate(dataSource.getConnection());
}

From source file:eu.trentorise.smartcampus.permissionprovider.oauth.AutoJdbcAuthorizationCodeServices.java

protected void initSchema(DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.execute(createStatement);
}

From source file:org.apereo.lap.services.StorageService.java

@PostConstruct
public void init() {
    // Initialize the temp database connection
    tempJdbcTemplate = new JdbcTemplate(tempDataSource);

    // Initialize the persistent database connection
    persistentJdbcTemplate = new JdbcTemplate(persistentDataSource);

    logger.info("INIT");
}

From source file:com.branded.holdings.qpc.repository.jdbc.JdbcVisitRepositoryImpl.java

@Autowired
public JdbcVisitRepositoryImpl(DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);

    this.insertVisit = new SimpleJdbcInsert(dataSource).withTableName("visits").usingGeneratedKeyColumns("id");
}

From source file:com.nebhale.buildmonitor.web.AbstractControllerTest.java

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

From source file:locksdemo.JdbcLockService.java

public JdbcLockService(DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
}