List of usage examples for org.springframework.jdbc.core PreparedStatementCreator PreparedStatementCreator
PreparedStatementCreator
From source file:com.nortal.petit.core.dialect.PostgreSqlDialect.java
@SuppressWarnings("unchecked") @Override/*w w w.j av a 2s . co m*/ public <B> B insertReturningId(JdbcOperations jdbcOperations, final String sql, String idColumn, final Object... params) { KeyHolder keyHolder = new GeneratedKeyHolder(); jdbcOperations.update(new PreparedStatementCreator() { @Override public PreparedStatement createPreparedStatement(Connection con) throws SQLException { PreparedStatement ps = con.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS); Object[] queryParams = params.length == 1 && params[0] instanceof Object[] ? (Object[]) params[0] : params; ArgPreparedStatementSetter.setValues(ps, queryParams, 1); return ps; } }, keyHolder); return (B) keyHolder.getKeys().get(idColumn); }
From source file:net.freechoice.model.orm.Map_Tag.java
@Override public PreparedStatementCreator createInsert(final FC_Tag tag) { return new PreparedStatementCreator() { @Override/*from w ww .j ava2 s. c o m*/ public PreparedStatement createPreparedStatement(Connection con) throws SQLException { PreparedStatement ps = con.prepareStatement("insert into FC_Tag(content)" + " values(?)", RET_ID); ps.setString(1, tag.content); return ps; } }; }
From source file:com.ccoe.build.dal.RawDataJDBCTemplate.java
public int create(final Plugin plugin, final int sessionID, final int projectID) { final String SQL = "insert into RBT_RAW_DATA (plugin_id, session_id, " + "project_id, duration, event_time, plugin_key) values (?, ?, ?, ?, ?, ?)"; KeyHolder keyHolder = new GeneratedKeyHolder(); jdbcTemplateObject.update(new PreparedStatementCreator() { public PreparedStatement createPreparedStatement(Connection connection) throws SQLException { PreparedStatement ps = connection.prepareStatement(SQL, new String[] { "id" }); ps.setInt(1, plugin.getId()); ps.setInt(2, sessionID);// w w w . j ava 2 s. com ps.setInt(3, projectID); ps.setLong(4, plugin.getDuration()); ps.setTimestamp(5, new java.sql.Timestamp(plugin.getStartTime().getTime())); ps.setString(6, plugin.getGroupId() + ":" + plugin.getArtifactId()); return ps; } }, keyHolder); return keyHolder.getKey().intValue(); }
From source file:net.freechoice.dao.impl.DaoTag.java
@Warning(values = { "Injection" }) @Override/*from w w w. j a v a 2s . c om*/ public List<FC_Tag> getTagsByName(final String name) { return getJdbcTemplate().query(new PreparedStatementCreator() { @Override public PreparedStatement createPreparedStatement(Connection con) throws SQLException { PreparedStatement ps = con .prepareStatement(SELECT_FROM_FC_TAG + " where is_valid = true and content = ?"); ps.setString(1, name); return ps; } }, mapper); }
From source file:com.apress.prospringintegration.springenterprise.stocks.dao.jdbc.JdbcTemplateStockDao.java
@Override public void update(final Stock stock) { jdbcTemplate.update(new PreparedStatementCreator() { public PreparedStatement createPreparedStatement(Connection connection) throws SQLException { String sql = "UPDATE STOCKS SET SYMBOL = ?, INVENTORY_CODE = ?, " + "PRICE_PER_SHARE = ?, QUANTITY_AVAILABLE = ?, " + "EXCHANGE_ID = ?, PURCHASE_DATE = ? where ID = ?"; PreparedStatement ps = connection.prepareStatement(sql); ps.setString(1, stock.getSymbol()); ps.setString(2, stock.getInventoryCode()); ps.setFloat(3, stock.getSharePrice()); ps.setFloat(4, stock.getQuantityAvailable()); ps.setString(5, stock.getExchangeId()); ps.setDate(6, new java.sql.Date(stock.getPurchaseDate().getTime())); ps.setInt(7, stock.getId()); return ps; }//from w w w.j a v a 2 s . c o m }); }
From source file:net.freechoice.model.orm.Map_Account.java
@Override public PreparedStatementCreator createUpdate(final FC_Account entity) { return new PreparedStatementCreator() { @Override//from ww w. j av a 2 s . c om public PreparedStatement createPreparedStatement(Connection con) throws SQLException { PreparedStatement ps = con.prepareStatement( "update FC_Account set id_user_= ? " + ",balance = ? " + " where id = ? "); ps.setInt(1, entity.id_user_); ps.setBigDecimal(2, entity.balance); ps.setInt(3, entity.id); return ps; } }; }
From source file:com.ccoe.build.dal.SessionJDBCTemplate.java
public int create(final Session session) { final String SQL = "insert into RBT_SESSION (pool_name, machine_name, user_name, environment, " + "status, duration, maven_version, goals, start_time, git_url, git_branch, jekins_url, java_version, cause, full_stacktrace, category, filter) " + "values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; KeyHolder keyHolder = new GeneratedKeyHolder(); jdbcTemplateObject.update(new PreparedStatementCreator() { public PreparedStatement createPreparedStatement(Connection connection) throws SQLException { PreparedStatement ps = connection.prepareStatement(SQL, new String[] { "id" }); ps.setString(1, session.getAppName()); ps.setString(2, session.getMachineName()); ps.setString(3, session.getUserName()); ps.setString(4, session.getEnvironment()); ps.setString(5, session.getStatus()); ps.setLong(6, session.getDuration()); ps.setString(7, session.getMavenVersion()); ps.setString(8, session.getGoals()); ps.setTimestamp(9, new java.sql.Timestamp(session.getStartTime().getTime())); ps.setString(10, session.getGitUrl()); ps.setString(11, session.getGitBranch()); ps.setString(12, session.getJenkinsUrl()); ps.setString(13, session.getJavaVersion()); ps.setString(14, getCause(session.getExceptionMessage())); setFullStackTraceAsClob(15, ps, session); ps.setString(16, session.getCategory()); ps.setString(17, session.getFilter()); return ps; }/* w w w. ja v a 2s .co m*/ }, keyHolder); return keyHolder.getKey().intValue(); }
From source file:com.baidu.rigel.demo.dao.BaseDao.java
/** * Insert and get key.//from w w w . ja v a2 s.c o m * * @param sql * the sql * @param params * the params * @return the object */ public Object insertAndGetKey(final String sql, final Object... params) { final KeyHolder key = new GeneratedKeyHolder(); simpleJdbcTemplate.getJdbcOperations().update(new PreparedStatementCreator() { public PreparedStatement createPreparedStatement(Connection con) throws SQLException { PreparedStatement ps = con.prepareStatement(sql, PreparedStatement.RETURN_GENERATED_KEYS); PreparedStatementSetter pss = new ArgPreparedStatementSetter(params); try { if (pss != null) { pss.setValues(ps); } } finally { if (pss instanceof ParameterDisposer) { ((ParameterDisposer) pss).cleanupParameters(); } } return ps; } }, key); return key.getKey(); }
From source file:com.ewcms.component.interaction.dao.InteractionDAO.java
@Override public Integer addInteraction(final Interaction vo) { final String sql = "Insert Into plugin_interaction " + "(username,title,content,replay,type,state,checked,organ_id,ip,name,organ_name,tel) " + "Values (?,?,?,?,?,?,?,?,?,?,?,?)"; jdbcTemplate.update(new PreparedStatementCreator() { @Override//w w w. j a v a 2 s .c o m public PreparedStatement createPreparedStatement(Connection con) throws SQLException { PreparedStatement ps = con.prepareStatement(sql); ps.setString(1, vo.getUsername()); ps.setString(2, vo.getTitle()); ps.setString(3, vo.getContent()); ps.setString(4, vo.getReplay()); ps.setInt(5, vo.getType()); ps.setInt(6, vo.getState().ordinal()); ps.setBoolean(7, vo.getChecked()); ps.setInt(8, vo.getOrgan().getId()); ps.setString(9, vo.getIp()); ps.setString(10, vo.getName()); ps.setString(11, vo.getOrgan().getName()); ps.setString(12, vo.getTel()); return ps; } }); return jdbcTemplate.queryForInt("select currval('seq_plugin_interaction_id')"); }
From source file:org.perconsys.dao.implement.CommentDb.java
@Override public Comment create(final Comment comm) { KeyHolder keyh = new GeneratedKeyHolder(); final Long target = comm.getTargetId() == 0 ? null : comm.getTargetId(); final String sql = "insert into blogs (`title`, `content`, `post_id`, `user_id`, `target_id`, `date`) " + "value (?, ?, ?, ?, ?, now()) ;"; getJdbcTemplate().update(new PreparedStatementCreator() { @Override//from ww w . ja v a2 s . co m public PreparedStatement createPreparedStatement(Connection conn) throws SQLException { PreparedStatement pstat = conn.prepareStatement(sql, new String[] { "id" }); pstat.setString(1, comm.getTitle()); pstat.setString(2, comm.getContent()); pstat.setLong(3, comm.getPostId()); pstat.setLong(4, comm.getUser().getId()); pstat.setLong(5, target); return pstat; } }, keyh); Long id = (Long) keyh.getKey(); comm.setId(id); return comm; }