⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 elite.jsp

📁 bbs设计是一个论坛方面的设计 基于jsp的系统设计
💻 JSP
字号:
🔍 
<link rel=stylesheet href="style.css" type="text/css">
<body bgcolor="#DEDEDE">
<%@ page language="java" import="java.util.*" %> 
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="doit" scope="page" class="dbcon.doit" />
<jsp:useBean id="DB" scope="page" class="dbcon.mydb" />
<%
int intPageSize; 
int intRowCount;
int intPageCount; 
int intPage; 
String strPage,strAreaid,strSql=""; 
String strUser=(String)session.getValue("user");
String strShow=doit.changecode(strUser);
int i,intAreaid;  

//取得待显示页码 
strPage=(String)request.getParameter("page");
strAreaid=(String)session.getValue("area_id");

if(!strAreaid.equals("0")&&strAreaid!=null)
{intAreaid=java.lang.Integer.parseInt(strAreaid);
 strSql="SELECT  INT_ID,STR_TITLE,STR_AUTHOR,INT_RPLYNUMB,INT_CLICKNUMB,STR_DATE,INT_TXTLEN,INT_COOL,INT_ICON";
 strSql=strSql+" FROM DATA WHERE INT_ROOTID=0 AND INT_AREAID="+intAreaid+" AND INT_COOL=1 ORDER BY INT_ID DESC";
 }
else{strSql="SELECT INT_ID,STR_TITLE,STR_AUTHOR,INT_RPLYNUMB,INT_CLICKNUMB,STR_DATE,INT_TXTLEN,INT_COOL,INT_ICON";
     strSql=strSql+" FROM  DATA WHERE INT_ROOTID=0 and INT_COOL=1 ORDER BY INT_ID DESC";
   }
%>
<table border="0"  cellpadding="1" cellspacing="0" width="100%">
 <tr bgcolor="#cc3333">  
      <td align="center" nowrap ><font color="#ffffff" face="times new roman" ><strong>Title</strong></font></td>             
      <td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>Author</strong></font></td>             
      <td align="center" nowrap><font color="#ffffff" face="times new roman"><strong>Reply/Click</strong></font></td>             
      <td align="center" nowrap><font color="#ffffff"  face="times new roman"><strong>Date</strong></font></td>             
       </tr>    

<jsp:include page=draw_tb.js />
<% 
//设置一页显示的记录数 
intPageSize = 20; 

if(strPage==null){//表明在QueryString中没有page这一个参数，此时显示第一页数据 
intPage = 1; 
} 
else{//将字符串转换成整型 
intPage = java.lang.Integer.parseInt(strPage); 
if(intPage<1) intPage = 1; 
} 


ResultSet sqlRst=DB.executeQuery(strSql);
//获取记录总数 
sqlRst.last(); 
intRowCount = sqlRst.getRow(); 

//记算总页数 
intPageCount = (intRowCount+intPageSize-1) / intPageSize; 

//调整待显示的页码 
if(intPage>intPageCount) intPage = intPageCount; 

if(intPageCount>0){ 
//将记录指针定位到待显示页的第一条记录上 
       int intCurrent=(intPage-1) * intPageSize +1;
	   if (intCurrent<=1){
		  sqlRst.beforeFirst();
		}else{
		   sqlRst.absolute(intCurrent-1); 
			   }


//显示数据 
i = 0; 
String s1,s2,s3,s4,s5,s6,s7;
String id,icon,area_nick,area_link,cool_flag;
int all,s8,RowCount;
icon="";
s8=1;
all=0;
area_nick="";
area_link="";
RowCount=0;
while(i<intPageSize && sqlRst.next()){ 
id=sqlRst.getString("INT_ID");
s1=sqlRst.getString("STR_TITLE");
s2=sqlRst.getString("STR_AUTHOR");
s3=sqlRst.getString("INT_RPLYNUMB");
s4=sqlRst.getString("INT_CLICKNUMB");
s5=sqlRst.getString("STR_DATE");
s6="("+(String)sqlRst.getString("INT_TXTLEN")+" Bytes)";
cool_flag=sqlRst.getString("INT_COOL");
icon=sqlRst.getString("INT_ICON");
s1=s1+s6;

out.print("draw_table("+id+",'"+s1+"','"+s2+"',"+s3+","+s4+",'"+s5+"',"+cool_flag+","+icon+","+all+","+s8+",'"+area_nick+"','"+area_link+"');\n");
i++;

 
} 
}
%> 

</script>
</table>
<table border="0" width="100%"><tr><td align="left">[Total <%=intPageCount%> Pages]</td><td align="right">
<%if(intPage>1){%><a href="board.jsp?page=<%=intPage-1%>">Previous</a><%}%> Page<font color="red"><%=intPage%></font> <%if(intPage<intPageCount){%><a href="board.jsp?page=<%=intPage+1%>">Next</a><%}%> 
</td></tr></table>

<% 

sqlRst.close(); 

%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -