增加添加数据功能
1,创建Add.html页面
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title>添加用户</title>
</head>
<body>
<form method="post" action="AddUserInfo.ashx">
用户名:<input type="text" name="txtName" /><br />
密码:<input type="text" name="txtPwd"/><br />
邮箱:<input type="text" name="txtEmail"/><br />
<input type="submit" value="添加"/><br />
</form>
</body>
</html>
2.在Dal 层中的UserInfoDal.cs文件中添加一个方法
public int AddUserInfo(UserInfo userInfo)
{
string sql = "insert into UserInfo(Name,Password,Email) values(@Name,@Password,@Email)";
SqlParameter[] pars =
{
new SqlParameter("@Name",SqlDbType.NVarChar,32),
new SqlParameter("@Password",SqlDbType.Int),
new SqlParameter("@Email",SqlDbType.NVarChar,32)
};
pars[0].Value = userInfo.Name;
pars[1].Value = userInfo.Password;
pars[2].Value = userInfo.Email;
return SqlHelper.ExecuteNonquery(sql, CommandType.Text,pars);
}
3.在业务逻辑层添加
public bool AddUserInfo(UserInfo userInfo)
{
return UserInfoDal.AddUserInfo(userInfo) > 0;
}
4. 创建一般处理程序
using Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace WebApplication2
{
/// <summary>
/// AddUserInfo 的摘要说明
/// </summary>
public class AddUserInfo : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
string username=context.Request.Form["txtName"];
int userpwd =Convert.ToInt32( context.Request.Form["txtPwd"]);
string useremail = context.Request.Form["txtEmail"];
UserInfo userInfo = new UserInfo();
userInfo.Name = username;
userInfo.Password = userpwd;
userInfo.Email = useremail;
BLL.UserInfoService userInfoService = new BLL.UserInfoService();
if (userInfoService.AddUserInfo(userInfo))
{
context.Response.Redirect("UserInfoList.ashx");
}
else {
context.Response.Redirect("Error.html");
}
}
public bool IsReusable
{
get
{
return false;
}
}
}
}