jsp+access论坛

package spage; import java.sql.*; public class ShowPage { private String str = ""; //显示页号为p的一页(user) String textContent=request.getParameter("name"); byte b[]=textContent.getBytes("iso-8859-1"); textContent=new String(b); public String printPage(ResultSet rs, int p, int size) { str = ""; //将访问游标定位到页号为p的页要显示的第一条记录的位置 try { for(int k=0;k<(p-1)*size;k++) rs.next(); } catch(SQLException e) { } for(int iPage=1; iPage<=size; iPage++) { str += printRow(rs,iPage,p); try { if(!rs.next()) break; } catch(Exception e) { } } return str; } //显示单行记录(user) public String printRow( ResultSet rs ,int i,int p) { String temp = ""; try { int id=rs.getInt("userid"); temp+="<tr align='center' bgcolor='#FFFAF7'>"; temp+="<td><a href='detailuser.jsp?detailid="+id+"'>"+rs.getString("name")+"</a></td>"; temp+="<td>"+rs.getString("sex")+"</td>"; temp+="<td>"+rs.getString("age")+"</td>"; int grade=rs.getInt("rank"); temp+="<td>"; switch (grade) { case 0:temp+="普通用户";break; case 1:temp+="1区斑竹";break; case 2:temp+="2区斑竹";break; case 3:temp+="3区斑竹";break; case 4:temp+="管理员";break; } temp+="</td>"; temp+="<td>"+rs.getString("pubnum")+"</td>"; temp += "<td><a href='updateuser.jsp?updateid="+id+"'>修改</a></td>"; temp += "<td><a href='dealdeleteuser.jsp?delid="+id+"'>删除</a></td>"; temp += "</tr>"; } catch(SQLException e) { } return temp; } //显示页号为p的一页(board) public String artPrintPage(ResultSet rs, int p, int size,boolean f,boolean isex) { str = ""; //将访问游标定位到页号为p的页要显示的第一条记录的位置 try { for(int k=0;k<(p-1)*size;k++) rs.next(); } catch(SQLException e) { } for(int iPage=1; iPage<=size; iPage++) { str += artPrintRow(rs,iPage,p,f,isex); try { if(!rs.next()) break; } catch(Exception e) { } } return str; } //显示单行记录(board) public String artPrintRow( ResultSet rs ,int i,int p,boolean f,boolean isex) { String temp = ""; try { int id=rs.getInt("id"); temp+="<tr align='center'>"; boolean ex=rs.getBoolean("excellent"); if(ex) temp+="<td><img src='images/isbest.gif'></td>"; else temp+="<td><img src='images/folder.gif'></td>"; temp+="<td><a href='detail.jsp?id="+id+"' target='_blank'>"+rs.getString("title")+"</a></td>"; temp+="<td><a href='javaScript:detailwin("+rs.getString("userid")+")'>"+rs.getString("name")+"</a></td>"; temp+="<td>"+rs.getString("reNum")+"</td>"; temp+="<td>"+rs.getString("pubtime")+"</td>"; if(f) { if(isex) temp += "<td><a href='addex.jsp?exid="+id+"'>加精</a></td>"; else temp += "<td><a href='delex.jsp?delexid="+id+"'>从精华中删去</a></td>"; } temp += "</tr>"; } catch(SQLException e) { } return temp; } //显示页号为p的一页(article) public String detailPage(ResultSet rs, int p, int size,String logid,boolean f) { str = ""; //将访问游标定位到页号为p的页要显示的第一条记录的位置 try { for(int k=0;k<(p-1)*size;k++) rs.next(); } catch(SQLException e) { } for(int iPage=1; iPage<=size; iPage++) { str += detailRow(rs,iPage,p,logid,f); try { if(!rs.next()) break; } catch(Exception e) { } } return str; } //显示单行记录(article) public String detailRow( ResultSet rs ,int i,int p,String logid,boolean f) { String temp = ""; try { temp+="<tr>"; temp+="<td width='25%' height='15' align='center'>"+rs.getString("name")+"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"; if(rs.getString("sex").equals("男")) temp+="<img src='images/boy.gif'></td>"; else temp+="<img src='images/girl.gif'></td>"; temp+="<td><img src='"+rs.getString("feel")+"'>&nbsp;&nbsp;"+rs.getString("title")+"</td></tr>"; temp+="<tr>"; temp+="<td height='150' align='center' valign='middle'><img src='"+rs.getString("face")+"' height='60%' width='60%'></td>"; temp+="<td rowspan='2' valign='top'>"+rs.getString("content")+"</td></tr>"; temp+="<tr>"; int grade=rs.getInt("rank"); temp+="<td>等级："; switch (grade) { case 0:temp+="普通用户";break; case 1:temp+="1区斑竹";break; case 2:temp+="2区斑竹";break; case 3:temp+="3区斑竹";break; case 4:temp+="管理员";break; } temp+="<br>年龄："+rs.getString("age"); temp+="<br>文章："+rs.getString("pubnum")+"</td>"; temp+="<tr>"; temp+="<td>发贴时间："+rs.getString("pubtime")+"</td>"; temp+="<td align='right'>&nbsp;"; String id=rs.getString("id"); String authorid=rs.getString("authorID"); if(i==1) { if(f||logid.equals(authorid)) temp += "<a href='update.jsp?updateid="+id+"'><img src='images/edit.gif' border='0'></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"; if(f) temp += "<a href='dealdelete.jsp?delid="+id+"'><img src='images/delete.gif' border='0'></a>"; } else { if(f||logid.equals(authorid)) { temp += "<a href='update.jsp?updateid="+id+"'><img src='images/edit.gif' border='0'></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"; temp += "<a href='dealdelete.jsp?delid="+id+"'><img src='images/delete.gif' border='0'></a>"; } } temp+="</td></tr>"; } catch(SQLException e) { } return temp; } }