【正文】 ，因此開發(fā)商品進(jìn)銷存系統(tǒng)的技術(shù)是可行的。 8)如果使用事務(wù)，根據(jù)前面對數(shù)據(jù)庫操作的成功與否決定是否接受事務(wù)。 3）組織一條 SQL 語句，此 SQL 語句既可以進(jìn)行插入 、修改和刪除等任何數(shù)據(jù)庫操作，只要 4）數(shù)據(jù)庫建立連接時所使用的用戶有足夠的權(quán)限。 在一 個打開的 Visual 的工程中，選擇【工程】 → 【引用】菜單命令，出現(xiàn)引用對話框，在“可引用”列表框中選擇“ Microsoft ActiveX Date Objects Library”選項(xiàng)，單擊【確定】按鈕。這樣設(shè)計使得程序非常的清晰，易于維護(hù)和調(diào)試。 選擇【工程】 → 【屬性】菜單命令，打開‘工程屬性’對話框，在工程類型中顯示“ ActiveX DLL”項(xiàng)，啟動對象選擇“ Sub Main”。業(yè)務(wù)層接受來自. . 數(shù)據(jù)存儲層的數(shù)據(jù)，封裝成類的形式返回給用戶界面。 系統(tǒng)開發(fā)關(guān)鍵技術(shù)介紹 三層體系結(jié)構(gòu) 傳統(tǒng)的兩層 C/S 架構(gòu)中，客戶端與數(shù)據(jù)庫完全分開，把大量的數(shù)據(jù)訪問規(guī)則、業(yè)務(wù)規(guī)則及合法性校驗(yàn)等服務(wù)集成到客戶端應(yīng)用程序。 2）數(shù)據(jù)存儲安全、可靠，信息分類清晰，準(zhǔn)確。但是目前各個城市的小商店仍沿用傳統(tǒng)的人工方式管理商品的模式，人工方式管理商品存在著許多缺點(diǎn)，如商品進(jìn)、出貨信息的維護(hù)和修改繁瑣，收款結(jié)算速度慢，容易出現(xiàn)營業(yè)差錯，不宜進(jìn)行商品調(diào)價，盤點(diǎn)效率低，商品的進(jìn)、銷、存等決策以經(jīng)驗(yàn)為主，缺乏實(shí)時分析功能等等，人工方式管理商品給商店的管理者的工作帶來很大的麻煩。 關(guān)鍵字 ： 數(shù)據(jù)庫；商品管理；窗體 . . The desingn and implementation of management information system for shops stock goods ZHANG Cheng zhen (information management and information system, School of information science and technology, Gansu Agricultural University, Gansu Lanzhou, 730070) Abstract: Based on the paper analysis of small shops Invoicing business processes , it puts forward the small store management system of user needs and functional requirements, and with Visual Basic and SQL for the development tool, adopt three layer architecture development of small shops Invoicing management system. The system includes 8 function modules: user management, supplier management, types of goods, purchase management, sales management, inventory management, loss report and statistics system has good security, maintainability, reusability and easy operation. After sales, the users can accurately control the inventory in real time , speed up the turnover effectively , reduce labor intensity and improve the quality of service. Key words: database。. . 本科畢業(yè)論文 題 目 小型商店 進(jìn)銷存管理系統(tǒng)的 設(shè)計 與 開發(fā) 學(xué) 院 信息科學(xué)技術(shù)學(xué)院 專 業(yè) 信息管理與信息系統(tǒng) 畢業(yè)屆別 2020 屆 姓 名 張 成 珍 指導(dǎo)教師 李 宇 泊 職 稱 講 師 甘肅農(nóng)業(yè)大學(xué)教務(wù)處制 二 〇 一 三年五月 . . 目 錄 摘要 ............................................................................... 1 關(guān)鍵字 ............................................................................. 1 Abstract........................................................................... 2 Key words .......................................................................... 2 ............................................................................. 3 ................................................................... 3 ................................................................... 3 ........................................................ 3 .......................................................... 3 ............................................................ 4 ADO操縱數(shù)據(jù)庫 .................................................... 4 ......................................................................... 5 ............................................ 5 ............................................................... 6 ........................................................ 6 .......................................................... 6 ..................................................................... 7 ............................................................... 7 ............................................................ 8 ............................................................... 9 ............................................................. 10 .................................................................. 12 .............................................................. 12 ....................................................... 12 ....................................................... 13 ........................................................... 14 ................................................... 14 ..................................................... 14 ............................................. 15 .................................................................. 15 ......................................... 15 ......................................................... 15 ....................................................... 16 ............................................................. 17 ......................................................... 17 ................................................... 18 .............................................................. 19 ................................................... 19 . . ................................................... 20 ............................................................. 21 ...................................................................... 21 .............................................................. 22 .............................................................. 22 ................................................................ 22 ............................................................................ 22 參考文獻(xiàn) .......................................................................... 24 致謝 .............................................................................. 25 附錄 .............................................................................. 26