开发环境:
System:Windows
WebBrowser:IE6+、Firefox3+
JavaEE Server:tomcat5.0.2.8、tomcat6
IDE:eclipse、MyEclipse 8
Database:MySQL
开发依赖库:
JavaEE5、Spring 3.0.5、Mybatis 3.0.4、myBatis-spring-1.0、Struts2.2.3、junit4.8.2、ext2.2.2
Email:hoojo_@126.com
Blog:[http://blog.csdn.net/IBM_hoojo](http://blog.csdn.net/IBM_hoojo)
[http://hoojo.cnblogs.com/](http://hoojo.cnblogs.com/)
上次介绍过Spring3、SpringMVC、MyBatis3整合,在线博文:[http://www.cnblogs.com/hoojo/archive/2011/04/15/2016324.html](http://www.cnblogs.com/hoojo/archive/2011/04/15/2016324.html)
###一、准备工作
1、 下载jar包
Struts2 jar下载:
[http://labs.renren.com/apache-mirror//struts/library/struts-2.2.3-lib.zip](http://labs.renren.com/apache-mirror/struts/library/struts-2.2.3-lib.zip)
Spring3 jar下载:
[http://ebr.springsource.com/repository/app/library/version/detail?name=org.springframework.spring&version=3.0.5.RELEASE](http://ebr.springsource.com/repository/app/library/version/detail?name=org.springframework.spring&version=3.0.5.RELEASE)
MyBatis3 jar 下载:[http://www.mybatis.org/java.html](http://www.mybatis.org/java.html)
2、 添加的jar包如下:
[![image](https://box.kancloud.cn/2016-04-01_56fe1228701fa.gif "image")](http://hi.csdn.net/attachment/201105/11/0_13051060949h9C.gif)
#### 二、Spring、MyBatis整合
1、 需要的jar文件如下:
[![clip_image002](https://box.kancloud.cn/2016-04-01_56fe12288ecc8.gif "clip_image002")](http://hi.csdn.net/attachment/201105/11/0_13051061019KQL.gif)
2、 在src目录中加入mybatis.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>
<typeAlias type="com.hoo.entity.Account" alias="account"/>
<typeAliases>
<configuration>
~~~
上面的配置文件中,可以加入一些公共、常用的MyBatis方面的全局配置。如handler、objectFactory、plugin、以及mappers的映射路径(由于在applicationContext-common中的SqlSessionFactoryBean有配置mapper的location,这里就不需要配置)等。这个类的文件名称和下面的applicationContext-common.xml中的configLocation中的值对应,不是随便写的。
3、 在src目录中添加applicationContext-common.xml中加入内容如下:
~~~
<xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
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
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd ">
<-- 配置DataSource数据源 -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://10.0.0.131:3306/ash2"/>
<property name="username" value="dev"/>
<property name="password" value="dev"/>
bean>
<-- 配置SqlSessionFactoryBean -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="configLocation" value="classpath:mybatis.xml"/>
<-- mapper和resultmap配置路径 -->
<property name="mapperLocations">
<list>
<-- 表示在com.hoo.resultmap包或以下所有目录中,以-resultmap.xml结尾所有文件 -->
<value>classpath:com/hoo/resultmap/**/*-resultmap.xmlvalue>
<value>classpath:com/hoo/entity/*-resultmap.xmlvalue>
<value>classpath:com/hoo/mapper/**/*-mapper.xmlvalue>
list>
property>
bean>
<-- 配置事务管理器,注意这里的dataSource和SqlSessionFactoryBean的dataSource要一致,不然事务就没有作用了 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
bean>
<-- 配置事务的传播特性 -->
<bean id="baseTransactionProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" abstract="true">
<property name="transactionManager" ref="transactionManager" />
<property name="transactionAttributes">
<props>
<prop key="add*">PROPAGATION_REQUIREDprop>
<prop key="edit*">PROPAGATION_REQUIREDprop>
<prop key="remove*">PROPAGATION_REQUIREDprop>
<prop key="insert*">PROPAGATION_REQUIREDprop>
<prop key="update*">PROPAGATION_REQUIREDprop>
<prop key="del*">PROPAGATION_REQUIREDprop>
<prop key="*">readOnlyprop>
props>
property>
bean>
<-- 通过扫描的模式,扫描目录在com/hoo/mapper目录下,所有的mapper都继承SqlMapper接口的接口, 这样一个bean就可以了 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.hoo.mapper"/>
<property name="markerInterface" value="com.hoo.mapper.SqlMapper"/>
<bean>
<beans>
~~~
DataSource,这里的是采用jdbc的dataSource;
SqlSessionFactory,是MyBatis团队提供整合Spring的SqlSession工厂Bean用它可以完成Spring和MyBatis的整合。SqlSessionFactoryBean需要注入DataSource,配置myBatis配置文件的location,以及配置mapper.xml和resultMap.xml文件的路径,可以用通配符模式配置。其实mapper里面是可以存放resultMap的内容的。由于resultMap文件的内容是和JavaBean及数据库表对象进行映射的。一般一张表、一个JavaBean(Model)对应一个resultMap文件。将resultMap独立出来提供可读性、维护性。
TransactionManager,事务管理器是采用jdbc的管理器。需要注入DataSource数据源,这里注入的数据源和SqlSessionFactory是同一个数据源。如果不同的数据源,事务将无法起到作用。
baseTransactionProxy,事务的传播特性才有spring提供的TransactionProxyFactoryBean这个事务代理工厂的拦截器类来完成。其他的暂时还没有可以支持事务配置的传播特性和隔离级别的方法,关于这里你可以参考:[http://www.cnblogs.com/hoojo/archive/2011/04/15/2017447.html](http://www.cnblogs.com/hoojo/archive/2011/04/15/2017447.html)
MapperScannerConfigurer是MyBatis的mapper接口的扫描器,通过这个配置可以完成对指定basePackage报下的类进行扫描,如果这些类有继承SqlMapper这个类的,将会是MyBatis的接口。不需要单独配置mapper,而完成注入。
4、 在src目录添加applicationContext-beans.xml这个文件,文件内容如下:
~~~
<xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
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
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd">
<-- 注解探测器 -->
<context:component-scan base-package="com.hoo"/>
<beans>
~~~
这里面可以完成一下Action、Bean的注入配置
5、 JavaBean(Model、Entity)相关类、及resultMap.xml文件内容
Bean
~~~
package com.hoo.entity;
import java.io.Serializable;
import java.util.Date;
public class Account implements Serializable {
private static final long serialVersionUID = -7970848646314840509L;
private Integer accountId;
private String username;
private String password;
private Date createTime;
public Account() {
super();
}
//getter、setter
@Override
public String toString() {
return this.accountId + "#" + this.username + "#" + this.password + "#" + this.createTime;
}
}
account-resultMap.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="accountMap">
<resultMap type="com.hoo.entity.Account" id="accountResultMap">
<id property="accountId" column="account_id"/>
<result property="username" column="username"/>
<result property="password" column="password"/>
<result property="createTime" column="create_time"/>
<resultMap>
<mapper>
~~~
resultMap的type属性和对应的classpath对应,id会在mapper.xml文件中用到。下面的属性property是JavaBean的属性,column和数据库的字段对应。
6、 上面的applicationContext-common.xml中配置了SqlMapper,下面是SqlMapper代码,就一个空接口
~~~
package com.hoo.mapper;
/**
* function:所有的Mapper继承这个接口
* @author hoojo
* @createDate 2011-4-12 下午04:00:31
* @file SqlMapper.java
* @package com.hoo.mapper
* @project MyBatisForSpring
* @blog http://blog.csdn.net/IBM_hoojo
* @email hoojo_@126.com
* @version 1.0
*/
public interface SqlMapper {
}
~~~
7、 定制我们自己的增删改查(CRUD)组件,接口如下
~~~
package com.hoo.mapper;
import java.util.List;
import org.springframework.dao.DataAccessException;
/**
* function: BaseSqlMapper继承SqlMapper,对Mapper进行接口封装,提供常用的增删改查组件;
* 也可以对该接口进行扩展和封装
* @author hoojo
* @createDate 2011-4-14 上午11:36:41
* @file BaseSqlMapper.java
* @package com.hoo.mapper
* @project MyBatisForSpring
* @blog http://blog.csdn.net/IBM_hoojo
* @email hoojo_@126.com
* @version 1.0
*/
public interface BaseSqlMapper<T> extends SqlMapper {
public void add(T entity) throws DataAccessException;
public void edit(T entity) throws DataAccessException;
public void remvoe(T entity) throws DataAccessException;
public T get(T entity) throws DataAccessException;
public List<T> getList(T entity) throws DataAccessException;
}
~~~
当然实际开发中,增删改查组件一定不止这几个方法。这里只是随便挪列几个方法做一个示例。实际中可以根据需求进行添加方法,这里添加的方法可以用一个mapper.xml进行实现,然后注入这个mapper即可完成操作。也可以定义其他的mapper,如AccountMapper继承这个接口。然后为AccountMapper提供实现也是可以的。
8、 下面看看AccountMapper接口
~~~
package com.hoo.mapper;
import java.util.List;
import com.hoo.entity.Account;
/**
* function:继承SqlMapper,MyBatis数据操作接口;此接口无需实现类
* @author hoojo
* @createDate 2010-12-21 下午05:21:20
* @file AccountMapper.java
* @package com.hoo.mapper
* @project MyBatis
* @blog http://blog.csdn.net/IBM_hoojo
* @email hoojo_@126.com
* @version 1.0
*/
public interface AccountMapper<T extends Account> extends BaseSqlMapper<T> {
public List<T> getAllAccount();
}
~~~
上面的AccountMapper继承了BaseSqlMapper,并且提供了自己所需要的方法。下面实现这个Mapper中和父接口的方法。
account-mapper.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">
<-- namespace和定义的Mapper接口对应,并实现其中的方法 -->
<mapper namespace="com.hoo.mapper.AccountMapper">
<select id="getList" parameterType="com.hoo.entity.Account" resultType="list" resultMap="accountResultMap">
select * from account where username like '%' #{username} '%'
select>
<select id="getAllAccount" resultType="list" resultMap="accountResultMap">
select * from account
select>
<-- accountResultMap是account-resultmap.xml中定义的resultmap -->
<select id="get" parameterType="account" resultType="com.hoo.entity.Account" resultMap="accountResultMap">
[CDATA[
select * from account where account_id = #{accountId}
]]>
select>
<-- 自动生成id策略 -->
<insert id="add" useGeneratedKeys="true" keyProperty="account_id" parameterType="account">
insert into account(account_id, username, password)
values(#{accountId}, #{username}, #{password})
insert>
<update id="edit" parameterType="account">
update account set
username = #{username},
password = #{password}
where account_id = #{accountId}
update>
<delete id="remove" parameterType="account">
delete from account where account_id = #{accountId}
<delete>
<mapper>
~~~
mapper的namespace和接口的classpath对应,里面的sql语句的id和方法名称对应。这样就完成了AccountMapper的实现。
9、 下面来测试下AccountMapper的功能,代码如下:
~~~
package com.hoo.mapper;
import java.util.List;
import javax.inject.Inject;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests;
import com.hoo.entity.Account;
/**
* function: AccountMapper JUnit测试类
* @author hoojo
* @createDate 2011-4-12 下午04:21:50
* @file AccountMapperTest.java
* @package com.hoo.mapper
* @project MyBatisForSpring
* @blog http://blog.csdn.net/IBM_hoojo
* @email hoojo_@126.com
* @version 1.0
*/
@ContextConfiguration("classpath:applicationContext-*.xml")
public class AccountMapperTest extends AbstractJUnit38SpringContextTests {
@Inject
private AccountMapper<Account> mapper;
public void testGetAccount() {
Account acc = new Account();
acc.setAccountId(28);
System.out.println(mapper.get(acc));
}
public void testAdd() {
Account account = new Account();
account.setUsername("lisi@155.com");
account.setPassword("abc");
mapper.add(account);
}
public void testEditAccount() {
Account acc = new Account();
acc.setAccountId(28);
acc = mapper.get(acc);
System.out.println(acc);
acc.setUsername("Zhangsan22");
acc.setPassword("123123");
mapper.edit(acc);
System.out.println(mapper.get(acc));
}
public void testRemoveAccount() {
Account acc = new Account();
acc.setAccountId(28);
mapper.remvoe(acc);
System.out.println(mapper.get(acc));
}
public void testAccountList() {
List<Account> acc = mapper.getAllAccount();
System.out.println(acc.size());
System.out.println(acc);
}
public void testList() {
Account acc = new Account();
acc.setUsername("@qq.com");
List<Account> list = mapper.getList(acc);
System.out.println(list.size());
System.out.println(list);
}
}
~~~
运行上面的方法,没有错误基本上就算完成了Mapper的功能了。
10、 下面来写一个数据库操作的基类Dao,代码如下:
~~~
package com.hoo.dao;
import java.util.List;
import com.hoo.mapper.BaseSqlMapper;
/**
* function:
* @author hoojo
* @createDate 2011-4-14 上午11:30:09
* @file BaseMapperDao.java
* @package com.hoo.dao
* @project MyBatisForSpring
* @blog http://blog.csdn.net/IBM_hoojo
* @email hoojo_@126.com
* @version 1.0
*/
public interface BaseMapperDao<T> {
@SuppressWarnings("unchecked")
public void setMapperClass(Class<? extends BaseSqlMapper> mapperClass);
public BaseSqlMapper<T> getMapper();
public boolean add(T entity) throws Exception;
public boolean edit(T entity) throws Exception;
public boolean remove(T entity) throws Exception;
public T get(T entity) throws Exception;
public List<T> getAll(T entity) throws Exception;
}
~~~
这个Dao定义了BaseSqlMapper中的方法,还提供了一个setMapperClass的方法。目的是在使用这个dao的时候,需要设置一个Mapper的class。且这个Mapper必须要是BaseSqlMapper或它的子类。所有的dao都可以用BaseMapperDao来完成CRUD操作即可,当BaseMapperDao的方法不够用的情况下,可以在接口中提供SqlSession、SqlSessionTemplate方法,让底层人员自己扩展所需要的方法。这里的dao和mapper好像有点冗余,因为dao和mapper完成的功能都是类似或是相同的。但是你可以在dao中,同时调用不同的mapper,来完成当前模块的dao所需要的功能。
11、 看看BaseMapperDao的实现代码
~~~
package com.hoo.dao.impl;
import java.util.List;
import javax.inject.Inject;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.stereotype.Repository;
import com.hoo.dao.BaseMapperDao;
import com.hoo.mapper.BaseSqlMapper;
/**
* function:运用SqlSessionTemplate封装Dao常用增删改方法,可以进行扩展
* @author hoojo
* @createDate 2011-4-14 下午12:22:07
* @file BaseMapperDaoImpl.java
* @package com.hoo.dao.impl
* @project MyBatisForSpring
* @blog http://blog.csdn.net/IBM_hoojo
* @email hoojo_@126.com
* @version 1.0
*/
@SuppressWarnings("unchecked")
@Repository
public class BaseMapperDaoImpl<T> extends SqlSessionTemplate implements BaseMapperDao<T> {
@Inject
public BaseMapperDaoImpl(SqlSessionFactory sqlSessionFactory) {
super(sqlSessionFactory);
}
private Class<? extends BaseSqlMapper> mapperClass;
public void setMapperClass(Class<? extends BaseSqlMapper> mapperClass) {
this.mapperClass = mapperClass;
}
public BaseSqlMapper<T> getMapper() {
return this.getMapper(mapperClass);
}
public boolean add(T entity) throws Exception {
boolean flag = false;
try {
this.getMapper().add(entity);
flag = true;
} catch (Exception e) {
flag = false;
throw e;
}
return flag;
}
public boolean edit(T entity) throws Exception {
boolean flag = false;
try {
this.getMapper().edit(entity);
flag = true;
} catch (Exception e) {
flag = false;
throw e;
}
return flag;
}
public T get(T entity) throws Exception {
return this.getMapper().get(entity);
}
public List<T> getAll() throws Exception {
return this.getMapper().getList(null);
}
public boolean remove(T entity) throws Exception {
boolean flag = false;
try {
this.getMapper().remvoe(entity);
flag = true;
} catch (Exception e) {
flag = false;
throw e;
}
return flag;
}
}
~~~
这个实现类继承了SqlSessionTemplate,并且要注入SqlSessionFactory。提供的setMapperClass方法需要设置其BaseSqlMapper或它的子类。
好了,至此基本的CRUD的mapper和dao就算完成了。现在我们可以定义我们自己的业务模块,调用公共组件来完成增删改查操作。
12、 下面测试下这个BaseMapperDao功能
~~~
package com.hoo.dao;
import javax.inject.Inject;
import org.junit.Before;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests;
import com.hoo.entity.Account;
import com.hoo.mapper.AccountMapper;
/**
* function:
* @author hoojo
* @createDate 2011-4-14 下午01:08:49
* @file BaseMapperDaoImplTest.java
* @package com.hoo.dao
* @project MyBatisForSpring
* @blog http://blog.csdn.net/IBM_hoojo
* @email hoojo_@126.com
* @version 1.0
*/
@ContextConfiguration("classpath:applicationContext-*.xml")
public class BaseMapperDaoImplTest extends AbstractJUnit38SpringContextTests {
@Inject
private BaseMapperDao<Account> dao;
@Before
public void init() {
System.out.println(dao);
dao.setMapperClass(AccountMapper.class);
}
public void testGet() throws Exception {
init();
Account acc = new Account();
acc.setAccountId(28);
System.out.println(dao.get(acc));
}
public void testAdd() throws Exception {
init();
Account account = new Account();
account.setUsername("temp@156.com");
account.setPassword("abc");
System.out.println(dao.add(account));
}
}
~~~
13、 下面定义AccountDao接口
~~~
package com.hoo.dao;
import java.util.List;
import org.springframework.dao.DataAccessException;
/**
* function: Account数据库操作dao接口
* @author hoojo
* @createDate 2011-4-13 上午10:21:38
* @file AccountDao.java
* @package com.hoo.dao
* @project MyBatisForSpring
* @blog http://blog.csdn.net/IBM_hoojo
* @email hoojo_@126.com
* @version 1.0
*/
public interface AccountDao<T> {
/**
* function: 添加Account对象信息
* @author hoojo
* @createDate 2011-4-13 上午11:50:05
* @param entity Account
* @return boolean 是否成功
* @throws DataAccessException
*/
public boolean addAccount(T entity) throws DataAccessException;
/**
* function: 根据id对到Account信息
* @author hoojo
* @createDate 2011-4-13 上午11:50:45
* @param id 编号id
* @return Account
* @throws DataAccessException
*/
public T getAccount(Integer id) throws DataAccessException;
/**
* function: 查询所有Account信息
* @author hoojo
* @createDate 2011-4-13 上午11:51:45
* @param id 编号id
* @return Account
* @throws DataAccessException
*/
public List<T> getList() throws DataAccessException;
}
~~~
14、 AccountDao实现类
~~~
package com.hoo.dao.impl;
import java.util.List;
import javax.inject.Inject;
import org.springframework.dao.DataAccessException;
import org.springframework.stereotype.Repository;
import com.hoo.dao.AccountDao;
import com.hoo.dao.BaseMapperDao;
import com.hoo.entity.Account;
import com.hoo.mapper.AccountMapper;
/**
* function: Account数据库操作dao
* @author hoojo
* @createDate 2011-4-13 上午10:25:02
* @file AccountDaoImpl.java
* @package com.hoo.dao.impl
* @project MyBatisForSpring
* @blog http://blog.csdn.net/IBM_hoojo
* @email hoojo_@126.com
* @version 1.0
*/
@SuppressWarnings("unchecked")
@Repository
public class AccountDaoImpl<T extends Account> implements AccountDao<T> {
@Inject
private BaseMapperDao<Account> dao;
public boolean addAccount(T entity) throws DataAccessException {
dao.setMapperClass(AccountMapper.class);
boolean flag = false;
try {
dao.add(entity);
flag = true;
} catch (DataAccessException e) {
flag = false;
throw e;
} catch (Exception e) {
throw new RuntimeException(e);
}
return flag;
}
public T getAccount(Integer id) throws DataAccessException {
dao.setMapperClass(AccountMapper.class);
Account acc = new Account();
T entity = null;
try {
acc.setAccountId(id);
entity = (T) dao.get(acc);
} catch (DataAccessException e) {
throw e;
} catch (Exception e) {
throw new RuntimeException(e);
}
return entity;
}
public List<T> getList() throws DataAccessException {
dao.setMapperClass(AccountMapper.class);
List<T> list = null;
try {
list = (List<T>) ((AccountMapper)dao.getMapper()).getAllAcount();
} catch (DataAccessException e) {
throw e;
} catch (Exception e) {
throw new RuntimeException(e);
}
return list;
}
}
~~~
注意,上面的方法都设置了MapperClass,表示当前dao的Mapper是AccountMapper对象。所有的mapper方法都是调用AccountMapper这个对象中的方法。
15、 下面定义服务器层接口
~~~
package com.hoo.biz;
import java.util.List;
import org.springframework.dao.DataAccessException;
/**
* function: biz层Account接口
* @author hoojo
* @createDate 2011-4-13 上午11:33:04
* @file AccountBiz.java
* @package com.hoo.biz
* @project MyBatisForSpring
* @blog http://blog.csdn.net/IBM_hoojo
* @email hoojo_@126.com
* @version 1.0
*/
public interface AccountBiz<T> {
/**
* function: 添加Account对象信息
* @author hoojo
* @createDate 2011-4-13 上午11:50:05
* @param entity Account
* @return boolean 是否成功
* @throws DataAccessException
*/
public boolean addAccount(T entity) throws DataAccessException;
public boolean execute(T entity) throws DataAccessException;
/**
* function: 根据id对到Account信息
* @author hoojo
* @createDate 2011-4-13 上午11:50:45
* @param id 编号id
* @return Account
* @throws DataAccessException
*/
public T getAccount(Integer id) throws DataAccessException;
/**
* function: 查询所有Account信息
* @author hoojo
* @createDate 2011-4-13 上午11:51:45
* @param id 编号id
* @return Account
* @throws DataAccessException
*/
public List<T> getList() throws DataAccessException;
}
~~~
16、 AccountBiz的实现代码
~~~
package com.hoo.biz.impl;
import java.util.List;
import javax.inject.Inject;
import org.springframework.dao.DataAccessException;
import org.springframework.stereotype.Component;
import com.hoo.biz.AccountBiz;
import com.hoo.dao.AccountDao;
import com.hoo.entity.Account;
import com.hoo.exception.BizException;
/**
* function: Account Biz接口实现
* @author hoojo
* @createDate 2011-4-13 上午11:34:39
* @file AccountBizImpl.java
* @package com.hoo.biz.impl
* @project MyBatisForSpring
* @blog http://blog.csdn.net/IBM_hoojo
* @email hoojo_@126.com
* @version 1.0
*/
//@Component
@Service
public class AccountBizImpl<T extends Account> implements AccountBiz<T> {
@Inject
private AccountDao<T> dao;
public boolean addAccount(T entity) throws DataAccessException {
if (entity == null) {
throw new BizException(Account.class.getName() + "对象参数信息为Empty!");
}
return dao.addAccount(entity);
}
public T getAccount(Integer id) throws DataAccessException {
return dao.getAccount(id);
}
public List<T> getList() throws DataAccessException {
return dao.getList();
}
public boolean execute(T entity) throws DataAccessException {
if (entity == null) {
throw new BizException(Account.class.getName() + "对象参数信息为Empty!");
}
return dao.addAccount(entity);
}
}
~~~
直接注入AccountDao完成相关操作即可
17、 如果你需要在业务层设置事务传播特性,需要在applicationContext-bean.xml中加入配置如下:
~~~
<-- 为AccountBiz接口配置事务拦截器,baseTransactionProxy是事务拦截器,在Action中获取这个对象 -->
<bean id="accountBiz" parent="baseTransactionProxy">
<-- 设置target,也就是AccountBiz的实现类 -->
<property name="target" ref="accountBizImpl"/>
<bean>
~~~
这样在Action中注入accountBiz这个对象后,那么当这个对象出现DataAccessException异常的时候,就会自动回滚事务。
至此,Spring和MyBatis的整合就完成了。
- 前言
- ExtJS 中用js 操作cookie的方法
- eclipse MyEclipse中安装 ext插件 spket提示
- eclipse MyEclipse中安装 spket插件 js文件内容字体变小解决方案
- ExtJS中,在FireFox浏览器中字体很小,解决方法
- ExtJS中grid按照中文拼音首字母排序、改变行背景、列背景、静态数据分页不再困难
- ExtJS中grid按照使用Expand插件、分组显示、中文拼音首字母排序、改变行背景、列背景、静态数据分页综合案例
- ExtJS EditorGridPanel 示例之xml格式Store前后台增删改查
- ExtJS EditorGridPanel 示例之Array格式(自定义Array解析器)Store前后台增删改查
- ExtJS EditorGridPanel 示例之Array格式Store前后台增删改查(不支持分页)
- ExtJS EditorGridPanel 示例之JSON格式Store前后台增删改查
- Ext 中,为Ext.form.HtmlEditor添加键盘事件
- ExtJS 文件浏览器,可以选择文件和文件夹
- Struts2、Spring3、MyBatis3整合ExtJS,完成ColumnTree 【一】
- Struts2、Spring3、MyBatis3整合ExtJS,完成ColumnTree 【二】
- Struts2、Spring3、MyBatis3整合ExtJS,完成CheckNodeColumnTree
- ExtJS Form扩展组件[ColorFiled, DateTimeFiled, IconCombo, MultiComboBox, DynamicTreeCombox]
- Ext [DDTabPanel、FoodImageField、ImageChooser]扩展组件