• SpringMVC增删改查（CRUD）的实现

    目录

    前言

    一、前期准备

    1.pom.xml---依赖与插件的导入

    2.jdbc.properties---数据库连接

     3.log4j2.xml---日志文件

    4.spring-mybatis---mybatis与spring整合文件

    5.spring-context---spring上下文配置

    6.spring-mvc

    7.generatorConfig.xml---代码生成器

    8.web.xml

    二、增删改查的实现

    1.model与mapper层的生成

    2.biz层与切面

    3.工具类

    4.controller层

    三、测试结果

    总结

    【参考资料】

    前言

            Spring MVC是一种基于Java的Web框架，它提供了一种简单而强大的方式来构建Web应用程序。在本文中，我们将详细讲解如何使用Spring MVC来实现增删改查功能。我们将从基本概念开始，逐步介绍每个步骤，并提供示例代码来帮助您更好地理解和应用这些概念。

    一、前期准备

    先创建一个maven工程

    1.pom.xml---依赖与插件的导入

    将相关依赖于插件进行添加，并将标签内将标签删除（解除版本锁定）

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

    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

     3.log4j2.xml---日志文件

    用于记录日志

    1. <?xml version="1.0" encoding="UTF-8"?>
    2.  
    3. <!-- status : 指定log4j本身的打印日志的级别.ALL< Trace < DEBUG < INFO < WARN < ERROR 
    4. 	< FATAL < OFF。 monitorInterval : 用于指定log4j自动重新配置的监测间隔时间，单位是s,最小是5s. -->
    5. <Configuration status="WARN" monitorInterval="30">
    6. 	<Properties>
    7. 		<!-- 配置日志文件输出目录 ${sys:user.home} -->
    8. 		<Property name="LOG_HOME">/root/workspace/lucenedemo/logs</Property>
    9. 		<property name="ERROR_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/error</property>
    10. 		<property name="WARN_LOG_FILE_NAME">/root/workspace/lucenedemo/logs/warn</property>
    11. 		<property name="PATTERN">%d{yyyy-MM-dd HH:mm:ss.SSS} [%t-%L] %-5level %logger{36} - %msg%n</property>
    12. 	</Properties>
    13.  
    14. 	<Appenders>
    15. 		<!--这个输出控制台的配置 -->
    16. 		<Console name="Console" target="SYSTEM_OUT">
    17. 			<!-- 控制台只输出level及以上级别的信息(onMatch),其他的直接拒绝(onMismatch) -->
    18. 			<ThresholdFilter level="trace" onMatch="ACCEPT"
    19. 				onMismatch="DENY" />
    20. 			<!-- 输出日志的格式 -->
    21. 			<!-- %d{yyyy-MM-dd HH:mm:ss, SSS} : 日志生产时间 %p : 日志输出格式 %c : logger的名称 
    22. 				%m : 日志内容，即 logger.info("message") %n : 换行符 %C : Java类名 %L : 日志输出所在行数 %M 
    23. 				: 日志输出所在方法名 hostName : 本地机器名 hostAddress : 本地ip地址 -->
    24. 			<PatternLayout pattern="${PATTERN}" />
    25. 		</Console>
    26.  
    27. 		<!--文件会打印出所有信息，这个log每次运行程序会自动清空，由append属性决定，这个也挺有用的，适合临时测试用 -->
    28. 		<!--append为TRUE表示消息增加到指定文件中，false表示消息覆盖指定的文件内容，默认值是true -->
    29. 		<File name="log" fileName="logs/test.log" append="false">
    30. 			<PatternLayout
    31. 				pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    32. 		</File>
    33. 		<!-- 这个会打印出所有的info及以下级别的信息，每次大小超过size， 则这size大小的日志会自动存入按年份-月份建立的文件夹下面并进行压缩，作为存档 -->
    34. 		<RollingFile name="RollingFileInfo" fileName="${LOG_HOME}/info.log"
    35. 			filePattern="${LOG_HOME}/$${date:yyyy-MM}/info-%d{yyyy-MM-dd}-%i.log">
    36. 			<!--控制台只输出level及以上级别的信息（onMatch），其他的直接拒绝（onMismatch） -->
    37. 			<ThresholdFilter level="info" onMatch="ACCEPT"
    38. 				onMismatch="DENY" />
    39. 			<PatternLayout
    40. 				pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    41. 			<Policies>
    42. 				<!-- 基于时间的滚动策略，interval属性用来指定多久滚动一次，默认是1 hour。 modulate=true用来调整时间：比如现在是早上3am，interval是4，那么第一次滚动是在4am，接着是8am，12am...而不是7am. -->
    43. 				<!-- 关键点在于 filePattern后的日期格式，以及TimeBasedTriggeringPolicy的interval， 日期格式精确到哪一位，interval也精确到哪一个单位 -->
    44. 				<!-- log4j2的按天分日志文件 : info-%d{yyyy-MM-dd}-%i.log -->
    45. 				<TimeBasedTriggeringPolicy interval="1"
    46. 					modulate="true" />
    47. 				<!-- SizeBasedTriggeringPolicy:Policies子节点， 基于指定文件大小的滚动策略，size属性用来定义每个日志文件的大小. -->
    48. 				<!-- <SizeBasedTriggeringPolicy size="2 kB" /> -->
    49. 			</Policies>
    50. 		</RollingFile>
    51.  
    52. 		<RollingFile name="RollingFileWarn" fileName="${WARN_LOG_FILE_NAME}/warn.log"
    53. 			filePattern="${WARN_LOG_FILE_NAME}/$${date:yyyy-MM}/warn-%d{yyyy-MM-dd}-%i.log">
    54. 			<ThresholdFilter level="warn" onMatch="ACCEPT"
    55. 				onMismatch="DENY" />
    56. 			<PatternLayout
    57. 				pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    58. 			<Policies>
    59. 				<TimeBasedTriggeringPolicy />
    60. 				<SizeBasedTriggeringPolicy size="2 kB" />
    61. 			</Policies>
    62. 			<!-- DefaultRolloverStrategy属性如不设置，则默认为最多同一文件夹下7个文件，这里设置了20 -->
    63. 			<DefaultRolloverStrategy max="20" />
    64. 		</RollingFile>
    65.  
    66. 		<RollingFile name="RollingFileError" fileName="${ERROR_LOG_FILE_NAME}/error.log"
    67. 			filePattern="${ERROR_LOG_FILE_NAME}/$${date:yyyy-MM}/error-%d{yyyy-MM-dd-HH-mm}-%i.log">
    68. 			<ThresholdFilter level="error" onMatch="ACCEPT"
    69. 				onMismatch="DENY" />
    70. 			<PatternLayout
    71. 				pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n" />
    72. 			<Policies>
    73. 				<!-- log4j2的按分钟 分日志文件 : warn-%d{yyyy-MM-dd-HH-mm}-%i.log -->
    74. 				<TimeBasedTriggeringPolicy interval="1"
    75. 					modulate="true" />
    76. 				<!-- <SizeBasedTriggeringPolicy size="10 MB" /> -->
    77. 			</Policies>
    78. 		</RollingFile>
    79.  
    80. 	</Appenders>
    81.  
    82. 	<!--然后定义logger，只有定义了logger并引入的appender，appender才会生效 -->
    83. 	<Loggers>
    84. 		<!--过滤掉spring和mybatis的一些无用的DEBUG信息 -->
    85. 		<logger name="org.springframework" level="INFO"></logger>
    86. 		<logger name="org.mybatis" level="INFO"></logger>
    87.  
    88. 		<!-- 第三方日志系统 -->
    89. 		<logger name="org.springframework" level="ERROR" />
    90. 		<logger name="org.hibernate" level="ERROR" />
    91. 		<logger name="org.apache.struts2" level="ERROR" />
    92. 		<logger name="com.opensymphony.xwork2" level="ERROR" />
    93. 		<logger name="org.jboss" level="ERROR" />
    94.  
    95.  
    96. 		<!-- 配置日志的根节点 -->
    97. 		<root level="all">
    98. 			<appender-ref ref="Console" />
    99. 			<appender-ref ref="RollingFileInfo" />
    100. 			<appender-ref ref="RollingFileWarn" />
    101. 			<appender-ref ref="RollingFileError" />
    102. 		</root>
    103.  
    104. 	</Loggers>
    105.  
    106. </Configuration>

    4.spring-mybatis---mybatis与spring整合文件

    扫描包、数据源、sqlsessionfactory、mapper扫描、事务管理所、开启自动代理

    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.ctb"/>
    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="10"/>
    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/ctb/**/mapper/*.xml"/>
    41.         
    42.         <property name="typeAliasesPackage" value="com/ctb/**/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/ctb/**/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>

    5.spring-context---spring上下文配置

    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.  
    7.     <import resource="classpath:spirng-mybatis.xml">import>
    8. beans>

    6.spring-mvc

    扫描包、视图解析器、静态资源处理、开启自动代理

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

    7.generatorConfig.xml---代码生成器

    主要生成model/mapper接口/mapper.xml

    1. "1.0" encoding="UTF-8" ?>
    2. generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    3.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    4. <generatorConfiguration>
    5.     
    6.     <properties resource="jdbc.properties"/>
    7.  
    8.     
    9.     <classPathEntry location="D:\\software\\maven\\mvn_protetis\\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.ctb.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.ctb.mapper"
    46.                          targetProject="src/main/java">
    47.             
    48.             <property name="enableSubPackages" value="false"/>
    49.         sqlMapGenerator>
    50.  
    51.         
    52.         
    53.         
    54.         
    55.         <javaClientGenerator targetPackage="com.ctb.mapper"
    56.                              targetProject="src/main/java" type="XMLMAPPER">
    57.             
    58.             <property name="enableSubPackages" value="false"/>
    59.         javaClientGenerator>
    60.  
    61.         
    62.         
    63.         
    64.         
    65.         
    66.         
    67.         
    68.         
    69.         
    70.         
    71.         
    72.         
    73.         
    74.  
    75.         <table schema="" tableName="t_mvc_book" domainObjectName="Book"
    76.                enableCountByExample="false" enableDeleteByExample="false"
    77.                enableSelectByExample="false" enableUpdateByExample="false">
    78.         table>
    79.  
    80.     context>
    81. generatorConfiguration>

    8.web.xml

    • spring和web项目集成---监听器
    • dispatchServlet---springMVC servlet
    • 中文乱码处理过滤器
    1. <?xml version="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 Application</display-name>
    7.   <!-- Spring和web项目集成start -->
    8.   <!-- spring上下文配置文件 -->
    9.   <context-param>
    10.     <param-name>contextConfigLocation</param-name>
    11.     <param-value>classpath:spring-context.xml</param-value>
    12.   </context-param>
    13.   <!-- 读取Spring上下文的监听器 -->
    14.   <listener>
    15.     <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    16.   </listener>
    17.   <!-- Spring和web项目集成end -->
    18.  
    19.   <!-- 中文乱码处理 -->
    20.   <filter>
    21.     <filter-name>encodingFilter</filter-name>
    22.     <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    23.     <async-supported>true</async-supported>
    24.     <init-param>
    25.       <param-name>encoding</param-name>
    26.       <param-value>UTF-8</param-value>
    27.     </init-param>
    28.   </filter>
    29.   <filter-mapping>
    30.     <filter-name>encodingFilter</filter-name>
    31.     <url-pattern>/*</url-pattern>
    32.   </filter-mapping>
    33.  
    34.   <!-- Spring MVC servlet -->
    35.   <servlet>
    36.     <servlet-name>SpringMVC</servlet-name>
    37.     <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    38.     <!--此参数可以不配置，默认值为：/WEB-INF/springmvc-servlet.xml-->
    39.     <init-param>
    40.       <param-name>contextConfigLocation</param-name>
    41.       <param-value>classpath:spring-mvc.xml</param-value>
    42.     </init-param>
    43.     <load-on-startup>1</load-on-startup>
    44.     <!--web.xml 3.0的新特性，是否支持异步-->
    45.     <async-supported>true</async-supported>
    46.   </servlet>
    47.   <servlet-mapping>
    48.     <servlet-name>SpringMVC</servlet-name>
    49.     <url-pattern>/</url-pattern>
    50.   </servlet-mapping>
    51. </web-app>

    二、增删改查的实现

    1.model与mapper层的生成

    Book

    1. package com.ctb.model;
    2.  
    3. import lombok.ToString;
    4.  
    5. @ToString
    6. public class Book {
    7.     private Integer bid;
    8.  
    9.     private String bname;
    10.  
    11.     private Float price;
    12.  
    13.     public Book(Integer bid, String bname, Float price) {
    14.         this.bid = bid;
    15.         this.bname = bname;
    16.         this.price = price;
    17.     }
    18.  
    19.     public Book() {
    20.         super();
    21.     }
    22.  
    23.     public Integer getBid() {
    24.         return bid;
    25.     }
    26.  
    27.     public void setBid(Integer bid) {
    28.         this.bid = bid;
    29.     }
    30.  
    31.     public String getBname() {
    32.         return bname;
    33.     }
    34.  
    35.     public void setBname(String bname) {
    36.         this.bname = bname;
    37.     }
    38.  
    39.     public Float getPrice() {
    40.         return price;
    41.     }
    42.  
    43.     public void setPrice(Float price) {
    44.         this.price = price;
    45.     }
    46. }

    BookMapper.java

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

    BookMapper.xml

    1. <?xml version="1.0" encoding="UTF-8" ?>
    2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    3. <mapper namespace="com.ctb.mapper.BookMapper" >
    4.   <resultMap id="BaseResultMap" type="com.ctb.model.Book" >
    5.     <constructor >
    6.       <idArg column="bid" jdbcType="INTEGER" javaType="java.lang.Integer" />
    7.       <arg column="bname" jdbcType="VARCHAR" javaType="java.lang.String" />
    8.       <arg column="price" jdbcType="REAL" javaType="java.lang.Float" />
    9.     </constructor>
    10.   </resultMap>
    11.   <sql id="Base_Column_List" >
    12.     bid, bname, price
    13.   </sql>
    14.   <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    15.     select 
    16.     <include refid="Base_Column_List" />
    17.     from t_mvc_book
    18.     where bid = #{bid,jdbcType=INTEGER}
    19.   </select>
    20.   <select id="selectPager" resultType="com.ctb.model.Book" parameterType="com.ctb.model.Book" >
    21.   select
    22.   <include refid="Base_Column_List" />
    23.   from t_mvc_book
    24.   <where>
    25.     <if test="bname != null">
    26.       and bname like concat('%',#{bname},'%')
    27.     </if>
    28.   </where>
    29.   </select>
    30.  
    31.   <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    32.     delete from t_mvc_book
    33.     where bid = #{bid,jdbcType=INTEGER}
    34.   </delete>
    35.   <insert id="insert" parameterType="com.ctb.model.Book" >
    36.     insert into t_mvc_book (bid, bname, price
    37.       )
    38.     values (#{bid,jdbcType=INTEGER}, #{bname,jdbcType=VARCHAR}, #{price,jdbcType=REAL}
    39.       )
    40.   </insert>
    41.   <insert id="insertSelective" parameterType="com.ctb.model.Book" >
    42.     insert into t_mvc_book
    43.     <trim prefix="(" suffix=")" suffixOverrides="," >
    44.       <if test="bid != null" >
    45.         bid,
    46.       </if>
    47.       <if test="bname != null" >
    48.         bname,
    49.       </if>
    50.       <if test="price != null" >
    51.         price,
    52.       </if>
    53.     </trim>
    54.     <trim prefix="values (" suffix=")" suffixOverrides="," >
    55.       <if test="bid != null" >
    56.         #{bid,jdbcType=INTEGER},
    57.       </if>
    58.       <if test="bname != null" >
    59.         #{bname,jdbcType=VARCHAR},
    60.       </if>
    61.       <if test="price != null" >
    62.         #{price,jdbcType=REAL},
    63.       </if>
    64.     </trim>
    65.   </insert>
    66.   <update id="updateByPrimaryKeySelective" parameterType="com.ctb.model.Book" >
    67.     update t_mvc_book
    68.     <set >
    69.       <if test="bname != null" >
    70.         bname = #{bname,jdbcType=VARCHAR},
    71.       </if>
    72.       <if test="price != null" >
    73.         price = #{price,jdbcType=REAL},
    74.       </if>
    75.     </set>
    76.     where bid = #{bid,jdbcType=INTEGER}
    77.   </update>
    78.   <update id="updateByPrimaryKey" parameterType="com.ctb.model.Book" >
    79.     update t_mvc_book
    80.     set bname = #{bname,jdbcType=VARCHAR},
    81.       price = #{price,jdbcType=REAL}
    82.     where bid = #{bid,jdbcType=INTEGER}
    83.   </update>
    84. </mapper>

    2.biz层与切面

    PagerAspect

    1. package com.ctb.aspect;
    2.  
    3. import com.ctb.utils.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.  *
    15.  * * *..*Service.*Pager(..)
    16.  * * ：任意返回值类型
    17.  * *..：任意包，不限层级 com.ctb com.biao.ctb
    18.  * *Service:以Service结尾的类/接口
    19.  * *Pager：以Pager结尾的方法
    20.  * ..：任意参数
    21.  * 符合上述条件，即为目标类或者目标方法
    22.  *
    23.  */
    24. @Aspect //代表当前类为切面类
    25. @Component // 代表当前类交给spring进行管理
    26. public class PagerAspect {
    27.  
    28.     @Around("execution(* *..*Biz.*Pager(..))")
    29.     public Object invoke(ProceedingJoinPoint args) throws Throwable {
    30.         PageBean pageBean = null;
    31. //        获取目标方法中的所有参数
    32.         Object[] ags = args.getArgs();
    33.         for (Object param : ags) {
    34.             if(param instanceof PageBean){
    35.                 pageBean = (PageBean) param;
    36.                 break;
    37.             }
    38.         }
    39.         if(pageBean != null && pageBean.isPagination())
    40.             PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
    41.        执行目标方法
    42.         Object lst = args.proceed();
    43.         if(pageBean != null && pageBean.isPagination()){
    44.             PageInfo info = new PageInfo((List) lst);
    45.             pageBean.setTotal((int)info.getTotal());
    46.         }
    47.         return lst;
    48.     }
    49. }

    BookBizImpl

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

    3.工具类

    pagebean---分页

    1. package com.ctb.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<String,String[]> 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<String, String[]> getMap() {
    48. 		return map;
    49. 	}
    50.  
    51. 	public void setMap(Map<String, String[]> 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. }

    pagetag---自定义分页标签

    1. package com.ctb.tag;
    2.  
    3.  
    4. import com.ctb.utils.PageBean;
    5.  
    6. import javax.servlet.jsp.JspException;
    7. import javax.servlet.jsp.JspWriter;
    8. import javax.servlet.jsp.tagext.BodyTagSupport;
    9. import java.io.IOException;
    10. import java.util.Map;
    11. import java.util.Map.Entry;
    12. import java.util.Set;
    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<String, String[]> paramMap = pageBean.getMap();
    46. 		if(paramMap != null && paramMap.size() > 0) {
    47. 			Set<Entry<String, String[]>> entrySet = paramMap.entrySet();
    48. 			for (Entry<String, String[]> 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();
  • }
  • }

    • ctb.tld---自定义标签配置

    1. <?xml version="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>ctb 1.1 core library</description>
    9.   <display-name>ctb core</display-name>
    10.   <tlib-version>1.1</tlib-version>
    11.   <short-name>ctb</short-name>
    12.   <uri>http://jsp.veryedu.cn</uri>
    13.   
    14.   
    15.   <tag>
    16.     <name>page</name>
    17.     <tag-class>com.ctb.tag.PageTag</tag-class>
    18.     <body-content>JSP</body-content>
    19.     <attribute>
    20.         <name>pageBean</name>
    21.         <required>true</required>
    22.         <rtexprvalue>true</rtexprvalue>
    23.     </attribute>
    24.   </tag>
    25.   
    26. </taglib>

    responseutil---返回结果显示

    1. package com.ctb.utils;
    2.  
    3. import com.fasterxml.jackson.databind.ObjectMapper;
    4.  
    5. import javax.servlet.http.HttpServletResponse;
    6. import java.io.PrintWriter;
    7.  
    8. public class ResponseUtil {
    9.  
    10. 	public static void write(HttpServletResponse response,Object o)throws Exception{
    11. 		response.setContentType("text/html;charset=utf-8");
    12. 		PrintWriter out=response.getWriter();
    13. 		out.println(o.toString());
    14. 		out.flush();
    15. 		out.close();
    16. 	}
    17. 	
    18. 	public static void writeJson(HttpServletResponse response,Object o)throws Exception{
    19. 		ObjectMapper om = new ObjectMapper();
    20. //		om.writeValueAsString(o)代表了json串
    21. 		write(response, om.writeValueAsString(o));
    22. 	}
    23. }

    4.controller层

    1. package com.ctb.controller;
    2.  
    3.  
    4. import com.ctb.biz.BookBiz;
    5. import com.ctb.model.Book;
    6. import com.ctb.utils.PageBean;
    7. import org.springframework.beans.factory.annotation.Autowired;
    8. import org.springframework.stereotype.Controller;
    9. import org.springframework.ui.Model;
    10. import org.springframework.web.bind.annotation.PathVariable;
    11. import org.springframework.web.bind.annotation.RequestMapping;
    12.  
    13. import javax.servlet.http.HttpServletRequest;
    14. import java.util.List;
    15.  
    16.  
    17. @Controller
    18. @RequestMapping("/book")
    19. public class BookController {
    20.     @Autowired
    21.     private BookBiz bookBiz;
    22. //    增
    23.     @RequestMapping("/add")
    24.     public String add(Book Book){
    25.         int i = bookBiz.insertSelective(Book);
    26.         return "redirect:list";
    27.     }
    28. //    删
    29.     @RequestMapping("/del/{bid}")
    30.     public String del(@PathVariable("bid") Integer bid){
    31.         bookBiz.deleteByPrimaryKey(bid);
    32.         return "redirect:/book/list";
    33.     }
    34.  
    35. //    改
    36.     @RequestMapping("/edit")
    37.     public String edit(Book Book){
    38.         bookBiz.updateByPrimaryKeySelective(Book);
    39.         return "redirect:list";
    40.     }
    41. //    查
    42.     @RequestMapping("/list")
    43.     public String list(Book Book, HttpServletRequest request){
    44.         PageBean pageBean = new PageBean();
    45.         pageBean.setRequest(request);
    46.         List<Book> Books = bookBiz.listPager(Book, pageBean);
    47.         request.setAttribute("lst",Books);
    48.         request.setAttribute("pageBean",pageBean);
    49.         return "book/list";
    50.     }
    51. //    查询单个
    52.     @RequestMapping("/detail")
    53.     public String preSave(Book Book, Model model){
    54.         if(Book != null && Book.getBid() != null && Book.getBid() != 0){
    55.             Book b = bookBiz.selectByPrimaryKey(Book.getBid());
    56.             model.addAttribute("b",b);
    57.         }
    58.         return "book/edit";
    59.     }
    60. }

    三、测试结果

    1.查

    2.模糊查询

    3.删

    4.改

    5.增

    总结

    在本文中，我们详细讲解了如何使用Spring MVC来实现增删改查功能。我们从基本概念开始，逐步介绍了每个步骤，并提供了示例代码来帮助您更好地理解和应用这些概念。希望本文对您有所帮助，谢谢阅读！

    【参考资料】

  • 相关阅读:
    C#的反射Reflection
    Vue项目实战——【基于 Vue3.x + Vant UI】实现一个多功能记账本（开发导航栏及公共部分）
    VMP3.6的反调试和反虚拟机
    Cega在Solana上推出主网，为加密货币散户投资者提供更加安全的高收益机遇
    JavaScript常用工具函数汇总（一）
    Siri怎么打开
    Bundle结构入门
    CV相关 - 文献地址地址、数据集地址
    HTML小游戏16 —— 消除游戏《魔法石》源码（附完整源码）
    力扣LeetCode算法题 第6题-Z 字形变换
  • 原文地址：https://blog.csdn.net/weixin_74268571/article/details/132768876