📄 commentone.jsp

📁 有完整的毕业设计所需的文件和代码没什么说的了

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>评论</title>
</head>

<body>

<table width="99%" border="0" cellspacing="0" cellpadding="0" height="28" background="images/yingshi_bg4.gif" class="text6" style="border-right-width:1px;border-right-color:#B3B3B3;border-right-style:solid">
          <tr>
            <td class="text6">&nbsp;用户评论</td>
            <td class="text6" align="right"><a href="comment.asp?id=<%=productid%>"><b>发表评论</b></a>&nbsp;&nbsp;</td>
          </tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="text6" bgcolor="#ffEcff">
		<tr>
			<td colspan="3" style="padding-left:20px;padding-right:5px">
					评论
         </td>
         <td width="60"> 时间 </td>
         <td  width="45">用户 </td>
		</tr>
</table>		
<%
	 dim dbc,rs,query
	 shopopendatabase dbc
    query =  "select TOP 10 * from comment where  productid = " & productid & " order by lasttime desc"
    set rs = dbc.execute(query)
    dim content,ptime,pren,preply
    dim n
    n=0
    Do WHILE not rs.EOF and n<10
		content= rs("comment")	
		ptime = rs("lasttime")	
		pren = rs("nickname")	
		preply = rs("reply")	
		n=n+1
%>
   <table width="100%" border="0" cellpadding="0" cellspacing="0" class="text6">
		<tr>
			<td style="padding-left:20px;padding-right:5px">
			&nbsp;&nbsp;<%=content%>
         </td>
         <td width="60"> <%=ptime%> </td>
         <td  width="45"> <%=pren%> </td>
		</tr>
<%	  	
	if (preply<>"") then  	
%>
		<tr>
	   	<td style="padding-left:20px;padding-right:5px">
	   	&nbsp;&nbsp;<font color=red>答复：</font><%=preply %>
	   	</td>
	   	<td width="60">
	   	</td>
	   	<td width="45">
	   	</td>
	  	</tr>
<%	
	end if
%>
		<tr>
	   	<td colspan="3" background='images/topbg.gif' height=3></td>
	  	</tr>
	</table>
<%		
		rs.movenext    		
    Loop
    closerecordset rs
    shopclosedatabase dbc
%>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -