实现对user表的显示（查询全部）、新增、修改、删除【ssm框架】

实现对user表的显示（查询全部）、新增、修改、删除【ssm框架】

bean层

Userbean（类）

package com.whut.bean;

import javax.ws.rs.GET;

//实体层模型

public class User {

    private int id;
    private  String username;
    private  String password;

    //get set
    /**
     *
     *
     *
     */
    public int getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    //构造方法  实体化里传值

    public User(int id, String username, String password) {
        this.id = id;
        this.username = username;
        this.password = password;
    }

    public User() {
    }
    //toString

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

dao层

Userdao（接口）

package com.whut.dao;

import com.whut.bean.User;

import java.util.List;

//接口，与数据库直接接触
public interface Userdao {

    //查询全部
    List<User> findAllUser();

    //新增
    void addUser(User user);

    //修改前查询
    User findUpdUserById(int id);

    //修改
    void  UpdUserById(User user);

    //删除
    void  deleteUser(User user);

    //模糊查询
//    List<User> findLikeUser(String )


}

impl（实现：sql语句；usermapper.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.whut.dao.Userdao" >

    <!--查询全部-->
    <select id="findAllUser" resultType="com.whut.bean.User" >
        select  * from td_user

    </select>

      <!--新增-->
    <select id="addUser" parameterType="com.whut.bean.User">
        insert into td_user(id,username,password) value (#{id},#{username},#{password})
    </select>
    <!--修改前的查询-->
     <select id="findUpdUserById" parameterType="java.lang.Integer" resultType="com.whut.bean.User">
         select  * from td_user where id=#{id}

     </select>

    <!--修改-->
    <update id="UpdUserById" parameterType="com.whut.bean.User">
        update td_user set username=#{username},password=#{password} where id=#{id}
    </update>

    <!--删除-->
    <delete id="deleteUser" parameterType="com.whut.bean.User">
        delete  from  td_user where id =#{id}
    </delete>

</mapper>

service层

Userservice（接口）

package com.whut.service;

import com.whut.bean.User;

import java.util.List;

//业务逻辑层
public interface Userservice {

    //查询全部
    List<User> findAllUser();

    void  addUser(User user);

     //修改前查询
    User findUpdUserById(int id);

    void UpdUserById(User user);
    //删除
    void deleteUser(User user);
}

Userserviceimpl（类）

package com.whut.service.impl;

//实现层

import com.whut.bean.User;
import com.whut.dao.Userdao;
import com.whut.service.Userservice;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class UserServIceimpl implements Userservice {

    @Autowired
    private Userdao userdao;



    @Override
    public List<User> findAllUser() {
        return userdao.findAllUser();
    }

    @Override
    public void addUser(User user) {
       userdao.addUser(user);
    }

    @Override
    public User findUpdUserById(int id) {
        return  userdao.findUpdUserById(id);
    }

    @Override
    public void UpdUserById(User user) {
        userdao.UpdUserById(user);
    }

    @Override
    public void deleteUser(User user) {
        userdao.deleteUser(user);
    }
}

controller层

Usercontroller（类）

package com.whut.contoller;

import com.whut.bean.User;
import com.whut.service.Userservice;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.swing.*;
import java.util.List;

//
@Controller
@RequestMapping("user")
public class Usercontrollerr {

    @Autowired
    private Userservice userservice;

    //查询所有
    @RequestMapping("findAllUser.do")
    public ModelAndView findAllUser(){

        //调用service层方法，查询结果
        List<User> Userlist = userservice.findAllUser();
        //返回值封装到springMVC内置对象Model
        ModelAndView mv=new ModelAndView();

        mv.addObject("userList",Userlist);

        mv.setViewName("user-list");

        return  mv;

    }

    //新增  java.lang.String
    @RequestMapping("/addUser")
    public String addUser(User user)
    {
        //1.调用service方法，得到结果
        userservice.addUser(user);

        return "redirect:findAllUser.do";

    }

    //修改前的查询操作
    @RequestMapping("/findUpdUserById")
    public ModelAndView  findUpdUserById(int id){
        //调用service，得到结果
        User user = userservice.findUpdUserById(id);
        //实例化一个
        ModelAndView mv =new ModelAndView();
//        System.out.println("得到的结果："+user);
        mv.addObject("user",user);

        mv.setViewName("user-update");

        return  mv;
    }

    //修改
    @RequestMapping("/UpdUserById")
    public  String  UpdUserById(User user)
    {
        userservice.UpdUserById(user);

        return "redirect:findAllUser.do";
    }

    @RequestMapping("/deleteUser.do")
    public  String deleteUser(User user)
    {
        userservice.deleteUser(user);
        JOptionPane.showConfirmDialog(null, "是否确定删除该记录？", "删除",JOptionPane.YES_NO_OPTION);
        return "redirect:findAllUser.do";
    }
}

页面

修改对应链接等。