• SpringMVC之CRUD和文件上传下载


    哈喽~大家好~~又是我~~~~上期带大家入门了我们的Springmvc这次给大家备一点干货!!!!

    目录

    一、增删改查环境搭建

            2)框架配置文件

    3)web.xml配置

      4)导入工具类  PageBean、tag助手类、tld文件

    二、增删改查测试 

    三、文件上传

    Springmvc.xml配置:

     四、文件下载


    一、增删改查环境搭建

    首先我们先导入我们的pom依赖!

    1. "1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    3. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    4. <modelVersion>4.0.0modelVersion>
    5. <groupId>org.examplegroupId>
    6. <artifactId>ssm2artifactId>
    7. <version>1.0-SNAPSHOTversion>
    8. <packaging>warpackaging>
    9. <name>ssm2 Maven Webappname>
    10. <url>http://www.example.comurl>
    11. <properties>
    12. <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    13. <maven.compiler.source>1.8maven.compiler.source>
    14. <maven.compiler.target>1.8maven.compiler.target>
    15. <maven.compiler.plugin.version>3.7.0maven.compiler.plugin.version>
    16. <spring.version>5.0.2.RELEASEspring.version>
    17. <mybatis.version>3.4.5mybatis.version>
    18. <mysql.version>5.1.44mysql.version>
    19. <pagehelper.version>5.1.2pagehelper.version>
    20. <mybatis.spring.version>1.3.1mybatis.spring.version>
    21. <commons.dbcp2.version>2.1.1commons.dbcp2.version>
    22. <commons.pool2.version>2.4.3commons.pool2.version>
    23. <log4j2.version>2.9.1log4j2.version>
    24. <junit.version>4.12junit.version>
    25. <servlet.version>4.0.0servlet.version>
    26. <lombok.version>1.18.2lombok.version>
    27. properties>
    28. <dependencies>
    29. <dependency>
    30. <groupId>org.springframeworkgroupId>
    31. <artifactId>spring-contextartifactId>
    32. <version>${spring.version}version>
    33. dependency>
    34. <dependency>
    35. <groupId>org.springframeworkgroupId>
    36. <artifactId>spring-ormartifactId>
    37. <version>${spring.version}version>
    38. dependency>
    39. <dependency>
    40. <groupId>org.springframeworkgroupId>
    41. <artifactId>spring-txartifactId>
    42. <version>${spring.version}version>
    43. dependency>
    44. <dependency>
    45. <groupId>org.springframeworkgroupId>
    46. <artifactId>spring-aspectsartifactId>
    47. <version>${spring.version}version>
    48. dependency>
    49. <dependency>
    50. <groupId>org.springframeworkgroupId>
    51. <artifactId>spring-webartifactId>
    52. <version>${spring.version}version>
    53. dependency>
    54. <dependency>
    55. <groupId>org.springframeworkgroupId>
    56. <artifactId>spring-testartifactId>
    57. <version>${spring.version}version>
    58. dependency>
    59. <dependency>
    60. <groupId>org.mybatisgroupId>
    61. <artifactId>mybatisartifactId>
    62. <version>${mybatis.version}version>
    63. dependency>
    64. <dependency>
    65. <groupId>mysqlgroupId>
    66. <artifactId>mysql-connector-javaartifactId>
    67. <version>${mysql.version}version>
    68. dependency>
    69. <dependency>
    70. <groupId>com.github.pagehelpergroupId>
    71. <artifactId>pagehelperartifactId>
    72. <version>${pagehelper.version}version>
    73. dependency>
    74. <dependency>
    75. <groupId>org.mybatisgroupId>
    76. <artifactId>mybatis-springartifactId>
    77. <version>${mybatis.spring.version}version>
    78. dependency>
    79. <dependency>
    80. <groupId>org.apache.commonsgroupId>
    81. <artifactId>commons-dbcp2artifactId>
    82. <version>${commons.dbcp2.version}version>
    83. dependency>
    84. <dependency>
    85. <groupId>org.apache.commonsgroupId>
    86. <artifactId>commons-pool2artifactId>
    87. <version>${commons.pool2.version}version>
    88. dependency>
    89. <dependency>
    90. <groupId>org.apache.logging.log4jgroupId>
    91. <artifactId>log4j-coreartifactId>
    92. <version>${log4j2.version}version>
    93. dependency>
    94. <dependency>
    95. <groupId>org.apache.logging.log4jgroupId>
    96. <artifactId>log4j-apiartifactId>
    97. <version>${log4j2.version}version>
    98. dependency>
    99. <dependency>
    100. <groupId>org.apache.logging.log4jgroupId>
    101. <artifactId>log4j-webartifactId>
    102. <version>${log4j2.version}version>
    103. dependency>
    104. <dependency>
    105. <groupId>junitgroupId>
    106. <artifactId>junitartifactId>
    107. <version>${junit.version}version>
    108. <scope>testscope>
    109. dependency>
    110. <dependency>
    111. <groupId>javax.servletgroupId>
    112. <artifactId>javax.servlet-apiartifactId>
    113. <version>${servlet.version}version>
    114. <scope>providedscope>
    115. dependency>
    116. <dependency>
    117. <groupId>org.projectlombokgroupId>
    118. <artifactId>lombokartifactId>
    119. <version>${lombok.version}version>
    120. <scope>providedscope>
    121. dependency>
    122. <dependency>
    123. <groupId>org.springframeworkgroupId>
    124. <artifactId>spring-webmvcartifactId>
    125. <version>${spring.version}version>
    126. dependency>
    127. <dependency>
    128. <groupId>javax.servlet.jspgroupId>
    129. <artifactId>javax.servlet.jsp-apiartifactId>
    130. <version>2.3.3version>
    131. dependency>
    132. <dependency>
    133. <groupId>jstlgroupId>
    134. <artifactId>jstlartifactId>
    135. <version>1.2version>
    136. dependency>
    137. <dependency>
    138. <groupId>taglibsgroupId>
    139. <artifactId>standardartifactId>
    140. <version>1.1.2version>
    141. dependency>
    142. dependencies>
    143. <build>
    144. <finalName>ssm2finalName>
    145. <resources>
    146. <resource>
    147. <directory>src/main/javadirectory>
    148. <includes>
    149. <include>**/*.xmlinclude>
    150. includes>
    151. resource>
    152. <resource>
    153. <directory>src/main/resourcesdirectory>
    154. <includes>
    155. <include>jdbc.propertiesinclude>
    156. <include>*.xmlinclude>
    157. includes>
    158. resource>
    159. resources>
    160. <pluginManagement>
    161. <plugins>
    162. <plugin>
    163. <groupId>org.apache.maven.pluginsgroupId>
    164. <artifactId>maven-compiler-pluginartifactId>
    165. <version>${maven.compiler.plugin.version}version>
    166. <configuration>
    167. <source>${maven.compiler.source}source>
    168. <target>${maven.compiler.target}target>
    169. <encoding>${project.build.sourceEncoding}encoding>
    170. configuration>
    171. plugin>
    172. <plugin>
    173. <groupId>org.mybatis.generatorgroupId>
    174. <artifactId>mybatis-generator-maven-pluginartifactId>
    175. <version>1.3.2version>
    176. <dependencies>
    177. <dependency>
    178. <groupId>mysqlgroupId>
    179. <artifactId>mysql-connector-javaartifactId>
    180. <version>${mysql.version}version>
    181. dependency>
    182. dependencies>
    183. <configuration>
    184. <overwrite>trueoverwrite>
    185. configuration>
    186. plugin>
    187. <plugin>
    188. <artifactId>maven-clean-pluginartifactId>
    189. <version>3.1.0version>
    190. plugin>
    191. <plugin>
    192. <artifactId>maven-resources-pluginartifactId>
    193. <version>3.0.2version>
    194. plugin>
    195. <plugin>
    196. <artifactId>maven-compiler-pluginartifactId>
    197. <version>3.8.0version>
    198. plugin>
    199. <plugin>
    200. <artifactId>maven-surefire-pluginartifactId>
    201. <version>2.22.1version>
    202. plugin>
    203. <plugin>
    204. <artifactId>maven-war-pluginartifactId>
    205. <version>3.2.2version>
    206. plugin>
    207. <plugin>
    208. <artifactId>maven-install-pluginartifactId>
    209. <version>2.5.2version>
    210. plugin>
    211. <plugin>
    212. <artifactId>maven-deploy-pluginartifactId>
    213. <version>2.8.2version>
    214. plugin>
    215. plugins>
    216. pluginManagement>
    217. build>
    218. project>

            2)框架配置文件

            applicationContext.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" 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. <import resource="applicationContext-mybatis.xml"></import>
    8. </beans>

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

       jdbc.properties:

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

           generatorConfig.xml:

    1. "1.0" encoding="UTF-8" ?>
    2. generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    3. "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    4. <generatorConfiguration>
    5. <properties resource="jdbc.properties"/>
    6. <classPathEntry location="E:\\mvn_repository\\mysql\\mysql-connector-java\\5.1.44\\mysql-connector-java-5.1.44.jar"/>
    7. <context id="infoGuardian">
    8. <commentGenerator>
    9. <property name="suppressAllComments" value="true"/>
    10. <property name="suppressDate" value="true"/>
    11. commentGenerator>
    12. <jdbcConnection driverClass="${jdbc.driver}"
    13. connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
    14. <javaTypeResolver>
    15. <property name="forceBigDecimals" value="false"/>
    16. javaTypeResolver>
    17. <javaModelGenerator targetPackage="com.zking.model"
    18. targetProject="src/main/java">
    19. <property name="enableSubPackages" value="false"/>
    20. <property name="constructorBased" value="true"/>
    21. <property name="trimStrings" value="false"/>
    22. <property name="immutable" value="false"/>
    23. javaModelGenerator>
    24. <sqlMapGenerator targetPackage="com.zking.mapper"
    25. targetProject="src/main/java">
    26. <property name="enableSubPackages" value="false"/>
    27. sqlMapGenerator>
    28. <javaClientGenerator targetPackage="com.zking.mapper"
    29. targetProject="src/main/java" type="XMLMAPPER">
    30. <property name="enableSubPackages" value="false"/>
    31. javaClientGenerator>
    32. <table schema="" tableName="t_struts_class" domainObjectName="Clazz"
    33. enableCountByExample="false" enableDeleteByExample="false"
    34. enableSelectByExample="false" enableUpdateByExample="false">
    35. table>
    36. context>
    37. generatorConfiguration>

             log4j2.xml:

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

    springMVC-servlet.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" 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
    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 http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
    8. <aop:aspectj-autoproxy/>
    9. <context:component-scan base-package="com.zking.controller"/>
    10. <mvc:annotation-driven>mvc:annotation-driven>
    11. <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    12. <property name="viewClass"
    13. value="org.springframework.web.servlet.view.JstlView">property>
    14. <property name="prefix" value="/"/>
    15. <property name="suffix" value=".jsp"/>
    16. bean>
    17. <mvc:resources location="/images/" mapping="/images/**"/>
    18. beans>

    3)web.xml配置

                    dispatcherServlet

                    ContextLoadListener

         

    1. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
    2. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    3. xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
    4. version="3.1">
    5. <display-name>Archetype Created Web Application</display-name>
    6. <context-param>
    7. <param-name>contextConfigLocation</param-name>
    8. <param-value>classpath:applicationContext.xml</param-value>
    9. </context-param>
    10. <!-- 读取Spring上下文的监听器 -->
    11. <listener>
    12. <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    13. </listener>
    14. <!-- Spring MVC servlet -->
    15. <servlet>
    16. <servlet-name>SpringMVC</servlet-name>
    17. <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    18. <!--此参数可以不配置,默认值为:/WEB-INF/springmvc-servlet.xml-->
    19. <init-param>
    20. <param-name>contextConfigLocation</param-name>
    21. <param-value>/WEB-INF/Springmvc-servlet.xml</param-value>
    22. </init-param>
    23. <load-on-startup>1</load-on-startup>
    24. <!--web.xml 3.0的新特性,是否支持异步-->
    25. <async-supported>true</async-supported>
    26. </servlet>
    27. <servlet-mapping>
    28. <servlet-name>SpringMVC</servlet-name>
    29. <url-pattern>/</url-pattern>
    30. </servlet-mapping>
    31. <!-- 中文乱码处理 -->
    32. <filter>
    33. <filter-name>encodingFilter</filter-name>
    34. <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    35. <!--web.xml 3.0的新特性,是否支持异步-->
    36. <async-supported>true</async-supported>
    37. <init-param>
    38. <param-name>encoding</param-name>
    39. <param-value>UTF-8</param-value>
    40. </init-param>
    41. </filter>
    42. <filter-mapping>
    43. <filter-name>encodingFilter</filter-name>
    44. <url-pattern>/*</url-pattern>
    45. </filter-mapping>
    46. </web-app>

      4)导入工具类  PageBean、tag助手类、tld文件

    PageBean :、

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

    助手类(PageTag ): 

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

    1. <?xml version="1.0" encoding="UTF-8" ?>
    2. <taglib xmlns="http://java.sun.com/xml/ns/j2ee"
    3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4. xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-jsptaglibrary_2_0.xsd"
    5. version="2.0">
    6. <description>zking 1.1 core library</description>
    7. <display-name>zking core</display-name>
    8. <tlib-version>1.1</tlib-version>
    9. <short-name>zking</short-name>
    10. <uri>http://jsp.veryedu.cn</uri>
    11. <tag>
    12. <name>page</name>
    13. <tag-class>com.zking.ssm.tag.PageTag</tag-class>
    14. <body-content>JSP</body-content>
    15. <attribute>
    16. <name>pageBean</name>
    17. <required>true</required>
    18. <rtexprvalue>true</rtexprvalue>
    19. </attribute>
    20. </tag>
    21. </taglib>

    接下来就进行我们的编码阶段了!!
    我们以这张表为主!

     先写我们的实体类:

    1. package com.zking.model;
    2. public class Clazz {
    3. private Integer cid;
    4. private String cname;
    5. private String cteacher;
    6. private String pic;
    7. public Clazz(Integer cid, String cname, String cteacher, String pic) {
    8. this.cid = cid;
    9. this.cname = cname;
    10. this.cteacher = cteacher;
    11. this.pic = pic;
    12. }
    13. public Clazz() {
    14. super();
    15. }
    16. public Integer getCid() {
    17. return cid;
    18. }
    19. public void setCid(Integer cid) {
    20. this.cid = cid;
    21. }
    22. public String getCname() {
    23. return cname;
    24. }
    25. public void setCname(String cname) {
    26. this.cname = cname;
    27. }
    28. public String getCteacher() {
    29. return cteacher;
    30. }
    31. public void setCteacher(String cteacher) {
    32. this.cteacher = cteacher;
    33. }
    34. public String getPic() {
    35. return pic;
    36. }
    37. public void setPic(String pic) {
    38. this.pic = pic;
    39. }
    40. }

    ClazzMapper  

    1. package com.zking.mapper;
    2. import com.zking.model.Clazz;
    3. import org.springframework.stereotype.Repository;
    4. import java.util.List;
    5. @Repository
    6. public interface ClazzMapper {
    7. int deleteByPrimaryKey(Integer cid);
    8. int insert(Clazz record);
    9. int insertSelective(Clazz record);
    10. Clazz selectByPrimaryKey(Integer cid);
    11. List listPager(Clazz clazz);
    12. int updateByPrimaryKeySelective(Clazz record);
    13. int updateByPrimaryKey(Clazz record);
    14. }

    ClazzMapper.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.zking.mapper.ClazzMapper" >
    4. <resultMap id="BaseResultMap" type="com.zking.model.Clazz" >
    5. <constructor >
    6. <idArg column="cid" jdbcType="INTEGER" javaType="java.lang.Integer" />
    7. <arg column="cname" jdbcType="VARCHAR" javaType="java.lang.String" />
    8. <arg column="cteacher" jdbcType="VARCHAR" javaType="java.lang.String" />
    9. <arg column="pic" jdbcType="VARCHAR" javaType="java.lang.String" />
    10. </constructor>
    11. </resultMap>
    12. <sql id="Base_Column_List" >
    13. cid, cname, cteacher, pic
    14. </sql>
    15. <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    16. select
    17. <include refid="Base_Column_List" />
    18. from t_struts_class
    19. where cid = #{cid,jdbcType=INTEGER}
    20. </select>
    21. <select id="listPager" resultType="com.zking.model.Clazz" parameterType="com.zking.model.Clazz" >
    22. select
    23. <include refid="Base_Column_List" />
    24. from t_struts_class
    25. <where>
    26. <if test="cname !=null and cname !=''">
    27. and cname like concat('%')
    28. </if>
    29. <if test="cid !=null and cid !=''">
    30. and cid = #{cid}
    31. </if>
    32. </where>
    33. order by cid desc
    34. </select>
    35. <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer" >
    36. delete from t_struts_class
    37. where cid = #{cid,jdbcType=INTEGER}
    38. </delete>
    39. <insert id="insert" parameterType="com.zking.model.Clazz" >
    40. insert into t_struts_class (cid, cname, cteacher,
    41. pic)
    42. values (#{cid,jdbcType=INTEGER}, #{cname,jdbcType=VARCHAR}, #{cteacher,jdbcType=VARCHAR},
    43. #{pic,jdbcType=VARCHAR})
    44. </insert>
    45. <insert id="insertSelective" parameterType="com.zking.model.Clazz" >
    46. insert into t_struts_class
    47. <trim prefix="(" suffix=")" suffixOverrides="," >
    48. <if test="cid != null" >
    49. cid,
    50. </if>
    51. <if test="cname != null" >
    52. cname,
    53. </if>
    54. <if test="cteacher != null" >
    55. cteacher,
    56. </if>
    57. <if test="pic != null" >
    58. pic,
    59. </if>
    60. </trim>
    61. <trim prefix="values (" suffix=")" suffixOverrides="," >
    62. <if test="cid != null" >
    63. #{cid,jdbcType=INTEGER},
    64. </if>
    65. <if test="cname != null" >
    66. #{cname,jdbcType=VARCHAR},
    67. </if>
    68. <if test="cteacher != null" >
    69. #{cteacher,jdbcType=VARCHAR},
    70. </if>
    71. <if test="pic != null" >
    72. #{pic,jdbcType=VARCHAR},
    73. </if>
    74. </trim>
    75. </insert>
    76. <update id="updateByPrimaryKeySelective" parameterType="com.zking.model.Clazz" >
    77. update t_struts_class
    78. <set >
    79. <if test="cname != null" >
    80. cname = #{cname,jdbcType=VARCHAR},
    81. </if>
    82. <if test="cteacher != null" >
    83. cteacher = #{cteacher,jdbcType=VARCHAR},
    84. </if>
    85. <if test="pic != null" >
    86. pic = #{pic,jdbcType=VARCHAR},
    87. </if>
    88. </set>
    89. where cid = #{cid,jdbcType=INTEGER}
    90. </update>
    91. <update id="updateByPrimaryKey" parameterType="com.zking.model.Clazz" >
    92. update t_struts_class
    93. set cname = #{cname,jdbcType=VARCHAR},
    94. cteacher = #{cteacher,jdbcType=VARCHAR},
    95. pic = #{pic,jdbcType=VARCHAR}
    96. where cid = #{cid,jdbcType=INTEGER}
    97. </update>
    98. </mapper>

    PagerAspect : 

    1. package com.zking.ssm.aspect;
    2. import com.github.pagehelper.PageHelper;
    3. import com.github.pagehelper.PageInfo;
    4. import com.zking.ssm.util.PageBean;
    5. import org.aspectj.lang.ProceedingJoinPoint;
    6. import org.aspectj.lang.annotation.Around;
    7. import org.aspectj.lang.annotation.Aspect;
    8. import org.springframework.stereotype.Component;
    9. import java.util.List;
    10. @Component
    11. @Aspect
    12. public class PagerAspect {
    13. /**
    14. * *:返回值类型
    15. * *..:无线包
    16. * *Service:以Service结尾接口名
    17. * *Pager:以Pager结尾的方法名
    18. * 只要同时匹配上诉四个条件,就会被列为目标对象
    19. * 上诉配置要生效,代理注解 不能少
    20. * @param args
    21. * @return
    22. * @throws Throwable
    23. */
    24. @Around("execution(* *..*Biz.*Pager(..))")
    25. public Object invoke(ProceedingJoinPoint args) throws Throwable {
    26. Object[] params = args.getArgs();
    27. PageBean pageBean = null;
    28. for (Object param : params) {
    29. if(param instanceof PageBean){
    30. pageBean = (PageBean)param;
    31. break;
    32. }
    33. }
    34. if(pageBean != null && pageBean.isPagination())
    35. PageHelper.startPage(pageBean.getPage(),pageBean.getRows());
    36. // 执行目标方法
    37. Object list = args.proceed(params);//获取目标方法返回的结果
    38. if(null != pageBean && pageBean.isPagination()){
    39. PageInfo pageInfo = new PageInfo((List) list);
    40. pageBean.setTotal(pageInfo.getTotal()+"");
    41. }
    42. return list;
    43. }
    44. }

    ClazzController  

    1. package com.zking.controller;
    2. import com.zking.model.Clazz;
    3. import com.zking.ssm.biz.ClazzBiz;
    4. import com.zking.ssm.util.PageBean;
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.stereotype.Controller;
    7. import org.springframework.web.bind.annotation.RequestMapping;
    8. import javax.servlet.http.HttpServletRequest;
    9. import java.util.List;
    10. @Controller
    11. @RequestMapping("/clz")
    12. public class ClazzController {
    13. @Autowired
    14. private ClazzBiz clazzBiz;
    15. // list——>clzlist
    16. // toList——>重定向list——>"redirect:/clz/list"
    17. // toEdit——>跳转到编辑界面——>clzEdit
    18. // Clazz:以前通过模型驱动接口封装,现在是直接在方法中接收参数即可
    19. @RequestMapping("/list")
    20. public String list(Clazz clazz, HttpServletRequest request){
    21. PageBean pageBean=new PageBean();
    22. pageBean.setRequest(request);
    23. List lst = this.clazzBiz.listPager(clazz, pageBean);
    24. request.setAttribute("lst",lst);
    25. request.setAttribute("pageBean",pageBean);
    26. return "clzList";
    27. }
    28. @RequestMapping("/toEdit")
    29. public String toEdit(Clazz clazz, HttpServletRequest request){
    30. Integer cid = clazz.getCid();
    31. //传递了的id代表了修改,没传代表新增
    32. if(cid !=null){
    33. List lst=this.clazzBiz.listPager(clazz,null);
    34. request.setAttribute("b",lst.get(0));
    35. }
    36. return "clzEdit";
    37. }
    38. @RequestMapping("/add")
    39. public String add(Clazz clazz){
    40. this.clazzBiz.insertSelective(clazz);
    41. return "redirect:/clz/list";
    42. }
    43. @RequestMapping("/edit")
    44. public String edit(Clazz clazz){
    45. this.clazzBiz.updateByPrimaryKeySelective(clazz);
    46. return "redirect:/clz/list";
    47. }
    48. @RequestMapping("/del")
    49. public String del(Clazz clazz){
    50. this.clazzBiz.deleteByPrimaryKey(clazz.getCid());
    51. return "redirect:/clz/list";
    52. }
    53. }

     ClazzBiz

    1. package com.zking.ssm.biz;
    2. import com.zking.model.Clazz;
    3. import com.zking.ssm.util.PageBean;
    4. import java.util.List;
    5. public interface ClazzBiz {
    6. int deleteByPrimaryKey(Integer cid);
    7. int insert(Clazz record);
    8. int insertSelective(Clazz record);
    9. Clazz selectByPrimaryKey(Integer cid);
    10. int updateByPrimaryKeySelective(Clazz record);
    11. int updateByPrimaryKey(Clazz record);
    12. List listPager(Clazz clazz, PageBean pageBean);
    13. }

    ClazzBizImpl  

    1. package com.zking.ssm.biz.impl;
    2. import com.zking.mapper.ClazzMapper;
    3. import com.zking.model.Clazz;
    4. import com.zking.ssm.biz.ClazzBiz;
    5. import com.zking.ssm.util.PageBean;
    6. import org.springframework.beans.factory.annotation.Autowired;
    7. import org.springframework.stereotype.Service;
    8. import sun.security.provider.certpath.CertId;
    9. import java.util.List;
    10. @Service
    11. public class ClazzBizImpl implements ClazzBiz {
    12. @Autowired
    13. private ClazzMapper clazzMapper;
    14. @Override
    15. public int deleteByPrimaryKey(Integer cid) {
    16. return clazzMapper.deleteByPrimaryKey(cid);
    17. }
    18. @Override
    19. public int insert(Clazz record) {
    20. return clazzMapper.insert(record);
    21. }
    22. @Override
    23. public int insertSelective(Clazz record) {
    24. return clazzMapper.insertSelective(record);
    25. }
    26. @Override
    27. public Clazz selectByPrimaryKey(Integer cid) {
    28. return clazzMapper.selectByPrimaryKey(cid);
    29. }
    30. @Override
    31. public int updateByPrimaryKeySelective(Clazz record) {
    32. return clazzMapper.updateByPrimaryKeySelective(record);
    33. }
    34. @Override
    35. public int updateByPrimaryKey(Clazz record) {
    36. return clazzMapper.updateByPrimaryKey(record);
    37. }
    38. @Override
    39. public List listPager(Clazz clazz, PageBean pageBean){
    40. return clazzMapper.listPager(clazz);
    41. }
    42. }

     前端页面代码:

    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. <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. .page-item input, .page-item b {
    24. line-height: 38px;
    25. float: left;
    26. font-weight: 400;
    27. }
    28. .page-item.go-input {
    29. margin: 0 10px;
    30. }
    31. </style>
    32. </head>
    33. <body>
    34. <form class="form-inline" action="${pageContext.request.contextPath }/clz/list" method="post">
    35. <div class="form-group mb-2">
    36. <input type="text" class="form-control-plaintext" name="cname" placeholder="请输入班级名称"/>
    37. </div>
    38. <button type="submit" class="btn btn-primary mb-2">查询</button>
    39. <a class="btn btn-primary mb-2" href="${pageContext.request.contextPath }/clz/toEdit?cid=${b.cid}">新增</a>
    40. </form>
    41. <table class='table table-striped ' >
    42. <thead>
    43. <tr>
    44. <th scope="col">ID</th>
    45. <th scope="col">班级名称</th>
    46. <th scope="col">指导老师</th>
    47. <th scope="col">班级相册</th>
    48. <th scope="col">操作</th>
    49. </tr>
    50. </thead>
    51. <tbody>
    52. <c:forEach var="b" items="${lst }">
    53. <tr>
    54. <td>${b.cid }</td>
    55. <td>${b.cname }</td>
    56. <td>${b.cteacher }</td>
    57. <td>
    58. <img src="${pageContext.request.contextPath }${b.pic }" style="height:100px;width:100px"/>
    59. </td>
    60. <td>
    61. <a href="${pageContext.request.contextPath }/clz/toEdit?cid=${b.cid}">修改</a>
    62. <a href="${pageContext.request.contextPath }/clz/del?cid=${b.cid}">删除</a>
    63. <a href="${pageContext.request.contextPath }/clzUpload.jsp?cid=${b.cid}">上传图片</a>
    64. <a href="${pageContext.request.contextPath }/clz/download?cid=${b.cid}">下载图片</a>
    65. </td>
    66. </tr>
    67. </c:forEach>
    68. </tbody>
    69. </table>
    70. <!-- 这一行代码就相当于前面分页需求前端的几十行了 -->
    71. <z:page pageBean="${pageBean }"></z:page>
    72. </body>
    73. </html>

     clzEdit:

    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 }/clz/${empty b ? 'add' : 'edit'}" method="post">
    11. cid:<input type="text" name="cid" value="${b.cid }"><br>
    12. cname:<input type="text" name="cname" value="${b.cname }"><br>
    13. cteacher:<input type="text" name="cteacher" value="${b.cteacher }"><br>
    14. <input type="submit">
    15. </form>
    16. </body>
    17. </html>

    二、增删改查测试 

    查询

    其他功能有误, 正在努力中.....

    三、文件上传

    我们先导入我们的pom依赖

    1. <dependency>
    2. <groupId>commons-fileupload</groupId>
    3. <artifactId>commons-fileupload</artifactId>
    4. <version>1.3.3</version>
    5. </dependency>

    Springmvc.xml配置:

    1. <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
    2. <!-- 必须和用户JSP 的pageEncoding属性一致,以便正确解析表单的内容 -->
    3. <property name="defaultEncoding" value="UTF-8"></property>
    4. <!-- 文件最大大小(字节) 1024*1024*50=50M-->
    5. <property name="maxUploadSize" value="52428800"></property>
    6. <!--resolveLazily属性启用是为了推迟文件解析,以便捕获文件大小异常-->
    7. <property name="resolveLazily" value="true"/>
    8. </bean>

    ClazzDto :

    1. package com.zking.model.dto;
    2. import com.zking.model.Clazz;
    3. import org.springframework.web.multipart.MultipartFile;
    4. public class ClazzDto extends Clazz {
    5. // multipartFile的属性名一定要跟form中的表单属性名一致
    6. private MultipartFile picFile;
    7. public MultipartFile getPicFile() {
    8. return picFile;
    9. }
    10. public void setPicFile(MultipartFile picFile) {
    11. this.picFile = picFile;
    12. }
    13. }

    注意我们的实体类

    ClazzController:

    1. // 文件上传
    2. @RequestMapping("/upload")
    3. public String upload(ClazzDto clazzDto){
    4. try {
    5. // 前台上传的文件
    6. MultipartFile picFile = clazzDto.getPicFile();
    7. // 实际应该配置到resource.properties中
    8. String diskPath="G:/temp";//图片存放地址
    9. // http://localhost:8080/upload/mvc/...png
    10. String requestPath="/upload/mvc/";//数据库保存地址,也是访问地址
    11. //拿到上传文件的名字
    12. String filename = picFile.getOriginalFilename();
    13. FileUtils.copyInputStreamToFile(picFile.getInputStream(),new File(diskPath+filename));
    14. // 将图片上传图片之后,并且将图片地址更新到数据库中
    15. Clazz clazz=new Clazz();
    16. clazz.setCid(clazzDto.getCid());
    17. clazz.setPic(requestPath+filename);
    18. this.clazzBiz.updateByPrimaryKeySelective(clazz);
    19. }catch (Exception e){
    20. e.printStackTrace();
    21. }
    22. return "redirect:/clz/list";
    23. }

     四、文件下载

    1、点击下载传递文件的ID,通过文件的ID查询出文件的路径

    2、通过文件的请求地址,转换成文件存放的硬盘地址

    3、将硬盘中文件下载下来——>固定代码

    ClazzController:

    1. //文件下载
    2. @RequestMapping("/download")
    3. public ResponseEntity download(ClazzDto clazzDto){
    4. try {
    5. //1、点击下载传递文件的ID,通过文件的ID查询出文件的路径
    6. Clazz clazz = this.clazzBiz.selectByPrimaryKey(clazzDto.getCid());
    7. String pic=clazz.getPic();//
    8. String diskPath = "G:/temp/";
    9. String requestPath = "/upload/mvc/";
    10. //2、通过文件的请求地址,转换成文件存放的硬盘地址
    11. String realPath = pic.replace(requestPath, diskPath);
    12. String fileName = realPath.substring(realPath.lastIndexOf("/")+1);
    13. // 3、将硬盘中文件下载下来——>固定代码
    14. File file=new File(realPath);
    15. HttpHeaders headers = new HttpHeaders();//http头信息
    16. String downloadFileName = new String(fileName.getBytes("UTF-8"),"iso-8859-1");//设置编码
    17. headers.setContentDispositionFormData("attachment", downloadFileName);
    18. headers.setContentType(MediaType.APPLICATION_OCTET_STREAM);
    19. //MediaType:互联网媒介类型 contentType:具体请求中的媒体类型信息
    20. return new ResponseEntity<byte[]>(FileUtils.readFileToByteArray(file),headers, HttpStatus.OK);
    21. }catch (Exception e){
    22. e.printStackTrace();
    23. }
    24. return null;
    25. }

    因为一些报错还没解决,今天给大家分享就到这啦~等待博主后续改进!!!

    有发现更好方法的宝宝们可以联系博主进入探讨,为博主指条明路!!!!! 

  • 相关阅读:
    笔记本外接显示器,edge浏览器播放视频黑屏
    Vue Router跨域报错的原因和解决方法
    软件测试的基础知识
    代码随想录day46 | 动态规划P8 | ● 139. ● 多重背包● 背包问题总结
    深入理解Istio流量管理的熔断配置
    流媒体分析之rtmp 协议封装
    【软考-中级】系统集成项目管理工程师-进度管理-关键路径法
    网关及其分类
    jmeter固定定时器,生效是在请求发送前还是发送后
    Redis--list列表
  • 原文地址:https://blog.csdn.net/weixin_63544775/article/details/126413271