?? show.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"/>
<html>
<head>
<title>查看問題表單</title>
</head>
<body>
<%
String id=request.getParameter("id");
String sql="select * from faqs where id ="+id;
ResultSet rs = data.executeQuery(sql);
int click=rs.getInt("click")+1;
sql="update faqs set click="+click+" where id="+id;
data.executeUpdate(sql);
%>
<center>
<h1>查看問題界面</h1>
<hr>
<table width="80%" border="1">
<tr>
<td width="48%">問題:
<%String title=str.strtochn(rs.getString("qtitle"));
out.print(title);
%></td>
<td width="12%">點擊數(shù): <%=rs.getInt("click")%></td>
<td width="18%">回答的人數(shù): <%=rs.getInt("answer")%></td>
<td width="22%">日期: <%=rs.getTimestamp("qdate")%></td>
</tr>
<tr>
<td colspan="4">
<p>具體內容:</p>
<p><%=str.strtochn(rs.getString("content"))%></p>
</td>
</tr>
<%sql="select * from faqs where pid="+id+" order by qdate desc";
rs.close();
rs=data.executeQuery(sql);
while(rs.next()){
%>
<tr>
<td colspan="4">主題:<br>
<%=str.strtochn(rs.getString("qtitle"))%></td>
</tr>
<tr>
<td colspan="4"><p>具體內容:<br>
<%=str.strtochn(rs.getString("content"))%></p></td>
</tr>
<%}%>
</table>
<hr>
<%title="Re-->"+title;
%>
<form name="form1" method="post" action="reply.jsp?id=<%=id%>
&title=<%=title%>">
<p>請?zhí)钌夏膬热荩?lt;/p>
<p>
<textarea name="content" rows="8" cols="80"></textarea>
</p>
<p> </p>
<input type="submit" name="Submit" value=" 回 復 ">
<a href="main.jsp">返回主頁</a>
</form>
</center>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -