📄 show.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
String id=(String)request.getParameter("id");
String password="arthemis";//管理员密码
String mm=null;mm=(String)session.getAttribute("pass");
if(id==null){
out.print("<font color=#FF0000><h3>ERROR!</h3></font>");}else{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:numb1");//,"","");
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from lyb where id="+id;
ResultSet rs=st.executeQuery(sql);
rs.next();
%><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>留言内容</title>
<style type="text/css">
<!--
body {
background-image: url(img/bg.gif);
margin-top: 0px;
margin-bottom: 5px;
}
.style2 {color: #FFFFFF}
td{font-size:14px}
th{font-size:16px}
a:link{text-decoration:none;color:#006600}
a:visited{text-decoration:none;color:#006600}
a:hover{text-decoration:underline;color:#ff0000}
.l {font-size:13px}
.l a:link{text-decoration:none;color:#006600}
.l a:visited{text-decoration:none;color:#006600}
.l a:hover{text-decoration:none;color:#ff0000}
.style3 {color: #FF0000}
-->
</style>
</head>
<body>
<table width="780" border="0" align="center" cellspacing="0" bgcolor="#f8fff7">
<tr>
<td height="2"></td>
</tr>
<tr>
<td><img src="img/1.gif" width="778" height="80"></td>
</tr>
<tr>
<td><hr></td>
</tr>
<tr>
<td class="l"> <a href="login.jsp" target="_blank">首页</a> > <a href="login.jsp">留言列表</a> > <span class="style3">留言内容</span></td>
</tr>
<tr>
<td height="10"></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="1" bgcolor="#c1d1c1">
<tr>
<td bgcolor="#f8f8f8"><table width="100%" border="0" cellspacing="0">
<tr>
<td class="l"><div align="right"><a href="index.jsp"><img src="img/back.jpg" width="69" height="20" border="0"></a>
<% if(password.equals(mm)){%><a href="drop.jsp?id=<%=id%>"><img src="img/dell.jpg" width="76" height="21" border="0"></a>
<% }%> </div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="10"></td>
</tr>
</table>
<table width="780" border="0" align="center" bgcolor="#F8FFF7" style="BORDER-BOTTOM: #4F7B0D 1px solid; BORDER-LEFT: #4F7B0D 1px solid; BORDER-RIGHT: #4F7B0D 1px solid; BORDER-TOP: #4F7B0D 1px solid">
<tr>
<td height="20">
<table width="100%" border="0" cellspacing="1" bgcolor="#4F7B0D">
<tr>
<td width="40%"> <span class="style2"><%=rs.getString(2)%></span></td>
<td width="60%"><div align="right"><span class="style2"><%=rs.getString(3)%> 发表于：<%=rs.getString(8)%> IP地址：<% if(password.equals(mm)){out.print(rs.getString(7));}else{String str=rs.getString(7);int l=str.lastIndexOf(".");l++; String ip=str.substring(0,l);out.print(ip+"*");}%></span> </div></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#F8FFF7">
<td><div align="center">
<table width="100%" border="0" cellspacing="0">
<tr>
<td width="7%"><div align="right">网站：</div></td>
<td width="33%"><%=rs.getString(5)%></td>
<td width="9%"><div align="right">Q Q：</div></td>
<td width="19%"><%=rs.getString(6)%></td>
<td width="13%"><div align="right">E-mail：</div></td>
<td width="19%"><%=rs.getString(4)%></td>
</tr>
</table>
</div> <div align="center"></div> <div align="center"></div> <div align="center"></div> <div align="center"></div></td>
</tr>
<tr bgcolor="#F8FFF7">
<td height="1" background="img/b.gif"></td>
</tr>
<tr bgcolor="#F8FFF7">
<td><table width="97%" border="0" align="center" cellspacing="5">
<tr>
<td><%=rs.getString(9)%></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#F8FFF7">
<td><table width="98%" border="0" align="center" cellspacing="5">
<tr>
<td bgcolor="#d1e8c1"><table width="100%" border="0" cellspacing="8">
<tr>
<td><%=rs.getString(10)%></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<% if(password.equals(mm)){%>
<br><form name="form1" method="post" action="actre.jsp">
<table width="780" border="0" align="center" cellspacing="1" bgcolor="#4F7B0D">
<tr bgcolor="#EFF3E7">
<td><table width="100%" border="0" cellspacing="1">
<tr>
<th bgcolor="#4F7B0D"><span class="style2">回 复 留 言</span></th>
</tr>
</table></td>
</tr>
<tr bgcolor="#EFF3E7">
<td bgcolor="#EFF3E7"><div align="center">
<table width="100%" border="0" cellspacing="5">
<tr>
<td><div align="center">
<textarea name="text" cols="100" rows="8" id="text" style="BORDER: #4F7B0D 1px solid; background: #f8fff7;color: #4F7B0D; overflow:auto;"></textarea>
</div></td>
</tr>
<tr>
<th><input name="imageField" type="image" src="img/hf.jpg" width="69" height="20" border="0" >
<input name="id" type="hidden" id="id" value="<%=id%>">
<a href="http://www.numb1.com"><img src="img/main.jpg" width="69" height="20" border="0"></a></th>
</tr>
</table>
</div></td>
</tr>
</table>
</form><%}%>
<br>
<table width="780" border="0" align="center" cellspacing="1" bgcolor="#4F7B0D">
<tr>
<td bgcolor="#639A10" class="l"><div align="center" class="style2">
<DIV align="center">欢迎留下你宝贵的意见，以使本店提供更完善的服务 <A href="login.jsp" target="_blank">思捷网上商店 2008</A></DIV>
</div></td>
</tr>
</table>
</body>
</html>
<% }%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -