titlelist.jsp

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

<%@ 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=8;//每页显示的行数
  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;
String title;
String content;
String pic;
String buildtime;
String sqlStr;
String userid = (String) session.getValue("userid");
//String biaoshi = (String) session.getValue("biaoshi");	 
String priN = "";
String priT = "";
  pagesum=request.getParameter("pagesum");//获得当前页号
  if(pagesum==null)
    {currentpage=1;}
  else
    {currentpage=Integer.parseInt(pagesum);}

try{
sqlStr = "select priN from userprivilege where userid='"+userid+"'";
rs = stmt.executeQuery(sqlStr);
while(rs.next())
{
 priT = rs.getString(1);
 }

sqlStr = "select count(*) from notice";
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;}//上一页 
out.print("<br>");
sqlStr = "select * from notice order by buildtime DESC";
rs= stmt.executeQuery(sqlStr);


boolean gobackflag = false;

int recno = 1;

while (rs.next()) {

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

  	} else {
  		recno = recno + 1;
		id = rs.getString("ID");
		title = rs.getString("title");
		content = rs.getString("content");
		pic = rs.getString("pic");
		buildtime = rs.getString("buildtime");
		byte[] titlebyte=title.getBytes("ISO8859_1"); 
                title=new String(titlebyte);
//if ((recno%2)==0)
//(		
String  start="<img src='../images/forumme.gif'>";
String	urlStr = start+"<a href=noticedisplay.jsp?id="+id+">" + title + "        " + "(" + buildtime + ")" + "</a>" + "<br><br>"  ;
		
String detStr = "<a href=\"javascript:\" onClick=\"window.open(\'noticedelete.jsp? "
				+ "&id=" + id  +"\',\'Updating\',\'scrollbars=yes,width=400,height=200\')\"><img src=\"../images/icon_delete.gif\"  width=\"20\" height=\"20\" border=\"0\"></a>";
String updStr = "<a href=\"NoticeUpdate.jsp?"
				+ "&id=" + id  + "\" ><img src=\"../images/icon_update2.gif\" width=\"20\" height=\"20\" border=\"0\"></a>&nbsp;";
if(priT.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(); 
	}

%>
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
<tr>
<%
if(priT.equals("1"))
{
%>
<td background="../images/034.gif"><div align="center"><a href="addnotice.jsp">发布公告</a></div></td>
<%
}
%>
<td background="../images/034.gif"><div align="right"><a href="noticelist.jsp?pagesum=<%=beginpage%>">首页</a>&nbsp;<a href="noticelist.jsp?pagesum=<%=previouspage%>">上一页</a>&nbsp;<a href="noticelist.jsp?pagesum=<%=nextpage%>">下一页</a>&nbsp;<a href="noticelist.jsp?pagesum=<%=endpage%>">尾页</a>&nbsp;</div></td>
</tr>

</table>
</body>