?? query_jsp.java

?? 論壇源碼
?? 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("<!--?aê?μ?è?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>主&nbsp; 題：<input type=\"text\" name=\"par\" size=\"20\">&nbsp;      \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(" &nbsp; </select>&nbsp; <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>發(fā)表人：<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>&nbsp; \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>時&nbsp; 間：<select size=\"1\" name=\"par\">      \r\n");
      out.write("            <option value=\"");
//=date()-1
      out.write("\" selected>一天內(nèi)的貼子</option>     \r\n");
      out.write("            <option value=\"");
//=date()-3
      out.write("\">三天內(nèi)的貼子</option>     \r\n");
      out.write("            <option value=\"");
//=date()-5
      out.write("\">五天內(nèi)的貼子</option>     \r\n");
      out.write("            <option value=\"");
//=date()-7
      out.write("\">一周內(nèi)的貼子</option>     \r\n");
      out.write("            <option value=\"");
//=date()-30
      out.write("\">一月內(nèi)的貼子</option>     \r\n");
      out.write("            <option value=\"");
//=date()-90
      out.write("\">三個月內(nèi)的貼子</option>     \r\n");
      out.write("          </select>&nbsp; <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>&nbsp; <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>精華貼&nbsp; <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);
    }
  }
}
?? 文件大小 477 K
?? 上傳用戶 wjm197811
?? 所屬分類 Jsp/Servlet
??? 相關標簽

#論壇 #源碼
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? query_jsp.java

?? 快捷鍵說明
