复习连接数据库--制作SQLHelper类完成登陆注册

最新推荐文章于 2018-11-14 19:27:47 发布

心如止静

最新推荐文章于 2018-11-14 19:27:47 发布

阅读量762

点赞数

本文链接：https://blog.csdn.net/qhx556/article/details/8104753

版权

制作SQLHelper类完成登陆注册

包含文件为 login登陆页，registor注册页，showMsg显示注册信息页，welcome欢迎页，使用session存储信息。

<head runat="server">
<title></title>
<style type="text/css">
.red
{
color:Red;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table align="center">
<tr><td>用户名：</td>
<td><asp:TextBox ID="txtUserName" runat="server"></asp:TextBox></td>
<td><span class="red">*</span></td></tr>

</table>

<asp:Label ID="lblErrorMessage" runat="server" Visible="False"></asp:Label>
<br />
</div></form>

</body>
</html>

logion.aspx.cs

protected void btnLogin_Click(object sender, EventArgs e)
{
string username = txtUserName.Text;
string password = txtPassWord.Text;

string connStr = "Data Source=QIHONGXIA-PC;Initial Catalog=UserDB1; Persist Security Info=True;User ID=sa;Password=842674";//第一步连接字符串
//string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
#region 方法1
//cmd.CommandText="select * from dbo.T_Users where FuserName=username";
//cmd.CommandText = "select * from dbo.T_Users where FuserName=@name and Fpassword=@pwd";
//cmd.Parameters.Add(new SqlParameter("@name", username));
//cmd.Parameters.Add(new SqlParameter("@pwd", password));
//if (Convert.ToInt64(cmd.ExecuteScalar()) > 0)
//{
// //找到了相应的用户名和密码，登陆成功
// //session["是否登陆"]=true
// Response.Redirect("~/lianxi/Welcome.aspx");
//}
//else
//{
// //用户名和密码不正确，登陆失败
//}
#endregion
cmd.CommandText = "select * from T_Users1 where FuserName=@name";
cmd.Parameters.Add(new SqlParameter("@name",username));
SqlDataReader reader=cmd.ExecuteReader();
if (reader.Read() == true)
{
//用户名存在
string pwd = reader.GetString(reader.GetOrdinal("Fpassword"));
if (pwd == password)
{
//用户名密码正确
//Session["是否登陆"]=true
this.lblErrorMessage.Visible = false;
Response.Redirect("~/lianxi/Welcome.aspx");
}
else
{
//密码错误
this.lblErrorMessage.Visible = true;
this.lblErrorMessage.Text="密码错误";
}
}
else
{
//用户不存在名
this.lblErrorMessage.Visible = true;
this.lblErrorMessage.Text = "用户名不存在!";
}
}
}

}
protected void btnRegister_Click(object sender, EventArgs e)
{

Response.Redirect("~/lianxi2/Registor.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox2.Text == Session["Code"].ToString())
{
Response.Write("正确");
}
else
{
Response.Write("不正确");
}
}
}

registor.aspx页

registor.aspx.cs

public partial class lianxi_Registor : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
RegisterUser.ContinueDestinationPageUrl = Request.QueryString["ReturnUrl"];
}
protected void btnRegister_Click(object sender, EventArgs e)
{
//验证控件完成用户名密码合法性验证，
string username = txtUserName.Text;
string password = txtPassWord.Text;
#region 向数据库插入记录方法1
//string connStr = "Data Source=QIHONGXIA-PC;Initial Catalog=UserDB1; Persist Security Info=True;User ID=sa;Password=842674";//第一步连接字符串
//using (SqlConnection conn = new SqlConnection(connStr))
//{
// conn.Open();
// using (SqlCommand cmd = conn.CreateCommand())
// {
// cmd.CommandText = "insert into T_Users1(Fusername,Fpassword)values(@name,@pwd)";
// cmd.Parameters.Add(new SqlParameter("@name", username));
// cmd.Parameters.Add(new SqlParameter("@pwd", password));
// cmd.ExecuteNonQuery();
// //Session["用户登陆Id"]=UserId；
// //Session["是否登陆"]=true
// Response.Redirect("ShowMsg.aspx?Msg=注册成功，即将转向登陆页面! &RedirectURL=Login.aspx");
// }

//}
#endregion
SqlParameter p1=new SqlParameter("@name", username);
SqlParameter p2=new SqlParameter("@pwd", password);

int result=SQLHelper.ExecuteNoQuery("insert into T_Users1(Fusername,Fpassword)values(@name,@pwd)",new SqlParameter("@name",username),new SqlParameter("@pwd",password));
if (result >= 1)
{
//向数据库中插入了至少一条记录
Response.Redirect("ShowMsg.aspx?Msg=注册成功，即将转向登陆页面！&RedirectURL=Login.aspx");
}
}
}

showMsg.aspx页

setTimeout(function () {
location.href = '<%=Request["RedirectURL"] %>';

}, 3000);

</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lblMsg" runat="server" Text="Label"></asp:Label>
<a href='<%=Request["RedirectURL"] %>'>立即转向</a>
</div>
</form>
</body>
</html>

showMsg.aspx.cs页

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class lianxi2_ShowMsg : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
lblMsg.Text = Request["Msg"];
//Response.Redirect(Request["RedirectURL"]);
}
}

welcome.aspx页

<%@ Page Xlanguage="C#" AutoEventWireup="true" CodeFile="Welcome.aspx.cs" Inherits="lianxi_Welcome" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

welcome.aspx.cs页

ublic partial class lianxi_Welcome : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//Session["是否登录"]!=true,Response.Redirect("~/lianxi2/Login.aspx");
}
}
protected void Page_UnLoad(object sender, EventArgs e)
{
//Session["是否登录"]=false;

}
protected void Button1_Click(object sender, EventArgs e)
{
DataSet dataset = new DataSet();
string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from T_Users";

SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dataset);
}
}
DataTable table=dataset.Tables[0];

for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
string name = Convert.ToString(row["FuserName"]);
this.TextBox1.Text += name + ";";
}

}
}

session.aspx页

default.aspx

default.aspx.cs

public partial class Session_Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//读取seesion 的时候需要一个参数string sessionid----------cookie
if (Request.Cookies["MySessionId"] == null)
{
string sessionId = Guid.NewGuid().ToString();
Response.SetCookie(new HttpCookie("MySessionId", sessionId));
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string sessionid = Request.Cookies["MySessionId"].Value;
IDictionary<string, object> session = SessionMrg.GetSession(sessionid);
this.Button2.Text = Convert.ToString(session["服务端数据"]);
}
protected void Button1_Click(object sender, EventArgs e)
{
string sessionid = Request.Cookies["MySessionId"].Value;
IDictionary<string, object> session = SessionMrg.GetSession(sessionid);
session["服务端数据"] = "嘿嘿嘻嘻哈哈";
}
}

default2.aspx

default2.aspx.cs

protected void Button1_Click(object sender, EventArgs e)
{
Session["第一个值"] = DateTime.Now;
Session["第二个值"] = "Hello Gay";
}
protected void Button2_Click(object sender, EventArgs e)
{
Button2.Text = Convert.ToString(Session["第一个值"]);
}

default3.aspx

<asp:Button ID="Button1" runat="server" Text="Button" Xοnclick="Button1_Click" />

</div>
</form>
</body>

default3.aspx.cs

public partial class Session_Default3 : System.Web.UI.Page
{
//static int V;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session["value"] = 0;
}

}
protected void Button1_Click(object sender, EventArgs e)
{
int v = Convert.ToInt32(Session["value"]);
v++;
Session["value"] = v;
TextBox1.Text = v.ToString();