• SpringMVC之CRUD

    目录

    SpringMVC实现增删改查

    1. 导入相关依赖

     2. 添加配置文件

    3. 逆向生成对应的类

    4. 后台代码编写

     5. 前台代码编写

    SpringMVC实现增删改查

    1. 导入相关依赖

    pom.xml

    1. "1.0" encoding="UTF-8"?>
    2.  
    3. "http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.   4.0.0
    6.  
    7.   org.example
    8.   xisslzy_ssm
    9.   1.0-SNAPSHOT
    10.   war
    11.  
    12.   xisslzy_ssm Maven Webapp
    13.   
    14.   http://www.example.com
    16.   
    17.     UTF-8
    18.     1.8
    19.     1.8
    20.     3.7.0
    22.     
    23.     
    24.     5.0.2.RELEASE
    25.     
    26.     3.4.5
    27.     
    28.     5.1.44
    29.     
    30.     5.1.2
    31.     
    32.     1.3.1
    33.     
    34.     2.1.1
    35.     2.4.3
    36.     
    37.     2.9.1
    38.     
    39.     4.12
    40.     4.0.0
    41.     1.18.2
    42.   
    45.   
    46.     
    47.     
    48.       org.springframework
    49.       spring-context
    50.       ${spring.version}
    51.     
    52.     
    53.       org.springframework
    54.       spring-orm
    55.       ${spring.version}
    56.     
    57.     
    58.       org.springframework
    59.       spring-tx
    60.       ${spring.version}
    61.     
    62.     
    63.       org.springframework
    64.       spring-aspects
    65.       ${spring.version}
    66.     
    67.     
    68.       org.springframework
    69.       spring-web
    70.       ${spring.version}
    71.     
    72.     
    73.       org.springframework
    74.       spring-test
    75.       ${spring.version}
    76.     
    78.     
    79.     
    80.       org.mybatis
    81.       mybatis
    82.       ${mybatis.version}
    83.     
    84.     
    85.     
    86.       mysql
    87.       mysql-connector-java
    88.       ${mysql.version}
    89.     
    90.     
    91.     
    92.       com.github.pagehelper
    93.       pagehelper
    94.       ${pagehelper.version}
    95.     
    96.     
    97.     
    98.       org.mybatis
    99.       mybatis-spring
    100.       ${mybatis.spring.version}
    101.     
    103.     
    104.     
    105.       org.apache.commons
    106.       commons-dbcp2
    107.       ${commons.dbcp2.version}
    108.     
    109.     
    110.       org.apache.commons
    111.       commons-pool2
    112.       ${commons.pool2.version}
    113.     
    115.     
    116.     
    117.     
    118.       org.apache.logging.log4j
    119.       log4j-core
    120.       ${log4j2.version}
    121.     
    122.     
    123.       org.apache.logging.log4j
    124.       log4j-api
    125.       ${log4j2.version}
    126.     
    127.     
    128.     
    129.       org.apache.logging.log4j
    130.       log4j-web
    131.       ${log4j2.version}
    132.     
    134.     
    135.     
    136.       junit
    137.       junit
    138.       ${junit.version}
    140.     
    141.     
    142.       javax.servlet
    143.       javax.servlet-api
    144.       ${servlet.version}
    145.       provided
    146.     
    147.     
    148.       org.projectlombok
    149.       lombok
    150.       ${lombok.version}
    151.       provided
    152.     
    154.     
    155.       org.springframework
    156.       spring-webmvc
    157.       ${spring.version}
    158.     
    160.     
    161.     
    162.       javax.servlet.jsp
    163.       javax.servlet.jsp-api
    164.       2.3.3
    165.     
    166.     
    167.       jstl
    168.       jstl
    169.       1.2
    170.     
    171.     
    172.       taglibs
    173.       standard
    174.       1.1.2
    175.     
    176.   
    179.   
    180.     xisslzy_ssm
    181.     
    182.       
    183.       
    184.         src/main/java
    185.         
    186.           **/*.xml
    187.         
    188.       
    189.       
    190.       
    191.         src/main/resources
    192.         
    193.           jdbc.properties
    194.           *.xml
    195.         
    196.       
    197.     
    199.     
    200.       
    201.         org.mybatis.generator
    202.         mybatis-generator-maven-plugin
    203.         1.3.2
    204.         
    205.           
    206.           
    207.             mysql
    208.             mysql-connector-java
    209.             5.1.44
    210.           
    211.         
    212.         
    213.           true
    214.         
    215.       
    217.       
    218.           maven-clean-plugin
    219.           3.1.0
    220.         
    221.         
    222.         
    223.           maven-resources-plugin
    224.           3.0.2
    225.         
    226.         
    227.           maven-compiler-plugin
    228.           3.8.0
    229.         
    230.         
    231.           maven-surefire-plugin
    232.           2.22.1
    233.         
    234.         
    235.           maven-war-plugin
    236.           3.2.2
    237.         
    238.         
    239.           maven-install-plugin
    240.           2.5.2
    241.         
    242.         
    243.           maven-deploy-plugin
    244.           2.8.2
    245.         
    246.       
    247.

    web.xml 

    1. "1.0" encoding="UTF-8"?>
    2. "http://xmlns.jcp.org/xml/ns/javaee"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
    5.          version="3.1">
    6.   Archetype Created Web Application
    7.   
    8.   
    9.   
    10.     contextConfigLocation
    11.     classpath:spring-context.xml
    12.   
    13.   
    14.   
    15.     org.springframework.web.context.ContextLoaderListener
    16.   
    17.   
    18.  
    19.   
    20.   
    21.     encodingFilter
    22.     org.springframework.web.filter.CharacterEncodingFilter
    23.     true
    24.     
    25.       encoding
    26.       UTF-8
    27.     
    28.   
    29.   
    30.     encodingFilter
    31.     /*
    32.   
    34.   
    35.   
    36.     SpringMVC
    37.     org.springframework.web.servlet.DispatcherServlet
    38.     
    39.     
    40.       contextConfigLocation
    41.       classpath:spring-mvc.xml
    42.     
    43.     1
    44.     
    45.     true
    46.   
    47.   
    48.     SpringMVC
    49.     /
    50.

     2. 添加配置文件

    jdbc.properties

    1. jdbc.driver=com.mysql.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost/mybatis_ssm?useUnicode=true&characterEncoding=UTF-8
    3. jdbc.username=root
    4. jdbc.password=123456
    5.

     generatorConfig.xml

    1. "1.0" encoding="UTF-8" ?>
    2. "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    3.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    5.     
    6.     "jdbc.properties"/>
    7.  
    8.     
    9.     "D:\\maven\\mvn_repository\\mysql\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
    10.  
    11.     
    12.     "infoGuardian">
    13.         
    14.         
    15.             "suppressAllComments" value="true"/>
    16.             "suppressDate" value="true"/> 
    17.         
    18.  
    19.         
    20.         "${jdbc.driver}"
    21.                         connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
    22.  
    23.         
    24.         
    25.             
    26.             "forceBigDecimals" value="false"/>
    27.         
    28.  
    29.         
    30.         
    31.         
    32.         "com.xissl.model"
    33.                             targetProject="src/main/java">
    34.             
    35.             "enableSubPackages" value="false"/>
    36.             
    37.             "constructorBased" value="true"/>
    38.             
    39.             "trimStrings" value="false"/>
    40.             
    41.             "immutable" value="false"/>
    42.         
    43.  
    44.         
    45.         "com.xissl.mapper"
    46.                          targetProject="src/main/java">
    47.             
    48.             "enableSubPackages" value="false"/>
    49.         
    50.  
    51.         
    52.         
    53.         
    54.         
    55.         "com.xissl.mapper"
    56.                              targetProject="src/main/java" type="XMLMAPPER">
    57.             
    58.             "enableSubPackages" value="false"/>
    59.         
    60.  
    61.  
    62.         "" tableName="t_mysql_student" domainObjectName="Student"
    63.                enableCountByExample="false" enableDeleteByExample="false"
    64.                enableSelectByExample="false" enableUpdateByExample="false">
    65.         
    66.  
    67.  
    68.     
    70.

    spring-mvc.xml

    1. "1.0" encoding="UTF-8"?>
    2. "http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xmlns:context="http://www.springframework.org/schema/context"
    5.        xmlns:aop="http://www.springframework.org/schema/aop"
    6.        xmlns:mvc="http://www.springframework.org/schema/mvc"
    7.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
    8.        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
    9.       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">
    10.     
    11.     package="com.xissl"/>
    12.  
    13.     
    14.     
    15.  
    16.     
    17.     "org.springframework.web.servlet.view.InternalResourceViewResolver">
    18.         
    19.         "viewClass"
    20.                   value="org.springframework.web.servlet.view.JstlView">
    21.         "prefix" value="/WEB-INF/jsp/"/>
    22.         "suffix" value=".jsp"/>
    23.     
    24.  
    25.  
    27.

    3. 逆向生成对应的类

    实体类

    1. package com.xissl.model;
    2.  
    3. import lombok.ToString;
    4.  
    5. @ToString
    6. public class Student {
    7.     private String sid;
    8.  
    9.     private String sname;
    10.  
    11.     private String sage;
    12.  
    13.     private String ssex;
    14.  
    15.     public Student(String sid, String sname, String sage, String ssex) {
    16.         this.sid = sid;
    17.         this.sname = sname;
    18.         this.sage = sage;
    19.         this.ssex = ssex;
    20.     }
    21.  
    22.     public Student() {
    23.         super();
    24.     }
    25.  
    26.     public String getSid() {
    27.         return sid;
    28.     }
    29.  
    30.     public void setSid(String sid) {
    31.         this.sid = sid;
    32.     }
    33.  
    34.     public String getSname() {
    35.         return sname;
    36.     }
    37.  
    38.     public void setSname(String sname) {
    39.         this.sname = sname;
    40.     }
    41.  
    42.     public String getSage() {
    43.         return sage;
    44.     }
    45.  
    46.     public void setSage(String sage) {
    47.         this.sage = sage;
    48.     }
    49.  
    50.     public String getSsex() {
    51.         return ssex;
    52.     }
    53.  
    54.     public void setSsex(String ssex) {
    55.         this.ssex = ssex;
    56.     }
    57. }

     mapper接口

    1. package com.xissl.mapper;
    2.  
    3. import com.xissl.model.Student;
    4. import org.springframework.stereotype.Repository;
    5.  
    6. import java.util.List;
    7.  
    8. @Repository
    9. public interface StudentMapper {
    10.     int deleteByPrimaryKey(String sid);
    11.  
    12.     int insert(Student record);
    13.  
    14.     int insertSelective(Student record);
    15.  
    16.     Student selectByPrimaryKey(String sid);
    17.  
    18.     int updateByPrimaryKeySelective(Student record);
    19.  
    20.     int updateByPrimaryKey(Student record);
    21.  
    22.     List listPager(Student student);
    23. }

    sql映射文件

    1. "1.0" encoding="UTF-8" ?>
    2. "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    3. "com.xissl.mapper.StudentMapper" >
    4.   "BaseResultMap" type="com.xissl.model.Student" >
    5.     
    6.       "sid" jdbcType="VARCHAR" javaType="java.lang.String" />
    7.       "sname" jdbcType="VARCHAR" javaType="java.lang.String" />
    8.       "sage" jdbcType="VARCHAR" javaType="java.lang.String" />
    9.       "ssex" jdbcType="VARCHAR" javaType="java.lang.String" />
    10.     
    11.   
    12.   "Base_Column_List" >
    13.     sid, sname, sage, ssex
    14.   
    15.   
    16.  
    17.   
    18.  
    19.   "deleteByPrimaryKey" parameterType="java.lang.String" >
    20.     delete from t_mysql_student
    21.     where sid = #{sid,jdbcType=VARCHAR}
    22.   
    23.   "insert" parameterType="com.xissl.model.Student" >
    24.     insert into t_mysql_student (sid, sname, sage, 
    25.       ssex)
    26.     values (#{sid,jdbcType=VARCHAR}, #{sname,jdbcType=VARCHAR}, #{sage,jdbcType=VARCHAR}, 
    27.       #{ssex,jdbcType=VARCHAR})
    28.   
    29.   "insertSelective" parameterType="com.xissl.model.Student" >
    30.     insert into t_mysql_student
    31.     "(" suffix=")" suffixOverrides="," >
    32.       <if test="sid != null" >
    33.         sid,
    34.       if>
    35.       <if test="sname != null" >
    36.         sname,
    37.       if>
    38.       <if test="sage != null" >
    39.         sage,
    40.       if>
    41.       <if test="ssex != null" >
    42.         ssex,
    43.       if>
    44.     
    45.     "values (" suffix=")" suffixOverrides="," >
    46.       <if test="sid != null" >
    47.         #{sid,jdbcType=VARCHAR},
    48.       if>
    49.       <if test="sname != null" >
    50.         #{sname,jdbcType=VARCHAR},
    51.       if>
    52.       <if test="sage != null" >
    53.         #{sage,jdbcType=VARCHAR},
    54.       if>
    55.       <if test="ssex != null" >
    56.         #{ssex,jdbcType=VARCHAR},
    57.       if>
    58.     
    59.   
    60.   "updateByPrimaryKeySelective" parameterType="com.xissl.model.Student" >
    61.     update t_mysql_student
    62.     
    63.       <if test="sname != null" >
    64.         sname = #{sname,jdbcType=VARCHAR},
    65.       if>
    66.       <if test="sage != null" >
    67.         sage = #{sage,jdbcType=VARCHAR},
    68.       if>
    69.       <if test="ssex != null" >
    70.         ssex = #{ssex,jdbcType=VARCHAR},
    71.       if>
    72.     
    73.     where sid = #{sid,jdbcType=VARCHAR}
    74.   
    75.   "updateByPrimaryKey" parameterType="com.xissl.model.Student" >
    76.     update t_mysql_student
    77.     set sname = #{sname,jdbcType=VARCHAR},
    78.       sage = #{sage,jdbcType=VARCHAR},
    79.       ssex = #{ssex,jdbcType=VARCHAR}
    80.     where sid = #{sid,jdbcType=VARCHAR}
    81.

    4. 后台代码编写

    业务逻辑层

    1. package com.xissl.biz;
    2.  
    3. import com.xissl.model.Student;
    4. import com.xissl.utils.PageBean;
    5.  
    6. import java.util.List;
    7.  
    8. public interface StudentBiz {
    9.     int deleteByPrimaryKey(String sid);
    10.  
    11.     int insert(Student record);
    12.  
    13.     int insertSelective(Student record);
    14.  
    15.     Student selectByPrimaryKey(String sid);
    16.  
    17.     int updateByPrimaryKeySelective(Student record);
    18.  
    19.     int updateByPrimaryKey(Student record);
    20.  
    21.     List listPager(Student student, PageBean pageBean);
    22. }

    实现接口

    1. package com.xissl.biz.impl;
    2.  
    3. import com.xissl.biz.StudentBiz;
    4. import com.xissl.mapper.StudentMapper;
    5. import com.xissl.model.Student;
    6. import com.xissl.utils.PageBean;
    7. import org.springframework.beans.factory.annotation.Autowired;
    8. import org.springframework.stereotype.Service;
    9.  
    10. import java.util.List;
    11.  
    12. /**
    13.  * @author xissl
    14.  * @create 2023-09-07 16:07
    15.  */
    16. @Service
    17. public class StudentBizImpl implements StudentBiz {
    18.  
    19.     @Autowired
    20.     private StudentMapper studentMapper;
    21.  
    22.     @Override
    23.     public int deleteByPrimaryKey(String sid) {
    24.         return studentMapper.deleteByPrimaryKey(sid);
    25.     }
    26.  
    27.     @Override
    28.     public int insert(Student record) {
    29.         return studentMapper.insert(record);
    30.     }
    31.  
    32.     @Override
    33.     public int insertSelective(Student record) {
    34.         return studentMapper.insertSelective(record);
    35.     }
    36.  
    37.     @Override
    38.     public Student selectByPrimaryKey(String sid) {
    39.         return studentMapper.selectByPrimaryKey(sid);
    40.     }
    41.  
    42.     @Override
    43.     public int updateByPrimaryKeySelective(Student record) {
    44.         return studentMapper.updateByPrimaryKeySelective(record);
    45.     }
    46.  
    47.     @Override
    48.     public int updateByPrimaryKey(Student record) {
    49.         return studentMapper.updateByPrimaryKey(record);
    50.     }
    51.  
    52.     @Override
    53.     public List listPager(Student student, PageBean pageBean) {
    54.         return studentMapper.listPager(student);
    55.     }
    56. }

     controller层

    1. package com.xissl.web;
    2.  
    3. import com.xissl.biz.StudentBiz;
    4. import com.xissl.model.Student;
    5. import com.xissl.utils.PageBean;
    6. import lombok.extern.slf4j.Slf4j;
    7. import org.springframework.beans.factory.annotation.Autowired;
    8. import org.springframework.stereotype.Controller;
    9. import org.springframework.ui.Model;
    10. import org.springframework.web.bind.annotation.PathVariable;
    11. import org.springframework.web.bind.annotation.RequestMapping;
    12.  
    13. import javax.servlet.http.HttpServletRequest;
    14. import java.util.List;
    15.  
    16. /**
    17.  * @author xissl
    18.  * @create 2023-09-07 16:59
    19.  */
    20. @Controller
    21. @RequestMapping("/stu")
    22. public class StudentController {
    23.     @Autowired
    24.     private StudentBiz studentBiz;
    25. //    增
    26.     @RequestMapping("/add")
    27.     public String add(Student student){
    28.         int i = studentBiz.insertSelective(student);
    29.         return "redirect:list";
    30.     }
    31. //    删
    32.     @RequestMapping("/del")
    33.     public String del(String sid){
    34.         studentBiz.deleteByPrimaryKey(sid);
    35.         return "redirect:/stu/list";
    36.     }
    37. //    改
    38.     @RequestMapping("/edit")
    39.     public String edit(Student student){
    40.         studentBiz.updateByPrimaryKey(student);
    41.         return "redirect:list";
    42.  
    43.     }
    44. //    查
    45.     @RequestMapping("/list")
    46.     public String list(Student student, HttpServletRequest request){
    47. //        Student student是前台用来给后台传递参数的
    48.         PageBean pageBean = new PageBean();
    49.         pageBean.setRequest(request);
    50.         List students = studentBiz.listPager(student, pageBean);
    51.         request.setAttribute("list",students);
    52.         request.setAttribute("pageBean",pageBean);
    53.         return "stu/list";
    54.     }
    55. //    数据回显
    56.     @RequestMapping("/preSave")
    57.     public String preSave(Student student, Model model){
    58.         if(student != null && student.getSid()!=null){
    59.             Student s = studentBiz.selectByPrimaryKey(student.getSid());
    60.             model.addAttribute("s",s);
    61.         }
    62.         return "stu/edit";
    63.     }
    64. }

     5. 前台代码编写

    list.jsp

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2.          pageEncoding="UTF-8"%>
    3. <%@ taglib uri="http://jsp.veryedu.cn" prefix="z"%>
    4. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
    5. "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    8.     "Content-Type" content="text/html; charset=UTF-8">
    9.     
    10.             href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/css/bootstrap.css"
    11.             rel="stylesheet">
    12.     
    13.             src="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/js/bootstrap.js">
    14.     博客列表
    15.     
    18. "form-inline"
    19.       action="${pageContext.request.contextPath }/stu/list" method="post">
    20.     
      "form-group mb-2">
    21.         "text" class="form-control-plaintext" name="sname"
    22.                placeholder="请输入学生姓名">
    23.         
    24.         
    25. <%--        "pagination" value="false" type="hidden">--%>
    26.
  • "btn btn-primary mb-2" href="${pageContext.request.contextPath }/stu/preSave">新增
  • "table table-striped">
  • var="b" items="${list }">
    • "col">学生编号"col">学生姓名"col">学生年龄"col">学生性别"col">操作
    ${b.sid }${b.sname }${b.sage }${b.ssex }
  • "${pageContext.request.contextPath }/stu/preSave?sid=${b.sid}">修改
  • "${pageContext.request.contextPath }/stu/del?sid=${b.sid}">删除
  • "${pageBean }">

    • edit.jsp 

    1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    4.     Title
    7. "${pageContext.request.contextPath }/${empty s ? 'stu/add' : 'stu/edit'}" method="post">
    8.     学生编号:"text" name="sid" value="${s.sid }">
    9.     学生姓名:"text" name="sname" value="${s.sname }">
    10.     学生年龄:"text" name="sage" value="${s.sage }">
    11.     学生性别:"text" name="ssex" value="${s.ssex }">
    12.     "submit">

  • 相关阅读:
    MapStruct的使用
    C. Target Practice
    电脑多位置同时输入方法
    这几个 Python 小游戏，上班摸鱼我能玩一天 ｜ 内附源码
    深度学习之目标检测模型后处理（非极大值抑制与WBF）
    MySQL之事务、存储引擎、索引
    《MLB棒球创造营》：走近棒球运动·旧金山巨人队
    怎么判断MES系统好不好？MES又是如何帮企业省钱的？
    Linux 安装 CenOS7 MySQL - 8.0.26
    Hexagon_V65_Programmers_Reference_Manual（7）
  • 原文地址：https://blog.csdn.net/lijie1025/article/details/132742543