一、重载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;
}
}
);
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("update cas_user set pass=? where sfz=?",new PreparedStatementSetter(){
public void setValues(PreparedStatement ps) throws SQLException ...{
ps.setString(1,"456");
ps.setString(2,"510……");
}
});
public void setValues(PreparedStatement ps) throws SQLException ...{
ps.setString(1,"456");
ps.setString(2,"510……");
}
});
三、编写sql语句
jdbcTemplate.update("insert into user (username,age) "+"values (' " + username + " ', " +age +")");