showpage.java

jsp动态网页的例子

package spage;
import java.sql.*;
public class ShowPage
{	
	private String str = "";
	//显示页号为p的一页(user)
	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;
	}
}