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.string_db.jdbc.DbConfig.java

/**
 * @return/*  ww  w  .j a  v  a  2  s  .c o  m*/
 */
@Bean
@Scope("singleton") //JdbcTemplate is thread-safe so keep just one instance
@Description("Provides the singleton JdbcTemplate")
public JdbcTemplate jdbcTemplate() {
    return new JdbcTemplate(dataSourceConfig.dataSource());
}

From source file:com.pontecultural.flashcards.JdbcFlashcardsDao.java

public void insert(final Card aCard) {
    String sql = "INSERT INTO cards (enText,ptText,deckId) VALUES (?,?,?)";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql, new PreparedStatementSetter() {
        public void setValues(PreparedStatement ps) throws SQLException {
            int index = 1;
            ps.setString(index, aCard.getEnText());
            index++;/*from   w ww .  j a  va2s  .  com*/
            ps.setString(index, aCard.getPtText());
            index++;
            ps.setInt(index, aCard.getDeckId());
        }
    });
}

From source file:com.stehno.sjdbcx.reflection.operation.OperationContext.java

public JdbcTemplate getJdbcTemplate() {
    return new JdbcTemplate(dataSource);
}

From source file:org.smigo.species.vernacular.JdbcVernacularDao.java

@Autowired
public void setDataSource(DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
    this.insertVernacular = new SimpleJdbcInsert(dataSource).withTableName("VERNACULARS")
            .usingGeneratedKeyColumns("id")
            .usingColumns("species_id", "vernacular_name", "language", "country");
}

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

public void afterPropertiesSet() throws Exception {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.execute("delete from user_roles_group");
    jdbcTemplate.execute("delete from roles_group_role");
    jdbcTemplate.execute("delete from role_permission");
    jdbcTemplate.execute("delete from roles_group");
    jdbcTemplate.execute("delete from permission");
    jdbcTemplate.execute("delete from role");
    jdbcTemplate.execute("delete from user");
}

From source file:org.xinta.eazycode.components.shiro.dao.BootstrapDataPopulator.java

public void afterPropertiesSet() {
    //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(this.dataSource);

    jdbcTemplate.execute("insert into roles values (1, 'user', 'The default role given to all users.')");
    jdbcTemplate.execute(//from  w  w  w  . ja va 2 s  .  co  m
            "insert into roles values (2, 'admin', 'The administrator role only given to site admins')");
    jdbcTemplate.execute("insert into roles_permissions values (2, 'user:*')");
    jdbcTemplate.execute(
            "insert into users(id,username,email,password) values (1, 'admin', 'sample@shiro.apache.org', '"
                    + new Sha256Hash("admin").toHex() + "')");
    jdbcTemplate.execute("insert into users_roles values (1, 2)");

}

From source file:camelinaction.JdbcTest.java

@Before
public void setupDatabase() throws Exception {
    DataSource ds = context.getRegistry().lookupByNameAndType("dataSource", DataSource.class);
    jdbc = new JdbcTemplate(ds);

    jdbc.execute(/*from   ww w .  java 2  s.  c  o m*/
            "create table incoming_orders " + "( part_name varchar(20), quantity int, customer varchar(20))");
}

From source file:com.nebhale.cyclinglibrary.repository.JdbcCollectionRepository.java

@Autowired
JdbcCollectionRepository(DataSource dataSource) {
    this.jdbcTemplate = new JdbcTemplate(dataSource);
    this.createStatement = new SimpleJdbcInsert(dataSource).withTableName("collections")
            .usingGeneratedKeyColumns("id");
}

From source file:com.rplt.studioMusik.dataPersewaan.PersewaanStudioMusikDAO.java

@Override
public void simpanData(PersewaanStudioMusik pPersewaanStudioMusik) {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    KeyHolder keyHolder = new GeneratedKeyHolder();
    //        String kode = getGeneratedKodeSewa();

    String sql = "insert into PERSEWAAN_STUDIO_MUSIK "
            + "values(?, ?, ?, ?, to_date(?, 'dd-MON-yyyy HH24:MI'), to_date(?, 'dd-MON-yyyy HH24:MI'), ?)";

    final String sqlmysql = "INSERT INTO `studiomusik`.`persewaan_studio_musik` "
            + "(`KODE_STUDIO`, `NAMA_PENYEWA`, `NOMOR_TELEPON`, `MULAI_SEWA`, `SELESAI_SEWA`, `BIAYA_PELUNASAN`) "
            + "VALUES (?, ?, ?, STR_TO_DATE(?, '%d-%b-%Y %k:%S'), " + "STR_TO_DATE(?, '%d-%b-%Y %k:%S'), ?)";

    System.out.println(sql);//from   ww w. j a  v  a  2  s . c o  m

    jdbcTemplate.update(new PreparedStatementCreator() {

        @Override
        public PreparedStatement createPreparedStatement(Connection cnctn) throws SQLException {
            PreparedStatement ps = cnctn.prepareStatement(sqlmysql, Statement.RETURN_GENERATED_KEYS);
            ps.setString(1, pPersewaanStudioMusik.getmKodeStudio());
            ps.setString(2, pPersewaanStudioMusik.getmNamaPenyewa());
            ps.setString(3, pPersewaanStudioMusik.getmNomorTeleponPenyewa());
            ps.setString(4, pPersewaanStudioMusik.getmMulaiSewa());
            ps.setString(5, pPersewaanStudioMusik.getmSelesaiSewa());
            ps.setInt(6, pPersewaanStudioMusik.getmBiayaPelunasan());
            return ps;
        }
    }, keyHolder);

    //        jdbcTemplate.update(sql,
    //                new Object[]{
    //                    kode,
    //                    pPersewaanStudioMusik.getmKodeStudio(),
    //                    pPersewaanStudioMusik.getmNamaPenyewa(),
    //                    pPersewaanStudioMusik.getmNomorTeleponPenyewa(),
    //                    pPersewaanStudioMusik.getmMulaiSewa(),
    //                    pPersewaanStudioMusik.getmSelesaiSewa(),
    //                    pPersewaanStudioMusik.getmBiayaPelunasan()
    //                });
    System.out.println(pPersewaanStudioMusik.getmMulaiSewa() + "sd" + pPersewaanStudioMusik.getmSelesaiSewa());

    pPersewaanStudioMusik.setmKodeSewa(keyHolder.getKey().toString());

    System.out.println("KEYHOLDER : " + pPersewaanStudioMusik.getmKodeSewa());

    System.out.println(pPersewaanStudioMusik.getmKodeSewa());

}

From source file:com.github.yongchristophertang.database.guice.provider.JdbcTemplateFactory.java

/**
 * Transfer an annotation to a T object.
 *
 * @param anno Sql annotation/*from w w  w.  j  a v  a 2 s . c  om*/
 */
@Override
protected JdbcTemplate createClient(SqlDB anno) {
    if (StringUtils.isBlank(anno.url()) || StringUtils.isBlank(anno.userName())
            || StringUtils.isBlank(anno.password())) {
        throw new IllegalArgumentException("Not all necessary configuration are specified.");
    }
    HikariDataSource ds = new HikariDataSource();
    ds.setJdbcUrl(anno.url());
    ds.setUsername(anno.userName());
    ds.setPassword(anno.password());
    return new JdbcTemplate(ds);
}