spring与mybatis的整合
简单使用java项目进行整合
1.导入spring和mybatis所需要的jar包和依赖包
2.创建用户实体类User
package com
.liu
.www
.entity
;
import java
.util
.Date
;
public class User {
private int id
;
private String name
;
private Date birthday
;
private double salary
;
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 Date
getBirthday() {
return birthday
;
}
public void setBirthday(Date birthday
) {
this.birthday
= birthday
;
}
public double getSalary() {
return salary
;
}
public void setSalary(double salary
) {
this.salary
= salary
;
}
@Override
public String
toString() {
return "User [id=" + id
+ ", name=" + name
+ ", birthday=" + birthday
+ ", salary=" + salary
+ "]";
}
public User(int id
, String name
, Date birthday
, double salary
) {
super();
this.id
= id
;
this.name
= name
;
this.birthday
= birthday
;
this.salary
= salary
;
}
public User() {
super();
}
}
对于数据库中s-user内容
3.编写dao接口UserDao
package com
.liu
.www
.dao
;
import java
.util
.List
;
import com
.liu
.www
.entity
.User
;
public interface UserDao {
List
<User> findAll();
}
4.配置userMapper.xml
为了方便管理在项目下建了一个Source Folder名为config，在config下建Package名为mapper包专门用来放置各mapper配置
<?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.liu.www.dao.UserDao">
<select id="findAll" resultMap="getUserMap">
select * from s_user;
</select>
<resultMap type="User" id="getUserMap">
<id column="user_id" property="id"/>
<result column="user_name" property="name"/>
<result column="user_birthday" property="birthday"/>
<result column="user_salary" property="salary"/>
</resultMap>
</mapper>
5.在config下创建一个spring.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:context="http://www.springframework.org/schema/context"
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.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<context:property-placeholder location="classpath:db.properties"/>
<context:component-scan base-package="com.liu.www"></context:component-scan>
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${driver}"></property>
<property name="jdbcUrl" value="${url}"></property>
<property name="user" value="${user}"></property>
<property name="password" value="${password}"></property>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="mapperLocations" value="classpath:mapper/*.xml"></property>
<property name="typeAliasesPackage" value="com.liu.www.entity"></property>
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.liu.www.dao"></property>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="get" read-only="true"/>
<tx:method name="find" read-only="true"/>
<tx:method name="*"/>
</tx:attributes>
</tx:advice>
<aop:config>
<aop:pointcut expression="execution(* com.liu.www.service*.*(..))" id="pointcut"/>
<aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut"/>
</aop:config>
</beans>
6.在config下建db.properties用于设置连接数据库
7.在service下建一个testUserDao测试类
package com
.liu
.www
.service
;
import java
.util
.List
;
import org
.junit
.Test
;
import org
.junit
.runner
.RunWith
;
import org
.springframework
.beans
.factory
.annotation
.Autowired
;
import org
.springframework
.test
.context
.ContextConfiguration
;
import org
.springframework
.test
.context
.junit4
.SpringJUnit4ClassRunner
;
import com
.liu
.www
.dao
.UserDao
;
import com
.liu
.www
.entity
.User
;
@RunWith(SpringJUnit4ClassRunner
.class)
@ContextConfiguration("classpath:spring.xml")
public class TestUserDao {
@Autowired
private UserDao userDao
;
@Test
public void testFind() {
List
<User> findAll
= userDao
.findAll();
System
.out
.println(findAll
);
}
}
运行结果：
已查询出结果，表示spring整合mybatis做查询成功！
