public class RegDao
{
public RegDao()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
private static string UserId = "@UserId";
private static string UserPassword= "@UserPassword";
private static string Email = "@Email";
private static string City = "@City";
private static string ZipCode = "@ZipCode";
private static string UserDate = "@UserDate";
//执行SQL语句
private static string InsertINTO_Userinfo="insert into Userinfo Values(@UserId,@UserPassword,@Email,@City,@ZipCode,@UserDate)";
private static bool AddUserinfo(Reg user)//这儿的括号里面的表示什么?(对象名 类名)传到AddUserinfo这个私有静态方法。对象名要写对,类名可以任意取。
{
SqlParameter[] parms = new SqlParameter[]{
new SqlParameter(UserId,SqlDbType.Char,50),//以后数据库最好都写成varchar类型,长度给长一些。
new SqlParameter(UserPassword,SqlDbType.Char,16),
new SqlParameter(Email,SqlDbType.NVarChar,40),
new SqlParameter(City,SqlDbType.Char,15),
new SqlParameter(ZipCode,SqlDbType.Char,10),
new SqlParameter(UserDate,SqlDbType.DateTime,8)};
parms[0].Value=user.UserId;
parms[1].Value=user.UserPassword;
parms[2].Value=user.Email;
parms[3].Value=user.City;
parms[4].Value=user.ZipCode;
parms[5].Value=user.UserDate;
//获取连接字符串,插入数据到SQL数据库
int tag = SqlHelper.SqlHelpDao.ExecuteNonQuery(GetConnectString.ConnectionString, CommandType.Text, InsertINTO_Userinfo, parms);
if (tag > 0)
{
return true;
}
return false;
}
}
protected void regBtn_Click(object sender, EventArgs e)
{
Reg user = new Reg();
user.UserId = this.UserId.Text.Trim();
user.UserPassword = this.UserPassword.Text.Trim();
user.Email = this.Email.Text.Trim();
user.City = this.City.Text.Trim();
user.ZipCode = this.Zipcode.Text.Trim();
//if (RegDao.AddUserinfo(User) == true)
//{
// Response.Write("<script>alert('注册成功')</script>");
//}
}