springMVC开发实例
省去配置文件(见上一节)
dao层
IUserDao接口
public interface IUserDao {
public void save(User u);
public void delete(int id);
public List<User> findAll();
}
UserDaoImpl实现类
public class UserDaoImpl extends SqlSessionDaoSupport implements IUserDao {
public void save(User u) {
this.getSqlSession().insert("day01.insertOne", u);
}
public void delete(int id) {
this.getSqlSession().delete("day01.deleteOne", id);
}
public List<User> findAll() {
List<User> users = this.getSqlSession().selectList("day01.selectAll");
return users;
}
}
entity
public class User implements Serializable{
private int id;
private String username;
private String email;
private int age;
省略无参构造和get,set方法
}
handler
@Controller
public class UserHandler {
@Autowired
private IUserService userService;
@RequestMapping(value="list.action")
public ModelAndView list(){
ModelAndView mav = new ModelAndView();
List<User> list = userService.findAll();
mav.addObject("list", list);
mav.setViewName("list");
return mav;
}
@RequestMapping(value="add.action",method={RequestMethod.GET,RequestMethod.POST})
public String add(String username,String email,int age){
User u = new User(username,email,age);
userService.saveUser(u);
return "redirect:/list.action";
}
@RequestMapping(value="delete.action")
public String delete(int id){
userService.deleteUser(id);
return "forward:/list.action";
}
public void setUserService(IUserService userService) {
this.userService = userService;
}
}
mapper
Usermapper
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="day01">
<insert id="insertOne" parameterType="User" useGeneratedKeys="true" keyProperty="id">
insert into user_myc(username,email,age) values(#{username},#{email},#{age})
</insert>
<select id="selectAll" resultType="User">
select * from user_myc
</select>
<delete id="deleteOne" parameterType="int">
delete from user_myc where id=#{value}
</delete>
</mapper>
service
IUserService接口
public interface IUserService {
public void saveUser(User u);
public void deleteUser(int id);
public List<User> findAll();
}
UserServiceImpl
public class UserServiceImpl implements IUserService {
private IUserDao userDao;
public void saveUser(User u) {
System.out.println("userDao="+userDao);
userDao.save(u);
}
public List<User> findAll() {
return userDao.findAll();
}
public void setUserDao(IUserDao userDao) {
this.userDao = userDao;
}
public UserServiceImpl() {
}
public UserServiceImpl( IUserDao userDao) {
this.userDao = userDao;
}
public void deleteUser(int id) {
userDao.delete(id);
}
}