welcome.aspx的设计
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="welcome.aspx.cs" Inherits="_10_17.数据库建立.welcome" %>
<!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 runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
恭喜你,登陆成功了!
</div>
</form>
</body>
</html>
welcome.aspx.cs的设计
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace _10_17.数据库建立
{
public partial class welcome : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
}
}
protected void Page_UnLoad(object sender, EventArgs e)
{
}
}
yanzheng.aspx设计
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="yanzheng.aspx.cs" Inherits="_10_17.数据库建立.yanzheng" %>
<!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 runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
</form>
</body>
</html>
yanzheng.aspx.cs的设计
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace _10_17.数据库建立
{
public partial class yanzheng : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Response.ContentType = "image/jpeg";
using (System.Drawing.Bitmap bitmap = new System.Drawing.Bitmap(57, 27))
{
using (System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(bitmap))
{
Random rand = new Random();
int code = rand.Next(1000, 9999);
string verCode = code.ToString();
Session["Code"] = verCode;
g.DrawString(verCode, new System.Drawing.Font("黑体", 19), System.Drawing.Brushes.Green, 0, 0);
bitmap.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
}
}
}
}
}
成功.aspx的设计
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="成功.aspx.cs" Inherits="_10_17.数据库建立.成功" %>
<!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 runat="server">
<title></title>
<script type="text/javascript">
setTimeout(function () {
location.href = '<%=Request["RedirectURL"]%>';
},3000);
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lbl" runat="server" Text="Label"></asp:Label>
</div>
</form>
</body>
</html>
成功.aspx.cs的设计
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace _10_17.数据库建立
{
public partial class 成功 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
lbl.Text = Request["Msg"];
}
}
}
登陆界面.aspx的设计
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="登陆界面.aspx.cs" Inherits="_10_17.数据库建立.登陆界面" %>
<!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 runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table align="center"><tr><td></td><td>
<asp:Label ID="Label1" runat="server" Text="登陆界面"></asp:Label></td></tr></table>
<table align="center">
<tr><td>用户名:</td><td>
<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox></td><td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ErrorMessage="不能为空" ForeColor="Red" ControlToValidate="txtUserName"></asp:RequiredFieldValidator></td></tr>
<tr><td>密码:</td><td>
<asp:TextBox ID="txtPassword" runat="server"></asp:TextBox></td><td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ErrorMessage="不能为空" ControlToValidate="txtPassword" ForeColor="Red"></asp:RequiredFieldValidator></td>
</tr>
<tr><td><img src="yanzheng.aspx" οnclick="this.src='yanzheng.aspx?aaa=bbb'+new Date()" /></td>
<td><asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
</tr>
<tr><td align="center" colspan="2">
<asp:Button ID="btnLogin" runat="server" Text="登陆" οnclick="btnLogin_Click"
Height="21px" Width="45px" />
<asp:Button ID="btnRegister"
runat="server" Text="注册" Height="21px" Width="45px"
CausesValidation="False" οnclick="btnRegister_Click" /></td></tr>
</table><asp:Label ID="lblErrorMessage" runat="server" Visible="False"></asp:Label>
</div>
</form>
</body>
</html>
登陆界面aspx.cs的设计
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using _10_17.数据库;
namespace _10_17.数据库建立
{
public partial class 登陆界面 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string username = txtUserName.Text;
string password = txtPassword.Text;
string coonStr = "Data Source=PC-20120416OTQL;Initial Catalog=UserDB1;Persist Security Info=True;User ID=sa;Password=admin";
using (SqlConnection coon = new SqlConnection(coonStr))
{
coon.Open();
using (SqlCommand cmd = coon.CreateCommand())
{
cmd.CommandText = "select * from T_userName where UserName=@name";
cmd.Parameters.Add(new SqlParameter("@name", username));
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read() == true && TextBox1.Text == Session["Code"].ToString())
{
string pwd = reader.GetString(reader.GetOrdinal("PassWord"));
if (pwd == password)
{
//用户名存在
this.lblErrorMessage.Visible = false;
Response.Redirect("~/数据库建立/welcome.aspx");
}
else
{
this.lblErrorMessage.Visible = true;
this.lblErrorMessage.Text = "密码错误";
}
}
else
{
this.lblErrorMessage.Visible = true;
this.lblErrorMessage.Text = "用户名或验证码不正确";
}
}
}
#region
object result=sqlHelper.ExecuteScalar("select * from T_userName where UserName=@name", new SqlParameter("@name", username));
if (Convert.ToInt64(result) > 0)
{
Response.Redirect("welcome.aspx");
}
else
{
}
#endregion
}
protected void btnRegister_Click(object sender, EventArgs e)
{
Response.Redirect("~/数据库建立/注册界面.aspx");
}
}
}
注册界面.aspx的设计
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="注册界面.aspx.cs" Inherits="_10_17.数据库建立.注册界面" %>
<!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 runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table align="center"><tr><td></td><td>
<asp:Label ID="Label1" runat="server" Text="注册界面"></asp:Label></td></tr></table>
<table align="center">
<tr><td>用户名:</td><td>
<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox></td><td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ErrorMessage="不能为空" ControlToValidate="txtUserName"
ForeColor="Red"></asp:RequiredFieldValidator></td>
</tr>
<tr><td>密码:</td><td>
<asp:TextBox ID="txtPassword" runat="server"></asp:TextBox></td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ErrorMessage="不能为空" ControlToValidate="txtPassword"
ForeColor="Red"></asp:RequiredFieldValidator></td>
</tr>
<tr><td>Email:</td><td>
<asp:TextBox ID="txtEmail" runat="server"></asp:TextBox></td>
<td>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ErrorMessage="不能为空" ControlToValidate="txtEmail" ForeColor="Red"></asp:RequiredFieldValidator></td></tr>
<tr><td colspan="2" align="center">
<asp:Button ID="btnRegister" runat="server" Text="注册"
οnclick="btnRegister_Click" style="height: 21px" /></td></tr>
</table>
</div>
</form>
</body>
</html>
注册界面aspx.cs的设计
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using _10_17.数据库;
namespace _10_17.数据库建立
{
public partial class 注册界面 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnRegister_Click(object sender, EventArgs e)
{
string username = txtUserName.Text;
string password = txtPassword.Text;
string email = txtEmail.Text;
string coonStr = "Data Source=PC-20120416OTQL;Initial Catalog=UserDB1;Persist Security Info=True;User ID=sa;Password=admin";
using(SqlConnection coon = new SqlConnection(coonStr))
{
coon.Open();
using (SqlCommand cmd = coon.CreateCommand())
{
cmd.CommandText = "insert into T_userName(UserName,PassWord,Email)values(@name,@pwd,@em)";
cmd.Parameters.Add(new SqlParameter("@name", username));
cmd.Parameters.Add(new SqlParameter("@pwd", password));
cmd.Parameters.Add(new SqlParameter("@em", email));
cmd.ExecuteNonQuery();
Response.Redirect("~/数据库建立/成功.aspx?Msg=注册成功,即将跳转到登陆界面&RedirectURL=登陆界面.aspx");
}
}
}
}
}