• SpringMVC实现增删改查(CRUD)--从头到尾全面详细讲解

    一，实现CRUD前准备工作

    1.1 pom.xml依赖的配置

    创建Model项目并导入相关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.     <dependencies>
    46.         
    47.         <dependency>
    48.             <groupId>org.springframeworkgroupId>
    49.             <artifactId>spring-coreartifactId>
    50.             <version>${spring.version}version>
    51.         dependency>
    52.         <dependency>
    53.             <groupId>org.springframeworkgroupId>
    54.             <artifactId>spring-beansartifactId>
    55.             <version>${spring.version}version>
    56.         dependency>
    57.         <dependency>
    58.             <groupId>org.springframeworkgroupId>
    59.             <artifactId>spring-contextartifactId>
    60.             <version>${spring.version}version>
    61.         dependency>
    62.         <dependency>
    63.             <groupId>org.springframeworkgroupId>
    64.             <artifactId>spring-ormartifactId>
    65.             <version>${spring.version}version>
    66.         dependency>
    67.         <dependency>
    68.             <groupId>org.springframeworkgroupId>
    69.             <artifactId>spring-txartifactId>
    70.             <version>${spring.version}version>
    71.         dependency>
    72.         <dependency>
    73.             <groupId>org.springframeworkgroupId>
    74.             <artifactId>spring-aspectsartifactId>
    75.             <version>${spring.version}version>
    76.         dependency>
    77.         <dependency>
    78.             <groupId>org.springframeworkgroupId>
    79.             <artifactId>spring-webartifactId>
    80.             <version>${spring.version}version>
    81.         dependency>
    82.  
    83.         <dependency>
    84.             <groupId>org.springframeworkgroupId>
    85.             <artifactId>spring-testartifactId>
    86.             <version>${spring.version}version>
    87.         dependency>
    88.  
    89.  
    90.         
    91.         <dependency>
    92.             <groupId>org.mybatisgroupId>
    93.             <artifactId>mybatisartifactId>
    94.             <version>${mybatis.version}version>
    95.         dependency>
    96.         
    97.         <dependency>
    98.             <groupId>mysqlgroupId>
    99.             <artifactId>mysql-connector-javaartifactId>
    100.             <version>${mysql.version}version>
    101.         dependency>
    102.         
    103.         <dependency>
    104.             <groupId>com.github.pagehelpergroupId>
    105.             <artifactId>pagehelperartifactId>
    106.             <version>${pagehelper.version}version>
    107.         dependency>
    108.         
    109.         <dependency>
    110.             <groupId>org.mybatisgroupId>
    111.             <artifactId>mybatis-springartifactId>
    112.             <version>${mybatis.spring.version}version>
    113.         dependency>
    114.  
    115.         <dependency>
    116.             <groupId>org.springframeworkgroupId>
    117.             <artifactId>spring-context-supportartifactId>
    118.             <version>${spring.version}version>
    119.         dependency>
    120.  
    121.         
    122.         <dependency>
    123.             <groupId>org.mybatis.cachesgroupId>
    124.             <artifactId>mybatis-ehcacheartifactId>
    125.             <version>${mybatis.ehcache.version}version>
    126.         dependency>
    127.         
    128.         <dependency>
    129.             <groupId>net.sf.ehcachegroupId>
    130.             <artifactId>ehcacheartifactId>
    131.             <version>${ehcache.version}version>
    132.         dependency>
    133.  
    134.         <dependency>
    135.             <groupId>redis.clientsgroupId>
    136.             <artifactId>jedisartifactId>
    137.             <version>${redis.version}version>
    138.         dependency>
    139.         <dependency>
    140.             <groupId>org.springframework.datagroupId>
    141.             <artifactId>spring-data-redisartifactId>
    142.             <version>${redis.spring.version}version>
    143.         dependency>
    144.         <dependency>
    145.             <groupId>com.fasterxml.jackson.coregroupId>
    146.             <artifactId>jackson-databindartifactId>
    147.             <version>${jackson.version}version>
    148.         dependency>
    149.         <dependency>
    150.             <groupId>com.fasterxml.jackson.coregroupId>
    151.             <artifactId>jackson-coreartifactId>
    152.             <version>${jackson.version}version>
    153.         dependency>
    154.         <dependency>
    155.             <groupId>com.fasterxml.jackson.coregroupId>
    156.             <artifactId>jackson-annotationsartifactId>
    157.             <version>${jackson.version}version>
    158.         dependency>
    159.  
    160.         
    161.         <dependency>
    162.             <groupId>org.apache.commonsgroupId>
    163.             <artifactId>commons-dbcp2artifactId>
    164.             <version>${commons.dbcp2.version}version>
    165.             <exclusions>
    166.                 <exclusion>
    167.                     <artifactId>commons-pool2artifactId>
    168.                     <groupId>org.apache.commonsgroupId>
    169.                 exclusion>
    170.             exclusions>
    171.         dependency>
    172.         <dependency>
    173.             <groupId>org.apache.commonsgroupId>
    174.             <artifactId>commons-pool2artifactId>
    175.             <version>${commons.pool2.version}version>
    176.         dependency>
    177.  
    178.         
    179.         <dependency>
    180.             <groupId>org.springframeworkgroupId>
    181.             <artifactId>spring-webmvcartifactId>
    182.             <version>${spring.version}version>
    183.         dependency>
    184.  
    185.         
    186.  
    187.         
    188.         
    189.         
    190.         <dependency>
    191.             <groupId>org.slf4jgroupId>
    192.             <artifactId>slf4j-apiartifactId>
    193.             <version>${slf4j.version}version>
    194.         dependency>
    195.         <dependency>
    196.             <groupId>org.slf4jgroupId>
    197.             <artifactId>jcl-over-slf4jartifactId>
    198.             <version>${slf4j.version}version>
    199.             <scope>runtimescope>
    200.         dependency>
    201.  
    202.         
    203.         <dependency>
    204.             <groupId>org.apache.logging.log4jgroupId>
    205.             <artifactId>log4j-apiartifactId>
    206.             <version>${log4j2.version}version>
    207.         dependency>
    208.         <dependency>
    209.             <groupId>org.apache.logging.log4jgroupId>
    210.             <artifactId>log4j-coreartifactId>
    211.             <version>${log4j2.version}version>
    212.         dependency>
    213.         
    214.         <dependency>
    215.             <groupId>org.apache.logging.log4jgroupId>
    216.             <artifactId>log4j-slf4j-implartifactId>
    217.             <version>${log4j2.version}version>
    218.         dependency>
    219.         
    220.         <dependency>
    221.             <groupId>org.apache.logging.log4jgroupId>
    222.             <artifactId>log4j-webartifactId>
    223.             <version>${log4j2.version}version>
    224.             <scope>runtimescope>
    225.         dependency>
    226.  
    227.         
    228.         <dependency>
    229.             <groupId>com.lmaxgroupId>
    230.             <artifactId>disruptorartifactId>
    231.             <version>${log4j2.disruptor.version}version>
    232.         dependency>
    233.  
    234.         
    235.         <dependency>
    236.             <groupId>junitgroupId>
    237.             <artifactId>junitartifactId>
    238.             <version>${junit.version}version>
    239.             <scope>testscope>
    240.         dependency>
    241.         <dependency>
    242.             <groupId>javax.servletgroupId>
    243.             <artifactId>javax.servlet-apiartifactId>
    244.             <version>${servlet.version}version>
    245.             <scope>providedscope>
    246.         dependency>
    247.         <dependency>
    248.             <groupId>org.projectlombokgroupId>
    249.             <artifactId>lombokartifactId>
    250.             <version>${lombok.version}version>
    251.             <scope>providedscope>
    252.         dependency>
    253.         <dependency>
    254.             <groupId>jstlgroupId>
    255.             <artifactId>jstlartifactId>
    256.             <version>${jstl.version}version>
    257.         dependency>
    258.         <dependency>
    259.             <groupId>taglibsgroupId>
    260.             <artifactId>standardartifactId>
    261.             <version>${standard.version}version>
    262.         dependency>
    263.         <dependency>
    264.             <groupId>org.apache.tomcatgroupId>
    265.             <artifactId>tomcat-jsp-apiartifactId>
    266.             <version>${tomcat-jsp-api.version}version>
    267.         dependency>
    268.         <dependency>
    269.             <groupId>commons-fileuploadgroupId>
    270.             <artifactId>commons-fileuploadartifactId>
    271.             <version>${commons-fileupload.version}version>
    272.         dependency>
    273.  
    274.         <dependency>
    275.             <groupId>org.hibernategroupId>
    276.             <artifactId>hibernate-validatorartifactId>
    277.             <version>${hibernate-validator.version}version>
    278.         dependency>
    279.  
    280.         
    281.         <dependency>
    282.             <groupId>org.apache.shirogroupId>
    283.             <artifactId>shiro-coreartifactId>
    284.             <version>${shiro.version}version>
    285.         dependency>
    286.         <dependency>
    287.             <groupId>org.apache.shirogroupId>
    288.             <artifactId>shiro-webartifactId>
    289.             <version>${shiro.version}version>
    290.         dependency>
    291.         <dependency>
    292.             <groupId>org.apache.shirogroupId>
    293.             <artifactId>shiro-springartifactId>
    294.             <version>${shiro.version}version>
    295.         dependency>
    296.     dependencies>
    297.  
    298.     <build>
    299.         <finalName>ssmfinalName>
    300.         <resources>
    301.             
    302.             <resource>
    303.                 <directory>src/main/javadirectory>
    304.                 <includes>
    305.                     <include>**/*.xmlinclude>
    306.                 includes>
    307.             resource>
    308.             
    309.             <resource>
    310.                 <directory>src/main/resourcesdirectory>
    311.                 <includes>
    312.                     <include>*.propertiesinclude>
    313.                     <include>*.xmlinclude>
    314.                 includes>
    315.             resource>
    316.         resources>
    317.         <pluginManagement>
    318.             <plugins>
    319.                 <plugin>
    320.                     <groupId>org.apache.maven.pluginsgroupId>
    321.                     <artifactId>maven-compiler-pluginartifactId>
    322.                     <version>${maven.compiler.plugin.version}version>
    323.                     <configuration>
    324.                         <source>${maven.compiler.source}source>
    325.                         <target>${maven.compiler.target}target>
    326.                         <encoding>${project.build.sourceEncoding}encoding>
    327.                     configuration>
    328.                 plugin>
    329.                 <plugin>
    330.                     <groupId>org.mybatis.generatorgroupId>
    331.                     <artifactId>mybatis-generator-maven-pluginartifactId>
    332.                     <version>1.3.2version>
    333.                     <dependencies>
    334.                         
    335.                         <dependency>
    336.                             <groupId>mysqlgroupId>
    337.                             <artifactId>mysql-connector-javaartifactId>
    338.                             <version>${mysql.version}version>
    339.                         dependency>
    340.                     dependencies>
    341.                     <configuration>
    342.                         <overwrite>trueoverwrite>
    343.                     configuration>
    344.                 plugin>
    345.  
    346.                 <plugin>
    347.                     <artifactId>maven-clean-pluginartifactId>
    348.                     <version>3.1.0version>
    349.                 plugin>
    350.                 
    351.                 <plugin>
    352.                     <artifactId>maven-resources-pluginartifactId>
    353.                     <version>3.0.2version>
    354.                 plugin>
    355.                 <plugin>
    356.                     <artifactId>maven-compiler-pluginartifactId>
    357.                     <version>3.8.0version>
    358.                 plugin>
    359.                 <plugin>
    360.                     <artifactId>maven-surefire-pluginartifactId>
    361.                     <version>2.22.1version>
    362.                 plugin>
    363.                 <plugin>
    364.                     <artifactId>maven-war-pluginartifactId>
    365.                     <version>3.2.2version>
    366.                 plugin>
    367.                 <plugin>
    368.                     <artifactId>maven-install-pluginartifactId>
    369.                     <version>2.5.2version>
    370.                 plugin>
    371.                 <plugin>
    372.                     <artifactId>maven-deploy-pluginartifactId>
    373.                     <version>2.8.2version>
    374.                 plugin>
    375.             plugins>
    376.         pluginManagement>
    377.     build>

    1.2 generatorConfig.xml

    此文件是实现模型代码层的配置，在下面table标签中定义数据库的表与生成的表名

    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="D:\\tools\\apache-maven-3.5.0-bin\\mvn_repository\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
    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.Bingzy.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.Bingzy.mapper"
    46.                          targetProject="src/main/java">
    47.             
    48.             <property name="enableSubPackages" value="false"/>
    49.         sqlMapGenerator>
    50.  
    51.         
    52.         
    53.         
    54.         
    55.         <javaClientGenerator targetPackage="com.Bingzy.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.         <table schema="" tableName="t_mvc_book" domainObjectName="Tbook"
    75.                enableCountByExample="false" enableDeleteByExample="false"
    76.                enableSelectByExample="false" enableUpdateByExample="false">
    77.         table>
    78.  
    79.  
    80.  
    81.  
    82.     context>
    83. generatorConfiguration>

    1.3 jdbc.properties

    建立数据库连接

    25256c994dbf420f83b6c82ca544f87e.png

    1.4 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>

    1.5 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="spring-mybatis.xml">import>
    8. beans>

    1.6 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.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
    7.       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">
    8.     
    9.     <context:component-scan base-package="com.Bingzy"/>
    10.  
    11.     
    12.     <mvc:annotation-driven />
    13.  
    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.     <mvc:resources location="/static/" mapping="/static/**"/>
    27. beans>

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

    1.8 生成模型层代码

    d78fc1de0d4b422f8f1fb5c720c666d1.png

    生成类样式：

    622c33658a6043f294fc986b07b9b249.png

    1.9 导入相关的工具类

    1b11837d6251419f9d3d95695be2487d.png

    创建util包并添加Page Bean类

    PageBean类：

    专门处理分页

    1. package com.Bingzy.util;
    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. }

    创建一个aspect包并添加pageAspect类：

    该是切面类专门来做分页

    1. package com.Bingzy.aspect;
    2.  
    3. import com.Bingzy.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.  * @Name BingBing
    15.  * @company zking cy
    16.  * @create 2023-08-25-18:37
    17.  */
    18. @Aspect//代表当前类为切面类
    19. @Component//代表当前类交给Spring进行管理
    20. public class PageAspect {
    21.     @Around("execution(* *..*Biz.*Page(..))")
    22.     public Object invoke(ProceedingJoinPoint args) throws Throwable {
    23.         PageBean pageBean =null;
    24.            //获取目标方法中的所有参数
    25.         Object[] arg = args.getArgs();
    26.         for (Object param : arg){
    27.           if(param instanceof  PageBean){
    28.           pageBean= (PageBean) param;
    29.           break;
    30.       }
    31.         }
    32.         if (pageBean != null && pageBean.isPagination())
    33.             PageHelper.startPage(pageBean.getPage(), pageBean.getRows());
    34.         //执行目标方法
    35.          Object lst=  args.proceed();
    36.             if (pageBean != null && pageBean.isPagination()) {
    37.                 PageInfo  info = new PageInfo ((List) lst);
    38.                 pageBean.setTotal((int) info.getTotal());
    39.  
    40.         }
    41.             return lst;
    42.     }
    43. }

    二、controller层代码编写

    创建一个web包并定义controller类

    1. package com.Bingzy.web;
    2.  
    3. import com.Bingzy.Biz.TbookBiz;
    4. import com.Bingzy.model.Tbook;
    5. import com.Bingzy.util.PageBean;
    6. import org.springframework.beans.factory.annotation.Autowired;
    7. import org.springframework.stereotype.Controller;
    8. import org.springframework.web.bind.annotation.RequestMapping;
    9.  
    10. import javax.servlet.http.HttpServletRequest;
    11. import java.util.List;
    12.  
    13. /**
    14.  * @Name BingBing
    15.  * @company zking cy
    16.  * @create 2023-09-08-19:51
    17.  */
    18. @Controller
    19. @RequestMapping("/book")
    20. public class TbookController {
    21.     @Autowired
    22.     private TbookBiz tbookBiz;
    23.  
    24.     @RequestMapping("/list")
    25.     //查询
    26.     public String list(Tbook tbook, HttpServletRequest request){
    27.         PageBean pageBean =new PageBean();
    28.         pageBean.setRequest(request);
    29.         List tbookList = tbookBiz.listPager(tbook, pageBean);
    30.         request.setAttribute("lst",tbookList);
    31.         request.setAttribute("pageBean",pageBean);
    32.         return  "book/list";
    33.     }
    34.  
    35.     //增加
    36.     //    增
    37.     @RequestMapping("/add")
    38.     public String add(Tbook tbook){
    39.         tbookBiz.insertSelective(tbook);
    40.         return "redirect:list";
    41.     }
    42.  
    43.     //    删
    44.     @RequestMapping("/del")
    45.     public String del(Tbook tbook){
    46.         tbookBiz.deleteByPrimaryKey(tbook.getBid());
    47.         return "redirect:list";
    48.     }
    49.  
    50.     //    改
    51.     @RequestMapping("/edit")
    52.     public String edit(Tbook tbook){
    53.         tbookBiz.updateByPrimaryKeySelective(tbook);
    54.         return "redirect:list";
    55.     }
    56.     //    模糊分页查询
    57.     @RequestMapping("/PreSave")
    58.     public String PreSave(Tbook tbook, HttpServletRequest request){
    59.         if(tbook!=null && tbook.getBid()!=null){
    60.             Tbook s = tbookBiz.selectByPrimaryKey(tbook.getBid());
    61.             request.setAttribute("b",s);
    62.         }
    63.         return "book/edit";
    64.     }
    65.  
    66.  
    67. }

    三，分页代码与前端代码

    3.1 分页代码

    3.1.1 PageTag

    1. package com.Bingzy.tag;
    2.  
    3. import com.Bingzy.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.getMap();
    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.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.2 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.Bingzy.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>

    3.2 前端代码

    list.jsp

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2. 	pageEncoding="UTF-8"%>
    3. <%@ taglib uri="http://jsp.veryedu.cn" prefix="z"%>	
    4. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>	
    5. html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    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 }/book/list" method="post">
    38. 	<div class="form-group mb-2">
    39. 		<input type="text" class="form-control-plaintext" name="bname"
    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 }/book/PreSave">新增a>
    47. form>
    48.  
    49. <table class="table table-striped ">
    50. 	<thead>
    51. 	<tr>
    52. 		<th scope="col">书籍IDth>
    53. 		<th scope="col">书籍名称th>
    54. 		<th scope="col">操作th>
    55. 	tr>
    56. 	thead>
    57. 	<tbody>
    58. 	<c:forEach  var="b" items="${lst }">
    59. 		<tr>
    60. 			<td>${b.bid }td>
    61. 			<td>${b.bname }td>
    62. 			<td>
    63. 				<a href="${pageContext.request.contextPath }/book/PreSave?bid=${b.bid}">修改a>
    64. 				<a href="${pageContext.request.contextPath }/book/del?bid=${b.bid}">删除a>
    65. 			td>
    66. 		tr>
    67. 	c:forEach>
    68. 	tbody>
    69. table>
    71. <z:page pageBean="${pageBean }">z:page>
    72. ${pageBean }
    73. ${slist}
    74.  
    75. body>
    76. html>

    edit.jsp

    增加与修改都是同一个界面

    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. <center>
    11.     编辑界面
    12.     <form action="${pageContext.request.contextPath }/${empty b ? 'book/add' : 'book/edit'}" method="post">
    13.         书籍id:<input type="text" name="bid" value="${b.bid }"><br>
    14.         书籍名称:<input type="text" name="bname" value="${b.bname }"><br>
    15.         <input type="submit">
    16.     form>
    17. center>
    18. body>
    19. html>

    四，案例测试（CRUD）

    25533d9f8a8b4ada96ae7e8020416253.gif

  • 相关阅读:
    参数查阅~~~9.18
    Mybatis (2)
    全栈开发笔记1:首个项目的收获
    HTML制作一个介绍自己家乡的网站——贵阳，排版整洁，内容丰富，主题鲜明
    【算法基础】栈和队列及常见变种与使用，双栈、动态栈、栈的迭代器，双端队列、优先队列、并发队列、延迟队列的使用
    界面组件DevExpress WinForms v23.1 - 增强的图表、甘特图功能
    Android WebRTC 入门教程(二) -- 模拟p2p本地视频传输
    【漏洞复现】Apache_Shiro_1.2.4_反序列化漏洞(CVE-2016-4437)
    binfmt_misc
    火山引擎 RTC 自研音频编码器 NICO 实践之路
  • 原文地址：https://blog.csdn.net/m0_73192864/article/details/132766018