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

📄 11-23.txt

📁 jsp常用实例讲解
💻 TXT
字号:
🔍 
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>论坛</title>
<script language =JavaScript">
function newwin(url){
var newwin=window.open(url,"newwin","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yew,width=600,height=450");
newwin.focus();
return false;
}
</script>
</head>

<body bgcolor="#FF66FF">
<script language="JavaScript">
function submit11(){
self.location.replace("bbs.jsp");
}
</script>

<div align="center">
<center>
<%@ page import="java.sql.*" %>
<%-- 连接数据库使用的语句 --%>
<%
String url=new String();
String sql=new String();
url="jdbc:odbc:luntan";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(url);
%>
<%-- 论坛帖子分页显示--%>
<%
int pageLine=10;
int totalRec=0;
int totalSub=0;
int intPage=1;
if(request.getParameter("page")!=null)
	intPage=Integer.parseInt(request.getParameter("page"));
Statement stat=conn.createStatement();
ResultSet countrs=null;
try{
	//从数据库中取得帖子的总数
	countrs=stat.executeQuery("select count(*) as cnt from db2admin.board");
	if(countrs.next())
		totalRec=countrs.getInt("cnt");
	//从数据库中取得主帖数
	countrs=stat.executeQuery("select count(*) as cnt from db2admin.board where parent_no=0");
	if(countrs.next())
		totalSub=countrs.getInt("cnt");
}catch(Exception e){
	e.printStackTrace();
}finally{
	countrs.close();
	stat.close();
}
//得到每行的主贴数
int jtemp=totalRec/pageLine+1;
int totalSubPerPage=totalSub/jtemp;
//取得总页数
int intPageCount=0;
intPageCount=(totalSub/totalSubPerPage*10+5)/10;
%>
<font color="red"><h4>趣味论坛</h4></font>
<table border="1" cellspacing="0" width="600" bgcolor="#F0F8FF" bordercolorlight="#4DA6FF" bordercolordark="#ECF5FF">
<tr align="center" bgcolor="#0099FF">
<td width="100">标题</td>
<td width="60">作者</td>
<td width="100">发贴时间</td>
<td width="40">回复数</td>
<td width="40">点击数</td>
<td width="40">管理</td>
</tr>
<%
int serial;
String title;
String speaker;
String providedate;
int reply;
int click;
Statement stat1=conn.createStatement();
Statement stat2=conn.createStatement();
ResultSet contentrs=null;
ResultSet backrs=null;

try{
contentrs=stat1.executeQuery("select * from db2admin.board where parent_no=0 order by serial_no ");
int i=0;
while(contentrs.next()){
	i++;
	//显示帖子内容
	if(i>(totalSubPerPage*(intPage-1))&&(i<=(intPage*totalSubPerPage))){
		out.print("<TR><TD>");
		serial=contentrs.getInt("serial_no");
		title=contentrs.getString("title");
		speaker=contentrs.getString("speaker");
		providedate=contentrs.getString("provide_time");
		reply=contentrs.getInt("reply_num");
		click=contentrs.getInt("click_num");

		//显示主帖子的内容连接
		out.print("<a href=bbscontent.jsp?serial="+serial+" onClick='return newwin(this.href);'>"+title+"</a>");
		out.print("</td><td align=\"center\">");
		out.print(speaker);
		out.print("</td><td align=\"center\">");
		out.print(providedate);
		out.print("</td><td align=\"center\">");
		out.print(reply);
		out.print("</td><td align=\"center\">");
		out.print(click);
		out.print("</td><td align=\"center\">");
		out.print("<a href=\"delete.jsp?id="+serial+"\">删除</a>");
		out.print("</td></tr>");
		out.print("</center>");
		//显示回复帖子
		backrs=stat2.executeQuery("select * from board where parent_no="+serial+" order by serial_no");
		while(backrs.next()){
			out.println("<TR><TD>");
			serial=backrs.getInt("serial_no");
			title=backrs.getString("title");
			speaker=backrs.getString("speaker");
			providedate=backrs.getString("provide_time");
			reply=backrs.getInt("reply_num");
			click=backrs.getInt("click_num");
			//显示回复的内容的连接
			out.print("Re:<a href=bbsrecontent.jsp?serial="+serial+" onClick='return newwin(this.href);'>"+title+"</a>");
			out.print("</td><td align=\"center\">");
			out.print(speaker);
			out.print("</td><td align=\"center\">");
			out.print(providedate);
			out.print("</td><td align=\"center\">");
			out.print(reply);
			out.print("</td><td align=\"center\">");
			out.print(click);
			out.print("</td><td align=\"center\">");
			out.print("<a href=\"delete.jsp?id="+serial+"\">删除</a>");
			out.print("</td></tr>");
			out.print("</center>");
		}
	
	}
}

}catch(Exception e){
	e.printStackTrace();
}finally{
	backrs.close();
	contentrs.close();
	stat1.close();
	stat2.close();
}
%>
<%-- 分页显示帖子 --%>
<%
out.print("<TR>");
if(intPage<1)
	intPage=1;
out.println("<form method=\"post\" name=fPageNum action=\"bbs.jsp\">");
out.println("<center>分页&nbsp;");
if(intPage<2)
	out.println("<font color=\"white\">首页 上一页</font>");
else{
	out.println("<a href=\"bbs.jsp?page=1\">首页</a>&nbsp;");
	out.println("<a href=\"bbs.jsp?page="+(intPage-1)+"\">上一页</a>&nbsp;");	
}
if(intPage-intPageCount>=0)
	out.println("<font color=\"white\">下一页 尾页</font>");
else
	out.println("<a href=\"bbs.jsp?page="+(intPage+1)+"\">下一页</a>&nbsp;<a href=\"bbs.jsp?page="+intPageCount+"\">尾页</a>");
out.print("&nbsp;页次:<strong><font color=\"white\">"+intPage+"</font>/"+intPageCount+"</strong>页");
out.print("&nbsp;共<b>"+totalRec+"</b>条纪录<b> "+pageLine+" </b>条/页");
out.print("转到第<input type=\"text\" name=\"page\" size=\"2\" maxlength=\"10\" class=smallInput value=\""+intPage+"\">");
out.print("页<input class=buttonface type=\"submit\" value=\"GO\" name=\"cndok\"></span></p></form>");
out.print("</td>");
out.print("</tr>");
%>

<%
conn.close();
%>
</body>
</html>

⌨️ 快捷键说明

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