开始学习spring了,这块的内容有点多。
一步一步来学,先从最简单的开始。
首先从ORM开始。mybatis与spring整合,需要mybatis-spring,另外网上查了一下,有三种方式,参考搜索“spring与mybatis三种整合方法”。第一种是使用注解SQL的方式,不喜欢,第二种感觉自己可控的太少,不方便,因此是选择的第三种方式。
Maven就是方便,要的东西配置一下,就自已从网上下载到本地库了,整合mybatis和spring,需要以下:
spring-context、spring-orm、mybatis-spring,数据连接用的DBCP,完整的pom.xml:
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>mybatistest</groupId>
<artifactId>mybatistest</artifactId>
<version>0.0.1-SNAPSHOT</version>
<properties>
<org.springframework-version>
4.0.2.RELEASE
</org.springframework-version>
<org.mybatis-version>
3.2.6
</org.mybatis-version>
</properties>
<dependencies>
<!-- <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc14</artifactId>
<version>10.2.0.1.0</version> </dependency> -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${org.mybatis-version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.2</version>
</dependency>
<!-- DBCP -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.2.2</version>
</dependency>
<dependency>
<groupId>commons-collections</groupId>
<artifactId>commons-collections</artifactId>
<version>3.1</version>
</dependency>
<dependency>
<groupId>commons-pool</groupId>
<artifactId>commons-pool</artifactId>
<version>1.2</version>
</dependency>
</dependencies>
</project>
先要弄个spring的配置文件:src/test/resources中,建applicationContext.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-3.0.xsd
">
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:XE" />
<property name="username" value="MyBatis" />
<property name="password" value="MyBatis" />
</bean>
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="classpath:mybatis-configuration.xml" />
</bean>
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="sqlSessionFactory" />
</bean>
<bean id="userDaoImpl" class="mybatistest.dao.impl.UserDaoImpl">
<!--注入SqlSessionTemplate实例 -->
<property name="sqlSessionTemplate" ref="sqlSession" />
<!--也可直接注入SqlSessionFactory实例,二者都指定时,SqlSessionFactory失效 -->
<!-- <property name="sqlSessionFactory" ref="sqlSessionFactory" /> -->
</bean>
<bean id="userServiceImpl" class="mybatistest.service.impl.UserServiceImpl">
<property name="mainDao" ref="userDaoImpl" />
</bean>
</beans>
这时,我们的dao和service需要改造了:
首先,BaseDaoImpl需要继承SqlSessionDaoSupport,这样该类和子类全部都可以使用getSqlSession()来直接获取数据库Session处理了
package mybatistest.dao.impl;
import java.io.Serializable;
import java.lang.reflect.ParameterizedType;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import mybatistest.dao.BaseDao;
public class BaseDaoImpl<T, PK extends Serializable> extends
SqlSessionDaoSupport implements BaseDao<T, PK> {
private Class<T> clazz;
@SuppressWarnings("unchecked")
public BaseDaoImpl() {
this.clazz = (Class<T>) ((ParameterizedType) getClass()
.getGenericSuperclass()).getActualTypeArguments()[0];
}
public T getByID(PK id) {
String methodName = Thread.currentThread().getStackTrace()[1]
.getMethodName();
return getSqlSession()
.selectOne(clazz.getName() + "." + methodName, id);
}
}
Service层中,因为定义了一个父类,使用的泛型DAO接口,所以要生成getter和setter方法,以便注入:
package mybatistest.service.impl;
import java.io.Serializable;
import mybatistest.dao.BaseDao;
import mybatistest.service.BaseService;
public abstract class BaseServiceImpl<T, PK extends Serializable> implements
BaseService<T, PK> {
protected BaseDao<T, PK> mainDao;
public BaseDao<T, PK> getMainDao() {
return mainDao;
}
public void setMainDao(BaseDao<T, PK> mainDao) {
this.mainDao = mainDao;
}
public T getByID(PK id) {
return mainDao.getByID(id);
};
}
因现在使用的spring的注入,因此UserServiceImpl就不需要在构造函数中,自己new UserDaoImpl()了:
package mybatistest.service.impl;
import mybatistest.entity.User;
import mybatistest.service.UserService;
public class UserServiceImpl extends BaseServiceImpl<User, String> implements
UserService {
public String userLogin(String userNumber, String userPassword) {
// ((UserDao) mainDao).getUserString("");
User user = mainDao.getByID("1");
if (null == user) {
return "用户不存在!";
}
if ("XXX" != userPassword) {
return "密码不正确!";
}
return "登录成功!";
}
}
好了,把Test.java改一下:
package mybatistest;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import mybatistest.entity.User;
import mybatistest.service.UserService;
public class Test {
public static void main(String[] args) {
ApplicationContext ac = new ClassPathXmlApplicationContext(
"applicationContext.xml");
// 注意定义成接口,并通过getBean方式取得Bean
UserService userService = (UserService) ac.getBean("userServiceImpl");
// 测试从接口中的服务取一个entity
User user = userService.getByID("1");
System.out.println(user.getUserName());
// 测试调接口的userLogin服务
System.out.println(userService.userLogin("1", "XXX"));
}
}
这样,最基本的mybatis与spring的整合就完成了。