• SpringMVC之CRUD（直接让你迅速完成部署）

    目录

    一、项目创建

    二、配置依赖导入

    依赖导入

    1、pom.xml

    2、web.xml

    配置

    1、generatorConfig.xml

    2、jdbc.properties

    3、log4j2.xml

    4、spring-context.xml

    5、spring-mvc.xml

    6、spring-mybatis.xml

    三、后端代码

    1、逆向生成代码

    1）、实体类

    2）、生成的xml文件

    3）、生成的接口类

    2、导入资源

    1）、切面类

    2）、分页类

    3）、分页实现类

    3、配置tld文件

    4、编写biz、impl层

    5、web层

    四、前端代码

    1、首页数据访问

    2、edit前端

    五、测试结果

    1、数据回显

    2、edit

    一、项目创建

    首先创建一个基于maven的项目部署，如果有些插件没有的话可以参考mybatis入门Idea搭建

    二、配置依赖导入

    依赖导入

    1、pom.xml

    需要根据自己的文件来进行导入，并不是原本照着导入

    1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    2.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    3.     <modelVersion>4.0.0modelVersion>
    4.     <groupId>org.examplegroupId>
    5.     <artifactId>tgqzyssmartifactId>
    6.     <packaging>warpackaging>
    7.     <version>1.0-SNAPSHOTversion>
    8.     <name>tgqzyssm Maven Webappname>
    9.     <url>http://maven.apache.orgurl>
    10.  
    11.     <properties>
    12.         <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    13.         <maven.compiler.source>1.8maven.compiler.source>
    14.         <maven.compiler.target>1.8maven.compiler.target>
    15.         <maven.compiler.plugin.version>3.7.0maven.compiler.plugin.version>
    16.         
    17.         
    18.         <spring.version>5.0.2.RELEASEspring.version>
    19.         
    20.         <mybatis.version>3.4.5mybatis.version>
    21.         
    22.         <mysql.version>5.1.44mysql.version>
    23.         
    24.         <pagehelper.version>5.1.2pagehelper.version>
    25.         
    26.         <mybatis.spring.version>1.3.1mybatis.spring.version>
    27.         
    28.         <commons.dbcp2.version>2.1.1commons.dbcp2.version>
    29.         <commons.pool2.version>2.4.3commons.pool2.version>
    30.         
    31.         <log4j2.version>2.9.1log4j2.version>
    32.         <log4j2.disruptor.version>3.2.0log4j2.disruptor.version>
    33.         <slf4j.version>1.7.13slf4j.version>
    34.         
    35.         <junit.version>4.12junit.version>
    36.         <servlet.version>4.0.0servlet.version>
    37.         <lombok.version>1.18.2lombok.version>
    38.  
    39.         <mybatis.ehcache.version>1.1.0mybatis.ehcache.version>
    40.         <ehcache.version>2.10.0ehcache.version>
    41.  
    42.         <redis.version>2.9.0redis.version>
    43.         <redis.spring.version>1.7.1.RELEASEredis.spring.version>
    44.         <jackson.version>2.9.3jackson.version>
    45.         <jstl.version>1.2jstl.version>
    46.         <standard.version>1.1.2standard.version>
    47.         <tomcat-jsp-api.version>8.0.47tomcat-jsp-api.version>
    48.         <commons-fileupload.version>1.3.3commons-fileupload.version>
    49.         <hibernate-validator.version>5.0.2.Finalhibernate-validator.version>
    50.  
    51.         <shiro.version>1.3.2shiro.version>
    52.     properties>
    53.  
    54.  
    55.  
    56.     <dependencies>
    57.         
    58.         <dependency>
    59.             <groupId>org.springframeworkgroupId>
    60.             <artifactId>spring-coreartifactId>
    61.             <version>${spring.version}version>
    62.         dependency>
    63.         <dependency>
    64.             <groupId>org.springframeworkgroupId>
    65.             <artifactId>spring-beansartifactId>
    66.             <version>${spring.version}version>
    67.         dependency>
    68.         <dependency>
    69.             <groupId>org.springframeworkgroupId>
    70.             <artifactId>spring-contextartifactId>
    71.             <version>${spring.version}version>
    72.         dependency>
    73.         <dependency>
    74.             <groupId>org.springframeworkgroupId>
    75.             <artifactId>spring-ormartifactId>
    76.             <version>${spring.version}version>
    77.         dependency>
    78.         <dependency>
    79.             <groupId>org.springframeworkgroupId>
    80.             <artifactId>spring-txartifactId>
    81.             <version>${spring.version}version>
    82.         dependency>
    83.         <dependency>
    84.             <groupId>org.springframeworkgroupId>
    85.             <artifactId>spring-aspectsartifactId>
    86.             <version>${spring.version}version>
    87.         dependency>
    88.         <dependency>
    89.             <groupId>org.springframeworkgroupId>
    90.             <artifactId>spring-webartifactId>
    91.             <version>${spring.version}version>
    92.         dependency>
    93.  
    94.         <dependency>
    95.             <groupId>org.springframeworkgroupId>
    96.             <artifactId>spring-testartifactId>
    97.             <version>${spring.version}version>
    98.         dependency>
    99.  
    100.  
    101.         
    102.         <dependency>
    103.             <groupId>org.mybatisgroupId>
    104.             <artifactId>mybatisartifactId>
    105.             <version>${mybatis.version}version>
    106.         dependency>
    107.         
    108.         <dependency>
    109.             <groupId>mysqlgroupId>
    110.             <artifactId>mysql-connector-javaartifactId>
    111.             <version>${mysql.version}version>
    112.         dependency>
    113.         
    114.         <dependency>
    115.             <groupId>com.github.pagehelpergroupId>
    116.             <artifactId>pagehelperartifactId>
    117.             <version>${pagehelper.version}version>
    118.         dependency>
    119.         
    120.         <dependency>
    121.             <groupId>org.mybatisgroupId>
    122.             <artifactId>mybatis-springartifactId>
    123.             <version>${mybatis.spring.version}version>
    124.         dependency>
    125.  
    126.         <dependency>
    127.             <groupId>org.springframeworkgroupId>
    128.             <artifactId>spring-context-supportartifactId>
    129.             <version>${spring.version}version>
    130.         dependency>
    131.  
    132.         
    133.         <dependency>
    134.             <groupId>org.mybatis.cachesgroupId>
    135.             <artifactId>mybatis-ehcacheartifactId>
    136.             <version>${mybatis.ehcache.version}version>
    137.         dependency>
    138.         
    139.         <dependency>
    140.             <groupId>net.sf.ehcachegroupId>
    141.             <artifactId>ehcacheartifactId>
    142.             <version>${ehcache.version}version>
    143.         dependency>
    144.  
    145.         <dependency>
    146.             <groupId>redis.clientsgroupId>
    147.             <artifactId>jedisartifactId>
    148.             <version>${redis.version}version>
    149.         dependency>
    150.         <dependency>
    151.             <groupId>org.springframework.datagroupId>
    152.             <artifactId>spring-data-redisartifactId>
    153.             <version>${redis.spring.version}version>
    154.         dependency>
    155.         <dependency>
    156.             <groupId>com.fasterxml.jackson.coregroupId>
    157.             <artifactId>jackson-databindartifactId>
    158.             <version>${jackson.version}version>
    159.         dependency>
    160.         <dependency>
    161.             <groupId>com.fasterxml.jackson.coregroupId>
    162.             <artifactId>jackson-coreartifactId>
    163.             <version>${jackson.version}version>
    164.         dependency>
    165.         <dependency>
    166.             <groupId>com.fasterxml.jackson.coregroupId>
    167.             <artifactId>jackson-annotationsartifactId>
    168.             <version>${jackson.version}version>
    169.         dependency>
    170.  
    171.         
    172.         <dependency>
    173.             <groupId>org.apache.commonsgroupId>
    174.             <artifactId>commons-dbcp2artifactId>
    175.             <version>${commons.dbcp2.version}version>
    176.             <exclusions>
    177.                 <exclusion>
    178.                     <artifactId>commons-pool2artifactId>
    179.                     <groupId>org.apache.commonsgroupId>
    180.                 exclusion>
    181.             exclusions>
    182.         dependency>
    183.         <dependency>
    184.             <groupId>org.apache.commonsgroupId>
    185.             <artifactId>commons-pool2artifactId>
    186.             <version>${commons.pool2.version}version>
    187.         dependency>
    188.  
    189.         
    190.         <dependency>
    191.             <groupId>org.springframeworkgroupId>
    192.             <artifactId>spring-webmvcartifactId>
    193.             <version>${spring.version}version>
    194.         dependency>
    195.  
    196.         
    197.  
    198.         
    199.         
    200.         
    201.         <dependency>
    202.             <groupId>org.slf4jgroupId>
    203.             <artifactId>slf4j-apiartifactId>
    204.             <version>${slf4j.version}version>
    205.         dependency>
    206.         <dependency>
    207.             <groupId>org.slf4jgroupId>
    208.             <artifactId>jcl-over-slf4jartifactId>
    209.             <version>${slf4j.version}version>
    210.             <scope>runtimescope>
    211.         dependency>
    212.  
    213.         
    214.         <dependency>
    215.             <groupId>org.apache.logging.log4jgroupId>
    216.             <artifactId>log4j-apiartifactId>
    217.             <version>${log4j2.version}version>
    218.         dependency>
    219.         <dependency>
    220.             <groupId>org.apache.logging.log4jgroupId>
    221.             <artifactId>log4j-coreartifactId>
    222.             <version>${log4j2.version}version>
    223.         dependency>
    224.         
    225.         <dependency>
    226.             <groupId>org.apache.logging.log4jgroupId>
    227.             <artifactId>log4j-slf4j-implartifactId>
    228.             <version>${log4j2.version}version>
    229.         dependency>
    230.         
    231.         <dependency>
    232.             <groupId>org.apache.logging.log4jgroupId>
    233.             <artifactId>log4j-webartifactId>
    234.             <version>${log4j2.version}version>
    235.             <scope>runtimescope>
    236.         dependency>
    237.  
    238.         
    239.         <dependency>
    240.             <groupId>com.lmaxgroupId>
    241.             <artifactId>disruptorartifactId>
    242.             <version>${log4j2.disruptor.version}version>
    243.         dependency>
    244.  
    245.         
    246.         <dependency>
    247.             <groupId>junitgroupId>
    248.             <artifactId>junitartifactId>
    249.             <version>${junit.version}version>
    250.             
    251.         dependency>
    252.         <dependency>
    253.             <groupId>javax.servletgroupId>
    254.             <artifactId>javax.servlet-apiartifactId>
    255.             <version>${servlet.version}version>
    256.             <scope>providedscope>
    257.         dependency>
    258.         <dependency>
    259.             <groupId>org.projectlombokgroupId>
    260.             <artifactId>lombokartifactId>
    261.             <version>${lombok.version}version>
    262.             <scope>providedscope>
    263.         dependency>
    264.         <dependency>
    265.             <groupId>jstlgroupId>
    266.             <artifactId>jstlartifactId>
    267.             <version>${jstl.version}version>
    268.         dependency>
    269.         <dependency>
    270.             <groupId>taglibsgroupId>
    271.             <artifactId>standardartifactId>
    272.             <version>${standard.version}version>
    273.         dependency>
    274.         <dependency>
    275.             <groupId>org.apache.tomcatgroupId>
    276.             <artifactId>tomcat-jsp-apiartifactId>
    277.             <version>${tomcat-jsp-api.version}version>
    278.         dependency>
    279.         <dependency>
    280.             <groupId>commons-fileuploadgroupId>
    281.             <artifactId>commons-fileuploadartifactId>
    282.             <version>${commons-fileupload.version}version>
    283.         dependency>
    284.  
    285.         <dependency>
    286.             <groupId>org.hibernategroupId>
    287.             <artifactId>hibernate-validatorartifactId>
    288.             <version>${hibernate-validator.version}version>
    289.         dependency>
    290.  
    291.         
    292.         <dependency>
    293.             <groupId>org.apache.shirogroupId>
    294.             <artifactId>shiro-coreartifactId>
    295.             <version>${shiro.version}version>
    296.         dependency>
    297.         <dependency>
    298.             <groupId>org.apache.shirogroupId>
    299.             <artifactId>shiro-webartifactId>
    300.             <version>${shiro.version}version>
    301.         dependency>
    302.         <dependency>
    303.             <groupId>org.apache.shirogroupId>
    304.             <artifactId>shiro-springartifactId>
    305.             <version>${shiro.version}version>
    306.         dependency>
    307.     dependencies>
    308.     <build>
    309.         <finalName>tgqzyssmfinalName>
    310.         <resources>
    311.             
    312.             <resource>
    313.                 <directory>src/main/javadirectory>
    314.                 <includes>
    315.                     <include>**/*.xmlinclude>
    316.                 includes>
    317.             resource>
    318.             
    319.             <resource>
    320.                 <directory>src/main/resourcesdirectory>
    321.                 <includes>
    322.                     <include>*.propertiesinclude>
    323.                     <include>*.xmlinclude>
    324.                 includes>
    325.             resource>
    326.         resources>
    327.         <plugins>
    328.             <plugin>
    329.                 <groupId>org.apache.maven.pluginsgroupId>
    330.                 <artifactId>maven-compiler-pluginartifactId>
    331.                 <version>${maven.compiler.plugin.version}version>
    332.                 <configuration>
    333.                     <source>${maven.compiler.source}source>
    334.                     <target>${maven.compiler.target}target>
    335.                     <encoding>${project.build.sourceEncoding}encoding>
    336.                 configuration>
    337.             plugin>
    338.             <plugin>
    339.                 <groupId>org.mybatis.generatorgroupId>
    340.                 <artifactId>mybatis-generator-maven-pluginartifactId>
    341.                 <version>1.3.2version>
    342.                 <dependencies>
    343.                     
    344.                     <dependency>
    345.                         <groupId>mysqlgroupId>
    346.                         <artifactId>mysql-connector-javaartifactId>
    347.                         <version>${mysql.version}version>
    348.                     dependency>
    349.                 dependencies>
    350.                 <configuration>
    351.                     <overwrite>trueoverwrite>
    352.                 configuration>
    353.             plugin>
    354.  
    355.             <plugin>
    356.                 <artifactId>maven-clean-pluginartifactId>
    357.                 <version>3.1.0version>
    358.             plugin>
    359.             
    360.             <plugin>
    361.                 <artifactId>maven-resources-pluginartifactId>
    362.                 <version>3.0.2version>
    363.             plugin>
    364.             <plugin>
    365.                 <artifactId>maven-compiler-pluginartifactId>
    366.                 <version>3.8.0version>
    367.             plugin>
    368.             <plugin>
    369.                 <artifactId>maven-surefire-pluginartifactId>
    370.                 <version>2.22.1version>
    371.             plugin>
    372.             <plugin>
    373.                 <artifactId>maven-war-pluginartifactId>
    374.                 <version>3.2.2version>
    375.             plugin>
    376.             <plugin>
    377.                 <artifactId>maven-install-pluginartifactId>
    378.                 <version>2.5.2version>
    379.             plugin>
    380.             <plugin>
    381.                 <artifactId>maven-deploy-pluginartifactId>
    382.                 <version>2.8.2version>
    383.             plugin>
    384.         plugins>
    385.     build>
    386. project>

    2、web.xml

    web文件原本导入就行

    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>

    配置

    1、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
    10.             location="D:\\zking App\\mvn_repository\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
    11.  
    12.     
    13.     <context id="infoGuardian">
    14.         
    15.         <commentGenerator>
    16.             <property name="suppressAllComments" value="true"/>
    17.             <property name="suppressDate" value="true"/> 
    18.         commentGenerator>
    19.  
    20.         
    21.         <jdbcConnection driverClass="${jdbc.driver}"
    22.                         connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
    23.  
    24.         
    25.         <javaTypeResolver>
    26.             
    27.             <property name="forceBigDecimals" value="false"/>
    28.         javaTypeResolver>
    29.  
    30.         
    31.         
    32.         
    33.         <javaModelGenerator targetProject="src/main/java" targetPackage="com.tgq.model">
    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 targetProject="src/main/java" targetPackage="com.tgq.mapper">
    46.             
    47.             <property name="enableSubPackages" value="false"/>
    48.         sqlMapGenerator>
    49.  
    50.         
    51.         
    52.         
    53.         
    54.         <javaClientGenerator targetProject="src/main/java" targetPackage="com.tgq.mapper" type="XMLMAPPER">
    55.             
    56.             <property name="enableSubPackages" value="false"/>
    57.  
    58.         <table schema="" tableName="t_struts_class" domainObjectName="StrutsClas"
    59.                enableCountByExample="false" enableDeleteByExample="false"
    60.                enableSelectByExample="false" enableUpdateByExample="false">
    61.         table>
    62.  
    63.  
    64.     context>
    65. generatorConfiguration>
    66.  
    1.     <classPathEntry
    2.             location="D:\\zking App\\mvn_repository\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
    选择你本地的 mysql-connector-java-5.1.44.jar地址 
    1. <table schema="" tableName="t_struts_class" domainObjectName="StrutsClas"
    2.                enableCountByExample="false" enableDeleteByExample="false"
    3.                enableSelectByExample="false" enableUpdateByExample="false">
    4.         table>

    tableName属性里面写你的数据库表名

    domainObjectName属性里面写你的要生成的类名

    2、jdbc.properties

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

    jdbc.username=root 数据库用户名
    jdbc.password=123456 数据库用户名密码

    3、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>

    4、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.     
    8.     <import resource="classpath:spring-mybatis.xml">import>
    9.  
    10. beans>

    5、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: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
    8.       http://www.springframework.org/schema/beans/spring-beans.xsd
    9.       http://www.springframework.org/schema/context
    10.       http://www.springframework.org/schema/context/spring-context-4.3.xsd
    11.       http://www.springframework.org/schema/aop
    12.       http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
    13.       http://www.springframework.org/schema/mvc
    14.       http://www.springframework.org/schema/mvc/spring-mvc.xsd">
    15.     
    16.     <context:component-scan base-package="com.tgq"/>
    17.  
    18.     
    19.     <mvc:annotation-driven/>
    20.  
    21.     
    22.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    23.         
    24.         <property name="viewClass"
    25.                   value="org.springframework.web.servlet.view.JstlView">property>
    26.         <property name="prefix" value="/WEB-INF/jsp/"/>
    27.         <property name="suffix" value=".jsp"/>
    28.     bean>
    29.     
    30.     
    31.  
    32.     
    33.     <aop:aspectj-autoproxy/>
    34. beans>

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

    三、后端代码

    1、逆向生成代码

    右键

    会生成两个包

    1）、实体类

    当然可以根据自己的sql表来对比

    1. package com.tgq.model;
    2.  
    3. import lombok.ToString;
    4.  
    5. @ToString
    6. public class StrutsClas {
    7.     private Integer cid;
    8.  
    9.     private String cname;
    10.  
    11.     private String cteacher;
    12.  
    13.     private String pic;
    14.  
    15.     public StrutsClas(Integer cid, String cname, String cteacher, String pic) {
    16.         this.cid = cid;
    17.         this.cname = cname;
    18.         this.cteacher = cteacher;
    19.         this.pic = pic;
    20.     }
    21.  
    22.     public StrutsClas() {
    23.         super();
    24.     }
    25.  
    26.     public Integer getCid() {
    27.         return cid;
    28.     }
    29.  
    30.     public void setCid(Integer cid) {
    31.         this.cid = cid;
    32.     }
    33.  
    34.     public String getCname() {
    35.         return cname;
    36.     }
    37.  
    38.     public void setCname(String cname) {
    39.         this.cname = cname;
    40.     }
    41.  
    42.     public String getCteacher() {
    43.         return cteacher;
    44.     }
    45.  
    46.     public void setCteacher(String cteacher) {
    47.         this.cteacher = cteacher;
    48.     }
    49.  
    50.     public String getPic() {
    51.         return pic;
    52.     }
    53.  
    54.     public void setPic(String pic) {
    55.         this.pic = pic;
    56.     }
    57. }

    2）、生成的xml文件

    在生成好的sqlxml文件里面新添加一个

    1.   <select id="selectPager" resultType="com.tgq.model.StrutsClas" parameterType="com.tgq.model.StrutsClas">
    2.     select  *  from t_struts_class
    3.     <where>
    4.       <if test="cname != null"/>
    5.       and cname like concat('%',#{cname},'%')
    6.     where>
    7.   select>

    3）、生成的接口类

    根据上面的xml配置文件生成接口方法

    List selectPager(StrutsClas strutsClas);

    1. package com.tgq.mapper;
    2.  
    3. import com.tgq.model.StrutsClas;
    4. import org.springframework.stereotype.Repository;
    5.  
    6. import java.util.List;
    7. @Repository
    8. public interface StrutsClasMapper {
    9.     int deleteByPrimaryKey(Integer cid);
    10.  
    11.     int insert(StrutsClas record);
    12.  
    13.     int insertSelective(StrutsClas record);
    14.  
    15.     StrutsClas selectByPrimaryKey(Integer cid);
    16.  
    17.     int updateByPrimaryKeySelective(StrutsClas record);
    18.  
    19.     int updateByPrimaryKey(StrutsClas record);
    20.  
    21.     List selectPager(StrutsClas strutsClas);
    22. }

    2、导入资源

    当然可以根据自己的学习成果来确认需不需要

    1）、切面类

    1. package com.tgq.aspect;
    2.  
    3. import com.github.pagehelper.PageHelper;
    4. import com.github.pagehelper.PageInfo;
    5. import com.tgq.utils.PageBean;
    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.  * @软件包名 com.tgq.aspect
    15.  * @用户 tgq
    16.  * @create 2023-08-25 下午9:26
    17.  * @注释说明：
    18.  */
    19. @Aspect //代表当前类为切面类
    20. @Component //代表该类交给spring进行管理
    21. public class PagerAspect {
    22.     /**
    23.      * * *..*biz.*Pager(..)
    24.      * * ： 任意返回值
    25.      * *..： 任意版本 不限层级
    26.      * *biz ：以biz结尾的接口/类
    27.      * *Pager ：以pager结尾的方法
    28.      * .. ：任意参数
    29.      * 
    30.      * 符合条件，就是目标或者目标方法
    31.      *
    32.      * @param args
    33.      * @return
    34.      * @throws Throwable
    35.      */
    36.     @Around("execution(* *..*Biz.*Pager(..))")
    37.     public Object invoke(ProceedingJoinPoint args) throws Throwable {
    38. //        获取目标方法中的所有参数
    39.         Object[] params = args.getArgs();
    40.         PageBean pageBean = null;
    41.         for (Object param : params) {
    42.             if (param instanceof PageBean) {
    43. //                强转
    44.                 pageBean = (PageBean) param;
    45.                 break;
    46.             }
    47.         }
    48.  
    49.         if (pageBean != null && pageBean.isPagination())
    50.             PageHelper.startPage(pageBean.getPage(), pageBean.getRows());
    51. //执行目标方法
    52.         Object list = args.proceed(params);
    53.  
    54.         if (null != pageBean && pageBean.isPagination()) {
    55.             PageInfo pageInfo = new PageInfo((List) list);
    56.             pageBean.setTotal((int) pageInfo.getTotal());
    57.         }
    58.         return list;
    59.     }
    60.  
    61.  
    62. }

    2）、分页类

    1. package com.tgq.tag;
    2.  
    3. import com.tgq.utils.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. public class PageTag extends BodyTagSupport {
    14.     private PageBean pageBean;// 包含了所有分页相关的元素
    15.  
    16.     public PageBean getPageBean() {
    17.         return pageBean;
    18.     }
    19.  
    20.     public void setPageBean(PageBean pageBean) {
    21.         this.pageBean = pageBean;
    22.     }
    23.  
    24.     @Override
    25.     public int doStartTag() throws JspException {
    26. //		没有标签体，要输出内容
    27.         JspWriter out = pageContext.getOut();
    28.         try {
    29.             out.print(toHTML());
    30.         } catch (IOException e) {
    31.             e.printStackTrace();
    32.         }
    33.         return super.doStartTag();
    34.     }
    35.  
    36.     private String toHTML() {
    37.         StringBuffer sb = new StringBuffer();
    38. //		隐藏的form表单---这个就是上一次请求下次重新发的奥义所在
    39. //		上一次请求的URL
    40.         sb.append("
      ");
    41.         sb.append("	");
    42. //		上一次请求的参数
    43.         Map paramMap = pageBean.getMap();
    44.         if (paramMap != null && paramMap.size() > 0) {
    45.             Set> entrySet = paramMap.entrySet();
    46.             for (Entry entry : entrySet) {
    47. //				参数名
    48.                 String key = entry.getKey();
    49. //				参数值
    50.                 for (String value : entry.getValue()) {
    51. //					上一次请求的参数，再一次组装成了新的Form表单
    52. //					注意：page参数每次都会提交，我们需要避免
    53.                     if (!"page".equals(key)) {
    54.                         sb.append("	");
    55.                     }
    56.                 }
    57.             }
    58.         }
    59.         sb.append("");
    60.  
    61. //		分页条
    62.         sb.append("
        ");
    63.         sb.append("	
    64. );
  • sb.append(" href='javascript:gotoPage(1)'>首页
    • ");
  • sb.append("
  • );
  • sb.append(" href='javascript:gotoPage(" + pageBean.getPreivousPage() + ")'><
    • ");// 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();
  • }
  • }

    • 3）、分页实现类

    1. package com.tgq.utils;
    2.  
    3. import javax.servlet.http.HttpServletRequest;
    4. import java.io.Serializable;
    5. import java.util.Map;
    6.  
    7. public class PageBean implements Serializable {
    8.  
    9. 	private static final long serialVersionUID = 2422581023658455731L;
    10.  
    11. 	//页码
    12. 	private int page=1;
    13. 	//每页显示记录数
    14. 	private int rows=10;
    15. 	//总记录数
    16. 	private int total=0;
    17. 	//是否分页
    18. 	private boolean isPagination=true;
    19. 	//上一次的请求路径
    20. 	private String url;
    21. 	//获取所有的请求参数
    22. 	private Map map;
    23. 	
    24. 	public PageBean() {
    25. 		super();
    26. 	}
    27. 	
    28. 	//设置请求参数
    29. 	public void setRequest(HttpServletRequest req) {
    30. 		String page=req.getParameter("page");
    31. 		String rows=req.getParameter("rows");
    32. 		String pagination=req.getParameter("pagination");
    33. 		this.setPage(page);
    34. 		this.setRows(rows);
    35. 		this.setPagination(pagination);
    36. 		this.url=req.getContextPath()+req.getServletPath();
    37. 		this.map=req.getParameterMap();
    38. 	}
    39. 	public String getUrl() {
    40. 		return url;
    41. 	}
    42.  
    43. 	public void setUrl(String url) {
    44. 		this.url = url;
    45. 	}
    46.  
    47. 	public Map getMap() {
    48. 		return map;
    49. 	}
    50.  
    51. 	public void setMap(Map map) {
    52. 		this.map = map;
    53. 	}
    54.  
    55. 	public int getPage() {
    56. 		return page;
    57. 	}
    58.  
    59. 	public void setPage(int page) {
    60. 		this.page = page;
    61. 	}
    62. 	
    63. 	public void setPage(String page) {
    64. 		if(null!=page&&!"".equals(page.trim()))
    65. 			this.page = Integer.parseInt(page);
    66. 	}
    67.  
    68. 	public int getRows() {
    69. 		return rows;
    70. 	}
    71.  
    72. 	public void setRows(int rows) {
    73. 		this.rows = rows;
    74. 	}
    75. 	
    76. 	public void setRows(String rows) {
    77. 		if(null!=rows&&!"".equals(rows.trim()))
    78. 			this.rows = Integer.parseInt(rows);
    79. 	}
    80.  
    81. 	public int getTotal() {
    82. 		return total;
    83. 	}
    84.  
    85. 	public void setTotal(int total) {
    86. 		this.total = total;
    87. 	}
    88. 	
    89. 	public void setTotal(String total) {
    90. 		this.total = Integer.parseInt(total);
    91. 	}
    92.  
    93. 	public boolean isPagination() {
    94. 		return isPagination;
    95. 	}
    96. 	
    97. 	public void setPagination(boolean isPagination) {
    98. 		this.isPagination = isPagination;
    99. 	}
    100. 	
    101. 	public void setPagination(String isPagination) {
    102. 		if(null!=isPagination&&!"".equals(isPagination.trim()))
    103. 			this.isPagination = Boolean.parseBoolean(isPagination);
    104. 	}
    105. 	
    106. 	/**
    107. 	 * 获取分页起始标记位置
    108. 	 * @return
    109. 	 */
    110. 	public int getStartIndex() {
    111. 		//(当前页码-1)*显示记录数
    112. 		return (this.getPage()-1)*this.rows;
    113. 	}
    114. 	
    115. 	/**
    116. 	 * 末页
    117. 	 * @return
    118. 	 */
    119. 	public int getMaxPage() {
    120. 		int totalpage=this.total/this.rows;
    121. 		if(this.total%this.rows!=0)
    122. 			totalpage++;
    123. 		return totalpage;
    124. 	}
    125. 	
    126. 	/**
    127. 	 * 下一页
    128. 	 * @return
    129. 	 */
    130. 	public int getNextPage() {
    131. 		int nextPage=this.page+1;
    132. 		if(this.page>=this.getMaxPage())
    133. 			nextPage=this.getMaxPage();
    134. 		return nextPage;
    135. 	}
    136. 	
    137. 	/**
    138. 	 * 上一页
    139. 	 * @return
    140. 	 */
    141. 	public int getPreivousPage() {
    142. 		int previousPage=this.page-1;
    143. 		if(previousPage<1)
    144. 			previousPage=1;
    145. 		return previousPage;
    146. 	}
    147.  
    148. 	@Override
    149. 	public String toString() {
    150. 		return "PageBean [page=" + page + ", rows=" + rows + ", total=" + total + ", isPagination=" + isPagination
    151. 				+ "]";
    152. 	}
    153. }

    3、配置tld文件

    用来管理分页的标签文件

    1. "1.0" encoding="UTF-8" ?>
    2.  
    3. "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.     tgq 1.1 core library
    9.     tgq core
    10.     1.1
    11.     <short-name>tgqshort-name>
    12.     http://jsp.veryedu.cn
    13.  
    14.  
    15.     
    16.         page
    17.         com.tgq.tag.PageTag
    18.         JSP
    19.         
    20.             pageBean
    21.             true
    22.             true
    23.         
    24.     
    25.

    4、编写biz、impl层

    1. package com.tgq.biz;
    2.  
    3. import com.tgq.model.StrutsClas;
    4. import com.tgq.utils.PageBean;
    5.  
    6. import java.util.List;
    7.  
    8. /**
    9.  * @软件包名 com.tgq.biz.impl
    10.  * @用户 tgq
    11.  * @create 2023-09-08 下午5:59
    12.  * @注释说明：
    13.  */
    14. public interface StrutsClasBiz {
    15.     int deleteByPrimaryKey(Integer cid);
    16.  
    17.     int insert(StrutsClas record);
    18.  
    19.     int insertSelective(StrutsClas record);
    20.  
    21.     StrutsClas selectByPrimaryKey(Integer cid);
    22.  
    23.     int updateByPrimaryKeySelective(StrutsClas record);
    24.  
    25.     int updateByPrimaryKey(StrutsClas record);
    26.  
    27.     List selectPager(StrutsClas clas, PageBean pageBean);
    28.  
    29. }
    1. package com.tgq.biz.impl;
    2.  
    3. import com.tgq.biz.StrutsClasBiz;
    4. import com.tgq.mapper.StrutsClasMapper;
    5. import com.tgq.model.StrutsClas;
    6. import com.tgq.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.  * @软件包名 com.tgq.biz.impl
    14.  * @用户 tgq
    15.  * @create 2023-09-08 下午8:23
    16.  * @注释说明：
    17.  */
    18. @Service
    19. public class StrutsClasBizImpl implements StrutsClasBiz {
    20.  
    21.     @Autowired
    22.     private StrutsClasMapper strutsClasMapper;
    23.  
    24.     @Override
    25.     public int deleteByPrimaryKey(Integer cid) {
    26.         return strutsClasMapper.deleteByPrimaryKey(cid);
    27.     }
    28.  
    29.     @Override
    30.     public int insert(StrutsClas record) {
    31.         return strutsClasMapper.insert(record);
    32.     }
    33.  
    34.     @Override
    35.     public int insertSelective(StrutsClas record) {
    36.         return strutsClasMapper.insertSelective(record);
    37.     }
    38.  
    39.     @Override
    40.     public StrutsClas selectByPrimaryKey(Integer cid) {
    41.         return strutsClasMapper.selectByPrimaryKey(cid);
    42.     }
    43.  
    44.     @Override
    45.     public int updateByPrimaryKeySelective(StrutsClas record) {
    46.         return strutsClasMapper.updateByPrimaryKeySelective(record);
    47.     }
    48.  
    49.     @Override
    50.     public int updateByPrimaryKey(StrutsClas record) {
    51.         return strutsClasMapper.updateByPrimaryKey(record);
    52.     }
    53.  
    54.     @Override
    55.     public List selectPager(StrutsClas clas, PageBean pageBean) {
    56.         return strutsClasMapper.selectPager(clas);
    57.     }
    58.  
    59. }

    5、web层

    添加

    @Controller ：需要实现接口
    @RequestMapping("/sc") ：里面的路径根据自己的习惯来进行

    @Autowired ： 实例化biz层需要用到的

    编写五个方法：增上改查 数据回显

    1. package com.tgq.web;
    2.  
    3. import com.tgq.biz.StrutsClasBiz;
    4. import com.tgq.model.StrutsClas;
    5. import com.tgq.utils.PageBean;
    6. import org.springframework.beans.factory.annotation.Autowired;
    7. import org.springframework.stereotype.Controller;
    8. import org.springframework.ui.Model;
    9. import org.springframework.web.bind.annotation.RequestMapping;
    10.  
    11. import javax.servlet.http.HttpServletRequest;
    12. import java.util.List;
    13.  
    14. /**
    15.  * @软件包名 com.tgq.web
    16.  * @用户 tgq
    17.  * @create 2023-09-08 下午8:58
    18.  * @注释说明：
    19.  */
    20. @Controller
    21. @RequestMapping("/sc")
    22. public class StrutsClasController {
    23.  
    24.     @Autowired
    25.     private StrutsClasBiz strutsClasBiz;
    26.  
    27.     /**
    28.      * 增加
    29.      *
    30.      * @param strutsClas
    31.      * @return
    32.      */
    33.     @RequestMapping("/add")
    34.     public String insertSelective(StrutsClas strutsClas) {
    35.         strutsClasBiz.insertSelective(strutsClas);
    36.         return "redirect:list";
    37.     }
    38.  
    39. //    @DeleteMapping("/del/{cid}")
    40. //    public String deleteByPrimaryKey(@PathVariable Integer cid) {
    41.  
    42.     /**
    43.      * 删除
    44.      *
    45.      * @param strutsClas
    46.      * @return
    47.      */
    48.     @RequestMapping("/del")
    49.     public String deleteByPrimaryKey(StrutsClas strutsClas) {
    50.         strutsClasBiz.deleteByPrimaryKey(strutsClas.getCid());
    51.         return "redirect:list";
    52.     }
    53.  
    54.     /**
    55.      * 修改
    56.      *
    57.      * @param strutsClas
    58.      * @return
    59.      */
    60.     @RequestMapping("/edit")
    61.     public String updateByPrimaryKeySelective(StrutsClas strutsClas) {
    62.         strutsClasBiz.updateByPrimaryKeySelective(strutsClas);
    63.         return "redirect:list";
    64.     }
    65.  
    66.  
    67.     @RequestMapping("/list")
    68.     public String list(StrutsClas strutsClas, HttpServletRequest request) {
    69.         PageBean pageBean = new PageBean();
    70.         pageBean.setRequest(request);
    71.         List strutsClas1 = strutsClasBiz.selectPager(strutsClas, pageBean);
    72.         request.setAttribute("list", strutsClas1);
    73.         request.setAttribute("pageBean", pageBean);
    74.         return "sc/list";
    75.     }
    76.  
    77.     /**
    78.      * 数据回显
    79.      *
    80.      * @param strutsClas
    81.      * @param model
    82.      * @return
    83.      */
    84.     @RequestMapping("/save")
    85.     public String save(StrutsClas strutsClas, Model model) {
    86.         if (strutsClas != null && strutsClas.getCid() != null && strutsClas.getCid() != 0) {
    87.             StrutsClas strutsClas1 = strutsClasBiz.selectByPrimaryKey(strutsClas.getCid());
    88.             model.addAttribute("s", strutsClas1);
    89.         }
    90.  
    91.         return "sc/edit";
    92.     }
    93.  
    94.  
    95. }

    四、前端代码

    根据自己的习惯来进行一个地方的修改

    1、首页数据访问

    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. html>
    6. <html>
    7. <head>
    8.     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    9.     <link
    10.             href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/css/bootstrap.css"
    11.             rel="stylesheet">
    12.     <script
    13.             src="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/js/bootstrap.js">script>
    14.     <title>列表title>
    15.     <style type="text/css">
    16.         .page-item input {
    17.             padding: 0;
    18.             width: 40px;
    19.             height: 100%;
    20.             text-align: center;
    21.             margin: 0 6px;
    22.         }
    23.  
    24.         .page-item input, .page-item b {
    25.             line-height: 38px;
    26.             float: left;
    27.             font-weight: 400;
    28.         }
    29.  
    30.         .page-item.go-input {
    31.             margin: 0 10px;
    32.         }
    33.     style>
    34. head>
    35. <body>
    36. <form class="form-inline"
    37.       action="${pageContext.request.contextPath }/sc/list" method="post">
    38.     <div class="form-group mb-2">
    39.         <input type="text" class="form-control-plaintext" name="cname"
    40.                placeholder="请输入名称">
    41.         
    42.         
    43.         <input name="pagination" value="false" type="hidden">
    44.     div>
    45.     <button type="submit" class="btn btn-primary mb-2">查询button>
    46.     <a class="btn btn-primary mb-2" href="${pageContext.request.contextPath }/sc/save">新增a>
    47. form>
    48.  
    49. <table class="table table-striped">
    50.     <thead>
    51.     <tr>
    52.         <th scope="col">编号th>
    53.         <th scope="col">班级名th>
    54.         <th scope="col">教师th>
    55.         <th scope="col">Logoth>
    56.         <th scope="col">操作th>
    57.     tr>
    58.     thead>
    59.     <tbody>
    60.     <c:forEach var="b" items="${list }">
    61.         <tr>
    62.             <td>${b.cid }td>
    63.             <td>${b.cname }td>
    64.             <td>${b.cteacher }td>
    65.             <td>${b.pic }td>
    66.             <td>
    67.                 <a href="${pageContext.request.contextPath }/sc/save?cid=${b.cid}">修改a>
    68.                 <a href="${pageContext.request.contextPath }/sc/del?cid=${b.cid}">删除a>
    69.             td>
    70.         tr>
    71.     c:forEach>
    72.     tbody>
    73. table>
    75. <z:page pageBean="${pageBean }">z:page>
    76. body>
    77. html>

    需要修改的地方就是一个自己表里面的属性名称和一个访问路径

    2、edit前端

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2.          pageEncoding="UTF-8" %>
    3. html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    4. <html>
    5. <head>
    6.     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    7.     <title>编辑界面title>
    8. head>
    9. <body>
    10. <form action="${pageContext.request.contextPath }/${empty s ? 'sc/add' : 'sc/edit'}" method="post">
    11.     编辑编号:<input type="text" name="cid" value="${s.cid }"><br>
    12.     班级名:<input type="text" name="cname" value="${s.cname }"><br>
    13.     教师:<input type="text" name="cteacher" value="${s.cteacher }"><br>
    14.     <input type="submit">
    15. form>
    16. body>
    17. html>

    五、测试结果

    1、数据回显

    2、edit

  • 相关阅读:
    C语言-const char*,char const*,char *const理解
    C++实现坦克大战（超详细）（文末附源码！！！）
    GNN Tensorflow packages
    Spark：性能调优实战
    运算符与逻辑分支
    js中this的指向
    达人评测 锐龙r7 6800u和r5 6600h差距 r76800u和r56600h对比
    录制线上课程，有哪些形式，到底使用什么软件好？
    sql 7
    【python】list 删除列表中某个元素的3种方法；附加删除numpy数组中的指定索引元素的方法
  • 原文地址：https://blog.csdn.net/weixin_74383330/article/details/132733852