【正文】 per introduces the use of the popular B / S model developed by a bination of a contract management system. The key technologies: Web site set up by Apache, MySQL building a database strategy, PHP programming and application of indepth analysis. Contract management system was designed with PHP language, smarty templates, and other technology development, in the WindowsXP operating system, Apache server and database system support run. The outset that the purpose of contract management system developed to analyze and explain the system requirements, then the objectoriented model of each module of the system, the system processes, ponents, libraries, databases and coding parts of the analysis and design . The contract management system to input data, delete, modify, query, logs and statistics and other basic functions, the contract for management of small and medium enterprises. Key words: Web， Apache， MySQL， PHP， Contract Management 北京大學(xué) 基于 web 的合同管理系統(tǒng)的設(shè)計(jì)和實(shí)現(xiàn) 第 3 頁(yè) 共 36 頁(yè) 目 錄 ABSTRACT ...................................................................................................................................................2 1．相關(guān)技術(shù) ...................................................................................................................................................4 PHP 介紹 ............................................................................................................................................4 數(shù)據(jù)庫(kù) MYSQL ..................................................................................................................................7 APACHE 介紹 .....................................................................................................................................8 B/S 架構(gòu)介紹 ................................................................................................................................ 10 2． 系統(tǒng)分析與設(shè)計(jì) ................................................................................................................................. 12 系統(tǒng)的功能設(shè)計(jì) .......................................................................................................................... 12 系統(tǒng)的流程設(shè)計(jì) .......................................................................................................................... 12 系統(tǒng)流程圖和功能圖 ................................................................................................................. 14 系統(tǒng)功能結(jié)構(gòu)分析 ..................................................................................................................... 15 添加合同 .............................................................................................................................. 15 修改合同 .............................................................................................................................. 15 停用 /啟用合同 ................................................................................................................... 15 打印合同 ............................................................................................................................... 16 查看日志 ............................................................................................................................... 16 數(shù)據(jù)庫(kù)設(shè)計(jì) ................................................................................................................................... 16 數(shù)據(jù)庫(kù)的設(shè)計(jì) ...................................................................................................................... 17 合同信息表 contract_order 的設(shè)計(jì) ........................................................................... 17 合同日志表 log_order 的設(shè)計(jì) ...................................................................................... 18 管理員表 member 的設(shè)計(jì) .................................................................................................. 18 合同信息表和合同日志表的關(guān)系 ................................................................................ 19 3．系統(tǒng)實(shí)現(xiàn) .............................................................................................................................................. 19 系統(tǒng)運(yùn)用的技術(shù) ........................................................................................................................... 19 JQUERY 的 Ajax 技術(shù) ......................................................................................................... 19 PHP+SMARTY 讓你的開(kāi)發(fā)更簡(jiǎn)單 ................................................................................... 21 .............................................................................................................................. 22 用戶管理 ............................................................................................................................... 22 合同管理 .............................................................................................................................. 23 系統(tǒng)前臺(tái)頁(yè)面 ............................................................................................................................... 29 合同列表頁(yè) ..................................................................................... 30 合同詳細(xì)頁(yè) action 為 view ................................................ 30 合同搜索頁(yè) ................................................................................ 31 束語(yǔ) ....................................................................................................................................................... 33 致 謝 ................................................................................................................................