📄 add.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<jsp:useBean id="DBConnection" scope="page" class="com.guestbook.DBConnection"/>
<jsp:useBean id="FaceFilter" scope="page" class="com.guestbook.FaceFilter"/>
<jsp:useBean id="HTMLFilter" scope="page" class="com.guestbook.HTMLFilter"/>
<jsp:useBean id="UbbCode" scope="page" class="com.guestbook.UbbCode"/>
<%
Boolean a=(Boolean)session.getAttribute("a");
Connection conn=DBConnection.getConnectionToAccess(application.getRealPath("/data/guestbook.mdb"));
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String action=request.getParameter("action");
if (action==null)
{
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>时空留言本v2.0-我要留言</title>
<style type="text/css">
<!--
body {
border: 1px 1 #CCCCCC;
}
.bian {
border-top-width: 1px;
border-top-style: solid;
border-top-color: #969696;
border-bottom-width: 1px;
border-bottom-style: solid;
border-bottom-color: #999999;
}
.f12 {
font-family: "宋体";
font-size: 12px;
color: #000000;
text-decoration: none;
line-height: 23px;
}
.bian1 {
border-right-width: 1px;
border-left-width: 1px;
border-right-style: solid;
border-left-style: solid;
border-right-color: #969696;
border-left-color: #969696;
}
a:link {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: none;
}
a:visited {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: none;
}
a:hover {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: underline;
}
a:active {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: none;
}
-->
</style>
<script language="javascript">
function checks(){
if(post1.password.value==""){
alert("请输入管理员密码");
return false;
}
if(post1.password.value.length>20){
alert("管理员密码不超过20位");
return false;
}
return true;
}
</script>
<script language="javascript">
function check(){
if(post.username.value==""){
alert("请输入您的称呼");
return false;
}
if(post.username.value.length>20){
alert("您的称呼不超过20位");
return false;
}
if(post.userurl.value!=""){
if(post.userurl.value.length>50){
alert("个人主页位数不超过24");
return false;
}
}
if(post.usermail.value==""){
alert("请输入您的邮件");
return false;
}
if(post.usermail.value!=""){
if(post.usermail.value.length>50){
alert("邮件位数不超过20");
return false;
}
if(post.usermail.value.indexOf("@") == -1){
alert("没有\"@\"符号，不是个有效的邮件地址");
return false;
}
else if(post.usermail.value.indexOf(".") == -1){
alert("没有\".\"符号，不是个有效的邮件地址");
return false;
}
}
if(post.userqq.value!=""){
if(post.userqq.value.length>9){
alert("QQ位数不超过9");
return false;
}
}
if(post.usertitle.value==""){
alert("请输入标题");
return false;
}
if(post.usertitle.value.length>40){
alert("标题不超过40位");
return false;
}
if(post.content.value==""){
alert("请输入正文");
return false;
}
if(post.content.value.length>60000){
alert("正文不超过60000位");
return false;
}
return true;
}
</script>
<SCRIPT src="images/index.js"></SCRIPT>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="20%"><img src="images/images/logo.gif" width="150" height="45"></td>
<td width="80%" style="FILTER: progid:DXImageTransform.Microsoft.Gradient(startColorStr='#FFFFFF', endColorStr='#5581D2', gradientType='1'; BORDER-BOTTOM: #969696 1px solid"> </td>
</tr>
</table>
<table width="100%" border="0" cellpadding="3" cellspacing="3" class="bian">
<form action="loginpost.jsp" method="post" name="post1" id="post1" onsubmit="return checks();">
<tr>
<td>
<%
//读管理员信息
String sql1="select * from admin where id=1";
ResultSet Rs1=stmt.executeQuery(sql1);
while(Rs1.next())
{
%>
<span class="f12">┃<font color="#333333"><a href="<%=Rs1.getString("url")%>" target="_blank">欢迎光临<strong><font face="Arial, Helvetica, sans-serif"> <%=Rs1.getString("site")%></font></strong></a>┃你的IP是<strong><font face="Arial, Helvetica, sans-serif"><%= request.getRemoteAddr() %></font></strong>┃
<%
if(a==null||a.booleanValue()==false)
{
%>
管理员：<strong><a href="mailto:<%=Rs1.getString("email")%>"><font face="Arial, Helvetica, sans-serif"><%=Rs1.getString("admin")%></font></a></strong>
密码 ：</font> </span><font color="#333333">
<input name='password' type="password" class="f12" id="adminpass" size="8">
<span class="f12">
<input name="submit2" type="submit" value="管理登陆">
</span></font><span class="f12"><font color="#333333">
<%}else{%>
</font> ┃<font color="#333333"><a href="index.jsp">管理留言</a></font>┃<font color="#333333"><a href="admin.jsp">设置留言本</a></font>┃<a href="logout.jsp">退出登陆</a>┃ </span>
<%}
//结束读管理员信息
}
Rs1.close();
%>
</td>
</tr>
</form>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="bian1">
<tr>
<td style="border-right: 1px solid #969696" vAlign=top width=100
bgColor=#f1f1f1 height="396" >
<TABLE width="100%" height="135" border=0 cellPadding=5 cellSpacing=0
borderColor=#111111 class="f12" id=AutoNumber1 style="BORDER-COLLAPSE: collapse">
<TBODY>
<TR>
<TD width="100%" height="46" align=right bgColor=#f1f1f1> </TD>
</TR>
<TR>
<TD id=menu1 onmouseover="document.all.menu1.bgColor='#5581D2'"
onmouseout="document.all.menu1.bgColor='#F1F1F1'" align=right width="100%" height=15><B><a href="index.jsp">查看留言</a></B></TD>
</TR>
<TR>
<TD id=menu2 width="100%" height=15 align=right bgcolor="#5581d2" ><B><a href="add.jsp">写留言</a></B></TD>
</TR>
<TR>
<TD id=menu3 onmouseover="document.all.menu3.bgColor='#5581D2'"
onmouseout="document.all.menu3.bgColor='#F1F1F1'" align=right
width="100%" height=15><B><a href="search.jsp">搜索留言</a></B></TD>
</TR>
<TR>
<TD id=menu4 onmouseover="document.all.menu4.bgColor='#5581D2'"
onmouseout="document.all.menu4.bgColor='#F1F1F1'" align=right
width="100%" height=2><B><a href="help.jsp">帮助</a></B></TD>
</TR>
</TBODY>
</TABLE>
</td>
<td valign="top" class="f12"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="5581d2">
<tr>
<td width="50%"><img src="images/images/page_new.gif" width="400" height="46"></td>
<td width="50%"><div align="right"><img src="images/images/pagetitle2_.gif" width="185" height="46"></div></td>
</tr>
</table>
<form action="add.jsp?action=add" method="post" name="post" id="post" onsubmit="return check();">
<DIV align=center>
<TABLE width="88%" border="0" align=center cellpadding="2" cellspacing="2" class="f12">
<TBODY>
<TR>
<TD><FONT
color=red><B>您的留言只有通过我们查看后才会显示，所以请不要重复提交您的留言，谢谢合作</B></FONT></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width="95%" align=center
cellPadding=3 cellSpacing=1 bgcolor="#969696" class=f12 style="WORD-BREAK: break-all">
<TR bgcolor="#FFFFFF">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -