Spring JdbcTemplate实现update或insert

三种使用Spring JdbcTemplate实现update或insert操作

?

?

第一种方式，重载PreparedStatementCreator

jdbcTemplate.update(new PreparedStatementCreator(){

????public PreparedStatement createPreparedStatement(Connection conn){

???????? String sql="insert into user (name,age) values(?,?)";

???????? PreparedStatement ps=con.prepareStatement(sql);

???????? ps.setString(1,name);

???????? ps.setInt(2,age);

????????return ps;

???? }

}

);

第二种方式，重载PreparedStatementSetter

jdbcTemplate.update("insert into user(name,age) values(?,?)",new PreparedStatementSetter(){

??????public void setValues(PreparedStatement ps) throws SQLException {

??????????? ps.setString(1,name);

??????????? ps.setInt(2,age);

??????? }

});

//jdbcTemplate会自动创建PreparedStatementCreator实例，以提供传递给setValues方法的ps对象

第三种方式，直接使用SQL

jdbcTemplate.update("insert into user (name,age) "+"values (' " + name + " ', " +age +")");

?

?

//批量更新

public void insertBooks(List<Book> book)

{

final List<Book> tempBook=book;

String sql="insert into book(name,pbYear) values(?,?)";

jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter()

{

public void setValues(PreparedStatement ps,int i)throws SQLException

{

String name=tempBook.get(i).getName();

int pbYear=tempBook.get(i).getPbYear();

ps.setString(1, name);

ps.setInt(2, pbYear);

}

public int getBatchSize()

{

return 25;

}

});

}