商城用戶與商品管理.doc

第4章 商城用戶與商品管理實(shí)訓(xùn)報(bào)告實(shí)訓(xùn)名稱：商城用戶與商品管理實(shí)訓(xùn)人： 學(xué)號(hào)：班級(jí)： 指導(dǎo)教師： 同組學(xué)生姓名 實(shí)驗(yàn)地點(diǎn)： 創(chuàng)新樓 實(shí)驗(yàn)日期： 2011 年 10 月 20 日一、實(shí)訓(xùn)目的：1. 掌握數(shù)據(jù)庫(kù)建立方法、數(shù)據(jù)表的建立技巧、配置web.config連接到數(shù)據(jù)庫(kù)，為后面的返問(wèn)操作打好基礎(chǔ)；2. 熟悉數(shù)據(jù)庫(kù)返問(wèn)基礎(chǔ)操作，建立數(shù)據(jù)庫(kù)的類，掌握數(shù)庫(kù)操作類的應(yīng)用：商城用戶重名檢測(cè)、用戶登錄和用戶資料修改；3. 掌握web用戶控件的建立和調(diào)用方法；4. 掌握通過(guò)？查詢字符串方式在網(wǎng)頁(yè)間傳遞參數(shù)與接收參數(shù)的方法，熟悉用Repeater方式顯示查詢結(jié)果。二、實(shí)訓(xùn)內(nèi)容： 1、建立一個(gè)簡(jiǎn)單的用戶管理系統(tǒng)，其中具有簡(jiǎn)單的添加、查詢刪除和修改的功能，； 2、數(shù)據(jù)庫(kù)操作類的建立，在沾點(diǎn)內(nèi)新建類文件DbManger.cs； 3、商城用戶重名檢測(cè)與注冊(cè)，就是當(dāng)輸入用戶名已經(jīng)存在時(shí)單擊檢測(cè)按鈕后會(huì)彈出提示框說(shuō)：“用戶名已經(jīng)被人使用，請(qǐng)用其用戶名注冊(cè)”，否則，輸入用戶名沒(méi)有重復(fù)，則會(huì)彈出“注冊(cè)成功的提示。 4、商城用戶登錄，用戶輸入用戶名和密碼，如果正確就轉(zhuǎn)manager.aspx，否則提示用戶名或密碼錯(cuò)誤； 5、建立一個(gè)search0.aspx文件，其中有一個(gè)“搜索”文本框，輸要查詢的關(guān)鍵字，就可能在search.aspx中顯示查詢結(jié)果； 6、自定義分頁(yè)顯示。三、實(shí)訓(xùn)的相關(guān)代碼：1、建立一個(gè)簡(jiǎn)單的用戶管理系統(tǒng)的關(guān)鍵性代碼如下： 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ù)庫(kù)操作類的建立的關(guān)鍵性代碼如下：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、商城用戶重名檢測(cè)與注冊(cè)的關(guān)鍵性代碼如下：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(用戶名已被人使用，請(qǐng)用其他用戶名注冊(cè)); else Response.Write(alert(恭喜你，可以使用這個(gè)用戶名注冊(cè)); 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(用戶名已被人使用，請(qǐng)用其他用戶名注冊(cè)); 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(照片文件類型不對(duì)); strSQL = insert into user(用戶名,密碼,Email,收件人姓名,通訊地址,電話,郵編,性別,學(xué)歷,關(guān)注產(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(注冊(cè)成功！);4、商城用戶登錄的關(guān)鍵性代碼如下：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(用戶名或密碼錯(cuò)誤！); protected void btnzc_Click(object sender, EventArgs e) Response.Redirect(register.aspx);5、建立一個(gè)search0.aspx文件的關(guān)鍵性代碼如下：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、自定義分頁(yè)顯示的關(guān)鍵性代碼如下：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() + 條記錄 當(dāng)前是第 + iCurpage.ToString() + / + iMaxPage.ToString() + 頁(yè); if (iCurpage != 1