1、
execute()方法執(zhí)行SQL語句 jdbcTemplate.execute("CREATE TABLE USER (user_id integer, name varchar(100))");jdbcTemplate.execute("CREATE TABLE USER (user_id integer, name varchar(100))");2、
update()方法執(zhí)行UPDATE或INSERT語句 jdbcTemplate.update("UPDATE USER SET name = ? WHERE user_id = ?",
new Object[] {name, id});
jdbcTemplate.update("INSERT INTO USER VALUES(?, ?, ?, ?)",
new Object[] {user.getId(), user.getName(), user.getSex(), user.getAge()});
或
jdbcTemplate.update("INSERT INTO USER VALUES(?, ?, ?, ?)",
new PreparedStatementSetter() {
public void setValues(PreparedStatement ps) throws SQLException {
ps.setString(1, user.getId());
ps.setString(2, user.getName());
ps.setString(3, user.getSex() );
ps.setInt(4, user.getAge());
}
});
jdbcTemplate.update("INSERT INTO USER VALUES(?, ?, ?, ?)", new Object[] {user.getId(), user.getName(), user.getSex(), user.getAge()});3、
queryForXXX()方法執(zhí)行查詢（
注意返回值）
--內(nèi)部執(zhí)行的是queryForObject(sql, rowMapper)；
//僅有SQL情況
int count = jdbcTemplate.queryForInt("SELECT COUNT(*) FROM USER");
List<Map> rows = jdbcTemplate.queryForList("SELECT * FROM USER");
for(Map userMap:rows){
System.out.print(userMap.get("user_id") + "\t");
System.out.print(userMap.get("name") + "\t");
System.out.print(userMap.get("sex") + "\t");
System.out.println(userMap.get("age") + "\t");
}
//帶參數(shù)的SQL情況，這里name字段類型是字符串
String name = (String) jdbcTemplate.queryForObject("SELECT name FROM USER “
+" WHERE user_id = ?",
new Object[] {id}, java.lang.String.class);
//帶參數(shù)的SQL情況，這里* 類型是POJO類類型 Person p= (Person) jdbcTemplate.queryForObject("select * from person where id = 8",
new RowMapper (){
public Object mapRow(ResultSet rs, int value) throws SQLException {
Person person = new Person ();
person.setId(new Integer(rs.getInt("id")));
person.setUsername(rs.getString("username"));
person.setAge(rs.getString("age"));
return user;
}
});
4、query()方法執(zhí)行查詢
User user = new User();
jdbcTemplate.query("SELECT * FROM USER WHERE user_id = ?",new Object[] {id},
new RowCallbackHandler() {
public void processRow(ResultSet rs) throws SQLException {
user.setId(rs.getString("user_id"));
user.setName(rs.getString("name"));
user.setSex(rs.getString("sex").charAt(0));
user.setAge(rs.getInt("age"));
}
});
final User user = new User();jdbcTemplate.query("SELECT * FROM USER WHERE user_id = ?", new Object[] {id}, new RowCallbackHandler() { public void processRow(ResultSet rs) throws SQLException { user.setId(rs.getString("user_id")); user.setName(rs.getString("name")); user.setSex(rs.getString("sex").charAt(0)); user.setAge(rs.getInt("age")); } });
List<Map> lst = new ArrayList<Map>();
lst = jdbcTemplate.query("SELECT * FROM USER WHERE user_id = ?",new Object[] {id}, new RowMapper(){
public Map mapRow(ResultSet rs, int arg1) throws SQLException {
Map m = new HashMap();
m.put("user_id", rs.getObject("user_id"));
m.put("name", rs.getObject("name"));
m.put("sex", rs.getObject("sex"));
m.put("age", rs.getObject("age"));
return m;
}
});
