📄 admin.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<jsp:useBean id="DBConnection" scope="page" class="com.guestbook.DBConnection"/>
<%
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 admin=request.getParameter("admin");
if (admin==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.site.value==""){
alert("请输入网站名称");
return false;
}
if(post.site.value.length>20){
alert("您的网站名称不超过20位");
return false;
}
if(post.url.value==""){
alert("请输入网站地址");
return false;
}
if(post.url.value.length>50){
alert("网站地址位数不超过24");
return false;
}
if(post.admins.value==""){
alert("请输入管理员名称");
return false;
}
if(post.admins.value.length>50){
alert("管理员名称位数不超过24");
return false;
}
if(post.password.value==""){
alert("请输入管理员密码");
return false;
}
if(post.password.value.length>50){
alert("管理员密码位数不超过24");
return false;
}
if(post.password2.value==""){
alert("请输入重复密码");
return false;
}
if(post.password2.value.length>50){
alert("重复密码位数不超过24");
return false;
}
if(post.password.value!=post.password2.value){
alert("输入的两次密码不一致");
return false;
}
if(post.email.value==""){
alert("请输入您的邮件");
return false;
}
if(post.email.value!=""){
if(post.email.value.length>50){
alert("邮件位数不超过20");
return false;
}
if(post.email.value.indexOf("@") == -1){
alert("没有\"@\"符号，不是个有效的邮件地址");
return false;
}
else if(post.email.value.indexOf(".") == -1){
alert("没有\".\"符号，不是个有效的邮件地址");
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 onmouseover="document.all.menu2.bgColor='#5581D2'"
onmouseout="document.all.menu2.bgColor='#F1F1F1'" width="100%" height=15 align=right ><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_admin.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>
<%
String sql="select * from admin where id=1";
ResultSet Rs=stmt.executeQuery(sql);
while(Rs.next())
{
%>
<form action="admin.jsp?admin=admin" method="post" name="post" id="post" onsubmit="return check();">
<DIV align=center>
<TABLE width="95%" align=center
cellPadding=3 cellSpacing=1 bgcolor="#969696" class=f12 style="WORD-BREAK: break-all">
<TBODY>
<TR bgcolor="#FFFFFF">
<TD width="20%" height=19 align=right valign="top" bgcolor="#f1f1f1" class=tablebody3>网站名称：</TD>
<TD width="80%" height=19 bgcolor="#e1ebba" class=tablebody2>
<INPUT size=29
value="<%=Rs.getString("site")%>" name=site>
<br>
留言本所属的站点的名称（如：Jsp天空网）。 </TD>
</TR>
<TR bgcolor="#FFFFFF">
<TD width="20%"
height=19 align=right vAlign=top bgcolor="#f1f1f1" class=tablebody3>网站地址：</TD>
<TD width="80%" height=19 bgcolor="#e1ebba" class=tablebody2><INPUT size=29
value=<%=Rs.getString("url")%>
name=url>
<br>
如果要填写，应填写完整地址，如http://www.jspsky.com</TD>
</TR>
<TR bgcolor="#FFFFFF">
<TD width="20%" height=19 align=right valign="top" bgcolor="#f1f1f1" class=tablebody3>管理员名称：</TD>
<TD width="80%" height=19 bgcolor="#e1ebba" class=tablebody2>
<INPUT
name=admins id="admins" value=<%=Rs.getString("admin")%> size=29> <BR>
换上你自己的吧。</TD>
</TR>
<TR bgcolor="#FFFFFF">
<TD width="20%"
height=19 align=right valign="top" bgcolor="#f1f1f1" class=tablebody3>管理员密码：</TD>
<TD width="80%" height=19 bgcolor="#e1ebba" class=tablebody2>
<INPUT type=password size=29
value=<%=Rs.getString("password")%> name=password>
<B><br>
</B>若不希望修改，别改动就行了。</TD>
</TR>
<TR bgcolor="#FFFFFF">
<TD width="20%" height=19 align=right bgcolor="#f1f1f1" class=tablebody3>重复密码：</TD>
<TD width="80%" height=19 bgcolor="#e1ebba" class=tablebody2>
<INPUT type=password size=29
value=<%=Rs.getString("password")%> name=password2></TD>
</TR>
<TR bgcolor="#FFFFFF">
<TD width="20%" height=19 align=right bgcolor="#f1f1f1" class=tablebody3>管理员Email：</TD>
<TD width="80%" height=19 bgcolor="#e1ebba" class=tablebody2>
<INPUT name=email id="email"
value=<%=Rs.getString("email")%> size=29> </TD>
</TR>
<TR bgcolor="#FFFFFF">
<TD
height=21 colSpan=2 align=middle vAlign=center class=tablebody1>
<INPUT type=submit value="提 交" name=Submit> <INPUT type=reset value="清 除" name=Submit2>
</TD>
</TR>
</TBODY>
</TABLE>
</DIV>
</FORM>
<%
}
Rs.close();
%>
</td>
</tr>
</table>
<table width="100%" border="0" cellpadding="2" cellspacing="2" class="bian">
<tr>
<td style="BORDER-TOP: #969696 1px solid; FILTER: progid:DXImageTransform.Microsoft.Gradient(startColorStr='#5581D2', endColorStr='#FFFFFF', gradientType='1'" ><div align="right" class="f12"><font color="#333333">版权所有：WWW.JSPSKY.COM</font> <br>
</div></td>
</tr>
</table>
</body>
</html>
<%
}
else
{
String site=request.getParameter("site");
String url=request.getParameter("url");
String admins=request.getParameter("admins");
String password=request.getParameter("password");
String password2=request.getParameter("password2");
String email=request.getParameter("email");
String sql1="update admin set site='"+site+"',url='"+url+"',admin='"+admins+"',password='"+password+"',email='"+email+"' where id=1";
try{
stmt.executeUpdate(sql1);
response.sendRedirect("admin.jsp");
}catch(Exception e)
{
response.sendRedirect("error.jsp?error=2");//数据库更新出错！
}
}
if(conn!=null)
{
conn.close();
}
if(stmt!=null)
{
stmt.close();
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -