mybatis学习笔记（十一）spring与mybatis整合

1.创建web工程，导入spring依赖包与mybatis依赖包，还需要mybatis-spring.jar，这是spring连接mybatis的桥梁．下载地址：http://mvnrepository.com/artifact/org.mybatis/mybatis-spring

2.配置文件

1)web.xml配置，指定spring配置文件名为config/spring-cfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" 
	xmlns="http://java.sun.com/xml/ns/j2ee" 
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 
	http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
    <!-- spring入口 -->
	<!-- 自动加载spring配置文件WEB-INF/applicationContenxt.xml -->
	<listener>
	     <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	<!-- 修改spring配置文件路径 -->
	<context-param>
	     <param-name>contextConfigLocation</param-name>
	     <param-value>WEB-INF/classes/config/spring-cfg.xml</param-value>
	</context-param>
</web-app>

2)spring-cfg.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-3.2.xsd   
    http://www.springframework.org/schema/tx   
    http://www.springframework.org/schema/tx/spring-tx-3.2.xsd  
    http://www.springframework.org/schema/context  
    http://www.springframework.org/schema/context/spring-context-3.2.xsd">
	<import resource="classpath:config/spring-mybatis.xml"/>
	<!-- 开启注解注入 -->
    <context:annotation-config></context:annotation-config>
    <context:component-scan base-package="com.skymr.mybatis.dao"></context:component-scan>
    <context:component-scan base-package="com.skymr.mybatis.service"></context:component-scan>
</beans>

引用mybatis的spring配置文件，开启自动扫描功能，扫描dao层与service层．

3)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"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd">
	<!-- 数据源 -->
	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<!-- 这个属性driverClassName为什么在DriverManagerDataSource及父类中找不到呢 -->
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://127.0.0.1:3306/website"/>
		<property name="username" value="root" />
		<property name="password" value="root" />
	</bean>
	
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="com.skymr.mybatis.dao"></property>
		<property name="sqlSessionFactoryBeanName" value="sessionFactory"></property>
	</bean>
	
	<!-- sessionFactory配置 -->
	<bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="mapperLocations" value="classpath:com/skymr/mybatis/mappers/*.xml"/>
		<property name="configLocation" value="classpath:config/mybatis-config.xml"/>
	</bean>
</beans>

首先是配置数据源；

再配置了个MapperScannerConfigurer，这个是什么用的呢？

在Service的实现层中，要使用到dao层的实现层的实例，但是mybatis中是没有dao层实现层的啊，怎么注入到Service中呢，我想MapperScannerConfiger就是解决这个问题的，它是将mybatis自己对dao层的实例化后的实例注入到spring容器中，我们就可以取出后使用．

最后配置了SqlsessionFactory，指定mapper文件路径与mybatis的另一些配置．

3)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>
	<typeAliases>
		<!-- 别名配置，方便书写 -->
		<package name="com.skymr.mybatis.model"/>
	</typeAliases>
</configuration>

只是定义别名而已．

3．分层

1)．Model层

package com.skymr.mybatis.model;

public class User {

	private int id;
	
	private String userName;
	
	private String password;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}
	
	public String toString(){
		return id+"," + userName+","+password;
	}
}

2)Dao层

package com.skymr.mybatis.dao;

import com.skymr.mybatis.model.User;

public interface UserDao {

	public User login(String userName, String password);
}

3)mapper层，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.skymr.mybatis.dao.UserDao">
	<select id="login" resultType="User">
		select * from mybatis_user where userName=#{param1} and password=#{param2}
	</select>
</mapper> 

4).Service层

package com.skymr.mybatis.service;

import com.skymr.mybatis.model.User;

public interface UserService {

	
	public User login(String userName, String password);
}

package com.skymr.mybatis.service.impl;

import javax.annotation.Resource;

import org.springframework.stereotype.Repository;

import com.skymr.mybatis.dao.UserDao;
import com.skymr.mybatis.model.User;
import com.skymr.mybatis.service.UserService;
@Repository("userService")
public class UserServiceBean implements UserService{
	@Resource
	private UserDao userDao;
	
	public User login(String userName, String password) {
		return userDao.login(userName, password);
	}

}

4.测试

package com.skymr.mybatis.service;

import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.skymr.mybatis.model.User;

public class LoginTest {

	@Test
	public void loginTest(){
		 ApplicationContext context= new ClassPathXmlApplicationContext("/config/spring-cfg.xml");
		 UserService service =(UserService) context.getBean("userService");
		 User user = service.login("aaaa", "aaaa");
		 System.out.println(user);   
	}
}