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:com.iucosoft.eavertizare.dao.impl.ConfiguratiiDaoImpl.java

@Override
public Configuratii findById(int idConfiguratie) {

    String query = "select * from configuratii_db where id = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    //using RowMapper anonymous class, we can create a separate RowMapper for reuse
    Configuratii configuratii = jdbcTemplate.queryForObject(query, new Object[] { idConfiguratie },
            new RowMapper<Configuratii>() {

                @Override/*  w  w  w  . j  a  v  a 2  s. c  o  m*/
                public Configuratii mapRow(ResultSet rs, int i) throws SQLException {

                    Configuratii configuratie = new Configuratii();
                    configuratie.setId(rs.getInt(1));
                    configuratie.setDriver(rs.getString(2));
                    configuratie.setUrlDb(rs.getString(3));
                    configuratie.setUsername(rs.getString(4));
                    configuratie.setPassword(rs.getString(5));
                    configuratie.setTabelaClienti(rs.getString(6));
                    return configuratie;
                }
            });

    return configuratii;
}

From source file:at.ac.tuwien.qse.sepm.dao.AbstractJDBCDAOTest.java

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

From source file:org.cloudfoundry.identity.uaa.password.PasswordChangeEndpointTests.java

@Before
public void setup() {

    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    JdbcScimUserProvisioning dao = new JdbcScimUserProvisioning(jdbcTemplate,
            new JdbcPagingListFactory(jdbcTemplate, new DefaultLimitSqlAdapter()));
    dao.setPasswordEncoder(NoOpPasswordEncoder.getInstance());
    dao.setPasswordValidator(new NullPasswordValidator());

    endpoints = new PasswordChangeEndpoint();
    endpoints.setScimUserProvisioning(dao);

    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:nl.surfnet.coin.db.AbstractInMemoryDatabaseTest.java

/**
 * We use an in-memory database - no need for Spring in this one - and
 * populate it with the sql statements in test-data-eb.sql
 * /*from www.j av  a2  s.  com*/
 * @throws Exception
 *           unexpected
 */
@Before
public void before() throws Exception {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setPassword("");
    dataSource.setUsername("sa");
    String url = getDataSourceUrl();
    dataSource.setUrl(url);
    dataSource.setDriverClassName("org.hsqldb.jdbcDriver");

    jdbcTemplate = new JdbcTemplate(dataSource);

    ClassPathResource resource = new ClassPathResource(getMockDataContentFilename());
    logger.debug("Loading database content from " + resource);
    if (resource.exists()) {
        final String sql = IOUtils.toString(resource.getInputStream());
        final String[] split = sql.split(";");
        for (String s : split) {
            if (!StringUtils.hasText(s)) {
                continue;
            }
            jdbcTemplate.execute(s + ';');
        }
    }
}

From source file:com.graphaware.importer.data.access.DbDataReader.java

/**
 * Create a {@link org.springframework.jdbc.core.JdbcTemplate} used for talking to the database.
 *
 * @return jdbc template.//from  www . j av  a 2  s .c om
 */
protected JdbcTemplate createJdbcTemplate() {
    DataSource dataSource = createDataSource();

    JdbcTemplate result = new JdbcTemplate(dataSource);

    additionalConfig(result);

    return result;
}

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

@Override
public List<Ticket> getTicketList() {
    List ticketList = new ArrayList();
    //   String sql = "select * from ticket";
    String sql = "select ticket_id,ticket_type,total_tickets from tickets";
    jdbcTemplate = new JdbcTemplate(dataSource);
    ticketList = jdbcTemplate.query(sql, new TicketRowMapper());
    System.out.println("Dao:" + ticketList);
    return ticketList;
}

From source file:edu.harvard.i2b2.crc.dao.setfinder.QueryInstanceSpringDao.java

public QueryInstanceSpringDao(DataSource dataSource, DataSourceLookup dataSourceLookup) {
    setDataSource(dataSource);/*from   w w  w  . j a  va 2  s  . c  om*/
    setDbSchemaName(dataSourceLookup.getFullSchema());
    jdbcTemplate = new JdbcTemplate(dataSource);
    this.dataSourceLookup = dataSourceLookup;
    queryInstanceMapper = new QtQueryInstanceRowMapper();
}

From source file:org.cloudfoundry.identity.uaa.scim.bootstrap.ScimUserBootstrapTests.java

@Before
public void setUp() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    builder.addScript("classpath:/org/cloudfoundry/identity/uaa/schema-hsqldb.sql");
    builder.addScript("classpath:/org/cloudfoundry/identity/uaa/scim/schema-hsqldb.sql");
    database = builder.build();/* w w  w . ja  v  a 2s  .  c o  m*/
    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    JdbcPagingListFactory pagingListFactory = new JdbcPagingListFactory(jdbcTemplate,
            new DefaultLimitSqlAdapter());
    db = new JdbcScimUserProvisioning(jdbcTemplate, pagingListFactory);
    db.setPasswordValidator(new NullPasswordValidator());
    gdb = new JdbcScimGroupProvisioning(jdbcTemplate, pagingListFactory);
    mdb = new JdbcScimGroupMembershipManager(jdbcTemplate);
    mdb.setScimUserProvisioning(db);
    mdb.setScimGroupProvisioning(gdb);
    userEndpoints = new ScimUserEndpoints();
    userEndpoints.setScimGroupMembershipManager(mdb);
    userEndpoints.setScimUserProvisioning(db);
}

From source file:io.github.huherto.springyRecords.TestDatabaseGenerator.java

@Test
@Ignore/*from  w  ww.  j  av  a  2s.  co  m*/
public void insertPet() {
    DataSource ds = createDs();

    JdbcTemplate jt = new JdbcTemplate(ds);
    jt.execute("delete from pet");

    PetTable table = new PetTable(ds);
    PetRecord r = new PetRecord();
    r.birthDate = new Date();
    r.name = "Manchas";
    r.owner = "Humberto";
    r.sex = "M";
    r.species = "Dog";
    table.insert(r);

    List<PetRecord> pets = table.queryAll();
    assertTrue(pets.size() >= 1);

}

From source file:uk.ac.kcl.itemProcessors.DbLineFixerItemProcessor.java

@PostConstruct
public void init() {
    this.template = new JdbcTemplate(ds);
    setFieldName(fieldName);
}