📄 query_jsp.java
字号:
package org.apache.jsp.web.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public final class query_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
public String getServletInfo() {
return "database handler";
}
private static java.util.Vector _jspx_dependants;
static {
_jspx_dependants = new java.util.Vector(1);
_jspx_dependants.add("/web/jsp/incdb.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");
request.setCharacterEncoding("GB2312");
out.write("\r\n");
out.write("\r\n");
out.write("<!--¿ªÊ¼µ¼Èëpackages-->\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\n");
out.write("<!--µ¼Èë½áÊø-->");
out.write('\r');
out.write('\n');
twm.bbsuser user = null;
synchronized (_jspx_page_context) {
user = (twm.bbsuser) _jspx_page_context.getAttribute("user", PageContext.PAGE_SCOPE);
if (user == null){
user = new twm.bbsuser();
_jspx_page_context.setAttribute("user", user, PageContext.PAGE_SCOPE);
}
}
out.write('\r');
out.write('\n');
twm.bbsboard board = null;
synchronized (_jspx_page_context) {
board = (twm.bbsboard) _jspx_page_context.getAttribute("board", PageContext.PAGE_SCOPE);
if (board == null){
board = new twm.bbsboard();
_jspx_page_context.setAttribute("board", board, PageContext.PAGE_SCOPE);
}
}
out.write("\r\n");
out.write("\r\n");
java.sql.ResultSet sqlRst; //'ADODB RECORDSE 对象
int i,method;
String tempSTR,strSQL,whereTo;
int boardid;
String boardname,username,sel;
out.write("\r\n");
out.write("<html>\r\n");
out.write("\r\n");
out.write("<head>\r\n");
out.write("<style type=\"text/css\">\r\n");
out.write("<!--\r\n");
out.write(".header {font: 11px Tahoma, Verdana; color: #000000; font-weight: bold; background-color: #99CC66 }\r\n");
out.write(".maintable {width: 100%; background-color: #EFFFCE }\r\n");
out.write(".tableborder {background: #D6E0EF; border: 1px solid #000000 }\r\n");
out.write("-->\r\n");
out.write("</style>\r\n");
out.write("<meta http-equiv=\"Content-Language\" content=\"zh-cn\">\r\n");
out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
out.write("<meta name=\"GENERATOR\" content=\"Microsoft FrontPage 4.0\">\r\n");
out.write("<meta name=\"ProgId\" content=\"FrontPage.Editor.Document\">\r\n");
out.write("<title>New Page 1</title>\r\n");
out.write("<link rel=\"stylesheet\" type=\"text/css\" href=\"bbs03.css\">\r\n");
out.write("</head>\r\n");
out.write("\r\n");
out.write("<body>\r\n");
out.write("<div class=\"maintable\">\r\n");
out.write(" <table cellspacing=\"1\" cellpadding=\"4\" width=\"751\" align=\"center\" class=\"tableborder\">\r\n");
out.write(" <tr class=\"header\">\r\n");
out.write(" <td height=\"58\"><h1><div align=\"center\">BBS</div></h1></td>\r\n");
out.write(" </tr>\r\n");
out.write(" </table>\r\n");
out.write("</div>\r\n");
out.write("\r\n");
out.write("<div align=\"center\">\r\n");
out.write(" <center>\r\n");
out.write(" <table bgcolor=\"#EFFFCE\" border=\"1\" width=\"751\">\r\n");
out.write(" <tr>\r\n");
out.write(" <td width=\"100%\" align=\"center\"><b>贴子查询</b></td>\r\n");
out.write(" </tr>\r\n");
out.write(" \r\n");
out.write(" <tr>\r\n");
out.write(" <td width=\"100%\" align=\"left\">\r\n");
out.write(" <form method=\"POST\" action=\"bbslist.jsp\" target=\"rtop\">\r\n");
out.write(" <p>主 题：<input type=\"text\" name=\"par\" size=\"20\"> \r\n");
out.write(" <select size=\"1\" name=\"boardid\"> \r\n");
sqlRst=board.listBoard(1);
i=1;
out.write(" \r\n");
while (sqlRst.next()) {
if (i==1) {
sel="selected";
}
else{
sel="";
}
boardid=sqlRst.getInt("boardid");
boardname=sqlRst.getString("boardname");
out.write(" \r\n");
out.write(" \r\n");
out.write(" <option value=\"");
out.print(boardid);
out.write('"');
out.write(' ');
out.print(sel);
out.write('>');
out.print(boardname);
out.write("</option> \r\n");
i++;
} //end while
sqlRst.close();
out.write(" </select> <input class=\"buttonface\" type=\"submit\" value=\"查询\" name=\"B1\"></p> \r\n");
out.write(" <input type=\"hidden\" name=\"method\" value=\"1\"> \r\n");
out.write(" </form> \r\n");
out.write(" </td> \r\n");
out.write(" </tr> \r\n");
out.write(" <tr> \r\n");
out.write(" <td width=\"100%\" align=\"left\"> \r\n");
out.write(" <form method=\"POST\" action=\"bbslist.jsp\" target=\"rtop\"> \r\n");
out.write(" <p>发表人：<select size=\"1\" name=\"par\"> \r\n");
//'=================
sqlRst=user.listUser(1);
i=1;
while (sqlRst.next()) {
if (i==1) {
sel="selected";
}
else {
sel="";
}
username=sqlRst.getString("username");
out.write(" \r\n");
out.write(" <option value=\"");
out.print(username);
out.write('"');
out.write(' ');
out.print(sel);
out.write('>');
out.print(username);
out.write("</option> \r\n");
i++;
} //end while
sqlRst.close();
//'=================
out.write(" \r\n");
out.write(" </select> \r\n");
out.write(" <select size=\"1\" name=\"boardid\"> \r\n");
i=1;
sqlRst=board.listBoard(1);
while (sqlRst.next()) {
if (i==1) {
sel="selected";
}
else {
sel="";
}
tempSTR=sqlRst.getString("boardid");
boardid=java.lang.Integer.parseInt(tempSTR);
boardname=sqlRst.getString("boardname");
out.write(" \r\n");
out.write(" <option value=\"");
out.print(boardid);
out.write('"');
out.write(' ');
out.print(sel);
out.write('>');
out.print(boardname);
out.write("</option> \r\n");
i++;
} //'end while
sqlRst.close();
out.write(" \r\n");
out.write(" </select> \r\n");
out.write(" <input class=\"buttonface\" type=\"submit\" value=\"查询\" name=\"B1\"></p> \r\n");
out.write(" <input type=\"hidden\" name=\"method\" value=\"2\"> \r\n");
out.write(" </form> \r\n");
out.write(" </td> \r\n");
out.write(" </tr> \r\n");
out.write(" <tr> \r\n");
out.write(" <td width=\"100%\" align=\"left\"> \r\n");
out.write(" <form method=\"POST\" action=\"bbslist.jsp\" target=\"rtop\"> \r\n");
out.write(" <p>时 间：<select size=\"1\" name=\"par\"> \r\n");
out.write(" <option value=\"");
//=date()-1
out.write("\" selected>一天内的贴子</option> \r\n");
out.write(" <option value=\"");
//=date()-3
out.write("\">三天内的贴子</option> \r\n");
out.write(" <option value=\"");
//=date()-5
out.write("\">五天内的贴子</option> \r\n");
out.write(" <option value=\"");
//=date()-7
out.write("\">一周内的贴子</option> \r\n");
out.write(" <option value=\"");
//=date()-30
out.write("\">一月内的贴子</option> \r\n");
out.write(" <option value=\"");
//=date()-90
out.write("\">三个月内的贴子</option> \r\n");
out.write(" </select> <select size=\"1\" name=\"boardid\"> \r\n");
sqlRst=board.listBoard(1);
while (sqlRst.next()) {
if (i==1) {
sel="selected";
}
else {
sel="";
}
tempSTR=sqlRst.getString("boardid");
boardid=java.lang.Integer.parseInt(tempSTR);
boardname=sqlRst.getString("boardname");
out.write(" \r\n");
out.write(" <option value=\"");
out.print(boardid);
out.write('"');
out.write(' ');
out.print(sel);
out.write('>');
out.print(boardname);
out.write("</option> \r\n");
i++;
} //end while
sqlRst.close();
out.write(" \r\n");
out.write(" </select> <input class=\"buttonface\" type=\"submit\" value=\"查询\" name=\"B1\"></p> \r\n");
out.write(" <input type=\"hidden\" name=\"method\" value=\"3\"> \r\n");
out.write(" </form> \r\n");
out.write(" </td> \r\n");
out.write(" </tr> \r\n");
out.write(" <tr> \r\n");
out.write(" <td width=\"100%\" align=\"left\"> \r\n");
out.write(" <form method=\"POST\" action=\"bbslist.jsp\" target=\"rtop\"> \r\n");
out.write(" <p>精华贴 <select size=\"1\" name=\"boardid\"> \r\n");
sqlRst=board.listBoard(1);
while (sqlRst.next()) {
if (i==1) {
sel="selected";
}
else {
sel="";
}
tempSTR=sqlRst.getString("boardid");
boardid=java.lang.Integer.parseInt(tempSTR);
boardname=sqlRst.getString("boardname");
out.write(" \r\n");
out.write("\r\n");
out.write(" <option value=\"");
out.print(boardid);
out.write('"');
out.write(' ');
out.print(sel);
out.write('>');
out.print(boardname);
out.write("</option> \r\n");
i++;
} //end while
sqlRst.close();
out.write(" \r\n");
out.write(" </select><input class=\"buttonface\" type=\"submit\" value=\"查询\" name=\"B1\"></p> \r\n");
out.write(" <input type=\"hidden\" name=\"method\" value=\"4\"> \r\n");
out.write(" </form> \r\n");
out.write(" </td> \r\n");
out.write(" </tr> \r\n");
out.write(" </table> \r\n");
out.write(" </center> \r\n");
out.write("</div> \r\n");
out.write("</body> \r\n");
out.write("</html> \r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -