UserController
package com.zhongruan.controller; import com.zhongruan.bean.User; import com.zhongruan.service.IUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView; import java.util.List; @Controller @RequestMapping("/user") public class UserController { @Autowired private IUserService userService; @RequestMapping("/login.do") public ModelAndView login(User user){ boolean flag=userService.login(user.getUsername(),user.getPassword()); ModelAndView modelAndView=new ModelAndView(); if(flag){ modelAndView.setViewName("../ok"); }else{ modelAndView.setViewName("../failure"); } return modelAndView; } @RequestMapping("/findAll.do") public ModelAndView findAll(){ List<User> userList=userService.findAll(); ModelAndView modelAndView=new ModelAndView(); modelAndView.addObject("userList",userList); modelAndView.setViewName("user-list"); return modelAndView; } @RequestMapping("/deleteById.do") public String delete(int id){ userService.deleteById(id); return "redirect:findAll.do"; } @RequestMapping("/add.do") public String add(User user){ userService.add(user); return "redirect:findAll.do"; } @RequestMapping("toUpDate.do") public ModelAndView toUpDate(int id){ User user=userService.selectUserById(id); ModelAndView modelAndView=new ModelAndView(); modelAndView.setViewName("user-update"); modelAndView.addObject("user",user); return modelAndView; } }镜像
<?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="com.zhongruan.dao.UserDao" > <select id="findUserNyUserName" parameterMap="String" resultMap="user"> select * from tb_user where username=#{username} </select> <select id="findAll" parameterMap="String" resultMap="user"> select * from tb_user </select> <delete id="deleteById" parameterType="int"> delete from tb_user where id=#(id) </delete> <insert id="add" parameterType="user"> insert into tb_user (username,password) value (#{username},#{password}) </insert> <select id="selectById" parameterType="int" resultType="user"> select * from tb)user where id=#{id} </select> </mapper>