实习22

实习22
结构

user

package com.zhongruan.bean;

public class User {
    private int id;
    private String zh;
    private String mm;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getZh() {
        return zh;
    }

    public void setZh(String zh) {
        this.zh = zh;
    }

    public String getMm() {
        return mm;
    }

    public void setMm(String mm) {
        this.mm = mm;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", zh='" + zh + '\'' +
                ", mm='" + mm + '\'' +
                '}';
    }
}

usercontroller

package com.zhongruan.controller;

import com.github.pagehelper.PageInfo;
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
public class UserController {
    @Autowired
    private IUserService userService;
    @RequestMapping("/findAll.do")
    public ModelAndView findAll(int pageNum,int size){
        List<User> users=userService.findAll(pageNum, size);
        PageInfo<User> pageInfo=new PageInfo<>(users);
        ModelAndView modelAndView=new ModelAndView();
        modelAndView.setViewName("allUser.jsp");
        modelAndView.addObject("pageInfo",pageInfo);
        return modelAndView;
    }
    @RequestMapping("/login.do")
    public String login(User user){
        Boolean num=userService.login(user.getZh(),user.getMm());
        if (num){
            return "redirect:/findAll.do?pageNum=1&size=5";
        }else {
            return "fail.jsp";
        }
    }
    @RequestMapping("/delete.do")
    public String delete(int id){
        userService.delete(id);
        return "redirect:/findAll.do?pageNum=1&size=5";

    }
}

iuserdao

package com.zhongruan.dao;

import com.zhongruan.bean.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface IUserDao {
    List<User> findAll();
    void delete(int id);
}

userservice

package com.zhongruan.service.Impl;

import com.github.pagehelper.PageHelper;
import com.zhongruan.bean.User;
import com.zhongruan.dao.IUserDao;
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 IUserDao userDao;

    @Override
    public Boolean login(String zh, String mm) {
        User user=userDao.jd(zh);
        if (user!=null && mm.equals(user.getMm())){
            return true;
        }else {
            return false;
        }
    }

    @Override
    public List<User> findAll(int pageNum,int size) {
        PageHelper.startPage(pageNum, size);
        return userDao.findAll();
    }

    @Override
    public void delete(int id) {
        userDao.delete(id);
    }
}

iuserservice

package com.zhongruan.service;

import com.zhongruan.bean.User;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.List;

public interface IUserService {
    List<User> findAll(@RequestParam int pageNum,@RequestParam int size);
    void delete(int id);
}

usermapper1

<?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.IUserDao">
    <select id="findAll" resultType="user">
        select * from dr
    </select>
    <select id="delete" parameterType="int">
        delete from dr where id=#{id}
    </select>
    <select id="add" parameterType="String">
        insert into dr(zh,mm) values (#{zh},#{mm})
    </select>
    <select id="update" parameterType="user">
        update dr set zh=#{zh},mm=#{mm} where id=#{id}
    </select>
    <select id="jd" parameterType="String" resultType="com.zhongruan.bean.User">
        select * from dr where zh=#{zh}
    </select>
    <select id="findbyid" parameterType="int" resultType="com.zhongruan.bean.User">
        select * from dr where id=#{id}
    </select>
</mapper>