📄 otherdisplay.jsp

📁 现今的社会是一个信息飞速发达的社会
💻 JSP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="con" scope="page" class="numb1.com.db"/>
<jsp:useBean id="ht" scope="page" class="numb1.com.Dohtml"/>
<jsp:useBean id="onLine" scope="application" class="numb1.com.onLine"/>
<%@ include file = "include/config.jsp" %>
<% 
String id    = (String)session.getAttribute("id");id=ht.donull(id);
String name  = (String)session.getAttribute("name");name=ht.donull(name);
String root  = (String)session.getAttribute("root");root=ht.donull(root);
String bdid  = request.getParameter("bdid");
String bbsid = request.getParameter("bbsid");
String stringpage=request.getParameter("page");//stringpage为未处理的字符串型的页码数
String table ="btable1";
String retable="";
String bdname="";
String bdmast="";
String main="main.jsp";
String display="display.jsp";

String title="";
String txt="";
String writerid="";
String writer="";
String tim="0000-00-00 00:00:00";
String retim="";
String penname="";
String up="";
String sup="";
String recom="";
String lock="";
String sql;
ResultSet rs;

String f_name=request.getRequestURI().substring(request.getRequestURI().lastIndexOf("/")+1,request.getRequestURI().lastIndexOf("."));

int count;
int x=0;//计数器
int showrow=8;//每页显示条数
int pages=1;//当前页数
int startrow; //本页开始条数

pages=ht.getInteger(stringpage,1);

if(!ht.isNumber(bdid) || !ht.isNumber(bbsid)){
    out.print("<meta http-equiv=\"refresh\" content=\"3;URL=index.jsp\"><center><h3><font color=#ff0000>您浏览的帖子已经被删除，或者参数有误！</font></h3></center>");
}else {

sql="SELECT  btable, name, page FROM board WHERE id="+bdid;
rs=con.query(sql);rs.next();
if(rs.getRow()!=0){
table=rs.getString(1);
bdname=con.getStr(rs.getString(2));
display=rs.getString(3)+"display.jsp";
main=rs.getString(3)+"main.jsp";
con.close();

java.io.File f1=new java.io.File(absDir+relDir+main);
java.io.File f2=new java.io.File(absDir+relDir+display);
if(!f1.isFile()){main="main.jsp";}
if(!f2.isFile()){display="display.jsp";}

if((_self.compareTo(display) != 0)&&(_self.compareTo("display.jsp") != 0)){
    response.sendRedirect(display+"?bdid="+bdid+"&bbsid="+bbsid);
}else{

sql="SELECT title, txt, up, super, recommendation, locked, userid, username, tim, ip, readtimes, penname FROM "+table+" WHERE id="+bbsid;
rs=con.query(sql);rs.next();
if(rs.getRow()==0){
out.print("<meta http-equiv=\"refresh\" content=\"3;URL=index.jsp\"><center><h3><font color=#ff0000>您浏览的帖子已经被删除，或者参数有误！</font></h3></center>");
}else{

title=con.getStr(rs.getString(1));
txt=con.getStr(rs.getString(2));
up=rs.getString(3);
sup=rs.getString(4);
recom=rs.getString(5);
lock=rs.getString(6);
writerid=rs.getString(7);
writer=con.getStr(rs.getString(8));
tim=rs.getString(9);
penname=con.getStr(rs.getString(12));
count=rs.getInt(11)+1;
con.close();
String update="UPDATE "+table+" SET readtimes="+count+" WHERE id="+bbsid;
con.update(update);
con.close();

//计算页数，回帖数
retable="re"+table;
sql="SELECT retitle, txt, userid, username, time, ip, penname FROM "+retable+" WHERE bbsid="+bbsid+" ORDER BY time";
rs=con.query(sql);
rs.last();
count=rs.getRow();
int pcount=count/showrow;
if(count%showrow>0){pcount=pcount+1;}
if(pcount<2)pcount=1;
if(pages>pcount)pages=pcount;
if(pages<2)pages=1;
startrow=(pages-1)*showrow+1;

if(root.compareTo("")==0){root="0";}
int step=Integer.parseInt(root);

sql = "SELECT id FROM master WHERE bid="+bdid+" AND userid='"+id+"'";
ResultSet rsm = con.query(sql);rsm.last();
if(rsm.getRow() > 0) step = 3;

if(online_enable == "on"){
String uId,uName,ip=request.getRemoteAddr();
if(id.compareTo("")==0){
uId="guest";
uName="guest";
}else{
uId=id;
uName=name;
}
onLine.addUser(uId,uName,(main+"?id="+bdid),ip,onTime);
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=title%>计算机BBS</title>
<style type="text/css">
<!--
p{text-indent:18pt;font-size:13px}
td{font-size:13px}
th{font-size:15px}
a:link{text-decoration:none;color:#0000ff}
a:visited{text-decoration:none;color:#0000ff}
a:hover{text-decoration:underline;color:#96CCFE}
.style1 {color: #FFFFFF}
.style6 {color: #0000FF}

.link {color:#585858}
.link a:link{text-decoration:none;color:#585858}
.link a:visited{text-decoration:none;color:#585858}
.link a:hover{text-decoration:underline;color:#96CCFE}
body {
	margin-bottom: 2px;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
function htmlIMG()
{
	var location = prompt("请输入图片的地址：","http://");
	if(location)
	{
		//var info = prompt("请输入图片的说明文字：","");
		form1.text.value=form1.text.value+"[img]"+location+"[/img]";
	}
}

function bbsdel() {
	
		if (confirm("确实要彻底删除吗?") == false)
			return ;
        window.open("action/delmaster.jsp?bbsid=<%=bbsid%>&bdid=<%=bdid%>");
		window.close();
}


function check_form(theform){
		
		
		if (theform.mvbdid.value=="-")
		{
			alert("请选择您要移入的版名！");
			theform.mvbdid.focus();
			return false;
		}
		if (theform.mvbdid.value=="<%=bdid%>")
		{
			alert("本版的内容不可以转移到本版");
			theform.mvbdid.focus();
			return false;
		}
  
	}


</script>

</head>

<body>
<table width="750"  border="0" align="center">
  <tr>
    <td><div align="right" style="font-size:12px "> [<a href="index.jsp">论坛首页</a>]
      <%	if(bdname.compareTo("")!=0){out.print(" [<a href=main.jsp?id="+bdid+"><font color=\"#FF0000\">"+bdname+"</font></a>]");}if(id==null||id.compareTo("")==0){
	%> [<a href="login.jsp?page=<%=f_name%>&bdid=<%=bdid%>&bbsid=<%=bbsid%>">登录</a>] [<a href="reg.jsp">注册</a>]<% }else{%> [<a href="shutdown.jsp">离开</a>]
        <% }%>
&nbsp;&nbsp; </div></td>
  </tr>
</table>
<table width="750" border="0" align="center">
  <tr>
    <td height="50"><img src="img/jsbbs.jpg" width="746" height="61"></td>
  </tr>
  <tr>
    <td><table width="100%"  border="0" cellspacing="0">
      <tr>
        <td height="8">&nbsp;</td>
      </tr>
      <tr>
        <td height="20" bgcolor="#f8f8f8">&nbsp;&nbsp;<a href="index.jsp">论坛</a> &gt; <% out.print("<a href=main.jsp?id="+bdid+">"+bdname+"</a> &gt; <font color=\"#FF0000\">"+title+"</font></a>");%> </td>
      </tr>
    </table></td>
  </tr>
</table>
  <table width="750" border="0" align="center">
    <tr>
      <td><div align="right">
       <% if(pcount>1){ if(pages>1){%><a
	   href="<%=_self%>?bdid=<%=bdid%>&bbsid=<%=bbsid%>"></a> <a
	   href="<%=_self%>?bdid=<%=bdid%>&bbsid=<%=bbsid%>&page=<%=(pages-1)%>">上一页</a><% }
	   if(pages<pcount){%> <a  href="<%=_self%>?bdid=<%=bdid%>&bbsid=<%=bbsid%>&page=<%=(pages+1)%>">下一页</a> <a
12 下一页
⌨️ 快捷键说明

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