目录

pom.xml

spring配置文件

springmvc配置文件

web.xml

实体类

mapper映射文件

Mapper接口

Service接口

Service实现类

Controller控制层

JSP页面（layui框架）

pom.xml

 
    
    
      com.github.pagehelper
      pagehelper
      5.1.11
    
    
      org.springframework
      spring-tx
      5.2.9.RELEASE
    
    
      org.springframework
      spring-jdbc
      5.2.9.RELEASE
    
    
    
      org.mybatis
      mybatis-spring
      2.0.6
    
    
    
      com.alibaba
      druid
      1.2.4
    
    
    
      org.springframework
      spring-webmvc
      5.2.9.RELEASE
    
    
    
      org.mybatis
      mybatis
      3.5.6
    
    
    
      mysql
      mysql-connector-java
      8.0.26
    
    
    
      org.projectlombok
      lombok
      1.18.22
    
    
    
      com.fasterxml.jackson.core
      jackson-databind
      2.12.4
    
    
    
      javax.servlet
      servlet-api
      2.5
    
    
      javax.servlet.jsp
      jsp-api
      2.2
    
    
    
      log4j
      log4j
      1.2.17
    
    
      org.slf4j
      slf4j-log4j12
      1.7.30
    
  

spring配置文件

spring.xml

    

    
        
        
        
        
        
        
        
        
        
        
    

    
        
        mapper映射文件 
    


  
    
    
    
    
  
  
    id, stu_name, stu_age, stu_sex
  

  
    select 
    
    from student
    where id = #{id,jdbcType=INTEGER}
  

    
      select 
      from student
    

    
    delete from student
    where id = #{id,jdbcType=INTEGER}
  

  
    insert into student (stu_name, stu_age, stu_sex
      )
    values (#{stuName,jdbcType=VARCHAR}, #{stuAge,jdbcType=VARCHAR}, #{stuSex,jdbcType=VARCHAR}
      )
  

  
    insert into student
    
      
        stu_name,
      
      
        stu_age,
      
      
        stu_sex,
      
    
    
      
        #{stuName,jdbcType=VARCHAR},
      
      
        #{stuAge,jdbcType=VARCHAR},
      
      
        #{stuSex,jdbcType=VARCHAR},
      
    
  

  
    update student
    
      
        stu_name = #{stuName,jdbcType=VARCHAR},
      
      
        stu_age = #{stuAge,jdbcType=VARCHAR},
      
      
        stu_sex = #{stuSex,jdbcType=VARCHAR},
      
    
    where id = #{id,jdbcType=INTEGER}
  

  
    update student
    set stu_name = #{stuName,jdbcType=VARCHAR},
      stu_age = #{stuAge,jdbcType=VARCHAR},
      stu_sex = #{stuSex,jdbcType=VARCHAR}
    where id = #{id,jdbcType=INTEGER}
  
 
Mapper接口 
package com.like.dao;

import com.like.entity.Student;

import java.util.List;

public interface StudentDao {

    //对数据库进行删除
    int deleteByPrimaryKey(Integer id);

    //对数据库进行添加
    int insert(Student record);

    //对数据库进行添加
    int insertSelective(Student record);

    //对数据路进行全部查找
    Student selectByPrimaryKey(Integer id);

    //对数据库进行修改
    int updateByPrimaryKeySelective(Student record);

    //对数据库进行修改
    int updateByPrimaryKey(Student record);

    //对数据路进行全部查找
    List selectAll();
}
 
Service接口 
package com.like.service;

import com.like.entity.Student;
import com.like.util.ComResult;
import com.like.util.TableLayui;

public interface StuService {
//    查询所有
    TableLayui findAll();
//    根据ID删除
    ComResult deleteStu(int id);
//    修改
    ComResult updateStu(Student stu);
//    添加
    ComResult insertStu(Student stu);
//    批量删除
    ComResult deleteStu(String  id);
}
 
Service实现类 
package com.like.service.impl;

import com.like.dao.StudentDao;
import com.like.entity.Student;
import com.like.service.StuService;
import com.like.util.ComResult;
import com.like.util.TableLayui;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;


@Service(value = "stuService")
public class StuServiceImpl implements StuService {
    @Autowired
    private StudentDao studentDao;

    public TableLayui findAll() {
        List list = studentDao.selectAll();
        return new TableLayui(0,"",list.size(),list);
    }
    
    public ComResult deleteStu(int id) {
        int i = studentDao.deleteByPrimaryKey(id);
        if(i>0){
            return new ComResult(2000,"删除成功",null);
        }
        return new ComResult(5000,"删除失败",null);
    }

    public ComResult updateStu(Student stu) {
        int i = studentDao.updateByPrimaryKey(stu);
        if(i>0){
            return new ComResult(2000,"修改成功",null);
        }
        return new ComResult(5000,"修改失败",null);
    }

    public ComResult insertStu(Student stu) {
        int i = studentDao.insert(stu);
        if(i>0){
            return new ComResult(2000,"添加成功",null);
        }
        return new ComResult(5000,"添加失败",null);
    }

    public ComResult deleteStu(String id) {
        int i=0;
        String[] ids = id.split(",");
        for (String s : ids) {
            i = studentDao.deleteByPrimaryKey(Integer.parseInt(s));
        }
        if(i>0){
            return new ComResult(2000,"删除成功",null);
        }
        return new ComResult(5000,"删除失败",null);
    }
}
 
Controller控制层 
package com.like.controller;

import com.like.entity.Student;
import com.like.service.StuService;
import com.like.util.ComResult;
import com.like.util.TableLayui;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;


@Controller
@RequestMapping("stu")
public class StuController {
    @Autowired
    private StuService stuService;

    @RequestMapping("list")
    @ResponseBody
    public TableLayui list(){
        return stuService.findAll();

    }

    @RequestMapping("delete")
    @ResponseBody
    public ComResult delete(int id){
        return stuService.deleteStu(id);
    }

    @RequestMapping("update")
    @ResponseBody
    public ComResult update(Student stu){
        Integer id = stu.getId();
        if(id!=null&&id!=0){
            return stuService.updateStu(stu);
        }
        return stuService.insertStu(stu);
    }

    @RequestMapping("checkDel")
    @ResponseBody
    public ComResult deleteAll(String  id){
        return stuService.deleteStu(id);
    }
}
 
JSP页面（layui框架） 
 
修改页面 
 
 添加页面 
 
 
 
<%--
  Created by IntelliJ IDEA.
  User: 深巷少年梦
  Date: 2021/12/11
  Time: 16:00
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>



    
    
    
    
    




    
    
        姓名:
        
            
        
    
    
        出生日期:
        
            
        
    
    
        性别:
        
            
        
    
    
        
            提交