【正文】 I 摘要 MIS 系統(tǒng)已經(jīng)在各行各業(yè)得到了廣泛的運(yùn)用，取得了良好的經(jīng)濟(jì)與管理效益，同時(shí)，企業(yè)管理的信息化是現(xiàn)代成功企業(yè)的標(biāo)志。因此，對(duì)企業(yè)管理信息系統(tǒng)的研究具有良好的實(shí)際運(yùn)用價(jià)值。本課題針對(duì)制藥企業(yè)的情況，設(shè)計(jì)開發(fā)了一個(gè)具有基本功能的“進(jìn)銷存信息管理系統(tǒng)”，實(shí)現(xiàn)企業(yè)信息管理的現(xiàn)代化。該系統(tǒng)采用 B/S 結(jié)構(gòu)，基于 WEB 方式， 具有企業(yè)產(chǎn)品、原料的進(jìn)銷、庫(kù)存管理等 操作。系統(tǒng)操作簡(jiǎn)便、界面友好、靈活實(shí)用、安全穩(wěn)定，基本符合制藥企業(yè)進(jìn)銷存信息管理的要求。 關(guān)鍵詞 ：進(jìn)銷存管理系統(tǒng)，制藥企業(yè)， JSP， SQL Server2021 I ABSTRACT The MIS system has already got an extensive usage in every trade, obtained good economy and the performance of management, in the meantime, the business enterprise manage of informationbased is the marking of modern and successful business enterprise. Therefore manage the research of information system to have good actual usage value to the business enterprise. This topic aims at a circumstance of make the medicine business enterprise and the design developped a enter to sell to save an information management system which has basic function and carry out the modernization of management of the business enterprise information. That system adoption B/S structure, according to the WEB method, have an enter of business enterprise product, raw material to sell, stock management etc. operation. The system operation is simple, interface amity, vivid and practical, the safety be stable, basic match to make a medicine business enterprise into sell a request of save the information management. Keywords: ERP , pharmacy corporation, JSP, SQL Server2021 II 目錄 摘要 .................................................................................................................................... I ABSTRACT ....................................................................................................................... I 第 1 章 緒論 ..................................................................................................................... 1 背景 ........................................................................................................................ 1 研究?jī)?nèi)容 ................................................................................................................ 2 第 2 章 需求分析 ............................................................................................................. 3 調(diào)查分析 ................................................................................................................. 3 生產(chǎn)管理 .......................................................................................................... 3 銷售業(yè)務(wù) .......................................................................................................... 3 庫(kù)存管理 .......................................................................................................... 3 往來(lái)管理 .......................................................................................................... 4 存在的問題 ............................................................................................................. 4 生產(chǎn)管理主要問題 .......................................................................................... 4 藥品銷售主要問題 .......................................................................................... 4 庫(kù)存管理主要問題 .......................................................................................... 5 往來(lái)管理主要問題 .......................................................................................... 5 系統(tǒng)要求 ................................................................................................................ 5 生產(chǎn)管理 .......................................................................................................... 5 基礎(chǔ)信息管理 .................................................................................................. 6 銷售管理 .......................................................................................................... 6 庫(kù)存管理 .......................................................................................................... 6 往來(lái)管理 .......................................................................................................... 7 查詢統(tǒng)計(jì)管理 .................................................................................................. 7 系統(tǒng)設(shè)置 .......................................................................................................... 7 可行性分析 ............................................................................................................ 7 本章小結(jié) ................................................................................................................ 8 III 第 3 章 總體設(shè)計(jì) ............................................................................................................. 9 項(xiàng)目規(guī)劃 ................................................................................................................ 9 系統(tǒng)功能結(jié)構(gòu)圖及流程圖 .................................................................................. 10 本章小結(jié) .............................................................................................................. 12 第 4 章 系統(tǒng)設(shè)計(jì) ........................................................................................................... 13 設(shè)計(jì)目標(biāo) .............................................................................................................. 13 開發(fā)及運(yùn)行環(huán)境 .................................................................................................. 13 數(shù)據(jù)庫(kù)設(shè)計(jì) .......................................................................................................... 14 數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì) .................................................................................... 14 數(shù)據(jù)庫(kù)表的設(shè)計(jì) ............................................................................................ 19 本章小結(jié) .............................................................................................................. 24 第 5 章 程序編寫 ................