一、增加功能
继上一篇查询的案例做增加功能,在UserDaoImpl加入add方法:
//增加功能
public boolean add(User user) {
String sql = "insert into users (username,psd) values(?,?)";
int row = template.update(sql, user.getUsername(), user.getPsd());
return row == 1;
}
测试类:
@Test
public void Springtest() {
BeanFactory factory = new ClassPathXmlApplicationContext("applicationContext.xml");
//获取dao对象
UserDaoImpl dao = (UserDaoImpl) factory.getBean("dao");
//调用dao方法
dao.add(new User(1, "Peter", "456789"));
List<User> list = dao.findAll();
//查询数据并输出
for (User u:list) {
System.out.println(u);
}
}
输出结果:
二、删除功能
在UserDaoImpl中编写delete方法:
//删除功能,根据所给uid删除对应数据
public boolean delete(int uid) {
String sql = "delete from users where uid = ?";
int row = template.update(sql, uid);
return row == 1;
}
测试类:
@Test
public void Springtest() {
BeanFactory factory = new ClassPathXmlApplicationContext("applicationContext.xml");
//获取dao对象
UserDaoImpl dao = (UserDaoImpl) factory.getBean("dao");
//调用dao方法
dao.delete(4);
List<User> list = dao.findAll();
//查询数据并输出
for (User u : list) {
System.out.println(u);
}
}
输出结果,课件uid=4的Peter被删除了:
三、更改功能
在UserDaoImpl中编写update方法:
//更改功能
public boolean update(User user) {
String sql = "update users set username=?,psd=? where uid=?";
int row = template.update(sql, user.getUsername(), user.getPsd(), user.getUid());
return row == 1;
}
测试类:
@Test
public void Springtest() {
BeanFactory factory = new ClassPathXmlApplicationContext("applicationContext.xml");
//获取dao对象
UserDaoImpl dao = (UserDaoImpl) factory.getBean("dao");
//调用dao方法
dao.update(new User(1, "二郎神", "AAA123"));
List<User> list = dao.findAll();
//查询数据并输出
for (User u : list) {
System.out.println(u);
}
}
输出结果: