用jQuery Pagination插件实现的简易低效分页功能

由于第一次做项目，在读取数据显示时没能实现分页显示，最后项目快完成时制作了一种低效分页功能，思路为在jsp页面调用了以插件页数id为参数的数据获取方法，代码如下

<%    session.setAttribute("id_num", "0");//初始插件的被选页号为0    //获取点击的页码，第一次进入此界面设置id_num为0，    if(request.getParameter("id") == null)        session.setAttribute("id_num", "0");    }    else{        session.setAttribute("id_num", request.getParameter("id"));        String skill = request.getParameter("skill");//获取上一界面传来需要在数据库查询的键值        session.setAttribute("skilltype", skill);    }%><script language="javascript" type="text/javascript">    $(document).ready(function() {//每一次点击页码初始分页插件        var id_num = <%=Integer.parseInt((String)session.getAttribute("id_num")) %>        var query_count = <%=GetSkill.getCount((String)session.getAttribute("skilltype"))%>//获取得到数据总个数，用于初始化分页插件的总个数        $("#Pagination").pagination(query_count, {            callback : pageselectCallback,            prev_text : '< 上一页',             next_text: '下一页 >',            items_per_page : 10,            num_display_entries : 6,            current_page : id_num,            num_edge_entries : 1,            link_to: "?id=__id__"//跳转本界面并传递参数为点击的页数id号        });    });    function pageselectCallback(page_id, jq) {    }</script>

GetSkill类里定义的方法

//获取数据总个数public static int getCount(String skilltype) throws SQLException{        DB db = MongoDBConn.getDB();//获取数据库        DBCollection ojs = db.getCollection("manage_skill");        BasicDBObject queryObject = new BasicDBObject("fenlei", skilltype);        Cursor cursor = ojs.find(queryObject).sort(new BasicDBObject("datetime",-1));        int searChcount = 0;        while(cursor.hasNext()){                DBObject obj = cursor.next();                searChcount++;        }        return searChcount;    }//通过id获取需要得到的数据public static Collection<ManageSkill> getMess(String skilltype,String id) throws SQLException{        DB db=MongoDBConn.getDB();        int idnum=Integer.parseInt(id);        DBCollection ojs = db.getCollection("manage_skill");        BasicDBObject queryObject = new BasicDBObject("fenlei", skilltype);        Cursor cursor = ojs.find(queryObject).sort(new BasicDBObject("datetime",-1));        int searChcount = 0;        Collection<ManageSkill> ret=new ArrayList<ManageSkill>();        while(cursor.hasNext()){            DBObject obj = cursor.next();            searChcount++;            //每页显示10条，所以只将10条数据插入ArrayList对象中            if(searChcount >= idnum*10 && searchCount < idnum*10+10){                String title = (String) obj.get("title");                String fenlei = (String) obj.get("fenlei");                String content = (String) obj.get("content");                String keyword = (String) obj.get("keyword");                String datetime = (String) obj.get("datetime");                String imgname = (String) obj.get("imgname");                ManageSkill cmessage = new ManageSkill();                cmessage.setContent(content);                cmessage.setDatetime(datetime);                cmessage.setFenlei(fenlei);                cmessage.setKeyword(keyword);                cmessage.setTitle(title);                cmessage.setImgname(imgname);                ret.add(cmessage);            }        }        cursor.close();        return ret;    }

效果截图