?? topiclist.jsp
字號:
<%@ page contentType="text/html; charset=gb2312"
language="java"
import = "java.util.*, java.text.*"
import = "java.sql.*,MyBean.dbcon"
%>
<%
dbcon dbc=new dbcon();
dbcon dbc1=new dbcon();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="Style.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
}
-->
</style>
</head>
<body>
<form name=form method=post action="topiclist.jsp">
<div align="center">關(guān)鍵詞:
<input type=text size=12 name=key>
<input type=submit name=submit value="查詢">
</div>
</form>
<%
String s=(String)session.getAttribute("userq");
String key=request.getParameter("key");
if("1".equals(s))
{
%>
<a href="issuetopic.jsp">我要提問</a>
<%
}
%>
<table width="99%" border="1" align="center" cellpadding="2" bordercolor="#C0C0C0" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" bgcolor="#EEEEEE">
<tr height=22>
<td width="40%" align=center>問題主題</td>
<td width="15%" align=center>提問人</td>
<td width="15%" align=center>提問日期</td>
<td width="15%" align=center>回答狀態(tài)</td>
<td width="15%" align=center>操作</td>
</tr>
<%
String topicid="";
if(key==null)
{
String strSQL=" ";
ResultSet rs=dbc.executeQuery("select * from topicinfo"
+ " order by topictime desc ");
while(rs.next())
{
topicid=rs.getString("topicid");
out.println("<tr height=22>");
out.println("<td>"+rs.getString("topictitle")+"</td>");
out.println("<td align=center>"+rs.getString("topicuserid")+"</td>");
out.println("<td align=center>"+rs.getString("topictime")+"</td>");
out.println("<td align=center>"+rs.getString("topicflag")+"</td>");
if("3".equals(s))
{out.println("<td align=center><a href=topicdetail.jsp?topicid="
+topicid+">查看</a><a href=dele.jsp?topicid="+topicid+"> 刪除</a></td></tr>");}
else{
out.println("<td align=center><a href=topicdetail.jsp?topicid="
+topicid+">查看</a></td></tr>");}
}
}
else
{
ResultSet rs1=dbc1.executeQuery("select * from topicinfo where topictitle like '"+key+"'");
if(rs1.next())
{
topicid=rs1.getString("topicid");
out.println("<tr height=22>");
out.println("<td>"+rs1.getString("topictitle")+"</td>");
out.println("<td align=center>"+rs1.getString("topicuserid")+"</td>");
out.println("<td align=center>"+rs1.getString("topictime")+"</td>");
if("3".equals(s))
{out.println("<td align=center><a href=topicdetail.jsp?topicid="
+topicid+">查看</a><a href=dele.jsp?topicid="+topicid+"> 刪除</a></td></tr>");}
else{
out.println("<td align=center><a href=topicdetail.jsp?topicid="
+topicid+">查看</a></td></tr>");}
}
else
{out.println("<tr height=22>");
out.println("<td>"+"沒有找到你需要的問題"+"</td>"+"</tr>");}
}
%>
</table></td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -