我用的mybatis是基于SqlSessionTemplate實(shí)現(xiàn)的，如下：
@Repository("daoSupport")
public class DaoSupport implements BaseDAO {
@Resource(name = "sqlSessionTemplate")
private SqlSessionTemplate sqlSessionTemplate;
/**
* 保存對(duì)象
* @param str
* @param obj
* @return
* @throws Exception
*/
public Object save(String str, Object obj){
return sqlSessionTemplate.insert(str, obj);
}
/**
* 批量更新
* @param str
* @param obj
* @return
* @throws Exception
*/
public Object batchSave(String str, List objs){
return sqlSessionTemplate.insert(str, objs);
}
/**
* 修改對(duì)象
* @param str
* @param obj
* @return
* @throws Exception
*/
public Object update(String str, Object obj){
Integer count=sqlSessionTemplate.update(str, obj);
@Service
public class OrderInfoService {
@Resource(name = "daoSupport")
private DaoSupport dao;
@SuppressWarnings("unchecked")
public List<PageData> getPerson() {
List<PageData> a =(List<PageData>)dao.findAllList(
"OrderInfoMapper.getOrderInfo");
return a;
}
public void save(PageData pd){
dao.save("OrderInfoMapper.saveOrderInfo", pd);
}
public void update(PageData pd){
dao.update("OrderInfoMapper.updateOrder", pd);
}
@SuppressWarnings("unchecked")
public List<PageData> list(PageData pd){
return (List<PageData>)dao.findForList("OrderInfoMapper.getOrderInfo", pd);
}
在xml文件里面寫(xiě)對(duì)應(yīng)sql的Mapper，我想在調(diào)用service層的方法操作數(shù)據(jù)庫(kù)時(shí)，幾條sql語(yǔ)句同時(shí)commit，其中有一條失敗則全部不執(zhí)行，就和jdbc那樣先設(shè)置不自動(dòng)commit，然后在commit那種，要在哪里配置或調(diào)用啥方法實(shí)現(xiàn)？
3 回答
元芳怎么了
TA貢獻(xiàn)1798條經(jīng)驗(yàn) 獲得超7個(gè)贊
Programmatic Transaction Management MyBatis SqlSession provides you
with specific methods to handle transactions programmatically. But
when using MyBatis-Spring your beans will be injected with a Spring
managed SqlSession or a Spring managed mapper. That means that Spring
will always handle your transactions.You cannot call SqlSession.commit(), SqlSession.rollback() or
SqlSession.close() over a Spring managed SqlSession. If you try to do
so, a UnsupportedOperationException exception will be thrown. Note
these methods are not exposed in injected mapper classes.Regardless of your JDBC connection's autocommit setting, any execution
of a SqlSession data method or any call to a mapper method outside a
Spring transaction will be automatically committed.If you want to control your transactions programmatically please refer
to chapter 10.6 of the Spring reference manual. This code shows how to
handle a transaction manually using the PlatformTransactionManager
described in section 10.6.2.
添加回答
舉報(bào)
0/150
提交
取消