使用Maven搭建springmvc项目(二)

使用Maven搭建springmvc项目(一)，这篇只有springmvc的配置。

下面是+mybatis的配置。

先上项目结构图：

下面是配置文件：

pom.xml

<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>com</groupId>
  <artifactId>mvn-springmvc</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>mvn-springmvc Maven Webapp</name>
  <url>http://maven.apache.org</url>
  
	<!-- 用来设置版本号 -->  
	<properties>  
        <srping.version>4.3.11.RELEASE</srping.version>
        <mybatis.version>3.4.5</mybatis.version>
	</properties>
	
	<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>3.8.1</version>
			<scope>test</scope>
		</dependency>
		<!-- spring架包 start -->
		<dependency>  
			<groupId>org.springframework</groupId>  
			<artifactId>spring-core</artifactId>  
			<version>${srping.version}</version>  
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>${srping.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-web</artifactId>
			<version>${srping.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>${srping.version}</version>
		</dependency>
		<dependency>  
			<groupId>org.springframework</groupId>  
			<artifactId>spring-tx</artifactId>  
			<version>${srping.version}</version>  
		</dependency>
		<dependency>  
			<groupId>org.springframework</groupId>  
			<artifactId>spring-jdbc</artifactId>  
			<version>${srping.version}</version>  
		</dependency>
		<!-- spring架包 end -->
		<!-- mybatis start -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>${mybatis.version}</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.3.0</version>
		</dependency>
		<!-- mybatis end -->
		<!-- 数据库驱动 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>6.0.6</version>
		</dependency>
		
	</dependencies>
	
	<build>
		<finalName>mvn-springmvc</finalName>
		<defaultGoal>compile</defaultGoal>
	</build>
</project>

applicationContext-dao.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-4.2.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-4.2.xsd"
	default-lazy-init="false">
	
	<!-- 获取资源文件 -->
	<context:property-placeholder ignore-resource-not-found="true" location="classpath:conf/*.properties"/>
	
	<!-- 使用spring 加载jdbc驱动 -->
	<bean id="dataSourceTemplate"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="${driver}" />
		<property name="url" value="${url}" />
		<property name="username" value="${uname}" />
		<property name="password" value="${password}" />
	</bean>
	
	<!-- 数据连接池 -->
	<bean id="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource"
		destroy-method="close">
		<property name="poolProperties">
			<bean class="org.apache.tomcat.jdbc.pool.PoolProperties">
				<!-- 通过引用加载数据库信息 -->
				<property name="dataSource" ref="dataSourceTemplate" />
				<property name="jmxEnabled" value="true" />
				<property name="testWhileIdle" value="true" />
				<property name="testOnBorrow" value="true" />
				<property name="testOnReturn" value="false" />
				<property name="validationInterval" value="30000" />
				<property name="validationQuery" value="SELECT 1" />
				<property name="timeBetweenEvictionRunsMillis" value="30000" />
				<property name="logAbandoned" value="false" />
				<property name="removeAbandoned" value="true" />
				<property name="removeAbandonedTimeout" value="60" />
				<!-- 初始化连接大小 -->
				<property name="initialSize" value="10"></property>
				<!-- 连接池最大数量 -->
				<property name="maxActive" value="200"></property>
				<!-- 连接池最小空闲 -->
				<property name="minIdle" value="10"></property>
				<!-- 获取连接最大等待时间 -->
				<property name="maxWait" value="60000"></property>
				<property name="jdbcInterceptors"
					value="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer" />
			</bean>
		</property>
	</bean>
	
	<!-- MyBatis配置 -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 数据库连接池 -->
		<property name="dataSource" ref="dataSource" />
		<!-- 自动扫描entity目录 -->
		<property name="typeAliasesPackage" value="com.model" />
		<!-- mybatis位置 -->
		<property name="configLocation" value="classpath:/mybatis/mybatis.xml" />
		<!-- 显式指定Mapper文件位置 -->
		<property name="mapperLocations" value="classpath:/mybatis/**/*Mapper.xml" />
	</bean>

	<!-- DAO接口所在包名，Spring会自动查找其下的类 -->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.dao" />
	</bean>
	
	<!-- 配置Spring的事务管理器 -->
	<bean id="transactionManager"
		class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource" />
	</bean>

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

mybatis.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="logPrefix" value="dao." />
		<setting name="cacheEnabled" value="false" />
		<!-- 日志实现,可以在控制台看到sql -->
		<setting name="logImpl" value="STDOUT_LOGGING" />
		<!-- <setting name="logImpl" value="SLF4J"/> -->
	</settings>
</configuration>

jdbc.properties

driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\://127.0.0.1\:3306/database?useSSL\=false&useUnicode\=true&characterEncoding\=utf8&autoReconnect\=true

uname=****
password=******

UserInfoMapper.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.dao.user.UserInfoDao">
	
	<!-- 根据用户ID获取用户信息 -->
	<select id="getById" parameterType="Long" resultType="UserInfo">

	</select>
	
</mapper> 

UserInfoDao.java

package com.dao.user;

import com.model.user.UserInfo;

public interface UserInfoDao {
	UserInfo getById(Long userId);
}