// 查
int rowCount = this.jdbcTemplate.queryForObject(
"select count(*) from user", Integer.class);
int countOfNameJoe = this.jdbcTemplate.queryForObject(
"select count(*) from user where first_name = ?",
Integer.class, "Joe"_);
String lastName = this.jdbcTemplate.queryForObject(
"select last_name from user where id = ?",
new Object[]{1212L}, String.class);
// 增
this.jdbcTemplate.update(
"insert into user (first_name, last_name) values (?, ?)",
"Meimei", "Han");
// 改
this.jdbcTemplate.update(
"update user set last_name = ? where id = ?", "Li", 5276L);
// 删
this.jdbcTemplate.update(
"delete from user where id = ?", Long.valueOf(userId));
// 创建表
this.jdbcTemplate.execute("create table user (id integer,
first_name varchar(100), last_name varchar(100))");
近期评论