⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 topicdetail.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();
    String topicid=request.getParameter("topicid");
%>
<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>
<%
String s=(String)session.getAttribute("userq");
if("2".equals(s))
{%>
<a href="reply.jsp?topicid=<%=topicid%>">我要回答</a>
<%}
%>


<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td  valign="top" >
    <table width="99%" border="1" align="center" cellpadding="2" bordercolor="#C0C0C0" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" bgcolor="#EEEEEE">
    <%
         ResultSet topicrs=dbc.executeQuery("select * from topicinfo a,userinfo b "
		  	                             +" where a.topicuserid=b.userid"
		  	                             +" and topicid="+topicid);
		 topicrs.next();
		 String ttitle=topicrs.getString("topictitle");
		 String tuserid=topicrs.getString("topicuserid");
		 String tcontent=topicrs.getString("topiccontent");
		 String tname=topicrs.getString("username");
		 String tsay=topicrs.getString("usersay");
		 out.println("<tr><td>"
		            +ttitle+"<br><p>"
		            +tcontent+"<br>"
		            +"<p>提问人："+tuserid
		            +"<br>"+tsay+"</td></tr>");
		 
    %>
    </table>
	<table width="99%" border="1" align="center" cellpadding="2" bordercolor="#C0C0C0" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" bgcolor="#EEEEEE">
      <tr height=5>
	   
	  </tr>
	  <%
	  	
		   ResultSet replyrs=dbc.executeQuery("select * from replyinfo a,userinfo b "
		  	                             +" where topicid="+topicid
		  	                             +" and a.replyuseid=b.userid "
		  	                             +" order by replytime desc ");
             int i=0;
		     String ruserid;
		     String rcontent;
		     String rsay;
		     String rtime;
			 while(replyrs.next())
			 {
				i++;
				
				rtime=replyrs.getString("replytime");
				rcontent=replyrs.getString("replyContent");
				ruserid=replyrs.getString("userid");
				rsay=replyrs.getString("usersay");
				out.println("<tr><td>"
		            +rcontent+"<br><p>"
		            +rtime+"<br>"
		            +"老师："+ruserid
		            +"<br>"+rsay+"</td></tr>");
			}
		  %>
	  </table></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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