MVC框架集成

基础Maven依赖

常用的框架依赖示例：

<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/maven-v4_0_0.xsd">    <modelVersion>4.0.0</modelVersion>    <groupId>test</groupId>    <artifactId>mavenweb</artifactId>    <packaging>war</packaging>    <version>0.0.1-SNAPSHOT</version>    <name>mavenweb Maven Webapp</name>    <url>http://maven.apache.org</url>    <!-- 全局配置 -->    <properties>        <spring.version>4.1.7.RELEASE</spring.version>    </properties>    <dependencies>        <!-- Spring -->        <!-- Spring 核心依赖 -->        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-core</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-beans</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-context</artifactId>            <version>${spring.version}</version>        </dependency>        <!-- Spring dao层依赖 -->        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-jdbc</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-tx</artifactId>            <version>${spring.version}</version>        </dependency>        <!-- Spring MVC -->        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-web</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-webmvc</artifactId>            <version>${spring.version}</version>        </dependency>        <!-- Spring 测试 -->        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-test</artifactId>            <version>${spring.version}</version>        </dependency>        <!-- Servlet依赖 -->        <dependency>            <groupId>taglibs</groupId>            <artifactId>standard</artifactId>            <version>1.1.2</version>        </dependency>        <dependency>            <groupId>jstl</groupId>            <artifactId>jstl</artifactId>            <version>1.2</version>        </dependency>        <dependency>            <groupId>com.fasterxml.jackson.core</groupId>            <artifactId>jackson-databind</artifactId>            <version>2.5.4</version>        </dependency>        <dependency>            <groupId>javax.servlet</groupId>            <artifactId>javax.servlet-api</artifactId>            <version>3.1.0</version>        </dependency>        <!-- DAO层依赖 -->        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>3.3.0</version>        </dependency>        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis-spring</artifactId>            <version>1.2.3</version>        </dependency>        <dependency>            <groupId>com.github.pagehelper</groupId>            <artifactId>pagehelper</artifactId>            <version>4.1.4</version>        </dependency>        <dependency>            <groupId>com.github.jsqlparser</groupId>            <artifactId>jsqlparser</artifactId>            <version>0.9</version>        </dependency>        <!-- 数据库依赖 -->        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>5.1.35</version>            <scope>runtime</scope>        </dependency>        <dependency>            <groupId>c3p0</groupId>            <artifactId>c3p0</artifactId>            <version>0.9.1.2</version>        </dependency>        <!-- 测试依赖 -->        <dependency>            <groupId>junit</groupId>            <artifactId>junit</artifactId>            <version>4.12</version>        </dependency>        <!-- 日志依赖 -->        <dependency>            <groupId>org.slf4j</groupId>            <artifactId>slf4j-api</artifactId>            <version>1.7.12</version>        </dependency>        <dependency>            <groupId>ch.qos.logback</groupId>            <artifactId>logback-core</artifactId>            <version>1.1.2</version>        </dependency>        <dependency>            <groupId>ch.qos.logback</groupId>            <artifactId>logback-classic</artifactId>            <version>1.1.2</version>        </dependency>    </dependencies>    <build>        <finalName>mavenweb</finalName>        <plugins>            <plugin>                <groupId>org.apache.maven.plugins</groupId>                <artifactId>maven-compiler-plugin</artifactId>                <version>3.3</version>                <configuration>                    <source>1.8</source>                    <target>1.8</target>                </configuration>            </plugin>        </plugins>    </build></project>

MyBatis集成

src/main/resources下新增数据库配置db.properties:

jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://xxx.xxx.xxx.xxx:3306/test?useUnicode=true&autoReconnect=true&characterEncoding=UTF8&allowMultiQueries=truejdbc.username=xxxjdbc.password=xxxmaxPoolSize=15minPoolSize=5initialPoolSize=10maxIdleTime=30checkoutTimeout=0acquireIncrement=3idleConnectionTestPeriod=60maxStatements=0

src/main/resources下新增mybatis基础配置文件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="useColumnLabel" value="true" />        <setting name="useGeneratedKeys" value="true" />        <setting name="mapUnderscoreToCamelCase" value="true" />    </settings>    <!-- 分页插件 -->    <plugins>        <plugin interceptor="com.github.pagehelper.PageHelper">            <property name="dialect" value="mysql"/>            <property name="offsetAsPageNum" value="true"/>            <property name="rowBoundsWithCount" value="true"/>            <property name="pageSizeZero" value="true"/>            <property name="reasonable" value="true"/>            <property name="params" value="pageNum=start;pageSize=limit;"/>        </plugin>    </plugins></configuration>

src/main/resources/spring下新增spring集成mybatis的配置文件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:tx="http://www.springframework.org/schema/tx"       xmlns:context="http://www.springframework.org/schema/context"       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd   http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">    <context:property-placeholder location="classpath:db.properties"/>    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">        <property name="driverClass" value="${jdbc.driverClassName}"/>        <property name="jdbcUrl" value="${jdbc.url}"/>        <property name="user" value="${jdbc.username}"/>        <property name="password" value="${jdbc.password}"/>        <property name="maxPoolSize" value="${maxPoolSize}"/>        <property name="minPoolSize" value="${minPoolSize}"/>        <property name="initialPoolSize" value="${initialPoolSize}"/>        <property name="maxIdleTime" value="${maxIdleTime}"/>        <property name="maxStatements" value="${maxStatements}"/>        <property name="acquireIncrement" value="${acquireIncrement}"/>        <property name="checkoutTimeout" value="${checkoutTimeout}"/>        <property name="idleConnectionTestPeriod" value="${idleConnectionTestPeriod}"/>    </bean>    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="configLocation" value="classpath:mybatis-config.xml"/>        <property name="mapperLocations" value="classpath:mapper/*.xml"/>        <property name="dataSource" ref="dataSource"/>        <property name="typeAliasesPackage" value="xxxx.entity"/>    </bean>    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="basePackage" value="xxxx.dao"/>        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>    </bean>    <!-- 事务配置 -->    <tx:annotation-driven transaction-manager="txManager" proxy-target-class="true"/>    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource"/>    </bean></beans>

sqlSessionFactory：

configLocation：指定mybatis基础配置文件mapperLocations：通配指定各个dao接口的mapper文件dataSource：指定数据源typeAliasesPackage：指定别名包，这个包下的entity类会自动指定别名

MapperScannerConfigurer:

basePackage：自动包扫描，扫描哪些dao

分页插件的使用示例：

    // 底x页，取y条    PageHelper.startPage(4, 10);    List<TestEntity> resultList = testDao.findTest();    // 获取分页信息    PageInfo<TestEntity> page = new PageInfo<TestEntity>(resultList);    System.out.println("getTotal:" + page.getTotal());    System.out.println("getPages:" + page.getPages());    System.out.println("getPageSize:" + page.getPageSize());

Spring MVC集成

web.xml中添加配置：

    <!-- 字符集过滤器 -->    <filter>        <filter-name>EncodingFilter</filter-name>        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>        <init-param>            <param-name>encoding</param-name>            <param-value>utf8</param-value>        </init-param>    </filter>    <filter-mapping>        <filter-name>EncodingFilter</filter-name>        <url-pattern>/*</url-pattern>    </filter-mapping>    <!-- Spring mvc -->    <servlet>        <servlet-name>web</servlet-name>        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>        <init-param>            <param-name>contextConfigLocation</param-name>            <param-value>classpath:spring/spring-*.xml</param-value>        </init-param>        <load-on-startup>1</load-on-startup>    </servlet>    <servlet-mapping>        <servlet-name>web</servlet-name>        <url-pattern>/</url-pattern>    </servlet-mapping>

spring-mvc.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:context="http://www.springframework.org/schema/context"       xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:aop="http://www.springframework.org/schema/aop"       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/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">    <!-- 注解驱动 -->    <mvc:annotation-driven/>    <!-- 包扫描 -->    <context:component-scan base-package="xxx"/>    <!-- 默认servlet处理静态资源，处理映射见web.xml -->    <mvc:default-servlet-handler/>    <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">        <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />        <property name="prefix" value="/WEB-INF/jsp/" />          <property name="suffix" value=".jsp" />          <property name="order" value="1" />      </bean></beans>