• SpringMVC之前端增删改查实现

    SpringMVC是一个基于MVC架构的框架，它可以帮助我们实现前后端的分离，同时也能很好地支持前端的增删改查操作。

    配置

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

    generatorConfig.xml
    1. "1.0" encoding="UTF-8" ?>
    2.         generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    3.                 "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    4. <generatorConfiguration>
    6. <properties resource="jdbc.properties"/>
    7.  
    9. <classPathEntry location="D:\\temp\\mvn_repository\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
    10.  
    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.CloudJun.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.CloudJun.mapper"
    46.                    targetProject="src/main/java">
    47.     
    48.     <property name="enableSubPackages" value="false"/>
    49.   sqlMapGenerator>
    50.  
    51.   
    52.   
    53.   
    54.   
    55.   <javaClientGenerator targetPackage="com.CloudJun.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_hotel" domainObjectName="Hotel"
    76.          enableCountByExample="false" enableDeleteByExample="false"
    77.          enableSelectByExample="false" enableUpdateByExample="false">
    78.   table>
    79.  
    80.  
    81. context>
    82. generatorConfiguration>

    jdbc.properties

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

    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>

    spring-context.xml

    1. <?xml version="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.     <import resource="classpath:spring-mybatis.xml"></import>
    7. </beans>

    spring-mvc.xml

    1. <?xml version="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.     <!--1) 扫描com.zking.zf及子子孙孙包下的控制器(扫描范围过大，耗时)-->
    12.     <context:component-scan base-package="com.yuan"/>
    13.  
    14.     <!--2) 此标签默认注册DefaultAnnotationHandlerMapping和AnnotationMethodHandlerAdapter -->
    15.     <mvc:annotation-driven />
    16.  
    17.     <!--3) 创建ViewResolver视图解析器 -->
    18.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    19.         <!-- viewClass需要在pom中引入两个包：standard.jar and jstl.jar -->
    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.     <!--4) 单独处理图片、样式、js等资源 -->
    27.     <!-- <mvc:resources location="/css/" mapping="/css/**"/>
    28.      <mvc:resources location="/js/" mapping="/js/**"/>
    29.      <mvc:resources location="WEB-INF/images/" mapping="/images/**"/>-->
    30. <!--    <mvc:resources location="/static/" mapping="/static/**"/>-->
    31.     <aop:aspectj-autoproxy/>
    32. </beans>

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

    StudentBizImpl

    1. package com.zhanghao.Biz.Impl;
    2.  
    3. import com.zhanghao.Biz.StudentBiz;
    4. import com.zhanghao.mapper.StudentMapper;
    5. import com.zhanghao.model.Student;
    6. import com.zhanghao.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 zhanghao
    14.  * @site
    15.  * @company s集团
    16.  * @create 2023-09-08 23:12
    17.  */
    18. @Service
    19. public class StudentBizImpl implements StudentBiz {
    20.     @Autowired
    21.     private StudentMapper studentMapper;
    22.  
    23.     @Override
    24.     public int deleteByPrimaryKey(String sid) {
    25.         return studentMapper.deleteByPrimaryKey(sid);
    26.     }
    27.  
    28.     @Override
    29.     public int insert(Student record) {
    30.         return studentMapper.insert(record);
    31.     }
    32.  
    33.     @Override
    34.     public int insertSelective(Student record) {
    35.         return studentMapper.insertSelective(record);
    36.     }
    37.  
    38.     @Override
    39.     public Student selectByPrimaryKey(String sid) {
    40.         return studentMapper.selectByPrimaryKey(sid);
    41.     }
    42.  
    43.     @Override
    44.     public int updateByPrimaryKeySelective(Student record) {
    45.         return studentMapper.updateByPrimaryKeySelective(record);
    46.     }
    47.  
    48.     @Override
    49.     public int updateByPrimaryKey(Student record) {
    50.         return studentMapper.updateByPrimaryKey(record);
    51.     }
    52.  
    53.     @Override
    54.     public List<Student> selBySnamePager(Student student, PageBean pageBean) {
    55.         return studentMapper.selBySnamePager(student);
    56.     }
    57.  
    58.  
    59. }
    60.

    PagerAspect

    1. package com.zhanghao.aspect;
    2.  
    3. import com.github.pagehelper.PageHelper;
    4. import com.github.pagehelper.PageInfo;
    5. import com.zhanghao.utils.PageBean;
    6. import org.aspectj.lang.ProceedingJoinPoint;
    7. import org.aspectj.lang.annotation.Around;
    8. import org.aspectj.lang.annotation.Aspect;
    9. import org.springframework.stereotype.Component;
    10.  
    11. import java.util.List;
    12.  
    13. /**
    14.  * @author zhanghao
    15.  * @site
    16.  * @company s集团
    17.  * @create 2023-08-25 17:01
    18.  */
    19. @Aspect
    20. @Component
    21. public class PagerAspect {
    22.  
    23.     @Around("execution(* *..*Biz.*Pager(..))")
    24.     public Object invoke(ProceedingJoinPoint args) throws Throwable {
    25.         PageBean pageBean = null;
    26.         //获取目标中的所有方法
    27.         Object[] args1 = args.getArgs();
    28.         for (Object o : args1) {
    29.             if (o instanceof PageBean) {
    30.                 pageBean = (PageBean) o;
    31.                 break;
    32.             }
    33.         }
    34.         if (pageBean != null && pageBean.isPagination()) {
    35.             PageHelper.startPage(pageBean.getPage(), pageBean.getRows());
    36.         }
    37.         Object proceed = args.proceed();
    38.         if (pageBean != null && pageBean.isPagination()) {
    39.             PageInfo pageInfo = new PageInfo((List) proceed);
    40.             pageBean.setTotal((int) pageInfo.getTotal());
    41.         }
    42.         return proceed;
    43.         }
    44.  
    45. }
    46.

    PageTag

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

    • 实现功能

    StudentController

    1. package com.zhanghao.web;
    2.  
    3. import com.zhanghao.Biz.StudentBiz;
    4. import com.zhanghao.model.Student;
    5. import com.zhanghao.utils.PageBean;
    6. import org.springframework.beans.factory.annotation.Autowired;
    7. import org.springframework.stereotype.Controller;
    8. import org.springframework.ui.Model;
    9. import org.springframework.web.bind.annotation.PathVariable;
    10. import org.springframework.web.bind.annotation.RequestMapping;
    11.  
    12. import javax.servlet.http.HttpServletRequest;
    13. import java.util.List;
    14.  
    15. /**
    16.  * @author zhanghao
    17.  * @site
    18.  * @company s集团
    19.  * @create 2023-09-08 21:52
    20.  */
    21. @Controller
    22. @RequestMapping("/student")
    23. public class StudentController {
    24.     @Autowired
    25.     private StudentBiz studentBiz;
    26.  
    27.     @RequestMapping("/list")
    28.     public String list(Student student, HttpServletRequest request){
    29.         PageBean pageBean = new PageBean();
    30.         pageBean.setRequest(request);
    31.         List<Student> students = studentBiz.selBySnamePager(student, pageBean);
    32.         request.setAttribute("list",students);
    33.         request.setAttribute("pageBean",pageBean);
    34.         return "stu/list";
    35.     }
    36.  
    37.     @RequestMapping("/add")
    38.     public String add(Student student){
    39.         studentBiz.insertSelective(student);
    40.         return "redirect:list";
    41.     }
    42.  
    43.     @RequestMapping("/del/{sid}")
    44.     public String add(@PathVariable("sid") String sid){
    45.         studentBiz.deleteByPrimaryKey(sid);
    46.         return "redirect:/student/list";
    47.     }
    48.  
    49.     @RequestMapping("/edit")
    50.     public String edit(Student student){
    51.         studentBiz.updateByPrimaryKeySelective(student);
    52.         return "redirect:list";
    53.     }
    54.  
    55.     @RequestMapping("/pareSave")
    56.     public String pareSave(Student student, Model model){
    57.         if(student!=null && student.getSid()!=null){
    58.             Student s = studentBiz.selectByPrimaryKey(student.getSid());
    59.             model.addAttribute("s",s);
    60.         }
    61.         return "stu/edit";
    62.  
    63.     }
    64.  
    65.  
    66. }
    67.

    JSP

    List.jsp

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2.          pageEncoding="UTF-8"%>
    3. <!DOCTYPE html >
    4. <html>
    5. <head>
    6. <%@ include file="/common/header.jsp" %>
    7. </head>
    8. <body>
    9. <form class="form-inline"
    10.       action="/student/list" method="post">
    11.     <div class="form-group mb-2">
    12.         <input type="text" class="form-control-plaintext" name="sname"
    13.                placeholder="请输入学生名称">
    14.         <!-- 			<input name="rows" value="20" type="hidden"> -->
    15.         <!-- 不想分页 -->
    16. <%--        <input name="pagination" value="false" type="hidden">--%>
    17.     </div>
    18.     <button type="submit" class="btn btn-primary mb-2">查询</button>
    19.     <a class="btn btn-primary mb-2" href="/student/pareSave">新增</a>
    20. </form>
    21.  
    22. <table class="table table-striped ">
    23.     <thead>
    24.     <tr>
    25.         <th scope="col">学生编号</th>
    26.         <th scope="col">学生名称</th>
    27.         <th scope="col">学生年龄</th>
    28.         <th scope="col">学生性别</th>
    29.         <th scope="col">操作</th>
    30.     </tr>
    31.     </thead>
    32.     <tbody>
    33.     <c:forEach  var="s" items="${list }">
    34.         <tr>
    35.             <td>${s.sid }</td>
    36.             <td>${s.sname }</td>
    37.             <td>${s.sage }</td>
    38.             <td>${s.ssex }</td>
    39.             <td>
    40.                 <a href="/student/pareSave?sid=${s.sid}">修改</a>
    41.                 <a href="/student/del/${s.sid}">删除</a>
    42.             </td>
    43.         </tr>
    44.     </c:forEach>
    45.     </tbody>
    46. </table>
    47. <!-- 这一行代码就相当于前面分页需求前端的几十行了 -->
    48. <z:page pageBean="${pageBean }"></z:page>
    49. ${pageBean}
    50. </body>
    51. </html>

    edit.jsp

    1. <%@ page language="java" contentType="text/html; charset=UTF-8"
    2.          pageEncoding="UTF-8"%>
    3. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    4. <html>
    5. <head>
    6.     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    7.     <title></title>
    8. </head>
    9. <body>
    10. <form action="${pageContext.request.contextPath }/${empty s ? 'student/add' : 'student/edit'}" method="post">
    11.     学生编号:<input type="text" name="sid" value="${s.sid }"><br>
    12.     学生姓名:<input type="text" name="sname" value="${s.sname }"><br>
    13.     学生年龄:<input type="text" name="sage" value="${s.sage }"><br>
    14.     学生性别:<input type="text" name="ssex" value="${s.ssex }"><br>
    15.     <input type="submit">
    16. </form>
    17. </body>
    18. </html>

    heard.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. <!DOCTYPE html >
    6. <html>
    7. <head>
    8.     <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    9.     <link
    10.             href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/css/bootstrap.css"
    11.             rel="stylesheet">
    12.     <script
    13.             src="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/4.5.0/js/bootstrap.js"></script>
    14.     <base href="${pageContext.request.contextPath }" />
    15. </head>

    前端增删改查实现一般需要完成以下几个步骤：

    1. 前端页面设计。前端页面应该清晰明了，使用户易于理解和使用。需要定义表格用于展示数据，包括表头和表内容，同时还需要添加各种操作按钮用于增加、修改和删除数据。

    2. 接口设计。接口是前后端之间的桥梁，要实现增删改查功能，需要定义对应的增删改查接口。接口应该具有明确的功能和参数，以便前端能够正确调用。

    3. 数据库设计。数据库是存储数据的重要组成部分。需要定义对应的数据表，包括数据列、数据类型和主键等，以便后台能够存储数据并进行操作。

    4. 前端逻辑实现。前端需要编写对应的JavaScript代码来实现增删改查功能。具体包括：对表格进行初始化、监听操作按钮点击事件、调用后台接口进行数据操作等。

    5. 后台接口实现。后台接口需要根据前端定义的接口进行实现。一般需要包括对应的增删改查方法，以便能够正确处理前端传递的参数和数据。

    6. 后台逻辑实现。后台需要根据前端传递的参数和数据，进行相应的处理，包括数据的存储和修改、数据的查询和删除等。同时，还需要对数据进行校验和验证，保证数据的正确性和安全性。

    综上所述，前端增删改查实现需要前后端配合完成，同时还需要遵循一定的规范和标准，才能够实现功能完善、性能优良的系统。

  • 相关阅读:
    Liunx-02建立liunx实验环境
    Spring 框架学习（六）---- Bean作用域
    09:STM32-------USART串口通信+串口数据包
    CPU卡MF下目录基本文件（DIR）的结构
    寄存器介绍
    开源OA协同办公系统，集成Flowable流程引擎 可拖拽创建个性表单
    利用ESP32实现蓝牙通信的方法
    MySQL的增删查改（CRUD）
    【网络协议】聊聊UDP协议
    教你实现多线程案例定时器
  • 原文地址：https://blog.csdn.net/djssubddbj/article/details/132769008