📄 topiclist.jsp

📁 一个　网上答疑系统　与大家分享　jsp+sql
💻 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">关键词:
	    <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>回答状态</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+">&nbsp删除</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+">&nbsp删除</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>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -