1.传统dao开发模式的集成
这里所谓的传统dao开发模式指的是不使用mybatis的mapper接口。首先建立新的maven工程(如果您对maven不熟悉,请查看其它相关资料),添加spring、mybatis的依赖。maven依赖的代码如下:
<dependencies>
<!-- spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>3.2.5.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>3.2.5.RELEASE</version>
</dependency>
<!-- mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.3.1</version>
</dependency>
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.0.8</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.10</version>
<scope>test</scope>
</dependency>
jar包的依赖配好了,下来写spring的配置文件,spring.xml:
<context:property-placeholder location="classpath:jdbc.properties"/>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${db.driver}" />
<property name="url" value="${db.url}" />
<property name="username" value="${db.username}" />
<property name="password" value="${db.password}" />
<property name="initialSize" value="${db.initialSize}" />
<property name="maxActive" value="${db.maxActive}" />
<property name="validationQuery" value="${db.validationQuery}" />
</bean>
<!-- 创建SqlSessionFactory,同时指定数据源 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!--mybatis配置文件的路径-->
<property name="configLocation" value="mybatis-conf.xml"/>
</bean>
<bean id="userDao" class="com.jackie.springmybatis.dao.impl.UserDaoImpl">
<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
</bean>
spring的配置文件写完了,其中的jdbc.properties文件配置了连接数据库的基本信息,代码如下:
db.driver=com.mysql.jdbc.Driver
db.url=jdbc\:mysql\://192.168.1.104\:3306/test?characterEncoding\=UTF-8
db.username=root
db.password=123456
db.minIdle=5
db.maxIdle=10
db.maxWait=5
db.maxActive=20
db.initialSize=10
db.validationQuery=SELECT 1
现在看一下项目的结构:
mybatis的配置文件代码如下:
<configuration>
<!-- 别名定义 -->
<typeAliases>
<package name="com.jackie.springmybatis.domain"/>
</typeAliases>
<!-- 加载 映射文件, 这里注意mapper文件的路径 -->
<mappers>
<mapper resource="mapper/User.xml"/>
</mappers>
</configuration>
再来看一下java的相关代码:
public interface UserDao {
void insert(User user);
User selectByPrimaryKey(Integer id);
}
//实现类要继承SqlSessionDaoSupport 类,并且在spring的配置文件中,已经注入了sqlSessionFactory对象
public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao {
public void insert(User user) {
SqlSession session = this.getSqlSession();
session.insert("test.insertUser", user);
}
public User selectByPrimaryKey(Integer id) {
SqlSession session = this.getSqlSession();
User user = session.selectOne("test.selectByPrimaryKey", id);
return user;
}
}
java代码写完后,还差一个mapper.xml文件,在这里我们写成User.xml,代码如下:
<mapper namespace="test">
<insert id="insertUser" parameterType="User">
insert into nsl_yh (id, name, user_login_id, cellphone, password1 )
values (#{id}, #{name}, #{userLoginId}, #{cellphone}, #{password1} )
</insert>
<select id="selectByPrimaryKey" resultType="User" parameterType="java.lang.Integer" >
select
id,
name,
user_login_id userLoginId,
cellphone,
password1
from nsl_yh
where id = #{id}
</select>
OK,集成完了,看一下测试代码:
public class UserDaoTest {
private ApplicationContext factory;
@Before
public void setUp() throws Exception {
factory = new ClassPathXmlApplicationContext("spring.xml");
}
@Test
public void testInsert() {
UserDao userDao = (UserDao)factory.getBean("userDao");
User user = new User();
user.setName("王ss");
user.setCellphone("111111111");
user.setUserLoginId("wss");
userDao.insert(user);
}
}
完整代码请看:https://github.com/maodou95838/springmybatis
2.spring与mpper接口开发方式集成
还是使用上面搭建好的环境,maven的依赖配置不用改变。先来看spring配置文件的变化:
<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:tx="http://www.springframework.org/schema/tx"
xmlns:mybatis="http://mybatis.org/schema/mybatis-spring"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.2.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
http://mybatis.org/schema/mybatis-spring
http://mybatis.org/schema/mybatis-spring.xsd">
<!-- 配置数据源 -->
<context:property-placeholder location="classpath:jdbc.properties"/>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${db.driver}" />
<property name="url" value="${db.url}" />
<property name="username" value="${db.username}" />
<property name="password" value="${db.password}" />
<property name="initialSize" value="${db.initialSize}" />
<property name="maxActive" value="${db.maxActive}" />
<property name="validationQuery" value="${db.validationQuery}" />
</bean>
<!-- 创建SqlSessionFactory,同时指定数据源 -->
<!--对实体类进行批量重命名-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="typeAliasesPackage" value="com.jackie.springmybatis.domain"/>
</bean>
<!--指定mapper接口的包名-->
<!--需要引入mybatis的命名空间,请看文件头-->
<mybatis:scan base-package="com.jackie.springmybatis.dao" factory-ref="sqlSessionFactory"/>
</beans>
要注意的问题:mapper接口和mapper.xml在一个包下,并且接口名称和文件名称一样。工程结构如下:
由图可以看出,已经没有dao的实现类。并且,也没有了mybatis-conf.properties文件。下面请看dao层的java代码:
package com.jackie.springmybatis.dao;
import com.jackie.springmybatis.domain.User;
/**
* 用户dao接口
*
* @author Jackie
*
*/
public interface UserDao {
void insertUser(User user);
User selectByPrimaryKey(Integer id);
}
UserDao.xml的代码如下:
<mapper namespace="com.jackie.springmybatis.dao.UserDao">
<insert id="insertUser" parameterType="User">
insert into nsl_yh (id, name, user_login_id, cellphone, password1 )
values (#{id}, #{name}, #{userLoginId}, #{cellphone}, #{password1} )
</insert>
<select id="selectByPrimaryKey" resultType="User" parameterType="java.lang.Integer" >
select
id,
name,
user_login_id userLoginId,
cellphone,
password1
from nsl_yh
where id = #{id}
</select>
</mapper>
到此,mapper接口的方式集成完毕!下面看测试代码:
public class UserDaoTest {
private ApplicationContext factory;
@Before
public void setUp() throws Exception {
factory = new ClassPathXmlApplicationContext("spring.xml");
}
@Test
public void testInsert() {
UserDao userDao = (UserDao)factory.getBean("userDao");
User user = new User();
user.setName("王ss");
user.setCellphone("111111111");
user.setUserLoginId("wss");
userDao.insertUser(user);
}
}
这种方式与spring集成后,不用再spring的配置文件配置dao层,也没法配,在项目启动时,会自动将dao层的bean添加到spring的容器。命名方式是类名的第一个字母小写,其他不变。请看测试用例中获取userDao的代码。
代码请看:https://github.com/maodou95838/springmybatismapper
OK,Enjoy!