package com.jh.core.db.jdbc.demo;
import java.util.List;
import com.jh.core.db.TagDAO;
import com.jh.core.util.JHPage;
public class SelectDemo {
/**
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception {
TagDAO<DemoBean> dao = new TagDAO<DemoBean>(DemoBean.class);
JHPage page = new JHPage();
page.setGoPage(2);
page.setSize(2);
String sql = " select * from DemoBean_tab ";
List list = null;
list = dao.getObjList(sql, page);// 取分页数据
list = dao.getObjList(sql, 3);// 取3条
list = dao.getObjList(sql);// 取所有
list = TagDAO.getObjList(sql, DemoBean.class, page);// 取分页数据
list = TagDAO.getObjList(sql, DemoBean.class, 3);// 取3条
list = TagDAO.getObjList(sql, DemoBean.class);// 取所有
list.size();
System.out.println("getLast" + page.getLast());
System.out.println("getSize" + page.getSize());
System.out.println("getCount" + page.getCount());
System.out.println("getPage" + page.getPage());
System.out.println("getGoPage" + page.getGoPage());
System.out.println("getList \n" + page.getList());
/*
* ##分页处理 #macro( PAGE_INFO ) 每页$!pageInfo.size条记录 |
* 共$!pageInfo.page页/$!pageInfo.count条记录 | <a
* href="javascript:goPage(1);"> 首 页</a> <a
* href="javascript:goPage($!pageInfo.prev);"> 上一页</a> <a
* href="javascript:goPage($!pageInfo.next);"> 下一页</a> <a
* href="javascript:goPage($!pageInfo.last);"> 最后一页</a> | 第 <input
* name="goPageNum" id="goPageNum" value="$!pageInfo.goPage" size="3" />
* 页 <a href="javascript:goPage2();">go</a> #end
*/
}
}