?? show.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*" errorPage=""%>
<%!public String getStr(String s) {
String str = s;
try {
byte b[] = str.getBytes("ISO-8859-1");
str = new String(b);
return str;
} catch (Exception e) {
return null;
}
}
public String[] split(String str, String div) {
int arr = 0, index, indexto, d_length = div.length();
if (str.compareTo("") != 0) {
if (str.indexOf(div) > -1) {
index = str.indexOf(div);
for (int i = 1;; i++) {
if (str.indexOf(div, index + d_length) > -1) {
arr = i;
index = str.indexOf(div, index + d_length);
} else {
arr += 2;
break;
}
}
} else
arr = 1;
} else
arr = 0;
String[] restr = new String[arr];
if (str.compareTo("") != 0) {
if (str.indexOf(div) > -1) {
index = str.indexOf(div);
restr[0] = str.substring(0, index);
for (int j = 1;; j++) {
if (str.indexOf(div, index + d_length) > -1) {
indexto = str.indexOf(div, index + d_length);
restr[j] = str.substring(index + d_length, indexto);
index = str.indexOf(div, index + d_length);
} else {
restr[j] = str
.substring(index + d_length, str.length());
break;
}
}
} else {
restr[0] = str;
return restr;
}
} else {
return restr;
}
return restr;
}
public String donull(String str) {
String restr = null;
if (str == null)
restr = "";
else
restr = str;
return restr;
}
public Object donull(Object obj) {
Object reobj = null;
if (obj == null)
reobj = (Object) ("");
else
reobj = obj;
return reobj;
}
public String replace(String str, String oldstr, String newstr) {
String[] strarr = split(str, oldstr);
String restr = null;
if (strarr.length > 0) {
restr = strarr[0];
for (int i = 1; i < strarr.length; i++) {
restr = donull(restr) + newstr + strarr[i];
}
}
return donull(restr);
}
public String dohtm1(String txt) {
if (txt != null) {
txt = replace(txt, "&", "&");
txt = replace(txt, "<", "<");
txt = replace(txt, ">", ">");
txt = replace(txt, " ", " ");
txt = "<p>" + txt + "</p>";
txt = replace(txt, "\n", "</p><p>");
}
return txt;
}
public String dohtm2(String txt) {
if (txt != null) {
txt = replace(txt, " ", " ");
txt = "<p>" + txt + "</p>";
txt = replace(txt, "\n", "</p><p>");
}
return txt;
}%>
<%
String id = (String) request.getParameter("id");
String host = "localhost";
String user = "root";
String pw = "123";
String db = "numb1";
String pass = null;
pass = (String) session.getAttribute("pass");
int alt;
if (id == null) {
id = "0";
} else {
for (int i = 0; i < id.length(); i++) {
alt = id.charAt(i);
if (alt < 48 || alt > 57) {
id = "0";
break;
}
}
}
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url = "jdbc:mysql://" + host + "/" + db;
Connection con = DriverManager.getConnection(url, user, pw);
Statement st = con.createStatement();
String sql = "select*from lyb where id=" + id;
ResultSet numb1 = st.executeQuery(sql);
numb1.next();
if (numb1.getRow() == 0) {
out.print("<font color=#FF0000><h3>參數有誤，或該留言已被刪除</h3></font>");
} else {
%>
<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}
p{text-indent:18pt;font-size:14px}
td{font-size:14px}
th{font-size:16px}
a:link{text-decoration:none;color:#0000ff}
a:visited{text-decoration:none;color:#0000ff}
a:hover{text-decoration:underline;color:#ff0000}
.l {font-size:13px}
.l a:link{text-decoration:none;color:#0000ff}
.l a:visited{text-decoration:none;color:#0000ff}
.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/title.jpg" width="778" height="80">
</td>
</tr>
<tr>
<td>
<hr>
</td>
</tr>
<tr>
<td class="l">
首頁 >
<a href="index.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/back1.jpg" width="69"
height="20" border="0"
onMouseOut="this.src='img/back1.jpg'"
onMouseOver="this.src='img/back2.jpg'">
</a>
<%
if ("y".equals(pass)) {
%>
<a href="drop.jsp?id=<%=id%>"><img src="img/del1.jpg"
width="76" height="21" border="0"
onMouseOver="this.src='img/del2.jpg'"
onMouseOut="this.src='img/del1.jpg'">
</a>
<%
} else {
%>
<a href="send.jsp"><img src="img/send1.jpg" width="77"
height="21" border="0"
onMouseOut="this.src='img/send1.jpg'"
onMouseOver="this.src='img/send2.jpg'">
</a>
<a href="login.jsp?id=<%=id%>"><img src="img/admin1.jpg"
width="77" height="21" border="0"
onMouseOut="this.src='img/admin1.jpg'"
onMouseOver="this.src='img/admin2.jpg'">
</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"><%=getStr(numb1.getString(2))%>
</span>
</td>
<td width="60%">
<div align="right">
<span class="style2"><%=getStr(numb1.getString(3))%>
發表于：<%
String tim = getStr(numb1.getString(8));
out.print(tim.substring(0, 19));
%> IP地址：<%
if ("y".equals(pass)) {
out.print(numb1.getString(7));
} else {
String str = numb1.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%">
<%
if (numb1.getString(5).compareTo("") != 0) {
out.print("<a href=" + numb1.getString(5)
+ " target=_blank>" + getStr(numb1.getString(5))
+ "</a>");
}
%>
</td>
<td width="9%">
<div align="right">
Q Q：
</div>
</td>
<td width="19%">
<%=getStr(numb1.getString(6))%>
</td>
<td width="13%">
<div align="right">
E-mail：
</div>
</td>
<td width="19%">
<%
if (numb1.getString(4).compareTo("") != 0) {
out.print("<a href=mailto:" + numb1.getString(4) + ">"
+ getStr(numb1.getString(4)) + "</a>");
}
%>
</td>
</tr>
</table>
</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>
<%=dohtm1(getStr(numb1.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>
<%=dohtm2(getStr(numb1.getString(10)))%>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<%
if ("y".equals(pass)) {
%>
<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">
<br>
<textarea name="text" cols="103" 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/ok1.jpg"
width="69" height="20" border="0"
onMouseOut="this.src='img/ok1.jpg'"
onMouseOver="this.src='img/ok2.jpg'">
<input name="id" type="hidden" id="id" value="<%=id%>">
<img src="img/back1.jpg" width="69" height="20" border="0"
onMouseOver="this.src='img/back2.jpg'"
onMouseOut="this.src='img/back1.jpg'">
</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">
歡迎進入本站留言板
<font color="#ffffff">版權所有 © 2004-2005</font>
</div>
</td>
</tr>
</table>
</body>
</html>
<%
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -