📄 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 + -