商城用户与商品管理.doc

第4章 商城用户与商品管理实训报告实训名称：商城用户与商品管理实训人： 学号：班级： 指导教师： 同组学生姓名 实验地点： 创新楼 实验日期： 2011 年 10 月 20 日一、实训目的：1. 掌握数据库建立方法、数据表的建立技巧、配置web.config连接到数据库，为后面的返问操作打好基础；2. 熟悉数据库返问基础操作，建立数据库的类，掌握数库操作类的应用：商城用户重名检测、用户登录和用户资料修改；3. 掌握web用户控件的建立和调用方法；4. 掌握通过？查询字符串方式在网页间传递参数与接收参数的方法，熟悉用Repeater方式显示查询结果。二、实训内容： 1、建立一个简单的用户管理系统，其中具有简单的添加、查询删除和修改的功能，； 2、数据库操作类的建立，在沾点内新建类文件DbManger.cs； 3、商城用户重名检测与注册，就是当输入用户名已经存在时单击检测按钮后会弹出提示框说：“用户名已经被人使用，请用其用户名注册”，否则，输入用户名没有重复，则会弹出“注册成功的提示。 4、商城用户登录，用户输入用户名和密码，如果正确就转manager.aspx，否则提示用户名或密码错误； 5、建立一个search0.aspx文件，其中有一个“搜索”文本框，输要查询的关键字，就可能在search.aspx中显示查询结果； 6、自定义分页显示。三、实训的相关代码：1、建立一个简单的用户管理系统的关键性代码如下： ublic partial class member_manager : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void btnDelete_Click(object sender, EventArgs e) string strSQL = DELETE FROM userWHERE 用户名=july; DbManger.ExecuteNonQuery(strSQL); Label1.Text = 删除成功！; protected void btnUpdate_Click1(object sender, EventArgs e) string strSQL = UPDATE user SET 密码=456WHERE 用户名=有天; DbManger.ExecuteNonQuery(strSQL); Label1.Text = 修改成功！; protected void btnAdd_Click1(object sender, EventArgs e) string strSQL = INSERT INTO user(用户名,密码,通讯地址,电话)VALUES(july,456,北京,137591234556); DbManger.ExecuteNonQuery(strSQL); Label1.Text = 添加成功！; protected void btnSelect_Click(object sender, EventArgs e) string strSQL =SELECT * FROM user; GridView1.DataSource = DbManger.ExecuteQuery(strSQL); GridView1.DataBind(); 2、数据库操作类的建立的关键性代码如下：public static DataTable ExecuteQuery(string strSQL) string ConnectionString = ConfigurationManager.ConnectionStringsaccessconn.ConnectionString; OleDbConnection conn = new OleDbConnection(ConnectionString); try OleDbDataAdapter adapter = new OleDbDataAdapter(strSQL, conn); DataSet ds = new DataSet(); adapter.Fill(ds); return ds.Tables0; finally if (conn.State = ConnectionState.Open) conn.Close(); public static int ExecuteNonQuery(string strSQL) string ConnectionString = ConfigurationManager.ConnectionStringsaccessconn.ConnectionString; OleDbConnection conn = new OleDbConnection(ConnectionString); conn.Open(); try OleDbCommand cmd = new OleDbCommand(strSQL, conn); return (cmd.ExecuteNonQuery(); finally if (conn.State = ConnectionState .Open ) conn.Close(); public static object ExecuteScalar(string strSQL) string ConnectionString = ConfigurationManager.ConnectionStringsaccessconn.ConnectionString; OleDbConnection conn = new OleDbConnection(ConnectionString); conn.Open(); try OleDbCommand cmd = new OleDbCommand(); cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = strSQL; return cmd.ExecuteScalar(); finally if (conn.State = ConnectionState.Open) conn.Close(); 3、商城用户重名检测与注册的关键性代码如下：protected void Button2_Click(object sender, EventArgs e) string strSQL = select * from userwhere 用户名 = + TxtName.Text + ; if (DbManger.ExecuteQuery(strSQL).Rows.Count 0) Response.Write(alert(用户名已被人使用，请用其他用户名注册); else Response.Write(alert(恭喜你，可以使用这个用户名注册); protected void Button1_Click(object sender, EventArgs e) string strSQL = select * from user where 用户名 = + TxtName.Text + ; if (DbManger.ExecuteQuery(strSQL).Rows.Count 0) Response.Write(alert(用户名已被人使用，请用其他用户名注册); Response.Write(history.go(-1); string strCategory = ; for (int i = 0; i chkCategory.Items.Count; i+) if (chkCategory.Itemsi.Selected) strCategory = strCategory + chkCategory.Itemsi.Text + ; string strFileName = ; if (FileUpload1.HasFile) string strType = FileUpload1.PostedFile.ContentType; if (strType = image/bmp | strType = image/pjpeg | strType = image/gif | strType = image/png) strFileName = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString(); FileUpload1.SaveAs(Server.MapPath(images/ + strFileName + .jpg); Image1.ImageUrl = images/ + strFileName + .jpg; else Response.Write(alert(照片文件类型不对); strSQL = insert into user(用户名,密码,Email,收件人姓名,通讯地址,电话,邮编,性别,学历,关注产品,照片,年龄)values( + TxtName.Text + , + TxtPwd.Text + , + TxtEmail.Text + , + TxtMailName.Text + , + TxtAddress.Text + , + TxtTel.Text + , + TxtCode.Text + , + radSex.SelectedValue.ToString() + , + drpDiploma.Text + , + strCategory + , + strFileName + , + txtAge.Text + ); if (DbManger.ExecuteNonQuery(strSQL) 0) Response.Write(alert(注册成功！);4、商城用户登录的关键性代码如下：protected void btnLogin_Click(object sender, EventArgs e) string strSQL=SELECT * FROM userWHERE 用户名=+txtName .Text +AND 密码=+txtPwd .Text +; DataTable dt = DbManger.ExecuteQuery(strSQL); if (dt.Rows.Count 0) Sessionname = txtName.Text; Response.Redirect(member_manager.aspx); else Response.Write(alert(用户名或密码错误！); protected void btnzc_Click(object sender, EventArgs e) Response.Redirect(register.aspx);5、建立一个search0.aspx文件的关键性代码如下：protected void ImageButton1_Click(object sender, ImageClickEventArgs e) Response.Redirect(search1.aspx?proName= + TextBox1.Text + );protected void Page_Load(object sender, EventArgs e) string strSQL = select * from product where productName like % + Request.QueryStringproName + %; GridView1.DataSource = DbManger.ExecuteQuery(strSQL); GridView1.DataBind(); 6、自定义分页显示的关键性代码如下：protected void Page_Load(object sender, EventArgs e) int iPageSize = 5; int iCurpage; int iMaxPage = 1; string sql = ; if (Request.QueryStringpage != ) iCurpage = Convert.ToInt32(Request.QueryStringpage); else iCurpage = 1; string sqlstr = select count(*) from product; int intTotalRec = Convert.ToInt32(DbManger.ExecuteScalar(sqlstr); if (intTotalRec % iPageSize = 0) iMaxPage = intTotalRec / iPageSize; else iMaxPage = intTotalRec / iPageSize + 1; if (iMaxPage = 0) iMaxPage = 1; if (iCurpage iMaxPage) iCurpage = iMaxPage; if (intTotalRec != 0) if (iCurpage = 1) sql = select top + iPageSize + * from product order by bh; else sql = select top + iPageSize + * from product where bh not in(select top + (iCurpage - 1) * iPageSize + bh from product order by bh) order by bh; Repeater1.DataSource = DbManger.ExecuteQuery(sql); Repeater1.DataBind(); lblTotal.Text = 共有 + intTotalRec.ToString() + 条记录 当前是第 + iCurpage.ToString() + / + iMaxPage.ToString() + 页; if (iCurpage != 1