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:org.cloudfoundry.identity.uaa.scim.ScimUserEndpointsTests.java

@BeforeClass
public static void setUp() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    builder.addScript("classpath:/org/cloudfoundry/identity/uaa/schema-hsqldb.sql");
    database = builder.build();/* w ww.jav a 2 s  . c o m*/
    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    dao = new JdbcScimUserProvisioning(jdbcTemplate);
    dao.setPasswordEncoder(NoOpPasswordEncoder.getInstance());
    dao.setPasswordValidator(new NullPasswordValidator());
    ScimSearchQueryConverter filterConverter = new ScimSearchQueryConverter();
    Map<String, String> replaceWith = new HashMap<String, String>();
    replaceWith.put("emails\\.value", "email");
    replaceWith.put("groups\\.display", "authorities");
    replaceWith.put("phoneNumbers\\.value", "phoneNumber");
    filterConverter.setAttributeNameMapper(new SimpleAttributeNameMapper(replaceWith));
    dao.setQueryConverter(filterConverter);
    endpoints = new ScimUserEndpoints();
    endpoints.setScimUserProvisioning(dao);
    mm = new JdbcScimGroupMembershipManager(jdbcTemplate);
    mm.setScimUserProvisioning(dao);
    JdbcScimGroupProvisioning gdao = new JdbcScimGroupProvisioning(jdbcTemplate);
    mm.setScimGroupProvisioning(gdao);
    endpoints.setScimGroupMembershipManager(mm);
    groupEndpoints = new ScimGroupEndpoints(gdao, mm);
    joel = new ScimUser(null, "jdsa", "Joel", "D'sa");
    joel.addEmail("jdsa@vmware.com");
    dale = new ScimUser(null, "olds", "Dale", "Olds");
    dale.addEmail("olds@vmware.com");
    joel = dao.createUser(joel, "password");
    dale = dao.createUser(dale, "password");
}

From source file:org.ala.hbase.GeoRegionLoader.java

/**
 * Initialise connections./*from  ww w.j a v  a 2 s.  c  om*/
 */
private void init() {
    String[] locations = { "classpath:spring.xml" };
    context = new ClassPathXmlApplicationContext(locations);
    gisDataSource = (DataSource) context.getBean("gisDataSource");
    gisTemplate = new JdbcTemplate(gisDataSource);
    geoRegionDao = (GeoRegionDao) context.getBean("geoRegionDao");
}

From source file:com.scistor.queryrouter.server.impl.JdbcHandlerImpl.java

/**
 * //www.  j  a  va 2s.  com
 * initJdbcTemplate
 * 
 * @param dataSource
 *            dataSource
 */
@Override
public synchronized void initJdbcTemplate(DataSource dataSource) {
    long begin = System.currentTimeMillis();
    try {
        if (this.getJdbcTemplate() == null || !this.getJdbcTemplate().getDataSource().equals(dataSource)) {
            this.setJdbcTemplate(new JdbcTemplate(dataSource));
            logger.info("queryId:{} initJdbcTemplate cost:" + (System.currentTimeMillis() - begin) + "ms", 1);
        }
        //            String maxSize = PropertiesFileUtils.getPropertiesKey(PROPERY_SERVER_FILE_NAME,
        //                    PROPERY_MAX_RESULT_SIZE);
        //            if (!StringUtils.isEmpty(maxSize)) {
        //                memoryMaxSize = Integer.valueOf(maxSize).intValue();
        //            }
        this.dataSource = dataSource;
    } catch (Exception e) {
        e.printStackTrace();
        logger.error("getDataSource error:" + e.getCause().getMessage());
    }
}

From source file:com.avego.oauth.migration.JdbcOauthMigrationDao.java

/**
 * This creates a JdbcOauthMigrationDao that uses the given params
 * @param params The params/*from  w w w. j av  a2 s.c  om*/
 * @throws SQLException If an erorr occurs creating the data source
 */
public JdbcOauthMigrationDao(Map<String, Object> params) throws SQLException {
    if (params == null) {
        throw new IllegalArgumentException("The parameters may not be null");
    }
    this.params = params;
    this.datasource = buildDataSource();
    this.jdbcTemplate = new JdbcTemplate(this.datasource);
    this.tokenStore = new CustomJdbcTokenStore(this.datasource);
}

From source file:com.fengjing.framework.shiro.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 create the tables and insert the 2 sample users on bootstrap:

    JdbcTemplate jdbcTemplate = new JdbcTemplate(this.dataSource);
    //jdbcTemplate.execute(CREATE_TABLES);

    System.out.println(CREATE_TABLES);

    //password is 'admin' SHA hashed and base64 encoded:
    //The first argument to the hash constructor is the actual value to be hased.  The 2nd is the
    //salt.  In this simple demo scenario, the username and the password are the same, but to clarify the
    //distinction, you would see this in practice:
    //new Sha256Hash( <password>, <cryptographically strong randomly generated salt> (not the username!) )
    String query = "insert into users values ('admin', '" + new Sha256Hash("admin", "admin").toBase64() + "' )";
    jdbcTemplate.execute(query);//from  w  w  w  .j a v a 2s . c  om
    log.debug("admin.");

    //password is 'user' SHA hashed and base64 encoded:
    query = "insert into users values ( 'user', '" + new Sha256Hash("user", "user").toBase64() + "' )";
    jdbcTemplate.execute(query);
    log.debug("user.");

    query = "insert into roles values ( 'Admin' )";
    jdbcTemplate.execute(query);
    log.debug(" Admin");

    query = "insert into roles values ( 'User' )";
    jdbcTemplate.execute(query);
    log.debug(" User");

    query = "insert into roles_permissions values ( 'Admin', 'user:view')";
    jdbcTemplate.execute(query);
    log.debug("Adminuser:view");

    query = "insert into roles_permissions values ( 'Admin', 'user:edit')";
    jdbcTemplate.execute(query);
    log.debug("Adminuser:edit");

    query = "insert into roles_permissions values ( 'User', 'user:view')";
    jdbcTemplate.execute(query);
    log.debug("Useruser:view");

    query = "insert into user_roles values ( 'admin', 'Admin' )";
    jdbcTemplate.execute(query);
    query = "insert into user_roles values ( 'admin', 'User' )";
    jdbcTemplate.execute(query);
    log.debug("adminAdmin User");

    query = "insert into user_roles values ( 'user', 'User' )";
    jdbcTemplate.execute(query);
    log.debug("user User");
}

From source file:org.apache.shiro.samples.spring.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 create the tables and insert the 2 sample users on bootstrap:

    JdbcTemplate jdbcTemplate = new JdbcTemplate(this.dataSource);
    jdbcTemplate.execute(CREATE_TABLES);

    //password is 'user1' SHA hashed and base64 encoded:
    //The first argument to the hash constructor is the actual value to be hased.  The 2nd is the
    //salt.  In this simple demo scenario, the username and the password are the same, but to clarify the
    //distinction, you would see this in practice:
    //new Sha256Hash( <password>, <cryptographically strong randomly generated salt> (not the username!) )
    String query = "insert into users values ('user1', '" + new Sha256Hash("user1", "user1").toBase64() + "' )";
    jdbcTemplate.execute(query);//from w  w w. ja  v a  2  s. co  m
    log.debug("Created user1.");

    //password is 'user2' SHA hashed and base64 encoded:
    query = "insert into users values ( 'user2', '" + new Sha256Hash("user2", "user2").toBase64() + "' )";
    jdbcTemplate.execute(query);
    log.debug("Created user2.");

    query = "insert into roles values ( 'role1' )";
    jdbcTemplate.execute(query);
    log.debug("Created role1");

    query = "insert into roles values ( 'role2' )";
    jdbcTemplate.execute(query);
    log.debug("Created role2");

    query = "insert into roles_permissions values ( 'role1', 'permission1')";
    jdbcTemplate.execute(query);
    log.debug("Created permission 1 for role 1");

    query = "insert into roles_permissions values ( 'role1', 'permission2')";
    jdbcTemplate.execute(query);
    log.debug("Created permission 2 for role 1");

    query = "insert into roles_permissions values ( 'role2', 'permission1')";
    jdbcTemplate.execute(query);
    log.debug("Created permission 1 for role 2");

    query = "insert into user_roles values ( 'user1', 'role1' )";
    jdbcTemplate.execute(query);
    query = "insert into user_roles values ( 'user1', 'role2' )";
    jdbcTemplate.execute(query);
    log.debug("Assigned user1 roles role1 and role2");

    query = "insert into user_roles values ( 'user2', 'role2' )";
    jdbcTemplate.execute(query);
    log.debug("Assigned user2 role role2");
}

From source file:com.beezas.dao.TicketDaoImpl.java

@Override
public void deleteTicket(int ticketId) {
    // String sql = "delete from tickets where ticket_type=?"; 
    String sql = "delete from tickets where ticket_id=?";
    jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql, ticketId);//from  w ww  .jav  a 2s .c o  m

}

From source file:com.googlecode.flyway.core.dbsupport.postgresql.PostgreSQLMigrationMediumTest.java

/**
 * Tests clean and migrate for PostgreSQL Triggers.
 *//*  w ww . j  a  va  2  s  .c  om*/
@Test
public void trigger() throws Exception {
    flyway.setBaseDir("migration/dbsupport/postgresql/sql/trigger");
    flyway.migrate();

    JdbcTemplate jdbcTemplate = new JdbcTemplate(migrationDataSource);
    assertEquals(10, jdbcTemplate.queryForInt("SELECT count(*) FROM test4"));

    flyway.clean();

    // Running migrate again on an unclean database, triggers duplicate object exceptions.
    flyway.migrate();

}

From source file:org.inbio.ait.dao.conn.impl.PlicDataAccessDAOImpl.java

private void accessToDB(PlicPropertyHolder ph) {
    //Getting the data source connection
    AitDataSource ds = new AitDataSource(ph.getDriverClassName(), ph.getUrl(), ph.getUsername(),
            ph.getPassword());/*w  w w  .jav  a 2s .  c o  m*/
    this.jdbcTemplate = new JdbcTemplate(ds);
}