@Override public void setValues(PreparedStatement ps, int i) throws SQLException { ps.setString(1, items.get(i).getFirstname()); ps.setString(2, items.get(i).getLastname()); ps.setDate(3, new Date(items.get(i).getBirth().getTime())); }
@Override public void setValues(PreparedStatement ps, int i) throws SQLException { ps.setString(1, items.get(i).getFirstname()); ps.setString(2, items.get(i).getLastname()); ps.setDate(3, new Date(items.get(i).getBirth().getTime())); }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForObject("select contact_seq.nextval from dual",Long.class).longValue(); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); Thread.sleep(10); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForObject("select contact_seq.nextval from dual",Long.class).longValue(); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); Thread.sleep(10); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForObject("select contact_seq.nextval from dual",Long.class).longValue(); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForObject("select contact_seq.nextval from dual",Long.class).longValue(); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForObject("select contact_seq.nextval from dual",Long.class).longValue(); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForObject("select contact_seq.nextval from dual",Long.class).longValue(); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForObject("select contact_seq.nextval from dual",Long.class).longValue(); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForObject("select contact_seq.nextval from dual",Long.class).longValue(); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForObject("select contact_seq.nextval from dual",Long.class).longValue(); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForObject("select contact_seq.nextval from dual",Long.class).longValue(); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { jdbcTemplate.update( "insert into contact (firstname,lastname,birth) values (?,?,?)", item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { jdbcTemplate.update( "insert into contact (firstname,lastname,birth) values (?,?,?)", item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { jdbcTemplate.update( "insert into contact (firstname,lastname,birth) values (?,?,?)", item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { jdbcTemplate.update( "insert into contact (firstname,lastname,birth) values (?,?,?)", item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForLong("select contact_seq.nextval from dual"); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { Long id = jdbcTemplate.queryForLong("select contact_seq.nextval from dual"); jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth) values (?,?,?,?)", id,item.getFirstname(),item.getLastname(),item.getBirth() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth,ssn) values (?,?,?,?,?)", item.getId(),item.getFirstname(),item.getLastname(),item.getBirth(),item.getSsn() ); } }
@Override public void write(List<? extends Contact> items) throws Exception { for(Contact item : items) { jdbcTemplate.update( "insert into contact (id,firstname,lastname,birth,ssn) values (?,?,?,?,?)", item.getId(),item.getFirstname(),item.getLastname(),item.getBirth(),item.getSsn() ); } }