📄 checkasp_jsp.java
字号:
package org.apache.jsp.bbs;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import java.io.*;
import java.util.*;
import java.util.Date;
import java.text.*;
public final class checkasp_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
public String htmln(String ftbbs)
{ String htmlftbbs;
ftbbs = htmlz(ftbbs,"<","<");
ftbbs = htmlz(ftbbs,">",">");
ftbbs = htmlz(ftbbs,"<br>","\n");
ftbbs = htmlz(ftbbs," "," ");
return ftbbs;
}
public String htmlz(String str,String newstr,String oldstr)
{
int find = -1;
int oldrep = oldstr.length();
do{
find = str.indexOf(oldstr);
if(find != -1)
str = str.substring(0,find) + newstr + str.substring(find+oldrep);
}while(find != -1);
return str;
}
String jibie,touxian,siteurl;
private static java.util.Vector _jspx_dependants;
static {
_jspx_dependants = new java.util.Vector(2);
_jspx_dependants.add("/bbs/../inc/ftbbstohtml.jsp");
_jspx_dependants.add("/bbs/../inc/conn.jsp");
}
public java.util.List getDependants() {
return _jspx_dependants;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=gb2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n");
out.write(" \r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write('\r');
out.write('\n');
out.write('\r');
out.write('\n');
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:db2000";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
out.write('\r');
out.write('\n');
out.write('\r');
out.write('\n');
String BoardID_1,BoardID_2,bbs_img,bbs_img_display,title,zhiye,htmfilename,postnum,BBS_Cate_Name1,BBS_Cate_Name2,BBS_Cate_Manager_Name,postuser,File;
String clubuser_reg_date,img,signname,reg_date,reuser_id;
ResultSet rs,rs1,rs2,rs3,rs6,rs7;
int jingyuan,tili;long reid=0;
String pid =request.getParameter("id");
String TitleID=request.getParameter("id");
String Sql_kind="select * from config where kind=1 order by id asc";
Statement stmt02=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs7=stmt02.executeQuery(Sql_kind);
if(rs7.next()){
siteurl=rs7.getObject("content").toString();
}
Statement stmt01=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql2="update bbstitle set hit=hit+1 where id="+pid;
stmt01.executeUpdate(sql2);
String sql="select * from bbstitle where id="+pid+" order by bbstop desc,redate";
rs=stmt.executeQuery(sql);
rs.next();
BoardID_1=rs.getObject("BoardID_1").toString();
BoardID_2=rs.getObject("BoardID_2").toString();
bbs_img=rs.getObject("bbs_img").toString();
bbs_img_display=rs.getObject("bbs_img_display").toString();
title=rs.getObject("title").toString();
zhiye=rs.getObject("zhiye").toString();
htmfilename=rs.getObject("htmfilename").toString();
postnum=rs.getObject("postnum").toString();
//rs.close();
String str="select BBS_Cate_Name,BBS_Cate_Manager_Name from BBS_Cate where BBS_Cate_ID='"+BoardID_1+"'";
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs1=stmt1.executeQuery(str);
rs1.next();
BBS_Cate_Name1=rs1.getString("BBS_Cate_Name"); //一级类别名称
BBS_Cate_Manager_Name=rs1.getString("BBS_Cate_Manager_Name"); //一级类别板主姓名
String sqlstr="select BBS_Cate_Name,BBS_Cate_Manager_Name from BBS_Cate where BBS_Cate_ID='"+BoardID_2+"'";
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs2=stmt2.executeQuery(sqlstr);
rs2.next();
BBS_Cate_Name2=rs2.getString("BBS_Cate_Name"); //二级类别名称
BBS_Cate_Manager_Name=rs2.getString("BBS_Cate_Manager_Name"); //二级类别板主姓名
String str1="select * from clubuser where clubuser_name='"+rs.getString("name")+"'";
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs3=stmt3.executeQuery(str1);
if(rs3.next())
{
jingyuan=rs3.getInt("jingyuan");
tili=rs3.getInt("tili");
img=rs3.getString("userimg");
clubuser_reg_date=rs3.getString("clubuser_reg_date");
signname=htmln(rs3.getString("signname"));
if(signname==null){
signname="你还没有签名，可以从修改资料中加入自已的签名";
}
}
else
{
jingyuan=0;
tili=100;
img="cache5.gif";
signname="你还没有签名，可以从修改资料中加入自已的签名";
}
if(jingyuan<=50)
{
touxian="小野人";
}
if(jingyuan>50&&jingyuan<=150)
{
touxian="野人";
}
if(jingyuan>150&&jingyuan<=500)
{
touxian="土人";
}
if(jingyuan>500&&jingyuan<=1000)
{
touxian="咕噜";
}
if(jingyuan>1000&&jingyuan<=2000)
{
touxian="大咕噜";
}
if(jingyuan>2000&&jingyuan<=4000)
{
touxian="咕噜队长";
}
if(jingyuan>4000&&jingyuan<=8000)
{
touxian="初级守卫";
}
if(jingyuan>8000&&jingyuan<=10000)
{
touxian="守卫队长";
}
if(jingyuan>10000&&jingyuan<=11000)
{
touxian="斗士";
}
if(jingyuan>11000&&jingyuan<=12000)
{
touxian="大斗士";
}
if(jingyuan>12000&&jingyuan<=14000)
{
touxian="斗士长";
}
if(jingyuan>14000&&jingyuan<=16000)
{
touxian="骑士";
}
if(jingyuan>16000&&jingyuan<=18000)
{
touxian="青铜骑士";
}
if(jingyuan>18000&&jingyuan<=20000)
{
touxian="白银骑士";
}
if(jingyuan>20000&&jingyuan<=22000)
{
touxian="黄金骑士";
}
if(jingyuan>22000&&jingyuan<=24000)
{
touxian="圣骑士";
}
if(jingyuan>24000&&jingyuan<=26000)
{
touxian="神秘头衔";
}
if(jingyuan>26000&&jingyuan<=28000)
{
touxian="神秘头衔";
}
if(jingyuan>28000)
{
touxian="神秘头衔";
}
if(jingyuan<=50)
{jibie="<img src=../bbs/userheadimg/class1.gif width=63 height=10>";}
if(jingyuan>50&&jingyuan<=150)
{jibie="<img src=../bbs/userheadimg/class2.gif width=63 height=10>";}
if(jingyuan>150&&jingyuan<=500)
{jibie="<img src=../bbs/userheadimg/class3.gif width=63 height=10>";}
if(jingyuan>500&&jingyuan<=1000)
{jibie="<img src=../bbs/userheadimg/class4.gif width=63 height=10>";}
if(jingyuan>1000&&jingyuan<=2000)
{jibie="<img src=../bbs/userheadimg/class5.gif width=63 height=10>";}
if(jingyuan>2000&&jingyuan<=4000)
{jibie="<img src=../bbs/userheadimg/class6.gif width=63 height=10>";}
if(jingyuan>4000&&jingyuan<=8000)
{jibie="<img src=../bbs/userheadimg/class7.gif width=63 height=10>";}
if(jingyuan>8000&&jingyuan<=10000)
{jibie="<img src=../bbs/userheadimg/class8.gif width=63 height=10>";}
if(jingyuan>10000&&jingyuan<=11000)
{jibie="<img src=../bbs/userheadimg/class9.gif width=63 height=10>";}
if(jingyuan>11000&&jingyuan<=12000)
{jibie="<img src=../bbs/userheadimg/class10.gif width=63 height=10>";}
if(jingyuan>12000&&jingyuan<=14000)
{jibie="<img src=../bbs/userheadimg/class11.gif width=63 height=10>";}
if(jingyuan>14000&&jingyuan<=16000)
{jibie="<img src=../bbs/userheadimg/class12.gif width=63 height=10>";}
if(jingyuan>16000&&jingyuan<=18000)
{jibie="<img src=../bbs/userheadimg/class13.gif width=63 height=10>";}
if(jingyuan>18000&&jingyuan<=20000)
{jibie="<img src=../bbs/userheadimg/class14.gif width=63 height=10>";}
if(jingyuan>20000&&jingyuan<=22000)
{jibie="<img src=../bbs/userheadimg/class15.gif width=63 height=10>";}
if(jingyuan>22000&&jingyuan<=24000)
{jibie="<img src=../bbs/userheadimg/class16.gif width=63 height=10>";}
if(jingyuan>24000&&jingyuan<=26000)
{jibie="<img src=../bbs/userheadimg/class17.gif width=63 height=10>";}
if(jingyuan>26000&&jingyuan<=28000)
{jibie="<img src=../bbs/userheadimg/class18.gif width=63 height=10>";}
if(jingyuan>28000)
{jibie="<img src=../bbs/userheadimg/class19.gif width=63 height=10>";}
out.write("\r\n");
out.write("\r\n");
out.write("<HTML>\r\n");
out.write("<HEAD>\r\n");
out.write("<META content=\"text/html; charset=gb2312\" http-equiv=Content-Type>\r\n");
out.write("<title>");
out.print(title);
out.write("</title>\r\n");
out.write("<LINK href=\"../css/xmwuye.css\" rel=stylesheet type=text/css>\r\n");
out.write("<script language=\"javascript\" src=\"../js/resizeImages.js\"></script>\r\n");
out.write("<script language=\"javascript\" src=\"../js/numjs.js\"></script>\r\n");
out.write("<script language = \"JavaScript\" src =\"../inc/Main.js\"></script>\r\n");
out.write("<META content=\"MSHTML 5.00.3700.6699\" name=GENERATOR></HEAD><BODY leftMargin=8 topMargin=3>\r\n");
out.write("<!--Begin0-->\r\n");
out.write("<div class=menuskin id=popmenu onMouseOver=\"clearhidemenu()\" onMouseOut=\"dynamichide(event)\" style=\"Z-index:100\"></div>\r\n");
out.write("<TABLE align=center class=\"table001\" border=0 cellPadding=0 cellSpacing=0 width=\"99%\"><TR>\r\n");
out.write(" <TD height=25 width=\"65%\"><IMG src=\"../images/bbs_t1.gif\" align=\"absmiddle\"> \r\n");
out.write(" 主题位置：<A class=a03 href=main.jsp>论坛首页</a>>><A class=a03 href=main.jsp?layer_1=");
out.print(BoardID_1);
out.write('>');
out.print(BBS_Cate_Name1);
out.write("</A>>><a class=a03 href=main.jsp?layer_1=");
out.print(BoardID_1);
out.write("&layer_2=");
out.print(BoardID_2);
out.write('>');
out.print(BBS_Cate_Name2);
out.write("</A> \r\n");
out.write(" <a class=a03 href=fbht.jsp?layer_1=");
out.print(BoardID_1);
out.write("&layer_2=");
out.print(BoardID_2);
out.write(">发布新贴</A></TD>\r\n");
out.write(" <TD height=22 width=\"35%\"><IMG align=absMiddle height=16 src=\"../bbs/images/posttitle.gif\" width=16> \r\n");
out.write(" 版 主：");
out.print(BBS_Cate_Manager_Name);
out.write("</TD>\r\n");
out.write(" </TR></TABLE>\r\n");
out.write("<TABLE align=\"center\" border=0 cellPadding=0 cellSpacing=0 width=\"99%\" style=\"table-layout:fixed; word-break:break-all\">\r\n");
out.write(" <TBODY>\r\n");
out.write(" <TR> \r\n");
out.write(" <TD class=td002 rowSpan=5 vAlign=top width=\"20%\"><DIV align=center> \r\n");
out.write(" <TABLE border=0 cellPadding=0 cellSpacing=0 width=\"100%\">\r\n");
out.write(" <TBODY>\r\n");
out.write(" <TR> \r\n");
out.write(" <TD height=22><DIV align=center>楼 主</DIV></TD>\r\n");
out.write(" </TR>\r\n");
out.write(" <TR> \r\n");
out.write(" <TD> <DIV align=center><IMG height=84 src=../bbs/userheadimg/");
out.print(img);
out.write(" width=84></DIV></TD>\r\n");
out.write(" </TR>\r\n");
out.write(" <TR> \r\n");
out.write(" <TD height=20>・网名：");
out.print(rs.getString("user_id"));
out.write("</TD>\r\n");
out.write(" </TR>\r\n");
out.write(" <TR> \r\n");
out.write(" <TD height=20>・头衔：");
out.print(touxian);
out.write("</TD>\r\n");
out.write(" </TR>\r\n");
out.write(" <TR> \r\n");
out.write(" <TD height=20>・级别：");
out.print(jibie);
out.write("</TD>\r\n");
out.write(" </TR>\r\n");
out.write(" <TR> \r\n");
out.write(" <TD height=20>・资历：");
out.print(tili);
out.write("</TD>\r\n");
out.write(" </TR>\r\n");
out.write(" <TR> \r\n");
out.write(" <TD height=20>・经验：");
out.print(jingyuan);
out.write("</TD>\r\n");
out.write(" </TR>\r\n");
out.write(" <TR> \r\n");
out.write(" <TD height=20>・注册：");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -