整合 spring mvc+spring+mybatis

1、导入相关jar包

aopalliance.jar
asm-3.3.1.jar
asm-commons-3.3.jar
commons-fileupload-1.3.2.jar
commons-io-2.2.jar
commons-logging-1.1.3.jar
jackson-core-asl-1.9.2.jar
jackson-jaxrs-1.8.3.jar
jackson-mapper-asl-1.9.2.jar
jackson-xc-1.8.3.jar
javassist-3.17.1-GA.jar
json-lib-2.4-jdk15.jar
log4j-1.2.17.jar
log4j-api-2.0-rc1.jar
log4j-core-2.0-rc1.jar
mysql-connector-java-5.1.20-bin.jar
ognl-3.0.5.jar
spring-aop-4.1.6.RELEASE.jar
spring-aspects-4.1.6.RELEASE.jar
spring-beans-4.1.6.RELEASE.jar
spring-core-4.1.6.RELEASE.jar
spring-expression-4.1.6.RELEASE.jar
spring-jdbc-4.1.6.RELEASE.jar
spring-orm-4.1.6.RELEASE.jar
spring-tx-4.1.6.RELEASE.jar
spring-web-4.1.6.RELEASE.jar
spring-webmvc-4.1.6.RELEASE.jar

2、编写配置文件

             web.xml：配置spring，spring mvc

	<?xml version="1.0" encoding="UTF-8"?>
	<web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
	http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
	<display-name></display-name>
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:applicationContext.xml</param-value>
	</context-param>
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	<servlet>
		<servlet-name>springmvc</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
	</servlet>
	<init-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:mvc.xml</param-value>
	</init-param>
	<load-on-startup>1</load-on-startup>
	<servlet-mapping>
		<servlet-name>springmvc</servlet-name>
		<url-pattern>*.do</url-pattern>
	</servlet-mapping>
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>
</web-app>

mvc.xml-spring mvc(使用注解)

如果需要json或其他处理需填写相关配置

<?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"
	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">
	<!-- 注解扫描 -->
	<context:component-scan base-package="ssm.controller"/> 
</beans>

applicationContext.xml-spring

<?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:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
		
		<!-- 配置扫描service 所在的包 -->
		<context:component-scan base-package="com.nap.service.impl"></context:component-scan>
		
		<!-- 配置datasource 链接数据库，以及db.properties位置-->
		<context:property-placeholder location="classpath:db.properties"/> 
		<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
			<property name="username" value="${user}"></property>
			<property name="password" value="${password}"></property>
			<property name="driverClassName" value="${driverClass}"></property>
			<property name="url" value="${jdbcUrl}"></property>
		</bean>
		
		<!-- 配置SqlSessionFactory -->
		<bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
			<property name="dataSource" ref="dataSource"></property>
			<property name="typeAliasesPackage" value="com.nap.domain"></property>
			<!-- <property name="configLocation" value="classpath:mybatis-config.xml"></property> -->
		</bean>
		
		<!-- 配置MapperScannerConfigurer -->
		<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
			<property name="basePackage" value="com.nap.mapper"></property>
			
		</bean>
		
		<!-- 配置事务管理器 -->
		<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
			<property name="dataSource" ref="dataSource"></property>
		</bean>
		<tx:advice id="advice" transaction-manager="transactionManager">
			<tx:attributes>
				<tx:method name="save" propagation="REQUIRED"/>
				<tx:method name="get" propagation="true"/>
				<tx:method name="*" propagation="REQUIRED"/>
			</tx:attributes>
		</tx:advice>
		<aop:config>
			<aop:pointcut expression="execution(* com.nap.service.impl.*.*(..))" id="pointcut"/>
			<aop:advisor advice-ref="advice" pointcut-ref="pointcut"/>
		</aop:config>
	</beans>

db.properties

user=root
password=123456
driverClass=com.mysql.jdbc.Driver
jdbcUrl=jdbc\:mysql\:///thing?useUnicode\=true&characterEncoding\=UTF-8

mybatis.cfg.xml-mybatis

<?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>
  	
  	<typeAliases>
  		<package name="com.nap.domain"/>
  	</typeAliases>
  	<mappers resourse="vo/user.mapper.xml">
  	<!-- mapper文件填写位置 -->	
  	</mappers>
  </configuration>

3、整合的实现

User.java

public class User {
	private int id;
	private String name;
	private String pwd;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
}

UserDao.java

public interface UserDao {
	public List<User> list();
}

UserDaoImpl.java

import java.util.List;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import vo.User;

import dao.UserDao;
@Repository("UserDao")
public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao {
	@Autowired
	public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory)
	{
		super.setSqlSessionFactory(sqlSessionFactory);
	}
	@Override
	public List<User> list()
	{
		return getSqlSession().selectList("vo.user.mapper.list");
	}

}

UserService.java

package service;

import java.util.List;

import vo.User;

public interface UserService {
	public List<User> list();

}

UserServiceImpl.java

package service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import dao.UserDao;

import service.UserService;
import vo.User;
@Service("userService")
public class UserServiceImpl implements UserService{
	@Autowired
	private UserDao userdao;
	public void setUserDao(UserDao userdao){
		this.userdao=userdao;
	}
	@Override
	public List<User> list() {
		// TODO Auto-generated method stub
		return userdao.list();
	}

}

list.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib prifix="c" uri="http://jakarta.apache.org/taglibs/standard/permittedTaglibs"%>
  <head>
  </head>
  <body>
     <table wid="80%" align="center">
     	<tr>
     		<td>编号</td>
     		<td>姓名</td>
     		<td>密码</td>
     	</tr>
     	<c:forEach items="${list}" var="bean">
     	<tr>
     		<td>${bean.id}</td>
     		<td>${bean.name}</td>
     		<td>${bean.pwd}</td>
     	</tr>
     </table>
  </body>
</html>