📄 gl.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="index.aspx.cs" Inherits="_index" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="c#" runat="server">
void Page_Load() {
if (!IsPostBack)
{
yh.Text = "";
mm1.Text ="";
yh.Focus();
}
}
void dlsj(object s,EventArgs e) {
string _lj = ConfigurationSettings.AppSettings["sjk"];
SqlConnection lj = new SqlConnection(_lj);
lj.Open();
SqlCommand cmd = new SqlCommand("select count(*) from admin where name='" + yh.Text + "' and pass='" + mm1.Text + "'", lj);
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
HttpCookie yangxiao = new HttpCookie("usre");
yangxiao.Value = "188";
Response.Cookies.Add(yangxiao);
ts.Text = "登陆成功！";
Panel1.Visible = true;
}
else
{
ts.Text = "登录失败,检查用户名与密码!";
Panel1.Visible = false;
}
lj.Close();
}
void Button4_Click(object sender, EventArgs e)
{
string _lj = ConfigurationSettings.AppSettings["sjk"];
SqlConnection lj = new SqlConnection(_lj);
lj.Open();
SqlCommand cmd = new SqlCommand("insert into admin(name,pass) values('" + TextBox2.Text + "','" + TextBox3.Text + "')", lj);
cmd.ExecuteNonQuery();
lj.Close();
ts.Text = "管理员添加成功";
}
void Button6_Click(object sender, EventArgs e)
{
string _lj = ConfigurationSettings.AppSettings["sjk"];
SqlConnection lj = new SqlConnection(_lj);
lj.Open();
SqlCommand cmd = new SqlCommand("update admin set pass='"+TextBox5.Text+"'where name='"+TextBox4.Text+"'" , lj);
cmd.ExecuteNonQuery();
lj.Close();
ts.Text = "密码修改成功";
}
</script>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>管理员登录</title>
<link href="css.css" rel="stylesheet" type="text/css" />
<script type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_showHideLayers() { //v6.0
var i,p,v,obj,args=MM_showHideLayers.arguments;
for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
obj.visibility=v; }
}
//-->
</script>
</head>
<body style="background-image: url(images/index_25.gif); background-repeat: repeat;">
<form id="Form1" runat="server">
<div id="mm" style="z-index: 102; left: 261px; width: 259px; position: absolute; top: 292px; height: 183px; visibility: hidden; text-align: center; border-top-width: thin; border-left-width: thin; border-left-color: #00ffff; background-image: url(img/index_3.gif); border-bottom-width: thin; border-bottom-color: #00ffff; border-top-color: #00ffff; border-right-width: thin; border-right-color: #00ffff;">
<table border="0" cellpadding="0" cellspacing="0" style="border-bottom: #3366cc thin solid; border-top-width: thin; border-left-width: thin; border-left-color: #ffffff; border-top-color: #ffffff; border-right-width: thin; border-right-color: #ffffff;">
<tr>
<td style="width: 702px; color: #ff0000; height: 16px; text-align: left"><img src="images/online.gif" /> 密 码 修 改</td>
<td style="width: 100px; height: 16px; text-align: center;" onfocus="MM_showHideLayers('mm','','hide')"><img src="images/close_a.gif" /></td>
</tr>
</table>
<br />
新管理员名称：
<asp:TextBox ID="TextBox4" runat="server" Width="126px" validationgroup="a1"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="TextBox4"
ErrorMessage="*" validationgroup="a1"></asp:RequiredFieldValidator>
<br />
<asp:CompareValidator ID="CompareValidator2" runat="server" ControlToCompare="TextBox5"
ControlToValidate="TextBox6" ErrorMessage="密码不一致" Width="74px" validationgroup="a1"></asp:CompareValidator>
<br />
新管理员密码：
<asp:TextBox ID="TextBox5" runat="server" TextMode="Password" Width="126px" validationgroup="a1"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="TextBox5"
ErrorMessage="*" validationgroup="a1"></asp:RequiredFieldValidator>
<br />
新密码确认：
<asp:TextBox ID="TextBox6" runat="server" TextMode="Password"
Width="126px" validationgroup="a1"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="TextBox5"
ErrorMessage="*" ValidationGroup="a1"></asp:RequiredFieldValidator><br />
<br />
<asp:Button ID="Button6" runat="server" OnClick="Button6_Click" Text="确定" validationgroup="a1" />
</div>
<div id="dlk" runat="server" align="center">
<div>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td style="background-image: url(img/header.jpg); width: 760px; height: 200px">
<span style="font-size: 24pt; color: #cc9900; font-family: 华文彩云"></span> <table
border="0" cellpadding="0" cellspacing="0" style="width: 632px; height: 113px;
text-align: left">
<tr>
<td style="width: 100px; height: 145px">
</td>
<td style="width: 100px; height: 145px">
<span style="font-family: 黑体"><span style="color: #66ccff"><span style="font-size: 24pt">
<br />
</span>
</span></span>
</td>
</tr>
<tr>
<td style="width: 100px; height: 20px">
</td>
<td style="width: 100px; height: 20px">
<asp:LinkButton ID="LinkButton2" runat="server" ForeColor="LightSlateGray" PostBackUrl="~/index.aspx"
Width="58px">返回首页</asp:LinkButton>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" style="background-image: url(img/main.jpg);
width: 760px">
<tr>
<td style="width: 104px; height: 247px; text-align: right;">
<table border="0" cellpadding="0" cellspacing="0" style="width: 666px; height: 273px">
<tr>
<td rowspan="4" style="width: 1333px">
</td>
<td style="text-align: right" colspan="2" rowspan="4">
<br />
<br />
用户:<asp:TextBox ID="yh" Width="100" runat="server" /><br />
<br />
密码:<asp:TextBox ID="mm1" Width="100" TextMode="password" runat="server" /><asp:Button ID="dl" runat="server" Text="管理员登录" OnClick="dlsj" />
<br />
<br />
<br />
<asp:Label ID="ts" runat="server" Text="请输入用户和密码" ForeColor="Red" Width="122px" /></td>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
</tr>
</table>
<br />
<br />
<div>
</div>
<div style="text-align: right">
</div>
</td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td style="background-image: url(img/footer.jpg); width: 760px; height: 63px">
<asp:Panel ID="Panel1" runat="server" Height="6px" Width="531px" Visible="False" BackImageUrl="~/img/index_3.gif">
<table border="1" cellpadding="0" cellspacing="0" style="cursor: hand; width: 350px;" id="guanli">
<tr>
<td style="width: 127px">
<span>
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/index.aspx" Width="100px">回复、删除、修改</asp:HyperLink></span></td>
<td style="width: 178px" onfocus="MM_showHideLayers('gl','','show')">
<span>添加管理员</span>
<div id="gl" style="z-index: 101; left: 154px; width: 261px; position: absolute; top: 214px; height: 168px; visibility: hidden; border-top-width: thin; border-left-width: thin; border-left-color: #00ffff; background-image: url(img/index_3.gif); border-bottom-width: thin; border-bottom-color: #00ffff; border-top-color: #00ffff; border-right-width: thin; border-right-color: #00ffff;">
<table border="0" cellpadding="0" cellspacing="0" style="border-bottom: #3366cc thin solid; border-top-width: thin; border-left-width: thin; border-left-color: #ffffff; border-top-color: #ffffff; border-right-width: thin; border-right-color: #ffffff;">
<tr>
<td style="width: 702px; color: #ff0000; height: 16px; text-align: left">
<img src="images/online.gif" />
管 理 员 添 加</td>
<td style="width: 100px; height: 16px; text-align: center;" onfocus="MM_showHideLayers('gl','','hide')">
<img src="images/close_a.gif" onClick="MM_showHideLayers('gl','','hide')" /></td>
</tr>
</table>
<br />
新管理员名称：<asp:TextBox ID="TextBox2" runat="server" Width="126px" ValidationGroup="a0"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox2"
ErrorMessage="*" ValidationGroup="a0"></asp:RequiredFieldValidator><br />
<asp:CompareValidator ID="CompareValidator1" runat="server" ControlToCompare="TextBox3"
ControlToValidate="TextBox7" ErrorMessage="密码不一致" Width="74px" ValidationGroup="a0"></asp:CompareValidator><br />
新管理员密码：<asp:TextBox ID="TextBox3" runat="server" TextMode="Password" Width="126px" ValidationGroup="a0"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox3"
ErrorMessage="*" ValidationGroup="a0"></asp:RequiredFieldValidator><br />
<span> 新密码确认：</span><asp:TextBox ID="TextBox7" runat="server" TextMode="Password"
Width="126px" ValidationGroup="a0"></asp:TextBox> <asp:RequiredFieldValidator
ID="RequiredFieldValidator6" runat="server" ControlToValidate="TextBox3" ErrorMessage="*"
ValidationGroup="a0"></asp:RequiredFieldValidator><br />
<br />
<asp:Button ID="Button4" runat="server" OnClick="Button4_Click" Text="确定" ValidationGroup="a0" />
<br />
</div></td>
<td style="width: 88px" onfocus="MM_showHideLayers('mm','','show')">
<span>
修改密码</span></td>
</tr>
</table>
</asp:Panel>
本程序为SQL版本，２００７年６月２１日完成(课程设计作业)，内蒙古电子信息学院、稻草人版权所有(ＱＱ：２８８４５８７)
</td>
</tr>
</table>
<br />
</div>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -