/**
* 分页查询
* @param O2008VipInfo
* @param page
* @param rows
* @return
* @throws Exception
*/
public List<?> loadVIPInfoList(O2008VipInfo o2008VipInfo,int page, int rows) throws Exception
{
StringBuilder sql = new StringBuilder(
"select ovi.id as \"id\"," +
" ovi.pax_name as \"paxName\"," +
" ovi.pax_firstname as \"paxFirstName\"," +
" ovi.pax_lastname as \"paxLastName\""+
" from o2008_vip_info ovi");
List<O2008VipInfo> result=executeSQLQueryWithPagination(sql.toString(),O2008VipInfo.class,o2008VipInfo, page, rows);
return result;
}
/**
* 根据sql查询出分页对象,其中转换的bean需要继承自baseItem类
*
* @param sql
* 查询sql字符串
* @param clazz
* 转换类
* @param object
* dto
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余2页未读,立即下载