Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public int getRowCount(String tableName){
- try{
- Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE
- , ResultSet.CONCUR_READ_ONLY);
- ResultSet res=stmt.executeQuery("select * from "+tableName);
- res.last();
- int i=res.getRow();
- res.close();
- return i;
- }catch(SQLException e){return 0;}
- }
- public List retriveBlogs(String tableName,int page){
- int rowCount=getRowCount(tableName);
- int pagescount=rowCount/10;
- int pointer;
- List table=new LinkedList();
- if(rowCount%10!=0){
- pagescount++;
- }
- if(page<=pagescount){
- pointer=((page-1)*10)+1;
- try{
- Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE
- ,ResultSet.CONCUR_READ_ONLY);
- ResultSet res=stmt.executeQuery("select * from "+tableName+" order by id");
- res.absolute(pointer);
- for(int i=0;i<10;i++){
- List row=new LinkedList();
- //Enter Number of Coloums to retrive from database
- row.add(res.getObject(1));
- row.add(res.getObject(2));
- row.add(res.getObject(3));
- row.add(res.getObject(4));
- row.add(res.getObject(5));
- table.add(row);
- res.next();
- if(res.isAfterLast()){
- break;
- }
- }
- res.close();
- return table;
- }catch(SQLException e){return null;}
- }else{
- return null;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement