商城用戶與商品管理.doc

第4章 商城用戶與商品管理實訓報告實訓名稱：商城用戶與商品管理實訓人： 學號：班級： 指導教師： 同組學生姓名 實驗地點： 創(chuàng)新樓 實驗日期： 2011 年 10 月 20 日一、實訓目的：1. 掌握數(shù)據(jù)庫建立方法、數(shù)據(jù)表的建立技巧、配置web.config連接到數(shù)據(jù)庫，為后面的返問操作打好基礎；2. 熟悉數(shù)據(jù)庫返問基礎操作，建立數(shù)據(jù)庫的類，掌握數(shù)庫操作類的應用：商城用戶重名檢測、用戶登錄和用戶資料修改；3. 掌握web用戶控件的建立和調(diào)用方法；4. 掌握通過？查詢字符串方式在網(wǎng)頁間傳遞參數(shù)與接收參數(shù)的方法，熟悉用Repeater方式顯示查詢結(jié)果。二、實訓內(nèi)容： 1、建立一個簡單的用戶管理系統(tǒng)，其中具有簡單的添加、查詢刪除和修改的功能，； 2、數(shù)據(jù)庫操作類的建立，在沾點內(nèi)新建類文件DbManger.cs； 3、商城用戶重名檢測與注冊，就是當輸入用戶名已經(jīng)存在時單擊檢測按鈕后會彈出提示框說：“用戶名已經(jīng)被人使用，請用其用戶名注冊”，否則，輸入用戶名沒有重復，則會彈出“注冊成功的提示。 4、商城用戶登錄，用戶輸入用戶名和密碼，如果正確就轉(zhuǎn)manager.aspx，否則提示用戶名或密碼錯誤； 5、建立一個search0.aspx文件，其中有一個“搜索”文本框，輸要查詢的關鍵字，就可能在search.aspx中顯示查詢結(jié)果； 6、自定義分頁顯示。三、實訓的相關代碼：1、建立一個簡單的用戶管理系統(tǒng)的關鍵性代碼如下： 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、數(shù)據(jù)庫操作類的建立的關鍵性代碼如下：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,收件人姓名,通訊地址,電話,郵編,性別,學歷,關注產(chǎn)品,照片,年齡)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