📄 query.jsp

📁 论坛源码
💻 JSP
字号:
<!--帖子查询-->
<%@page pageEncoding="GB2312"%>
<%@page contentType="text/html; charset=gb2312"%>
<%request.setCharacterEncoding("GB2312");%>

<%@ include file="incdb.jsp"%>
<jsp:useBean id="user" class="twm.bbsuser" scope="page"/>
<jsp:useBean id="board" class="twm.bbsboard" scope="page"/>

<%
java.sql.ResultSet sqlRst;				   //'ADODB RECORDSE 对象
int i,method;
String tempSTR,strSQL,whereTo;

int boardid;
String boardname,username,sel;
%>
<html>

<head>
<style type="text/css">
<!--
.header {font: 11px Tahoma, Verdana; color: #000000; font-weight: bold; background-color: #99CC66 }
.maintable {width: 100%; background-color: #EFFFCE }
.tableborder {background: #D6E0EF; border: 1px solid #000000 }
-->
</style>
<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>New Page 1</title>
<link rel="stylesheet" type="text/css" href="bbs03.css">
</head>

<body>
<div class="maintable">
  <table cellspacing="1" cellpadding="4" width="751" align="center" class="tableborder">
    <tr class="header">
      <td height="58"><h1><div align="center">BBS</div></h1></td>
    </tr>
  </table>
</div>

<div align="center">
  <center>
  <table  bgcolor="#EFFFCE" border="1" width="751">
    <tr>
      <td width="100%" align="center"><b>贴子查询</b></td>
    </tr>
    
    <tr>
      <td width="100%" align="left">
        <form method="POST" action="bbslist.jsp" target="rtop">
          <p>主&nbsp; 题：<input type="text" name="par" size="20">&nbsp;      
          <select size="1" name="boardid">             
<%            
sqlRst=board.listBoard(1);
i=1;
%>            
<%
while (sqlRst.next()) {

if (i==1) { 
  sel="selected";
}
else{            
  sel="";
}
boardid=sqlRst.getInt("boardid");
boardname=sqlRst.getString("boardname");
%>             
           
          <option value="<%=boardid%>" <%=sel%>><%=boardname%></option>             
<%           
i++;           
}  //end while
sqlRst.close();
%> &nbsp; </select>&nbsp; <input class="buttonface" type="submit" value="查询" name="B1"></p>              
          <input type="hidden" name="method" value="1">             
        </form>             
      </td>             
    </tr>             
    <tr>             
      <td width="100%" align="left">             
        <form method="POST" action="bbslist.jsp" target="rtop">             
          <p>发表人：<select size="1" name="par">  
<%
//'================= 
sqlRst=user.listUser(1);
i=1;
while (sqlRst.next()) {

if (i==1) {  
  sel="selected";             
}
else {             
  sel="";            
}
username=sqlRst.getString("username");
%>                           
                <option value="<%=username%>" <%=sel%>><%=username%></option>             
<%            
i++;
}  //end while
sqlRst.close();
//'================= 
%>             
   </select> 
           <select size="1" name="boardid">             
<% 
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");
%>            
          <option value="<%=boardid%>" <%=sel%>><%=boardname%></option>            
<%          
i++;
}  //'end while
sqlRst.close();

%>           
   </select>&nbsp; 
 <input class="buttonface" type="submit" value="查询" name="B1"></p>              
 <input type="hidden" name="method" value="2">             
        </form>             
      </td>             
    </tr>             
    <tr>             
      <td width="100%" align="left">             
        <form method="POST" action="bbslist.jsp" target="rtop">             
          <p>时&nbsp; 间：<select size="1" name="par">      
            <option value="<%//=date()-1%>" selected>一天内的贴子</option>     
            <option value="<%//=date()-3%>">三天内的贴子</option>     
            <option value="<%//=date()-5%>">五天内的贴子</option>     
            <option value="<%//=date()-7%>">一周内的贴子</option>     
            <option value="<%//=date()-30%>">一月内的贴子</option>     
            <option value="<%//=date()-90%>">三个月内的贴子</option>     
          </select>&nbsp; <select size="1" name="boardid">         
<%
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");
%>        
          <option value="<%=boardid%>" <%=sel%>><%=boardname%></option>        
<%      
i++;      
} //end while
sqlRst.close();

%>       
          </select>&nbsp; <input class="buttonface" type="submit" value="查询" name="B1"></p>            
          <input type="hidden" name="method" value="3">             
        </form>             
      </td>             
    </tr>             
    <tr>             
      <td width="100%" align="left">             
        <form method="POST" action="bbslist.jsp" target="rtop">  
        <p>精华贴&nbsp; <select size="1" name="boardid">         
<%
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");
%>        

          <option value="<%=boardid%>" <%=sel%>><%=boardname%></option>        
<%      
i++;
} //end while
sqlRst.close();
%>       
          </select><input class="buttonface" type="submit" value="查询" name="B1"></p> 
          <input type="hidden" name="method" value="4">           
        </form> 
      </td>         
    </tr>         
  </table>         
  </center>         
</div>         
</body>         
</html>
⌨️ 快捷键说明

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