📄 guestone.jsp

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

💻 JSP

字号:

<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<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="guestcomment.jsp"><b>发表留言</b></a>&nbsp;&nbsp;</td>
          </tr>
</table>
<table width="99%" border="0" cellpadding="0" cellspacing="0" class="text6" bgcolor="#ffEcff">
		<tr>
			<td colspan="3" style="padding-left:20px;padding-right:5px">留言 </td>
            <td width="50"> &nbsp;时间 </td>
          <td  width="49">&nbsp;用户 </td>
  </tr>
</table>		
<%
	 dim dbc,rs,query
	 shopopendatabase dbc
    query =  "select TOP 20 * from comment where  productid = 30000 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="99%" border="0" cellpadding="0" cellspacing="0" class="text6">
		<tr>
			<td width="638" style="padding-left:20px;padding-right:5px">
			&nbsp;&nbsp;<%=content%>
         </td>
         <td width="61"> <%=ptime%> </td>
         <td  width="37"> <%=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="61">	   	</td>
	   	<td width="37">	   	</td>
	  	</tr>
<%	
	end if
%>
		<tr>
	   	<td colspan="3" background='images/topbg.gif' height=3></td>
	  	</tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -