數(shù)據(jù)庫(kù)課程設(shè)計(jì)報(bào)告-商品庫(kù)存管理系統(tǒng)

參考文獻(xiàn)參考文獻(xiàn)[1]王珊，薩師煊.數(shù)據(jù)庫(kù)系統(tǒng)概論[M],北京：高等教育出版社，2002[2]徐聰蔥,ASP.Net編程從入門(mén)到實(shí)踐[M],北京:清華大學(xué)出版社,2010[3]陳華,Ajax從入門(mén)到精通[M],北京:清華大學(xué)出版社,2008[4]王山等,.Net網(wǎng)站開(kāi)發(fā)典型模塊與實(shí)例精講[M],北京:電子工業(yè)出版社，2006[5]張小豪,軟件工程導(dǎo)論[M],北京:清華大學(xué)出版社,2003沈陽(yáng)航空航天大學(xué)課程設(shè)計(jì)報(bào)告附錄附錄（程序清單）Dbhelper類(lèi)usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Collections;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Configuration;namespaceinventory{classDbhelper{publicstaticstringconnectionString="DataSource=.\\sqlexpress;InitialCatalog=inventory;UserId=sa;Password=123456";#region通用方法//數(shù)據(jù)連接池privateSqlConnectioncon;//////返回?cái)?shù)據(jù)庫(kù)連接字符串//////publicstaticStringGetSqlConnection(){Stringconn=connectionString;returnconn;}#endregion#region執(zhí)行sql字符串//////執(zhí)行不帶參數(shù)的SQL語(yǔ)句/////////publicstaticintExecuteSql(StringSqlstr){StringConnStr=GetSqlConnection();using(SqlConnectionconn=newSqlConnection(ConnStr)){SqlCommandcmd=newSqlCommand();cmd.Connection=conn;cmd.CommandText=Sqlstr;conn.Open();intnum=cmd.ExecuteNonQuery();conn.Close();returnnum;}}//////執(zhí)行帶參數(shù)的SQL語(yǔ)句//////SQL語(yǔ)句///參數(shù)對(duì)象數(shù)組///publicstaticintExecuteSql(StringSqlstr,SqlParameter[]param){StringConnStr=GetSqlConnection();using(SqlConnectionconn=newSqlConnection(ConnStr)){SqlCommandcmd=newSqlCommand();cmd.Connection=conn;cmd.CommandText=Sqlstr;cmd.Parameters.AddRange(param);conn.Open();intnum=cmd.ExecuteNonQuery();conn.Close();returnnum;}}//////返回DataReader/////////publicstaticSqlDataReaderExecuteReader(StringSqlstr){StringConnStr=GetSqlConnection();SqlConnectionconn=newSqlConnection(ConnStr);//返回DataReader時(shí),是不可以用using()的try{SqlCommandcmd=newSqlCommand();cmd.Connection=conn;cmd.CommandText=Sqlstr;conn.Open();returncmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);//關(guān)閉關(guān)聯(lián)的Connection}catch//(Exceptionex){returnnull;}}//////執(zhí)行SQL語(yǔ)句并返回?cái)?shù)據(jù)表//////SQL語(yǔ)句///publicstaticDataTableExecuteDt(StringSqlstr){StringConnStr=GetSqlConnection();using(SqlConnectionconn=newSqlConnection(ConnStr)){SqlDataAdapterda=newSqlDataAdapter(Sqlstr,conn);DataTabledt=newDataTable();conn.Open();da.Fill(dt);conn.Close();returndt;}}//////執(zhí)行SQL語(yǔ)句并返回DataSet//////SQL語(yǔ)句///publicstaticDataSetExecuteDs(StringSqlstr){StringConnStr=GetSqlConnection();using(SqlConnectionconn=newSqlConnection(ConnStr)){SqlDataAdapterda=newSqlDataAdapter(Sqlstr,conn);DataSetds=newDataSet();conn.Open();da.Fill(ds);conn.Close();returnds;}}#endregion#region數(shù)據(jù)庫(kù)連接和關(guān)閉//////打開(kāi)連接池///privatevoidOpen(){//打開(kāi)連接池if(con==null){//這里不僅需要usingSystem.Configuration;還要在引用目錄里添加con=newSqlConnection(GetSqlConnection());con.Open();}}//////關(guān)閉連接池///publicvoidClose(){if(con!=null)con.Close();}//////釋放連接池///publicvoidDispose(){//確定連接已關(guān)閉if(con!=null){con.Dispose();con=null;}}#endregion}}商品信息添加界面代碼usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;namespaceinventory{publicpartialclassaddGoods:Form{publicaddGoods(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){stringmingcheng,changzhi,dianhua,scchengjia,leibie,pinpai,jiage;jiage=textBox6.Text.Trim();try{floatjia=float.Parse(jiage);}catch(System.Exceptioned){MessageBox.Show("您輸入的價(jià)格有誤","錯(cuò)誤");return;}mingcheng=textBox1.Text.Trim();leibie=comboBox1.Text.Trim();changzhi=textBox4.Text.Trim();dianhua=textBox5.Text.Trim();scchengjia=textBox3.Text.Trim();pinpai=textBox2.Text.Trim();stringsql=string.Format("insertintogoodsvalues('{0}','{1}','{2}','{3}','{4}','{5}',{6},0)",mingcheng,leibie,pinpai,scchengjia,changzhi,dianhua,jiage);try{intresint=0;resint=Dbhelper.ExecuteSql(sql);if(resint==0){MessageBox.Show("產(chǎn)品信息未存儲(chǔ)請(qǐng)您核對(duì)相關(guān)信息","警告");}else{MessageBox.Show("產(chǎn)品信息已成功保存","提示");}}catch(System.Exceptionfe){MessageBox.Show("系統(tǒng)發(fā)生異常，請(qǐng)聯(lián)系管理員","