• 【SpringMVC】实现增删改查(附源码)

    目录

    引言

    一、前期准备

    1.1.搭建Maven环境

    1.2.导入pom.xml依赖

    1.3.导入配置文件

    ①jdbc.properties

    ②generatorConfig.xml

    ③log4j2.xml

    ④spring-mybatis.xml

    ⑤spring-context.xml

    ⑥spring-mvc.xml

    ⑦修改web.xml文件

    二、逆向生成增删改查

    2.1.导入相关util类

    ①StringUtils.java

    ②PageBean.java

    2.2.aspect切面层

    2.3.Mybatis generator逆向生成

    2.4.根据生成代码编写Biz层与实现类

    三、controller层代码编写

    四、前台代码与分页代码

    ①PageTag.java

    ②zking.tld

    ③list.jsp

    ④edit.jsp

    五、案例测试

    5.1.模糊查询

    5.2.新增

    5.3.修改

    5.4.删除

    5.5.分页

    引言

    在上一篇文章中我们讲解了Spring MVC的注解、参数传递、返回值和页面跳转的关键步骤,

    这篇文章，我来讲解一下利用前面所学知识，实现SpringMVC一个Maven项目的增删改查。

    一、前期准备

    1.1.搭建Maven环境

            右击项目名➡new➡module

             选择maven项目➡选择jdk版本➡选择webapp 

             输入项目名 

            选择好maven项目的文件位置➡点击添加按钮➡配置好参数  

    1.2.导入pom.xml依赖

    ①将与标签内容进行替换即可。

    1. <properties>
    2.         <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    3.         <maven.compiler.source>1.8maven.compiler.source>
    4.         <maven.compiler.target>1.8maven.compiler.target>
    5.         <maven.compiler.plugin.version>3.7.0maven.compiler.plugin.version>
    6.  
    7.         
    8.         
    9.         <spring.version>5.0.2.RELEASEspring.version>
    10.         
    11.         <mybatis.version>3.4.5mybatis.version>
    12.         
    13.         <mysql.version>5.1.44mysql.version>
    14.         
    15.         <pagehelper.version>5.1.2pagehelper.version>
    16.         
    17.         <mybatis.spring.version>1.3.1mybatis.spring.version>
    18.         
    19.         <commons.dbcp2.version>2.1.1commons.dbcp2.version>
    20.         <commons.pool2.version>2.4.3commons.pool2.version>
    21.         
    22.         <log4j2.version>2.9.1log4j2.version>
    23.         <log4j2.disruptor.version>3.2.0log4j2.disruptor.version>
    24.         <slf4j.version>1.7.13slf4j.version>
    25.         
    26.         <junit.version>4.12junit.version>
    27.         <servlet.version>4.0.0servlet.version>
    28.         <lombok.version>1.18.2lombok.version>
    29.  
    30.         <mybatis.ehcache.version>1.1.0mybatis.ehcache.version>
    31.         <ehcache.version>2.10.0ehcache.version>
    32.  
    33.         <redis.version>2.9.0redis.version>
    34.         <redis.spring.version>1.7.1.RELEASEredis.spring.version>
    35.         <jackson.version>2.9.3jackson.version>
    36.         <jstl.version>1.2jstl.version>
    37.         <standard.version>1.1.2standard.version>
    38.         <tomcat-jsp-api.version>8.0.47tomcat-jsp-api.version>
    39.         <commons-fileupload.version>1.3.3commons-fileupload.version>
    40.         <hibernate-validator.version>5.0.2.Finalhibernate-validator.version>
    41.  
    42.         <shiro.version>1.3.2shiro.version>
    43.     properties>
    44. //-------------------------------------------
    45.  
    46.     <dependencies>
    47.         
    48.         <dependency>
    49.             <groupId>org.springframeworkgroupId>
    50.             <artifactId>spring-coreartifactId>
    51.             <version>${spring.version}version>
    52.         dependency>
    53.         <dependency>
    54.             <groupId>org.springframeworkgroupId>
    55.             <artifactId>spring-beansartifactId>
    56.             <version>${spring.version}version>
    57.         dependency>
    58.         <dependency>
    59.             <groupId>org.springframeworkgroupId>
    60.             <artifactId>spring-contextartifactId>
    61.             <version>${spring.version}version>
    62.         dependency>
    63.         <dependency>
    64.             <groupId>org.springframeworkgroupId>
    65.             <artifactId>spring-ormartifactId>
    66.             <version>${spring.version}version>
    67.         dependency>
    68.         <dependency>
    69.             <groupId>org.springframeworkgroupId>
    70.             <artifactId>spring-txartifactId>
    71.             <version>${spring.version}version>
    72.         dependency>
    73.         <dependency>
    74.             <groupId>org.springframeworkgroupId>
    75.             <artifactId>spring-aspectsartifactId>
    76.             <version>${spring.version}version>
    77.         dependency>
    78.         <dependency>
    79.             <groupId>org.springframeworkgroupId>
    80.             <artifactId>spring-webartifactId>
    81.             <version>${spring.version}version>
    82.         dependency>
    83.  
    84.         <dependency>
    85.             <groupId>org.springframeworkgroupId>
    86.             <artifactId>spring-testartifactId>
    87.             <version>${spring.version}version>
    88.         dependency>
    89.  
    90.  
    91.         
    92.         <dependency>
    93.             <groupId>org.mybatisgroupId>
    94.             <artifactId>mybatisartifactId>
    95.             <version>${mybatis.version}version>
    96.         dependency>
    97.         
    98.         <dependency>
    99.             <groupId>mysqlgroupId>
    100.             <artifactId>mysql-connector-javaartifactId>
    101.             <version>${mysql.version}version>
    102.         dependency>
    103.         
    104.         <dependency>
    105.             <groupId>com.github.pagehelpergroupId>
    106.             <artifactId>pagehelperartifactId>
    107.             <version>${pagehelper.version}version>
    108.         dependency>
    109.         
    110.         <dependency>
    111.             <groupId>org.mybatisgroupId>
    112.             <artifactId>mybatis-springartifactId>
    113.             <version>${mybatis.spring.version}version>
    114.         dependency>
    115.  
    116.         <dependency>
    117.             <groupId>org.springframeworkgroupId>
    118.             <artifactId>spring-context-supportartifactId>
    119.             <version>${spring.version}version>
    120.         dependency>
    121.  
    122.         
    123.         <dependency>
    124.             <groupId>org.mybatis.cachesgroupId>
    125.             <artifactId>mybatis-ehcacheartifactId>
    126.             <version>${mybatis.ehcache.version}version>
    127.         dependency>
    128.         
    129.         <dependency>
    130.             <groupId>net.sf.ehcachegroupId>
    131.             <artifactId>ehcacheartifactId>
    132.             <version>${ehcache.version}version>
    133.         dependency>
    134.  
    135.         <dependency>
    136.             <groupId>redis.clientsgroupId>
    137.             <artifactId>jedisartifactId>
    138.             <version>${redis.version}version>
    139.         dependency>
    140.         <dependency>
    141.             <groupId>org.springframework.datagroupId>
    142.             <artifactId>spring-data-redisartifactId>
    143.             <version>${redis.spring.version}version>
    144.         dependency>
    145.         <dependency>
    146.             <groupId>com.fasterxml.jackson.coregroupId>
    147.             <artifactId>jackson-databindartifactId>
    148.             <version>${jackson.version}version>
    149.         dependency>
    150.         <dependency>
    151.             <groupId>com.fasterxml.jackson.coregroupId>
    152.             <artifactId>jackson-coreartifactId>
    153.             <version>${jackson.version}version>
    154.         dependency>
    155.         <dependency>
    156.             <groupId>com.fasterxml.jackson.coregroupId>
    157.             <artifactId>jackson-annotationsartifactId>
    158.             <version>${jackson.version}version>
    159.         dependency>
    160.  
    161.         
    162.         <dependency>
    163.             <groupId>org.apache.commonsgroupId>
    164.             <artifactId>commons-dbcp2artifactId>
    165.             <version>${commons.dbcp2.version}version>
    166.             <exclusions>
    167.                 <exclusion>
    168.                     <artifactId>commons-pool2artifactId>
    169.                     <groupId>org.apache.commonsgroupId>
    170.                 exclusion>
    171.             exclusions>
    172.         dependency>
    173.         <dependency>
    174.             <groupId>org.apache.commonsgroupId>
    175.             <artifactId>commons-pool2artifactId>
    176.             <version>${commons.pool2.version}version>
    177.         dependency>
    178.  
    179.         
    180.         <dependency>
    181.             <groupId>org.springframeworkgroupId>
    182.             <artifactId>spring-webmvcartifactId>
    183.             <version>${spring.version}version>
    184.         dependency>
    185.  
    186.         
    187.  
    188.         
    189.         
    190.         
    191.         <dependency>
    192.             <groupId>org.slf4jgroupId>
    193.             <artifactId>slf4j-apiartifactId>
    194.             <version>${slf4j.version}version>
    195.         dependency>
    196.         <dependency>
    197.             <groupId>org.slf4jgroupId>
    198.             <artifactId>jcl-over-slf4jartifactId>
    199.             <version>${slf4j.version}version>
    200.             <scope>runtimescope>
    201.         dependency>
    202.  
    203.         
    204.         <dependency>
    205.             <groupId>org.apache.logging.log4jgroupId>
    206.             <artifactId>log4j-apiartifactId>
    207.             <version>${log4j2.version}version>
    208.         dependency>
    209.         <dependency>
    210.             <groupId>org.apache.logging.log4jgroupId>
    211.             <artifactId>log4j-coreartifactId>
    212.             <version>${log4j2.version}version>
    213.         dependency>
    214.         
    215.         <dependency>
    216.             <groupId>org.apache.logging.log4jgroupId>
    217.             <artifactId>log4j-slf4j-implartifactId>
    218.             <version>${log4j2.version}version>
    219.         dependency>
    220.         
    221.         <dependency>
    222.             <groupId>org.apache.logging.log4jgroupId>
    223.             <artifactId>log4j-webartifactId>
    224.             <version>${log4j2.version}version>
    225.             <scope>runtimescope>
    226.         dependency>
    227.  
    228.         
    229.         <dependency>
    230.             <groupId>com.lmaxgroupId>
    231.             <artifactId>disruptorartifactId>
    232.             <version>${log4j2.disruptor.version}version>
    233.         dependency>
    234.  
    235.         
    236.         <dependency>
    237.             <groupId>junitgroupId>
    238.             <artifactId>junitartifactId>
    239.             <version>${junit.version}version>
    240.             <scope>testscope>
    241.         dependency>
    242.         <dependency>
    243.             <groupId>javax.servletgroupId>
    244.             <artifactId>javax.servlet-apiartifactId>
    245.             <version>${servlet.version}version>
    246.             <scope>providedscope>
    247.         dependency>
    248.         <dependency>
    249.             <groupId>org.projectlombokgroupId>
    250.             <artifactId>lombokartifactId>
    251.             <version>${lombok.version}version>
    252.             <scope>providedscope>
    253.         dependency>
    254.         <dependency>
    255.             <groupId>jstlgroupId>
    256.             <artifactId>jstlartifactId>
    257.             <version>${jstl.version}version>
    258.         dependency>
    259.         <dependency>
    260.             <groupId>taglibsgroupId>
    261.             <artifactId>standardartifactId>
    262.             <version>${standard.version}version>
    263.         dependency>
    264.         <dependency>
    265.             <groupId>org.apache.tomcatgroupId>
    266.             <artifactId>tomcat-jsp-apiartifactId>
    267.             <version>${tomcat-jsp-api.version}version>
    268.         dependency>
    269.         <dependency>
    270.             <groupId>commons-fileuploadgroupId>
    271.             <artifactId>commons-fileuploadartifactId>
    272.             <version>${commons-fileupload.version}version>
    273.         dependency>
    274.  
    275.         <dependency>
    276.             <groupId>org.hibernategroupId>
    277.             <artifactId>hibernate-validatorartifactId>
    278.             <version>${hibernate-validator.version}version>
    279.         dependency>
    280.  
    281.         
    282.         <dependency>
    283.             <groupId>org.apache.shirogroupId>
    284.             <artifactId>shiro-coreartifactId>
    285.             <version>${shiro.version}version>
    286.         dependency>
    287.         <dependency>
    288.             <groupId>org.apache.shirogroupId>
    289.             <artifactId>shiro-webartifactId>
    290.             <version>${shiro.version}version>
    291.         dependency>
    292.         <dependency>
    293.             <groupId>org.apache.shirogroupId>
    294.             <artifactId>shiro-springartifactId>
    295.             <version>${shiro.version}version>
    296.         dependency>
    297.     dependencies>

    ②标签内将标签删除（解除版本锁定），加入。

    可以确保mybatis-generator-maven-plugin在运行时能够正确地将所需的文件复制到目标文件夹中，避免出现缺少文件或配置错误的问题。

    1. <build>
    2.         <finalName>xwzyssmfinalName>
    3.         <resources>
    4.             
    5.             <resource>
    6.                 <directory>src/main/javadirectory>
    7.                 <includes>
    8.                     <include>**/*.xmlinclude>
    9.                 includes>
    10.             resource>
    11.             
    12.             <resource>
    13.                 <directory>src/main/resourcesdirectory>
    14.                 <includes>
    15.                     <include>*.propertiesinclude>
    16.                     <include>*.xmlinclude>
    17.                 includes>
    18.             resource>
    19.         resources>
    20.         <pluginManagement>
    21.             <plugins>
    22.                 <plugin>
    23.                     <groupId>org.apache.maven.pluginsgroupId>
    24.                     <artifactId>maven-compiler-pluginartifactId>
    25.                     <version>${maven.compiler.plugin.version}version>
    26.                     <configuration>
    27.                         <source>${maven.compiler.source}source>
    28.                         <target>${maven.compiler.target}target>
    29.                         <encoding>${project.build.sourceEncoding}encoding>
    30.                     configuration>
    31.                 plugin>
    32.                 <plugin>
    33.                     <groupId>org.mybatis.generatorgroupId>
    34.                     <artifactId>mybatis-generator-maven-pluginartifactId>
    35.                     <version>1.3.2version>
    36.                     <dependencies>
    37.                         
    38.                         <dependency>
    39.                             <groupId>mysqlgroupId>
    40.                             <artifactId>mysql-connector-javaartifactId>
    41.                             <version>${mysql.version}version>
    42.                         dependency>
    43.                     dependencies>
    44.                     <configuration>
    45.                         <overwrite>trueoverwrite>
    46.                     configuration>
    47.                 plugin>
    48.  
    49.                 <plugin>
    50.                     <artifactId>maven-clean-pluginartifactId>
    51.                     <version>3.1.0version>
    52.                 plugin>
    53.                 
    54.                 <plugin>
    55.                     <artifactId>maven-resources-pluginartifactId>
    56.                     <version>3.0.2version>
    57.                 plugin>
    58.                 <plugin>
    59.                     <artifactId>maven-compiler-pluginartifactId>
    60.                     <version>3.8.0version>
    61.                 plugin>
    62.                 <plugin>
    63.                     <artifactId>maven-surefire-pluginartifactId>
    64.                     <version>2.22.1version>
    65.                 plugin>
    66.                 <plugin>
    67.                     <artifactId>maven-war-pluginartifactId>
    68.                     <version>3.2.2version>
    69.                 plugin>
    70.                 <plugin>
    71.                     <artifactId>maven-install-pluginartifactId>
    72.                     <version>2.5.2version>
    73.                 plugin>
    74.                 <plugin>
    75.                     <artifactId>maven-deploy-pluginartifactId>
    76.                     <version>2.8.2version>
    77.                 plugin>
    78.             plugins>
    79.         pluginManagement>
    80.     build>

    ③在pom.xml中，将junit的scope（依赖作用的范围）注释方便我们使用。 

    1.3.导入配置文件

    导入羡慕之前先将Maven的目录结构补齐

    ①jdbc.properties

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

    ②generatorConfig.xml

    将逆向生成的代码所在的包名进行更改即可。

    1. "1.0" encoding="UTF-8" ?>
    2. generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    3.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    4. <generatorConfiguration>
    5.     
    6.     <properties resource="jdbc.properties"/>
    7.  
    8.     
    9.     <classPathEntry location="E:\\apache-maven-3.5.0-bin\\mvn_Repository\\mysql\\mysql-connector-java\\5.1.44"/>
    10.  
    11.     
    12.     <context id="infoGuardian">
    13.         
    14.         <commentGenerator>
    15.             <property name="suppressAllComments" value="true"/>
    16.             <property name="suppressDate" value="true"/> 
    17.         commentGenerator>
    18.  
    19.         
    20.         <jdbcConnection driverClass="${jdbc.driver}"
    21.                         connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
    22.  
    23.         
    24.         <javaTypeResolver>
    25.             
    26.             <property name="forceBigDecimals" value="false"/>
    27.         javaTypeResolver>
    28.  
    29.         
    30.         
    31.         
    32.         <javaModelGenerator targetPackage="com.csdn.xw.model"
    33.                             targetProject="src/main/java">
    34.             
    35.             <property name="enableSubPackages" value="false"/>
    36.             
    37.             <property name="constructorBased" value="true"/>
    38.             
    39.             <property name="trimStrings" value="false"/>
    40.             
    41.             <property name="immutable" value="false"/>
    42.         javaModelGenerator>
    43.  
    44.         
    45.         <sqlMapGenerator targetPackage="com.csdn.xw.mapper"
    46.                          targetProject="src/main/java">
    47.             
    48.             <property name="enableSubPackages" value="false"/>
    49.         sqlMapGenerator>
    50.  
    51.         
    52.         
    53.         
    54.         
    55.         <javaClientGenerator targetPackage="com.csdn.xw.mapper"
    56.                              targetProject="src/main/java" type="XMLMAPPER">
    57.             
    58.             <property name="enableSubPackages" value="false"/>
    59.         javaClientGenerator>
    60.  
    61.         
    62.         
    63.         
    64.         
    65.         
    66.         
    67.         
    68.         
    69.         
    70.         
    71.         
    72.         
    73.         
    74.  
    75.         <table schema="" tableName="t_mysql_student" domainObjectName="Student"
    76.                enableCountByExample="false" enableDeleteByExample="false"
    77.                enableSelectByExample="false" enableUpdateByExample="false">
    78.         table>
    79.  
    80.  
    81.  
    82.     context>
    83. generatorConfiguration>

    ③log4j2.xml

    1. "1.0" encoding="UTF-8"?>
    2.  
    4. <Configuration status="WARN" monitorInterval="30">
    5.     <Properties>
    6.         
    7.         <Property name="LOG_HOME">/root/workspace/lucenedemo/logsProperty>
    8.         <property name="ERROR_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/errorproperty>
    9.         <property name="WARN_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/warnproperty>
    10.         <property name="PATTERN">%d{yyyy-MM-dd HH:mm:ss.SSS} [%t-%L] %-5level %logger{36} - %msg%nproperty>
    11.     Properties>
    12.  
    13.     <Appenders>
    14.         
    15.         <Console name="Console" target="SYSTEM_OUT">
    16.             
    17.             <ThresholdFilter level="trace" onMatch="ACCEPT"
    18.                              onMismatch="DENY" />
    19.             
    20.             
    21.             <PatternLayout pattern="${PATTERN}" />
    22.         Console>
    23.  
    24.         
    25.         
    26.         <File name="log" fileName="logs/test.log" append="false">
    27.             <PatternLayout
    28.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    29.         File>
    30.         
    31.         <RollingFile name="RollingFileInfo" fileName="${LOG_HOME}/info.log"
    32.                      filePattern="${LOG_HOME}/$${date:yyyy-MM}/info-%d{yyyy-MM-dd}-%i.log">
    33.             
    34.             <ThresholdFilter level="info" onMatch="ACCEPT"
    35.                              onMismatch="DENY" />
    36.             <PatternLayout
    37.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    38.             <Policies>
    39.                 
    40.                 
    41.                 
    42.                 <TimeBasedTriggeringPolicy interval="1"
    43.                                            modulate="true" />
    44.                 
    45.                 
    46.             Policies>
    47.         RollingFile>
    48.  
    49.         <RollingFile name="RollingFileWarn" fileName="${WARN_LOG_FILE_NAME}/warn.log"
    50.                      filePattern="${WARN_LOG_FILE_NAME}/$${date:yyyy-MM}/warn-%d{yyyy-MM-dd}-%i.log">
    51.             <ThresholdFilter level="warn" onMatch="ACCEPT"
    52.                              onMismatch="DENY" />
    53.             <PatternLayout
    54.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    55.             <Policies>
    56.                 <TimeBasedTriggeringPolicy />
    57.                 <SizeBasedTriggeringPolicy size="2 kB" />
    58.             Policies>
    59.             
    60.             <DefaultRolloverStrategy max="20" />
    61.         RollingFile>
    62.  
    63.         <RollingFile name="RollingFileError" fileName="${ERROR_LOG_FILE_NAME}/error.log"
    64.                      filePattern="${ERROR_LOG_FILE_NAME}/$${date:yyyy-MM}/error-%d{yyyy-MM-dd-HH-mm}-%i.log">
    65.             <ThresholdFilter level="error" onMatch="ACCEPT"
    66.                              onMismatch="DENY" />
    67.             <PatternLayout
    68.                     pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    69.             <Policies>
    70.                 
    71.                 <TimeBasedTriggeringPolicy interval="1"
    72.                                            modulate="true" />
    73.                 
    74.             Policies>
    75.         RollingFile>
    76.  
    77.     Appenders>
    78.  
    79.     
    80.     <Loggers>
    81.         
    82.         <logger name="org.springframework" level="INFO">logger>
    83.         <logger name="org.mybatis" level="INFO">logger>
    84.  
    85.         
    86.         <logger name="org.springframework" level="ERROR" />
    87.         <logger name="org.hibernate" level="ERROR" />
    88.         <logger name="org.apache.struts2" level="ERROR" />
    89.         <logger name="com.opensymphony.xwork2" level="ERROR" />
    90.         <logger name="org.jboss" level="ERROR" />
    91.  
    92.  
    93.         
    94.         <root level="all">
    95.             <appender-ref ref="Console" />
    96.             <appender-ref ref="RollingFileInfo" />
    97.             <appender-ref ref="RollingFileWarn" />
    98.             <appender-ref ref="RollingFileError" />
    99.         root>
    100.  
    101.     Loggers>
    102.  
    103. Configuration>

    ④spring-mybatis.xml

    1. "1.0" encoding="UTF-8"?>
    2. <beans xmlns="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" xmlns:tx="http://www.springframework.org/schema/tx"
    5.        xmlns:aop="http://www.springframework.org/schema/aop"
    6.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
    7.     
    8.  
    9.     
    10.     <context:annotation-config/>
    11.     
    12.     <context:component-scan base-package="com.csdn.xw"/>
    13.  
    14.     <context:property-placeholder location="classpath:jdbc.properties"/>
    15.  
    16.     <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource"
    17.           destroy-method="close">
    18.         <property name="driverClassName" value="${jdbc.driver}"/>
    19.         <property name="url" value="${jdbc.url}"/>
    20.         <property name="username" value="${jdbc.username}"/>
    21.         <property name="password" value="${jdbc.password}"/>
    22.         
    23.         <property name="initialSize" value="10"/>
    24.         
    25.         <property name="maxTotal" value="100"/>
    26.         
    27.         <property name="maxIdle" value="50"/>
    28.         
    29.         <property name="minIdle" value="10"/>
    30.         
    31.         
    32.         <property name="maxWaitMillis" value="-1"/>
    33.     bean>
    34.  
    35.     
    36.     
    37.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    38.         
    39.         <property name="dataSource" ref="dataSource"/>
    40.         
    41.         <property name="mapperLocations" value="classpath*:com/csdn/xw/**/mapper/*.xml"/>
    42.         
    43.         <property name="typeAliasesPackage" value="com/csdn/xw/**/model"/>
    44.         
    45.         <property name="plugins">
    46.             <array>
    47.                 <bean class="com.github.pagehelper.PageInterceptor">
    48.                     <property name="properties">
    49.                         <value>
    50.                             helperDialect=mysql
    51.                         value>
    52.                     property>
    53.                 bean>
    54.             array>
    55.         property>
    56.     bean>
    57.  
    58.     
    59.     
    60.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    61.         
    62.         
    63.         <property name="basePackage" value="com/csdn/xw/**/mapper"/>
    64.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    65.     bean>
    66.  
    67.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    68.         <property name="dataSource" ref="dataSource" />
    69.     bean>
    70.     <tx:annotation-driven transaction-manager="transactionManager" />
    71.     <aop:aspectj-autoproxy/>
    72. beans>

    ⑤spring-context.xml

    1. "1.0" encoding="UTF-8"?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
    5.  
    6.     
    7.     <import resource="classpath:spring-mybatis.xml">import>
    8.  
    9.     
    10. beans>

    ⑥spring-mvc.xml

    1. "1.0" encoding="UTF-8"?>
    2. <beans xmlns="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:mvc="http://www.springframework.org/schema/mvc"
    6.        xmlns:aop="http://www.springframework.org/schema/aop"
    7.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
    8.       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 http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
    9.     
    10.     <context:component-scan base-package="com.csdn.xw"/>
    11.  
    12.     
    13.     <mvc:annotation-driven />
    14.  
    15.     
    16.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    17.         
    18.         <property name="viewClass"
    19.                   value="org.springframework.web.servlet.view.JstlView">property>
    20.         <property name="prefix" value="/WEB-INF/jsp/"/>
    21.         <property name="suffix" value=".jsp"/>
    22.     bean>
    23.  
    24.     
    25.     
    26.  
    28.  
    29.     <aop:aspectj-autoproxy/>
    30. beans>

    ⑦修改web.xml文件

    该配置文件的作用是创建一个基于Spring MVC框架的Web应用程序，并配置了相关的上下文、监听器和Servlet，以支持Spring的依赖注入和MVC模式的开发。

    1. "1.0" encoding="UTF-8"?>
    2. <web-app xmlns="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.   <display-name>Archetype Created Web Applicationdisplay-name>
    7.   
    8.   
    9.   <context-param>
    10.     <param-name>contextConfigLocationparam-name>
    11.     <param-value>classpath:spring-context.xmlparam-value>
    12.   context-param>
    13.   
    14.   <listener>
    15.     <listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>
    16.   listener>
    17.   
    18.  
    19.   
    20.   <filter>
    21.     <filter-name>encodingFilterfilter-name>
    22.     <filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class>
    23.     <async-supported>trueasync-supported>
    24.     <init-param>
    25.       <param-name>encodingparam-name>
    26.       <param-value>UTF-8param-value>
    27.     init-param>
    28.   filter>
    29.   <filter-mapping>
    30.     <filter-name>encodingFilterfilter-name>
    31.     <url-pattern>/*url-pattern>
    32.   filter-mapping>
    33.  
    34.   
    35.   <servlet>
    36.     <servlet-name>SpringMVCservlet-name>
    37.     <servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class>
    38.     
    39.     <init-param>
    40.       <param-name>contextConfigLocationparam-name>
    41.       <param-value>classpath:spring-mvc.xmlparam-value>
    42.     init-param>
    43.     <load-on-startup>1load-on-startup>
    44.     
    45.     <async-supported>trueasync-supported>
    46.   servlet>
    47.   <servlet-mapping>
    48.     <servlet-name>SpringMVCservlet-name>
    49.     <url-pattern>/url-pattern>
    50.   servlet-mapping>
    51. web-app>

    二、逆向生成增删改查

    2.1.导入相关util类

    ①StringUtils.java

    1. package com.csdn.xw.util;
    2.  
    3. public class StringUtils {
    4. 	// 私有的构造方法，保护此类不能在外部实例化
    5. 	private StringUtils() {
    6. 	}
    7.  
    8. 	/**
    9. 	 * 如果字符串等于null或去空格后等于""，则返回true，否则返回false
    10. 	 * 
    11. 	 * @param s
    12. 	 * @return
    13. 	 */
    14. 	public static boolean isBlank(String s) {
    15. 		boolean b = false;
    16. 		if (null == s || s.trim().equals("")) {
    17. 			b = true;
    18. 		}
    19. 		return b;
    20. 	}
    21. 	
    22. 	/**
    23. 	 * 如果字符串不等于null或去空格后不等于""，则返回true，否则返回false
    24. 	 * 
    25. 	 * @param s
    26. 	 * @return
    27. 	 */
    28. 	public static boolean isNotBlank(String s) {
    29. 		return !isBlank(s);
    30. 	}
    31.  
    32. }

    ②PageBean.java

    1. package com.csdn.xw.util;
    2.  
    3. import javax.servlet.http.HttpServletRequest;
    4. import java.util.HashMap;
    5. import java.util.Map;
    6.  
    7. /**
    8.  * @author Java方文山
    9.  * @compay csdn_Java方文山
    10.  * @create 2023-09-07-16:28
    11.  */
    12. public class PageBean {
    13.  
    14.     private int page = 1;// 页码
    15.  
    16.     private int rows = 10;// 页大小
    17.  
    18.     private int total = 0;// 总记录数
    19.  
    20.     private boolean pagination = true;// 是否分页
    21.  
    22.     private String url; //保存上一次请求的URL
    23.  
    24.     private Map paramMap = new HashMap<>();// 保存上一次请求的参数
    25.  
    26.     /**
    27.      * 初始化pagebean的，保存上一次请求的重要参数
    28.      * @param req
    29.      */
    30.     public void setRequest(HttpServletRequest req) {
    31. //		1.1	需要保存上一次请求的URL
    32.         this.setUrl(req.getRequestURL().toString());
    33. //		1.2	需要保存上一次请求的参数	bname、price
    34.         this.setParamMap(req.getParameterMap());
    35. //		1.3	需要保存上一次请求的分页设置	pagination
    36.         this.setPagination(req.getParameter("pagination"));
    37. //		1.4	需要保存上一次请求的展示条目数
    38.         this.setRows(req.getParameter("rows"));
    39. //		1.5  初始化请求的页码	page
    40.         this.setPage(req.getParameter("page"));
    41.     }
    42.  
    43.     public void setPage(String page) {
    44.         if(StringUtils.isNotBlank(page))
    45.             this.setPage(Integer.valueOf(page));
    46.     }
    47.  
    48.     public void setRows(String rows) {
    49.         if(StringUtils.isNotBlank(rows))
    50.             this.setRows(Integer.valueOf(rows));
    51.     }
    52.  
    53.     public void setPagination(String pagination) {
    54. //		只有在前台jsp填写了pagination=false，才代表不分页
    55.         if(StringUtils.isNotBlank(pagination))
    56.             this.setPagination(!"false".equals(pagination));
    57.     }
    58.  
    59.  
    60.     public String getUrl() {
    61.         return url;
    62.     }
    63.  
    64.     public void setUrl(String url) {
    65.         this.url = url;
    66.     }
    67.  
    68.     public Map getParamMap() {
    69.         return paramMap;
    70.     }
    71.  
    72.     public void setParamMap(Map paramMap) {
    73.         this.paramMap = paramMap;
    74.     }
    75.  
    76.  
    77.  
    78.     public PageBean() {
    79.         super();
    80.     }
    81.  
    82.     public int getPage() {
    83.         return page;
    84.     }
    85.  
    86.     public void setPage(int page) {
    87.         this.page = page;
    88.     }
    89.  
    90.     public int getRows() {
    91.         return rows;
    92.     }
    93.  
    94.     public void setRows(int rows) {
    95.         this.rows = rows;
    96.     }
    97.  
    98.     public int getTotal() {
    99.         return total;
    100.     }
    101.  
    102.     public void setTotal(int total) {
    103.         this.total = total;
    104.     }
    105.  
    106.     public void setTotal(String total) {
    107.         this.total = Integer.parseInt(total);
    108.     }
    109.  
    110.     public boolean isPagination() {
    111.         return pagination;
    112.     }
    113.  
    114.     public void setPagination(boolean pagination) {
    115.         this.pagination = pagination;
    116.     }
    117.  
    118.     /**
    119.      * 获得起始记录的下标
    120.      *
    121.      * @return
    122.      */
    123.     public int getStartIndex() {
    124.         return (this.page - 1) * this.rows;
    125.     }
    126.  
    127.     /**
    128.      * 最大页
    129.      * @return
    130.      */
    131.     public int maxPage() {
    132. //		total % rows == 0 ? total / rows : total / rows +1
    133.         return this.total % this.rows == 0 ? this.total / this.rows : this.total / this.rows + 1;
    134.     }
    135.  
    136.     /**
    137.      * 下一页
    138.      * @return
    139.      */
    140.     public int nextPage() {
    141. //		如果当前页小于最大页，那就下一页为当前页+1；如果不小于，说明当前页就是最大页，那就无需+1
    142.         return this.page < this.maxPage() ? this.page + 1 : this.page;
    143.     }
    144.  
    145.     /**
    146.      * 上一页
    147.      * @return
    148.      */
    149.     public int previousPage() {
    150.         return this.page > 1 ? this.page - 1 : this.page;
    151.     }
    152.  
    153.     @Override
    154.     public String toString() {
    155.         return "PageBean [page=" + page + ", rows=" + rows + ", total=" + total + ", pagination=" + pagination + "]";
    156.     }
    157.  
    158. }

    2.2.aspect切面层

    创建一个名为aspect的包，编写一个PageAspect切面类专门来做分页。

    PageAspect

    1. package com.csdn.xw.aspect;
    2.  
    3. import com.csdn.xw.util.PageBean;
    4. import com.github.pagehelper.PageHelper;
    5. import com.github.pagehelper.PageInfo;
    6. import org.aspectj.lang.ProceedingJoinPoint;
    7. import org.aspectj.lang.annotation.Around;
    8. import org.aspectj.lang.annotation.Aspect;
    9. import org.springframework.stereotype.Component;
    10.  
    11. import java.util.List;
    12.  
    13.  
    14. @Aspect
    15. //代表当前类是切面类
    16. @Component
    17. //代表这个是交给Spring管理
    18. public class PageAspect {
    19.  
    20.     /**
    21.      * *：返回值
    22.      * *..：无限包
    23.      * *Biz：以Biz结尾的接口名
    24.      * .pager：以pager方法
    25.      * 只要同时匹配上诉四个条件，就会被列为目标对象
    26.      * 上诉配置要生效，代理注释一定要打开：
    27.      * @param args
    28.      * @return
    29.      * @throws Throwable
    30.      */
    31.     @Around("execution(* *..*Biz.*Pager(..))")
    32.     public Object invoke(ProceedingJoinPoint args) throws Throwable {
    33.         Object[] params = args.getArgs();
    34.         PageBean pageBean = null;
    35.         for (Object param : params) {
    36.             if(param instanceof PageBean){
    37.                 pageBean = (PageBean)param;
    38.                 break;
    39.             }
    40.         }
    41.  
    42.         if(pageBean != null && pageBean.isPagination())
    43.             PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
    44.  
    45.         Object list = args.proceed(params);
    46.  
    47.         if(null != pageBean && pageBean.isPagination()){
    48.             PageInfo pageInfo = new PageInfo((List) list);
    49.             pageBean.setTotal(pageInfo.getTotal()+"");
    50.         }
    51.         return list;
    52.     }
    53.  
    54. }

     @Around("execution(* *..*Biz.*Pager(..))")`：这是一个注解，表示这个切面将会拦截所有使用了Biz.Pager()`方法的方法，所以我们需要分页的代码在其方法后面，加上Pager并在Biz多传递一个PageBean参数即可。

    2.3.Mybatis generator逆向生成

    在pom.xml或者generatorConfig.xml处

    右击➡Run Maven➡Plugins➡Mybatis-generator-maven-plugin➡单击mybatis-generator:generate

     会在根据你配置文件中提供的路径进行逆向生成代码。

    2.4.根据生成代码编写Biz层与实现类

    由于我们还需要一个模糊查询的方法，所以在StudentMapper.xml中添加一个方法

    1. <select id="selectBySnamePager" resultType="com.csdn.xw.model.Student" parameterType="com.csdn.xw.model.Student" >
    2.     select
    3.     <include refid="Base_Column_List" />
    4.     from t_mysql_student
    5.     <if test="sname != null">
    6.       where  sname like concat('%',#{sname},'%')
    7.     if>
    8.   select>

    并在StudentMapper.java添加一个相对应的方法和注解@Repository

    StudentBiz

    1. public interface StudentBiz {
    2.     int deleteByPrimaryKey(String sid);
    3.  
    4.     int insert(Student record);
    5.  
    6.     int insertSelective(Student record);
    7.  
    8.     Student selectByPrimaryKey(String sid);
    9.  
    10.     int updateByPrimaryKeySelective(Student record);
    11.  
    12.     int updateByPrimaryKey(Student record);
    13.  
    14.     List selectBySnamePager(Student student,PageBean PageBean);
    15. }

    StudentBizImpl

    1. package com.csdn.xw.Biz.Impl;
    2.  
    3. import com.csdn.xw.Biz.StudentBiz;
    4. import com.csdn.xw.mapper.StudentMapper;
    5. import com.csdn.xw.model.Student;
    6. import com.csdn.xw.util.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 Java方文山
    14.  * @compay csdn_Java方文山
    15.  * @create 2023-09-07-16:22
    16.  */
    17. @Service
    18. public class StudentBizImpl implements StudentBiz {
    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 selectBySnamePager(Student student, PageBean PageBean) {
    54.         return studentMapper.selectBySnamePager(student);
    55.     }
    56. }

    至此，我们的增删改查加模糊查询的分页所有方法就写完了。

    三、controller层代码编写

    首先建一个名为web的包，随后建立一个StudentController。

    StudentController

    1. @Controller
    2. @RequestMapping("/student")
    3. public class StudentController {
    4.  
    5.     @Autowired
    6.     private StudentBiz stubiz;
    7.  
    8. //    增
    9.     @RequestMapping("/add")
    10.     public String add(Student student){
    11.         stubiz.insertSelective(student);
    12.         return "redirect:list";
    13.     }
    14.  
    15.     //    删
    16.     @RequestMapping("/del")
    17.     public String del(Student student){
    18.         stubiz.deleteByPrimaryKey(student.getSid());
    19.         return "redirect:list";
    20.     }
    21.  
    22.  
    23. //    查
    24.     @RequestMapping("/list")
    25.     public String list(Student student, HttpServletRequest request){
    26.         PageBean pageBean=new PageBean();
    27.         pageBean.setRequest(request);
    28.         List students = stubiz.selectBySnamePager(student, pageBean);
    29.         request.setAttribute("slist",students);
    30.         request.setAttribute("pageBean",pageBean);
    31.         return "student/list";
    32.     }
    33. //    改
    34.     @RequestMapping("/edit")
    35.     public String edit(Student student){
    36.         stubiz.updateByPrimaryKeySelective(student);
    37.         return "redirect:list";
    38.     }
    39. //    模糊分页查询
    40.     @RequestMapping("/PreSave")
    41.     public String PreSave(Student student, HttpServletRequest request){
    42.         if(student!=null && student.getSid()!=null){
    43.             Student s = stubiz.selectByPrimaryKey(student.getSid());
    44.             request.setAttribute("s",s);
    45.         }
    46.         return "student/edit";
    47.     }
    48.  
    49.  
    50. }

    查询这用的是绝对路径，所以还要加上student。

    四、前台代码与分页代码

    这里我需要用到分页，所以将以前我所编写的自定义分页标签加入。

    首先建立一个名为tag的包，将PageTag.java导入

    ①PageTag.java

    1. package com.csdn.xw.tag;
    2.  
    3. import com.csdn.xw.util.PageBean;
    4.  
    5. import javax.servlet.jsp.JspException;
    6. import javax.servlet.jsp.JspWriter;
    7. import javax.servlet.jsp.tagext.BodyTagSupport;
    8. import java.io.IOException;
    9. import java.util.Map;
    10. import java.util.Map.Entry;
    11. import java.util.Set;
    12.  
    13.  
    14.  
    15. public class PageTag extends BodyTagSupport{
    16. 	private PageBean pageBean;// 包含了所有分页相关的元素
    17. 	
    18. 	public PageBean getPageBean() {
    19. 		return pageBean;
    20. 	}
    21.  
    22. 	public void setPageBean(PageBean pageBean) {
    23. 		this.pageBean = pageBean;
    24. 	}
    25.  
    26. 	@Override
    27. 	public int doStartTag() throws JspException {
    28. //		没有标签体，要输出内容
    29. 		JspWriter out = pageContext.getOut();
    30. 		try {
    31. 			out.print(toHTML());
    32. 		} catch (IOException e) {
    33. 			e.printStackTrace();
    34. 		}
    35. 		return super.doStartTag();
    36. 	}
    37.  
    38. 	private String toHTML() {
    39. 		StringBuffer sb = new StringBuffer();
    40. //		隐藏的form表单---这个就是上一次请求下次重新发的奥义所在
    41. //		上一次请求的URL
    42. 		sb.append("
      ");
    43. 		sb.append("	");
    44. //		上一次请求的参数
    45. 		Map paramMap = pageBean.getParamMap();
    46. 		if(paramMap != null && paramMap.size() > 0) {
    47. 			Set> entrySet = paramMap.entrySet();
    48. 			for (Entry entry : entrySet) {
    49. //				参数名
    50. 				String key = entry.getKey();
    51. //				参数值
    52. 				for (String value : entry.getValue()) {
    53. //					上一次请求的参数，再一次组装成了新的Form表单
    54. //					注意：page参数每次都会提交，我们需要避免
    55. 					if(!"page".equals(key)) {
    56. 						sb.append("	");
    57. 					}
    58. 				}
    59. 			}
    60. 		}
    61. 		sb.append("");
    62. 		
    63. //		分页条
    64. 		sb.append("
        ");
    65. 		sb.append("	
    66. );
  • sb.append(" href='javascript:gotoPage(1)'>首页
    • ");
  • sb.append("
  • );
  • sb.append(" href='javascript:gotoPage("+pageBean.previousPage()+")'><
    • ");// less than 小于号
  • // sb.append("
  • 1
    • ");
  • // sb.append("
  • 2
    • ");
  • sb.append("
  • "+pageBean.getPage()+"
    • ");
  • sb.append("
  • >
    • ");
  • sb.append("
  • 尾页
    • ");
  • sb.append("
  • 到第);
  • sb.append(" type='text' id='skipPage' name='' />页
    • ");
  • sb.append("
  • );
  • sb.append(" href='javascript:skipPage()'>确定
    • ");
  • sb.append("
  • 共"+pageBean.getTotal()+"条
    • ");
  • sb.append("");
  • // 分页执行的JS代码
  • sb.append("");
  • return sb.toString();
  • }
  • }

    • 将tld文件导入WEB-INF下

    ②zking.tld

    1. "1.0" encoding="UTF-8" ?>
    2.  
    3. <taglib xmlns="http://java.sun.com/xml/ns/j2ee"
    4.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    5.     xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-jsptaglibrary_2_0.xsd"
    6.     version="2.0">
    7.     
    8.   <description>zking 1.1 core librarydescription>
    9.   <display-name>zking coredisplay-name>
    10.   <tlib-version>1.1tlib-version>
    11.   <short-name>zkingshort-name>
    12.   <uri>http://jsp.veryedu.cnuri>
    13.   
    14.   
    15.   <tag>
    16.     <name>pagename>
    17.     <tag-class>com.csdn.xw.tag.PageTagtag-class>
    18.     <body-content>JSPbody-content>
    19.     <attribute>
    20.         <name>pageBeanname>
    21.         <required>truerequired>
    22.         <rtexprvalue>truertexprvalue>
    23.     attribute>
    24.   tag>
    25.   
    26. taglib>

    ③list.jsp

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: 索隆
    4.   Date: 2023/9/8
    5.   Time: 16:32
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    9. <%@ taglib uri="http://jsp.veryedu.cn" prefix="z"%>
    10. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
    11. <html>
    12. <head>
    13.     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    14.     <link
    15.             href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/css/bootstrap.css"
    16.             rel="stylesheet">
    17.     <script
    18.             src="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/js/bootstrap.js">script>
    19.     <title>学生管理首页title>
    20.     <style type="text/css">
    21.         .page-item input {
    22.             padding: 0;
    23.             width: 40px;
    24.             height: 100%;
    25.             text-align: center;
    26.             margin: 0 6px;
    27.         }
    28.  
    29.         .page-item input, .page-item b {
    30.             line-height: 38px;
    31.             float: left;
    32.             font-weight: 400;
    33.         }
    34.  
    35.         .page-item.go-input {
    36.             margin: 0 10px;
    37.         }
    38.     style>
    39. head>
    40. <body>
    41. <form class="form-inline"
    42.       action="${pageContext.request.contextPath }/student/list" method="post">
    43.     <div class="form-group mb-2">
    44.         <input type="text" class="form-control-plaintext" name="sname"
    45.                placeholder="请输入学生名称">
    46.         
    47.         
    48.                 <%--<input name="pagination" value="false" type="hidden">--%>
    49.     div>
    50.     <button type="submit" class="btn btn-primary mb-2">查询button>
    51.     <a class="btn btn-primary mb-2" href="${pageContext.request.contextPath }/student/PreSave">新增a>
    52. form>
    53.  
    54. <table class="table table-striped ">
    55.     <thead>
    56.     <tr>
    57.         <th scope="col">学生IDth>
    58.         <th scope="col">学生名称th>
    59.         <th scope="col">学生年龄th>
    60.         <th scope="col">学生性别th>
    61.         <th scope="col">操作th>
    62.     tr>
    63.     thead>
    64.     <tbody>
    65.     <c:forEach  var="s" items="${slist }">
    66.         <tr>
    67.             <td>${s.sid }td>
    68.             <td>${s.sname }td>
    69.             <td>${s.sage }td>
    70.             <td>${s.ssex }td>
    71.             <td>
    72.                 <a href="${pageContext.request.contextPath }/student/PreSave?sid=${s.sid}">修改a>
    73.                 <a href="${pageContext.request.contextPath }/student/del?sid=${s.sid}">删除a>
    74.             td>
    75.         tr>
    76.     c:forEach>
    77.     tbody>
    78. table>
    80. <z:page pageBean="${pageBean }">z:page>
    81. ${pageBean }
    82. ${slist}
    83. body>
    84. html>

    ④edit.jsp

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: 索隆
    4.   Date: 2023/9/8
    5.   Time: 16:49
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    9. <html>
    10. <head>
    11.     <title>编辑界面title>
    12. head>
    13. <body>
    14. <center>
    15. 编辑界面
    16. <form action="${pageContext.request.contextPath }/${empty s ? 'student/add' : 'student/edit'}" method="post">
    17.     sid:<input type="text" name="sid" value="${s.sid }"><br>
    18.     sname:<input type="text" name="sname" value="${s.sname }"><br>
    19.     sage:<input type="text" name="sage" value="${s.sage }"><br>
    20.     ssex:<input type="text" name="ssex" value="${s.ssex }"><br>
    21.     <input type="submit">
    22. form>
    23. center>
    24. body>
    25. html>

    五、案例测试

    5.1.模糊查询

    5.2.新增

    5.3.修改

    5.4.删除

    5.5.分页

    到这里我的分享就结束了，欢迎到评论区探讨交流！！

    💖如果觉得有用的话还请点个赞吧 💖

  • 相关阅读:
    看门狗 WDG
    Spring JdbcTemplate.queryForMap()
    [附源码]java毕业设计新冠疫苗接种预约系统
    软考高级五大证书，哪个更值得考？
    数据结构 - 链表
    华为OD机试 - 最长的指定瑕疵度的元音子串 - 正则表达式（Java 2023 B卷 200分）
    终端安全能力验证环境搭建和渗透测试记录
    为什么需要协调能力？如何提高协调能力？
    WebGL笔记：绘制多个点，三角形，以及画各种不同的线条，面
    上周热点回顾（2.19-2.25）
  • 原文地址：https://blog.csdn.net/weixin_74318097/article/details/132737854