JavaResources--provide free tutorial ebook source fpr you
Join  |  Add Resource  |  Forum  |  About Us  |  Contact Us  |  Policies    
 

 

<% Locale locale = Locale.CHINA; Format formatter = new SimpleDateFormat("MM/dd/yyyy"); Connection con=DbUtil.getCon(); BusinessObjFactory f=new BusinessObjFactory(){ public Object getBusinessObj(ResultSet rs)throws PagingException{ Vector v=new Vector(); try{ v.add(rs.getString("id")); v.add(rs.getString("type")); v.add(rs.getString("title")); v.add(rs.getString("username")); v.add(rs.getString("whenmade")); } catch(SQLException ex){ ex.printStackTrace(); throw new PagingException(ex.getMessage()); } return v; } }; out.println("
"); Page p=Page.getPage("select count(*) from resource where status=0 ","select * from resource where status=0 order by whenmade desc",con,f,20,request); out.println(p.getPagingHTMLCode("form1")); Iterator itr=p.getData().iterator(); int count=0; out.print(""); %> <% while(itr.hasNext()){ Vector v=(Vector)itr.next(); if(count%2==0) { out.print(""); } else { out.print(""); } count++; out.print("
Category Caption Username Updated
"+(String)v.elementAt(1)); out.print(""+""+(String)v.elementAt(2)+""); out.print(""+(String)v.elementAt(3)); java.util.Date date=new java.util.Date(Long.parseLong((String)v.elementAt(4))); String s = formatter.format(date); out.print(""+s); } out.println("
"); out.println(p.getPagingHTMLCode("form1")); out.println("
"); con.close(); %>

Copyright @ 2004- 2006  JavaResources. All rights reserved Grupo Publispain