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.ewcms.component.online.dao.AdvisorDAO.java

@Autowired
public void setDataSource(DataSource ds) {
    jdbcTemplate = new JdbcTemplate(ds);
}

From source file:com.rplt.studioMusik.member.MemberDAO.java

@Override
public void simpanData(Member pT) {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    String kode = getGeneratedKodeMember();
    String sql = "INSERT INTO member_studio_musik VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

    sql = "INSERT INTO `studiomusik`.`member_studio_musik` VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

    jdbcTemplate.update(sql,//from  w w  w  .j av a2  s  .  com
            new Object[] { kode, pT.getmUsernameMember().toUpperCase(), pT.getmPaswordMember(),
                    pT.getmNamaMember().toUpperCase(), pT.getmTempatLahirMember().toUpperCase(),
                    pT.getmTempatTanggalLahir().toUpperCase(), pT.getmAlamatMember(), pT.getmEmailMember(),
                    pT.getmNomorTelepon(), pT.getmSaldoMember(), });

    pT.setmKodeMember(kode);
}

From source file:camelinaction.InventoryCreateTable.java

public InventoryCreateTable(DataSource ds) {
    JdbcTemplate jdbc = new JdbcTemplate(ds);

    try {//from   w w w.  ja v a2 s.c  o  m
        jdbc.execute("drop table partner_inventory");
    } catch (Exception e) {
        // ignore as the table may not already exists
    }
    jdbc.execute("create table partner_inventory "
            + "( supplier_id varchar(10), part_id varchar(10), name varchar(10), amount varchar(10) )");
}

From source file:com.phideltcmu.recruiter.server.dao.RecruitListDao.java

private void checkSingleton() {
    if (jdbcTemplate == null) {
        jdbcTemplate = new JdbcTemplate(dataSource);
    }
}

From source file:com.bank.repository.internal.JdbcAccountRepository.java

public JdbcAccountRepository(DataSource dataSource) {
    jdbcTemplate = new JdbcTemplate(dataSource);
}

From source file:com.miserablemind.butter.domain.model.user.user.impl.UserDaoJDBCImpl.java

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

From source file:nl.surfnet.coin.shared.log.ApiCallLogServiceImpl.java

public ApiCallLogServiceImpl(DataSource dataSource) {
    jdbcTemplate = new JdbcTemplate(dataSource);
}

From source file:com.rplt.studioMusik.pegawai.PegawaiDAO.java

@Override
public String getNamaByUser(String pUsername) {
    String sql = "SELECT nama_pegawai FROM pegawai_studio_musik WHERE username_pegawai = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    return jdbcTemplate.queryForObject(sql, String.class, pUsername);
}

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

@Override
public void save(Discount discount) {
    jdbcTemplate = new JdbcTemplate(dataSource);
    //        if (discount.getId() > 0) {
    ////from  w w  w. jav  a 2s . c o  m
    //            // update
    //            String sql = "UPDATE discount SET id=?, ticket_type=?, min_quntity=?, min_ticket=?,max_quntity,max_ticket=?,discount_percentage=?"
    //                    + "discount_amount=?  WHERE id=?";
    //
    //            jdbcTemplate.update(sql, new Object[]{discount.getTickettype(), discount.getMinticket(),
    //                discount.getMaxquntity(), discount.getMaxticket(), discount.getDiscountamount(), discount.getDiscountpercentage(), discount.getId()});
    //        } else {
    // insert

    String sql = "INSERT INTO discount(MIN_TICKET,MAX_TICKET,DISCOUNT_AMOUNT,DISCOUNT_PERCENTAGE)"
            + " VALUES (?,?,?,?)";
    jdbcTemplate.update(sql, new Object[] { discount.getMinticket(), discount.getMaxticket(),
            discount.getDiscountamount(), discount.getDiscountpercentage() });

}

From source file:com.javaetmoi.elasticsearch.musicbrainz.batch.item.EnhanceAlbumProcessor.java

@Autowired
private EnhanceAlbumProcessor(DataSource dataSource) {
    jdbcTemplate = new JdbcTemplate(dataSource);
}