基于Maven整合SpringMVC、Spring和Mybatis框架

最新推荐文章于 2023-01-08 18:44:10 发布

Lee_Sung

最新推荐文章于 2023-01-08 18:44:10 发布

阅读量646

点赞数

分类专栏： Java Web 文章标签： spring spring mvc mybatis maven

本文链接：https://blog.csdn.net/SungLee_1992/article/details/53064946

版权

Java Web 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

介绍
pomxml
Webxml文件
springMVC-dispatcherxml文件
applicationContextxml文件
spring-mybatisxml文件
Mybatis-configxml文件
jdbcproperties文件
log4jproperties文件
测试

前面，我们已经介绍了SpringMVC 的理论基础，Maven 的环境搭建和用Maven构建简单Web项目，现在我们用Maven对SpringMVC、Spring和Mybatis三个框架进行一个整合。这一部分，基本上直接用代码说话，代码中，注释已经很清晰了。

SpringMVC理论基础http://blog.csdn.net/sunglee_1992/article/details/53044167
配置Maven环境http://blog.csdn.net/sunglee_1992/article/details/53044504
用Maven构建一个Web项目http://blog.csdn.net/sunglee_1992/article/details/53064408

介绍

首先放上项目搭建好之后的目录结构图。

这里写图片描述

resources中，我们放配置文件，我们由底层到上层一一介绍。

1.mappers包中放了持久化层框架Mybatis的mapper文件。

2.log4j.properties是日志打印的有关信息配置

3.generatorCofig.xml是自动生成代码的配置文件，Mybatis根据表自动生成Dao、mapper和实体代码的内容具体见
http://blog.csdn.net/sunglee_1992/article/details/53068252

4.jdbc.properties是连接数据库的有关信息

5.Mybatis-config是Mybatis的全局配置文件

6.spring-mybtis是spring和mybatis整合的配置文件，主要配置数据源，文件配置中需要引入 jdbc.properties文件和Mybatis-config文件。

7.applicationContext是spring的配置文件，主要配置自动扫描service包，需要引入spring和mybatis整合的配置文件spring-mybaits.xml

8.springMVC-dispatcher是SpringMVC的配置文件。

框架的整合，主要是这些文件的配置，大家在做整合的时候也可以按照这个顺序进行整合，后面我们会列出这些文件的详细配置代码。

java目录中我们存放代码，包括实体entity包和model包，model中又有controller、service、dao三个包，如下图。

这里写图片描述

1. pom.xml

properties标签里可以添加一些变量，方便工程量大的时候使用。

dependencyManagement依赖管理，如依赖重复版本不同时，使用这里指定的版本。

build标签，可以加入一些插件,如Junit等。

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>springMVCTest</groupId>
  <artifactId>springmvctest</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <name>springMVCTest</name>
  <description/>
  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <commons-lang.version>2.6</commons-lang.version>
    <!-- log4j日志文件管理包版本 -->  
    <slf4j.version>1.7.7</slf4j.version>  
    <log4j.version>1.2.17</log4j.version>
    <!-- spring版本号 --> 
    <spring.version>4.1.3.RELEASE</spring.version>
    <!-- mybatis版本号 -->  
    <mybatis.version>3.2.6</mybatis.version>
    <!-- druid数据源版本号 -->
    <druid.version>1.0.7</druid.version>
  </properties>

  <dependencyManagement>
    <dependencies>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-framework-bom</artifactId>
        <version>${spring.version}</version>
        <type>pom</type>
        <scope>import</scope>
      </dependency>
    </dependencies>
  </dependencyManagement>

  <dependencies>
      <dependency>  
            <groupId>junit</groupId>  
            <artifactId>junit</artifactId>  
            <version>4.11</version>  
            <!-- 表示开发的时候引入，发布的时候不会加载此包 -->  
            <scope>test</scope>  
      </dependency>  

      <dependency>
        <groupId>commons-lang</groupId>
        <artifactId>commons-lang</artifactId>
        <version>${commons-lang.version}</version>
      </dependency>

      <!-- 加入druid数据源依赖包 -->  
      <dependency>  
          <groupId>com.alibaba</groupId>  
          <artifactId>druid</artifactId>  
          <version>${druid.version}</version>  
      </dependency> 

      <!-- spring核心包 --> 
      <dependency>  
          <groupId>org.springframework</groupId>  
          <artifactId>spring-core</artifactId>  

      </dependency>  

      <dependency>  
          <groupId>org.springframework</groupId>  
          <artifactId>spring-web</artifactId>  

      </dependency>  
      <dependency>  
          <groupId>org.springframework</groupId>  
          <artifactId>spring-oxm</artifactId>  

      </dependency>  
      <dependency>  
          <groupId>org.springframework</groupId>  
          <artifactId>spring-tx</artifactId>  

      </dependency>  

      <dependency>  
          <groupId>org.springframework</groupId>  
          <artifactId>spring-jdbc</artifactId>  

      </dependency>  

      <dependency>  
          <groupId>org.springframework</groupId>  
          <artifactId>spring-webmvc</artifactId>  

      </dependency>  
      <dependency>  
          <groupId>org.springframework</groupId>  
          <artifactId>spring-aop</artifactId>  

      </dependency>  

      <dependency>  
          <groupId>org.springframework</groupId>  
          <artifactId>spring-context-support</artifactId>  

      </dependency>  

      <dependency>  
          <groupId>org.springframework</groupId>  
          <artifactId>spring-test</artifactId>   
      </dependency>  

      <!-- mybatis核心包 -->  
      <dependency>  
          <groupId>org.mybatis</groupId>  
          <artifactId>mybatis</artifactId>  
          <version>${mybatis.version}</version>  
      </dependency> 

      <!-- mybatis/spring包 -->  
      <dependency>  
          <groupId>org.mybatis</groupId>  
          <artifactId>mybatis-spring</artifactId>  
          <version>1.2.2</version>  
      </dependency>

      <!-- 导入Mysql数据库链接jar包 -->
      <dependency>  
            <groupId>mysql</groupId>  
            <artifactId>mysql-connector-java</artifactId>  
            <version>5.1.30</version>  
      </dependency>

      <!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->  
      <dependency>  
          <groupId>commons-dbcp</groupId>  
          <artifactId>commons-dbcp</artifactId>  
          <version>1.2.2</version>  
      </dependency>

      <!-- JSTL标签类 -->  
      <dependency>  
          <groupId>jstl</groupId>  
          <artifactId>jstl</artifactId>  
          <version>1.2</version>  
      </dependency>

      <!-- 日志文件管理包 -->  
      <!-- log start -->  
      <dependency>  
          <groupId>log4j</groupId>  
          <artifactId>log4j</artifactId>  
          <version>${log4j.version}</version>  
      </dependency>  

      <!-- 格式化对象，方便输出日志 -->  
      <dependency>  
          <groupId>com.alibaba</groupId>  
          <artifactId>fastjson</artifactId>  
          <version>1.1.41</version>  
      </dependency>  

      <dependency>  
          <groupId>org.slf4j</groupId>  
          <artifactId>slf4j-api</artifactId>  
          <version>${slf4j.version}</version>  
      </dependency>  

      <dependency>  
          <groupId>org.slf4j</groupId>  
          <artifactId>slf4j-log4j12</artifactId>  
          <version>${slf4j.version}</version>  
      </dependency>  
      <!-- log end -->

      <!-- 映入JSON -->  
      <dependency>  
          <groupId>org.codehaus.jackson</groupId>  
          <artifactId>jackson-mapper-asl</artifactId>  
          <version>1.9.13</version>  
      </dependency> 

      <!-- 上传组件包 -->  
      <dependency>  
          <groupId>commons-fileupload</groupId>  
          <artifactId>commons-fileupload</artifactId>  
          <version>1.3.1</version>  
      </dependency>  
      <dependency>  
          <groupId>commons-io</groupId>  
          <artifactId>commons-io</artifactId>  
          <version>2.4</version>  
      </dependency>  
      <dependency>  
          <groupId>commons-codec</groupId>  
          <artifactId>commons-codec</artifactId>  
          <version>1.9</version>  
      </dependency>
  </dependencies>

  <build>
    <plugins>
      <!-- Mybatis自动生成实体、dao和mapper的插件 -->
      <plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.3.2</version>
         <configuration>
            <verbose>true</verbose>
            <overwrite>true</overwrite>
        </configuration>
      </plugin>

      <plugin>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>2.3.2</version>
        <configuration>
          <source>1.6</source>
          <target>1.6</target>
        </configuration>
      </plugin>

      <plugin>
        <artifactId>maven-war-plugin</artifactId>
        <version>2.2</version>
        <configuration>
          <version>3.0</version>
          <failOnMissingWebXml>false</failOnMissingWebXml>
        </configuration>
      </plugin>
    </plugins>
  </build>
</project>

2.Web.xml文件

用servlet和servlet-Mapping将前端控制器配入web环境。servlet-name关系到默认配置文件，如果不做其他配置（如init-param），那么spring将在默认位置的默认文件名加载springmvc的配置文件，默认为/WEB-INF/$servlet-name%-servlet.xml，通过contextConfigLocation 改变了默认参数

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xmlns="http://java.sun.com/xml/ns/javaee" 
xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" 
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" 
id="WebApp_ID" 
version="3.0">
  <display-name>springmvc</display-name>

  <!-- Spring和mybatis的配置文件 -->  
  <!-- <context-param>  
      <param-name>contextConfigLocation</param-name>  
      <param-value>classpath:spring-mybatis.xml</param-value>  
  </context-param>  -->


  <!-- 编码过滤器 -->  
  <filter>  
      <filter-name>encodingFilter</filter-name>  
      <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>  
      <async-supported>true</async-supported>  
      <init-param>  
          <param-name>encoding</param-name>  
          <param-value>UTF-8</param-value>  
      </init-param>  
  </filter>  
  <filter-mapping>  
      <filter-name>encodingFilter</filter-name>  
      <url-pattern>/*</url-pattern>  
  </filter-mapping>    


  <!-- Spring应用上下文，理解层次化的ApplicationContext -->
  <context-param>  
    <param-name>contextConfigLocation</param-name>  
    <param-value>classpath:applicationContext*.xml</param-value>  
  </context-param>
  <!-- Spring监听器 -->  
  <listener>  
      <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  
  </listener>  
  <!-- 防止Spring内存溢出监听器 -->  
  <listener>  
      <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>  
  </listener> 

  <!-- Spring MVC Start -->  
  <servlet>
    <servlet-name>springMVC-dispatcher</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <!-- DispatcherServlet对应的上下文配置，默认为/WEB-INF/$servlet-name%-servlet.xml -->
    <init-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:springMVC-dispatcher.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>
  <!-- Spring MVC End -->  

  <servlet-mapping>
    <servlet-name>springMVC-dispatcher</servlet-name>
    <!-- 拦截所有请求 -->
    <url-pattern>/</url-pattern>
  </servlet-mapping>

  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
</web-app>

3.springMVC-dispatcher.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<beans
    xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:aop="http://www.springframework.org/schema/aop" 
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:jee="http://www.springframework.org/schema/jee" 
    xsi:schemaLocation="
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context.xsd
    http://www.springframework.org/schema/beans 
    http://www.springframework.org/schema/beans/spring-beans.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-3.0.xsd
    http://www.springframework.org/schema/jee
    http://www.springframework.org/schema/jee/spring-jee-3.0.xsd">

    <!-- 本配置文件是供名为springMVC-dispatcher的DispatcherServlet使用，提供其相关的Spring MVC配置 -->

    <!-- 启用Spring基于annotation的DI，使用户可以在Spring MVC中使用Spring的强大功能。
        激活@Required @Autowired,JSR  250's @PostConstruct,@PreDestory and @Resource 等标注 
    -->
    <context:annotation-config />

    <!-- 自动扫描，DispatcherServlet上下文，只管理@Controller标注的bean，不搜索其他标注的类，如@Service -->
    <context:component-scan base-package="com.cie.model.controllers">
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller" />
    </context:component-scan>

    <!-- HandlerMapping，无需配置，Spring MVC可以默认启动
        让DispatcherServlet启用基于annotation的handelerMapping 
        DefaultAnnotationHandlerMapping annotation-driven HandlerMapping
    -->

    <!-- 扩充了注解驱动，可以将请求参数绑定到控制器参数 ，即， URL查询参数中的某个变量可以直接映射到Controller中某个方法的输入参数-->
    <mvc:annotation-driven />

    <!-- 静态资源处理,css,js,imgs -->
    <mvc:resources mapping="/resources/**" location="/resources/" />

    <!-- 视图解析器配置 
        可以用多个ViewResolver
        使用order属性排序
        要注意，InternalResourceViewResolver放在最后
    -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!--    <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" /> --><!-- ********没有引这个类所在的包，所以报错******* -->
        <property name="prefix" value="/WEB-INF/view/" />   <!-- 前缀 这里是前缀，会在你返回的字符串前面加上这一串，不用加*，加了就不对了-->
        <property name="suffix" value=".jsp" /> <!-- 后缀 -->
    </bean>

     <!-- 配置文件上传，如果没有使用文件上传可以不用配置，当然如果不配，那么配置文件中也不必引入上传组件包 -->  
    <bean id="multipartResolver"    
        class="org.springframework.web.multipart.commons.CommonsMultipartResolver">    
        <!-- 默认编码 -->  
        <property name="defaultEncoding" value="utf-8" />    
        <!-- 文件大小最大值 -->  
        <property name="maxUploadSize" value="10485760000" />    
        <!-- 内存中的最大值 -->  
        <property name="maxInMemorySize" value="40960" />    
    </bean>  

    <!--避免IE执行AJAX时，返回JSON出现下载文件 -->  
    <!-- <bean id="mappingJacksonHttpMessageConverter"  
        class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">  
        <property name="supportedMediaTypes">  
            <list>  
                <value>text/html;charset=UTF-8</value>  
            </list>  
        </property>  
    </bean> -->  
     <!-- 启动SpringMVC的注解功能，完成请求和注解POJO的映射 -->  
    <!-- <bean  
        class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">  
        <property name="messageConverters">  
            <list>  
                <ref bean="mappingJacksonHttpMessageConverter" /> JSON转换器  
            </list>  
        </property>  
    </bean> --> 
</beans>

4.applicationContext.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<beans
    xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:aop="http://www.springframework.org/schema/aop" 
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:jee="http://www.springframework.org/schema/jee" 
    xsi:schemaLocation="
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context.xsd
    http://www.springframework.org/schema/beans 
    http://www.springframework.org/schema/beans/spring-beans.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-3.0.xsd
    http://www.springframework.org/schema/jee
    http://www.springframework.org/schema/jee/spring-jee-3.0.xsd">

    <context:annotation-config />

    <!-- 不需要管理controller,用exclude-filter -->
    <context:component-scan base-package="com.cie.model.service" />
<!--        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/> 
    </context:component-scan>
-->

    <!-- Spring中引入其他配置文件 -->
    <import resource="classpath:spring-mybatis.xml" />
</beans>

5.spring-mybatis.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<beans
    xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:aop="http://www.springframework.org/schema/aop" 
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:jee="http://www.springframework.org/schema/jee" 
    xsi:schemaLocation="
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context.xsd
    http://www.springframework.org/schema/beans 
    http://www.springframework.org/schema/beans/spring-beans.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-3.0.xsd
    http://www.springframework.org/schema/jee
    http://www.springframework.org/schema/jee/spring-jee-3.0.xsd 
    http://www.springframework.org/schema/tx     
    http://www.springframework.org/schema/tx/spring-tx-3.2.xsd">

    <!-- 引入jdbc.properties配置文件 -->  
    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">  
        <property name="location" value="classpath:jdbc.properties" />  
    </bean>  
    <!-- ====================配置数据源============================ -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"  
        init-method="init" destroy-method="close">  
        <property name="driverClassName" value="${driver}" />  
        <property name="url" value="${url}" />  
        <property name="username" value="${username}" />  
        <property name="password" value="${password}" />  
        <!-- 初始化连接大小 -->  
        <property name="initialSize" value="${initialSize}"></property>  
        <!-- 连接池最大数量 -->  
        <property name="maxActive" value="${maxActive}"></property>  
        <!-- 连接池最大空闲 -->  
        <property name="maxIdle" value="${maxIdle}"></property>  
        <!-- 连接池最小空闲 -->  
        <property name="minIdle" value="${minIdle}"></property>  
        <!-- 获取连接最大等待时间 -->  
        <property name="maxWait" value="${maxWait}"></property> 
        <property name="poolPreparedStatements" value="true" />
        <property name="maxPoolPreparedStatementPerConnectionSize" value="33" />
        <!-- 用来检测有效sql -->
        <property name="validationQuery" value="${validationQuery}" />
        <property name="testOnBorrow" value="false" />
        <property name="testOnReturn" value="false" />
        <property name="testWhileIdle" value="true" />
        <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
        <property name="timeBetweenEvictionRunsMillis" value="${timeBetweenEvictionRunsMillis}" />
        <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
        <property name="minEvictableIdleTimeMillis" value="${minEvictableIdleTimeMillis}" />
        <!-- 打开removeAbandoned功能 -->
        <property name="removeAbandoned" value="true" />
        <!-- 1800秒，也就是30分钟 -->
        <property name="removeAbandonedTimeout" value="1800" />
        <!-- 关闭abanded连接时输出错误日志 -->
        <property name="logAbandoned" value="true" />
        <!-- 监控数据库 -->
        <property name="filters" value="mergeStat" />
        <!-- 自动提交属性默认为true，更改使其不自动提交，为了batch操作 -->
        <!-- <property name="defaultAutoCommit" value="false"/> --> 
    </bean>  

    <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->  
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
        <property name="dataSource" ref="dataSource" />  
        <!-- 自动扫描mapping.xml文件 -->  
        <property name="mapperLocations" value="classpath:mappers/*.xml" />
        <!-- 自动扫描entity目录, 省掉Configuration.xml里的手工配置 -->
        <property name="typeAliasesPackage" value="com.cie.entity"/>
        <property name="configLocation" value="classpath:/Mybatis-config.xml"/>
    </bean>  

    <!-- DAO接口所在包名，Spring会自动查找其下的类 -->  
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
        <property name="basePackage" value="com.cie.model.dao" />  
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>  
    </bean>  

    <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->  
    <bean id="transactionManager"  
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  
        <property name="dataSource" ref="dataSource" />  
    </bean>

    <!-- 注解方式配置事物 -->
    <tx:annotation-driven transaction-manager="transactionManager" />
</beans>

6.Mybatis-config.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

    <!-- 全局参数 -->
    <settings>
        <!-- 使全局的映射器启用或禁用缓存。 -->
        <setting name="cacheEnabled" value="true"/>

        <!-- 全局启用或禁用延迟加载。当禁用时，所有关联对象都会即时加载。 -->
        <setting name="lazyLoadingEnabled" value="true"/>

        <!-- 当启用时，有延迟加载属性的对象在被调用时将会完全加载任意属性。否则，每种属性将会按需要加载。 -->
        <setting name="aggressiveLazyLoading" value="true"/>

        <!-- 是否允许单条sql 返回多个数据集  (取决于驱动的兼容性) default:true -->
        <setting name="multipleResultSetsEnabled" value="true"/>

        <!-- 是否可以使用列的别名 (取决于驱动的兼容性) default:true -->
        <setting name="useColumnLabel" value="true"/>

        <!-- 允许JDBC 生成主键。需要驱动器支持。如果设为了true，这个设置将强制使用被生成的主键，有一些驱动器不兼容不过仍然可以执行。  default:false  -->
        <setting name="useGeneratedKeys" value="false"/>

        <!-- 指定 MyBatis 如何自动映射 数据基表的列 NONE：不隐射　PARTIAL:部分  FULL:全部  -->  
        <setting name="autoMappingBehavior" value="PARTIAL"/>

        <!-- 这是默认的执行类型  （SIMPLE: 简单； REUSE: 执行器可能重复使用prepared statements语句；BATCH: 执行器可以重复执行语句和批量更新）  -->
        <setting name="defaultExecutorType" value="SIMPLE"/>

        <!-- 使用驼峰命名法转换字段。 -->
        <setting name="mapUnderscoreToCamelCase" value="true"/>

        <!-- 设置本地缓存范围 session:就会有数据的共享  statement:语句范围 (这样就不会有数据的共享 ) defalut:session -->
        <setting name="localCacheScope" value="SESSION"/>

        <!-- 设置但JDBC类型为空时,某些驱动程序 要指定值,default:OTHER，插入空值时不需要指定类型 -->
        <setting name="jdbcTypeForNull" value="NULL"/>

        <!-- 打印查询语句 -->
        <setting name="logImpl" value="STDOUT_LOGGING" />

    </settings>

    <!-- <plugins>
        <plugin interceptor="com.page.PageSupportPlugin">
            <property name="databaseType" value="mysql"/>
        </plugin>
    </plugins> -->

</configuration>

7. jdbc.properties文件

validationQuery=SELECT 1
driver=com.mysql.jdbc.Driver  
url=jdbc:mysql://localhost:3306/springmvc?useUnicode=true&characterEncoding=utf-8
username=root 
password=  
#定义初始连接数  
initialSize=0  
#定义最大连接数  
maxActive=20  
#定义最大空闲  
maxIdle=20  
#定义最小空闲  
minIdle=0 
#定义最长等待时间  
maxWait=60000  
#配置间隔多久才进行一次检测
timeBetweenEvictionRunsMillis=60000
#一个连接在池中最小生存的时间
minEvictableIdleTimeMillis=25200000

8.log4j.properties文件

log4j.rootLogger=INFO,Console,File  
#\u5B9A\u4E49\u65E5\u5FD7\u8F93\u51FA\u76EE\u7684\u5730\u4E3A\u63A7\u5236\u53F0  
log4j.appender.Console=org.apache.log4j.ConsoleAppender  
log4j.appender.Console.Target=System.out  
#\u53EF\u4EE5\u7075\u6D3B\u5730\u6307\u5B9A\u65E5\u5FD7\u8F93\u51FA\u683C\u5F0F\uFF0C\u4E0B\u9762\u4E00\u884C\u662F\u6307\u5B9A\u5177\u4F53\u7684\u683C\u5F0F  
log4j.appender.Console.layout = org.apache.log4j.PatternLayout  
log4j.appender.Console.layout.ConversionPattern=[%c] - %m%n  

#\u6587\u4EF6\u5927\u5C0F\u5230\u8FBE\u6307\u5B9A\u5C3A\u5BF8\u7684\u65F6\u5019\u4EA7\u751F\u4E00\u4E2A\u65B0\u7684\u6587\u4EF6  
log4j.appender.File = org.apache.log4j.RollingFileAppender  
#\u6307\u5B9A\u8F93\u51FA\u76EE\u5F55  
log4j.appender.File.File = logs/ssm.log  
#\u5B9A\u4E49\u6587\u4EF6\u6700\u5927\u5927\u5C0F  
log4j.appender.File.MaxFileSize = 10MB  
# \u8F93\u51FA\u6240\u4EE5\u65E5\u5FD7\uFF0C\u5982\u679C\u6362\u6210DEBUG\u8868\u793A\u8F93\u51FADEBUG\u4EE5\u4E0A\u7EA7\u522B\u65E5\u5FD7  
log4j.appender.File.Threshold = ALL  
log4j.appender.File.layout = org.apache.log4j.PatternLayout  
log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n

测试

1.Controller——Hello.java

package com.cie.model.controllers;

import javax.annotation.Resource;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;

import com.cie.entity.User;
import com.cie.model.service.UserService;

@Controller
@RequestMapping("/hello")       //类级别的requestmapping
public class Hello {

    private static Logger log = LoggerFactory.getLogger(Hello.class);
    @Resource
    private UserService userService;

    /**
     * @author: LS
     * 2016-9-28 下午6:18:36
     * @param args void
     * TODO
     */
    @RequestMapping("/mvc")
    //host:8080/hello/mvc
    public String helloMVC(){
        return "home";      //home.jsp
    }

    //本方法将处理/hello/view?userId=123   类似的url，并且是由get方法传递过来的请求
    @RequestMapping(value="/view",method=RequestMethod.GET)
    public String viewHello(@RequestParam("userId") Integer userId,Model model){
        log.debug("In viewUser,userId={}",userId);
        User user = userService.selectByPrimaryKey(userId);
        model.addAttribute(user);
        return "home";
    }

    public void setUserService(UserService userService) {
        this.userService = userService;
    }   
}

2.Service——UserService.java

package com.cie.model.service;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.cie.entity.User;
import com.cie.model.dao.UserDao;

@Service
public class UserService {
    @Resource
    private UserDao userDao;

    public User selectByPrimaryKey(Integer userId){
        return userDao.selectById(userId);
    }
}

3.UserDao.java

package com.cie.model.dao;

import org.springframework.stereotype.Repository;

import com.cie.entity.User;

@Repository
public interface UserDao {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table user
     *
     * @mbggenerated
     */
    int deleteByPrimaryKey(Integer userId);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table user
     *
     * @mbggenerated
     */
    int insert(User record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table user
     *
     * @mbggenerated
     */
    int insertSelective(User record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table user
     *
     * @mbggenerated
     */
    User selectById(Integer userId);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table user
     *
     * @mbggenerated
     */
    int updateByPrimaryKeySelective(User record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table user
     *
     * @mbggenerated
     */
    int updateByPrimaryKey(User record);
}

4.UserMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.cie.model.dao.UserDao">

  <sql id="Base_Column_List">
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    user_id, username, password, user_age
  </sql>
  <select id="selectById" resultType="User">
    select *
    from user
    where user_id = #{userId}
  </select>
</mapper>

5.home.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>测试</title>

<link rel="stylesheet" href="<%=request.getContextPath()%>/resources/css/main.css" type="text/css" />
</head>

<body>
    <div id="main">
        <div class="newcontainer" id="course_intro">
            <div class="course-title">${user.userId}</div>
            <div class="course_info">
                <div class="course-embed l">
                    <div id="js-video-wrap" class="video" style="display: none">
                        <div class="video_box" id="js-video"></div>
                    </div>
                </div>
                <div class="course_state">
                    <ul>
                        <li><span>用户名</span> <em>${user.username}</em></li>
                        <li class="course_hour"><span>年龄</span> <em class="ft-adjust"><span>${user.userAge}</span></em></li>
                    </ul>
                </div>
            </div>
        </div>
    </div>
</body>
</html>

Hello类和home.jsp是测试文件，按照上述配置，将工程部署到TomCat容器中，启动服务器，我们访问http://localhost:8080/springmvc/hello/view?userId=1，可以看到如下结果，证明框架整合成功了。

这里写图片描述

控制台输出信息

这里写图片描述

至此，框架整合已经全部完成并且测试通过了。

Lee_Sung

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
基于Maven整合SpringMVC、Spring和Mybatis框架

介绍pomxmlWebxml文件springMVC-dispatcherxml文件applicationContextxml文件spring-mybatisxml文件Mybatis-configxml文件jdbcproperties文件log4jproperties文件测试ControllerHellojavaServiceUserServicejavaUserDaojava
复制链接

扫一扫