?? query.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="incdb.jsp"%>
<jsp:useBean id="user" class="test.bbsuser" scope="page"/>
<jsp:useBean id="board" class="test.bbsboard" scope="page"/>
<%
java.sql.ResultSet sqlRst; //'ADODB RECORDSE 對象
int i,method;
String tempSTR,strSQL,whereTo;
int boardid;
String boardname,username,sel;
%>
<html>
<head>
<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 align="center">
<center>
<table border="0" width="500">
<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>主 題：<input type="text" name="par" size="20">
<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();
%> </select> <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> <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>時 間：<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> <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="3">
</form>
</td>
</tr>
<tr>
<td width="100%" align="left">
<form method="POST" action="bbslist.jsp" target="rtop">
<p>精華貼 <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 + -