?? 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="";
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="http://www.numb1.com" target="_blank">首頁</a> > <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%>">
<a href="http://www.numb1.com"><img src="img/back1.jpg" width="69" height="20" border="0" onMouseOver="this.src='img/back2.jpg'" onMouseOut="this.src='img/back1.jpg'"></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">歡迎進入本站留言板 <a href="http://www.numb1.com" target="_blank"><font color="#ffffff">版權所有 © 2004-2005</font></a></div></td>
</tr>
</table>
</body>
</html>
<%
}
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -