1、成績數據庫原理及應用課程設計報告商品銷售管理系統學院：信息工程學院班級： 學號： 姓名： 完成時間： 201 課程設計的任務數據庫原理及應用是計算機及其相關學科的一門重要的學科基礎課程，也是計算機軟件科學與技術、信息科學與技術的重要學科分支。本課程設計旨在通過對一個小型數據庫管理系統（dbms）的綜合設計過程，強化學生對計算機系統軟件的設計能力，提高學生的綜合素質，并通過課程設計進一步加強學生對所學知識的理解，以及對數據庫的全面、深刻認識。具體要求如下：1)了解dbms的設計過程；2)掌握關系型dbms的結構及實現；3)掌握系統程序設計的基礎知識；4)深化理解并掌握數據庫原理及應用課程的相關內

2、容；5)強化軟件開發的團隊意識，提高合作能力。系統需求分析與設計數據流圖er圖數據結構描述商品數據結構：shanidchar6shannamechar8shancountsmailint2shanpricesmailint2factoridchar6公司數據結構:factoridchar6factornamevarchar24factoraddrvarchar24factorphonechar11銷售數據結構：shanidchar6factoridchar6salsecountsmailint2銷售管理系統軟件設計流程圖和功能模塊圖商品信息查詢商品信息錄入銷售信息查詢銷售信息錄入公司信息查詢公

3、司信息錄入程序模塊匯總 商品信息錄入； 商品信息查詢； 公司信息錄入； 公司信息查詢； 銷售信息錄入； 銷售信息查詢；源程序清單主目錄：using system;using system.configuration;using system.data;using system.linq;using system.web;using system.web.security;using system.web.ui;using system.web.ui.htmlcontrols;using system.web.ui.webcontrols;using system.web.ui.webcontr

4、ols.webparts;using system.xml.linq;public partial class _default : system.web.ui.page protected void page_load(object sender, eventargs e) protected void button1_click(object sender, eventargs e) response.redirect("/default2.aspx"); protected void button3_click(object sender, eventargs e)

5、response.redirect("/default3.aspx"); protected void button2_click(object sender, eventargs e) response.redirect("/default4.aspx"); protected void button4_click(object sender, eventargs e) response.redirect("/default6.aspx"); protected void button5_click(object sender, e

6、ventargs e) response.redirect("/default4.aspx"); protected void button6_click(object sender, eventargs e) response.redirect("/default5.aspx"); protected void button7_click(object sender, eventargs e) response.redirect("/default7.aspx"); 1 商品信息錄入；using system;using syste

7、m.collections;using system.configuration;using system.data;using system.linq;using system.web;using system.web.security;using system.web.ui;using system.web.ui.htmlcontrols;using system.web.ui.webcontrols;using system.web.ui.webcontrols.webparts;using system.xml.linq;using system.data.sqlclient;publ

8、ic partial class default2 : system.web.ui.page protected void page_load(object sender, eventargs e) protected void button3_click(object sender, eventargs e) if (shangid.text.trim().length < 1) response.write("<script>window.alert('沒有要刪除的項！')</script>"); return; sqlco

9、nnection con = new sqlconnection("server=localhost;user id=sa;pwd=123456;database=studb"); con.open(); string select = "select count(*) as total from s where shanid="+"'"+ shangid.text.trim()+ "'" sqlcommand cmdsel = new sqlcommand(select, con); sqldat

10、areader dr = cmdsel.executereader(); if (dr.read() if (int.parse(dr"total".tostring() = 0) response.write("<script>window.alert('要刪除的記錄不存在！')</script>"); return; dr.close(); string str = "delete from s where shanid=" + "'" + shangid.tex

11、t.trim() + "'" sqlcommand cmd = new sqlcommand(str, con); cmd.executenonquery(); con.close(); protected void exit_click(object sender, eventargs e) response.redirect ("/default.aspx");protected void insert_click(object sender, eventargs e) sqlconnection con = new sqlconnectio

12、n("server=localhost;uid=sa;pwd=123456;database=studb"); con.open(); string insert = "insert into s(shanid,shanname,shancount,shanprice,factoryid) values(" + "'" + shangid.text.trim() + "'" + "," + "'" + shangname.text.trim() + &

13、quot;'" + "," + shangcount.text.trim() + "," + "'" + shangprice.text.trim() + "'" + "," + "'" + shangaddr.text.trim() + "'" + ")" response.write(insert); sqlcommand cmd1 = new sqlcommand(insert,

14、con); cmd1.executenonquery(); con.close();2 商品信息查詢；using system;using system.collections;using system.configuration;using system.data;using system.linq;using system.web;using system.web.security;using system.web.ui;using system.web.ui.htmlcontrols;using system.web.ui.webcontrols;using system.web.ui.

15、webcontrols.webparts;using system.xml.linq;using system.data.sqlclient;public partial class default3 : system.web.ui.page protected void page_load(object sender, eventargs e) protected void movetofirst_click(object sender, eventargs e) sqlconnection con = new sqlconnection("server=localhost;use

16、r id=sa;pwd=123456;database=studb"); con.open(); string str = "select shanid from s order by shanid asc" sqlcommand cmd = new sqlcommand(str, con); sqldatareader sr = cmd.executereader(); if (sr.read() string student = sr"shanid".tostring(); refresh(student); sr.close(); pri

17、vate void refresh(string shangid) sqlconnection con = new sqlconnection("server=localhost;user id=sa;pwd=123456;database=studb"); con.open(); string str = "select * from s where shanid=" + "'" + shangid.tostring() + "'" sqlcommand cmd = new sqlcommand(

18、str, con); sqldatareader sr = cmd.executereader(); if (sr.read() shangid.text = shangid.tostring(); shangname.text = sr"shanname".tostring(); shangcount.text = sr"shancount".tostring(); shangprice.text = sr"shanprice".tostring(); shangaddr.text = sr"factoryid"

19、.tostring(); protected void movetopre_click(object sender, eventargs e) if (shangid.text.trim().length < 1) response.write("<script>window.alert('請選擇一個當前項！')</script>"); return; string shangid = "" sqlconnection con = new sqlconnection("server=localhos

20、t;user id=sa;pwd=123456;database=studb"); con.open(); string str = "select shanid from s order by shanid asc" sqlcommand cmd = new sqlcommand(str, con); sqldatareader sr = cmd.executereader(); if (sr.read() shangid = sr"shanid".tostring(); sr.close(); if (shangid = shangid.t

21、ext.trim() response.write("<script>window.alert('當前數據項已經是第一個了！')</script>"); return; else string tempstr = "select max(shanid) as maxid from s where shanid<" + "'" + shangid.text.trim() + "'" cmd.commandtext = tempstr; sqldatarea

22、der dr = cmd.executereader(); if (dr.read() string shid = dr"maxid".tostring(); refresh(shid); con.close(); protected void movetonext_click(object sender, eventargs e) if (shangid.text.trim().length < 1) response.write("<script>window.alert('請選擇一個當前項！')</script>

23、"); return; string shangid = "" sqlconnection con = new sqlconnection("server=localhost;user id=sa;pwd=123456;database=studb"); con.open(); string str = "select shanid from s order by shanid desc" sqlcommand cmd = new sqlcommand(str, con); sqldatareader sr = cmd.ex

24、ecutereader(); if (sr.read() shangid = sr"shanid".tostring(); sr.close(); if (shangid = shangid.text.trim() response.write("<script>window.alert('當前數據項已經是最后一個了！')</script>"); return; else string tempstr = "select min(shanid) as maxid from s where shanid&g

25、t;" + "'" + shangid.text.trim() + "'" cmd.commandtext = tempstr; sqldatareader dr = cmd.executereader(); if (dr.read() string shid = dr"maxid".tostring(); refresh(shid); con.close(); protected void movetolast_click(object sender, eventargs e) sqlconnection

26、con = new sqlconnection("server=localhost;user id=sa;pwd=123456;database=studb"); con.open(); string str = "select shanid from s order by shanid desc" sqlcommand cmd = new sqlcommand(str, con); sqldatareader sr = cmd.executereader(); if (sr.read() string shang = sr"shanid&qu

27、ot;.tostring(); refresh(shang); sr.close(); con.close(); protected void keyselect_click(object sender, eventargs e) bool find = false; sqlconnection con = new sqlconnection("server=localhost;user id=sa;pwd=123456;database=studb"); con.open(); string cmdstr = "select * from s" sql

28、dataadapter da = new sqldataadapter(cmdstr, con); dataset ds = new dataset(); da.fill(ds); for (int i = 0; i < ds.tables0.rows.count; i+) for (int j = 0; j < ds.tables0.columns.count; j+) string data = (ds.tables0.rowsij.tostring().trim(); if (data = select.text.trim() shangid.text = ds.tables

29、0.rowsi"shanid".tostring(); shangname.text = ds.tables0.rowsi"shanname".tostring(); shangcount.text = ds.tables0.rowsi"shancount".tostring(); shangprice.text = ds.tables0.rowsi"shanprice".tostring(); shangaddr.text = ds.tables0.rowsi"factoryid".tostr

30、ing(); find = true; if (find = false) response.write("<script>window.alert('沒有相關記錄！')</script>"); con.close(); protected void exit_click(object sender, eventargs e) response.redirect("/default.aspx"); 3 公司信息錄入；using system;using system.collections;using system

31、.configuration;using system.data;using system.linq;using system.web;using system.web.security;using system.web.ui;using system.web.ui.htmlcontrols;using system.web.ui.webcontrols;using system.web.ui.webcontrols.webparts;using system.xml.linq;using system.data.sqlclient;public partial class default4

32、: system.web.ui.page protected void page_load(object sender, eventargs e) protected void insert_click(object sender, eventargs e) sqlconnection con = new sqlconnection("server=localhost;uid=sa;pwd=123456;database=studb"); con.open(); string insert = "insert into factory(factorid,facto

33、rname,factoraddr,factorphone) values(" + "'" + factoryid.text.trim() + "'" + "," + "'" + factoryname.text.trim() + "'" + "," + "'" + factoryaddr.text.trim() + "'" + "," + "'

34、;" + factoryphone.text.trim() + "'" + ")" response.write(insert); sqlcommand cmd1 = new sqlcommand(insert, con); cmd1.executenonquery(); con.close(); protected void delete_click(object sender, eventargs e) if (factoryid.text.trim().length < 1) response.write("<

35、;script>window.alert('沒有要刪除的項！')</script>"); return; sqlconnection con = new sqlconnection("server=localhost;user id=sa;pwd=123456;database=studb"); con.open(); string select = "select count(*) as total from factory where factorid=" + "'" + fac

36、toryid.text.trim() + "'" sqlcommand cmdsel = new sqlcommand(select, con); sqldatareader dr = cmdsel.executereader(); if (dr.read() if (int.parse(dr"total".tostring() = 0) response.write("<script>window.alert('要刪除的記錄不存在！')</script>"); return; dr.c

37、lose(); string str = "delete from factory where factorid=" + "'" + factoryid.text.trim() + "'" sqlcommand cmd = new sqlcommand(str, con); cmd.executenonquery(); con.close(); protected void exit_click(object sender, eventargs e) response.redirect("/default.a

38、spx"); 4 公司信息查詢；using system;using system.collections;using system.configuration;using system.data;using system.linq;using system.web;using system.web.security;using system.web.ui;using system.web.ui.htmlcontrols;using system.web.ui.webcontrols;using system.web.ui.webcontrols.webparts;using sys

39、tem.xml.linq;using system.data.sqlclient;public partial class default5 : system.web.ui.page protected void page_load(object sender, eventargs e) protected void movetofirst_click(object sender, eventargs e) sqlconnection con = new sqlconnection("server=localhost;user id=sa;pwd=123456;database=st

40、udb"); con.open(); string str = "select factorid from factory order by factorid asc" sqlcommand cmd = new sqlcommand(str, con); sqldatareader sr = cmd.executereader(); if (sr.read() string student = sr"factorid".tostring(); refresh(student); sr.close(); private void refresh(

41、string factorid) sqlconnection con = new sqlconnection("server=localhost;user id=sa;pwd=123456;database=studb"); con.open(); string str = "select * from factory where factorid=" + "'" + factorid.tostring() + "'" sqlcommand cmd = new sqlcommand(str, con

42、); sqldatareader sr = cmd.executereader(); if (sr.read() factoryid.text = factorid.tostring(); factoryname.text = sr"factorname".tostring(); factoryaddr.text = sr"factoraddr".tostring(); factoryphone.text = sr"factorphone".tostring(); protected void movetopre_click(obje

43、ct sender, eventargs e) if (factoryid.text.trim().length < 1) response.write("<script>window.alert('請選擇一個當前項！')</script>"); return; string factoryid = "" sqlconnection con = new sqlconnection("server=localhost;user id=sa;pwd=123456;database=studb"

44、); con.open(); string str = "select factorid from factory order by factorid asc" sqlcommand cmd = new sqlcommand(str, con); sqldatareader sr = cmd.executereader(); if (sr.read() factoryid = sr"factorid".tostring(); sr.close(); if (factoryid = factoryid.text.trim() response.write(

45、"<script>window.alert('當前數據項已經是第一個了！')</script>"); return; else string tempstr = "select max(factorid) as maxid from factory where factorid<" + "'" + factoryid.text.trim() + "'" cmd.commandtext = tempstr; sqldatareader dr = cmd.e

46、xecutereader(); if (dr.read() string faid = dr"maxid".tostring(); refresh(faid); con.close(); protected void movetonext_click(object sender, eventargs e) if (factoryid.text.trim().length < 1) response.write("<script>window.alert('請選擇一個當前項！')</script>"); ret

47、urn; string factoryid = "" sqlconnection con = new sqlconnection("server=localhost;user id=sa;pwd=123456;database=studb"); con.open(); string str = "select factorid from factory order by factorid desc" sqlcommand cmd = new sqlcommand(str, con); sqldatareader sr = cmd.executereader(); if (sr.read() factoryid = sr"factorid".tostring(); sr.close(); if (factoryid = factoryid.text.trim() response.write("<script>window.alert('當前數據項已經是最后一個了！')</script