?? main.jsp
字號:
<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="str" scope="page" class="test.str_filter"/>
<jsp:useBean id="data" scope="session" class="sql.faq"/>
<%
String s_pages=request.getParameter("page"),sql;
if(s_pages==null){
s_pages="0";
}
int pages=Integer.parseInt(s_pages);
if(pages<0) pages=0;
Statement stmt=data.getStatement();
stmt.setMaxRows(8);
int nextpage=pages*8;
sql="select * from faqs where id>"+nextpage
+" and pid=0 ";
ResultSet rs=data.executeQuery(sql);
%>
<html>
<head>
<title>在線問答系統</title>
</head>
<body>
<center>
<h1>在線問答系統 </h1>
<hr size="3">
<table width="80%" border="1" align="center">
<tr>
<td width="9%">記錄號</td>
<td width="40%">問題</td>
<td width="10%">點擊數</td>
<td width="14%">回答人數</td>
<td width="27%">日期</td>
</tr>
<%int count=0;
while(rs.next()){%>
<tr>
<td width="9%"><%=rs.getInt(1)%></td>
<td width="40%">
<a href="show.jsp?id=<%=rs.getInt(1)%>">
<%=str.strtochn(rs.getString(3))%>
</a>
</td>
<td width="10%"><%=rs.getInt("click")%></td>
<td width="14%"><%=rs.getInt("answer")%></td>
<td width="27%"><%=rs.getTimestamp("qdate")%></td>
</tr>
<%count++;
}
%>
</table>
<hr>
<a href="main.jsp?page=<%=pages-1%>">上一頁</a>
<%if(count==8){%>
<a href="main.jsp?page=<%=pages+1%>">下一頁</a>
<%}
rs.close();
%>
<p><a href="add.jsp">增加問題</a>
<a href="login.jsp">管理員登陸</a>
</center>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -