1.SpringMVC技术

1.1 技术介绍

  1. 一个MVC框架,在web模型中，MVC是一种很流行的框架，通过把Model，View，Controller分离，把较为复杂的web应用分成逻辑清晰的几部分，是为了简化开发，减少出错。
  3. 老李的理解是将原来传统的jsp模式开发，整合成不同的业务分层，更加合理的分离整合代码，减少耦合性。

1.2 技术注意点

1.2.1 @RequestParam注解

请求参数名和列对不上时，可以使用required=”false”来选择可以不用传参，defaultValue来默认请求参数。

  1. public String add(@RequestParam(value="id" required=false)Integer idxxxa, defaultValue="1"){
  2.     ...
  3. }

1.2.2 设置请求和响应编码格式

修改web.xml

  1. <filter>
  2.     <filter-name>encodingFilter</filter-name>
  3.     <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  4.     <init-param>
  5.         <param-name>encoding</param-name>
  6.         <param-value>UTF-8</param-value>
  7.     </init-param>
  8.     <init-param>
  9.         <param-name>forceEncoding</param-name>
  10.         <param-value>true</param-value>
  11.     </init-param>
  12. </filter>
  14. <filter-mapping>
  15.     <filter-name>encodingFilter</filter-name>
  16.     <url-pattern>/*</url-pattern>
  17. </filter-mapping>

1.2.3 静态资源放行

修改spring-mvc.xml

  1. <mvc:resources mapping="/img/**" location="/img/" />
  2. <mvc:resources mapping="/js/**" location="/js/" />
  3. <mvc:resources mapping="/css/**" location="/css/" />
  4. <mvc:resources mapping="/html/**" location="/html/" />

1.2.4 全局更改编码

修改tomcat的server.xml

  1. <Connector URIEncoding="UTF-8" connectionTimeout="20000", port="8080" protocol="HTTP/1.1" ......>

1.2.5 @ResponseBody注解

加上这个注解后，是无法返回jsp页面，所以在springmvc中要根据@RestController 

  1. @RequestMapping("/getStudent")
  2. @ResponseBody
  3. public String getStudentInfo(@RequestParam(value = "id", required = false) Long id,ModelMap model) {
  4.    List<Student> student = studentService.getStudentById(id);
  5.    System.out.println(student);
  6.    model.addAttribute("student", student.get(0));
  7.    return "student";
  8. }

1.3 技术具体demo文件路径

链接：https://pan.baidu.com/s/1j2-VIv-A5jNgX2WJiQaaAw
提取码：hm00

1.4 demo的UML图

image.png

image.png

1.5 demo的技术代码实现

1.5.1 pom的编写
  1. <!--统一jar包-->
  2. <properties>
  3.      <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  4.      <spring.vision>5.0.2.RELEASE</spring.vision>
  5.      <shiro.version>1.2.3</shiro.version>
  6.      <junit.version>4.12</junit.version>
  7.      <mysql.version>5.1.38</mysql.version>
  8.      <mybatis.ehcache.version>1.1.0</mybatis.ehcache.version>
  9.      <log4j.version>1.2.17</log4j.version>
  10.      <slf4j.version>1.7.5</slf4j.version>
  11.      <slf4j.log4j.version>1.7.12</slf4j.log4j.version>
  12.      <mybatis.generator.version>1.3.2</mybatis.generator.version>
  13.      <cglib.version>3.1</cglib.version>
  14.      <asm.version>3.3.1</asm.version>
  15.      <pagehelper.version>5.1.8</pagehelper.version>
  16.      <mybatis.spring.version>1.3.2</mybatis.spring.version>
  17.      <aspectjweaver.version>1.9.2</aspectjweaver.version>
  18.      <c3p0.version>0.9.5.2</c3p0.version>
  19. </properties>
  20. <dependencies>
  21.     <dependency>
  22.         <groupId>commons-fileupload</groupId>
  23.         <artifactId>commons-fileupload</artifactId>
  24.         <version>1.2.1</version>
  25.     </dependency>
  26.     <dependency>
  27.         <groupId>javax.servlet</groupId>
  28.         <artifactId>servlet-api</artifactId>
  29.         <version>2.5</version>
  30.     </dependency>
  31.     <!--mybatis框架-->
  32.     <dependency>
  33.         <groupId>org.mybatis</groupId>
  34.         <artifactId>mybatis</artifactId>
  35.         <version>3.4.6</version>
  36.     </dependency>
  37.     <!-- JUnit单元测试工具 -->
  38.     <dependency>
  39.         <groupId>junit</groupId>
  40.         <artifactId>junit</artifactId>
  41.         <version>${junit.version}</version>
  42.         <!-- 表示开发的时候引入，发布的时候不会加载此包 -->
  43.         <scope>test</scope>
  44.     </dependency>
  45.     <!--mysql连接池jar包-->
  46.     <dependency>
  47.         <groupId>mysql</groupId>
  48.         <artifactId>mysql-connector-java</artifactId>
  49.         <version>${mysql.version}</version>
  50.     </dependency>
  51.     <!--缓存-->
  52.     <dependency>
  53.         <groupId>org.mybatis.caches</groupId>
  54.         <artifactId>mybatis-ehcache</artifactId>
  55.         <version>${mybatis.ehcache.version}</version>
  56.     </dependency>
  57.     <!--打印日志-->
  58.     <dependency>
  59.         <groupId>log4j</groupId>
  60.         <artifactId>log4j</artifactId>
  61.         <version>${log4j.version}</version>
  62.     </dependency>
  63.     <dependency>
  64.         <groupId>org.slf4j</groupId>
  65.         <artifactId>slf4j-api</artifactId>
  66.         <version>${slf4j.version}</version>
  67.     </dependency>
  68.     <dependency>
  69.         <groupId>org.slf4j</groupId>
  70.         <artifactId>slf4j-log4j12</artifactId>
  71.         <version>${slf4j.log4j.version}</version>
  72.     </dependency>
  73.     <!--自动生成bean-->
  74.     <dependency>
  75.         <groupId>org.mybatis.generator</groupId>
  76.         <artifactId>mybatis-generator-core</artifactId>
  77.         <version>${mybatis.generator.version}</version>
  78.     </dependency>
  79.     <!--toString与重载方法过滤-->
  80.     <dependency>
  81.         <groupId>cglib</groupId>
  82.         <artifactId>cglib</artifactId>
  83.         <version>${cglib.version}</version>
  84.     </dependency>
  85.     <dependency>
  86.         <groupId>asm</groupId>
  87.         <artifactId>asm</artifactId>
  88.         <version>${asm.version}</version>
  89.     </dependency>
  90.     <!--分页-->
  91.     <dependency>
  92.         <groupId>com.github.pagehelper</groupId>
  93.         <artifactId>pagehelper</artifactId>
  94.         <version>${pagehelper.version}</version>
  95.     </dependency>
  96.     <!--spring框架核心库-->
  97.     <dependency>
  98.         <groupId>org.springframework</groupId>
  99.         <artifactId>spring-context</artifactId>
  100.         <version>${spring.vision}</version>
  101.     </dependency>
  102.     <!-- spring-aop -->
  103.     <dependency>
  104.         <groupId>org.springframework</groupId>
  105.         <artifactId>spring-aop</artifactId>
  106.         <version>${spring.vision}</version>
  107.     </dependency>
  108.     <dependency>
  109.         <groupId>org.springframework</groupId>
  110.         <artifactId>spring-orm</artifactId>
  111.         <version>${spring.vision}</version>
  112.     </dependency>
  113.     <!--Spring java数据库访问包，在本例中主要用于提供数据源 -->
  114.     <dependency>
  115.         <groupId>org.springframework</groupId>
  116.         <artifactId>spring-jdbc</artifactId>
  117.         <version>${spring.vision}</version>
  118.     </dependency>
  119.     <!--Spring Web-->
  120.     <dependency>
  121.         <groupId>org.springframework</groupId>
  122.         <artifactId>spring-webmvc</artifactId>
  123.         <version>${spring.vision}</version>
  124.     </dependency>
  125.     <dependency>
  126.         <groupId>org.springframework</groupId>
  127.         <artifactId>spring-web</artifactId>
  128.         <version>${spring.vision}</version>
  129.     </dependency>
  130.     <dependency>
  131.         <groupId>org.springframework</groupId>
  132.         <artifactId>spring-context-support</artifactId>
  133.         <version>${spring.vision}</version>
  134.     </dependency>
  135.     <!--spring和mybatis整合-->
  136.     <dependency>
  137.         <groupId>org.mybatis</groupId>
  138.         <artifactId>mybatis-spring</artifactId>
  139.         <version>${mybatis.spring.version}</version>
  140.     </dependency>
  141.     <!-- aspectjweaver 切面-->
  142.     <dependency>
  143.         <groupId>org.aspectj</groupId>
  144.         <artifactId>aspectjweaver</artifactId>
  145.         <version>${aspectjweaver.version}</version>
  146.     </dependency>
  147.     <!--最新版c3p0连接池-->
  148.     <dependency>
  149.         <groupId>com.mchange</groupId>
  150.         <artifactId>c3p0</artifactId>
  151.         <version>${c3p0.version}</version>
  152.     </dependency>
  153. </dependencies>

1.5.2 数据源的配置 jdbc.properties
  1. jdbc.driver=com.mysql.jdbc.Driver
  2. jdbc.url=jdbc:mysql://localhost:3306/stus?useUnicode=true&characterEncoding=utf8&useSSL=false
  3. jdbc.username=root
  4. jdbc.password=123
  5. #最大连接数
  6. maxPoolSize=100
  7. #最小连接数
  8. minPoolSize=20
  9. # 关闭连接后不自动commit
  10. autoCommitOnClose=false
  11. # 获取连接超时时间
  12. checkoutTimeout=10000
  13. # 初始化连接
  14. initialSize=30
  15. #driver default 指定由连接池所创建的连接的只读（read-only）状态。
  16. #如果没有设置该值，则“setReadOnly”方法将不被调用。（某些驱动并不支持只读模式，如：Informix）
  17. defaultReadOnly=
  18. #driver default 指定由连接池所创建的连接的事务级别（TransactionIsolation）。
  19. #可用值为下列之一：（详情可见javadoc。）NONE,READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, SERIALIZABLE
  20. defaultTransactionIsolation=READ_UNCOMMITTED
  21. #连接数
  22. acquireIncrement=30

1.5.3 日志的配置 log4j.properties
  1. #---- global logging configuration
  2. #---- level: FATAL,ERROR,WARN,INFO,DEBUG
  3. #---- appender: console, file, mail
  4. ### set log levels ###
  5. log4j.rootLogger = DEBUG,console
  7. ### 输出到控制台 ###
  8. log4j.appender.console = org.apache.log4j.ConsoleAppender
  9. log4j.appender.console.Target = System.out
  10. log4j.appender.console.layout = org.apache.log4j.PatternLayout
  11. log4j.appender.console.layout.ConversionPattern =  %d{yyyy-MM-dd HH\:mm\:ss} %5p %c{1}:%L - %m%n
  13. ### 输出到日志文件 ###
  14. log4j.appender.file = org.apache.log4j.DailyRollingFileAppender
  15. log4j.appender.file.File = ${webapp.root}/WEB-INF/logs/platform.log
  16. log4j.appender.file.DatePattern=_yyyyMMdd'.log'
  17. #log4j.appender.file.Append = true
  18. #log4j.appender.file.Threshold = INFO
  19. log4j.appender.file.layout = org.apache.log4j.PatternLayout
  20. log4j.appender.file.layout.ConversionPattern =%-d{yyyy-MM-dd HH\:mm\:ss}  [ %t\:%r ] - [ %p ]  %m%n
  22. ### 打印SQL ###
  23. #log4j.logger.com.ibatis=DEBUG
  24. #log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
  25. #log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
  26. #log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
  27. log4j.logger.java.sql.Connection=DEBUG
  28. log4j.logger.java.sql.Statement=DEBUG
  29. log4j.logger.java.sql.PreparedStatement=DEBUG
  30. #log4j.logger.java.sql.ResultSet=DEBUG

1.5.4 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_4_0.xsd"
  5.          version="4.0">
  6.     <!-- 加载Spring容器配置 -->
  7.     <listener>
  8.         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  9.     </listener>
  10.     <!-- 设置Spring容器加载所有的配置文件的路径 -->
  11.     <context-param>
  12.         <param-name>contextConfigLocation</param-name>
  13.         <param-value>classpath:applicationContext.xml,classpath:spring-mvc.xml</param-value>
  14.     </context-param>
  15.     <!-- 配置DispatcherServlet -->
  16.     <servlet>
  17.         <servlet-name>spring-mvc</servlet-name>
  18.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  19.         <init-param>
  20.             <param-name>contextConfigLocation</param-name>
  21.             <param-value>classpath:applicationContext.xml,classpath:spring-mvc.xml</param-value>
  22.         </init-param>
  23.         <!-- 启动加载一次 -->
  24.         <load-on-startup>1</load-on-startup>
  25.     </servlet>
  26.     <servlet-mapping>
  27.         <servlet-name>spring-mvc</servlet-name>
  28.         <!-- 默认匹配所有的请求 -->
  29.         <url-pattern>/</url-pattern>
  30.     </servlet-mapping>
  32.     <!-- 防止Spring内存溢出监听器 -->
  33.     <listener>
  34.         <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
  35.     </listener>
  37.     <!-- 解决工程编码过滤器 -->
  38.     <filter>
  39.         <filter-name>encodingFilter</filter-name>
  40.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  41.         <init-param>
  42.             <param-name>encoding</param-name>
  43.             <param-value>UTF-8</param-value>
  44.         </init-param>
  45.         <init-param>
  46.             <param-name>forceEncoding</param-name>
  47.             <param-value>true</param-value>
  48.         </init-param>
  49.     </filter>
  51.     <filter-mapping>
  52.         <filter-name>encodingFilter</filter-name>
  53.         <url-pattern>/*</url-pattern>
  54.     </filter-mapping>
  56.     <welcome-file-list>
  57.         <welcome-file>index.jsp</welcome-file>
  58.     </welcome-file-list>
  59. </web-app>

1.5.5 springmvc.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:mvc="http://www.springframework.org/schema/mvc"
  6.        xmlns:p="http://www.springframework.org/schema/p"
  7.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  8.        http://www.springframework.org/schema/beans/spring-beans.xsd
  9.        http://www.springframework.org/schema/context
  10.        http://www.springframework.org/schema/context/spring-context.xsd
  11.        http://www.springframework.org/schema/mvc
  12.        http://www.springframework.org/schema/mvc/spring-mvc.xsd ">
  14.     <!-- 自动扫描controller包下所有的类，成为spring mvc 的控制器-->
  15.     <context:component-scan base-package="org.hikktn.controller" use-default-filters="false">
  16.         <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"></context:include-filter>
  17.     </context:component-scan>
  19.     <!--视图解析器-->
  20.     <!--定义JSP文件的位置-->
  21.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  22.         <property name="viewClass" value="org.springframework.web.servlet.view.InternalResourceView"/>
  23.         <property name="prefix" value="/WEB-INF/" />
  24.         <property name="suffix" value=".jsp" />
  25.         <property name="order" value="0"></property>
  26.     </bean>
  28.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  29.         <property name="viewClass" value="org.springframework.web.servlet.view.InternalResourceView"/>
  30.         <property name="prefix" value="/html/" />
  31.         <property name="order" value="10"></property>
  32.         <property name="suffix" value=".html" />
  33.     </bean>
  35.     <!-- 视图解析器：通用视图名来解析视图（Excel） -->
  36.     <bean class="org.springframework.web.servlet.view.BeanNameViewResolver">
  37.         <property name="order" value="100"></property>
  38.     </bean>
  40.     <context:annotation-config/>
  42.     <!-- 开启注解( 用于将对象转换为 JSON) -->
  43.     <mvc:annotation-driven/>
  44.     <!--处理静态资源-->
  45.     <mvc:default-servlet-handler></mvc:default-servlet-handler>
  47.     <!--
  48.         配置静态资源，直接映射到对应的文件夹，不被DispatcherServlet处理，3.04新增功能，需要重新设置spring-mvc-3.0.xsd
  49.     -->
  50.     <mvc:resources mapping="/img/**" location="/img/" />
  51.     <mvc:resources mapping="/js/**" location="/js/" />
  52.     <mvc:resources mapping="/css/**" location="/css/" />
  53.     <mvc:resources mapping="/html/**" location="/html/" />
  55.     <!-- 定义文件上传解析器 -->
  56.     <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"  p:defaultEncoding="UTF-8">
  57.         <!-- 设定文件上传的最大值为100MB，100*1024*1024 -->
  58.         <property name="maxUploadSize">
  59.             <value>104857600</value>
  60.         </property>
  61.         <property name="maxInMemorySize">
  62.             <value>40960</value>
  63.         </property>
  64.     </bean>
  65. </beans>

1.5.6 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"
  5.        xmlns:aop="http://www.springframework.org/schema/aop"
  6.        xmlns:tx="http://www.springframework.org/schema/tx"
  7.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  8.        http://www.springframework.org/schema/beans/spring-beans.xsd
  9.        http://www.springframework.org/schema/context
  10.        http://www.springframework.org/schema/context/spring-context.xsd
  11.        http://www.springframework.org/schema/tx
  12.        http://www.springframework.org/schema/tx/spring-tx.xsd
  13.        http://www.springframework.org/schema/aop
  14.        http://www.springframework.org/schema/aop/spring-aop.xsd">
  15.     <!--引入属性文件，在配置中占位使用 -->
  16.     <context:property-placeholder location="classpath:jdbc.properties"/>
  17.     <!--配置C3P0数据源-->
  18.     <bean id="ds" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
  19.         <!--连接数据库的基本信息-->
  20.         <property name="user" value="${jdbc.username}" />
  21.         <property name="password" value="${jdbc.password}" />
  22.         <property name="jdbcUrl" value="${jdbc.url}" />
  23.         <property name="driverClass" value="${jdbc.driver}" />
  24.         <!--连接池的相应配置-->
  25.         <property name="maxPoolSize" value="${maxPoolSize}"></property>
  26.         <property name="minPoolSize" value="${minPoolSize}"></property>
  27.         <property name="initialPoolSize" value="${initialSize}"></property>
  28.         <property name="acquireIncrement" value="${acquireIncrement}"></property>
  29.         <property name="autoCommitOnClose" value="${autoCommitOnClose}"></property>
  30.     </bean>
  32.     <!--配置mybatis的工厂-->
  33.     <bean id="sessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
  34.         <!--数据源-->
  35.         <property name="dataSource" ref="ds"></property>
  36.         <!-- 配置MyBaties全局配置文件:mybatis-config.xml -->
  37.         <property name="configLocation" value="classpath:mybatis-config.xml"></property>
  38.         <!--类的别名的包-->
  39.         <property name="typeAliasesPackage" value="org.hikktn.model"></property>
  40.         <!-- 扫描sql配置文件:mapper需要的xml文件 -->
  41.         <property name="mapperLocations" value="classpath*:mapper/*.xml" />
  42.     </bean>
  44.     <!--spring和mybatis整合 (自动扫描映射接口)-->
  45.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  46.         <!--指定ioc容器中的mybatis工厂的bean的名字-->
  47.         <property name="sqlSessionFactoryBeanName" value="sessionFactoryBean"></property>
  48.         <!--mapper所在的包-->
  49.         <property name="basePackage" value="org.hikktn.dao"></property>
  50.     </bean>
  52.     <!--声明式事务管理-->
  53.     <!--定义事物管理器，由spring管理事务 -->
  54.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  55.         <property name="dataSource" ref="ds"></property>
  56.     </bean>
  58.     <!--支持注解驱动的事务管理，指定事务管理器 -->
  59.     <!--事务属性-->
  60.     <tx:advice id="advice" transaction-manager="transactionManager">
  61.         <tx:attributes>
  62.             <tx:method name="*" isolation="READ_COMMITTED" propagation="REQUIRED"/>
  63.             <tx:method name="insert*" isolation="SERIALIZABLE" propagation="REQUIRED"></tx:method>
  64.         </tx:attributes>
  65.     </tx:advice>
  67.     <!--配置事务(拦截service)-->
  68.     <aop:config>
  69.         <!--切入点表达式-->
  70.         <aop:pointcut id="pc" expression="execution(* org.hikktn.service.*.*(..))"></aop:pointcut>
  71.         <!--关联切入点表达式和事务属性-->
  72.         <aop:advisor advice-ref="advice" pointcut-ref="pc"></aop:advisor>
  73.     </aop:config>
  75.     <!--使事务注解起作用-->
  76.     <tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>
  78.     <!--只扫描controller的包以外的包-->
  79.     <context:component-scan base-package="org.hikktn">
  80.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"></context:exclude-filter>
  81.     </context:component-scan>
  83.     <!--aspectj支持自动代理实现AOP功能-->
  84.     <aop:aspectj-autoproxy proxy-target-class="true"></aop:aspectj-autoproxy>
  86.     <!-- 拦截器方式配置事物（这里可以不写，只是方便在advice的事务方便增加相应的事务配置） -->
  87.     <tx:advice id="transactionAdvice" transaction-manager="transactionManager">
  88.         <tx:attributes>
  89.             <tx:method name="add*" propagation="REQUIRED" />
  90.             <tx:method name="append*" propagation="REQUIRED" />
  91.             <tx:method name="insert*" propagation="REQUIRED" />
  92.             <tx:method name="save*" propagation="REQUIRED" />
  93.             <tx:method name="update*" propagation="REQUIRED" />
  94.             <tx:method name="modify*" propagation="REQUIRED" />
  95.             <tx:method name="edit*" propagation="REQUIRED" />
  96.             <tx:method name="delete*" propagation="REQUIRED" />
  97.             <tx:method name="remove*" propagation="REQUIRED" />
  98.             <tx:method name="repair" propagation="REQUIRED" />
  99.             <tx:method name="delAndRepair" propagation="REQUIRED" />
  101.             <tx:method name="get*" propagation="SUPPORTS" />
  102.             <tx:method name="find*" propagation="SUPPORTS" />
  103.             <tx:method name="load*" propagation="SUPPORTS" />
  104.             <tx:method name="search*" propagation="SUPPORTS" />
  105.             <tx:method name="datagrid*" propagation="SUPPORTS" />
  107.             <tx:method name="*" propagation="SUPPORTS" />
  108.         </tx:attributes>
  109.     </tx:advice>
  110. </beans>

1.5.7 model的准备
  1. package org.hikktn.model;
  3. public class Student {
  6.     /**
  7.      * 主键
  8.      */
  9.     private Long id;
  11.     /**
  12.      * 名称
  13.      */
  14.     private String name;
  16.     /**
  17.      * 年齡
  18.      */
  19.     private Long age;
  22.     public Long getId() {
  23.         return id;
  24.     }
  26.     public void setId(Long id) {
  27.         this.id = id;
  28.     }
  31.     public String getName() {
  32.         return name;
  33.     }
  35.     public void setName(String name) {
  36.         this.name = name;
  37.     }
  40.     public Long getAge() {
  41.         return age;
  42.     }
  44.     public void setAge(Long age) {
  45.         this.age = age;
  46.     }
  48.     @Override
  49.     public String toString() {
  50.         return "Student{" + "id=" + id + ", name='" + name + '\'' + ", age=" + age + '}';
  51.     }
  52. }

1.5.8 dao的编写
  1. @Repository
  2. public interface StudentDao {
  4.    List<Student> getStudentById(@Param("id")Long id);
  5. }

1.5.9 service的编写
  1. public interface StudentService {
  3.    List<Student> getStudentById(Long id);
  4. }

1.5.10 service实现类的编写
  1. @Service
  2. public class StudentServiceImpl implements StudentService {
  4.     @Autowired
  5.     private StudentDao studentDao;
  7.     public List<Student> getStudentById(Long id) {
  8.         List<Student> student = studentDao.getStudentById(id);
  9.         return student;
  10.     }
  11. }

1.5.11 Controller的编写
  1. @Controller
  2. public class StudentController {
  4.    @Autowired
  5.    private StudentService studentService;
  7.    @RequestMapping(value = "/hello")
  8.    public String hello(ModelMap model) {
  9.       model.addAttribute("message", "Spring 3 MVC Hello World");
  10.       return "index";
  11.    }
  13.    @RequestMapping("/getStudent")
  14.    public String getStudentInfo(@RequestParam(value = "id", required = false) Long id,ModelMap model) {
  15.       List<Student> student = studentService.getStudentById(id);
  16.       System.out.println(student);
  17.       model.addAttribute("student", student.get(0));
  18.       return "student";
  19.    }
  20. }

1.5.12 启动访问路径

http://localhost:8080/hello
http://localhost:8080/getStudent?id=1
image.png

1.5.13 jsp的编写

index.jsp

  1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  2.   <html>
  4.     <head>
  5.       <title>Title</title>
  6.     </head>
  8.     <body>
  9.       <span>Hello World!</span>
  10.       <p>message:${message}</p>
  11.     </body>
  12. </html>

student.jsp

  1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  2.   <html>
  4.     <head>
  5.       <title>Title</title>
  6.     </head>
  8.     <body>
  9.       <p>学生信息:</p>
  10.       <p>学生姓名：${student.name}</p>
  11.       <p>学生年龄：${student.age}</p>
  12.     </body>
  13. </html>

1.6 对应博客地址

1.7 环境准备

1.7.1 在idea上准备tomcat

https://blog.csdn.net/wsjzzcbq/article/details/89463304

1.7.2 idea上配置webapp

https://blog.csdn.net/qq_44575680/article/details/89449581

1.7.3 idea上移除或加入jar包

image.png
解释：左侧的available elements里面，如果出现jar包，则直接手动拖动lib目录下，并移除lib目录下报红的jar包，报红的jar包代表不存在。这里主要是当你的jar包出现冲突，某个类找不到的时候，你需要更改pom，但是maven依赖成功了，问题还是没有解决，这时你就需要手动排除掉一些错误引入的jar包，保证正确的jar包引入。

1.7.4 配置详解

1.7.4.1 数据库的数据源配置解释
  1. 本次使用的C3P0作为练习，即在applicationContext.xml中配置
  1. <!--引入属性文件，在配置中占位使用 -->
  2. <context:property-placeholder location="classpath:jdbc.properties"/>
  3. <!--配置C3P0数据源-->
  4. <bean id="ds" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
  5. <!--连接数据库的基本信息-->
  6. <property name="user" value="${jdbc.username}" />
  7. <property name="password" value="${jdbc.password}" />
  8. <property name="jdbcUrl" value="${jdbc.url}" />
  9. <property name="driverClass" value="${jdbc.driver}" />
  10. <!--连接池的相应配置-->
  11. <property name="maxPoolSize" value="${maxPoolSize}"></property>
  12. <property name="minPoolSize" value="${minPoolSize}"></property>
  13. <property name="initialPoolSize" value="${initialSize}"></property>
  14. <property name="acquireIncrement" value="${acquireIncrement}"></property>
  15. <property name="autoCommitOnClose" value="${autoCommitOnClose}"></property>
  16. </bean>

这样就能连接数据库。

1.7.4.2 applicationContext上下文配置

下面的模板，只需要更改红框起来的地方，其他可以不用修改。
image.pngimage.png