数据库操作基类设计3

最新推荐文章于 2021-07-26 13:33:14 发布

hankerzhuli

最新推荐文章于 2021-07-26 13:33:14 发布

阅读量145

点赞数

分类专栏： JDBC 文章标签：数据库 php

本文链接：https://blog.csdn.net/hankerzhuli/article/details/84002606

版权

JDBC 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

public int queryTotalCount(T criteria)
{
String statementName = entitySimpleClassName + ".queryCount";
Integer totalCount = (Integer)getSqlMapClientTemplate().queryForObject(statementName, criteria);
return totalCount;
}
public List<T> queryByCriteria(String statementName, Map<String, Object> criteria)
{
List<T> entities = getSqlMapClientTemplate().queryForList(statementName, criteria);
return entities;
}
public PaginationSupport<T> queryPagingEntities(String statementName, Map<String, Object> criteria, int pageNo,
int countPerPage)
{
return queryForPagination(criteria, pageNo, countPerPage, statementName);
}
private PaginationSupport<T> queryForPagination(Object criteria, int pageNo, int countPerPage, String statementName)
{
PaginationSupport<T> entites = new PaginationSupport<T>();
entites.setCurrentPage(pageNo);
entites.setCountPerPage(countPerPage);
Integer totalCount = (Integer)getSqlMapClientTemplate().queryForObject(statementName + "Count", criteria);
entites.setTotal(totalCount);
List<T> entityList =
getSqlMapClientTemplate().queryForList(statementName, criteria, entites.getBegin(), countPerPage);
entites.setItems(entityList);
return entites;
}
}