//UserController package com.zhongruan.controller;
import com.zhongruan.bean.User; import com.zhongruan.service.IUserService; import com.zhongruan.service.impl.UserService; 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("main"); }else { modelAndView.setViewName("../failer"); } 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; } @RequestMapping("/Update.do") public String Update(User user){ userService.Update(user); return "redirect:findAll.do"; }}
//UserDao package com.zhongruan.dao;
import com.zhongruan.bean.User;
import java.util.List;
public interface UserDao { User findUserByUserName(String username);
List<User> findAll(); void deleteById(int id); void add(User user); User selectById(int id); void Update(User user);}
//UserService package com.zhongruan.service.impl;
import com.zhongruan.bean.User; import com.zhongruan.dao.UserDao; import com.zhongruan.service.IUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;
import java.util.List;
@Service public class UserService implements IUserService {
@Autowired private UserDao userDao; @Override public boolean login(String username, String password) { User user = userDao.findUserByUserName(username); if (user!=null && user.getPassword().equals(password)){ return true; } return false; } @Override public List<User> findAll() { return userDao.findAll(); } @Override public void deleteById(int id) { userDao.deleteById(id); } @Override public void add(User user) { userDao.add(user); } @Override public User selectUserById(int id) { return userDao.selectById(id); } @Override public void Update(User user) { userDao.Update(user); }}
//IUserService package com.zhongruan.service;
import com.zhongruan.bean.User;
import java.util.List;
public interface IUserService { boolean login(String username,String password);
List<User> findAll(); void deleteById(int id); void add(User user); User selectUserById(int id); void Update(User user);}
//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" > select * from wzbc1 where username=#{username} <select id="findAll" resultType="user"> select * from wzbc1 </select> <delete id="deleteById" parameterType="int"> delete from wzbc1 where id = #{id} </delete> <insert id="add" parameterType="user"> insert into wzbc1 (id,username,password) values (#{id},#{username},#{password}) </insert> <select id="selectById" parameterType="int" resultType="user"> select * from wzbc1 where id=#{id} </select> <update id="Update" parameterType="user"> update wzbc1 set id=#{id}, username=#{username}, password=#{password} where id= #{id}