piclist.jsp.bak

本人用ＪＳＰ编写的一个网站程序

<%@ page language="java" import="java.io.*,java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="conn.jsp" %>
<LINK href="../css/style.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
body {
	margin-top: 0px;
}
-->
</style>
<%
  int i=1;
  int r=0;
  int j=0;
  int n=0;

  int pagecount=4;//每页显示的行数
  int currentpage=0;//当前页
  int nextpage=0;//下一页
  int previouspage=0;//上一页
  int beginpage=1;//首页
  int endpage=0;//尾页
  int pages=0;//总页数
  
  int linesum=0;//总行数
  int begincount=0;//起始行数
  int endcount=0;
  int pointcount=1;//计数器 
  
  int loc;
  

String pagesum = null;
String id = null;
String mtitle = null;
String mpic = null;
String urlStr = null;
String updStr = null;
String detStr = null;
String urlStrlink= null;
String priB = "";
String priE = "";
String priN = "";
String userid = (String) session.getValue("userid");
//String biaoshi = (String) session.getValue("biaoshi");	 

String sqlStr;

  pagesum=request.getParameter("pagesum");//获得当前页号
  if(pagesum==null)
    {currentpage=1;}
  else
    {currentpage=Integer.parseInt(pagesum);}

try{
//验证身份
sqlStr = "select priB, priN, priE from userprivilege where userid='"+userid+"'";
rs = stmt.executeQuery(sqlStr);
while(rs.next())
{
 priB = rs.getString(1);
 priN = rs.getString(2);
 priE = rs.getString(3);
 }	 
sqlStr = "select count(*) from building";
rs=stmt.executeQuery(sqlStr);
while (rs.next())
{
 linesum = Integer.parseInt(rs.getString(1));
 }
   pages=(linesum/pagecount)+1;
  endpage=pages;//尾页
  begincount=pagecount*(currentpage-1)+1;//起始行数
  endcount=pagecount*currentpage;//结束行数
  
  if(currentpage==pages)
  {nextpage=pages;}
  else
  {nextpage=currentpage+1;}//下一页
  
  if(currentpage==1)
  {previouspage=1;}
  else
  {previouspage=currentpage-1;}//上一页 
sqlStr = "select * from building order by buildtime DESC";
rs= stmt.executeQuery(sqlStr);

urlStr = "";
String id1 = null;
String id2 = null;
String mtitle1 = null;
String mtitle2 = null;
String mpic1 = null;
String mpic2 = null;
boolean gobackflag = false;

int recno = 0;

while (rs.next()) {

//    out.print("while");
	if (recno < begincount-1) { recno = recno + 1; gobackflag = true; continue; }
	
  	if (recno >=endcount) {
  		break;

  	} else {
  		recno = recno + 1;
		id = rs.getString("ID");
		mtitle = rs.getString("mtitle");
		mpic = rs.getString("mpic");
		byte[] mtitlebyte=mtitle.getBytes("ISO8859_1"); 
                mtitle=new String(mtitlebyte);
if ((recno%2)==1)
{	id1 = id;
    mtitle1 = mtitle;
    mpic1 = mpic;
	urlStr = "<tr align=\"center\"><td><a href=buildingdisplay.jsp?" + "&id=" +id1+ "><img src=\"" +mpic1 + "\" width=\"257\" height=\"225\" border=\"0\"><br>" + mtitle1 + "</a></td>"  ;
    detStr = "<a href=\"javascript:\" onClick=\"window.open(\'buildingdelete.jsp? "
				+ "&id=" + id  +"\',\'Updating\',\'scrollbars=yes,width=400,height=200\')\"><img src=\"../images/icon_delete.gif\"  width=\"20\" height=\"20\" border=\"0\"></a>";
    updStr = "<a href=\"BuildingUpdate.jsp?"
				+ "&id=" + id  + "\" ><img src=\"../images/icon_update2.gif\" width=\"20\" height=\"20\" border=\"0\"></a>&nbsp;" + "<font size=\"2\">" + mtitle1 + "</font>";
if((priB.equals("1"))||(priB.equals("1")&&priN.equals("1")&&priE.equals("1")))
   { urlStr = detStr + updStr + urlStr;}

    out.print(urlStr);
}else{
    id2 = id;
	mtitle2 = mtitle;
	mpic2 = mpic;
	urlStr =  "<td><a href=buildingdisplay.jsp?" + "&id=" +id2+ "><img src=\"" +mpic2 + "\" width=\"257\" height=\"225\" border=\"0\"><br>" + mtitle2 + "</a></td></tr>";
    urlStr = urlStr + "<tr align=\"center\"><td>&nbsp;</td><td>&nbsp;</td></tr>";
	detStr = "<a href=\"javascript:\" onClick=\"window.open(\'buildingdelete.jsp? "
				+ "&id=" + id  +"\',\'Updating\',\'scrollbars=yes,width=400,height=200\')\"><img src=\"../images/icon_delete.gif\"  width=\"20\" height=\"20\" border=\"0\"></a>";
    updStr = "<a href=\"BuildingUpdate.jsp?"
				+ "&id=" + id  + "\" ><img src=\"../images/icon_update2.gif\" width=\"20\" height=\"20\" border=\"0\"></a>&nbsp;" + "<font size=\"2\">" + mtitle2 + "</font>" ;
if((priB.equals("1"))||(priB.equals("1")&&priN.equals("1")&&priE.equals("1")))
  {  urlStr = detStr + updStr + urlStr ;}

	out.print(urlStr);
}
	
  	}
}
rs.close();
stmt.close();
conn.close();
}catch(java.sql.SQLException e)
	{
		out.print(e.toString());
		rs.close();
		stmt.close(); 
        conn.close(); 
	}
//隐藏“发布楼盘信息”
if((priB.equals("1")&&biaoshi.equals("B"))||(priB.equals("1")&&priN.equals("1")&&priE.equals("1")))
{
urlStr = "<tr><td background=\"../images/034.gif\"><div align=\"center\"><a href=\"addbuilding.jsp\">发布楼盘信息</a></div></td>";
urlStr = urlStr + "<td background=\"../images/034.gif\" ><div align=\"right\"><a href=\"buildinglist.jsp?&pagesum=" + beginpage +"\">首页</a>&nbsp;<a href=\"buildinglist.jsp?&pagesum=" + previouspage +"\">上一页</a>&nbsp;<a href=\"buildinglist.jsp?&pagesum=" + nextpage +"\">下一页</a>&nbsp;<a href=\"buildinglist.jsp?&pagesum=" + endpage +"\">尾页</a>&nbsp;</div></td></tr>";
out.print(urlStr);
}else{
urlStr = "<tr><td background=\"../images/034.gif\"></td>";
urlStr = urlStr + "<td background=\"../images/034.gif\" ><div align=\"right\"><a href=\"buildinglist.jsp?&pagesum=" + beginpage +"\">首页</a>&nbsp;<a href=\"buildinglist.jsp?&pagesum=" + previouspage +"\">上一页</a>&nbsp;<a href=\"buildinglist.jsp?&pagesum=" + nextpage +"\">下一页</a>&nbsp;<a href=\"buildinglist.jsp?&pagesum=" + endpage +"\">尾页</a>&nbsp;</div></td></tr>";
out.print(urlStr);
}
%>



</body>