📄 admin_login.jsp
字号:
<%--
File Name:admin_login.jsp
Author:fancy
Date:2001.6.1
Usage:for the administrator to login this admin interface
Address:Peking University 37#215,62762526,fancyrainbow@263.net,bbs.pku.edu.cn(id:javalover)
Note:1.这是一个Open Source项目,你可以自由的获取,修改,传播本项目的代码,无需经过本人的同意。
2.你不可以将本项目的源代码用于商业应用,除非获得本人的书面允许。
3.本项目的核心源代码所有权归原开发者所有,如果需要获取最新的核心代码，请与本人联系
--%>
<%
//设定Session,可能用不上
session.putValue("prevlink","");
session.putValue("nextlink","");
session.putValue("firstlink","");
session.putValue("lastlink","");
session.putValue("editlink","");
session.putValue("deletelink","");
session.putValue("backlink","");
%>
<%
String username=request.getParameter("username");
String password=request.getParameter("password");
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Java论坛</title>
</head>
<%@ include file="defaultcss.jsp"%>
<%@ include file="menuaction.jsp"%>
<%@ include file="database.jsp" %>
<%
java.sql.Statement stmtlist=conn.createStatement();
String SQL="SELECT * FROM forumuser where username='"+username+"'"+" and password='"+password+"'";
//out.println(SQL);
boolean boolCanLogin=false;
boolean boolCanAdmin=false;
String admingroup="";
ResultSet rslist=stmtlist.executeQuery(SQL);
rslist.last();
int lastrow=rslist.getRow();
if(lastrow!=0)
{
boolCanLogin=true;//初步验证,还不能够获取控制权
//out.println("here");
//首先作为普通用户登陆
session.putValue("username",username);
session.putValue("password",password);
rslist.close();
}
//out.println(boolCanLogin);
%>
<%
if (boolCanLogin==true)
{
SQL="UPDATE forumuser SET status='ONLINE' where username='"+username+"'"+" and password='"+password+"'";
stmtlist.execute(SQL);
if(username.equals("SYSOP"))//是系统管理员,获取Admin权限
{
session.putValue("adminuser",username);
session.putValue("adminpassword",password);
session.putValue("admingroup","SYSOP");
boolCanAdmin=true;
admingroup="SYSOP";
//out.println(username+boolCanAdmin);
//out.println(session.getValue("admingroup"));
}
else
{
SQL="SELECT * FROM forumgroup where adminusername='"+username+"'";
ResultSet rstemp=stmtlist.executeQuery(SQL);
rstemp.last();
lastrow=rstemp.getRow();
if(lastrow!=0)//是版主,获取部分Admin权限
{
session.putValue("adminuser",username);
session.putValue("adminpassword",password);
//设定可以管理的板块
session.putValue("admingroup",rstemp.getString(2));
boolCanAdmin=true;
admingroup=rstemp.getString(1);
//out.println(username+boolCanAdmin);
//out.println(session.getValue("admingroup"));
rstemp.close();
}
else
{
//to do nothing
}
}
}
stmtlist.close();
%>
<body LANGUAGE=javascript onload="return window_onload()">
<table border="0" width="100%" height="139" cellspacing="0" cellpadding="0">
<%@ include file="admintoptable.jsp"%>
<tr>
<td width="2%" height="13"></td>
<td width="92%" height="32" colspan="5" rowspan="2">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="80%" height="26">
<tr bgcolor="#efefef">
<td width="25%" height="24"></td>
<td width="50%" height="24" align="center"><font color="red" size="2">Java技术讨论区(登陆BBS)</font></td>
<td width="25%" height="24"></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
<tr><td width="2%" height="13"></td></tr>
<tr>
<td width="2%" height="16"></td>
<td width="2%" height="1" rowspan="18" background="img/shu.gif"></td>
<td width="92%" height="1" colspan="5" rowspan="18">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="1" width="99%" height="47">
<tr bgcolor='#DCEDED'>
<td width='100%' height='1' align="center">
<%
if (boolCanAdmin==true)
{
%>
<font color="red" size="2">祝贺您,<%=username%>:您已经成功地登陆了BBS管理系统</font>
<%
}
else
{
%>
<font color="red" size="2">对不起,<%=username%>:您的输入可能有误,请再试一下好吗?</font>
<%
}
%>
</td>
</tr>
<tr bgcolor='#DCDDED'>
<td width='100%' height='1' align="center">
<%
if(boolCanAdmin)
{
%>
<font color="red" size="2">回到<a href="adminlist.jsp?key=<%=session.getValue("admingroup")%>"><%=admingroup%></a>信区</font>
<%
}
else
{
%>
<font color="red" size="2">回到<a href="adminwelcome.jsp">首页</a></font>
<%
}
%>
</td>
</tr>
</table>
</center>
</div>
</td>
<td width="2%" height="1" rowspan="18"></td>
<td width="2%" height="1" rowspan="18" background="img/shu.gif"> </td>
</tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="16"></td></tr>
<tr><td width="2%" height="1"></td></tr>
<tr>
<td width="2%" height="41" rowspan="2"></td>
<td width="2%" height="41" background="img/shu.gif" rowspan="2"></td>
<td width="92%" height="27" colspan="5"></td>
<td width="2%" height="41" rowspan="2" background="img/shu.gif"></td>
<td width="2%" height="41" background="img/shu.gif" rowspan="2"></td>
</tr>
<tr align="center">
<td width="92%" height="18" colspan="5" background="img/bottom.gif"> </td>
</tr>
</table>
<%@ include file="adminmenu.jsp"%>
<%@ include file="adminmsgbox.jsp"%>
<%
conn.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -