@Override public PreparedStatement createPreparedStatement(Connection con) throws SQLException { PreparedStatement stmt = con.prepareStatement(select, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE); //Set the values ArgumentPreparedStatementSetter setter = new ArgumentPreparedStatementSetter(args); setter.setValues(stmt); return stmt; } }
@Override public PreparedStatement createPreparedStatement(Connection con) throws SQLException { if(ids.size() != 1) throw new RuntimeException("Wrong base query."); List<Object> args = new ArrayList<>(); String sql = ANNOTATED_POINT_ID_VALUE_SELECT + " where pv.dataPointId = ? and pv.ts < ? order by pv.ts desc"; args.add(ids.get(0)); args.add(before); if(limit != null) { sql += " limit ?"; args.add(limit); } PreparedStatement stmt = con.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); ArgumentPreparedStatementSetter setter = new ArgumentPreparedStatementSetter(args.toArray(new Object[args.size()])); setter.setValues(stmt); return stmt; }
@Override public PreparedStatement createPreparedStatement(Connection con) throws SQLException { if(ids.size() != 1) throw new RuntimeException("Wrong base query."); List<Object> args = new ArrayList<>(); String sql = ANNOTATED_POINT_ID_VALUE_SELECT + " where pv.dataPointId = ? and pv.ts >= ? and pv.ts<? order by pv.ts asc"; args.add(ids.get(0)); args.add(from); args.add(to); if(limit != null) { sql += " limit ?"; args.add(limit); } PreparedStatement stmt = con.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); ArgumentPreparedStatementSetter setter = new ArgumentPreparedStatementSetter(args.toArray(new Object[args.size()])); setter.setValues(stmt); return stmt; }
public RowIterator(DataSource ds, RowMapper<T> rowMapper, String query, Object... params) { try { this.rowMapper = rowMapper; this.con = ds.getConnection(); this.st = con.prepareStatement(query, java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); if (params != null && params.length > 0) new ArgumentPreparedStatementSetter(params).setValues(st); this.rs = st.executeQuery(); } catch (SQLException e) { close(); throw new RuntimeException(e); } }
@Override public PreparedStatement createPreparedStatement(Connection con) throws SQLException { if(ids.size() == 1) return super.createPreparedStatement(con); List<Object> args = new ArrayList<>(); String dataPointIds = createDelimitedList(ids, ",", null); String sql = ANNOTATED_POINT_ID_VALUE_SELECT + " where pv.dataPointId in (" + dataPointIds + ") and pv.ts < ? order by pv.ts desc"; args.add(before); if(limit != null) { sql += " limit ?"; args.add(limit); } PreparedStatement stmt = con.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); ArgumentPreparedStatementSetter setter = new ArgumentPreparedStatementSetter(args.toArray(new Object[args.size()])); setter.setValues(stmt); return stmt; } }
@Override public PreparedStatement createPreparedStatement(Connection con) throws SQLException { if(ids.size() == 1) return super.createPreparedStatement(con); List<Object> args = new ArrayList<>(); String dataPointIds = createDelimitedList(ids, ",", null); String sql = ANNOTATED_POINT_ID_VALUE_SELECT + " WHERE pv.dataPointId in (" + dataPointIds + ") AND pv.ts >= ? AND pv.ts<? ORDER BY pv.ts ASC"; args.add(from); args.add(to); if(limit != null) { sql += " limit ?"; args.add(limit); } PreparedStatement stmt = con.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); ArgumentPreparedStatementSetter setter = new ArgumentPreparedStatementSetter(args.toArray(new Object[args.size()])); setter.setValues(stmt); return stmt; } }
setter.setValues(ps);
public PreparedStatement createPreparedStatement(Connection con) throws SQLException { PreparedStatement ps = con.prepareStatement(boundSql.getSql(), new String[] { pkColumn }); ArgumentPreparedStatementSetter pss = new ArgumentPreparedStatementSetter(boundSql.getParameters() .toArray()); pss.setValues(ps); return ps; } }, keyHolder);