ibaits事务

SqlMapClient sqlMapper = getSqlMap.getSqlMapClient();

sqlMapper.startTransaction();

sqlMapper.insert("CopyHtxx", h);

sqlMapper.insert("InsertJournal", journal);

sqlMapper.insert("InsertHtrz", rz);

sqlMapper.commitTransaction();

sqlMapper.endTransaction();

分页

public static PageInfo queryForPageInfo(String MapName,Object obj){String pagingMapName=MapName+"Paging";String countMapName=MapName+"Count";    SqlMapClient sqlMapper=getSqlMap.getSqlMapClient();    PageInfo pageInfo=new PageInfo();    try {    List list=sqlMapper.queryForList(pagingMapName, obj);    pageInfo.setRoot(list);    int count=Integer.valueOf(sqlMapper.queryForObject(countMapName,obj).toString());    pageInfo.setTotalCount(count);} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}return pageInfo;}

public class PageInfo {private int totalCount;private List root;public List getRoot() {return root;}public void setRoot(List root) {this.root = root;}public int getTotalCount() {return totalCount;}public void setTotalCount(int totalCount) {this.totalCount = totalCount;}}

public static JSONObject pageInfoToJson(PageInfo pageInfo){JsonConfig cfg=new JsonConfig();cfg.registerJsonValueProcessor(java.util.Date.class, new JsonValueProcessorImpl());JSONObject json = JSONObject.fromObject(pageInfo,cfg);return json;}

PageInfo pi = MgrHtgl.select(t);JSONObject json = IbatisBaseDb.pageInfoToJson(pi);if(pi.getTotalCount()>0){Htxx1 sum = MgrHtgl.selectAllHtxxSum(t);json.put("sum", sum);}JsonUtil.outJson(response,json);