ibaits事务

最新推荐文章于 2018-10-15 21:39:37 发布

crazzy0727

最新推荐文章于 2018-10-15 21:39:37 发布

阅读量695

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/crazzy0727/article/details/9213159

本文介绍了一个基于Ibatis实现的分页查询方法及PageInfo类的设计，并展示了如何将查询结果转化为JSON格式，适用于需要处理大量数据并进行前后端交互的应用场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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 block
			e1.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);