Code
1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Web;
5 using System.Web.Security;
6 using System.Web.UI;
7 using System.Web.UI.WebControls;
8 using System.Web.UI.WebControls.WebParts;
9 using System.Web.UI.HtmlControls;
10 using System.Data.SqlClient;
11
12 /// <summary>
13 /// Connection 的摘要说明
14 /// </summary>
15 public class Connection
16 {
17 public Connection()
18 {
19 //
20 // TODO: 在此处添加构造函数逻辑
21 //
22 }
23
24 public static SqlConnection getConnection()
25 {
26 return new SqlConnection (System .Configuration .ConfigurationManager .ConnectionStrings ["ConnectionString"].ConnectionString );
27 }
28 }
29
1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Web;
5 using System.Web.Security;
6 using System.Web.UI;
7 using System.Web.UI.WebControls;
8 using System.Web.UI.WebControls.WebParts;
9 using System.Web.UI.HtmlControls;
10 using System.Data.SqlClient;
11
12 /// <summary>
13 /// Connection 的摘要说明
14 /// </summary>
15 public class Connection
16 {
17 public Connection()
18 {
19 //
20 // TODO: 在此处添加构造函数逻辑
21 //
22 }
23
24 public static SqlConnection getConnection()
25 {
26 return new SqlConnection (System .Configuration .ConfigurationManager .ConnectionStrings ["ConnectionString"].ConnectionString );
27 }
28 }
29
User类
1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Web;
5 using System.Web.Security;
6 using System.Web.UI;
7 using System.Web.UI.WebControls;
8 using System.Web.UI.WebControls.WebParts;
9 using System.Web.UI.HtmlControls;
10 using System.Data.SqlClient;
11
12 /// <summary>
13 /// User 的摘要说明
14 /// </summary>
15 public class User
16 {
17 public User()
18 {
19 //
20 // TODO: 在此处添加构造函数逻辑
21 //
22 }
23
24 /// <summary>
25 /// 检测用户是否存在
26 /// </summary>
27 /// <param name="userName">用户名</param>
28 /// <returns>bool</returns>
29 public bool checkName(string userName)
30 {
31 SqlConnection userConnection = Connection.getConnection();
32 SqlCommand userCommand = new SqlCommand("checkName", userConnection);
33
34 userCommand.CommandType = CommandType.StoredProcedure;
35 userCommand.Parameters.Add("@userName", SqlDbType.VarChar, 50);
36 userCommand.Parameters["@userName"].Value = userName;
37 userCommand.Connection.Open();
38 int n = (int)userCommand.ExecuteScalar();
39 userCommand.Connection.Close();
40
41 if (n > 0)
42 {
43 return true;
44 }
45 else
46 {
47 return false;
48 }
49 }
50
51 /// <summary>
52 /// 插入用户
53 /// </summary>
54 /// <param name="userName">用户名</param>
55 /// <param name="userPwd">密码</param>
56 /// <returns></returns>
57 public bool insertUserInfo(string userName, string userPwd)
58 {
59 SqlConnection userConnection = Connection.getConnection();
60 SqlCommand userCommand = new SqlCommand("insertUserInfo", userConnection);
61
62 userCommand.CommandType = CommandType.StoredProcedure;
63 userCommand.Parameters.Add("@userName", SqlDbType.VarChar, 50);
64 userCommand.Parameters["@userName"].Value = userName;
65
66 userCommand.Parameters.Add("@userPwd", SqlDbType.VarChar, 50);
67 userCommand.Parameters["@userPwd"].Value = userPwd;
68
69 userCommand.Connection.Open();
70 userCommand.ExecuteNonQuery();
71
72 userCommand.Connection.Close();
73 return true;
74 }
75
76 /// <summary>
77 /// 查询用户信息
78 /// </summary>
79 /// <returns>SqlDataReader</returns>
80 public SqlDataReader selectUserInfo()
81 {
82 SqlConnection userConnection = Connection.getConnection();
83 SqlCommand userCommand = new SqlCommand("select * from UserInfo",userConnection );
84 userCommand.Connection.Open() ;
85 return userCommand.ExecuteReader();
86
87 }
88
89 /// <summary>
90 /// 删除用户
91 /// </summary>
92 /// <param name="userName">用户名</param>
93 /// <returns>bool</returns>
94 public bool deleteUser(string userName)
95 {
96 SqlConnection userConnection = Connection.getConnection();
97 SqlCommand userCommand = new SqlCommand("deleteUser", userConnection);
98 userCommand.CommandType = CommandType.StoredProcedure;
99
100 userCommand.Parameters.Add("@userName", SqlDbType.VarChar, 50);
101 userCommand.Parameters["@userName"].Value = userName;
102
103 userCommand.Connection.Open();
104
105 userCommand.ExecuteNonQuery();
106 userCommand.Connection.Close();
107
108 return true;
109 }
110
111 /// <summary>
112 /// 更新用户信息
113 /// </summary>
114 /// <param name="userName"></param>
115 /// <param name="userPwd"></param>
116 /// <returns></returns>
117 public bool updateUserInfo(string userName, string userPwd)
118 {
119 SqlConnection userConnection = Connection.getConnection();
120 SqlCommand userCommand = new SqlCommand("updateUserInfo", userConnection);
121 userCommand.CommandType = CommandType.StoredProcedure;
122 userCommand.Parameters.Add("@userName", SqlDbType.VarChar, 50);
123 userCommand.Parameters["@userName"].Value = userName;
124 userCommand.Parameters.Add("@userPwd", SqlDbType.VarChar, 50);
125 userCommand.Parameters["@userPwd"].Value = userPwd;
126
127 userCommand.Connection.Open();
128 userCommand.ExecuteNonQuery();
129 userCommand.Connection.Close();
130
131 return true;
132 }
133 }
134
1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Web;
5 using System.Web.Security;
6 using System.Web.UI;
7 using System.Web.UI.WebControls;
8 using System.Web.UI.WebControls.WebParts;
9 using System.Web.UI.HtmlControls;
10 using System.Data.SqlClient;
11
12 /// <summary>
13 /// User 的摘要说明
14 /// </summary>
15 public class User
16 {
17 public User()
18 {
19 //
20 // TODO: 在此处添加构造函数逻辑
21 //
22 }
23
24 /// <summary>
25 /// 检测用户是否存在
26 /// </summary>
27 /// <param name="userName">用户名</param>
28 /// <returns>bool</returns>
29 public bool checkName(string userName)
30 {
31 SqlConnection userConnection = Connection.getConnection();
32 SqlCommand userCommand = new SqlCommand("checkName", userConnection);
33
34 userCommand.CommandType = CommandType.StoredProcedure;
35 userCommand.Parameters.Add("@userName", SqlDbType.VarChar, 50);
36 userCommand.Parameters["@userName"].Value = userName;
37 userCommand.Connection.Open();
38 int n = (int)userCommand.ExecuteScalar();
39 userCommand.Connection.Close();
40
41 if (n > 0)
42 {
43 return true;
44 }
45 else
46 {
47 return false;
48 }
49 }
50
51 /// <summary>
52 /// 插入用户
53 /// </summary>
54 /// <param name="userName">用户名</param>
55 /// <param name="userPwd">密码</param>
56 /// <returns></returns>
57 public bool insertUserInfo(string userName, string userPwd)
58 {
59 SqlConnection userConnection = Connection.getConnection();
60 SqlCommand userCommand = new SqlCommand("insertUserInfo", userConnection);
61
62 userCommand.CommandType = CommandType.StoredProcedure;
63 userCommand.Parameters.Add("@userName", SqlDbType.VarChar, 50);
64 userCommand.Parameters["@userName"].Value = userName;
65
66 userCommand.Parameters.Add("@userPwd", SqlDbType.VarChar, 50);
67 userCommand.Parameters["@userPwd"].Value = userPwd;
68
69 userCommand.Connection.Open();
70 userCommand.ExecuteNonQuery();
71
72 userCommand.Connection.Close();
73 return true;
74 }
75
76 /// <summary>
77 /// 查询用户信息
78 /// </summary>
79 /// <returns>SqlDataReader</returns>
80 public SqlDataReader selectUserInfo()
81 {
82 SqlConnection userConnection = Connection.getConnection();
83 SqlCommand userCommand = new SqlCommand("select * from UserInfo",userConnection );
84 userCommand.Connection.Open() ;
85 return userCommand.ExecuteReader();
86
87 }
88
89 /// <summary>
90 /// 删除用户
91 /// </summary>
92 /// <param name="userName">用户名</param>
93 /// <returns>bool</returns>
94 public bool deleteUser(string userName)
95 {
96 SqlConnection userConnection = Connection.getConnection();
97 SqlCommand userCommand = new SqlCommand("deleteUser", userConnection);
98 userCommand.CommandType = CommandType.StoredProcedure;
99
100 userCommand.Parameters.Add("@userName", SqlDbType.VarChar, 50);
101 userCommand.Parameters["@userName"].Value = userName;
102
103 userCommand.Connection.Open();
104
105 userCommand.ExecuteNonQuery();
106 userCommand.Connection.Close();
107
108 return true;
109 }
110
111 /// <summary>
112 /// 更新用户信息
113 /// </summary>
114 /// <param name="userName"></param>
115 /// <param name="userPwd"></param>
116 /// <returns></returns>
117 public bool updateUserInfo(string userName, string userPwd)
118 {
119 SqlConnection userConnection = Connection.getConnection();
120 SqlCommand userCommand = new SqlCommand("updateUserInfo", userConnection);
121 userCommand.CommandType = CommandType.StoredProcedure;
122 userCommand.Parameters.Add("@userName", SqlDbType.VarChar, 50);
123 userCommand.Parameters["@userName"].Value = userName;
124 userCommand.Parameters.Add("@userPwd", SqlDbType.VarChar, 50);
125 userCommand.Parameters["@userPwd"].Value = userPwd;
126
127 userCommand.Connection.Open();
128 userCommand.ExecuteNonQuery();
129 userCommand.Connection.Close();
130
131 return true;
132 }
133 }
134
Default.aspx
1<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
2
3<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4<html xmlns="http://www.w3.org/1999/xhtml">
5<head runat="server">
6 <title></title>
7<script language ="javascript" src="CreateObject.js"></script>
8</head>
9<body>
10 <form id="form1" runat="server">
11 <div style="text-align: center">
12 <table style=" 420px; height: 256px; text-align: center;" id="TABLE1" onclick="return TABLE1_onclick()">
13
14 <tr>
15 <td style=" 69px; height: 21px; border: 1px; text-align: center;">
16 <asp:Label ID="lblUserName" runat="server" Text="用户名:"></asp:Label></td>
17 <td style=" 69px; height: 21px; border: 1px;">
18 <input id="txtUserName" type="text" onkeyup="CheckName(document.getElementById('txtUserName').value);" /></td>
19 <td>
20 <img id="imgName" src="" /></td>
21 </tr>
22 <tr>
23 <td style=" 69px; height: 21px; border: 1px;">
24 <asp:Label ID="lblUserPwd" runat="server" Text="密码:"></asp:Label></td>
25 <td style=" 69px; height: 21px; border: 1px;">
26 <input id="txtUserPwd" type="text" /></td>
27 <td>
28 </td>
29 </tr>
30 <tr>
31 <td style=" 69px; height: 21px; border: 1px;">
32 <asp:Label ID="lblUserPwdRe" runat="server" Text="重复密码:"></asp:Label></td>
33 <td style=" 69px; height: 21px; border: 1px;">
34 <input id="txtUserPwdRe" type="text" />
35 </td>
36 <td>
37 </td>
38 </tr>
39 <tr>
40 <td colspan="3" style="border-top- 1px; border-left- 1px; border-bottom- 1px;
41 height: 21px; border-right- 1px">
42 <input id="btnOk" style=" 90px" type="button" value="OK" /></td>
43 </tr>
44 </table>
45 </div>
46 </form>
47</body>
48</html>
49
Code1<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
2
3<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4<html xmlns="http://www.w3.org/1999/xhtml">
5<head runat="server">
6 <title></title>
7<script language ="javascript" src="CreateObject.js"></script>
8</head>
9<body>
10 <form id="form1" runat="server">
11 <div style="text-align: center">
12 <table style=" 420px; height: 256px; text-align: center;" id="TABLE1" onclick="return TABLE1_onclick()">
13
14 <tr>
15 <td style=" 69px; height: 21px; border: 1px; text-align: center;">
16 <asp:Label ID="lblUserName" runat="server" Text="用户名:"></asp:Label></td>
17 <td style=" 69px; height: 21px; border: 1px;">
18 <input id="txtUserName" type="text" onkeyup="CheckName(document.getElementById('txtUserName').value);" /></td>
19 <td>
20 <img id="imgName" src="" /></td>
21 </tr>
22 <tr>
23 <td style=" 69px; height: 21px; border: 1px;">
24 <asp:Label ID="lblUserPwd" runat="server" Text="密码:"></asp:Label></td>
25 <td style=" 69px; height: 21px; border: 1px;">
26 <input id="txtUserPwd" type="text" /></td>
27 <td>
28 </td>
29 </tr>
30 <tr>
31 <td style=" 69px; height: 21px; border: 1px;">
32 <asp:Label ID="lblUserPwdRe" runat="server" Text="重复密码:"></asp:Label></td>
33 <td style=" 69px; height: 21px; border: 1px;">
34 <input id="txtUserPwdRe" type="text" />
35 </td>
36 <td>
37 </td>
38 </tr>
39 <tr>
40 <td colspan="3" style="border-top- 1px; border-left- 1px; border-bottom- 1px;
41 height: 21px; border-right- 1px">
42 <input id="btnOk" style=" 90px" type="button" value="OK" /></td>
43 </tr>
44 </table>
45 </div>
46 </form>
47</body>
48</html>
49
1// JScript 文件
2var xmlHttp;
3
4//检测用户是否存在
5function CheckName(userName)
6{
7 createXMLHTTP();
8 var url="DisposeEvent.aspx?Name="+userName+"&Event=Check";
9 xmlHttp.open("GET",url,true);
10 xmlHttp.onreadystatechange=checkUserName;
11 xmlHttp.send(null);
12}
13
14function createXMLHTTP()
15{
16 if(window.XMLHttpRequest)
17 {
18 xmlHttp = new XMLHttpRequest();
19 }
20 else if(window.ActiveXObject)
21 {
22 try
23 {
24 xmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
25 }
26 catch(e)
27 {}
28
29 try
30 {
31 xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
32 }
33 catch(e)
34 {}
35
36 if(!xmlHttp)
37 {
38 window.alert("不能创建XMLHttpRequest");
39 return false;
40 }
41 }
42}
43
44function checkUserName()
45{
46 if(xmlHttp.readyState == 4)
47 {
48 if(xmlHttp.status==200)
49 {
50 if(xmlHttp.responseText == "true")
51 {
52 document.getElementById("imgName").src="images/true.gif";
53
54 //注册按钮=false
55 document.getElementById("btnOk").disabled = false;
56 }
57 else
58 {
59 document.getElementById("imgName").src="images/flase.gif";
60 document.getElementById("btnOk").disabled = true;
61 }
62 }
63 }
64}
65
66
67//注册新用户
68function regUser()
69{
70 if(document.getElementById("txtUserName").value=="")
71 {
72 alert("对不起,用户名不能为空!");
73 return false;
74 }
75
76 if(document.getElementById("txtUserPwd").value="")
77 {
78 alert("对不起,密码不能为空");
79 return false;
80 }
81
82 var url="DisposeEvent.aspx?Name="+document.getElementById("userName").value+"&Pwd="+document.getElementById("txtUserPwd").value+"&Event=Reg";
83 xmlHttp.open("GET",url,true);
84 xmlHttp.onreadystatechange=regUserInfo;
85 xmlHttp.send(null);
86}
87
88//注册用户回调函数
89function regUserInfo()
90{
91 if(xmlHttp.readyState==4)
92 {
93 if(xmlHttp.status == 200)
94 {
95 if(xmlHttp.responseText=="true")
96 {
97 alert("恭喜,新用户注册成功。");
98 document.getElementById("txtUserName").value="";
99 document.getElementById("txtUserPwd").value="";
100 }
101 else
102 {
103 alert("对不起,注册失败");
104 document.getElementById("txtUserName").value="";
105 document.getElementById("txtUserPwd").value="";
106 }
107 }
108 }
109}
110
111
处理Request的页面(DoEvent.aspx)
1using System;
2using System.Data;
3using System.Configuration;
4using System.Collections;
5using System.Web;
6using System.Web.Security;
7using System.Web.UI;
8using System.Web.UI.WebControls;
9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class DisposeEvent : System.Web.UI.Page
14{
15 protected void Page_Load(object sender, EventArgs e)
16 {
17 User user= new User();
18
19 //是否为执行checkName的方法
20 if (Request.QueryString["Event"].ToString() == "Check")
21 {
22 if (user.checkName(Request.QueryString["Name"].ToString()))
23 {
24 //当数据库已经存在此用户
25 Response.Write("false");
26 Response.End();
27 }
28 else
29 {
30 Response.Write("true");
31 Response.End();
32 }
33 }
34
35 //是否为执行regUser方法
36 if (Request.QueryString["Event"].ToString() == "Reg")
37 {
38 if (user.insertUserInfo(Request.QueryString["Name"].ToString(), Request.QueryString["Pwd"].ToString()))
39 {
40 Response.Write("true");
41 Response.End();
42 }
43 }
44 }
45
46}
47
1using System;
2using System.Data;
3using System.Configuration;
4using System.Collections;
5using System.Web;
6using System.Web.Security;
7using System.Web.UI;
8using System.Web.UI.WebControls;
9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class DisposeEvent : System.Web.UI.Page
14{
15 protected void Page_Load(object sender, EventArgs e)
16 {
17 User user= new User();
18
19 //是否为执行checkName的方法
20 if (Request.QueryString["Event"].ToString() == "Check")
21 {
22 if (user.checkName(Request.QueryString["Name"].ToString()))
23 {
24 //当数据库已经存在此用户
25 Response.Write("false");
26 Response.End();
27 }
28 else
29 {
30 Response.Write("true");
31 Response.End();
32 }
33 }
34
35 //是否为执行regUser方法
36 if (Request.QueryString["Event"].ToString() == "Reg")
37 {
38 if (user.insertUserInfo(Request.QueryString["Name"].ToString(), Request.QueryString["Pwd"].ToString()))
39 {
40 Response.Write("true");
41 Response.End();
42 }
43 }
44 }
45
46}
47
1set ANSI_NULLS ON
2set QUOTED_IDENTIFIER ON
3go
4
5ALTER PROCEDURE [dbo].[checkName]
6 @userName varchar(50)
7AS
8SELECT COUNT(*) FROM UserInfo
9WHERE UserName=@userName
10
2set QUOTED_IDENTIFIER ON
3go
4
5ALTER PROCEDURE [dbo].[checkName]
6 @userName varchar(50)
7AS
8SELECT COUNT(*) FROM UserInfo
9WHERE UserName=@userName
10
1set ANSI_NULLS ON
2set QUOTED_IDENTIFIER ON
3go
4
5ALTER PROCEDURE [dbo].[deleteUser]
6 @userName varchar(50)
7AS
8DELETE FROM UserInfo WHERE UserName=@userName
9return
10
2set QUOTED_IDENTIFIER ON
3go
4
5ALTER PROCEDURE [dbo].[deleteUser]
6 @userName varchar(50)
7AS
8DELETE FROM UserInfo WHERE UserName=@userName
9return
10
insertUserInfo
1 set ANSI_NULLS ON
2 set QUOTED_IDENTIFIER ON
3 go
4
5 ALTER PROCEDURE [dbo].[insertUserInfo]
6 @userName varchar(50),
7 @userPwd varchar(50)
8 AS
9 INSERT INTO UserInfo VALUES(@userName,@userPwd)
10 return
11
12
1 set ANSI_NULLS ON
2 set QUOTED_IDENTIFIER ON
3 go
4
5 ALTER PROCEDURE [dbo].[insertUserInfo]
6 @userName varchar(50),
7 @userPwd varchar(50)
8 AS
9 INSERT INTO UserInfo VALUES(@userName,@userPwd)
10 return
11
12
updateUserInfo
1 set ANSI_NULLS ON
2 set QUOTED_IDENTIFIER ON
3 go
4
5 ALTER PROCEDURE [dbo].[updateUserInfo]
6 @userName varchar(50),
7 @userPwd varchar(50)
8 AS
9 UPDATE UserInfo SET UserPwd=@userPwd
10 WHERE UserName=@userName
11 return
12
13
1 set ANSI_NULLS ON
2 set QUOTED_IDENTIFIER ON
3 go
4
5 ALTER PROCEDURE [dbo].[updateUserInfo]
6 @userName varchar(50),
7 @userPwd varchar(50)
8 AS
9 UPDATE UserInfo SET UserPwd=@userPwd
10 WHERE UserName=@userName
11 return
12
13