import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;
publicclassTest {publicstaticvoidmain(String[] args) {
ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
JdbcTemplate jt = (JdbcTemplate) ac.getBean("jdbcTemplate");
//增加
String sql1 = "insert into students(id, name, clazz) values(?, ?, ?)";
jt.update(sql1, "160341237", "詹金浩", "1234");
//删除
String sql2 = "delete from students where id = ?";
jt.update(sql2, "160341237");
//修改
String sql3 = "update students set name = ? where id = ?";
jt.update(sql3, "ccc", "aaa");
}
}
查询-返回值类型为基本数据类型
String sql4 = "select name from students where id = ?";
String name = jt.queryForObject(sql4, String.class, "aaa");
System.out.println(name);
查询-返回值类型为单一对象
String sql4 = "select * from students where id = ?";
Student student = jt.queryForObject(sql4, new RowMapper<Student>() {
public Student mapRow(ResultSet rs, int arg1) throws SQLException {
Student s = new Student();
s.setId(rs.getString("id"));
s.setName(rs.getString("name"));
s.setClazz(rs.getString("clazz"));
return s;
}
}, "aaa");
System.out.println(student);
查询-返回值类型为集合
String sql4 ="select * from students where clazz = ?";
List<Student> students = jt.queryForObject(sql4, new RowMapper<List<Student>>() {
publicList<Student> mapRow(ResultSet rs, int arg1) throws SQLException {
List<Student> l =new ArrayList<>();
Student s=new Student();
while(rs.next()) {
s.setId(rs.getString("id"));
s.setName(rs.getString("name"));
s.setClazz(rs.getString("clazz"));
l.add(s);
}
return l;
}
}, "160341B");
System.out.println(students);