基于ssm框架用Idea写的简单的登录、增删改查（四）

本篇继之前的内容： 篇三

删除不需要中间的跳转页，所以没有jsp页面。

接口IUserDao

添加了一个delete接口

package com.hcq.dao;

import com.hcq.bean.TbUser;
import com.hcq.page.Page;

import java.util.List;

public interface IUserDao {
    List<TbUser> findAll();
    void add(TbUser user);
    void delete(int id);
    List<TbUser> list(Page page);
    int total();
}

接口IUserService

package com.hcq.service;

import com.hcq.bean.TbUser;
import com.hcq.page.Page;

import java.util.List;

public interface IUserService {
    List<TbUser> findAll();
    void add(TbUser user);
    void delete(int id);
    List<TbUser> list(Page page);
    int total();
}

UserServiceImpl类

package com.hcq.service.impl;

import com.hcq.bean.TbUser;
import com.hcq.dao.IUserDao;
import com.hcq.page.Page;
import com.hcq.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.*;
@Service
public class UserServiceImpl implements IUserService {
    @Autowired
    private IUserDao userDao;
    @Override
    public List<TbUser> findAll() {
        return userDao.findAll();
    }
   
    @Override
    public void add(TbUser user) {
        userDao.add(user);
    }
   
    @Override
    public void delete(int id) {
        userDao.delete(id);
    }
   
    @Override
    public List<TbUser> list(Page page) {
        return userDao.list(page);
    }

    @Override
    public int total() {
        return userDao.total();
    }
}

TbUserMapper.xml映射文件

<?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.hcq.dao.IUserDao" >

    <!--查询所有-->
    <select id="findAll" resultType="com.hcq.bean.TbUser">
        select * from tb_user
    </select>
    
    <!--添加-->
    <insert id="add" parameterType="com.hcq.bean.TbUser">
        insert into tb_user(id,username,password) values (#{id},#{username},#{password})
    </insert>
   
    <!--删除-->
    <delete id="delete" parameterType="int">
        delete from tb_user where id=#{id}
    </delete>

    <select id="list" resultType="com.hcq.bean.TbUser">
        select * from tb_user
        <if test="start!=null and count!=null">
            limit #{start},#{count}
        </if>
    </select>

    <select id="total" resultType="int">
        select count(*) from tb_user
    </select>
</mapper>

UserController类

package com.hcq.controller;

import com.hcq.bean.TbUser;
import com.hcq.page.Page;
import com.hcq.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 javax.persistence.Id;
import javax.servlet.http.HttpServletRequest;
import javax.swing.*;
import java.util.List;

@RequestMapping("user")
@Controller
public class UserController {
    @Autowired
    IUserService userService;

    @RequestMapping("findAll.do")
    public ModelAndView findAll(){
        List<TbUser> users = userService.findAll();
        ModelAndView mv = new ModelAndView();
        mv.addObject("us",users);
        mv.setViewName("allUser");
        return mv;
    }

    @RequestMapping("add.do")
    public String add(TbUser user){
        if (user != null){
            userService.add(user);
        }
        return "redirect:list.do";
    }
    
    @RequestMapping("delete.do")
    public String delete(int id){
        userService.delete(id);
        return "redirect:list.do";
    }

    @RequestMapping("list.do")
    public ModelAndView list(Page page){
        ModelAndView mv = new ModelAndView();
        List<TbUser> users = userService.list(page);
        int total = userService.total();
        page.calculateLast(total);
        mv.addObject("cs",users);
        mv.setViewName("allUser");
        return mv;
    }

    @RequestMapping("toList.do")
    public String toList(HttpServletRequest request){
        List<TbUser> list = userService.findAll();
        for (TbUser user : list){
            if (user.getUsername().equals(request.getParameter("username"))&&user.getPassword().equals(request.getParameter("password"))){
                return "redirect:list.do";
            }
        }
        JOptionPane.showMessageDialog(null, "用户名或密码错误！请重新登录", "认证失败！", JOptionPane.ERROR_MESSAGE);
        return "../index";
    }
}