Example usage for org.springframework.jdbc.core JdbcTemplate update

Introduction

In this page you can find the example usage for org.springframework.jdbc.core JdbcTemplate update.

Prototype

@Override
    public int update(String sql, @Nullable Object... args) throws DataAccessException 

Source Link

Usage

From source file:com.iucosoft.eavertizare.dao.impl.FirmaDaoImpl.java

@Override
public void deleteByName(String firmaName) {
    String query = "delete from firme where nume_firma=?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    jdbcTemplate.update(query, firmaName);
}

---

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

@Override
public void updateKurangSaldo(String pUsername, int pValue) {
    String sql = "UPDATE member_studio_musik SET saldo_member = ? WHERE username_member = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql, new Object[] { pValue, pUsername });
}

---

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

@Override
public void updateTambahSaldo(String pUsername, int pValue) {
    String sql = "UPDATE member_studio_musik SET saldo_member = ? WHERE username_member = ?";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql, new Object[] { pValue, pUsername });
}

---

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

@Override
public void updateDataMember(Member pT) {
    String sql = "UPDATE member_studio_musik SET " + "ttl_member = to_date(?, 'dd-MON-yyyy'), "
            + "tempat_lahir_member = ?, " + "alamat_member = ?, " + "no_telp_member = ?, "
            + "email_member = ?, " + "password_member = ? " + "WHERE username_member = ?";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql,
            new Object[] { pT.getmTempatTanggalLahir(), pT.getmTempatLahirMember(), pT.getmAlamatMember(),
                    pT.getmNomorTelepon(), pT.getmEmailMember(), pT.getmPaswordMember(),
                    pT.getmUsernameMember() });
}

---

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  . ja  va 2s  . co m*/
            ps.setString(index, aCard.getPtText());
            index++;
            ps.setInt(index, aCard.getDeckId());
        }
    });
}

---

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

public int insert(final Deck aDeck) {
    int rc = -1;//from  ww w. j  a va2  s.  com
    String sql = "INSERT INTO decks (name, description) VALUES (?,?)";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(sql, new PreparedStatementSetter() {
        public void setValues(PreparedStatement ps) throws SQLException {
            int index = 1;
            ps.setString(index, aDeck.getName());
            index++;
            ps.setString(index, aDeck.getDescription());
        }
    });

    // There are database specific ways to retrieve the id 
    // for the last inserted row(e.g., last_insert_id() in 
    // mysql. Using MAX(id) because I want to be able to use
    // different data sources. See Stackoverflow for limitations
    // on this approach. 
    // http://stackoverflow.com/questions/4734589/retrieve-inserted-row-id-in-sql/4734672
    rc = jdbcTemplate.queryForInt("SELECT MAX(_id) from decks");
    return rc;
}

---

From source file:uta.ak.usttmp.dmcore.service.impl.MiningTaskServiceImpl.java

protected long doCreateSingleMiningTask(MiningTask mt) {

    if (checkDuplTask(mt.getName())) {
        throw new IllegalArgumentException("The name of mining task is duplicated.");
    }//  w ww . j a  va2s .co  m

    final String insertSql = "INSERT INTO `c_miningtask` ( " + "   `name`, " + "   `starttime`, "
            + "   `endtime`, " + "   `mininginterval`, " + "   `status`, " + "   `tag`, "
            + "   `qrtz_job_exec_count`, " + "   `qrtz_job_total_count`," + "   `topic_num`,"
            + "   `keyword_num`," + "   `alpha`," + "   `beta`," + "   `preprocess_component`,"
            + "   `mining_component`," + "   `tracking_component`" + ") " + "VALUES " + "   ( " + "      ?, "
            + "      ?, " + "      ?, " + "      ?, " + "      ?, " + "      ?, " + "      ?, " + "      ?, "
            + "      ?, " + "      ?, " + "      ?, " + "      ?, " + "      ?, " + "      ?, " + "      ? )";

    SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

    KeyHolder keyHolder = new GeneratedKeyHolder();
    JdbcTemplate jt = this.getJdbcTemplate();

    jt.update(new PreparedStatementCreator() {
        public PreparedStatement createPreparedStatement(Connection con) throws SQLException {
            PreparedStatement pst = con.prepareStatement(insertSql, new String[] { "mme_eid" });
            pst.setString(1, mt.getName());
            pst.setString(2, formatter.format(mt.getStartTime()));
            pst.setString(3, formatter.format(mt.getEndTime()));
            pst.setInt(4, mt.getMiningInterval());
            pst.setInt(5, MiningTask.STATUS_NOT_STARTED);
            pst.setString(6, mt.getTag());
            pst.setInt(7, 0);
            pst.setInt(8, mt.getQrtzJobTotalCount());
            pst.setInt(9, mt.getTopicNum());
            pst.setInt(10, mt.getKeywordNum());
            pst.setDouble(11, mt.getAlpha());
            pst.setDouble(12, mt.getBeta());
            pst.setString(13, mt.getPreprocessComponent());
            pst.setString(14, mt.getMiningComponent());
            pst.setString(15, mt.getTrackingComponent());
            return pst;
        }
    }, keyHolder);

    long taskId = (long) keyHolder.getKey();

    return taskId;
}

---

From source file:gov.nih.nci.ncicb.cadsr.bulkloader.util.BulkLoaderUnclassifier.java

private void runDeleteQry(String qry, final Object[] args) {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.update(qry, new PreparedStatementSetter() {

        @Override//from  w ww  .  j  a  va 2  s . c om
        public void setValues(PreparedStatement ps) throws SQLException {
            for (int i = 0; i < args.length; i++) {
                Object o = args[i];
                if (o instanceof String) {
                    ps.setString(i + 1, (String) o);
                } else if (o instanceof Integer) {
                    ps.setInt(i + 1, (Integer) o);
                } else if (o instanceof Double) {
                    ps.setDouble(i + 1, (Double) o);
                }
            }
        }

    });
}

---

From source file:ca.nrc.cadc.cred.server.CertificateDAO.java

public void delete(String hashKey) {
    Profiler profiler = new Profiler(this.getClass());
    String sql = "delete from " + config.getTable() + " where hash_dn = ? ";
    JdbcTemplate jdbc = new JdbcTemplate(config.getDataSource());
    jdbc.update(sql, new String[] { hashKey });
    profiler.checkpoint("delete");
}

---

From source file:edu.jhuapl.openessence.web.util.MapQueryUtil.java

public int performDelete(OeDataEntrySource mapLayerDataEntrySource, Object current_time,
        String postgresCleanup) {
    JdbcTemplate pgdb = new JdbcTemplate(mapDataSource);
    String sql = "delete from " + mapLayerDataEntrySource.getTableName()
            + " where ? > time_requested + interval '" + postgresCleanup + "'";
    log.debug(sql);//from  w w  w  .  j a  v  a 2  s.c  o  m
    return pgdb.update(sql, current_time);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• »