这次整合利用了maven的环境,对于maven环境搭建和项目创建大家可以先百度一下。
下面先上图看一下大概的目录结构,最后会附上源代码
1、导入项目所需的jar包
pom.xml
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<spring-version>3.1.1.RELEASE</spring-version>
<!-- log4j日志文件管理包版本 -->
<org.slf4j.version>1.6.1</org.slf4j.version>
<logback.version>1.0.7</logback.version>
</properties>
<dependencies>
<!-- SpringMVC返回json数据 -->
<dependency>
<groupId>org.codehaus.jackson</groupId>
<artifactId>jackson-mapper-asl</artifactId>
<version>1.9.5</version>
</dependency>
<!-- mybatis/spring包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- mybatis核心包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.2.6</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring-version}</version>
</dependency>
<dependency>
<groupId>commons-pool</groupId>
<artifactId>commons-pool</artifactId>
<version>1.6</version>
</dependency>
<dependency>
<groupId>commons-collections</groupId>
<artifactId>commons-collections</artifactId>
<version>3.2.1</version>
</dependency>
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<dependency>
<groupId>cglib</groupId>
<artifactId>cglib-nodep</artifactId>
<version>2.2</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.9</version>
</dependency>
<dependency>
<groupId>org.apache.geronimo.bundles</groupId>
<artifactId>aspectjrt</artifactId>
<version>1.6.2_1</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring-version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring-version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</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-web</artifactId>
<version>${spring-version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring-version}</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!-- 日志文件管理包 -->
<!-- slfj+logback -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${org.slf4j.version}</version>
</dependency>
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-classic</artifactId>
<version>${logback.version}</version>
<type>jar</type>
<scope>compile</scope>
</dependency>
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-core</artifactId>
<version>${logback.version}</version>
<type>jar</type>
<scope>compile</scope>
</dependency>
</dependencies>
2、Spring与MyBatis的整合
(配置文件)
2.1 建立JDBC属性文件
jdbc.properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/selfdatabase?useUnicode=true&characterEncoding=utf-8
user=root
password=tiger
#初始连接数
initialSize=2
#最大连接数
maxActive=10
#最大空间
maxIdle=3
#最小空间
minIdle=2
#最长等待时间
maxWait=6000
#测试/验证连接池连接的SQL语句
validationQuery=select 1
#连接的超时时间,默认半小时
timeBetweenEvictionRunsMillis=3600000
#进行连接空闲时间判断,若为0,对空闲的连接不进行验证
minEvictableIdleTimeMillis=18000000
testOnBorrow=true
2.2建立dataAccessContext.xml配置文件
dataAccessContext.xml包含Spring与MyBatis的配置信息,主要是配置数据库、自动扫描、自动注入
dataAccessContext.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"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">
<!-- 引入数据库配置文件 -->
<context:property-placeholder location="classpath*:config/jdbc.properties" />
<!-- 数据源=连接池 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${user}" />
<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>
</bean>
<!-- JDBC事务管理器 -->
<bean id="txManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 切面 -->
<!-- 注意execution第一个*后面要有空格 -->
<aop:config>
<aop:pointcut id="point"
expression="execution(* service..*ServiceImpl.*(..))" />
<aop:advisor advice-ref="txAdvice" pointcut-ref="point" />
</aop:config>
<!-- spring与mybatis整合,不需要mybatis的配置文件 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<!-- 自动扫描mapper.xml文件 -->
<property name="mapperLocations" value="classpath*:sql/*.xml"></property>
</bean>
<!-- dao接口所在包名,Spring会自动查找其下的类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="*"></property>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
<!-- 事务的通知 -->
<tx:advice id="txAdvice" transaction-manager="txManager">
<tx:attributes>
<tx:method name="save*" propagation="REQUIRED"
rollback-for="java.lang.Exception" />
<tx:method name="update*" propagation="REQUIRED"
rollback-for="java.lang.Exception" />
<tx:method name="edit*" propagation="REQUIRED"
rollback-for="java.lang.Exception" />
<tx:method name="delete*" propagation="REQUIRED"
rollback-for="java.lang.Exception" />
<tx:method name="add*" propagation="REQUIRED" rollback-for="java.lang.Exception" />
<tx:method name="remove*" propagation="REQUIRED"
rollback-for="java.lang.Exception" />
<tx:method name="produce*" propagation="REQUIRED"
rollback-for="java.lang.Exception" />
<tx:method name="create*" propagation="REQUIRED"
rollback-for="java.lang.Exception" />
<tx:method name="insert*" propagation="REQUIRED"
rollback-for="java.lang.Exception" />
</tx:attributes>
</tx:advice>
</beans>
2.3 配置logback
调试过程中,常使用日志来输出信息。logback是一个开源日志组件,配置简单,使用方便。不配置也不影响框架的整合
logback.properties
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration>
<configuration scan="true" scanPeriod="1 seconds">
<property name="LOG_HOME" value="E:/dev/workspace/log" />
<property name="CONTEXT_NAME" value="/SSM" />
<!-- 控制台输出日志 -->
<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
<encoder>
<pattern>%-5level %d{yyyy-MM-dd HH:mm:ss.SSS} [%thread]
%logger{100}[line:%L] - %msg%n</pattern>
</encoder>
</appender>
<!-- 文件输出日志 (文件大小策略进行文件输出,超过指定大小对文件备份) -->
<appender name="ERROR"
class="ch.qos.logback.core.rolling.RollingFileAppender">
<filter class="ch.qos.logback.classic.filter.LevelFilter">
<level>ERROR</level>
<OnMismatch>DENY</OnMismatch>
<OnMatch>ACCEPT</OnMatch>
</filter>
<File>${LOG_HOME}/${CONTEXT_NAME}/error.log</File>
<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
<FileNamePattern>${LOG_HOME}/${CONTEXT_NAME}/error.%d{yyyy-MM-dd}.log</FileNamePattern>
</rollingPolicy>
<maxHistory>90</maxHistory> <!-- keep 90 days -->
<layout class="ch.qos.logback.classic.PatternLayout">
<Pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level
%logger{100}[line:%L] - %msg%n</Pattern>
</layout>
</appender>
<appender name="DEBUG"
class="ch.qos.logback.core.rolling.RollingFileAppender">
<filter class="ch.qos.logback.classic.filter.LevelFilter">
<level>DEBUG</level>
<OnMismatch>DENY</OnMismatch>
<OnMatch>ACCEPT</OnMatch>
</filter>
<File>${LOG_HOME}/${CONTEXT_NAME}/debug.log</File>
<rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
<FileNamePattern>${LOG_HOME}/${CONTEXT_NAME}/debug.%d{yyyy-MM-dd}.log</FileNamePattern>
</rollingPolicy>
<maxHistory>90</maxHistory> <!-- keep 90 days -->
<layout class="ch.qos.logback.classic.PatternLayout">
<Pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level
%logger{100}[line:%L] - %msg%n</Pattern>
</layout>
</appender>
<logger name="Test" level="DEBUG" />
<logger name="org.apache" level="DEBUG" />
<logger name="org.springframework" level="DEBUG" />
<logger name="ch.qos.logback" level="DEBUG" />
<root level="DEBUG">
<appender-ref ref="STDOUT" />
<appender-ref ref="ERROR" />
<appender-ref ref="DEBUG" />
</root>
</configuration>
(数据库表结构)
2.4 user.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="dao.UserDao"> <!-- namespace对应dao类 -->
<resultMap id="userObjectMap" type="pojo.User"> <!-- type对应pojo的user实体类 -->
<result property="username" column="USERNAME" /> <!-- property对应user的属性,column对应数据表的表元素 -->
<result property="password" column="PASSWORD" />
</resultMap>
<select id="getUserAccount" resultMap="userObjectMap">
SELECT * FROM T_USER
</select>
</mapper>
(java代码)
2.5 pojo层存放实体类
User.java
public class User {
private String username;
private String password;
public String getName() {
return username;
}
public void setName(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public User() {
super();
}
@Override
public String toString() {
return "User [username=" + username + ", password=" + password + "]";
}
}
2.6 IUserService.java
import java.util.List;
import pojo.User;
public interface IUserService {
public List<User> getUserAccount();
}
UserServiceImpl.java
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import dao.UserDao;
import pojo.User;
import service.IUserService;
@Service("UserServiceImpl")
public class UserServiceImpl implements IUserService{
@Resource
UserDao userDao;
public List<User> getUserAccount() {
return userDao.getUserAccount();
}
}
至此,Spring与MyBatis的整合已完成,大家可以使用JUnit4来测试一下
3、整合SpringMVC
3.1 配置spring-mvc.xml文件(启用注释扫描并生效)
spring-mvc.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
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:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
<!-- 启用并且扫描注解 -->
<context:component-scan base-package="*" />
<!-- 让请求与注解映射生效 -->
<mvc:annotation-driven />
</beans>
3.2 配置web.xml
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
version="2.4"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:spring/*.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<display-name>Archetype Created Web Application</display-name>
</web-app>
3.3 UserController.java
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import pojo.User;
import service.IUserService;
@Controller
@RequestMapping("/user")
public class UserController {
@Resource(name="UserServiceImpl")
IUserService userService;
@RequestMapping("/getUserAccount")
public void getUserAccount(){
List<User> user=userService.getUserAccount();
for(int i=0;i<user.size();i++){
System.out.println(user.get(i).toString());
}
}
}
4、测试
SSM三大框架的整合已经完成啦,可以启动tomcat测试一下
数据库表信息:
网址:
控制台输出: