[论文精品]高校药房管理系统

A2A3A2课程设计（实训）报告系部_信息工程系_专业_计算机信息管理_班级学号姓名_课题高校药房管理系统指导教师_报告成绩_日期2011年11月5日A2A4A2摘要A0A1A5A6A7A8A9A10A11A12A13A14A15A16A17A18A19A20A21A22A23A24A25A26A27A28A29A30A31A32A33A34A35A36A37A38A34A39A40A41A38A34A42A43A44A45A46A47A48A49A50A51A12A52A53A37A38A54A55A56A37A38A57A17A58A59A49A59A36A60A61A62A63A64A13A14A12A41A38A34A65A66A5A18A19A20A67A25A26A28A29A13A14A37A38A68A69A12A70A71A17A18A19A20A12A72A73A74A41A58A29A75A28A76A77A78A48A49A13A14A37A38A17A79A28A18A19A20A48A49A13A14A80A81A34A63A82A83A84A85A86A87A88A89A34A90A91A73A73A12A83A84A85A92A93A94A95A17A96A92A97A29A98A99A12A13A14A37A38A34A18A19A20A77A78A100A101A10A102A76A12A103A104A95A17A18A19A20A48A49A13A14A37A38A105A13A14A37A38A68A69A12A64A10A106A107A108A109A34A68A69A12A64A10A5A68A69A37A38A12A110A83A17A111A68A69A112A5A113A85A37A38A74A114A115A13A14A90A116A18A12A17A58A117A118A114A119A119A120A121A122A34A123A124A125A73A34A46A110A12A126A127A41A38A128A129A86A130A87A34A86A87A131A73A34A132A133A89A84A34A132A133A134A135A63A136A137A138A17A65A23A24A63A77A139A27A15A140A10A11A12A128A141A34A142A37A38A12A143A144A145A146A34A97A37A38A147A97A148A149A150A122A12A63A151A34A152A153A154A77A155A156A6A157A158A159A34A160A63A161A162A163A164A165A166A167A17A168A46A34A169A170A171A107A172A128A6A173A50A51A174A28A12A114A119A37A38A68A69A17A90A65A6A173A12A114A115A37A38A68A69A79A28A175A145A34A88A89A84A34A9A144A176A34A135A177A151A174A28A178A179A138A17A111A68A69A5A180A181A182A183A184A180A185A186A130A87A68A69A187A34A46A60A39A188A12A189A190A191A192A193A113A64A10A86A194A145A174A195A12A17A6A7A74A12A114A115A37A38A68A69A196A197A128A77A78A198A199A178A200A201A6A157A202A111A12A126A127A203A204A34A205A206A111A68A69A60A12A114A119A203A204A178A199A207A203A204A34A208A147A13A14A34A97A29A65A157A203A204A178A126A127A77A177A151A209A48A49A137A210A54A179A138A178A211A212A17A92A213A34A114A115A37A38A68A69A128A141A77A78A48A49A177A151A209A114A115A37A38A17A172A128A77A78A114A119A214A215A34A65A5A202A111A12A128A216A217A77A17A113A85A177A151A37A38A147A37A38A126A127A34A152A128A77A174A195A97A59A120A126A127A12A69A18A34A206A69A18A23A218A219A12A114A119A12A13A14A34A220A221A114A119A12A13A14A178A207A200A13A14A57A17关键字数据库设计；高校药房管理系统；SQLSERVER2000A222A223A222目录A224A225A226A227A228A2291A230A225A231A232A233A234A235A2361A237A225A233A234A238A2392A240A225A241A242A243A2443A245A246A247A248A249A250A251A2523A245A246A253A254A255A237A0A1A2A3A4A237A0A2523A242A225A252A236A243A2444A243A246A247A248A249A250A251A2524A243A246A253A254A255A237A0A1A2A3A4A237A0A2524A244A225A125A5A6A236A7A84A190A246A247A27A245A9A247A248A10A11A12A125A5A64A190A246A253A209A12A2525A252A225A11A12A250A136A14A246A247A248A249A250A251A252A250A13A236A11A126A14A246A253A254A255A237A0A1A2A3A4A237A0A252A250A13A236A11A126A15A225A11A12A16A176A18A246A247A16A17A254A255A237A0A1A2A3A4A237A0A252A213A19A20A254A255A1A2A3A4A236A21A226A18A246A253A16A17A248A249A250A251A252A213A23A24A207A25A26A237A236A21A227A18A246A28A27A16A17A228A229A29A11A12A30A2417A18A246A243A11A12A31A32A33A2327A18A246A14A11A12A34A35A298A36A225A37A389A39A40A41A429A222A43A222一、需求分析A205A44A74A45A46A47A48A49A50A51A52A53A54A55A152A56A57A58A83A59A60A61A62A63A64A65A66A177A83A67A60A59A68A69A70A71A52A72A113A71A73A53A54A69A75A76A52A72A113A77A78A71A73A53A54A79A76A108A80A60A81A82A84A251A85A86A87A88A65A89A90A60A113A91A92A58A131A93A94A95A96A97A69A98A99A100A46A47A53A54A60A48A49A101A94A95A102A103A84A104A217A113A105A94A95A96A97A69A106A113A91A92A107A109A94A95A110A111A96A97A101A69A122A112A101A69A114A115A101A69A141A116A117A118A119A83A94A95A59A68A60A120A60A84A116A121A123A60A113A105A124A126A171A127A128A86A96A97A84A83A123A113A105A94A95A52A86A129A130A132A58A133A134A116A135A136A137A138A139A60A110A111A69A113A91A140A142A143A144A145A58A146A147A60A148A101A58A92A149A150A161A60A151A124A69A153A151A154A155A131A156A69A205A157A173A158A159A110A160A111A69A162A163A60A110A111A142A164A165A166A113A91A94A95A110A111A167A168A145A142A60A169A170A177A172A66A69A205A157A74A45A174A175A102A92A158A128A176A94A95A110A111A69A151A178A65A179A180A181A182A183A184A175A185A186A187A188A58A56A57A189A191A69A116A192A193A194A98A74A45A174A175A102A195A152A108A60A182A183A48A49A92A158A97A174A84A83A123A121A238A121A196A94A95A96A97A69A52A94A95A121A238A197A123A218A170A198A108A48A49A60A199A127A96A97A84A194A98A74A45A200A96A97A195A201A202A140A203A92A158A204A95A84A206A208A72A238A177A113A210A211A212A146A60A191A214A69A215A216A69A219A220A221A222A223A84A193A194A98A92A158A73A54A140A203A60A95A84A208A113A91A92A149A224A225A69A204A95A226A147A69A227A113A69A225A109A113A91A222A223A69A204A228A229A230A222A223A69A231A232A233A234A235A236A84A201A239A98A224A240A241A69A246A251A249A106A45A86A87A152A59A253A94A95A96A97A69A187A254A52A255A98A69A134A52A255A99A0A60A101A1A84A128A126A111A65A106A94A95A76A83A59A69A107A219A76A103A131A84A195A239A202A104A60A105A230A134A152A2A76A83A60A106A3A67A84二、课程设计目的A112A127A4A5A6A86A87A94A95A48A49A96A97A69A106A198A108A167A168A160A111A129A7A76A108A228A176A69A134A76A108A46A47A101A84A91A8A127A120A60A52A112A2A109A53A54A119A110A86A87A9A73A60A54A10A11A224A69A158A113A169A170A69A76A73A60A112A114A167A12A10A69A134A65A106A91A71A73A74A116A119A83A84A81A83A45A13A14A15A16A17A18A19A20A21A22A23A24A25A117A118A40A26A15A16A33A92A27A119A28A29A125A30A31A32A92A27A34A121A29A35A36A37A38A39A123A48A41A42A29A124A43A44A46A47A49A33A232A50A51A52A33A53A54A127A135A29A175A55A75A56A57A58A16A59A60A57A61A62A63A64A65A66A29A122A67A13A128A15A16A68A69A29A70A71A70三、设计概念A72A80A130A131A132A230A74A77A78A79A82A84A85A237A86A87A88A237A86A89A87A90A93A94A87A88A82A90A93A94A89A87A133A95A96A97A207A100A89A87A237A86A89A87A90A93A94A89A87A74A77A102A107A115A90A102A107A74A77A90A120A78A79A82A126A115A90A136A137A138A88A139A74A77A96A97A90A120A140A97A141A142A88A143A115A90A144A142A90A120A78A79A82A145A146A147A148A140A149A150A140A102A107A85A138A88A139A150A140A88A139A150A140A144A142A140A97A141A142A88A143A140A87A84A85A213A151A152A153A152四、图形界面41处方信息表42医生名单和药剂师名单表A152A154A152五、表的界面51处方信息表A155A156A239A157A155A156A159A160A155A156A161A162A163A164A165A166A167A168A169A170A171A172A173A174A177A178A179A174A177A180A181A182A183A184A185A186A187A188A189A173A174A177A178A179A174A177A190A181A182A191A192A188A189A173A174A177A178A179A174A177A190A181A182A193A194A195A188A189A173A174A177A178A179A174A177A190A181A182A196A197A198A199A245A200A174A201A201A203A204A205A235A206A181A182A208A193A198A199A245A200A174A201A201A203A204A205A235A206A181A18252医生名单和药剂师名单表A185A209A189A210A185A209A211A212A185A209A214A215A216A217A218A220A221A222A169A170A188A189A173A174A177A178A179A174A177A190A181A182A183A184A185六、数据库的实现61用SQL语句创建数据库A223A225A226A227A228A226A229A227A228A227A231A227A233A226A234A236A238A240A241A242A243A244A246A247A248A225A249A250A227A225A251A252A253A254A255A166A238A240A241A242A167A229A227A228A226A33A189A249A157A226A247A227A250A226A166A150A0A170A238A240A241A242A226A191A250A229A189A150A168A233A249A172A226A166A1A168A254A253A165A245A174A2A255A166A235A3A168A176A174A247A255A130A4A5A6A7A8A166A235A182A9A10A9A247A5A130A5A252A251A252A253A254A255A166A150A238A240A241A242A150A168A176A174A247A255A252A253A254A255A166A150A0A118A170A238A240A241A242A167A157A246A183A191A157A229A189A150A168A245A174A2A255A166A235A168A254A253A165A245A174A2A255A166A236A3A168A176A174A247A255A130A4A5A6A7A8A166A235A3A184A182A130A562新建表A190A191A236A191A235A209A11A185A40A12A13A14A15A186A16A17A187A18A19A83A45A113A20A21A22A23A24A177A25A152A26A27A28A29A27A29A28A158A30A27A31A32A34A35A36A162A134A37A149A28A26A152A38A28A26A162A39A41A163A25A42A163A187A43A43A171A207A44A46A239A149A28A26A152A38A28A26A162A47A41A163A25A42A163A187A43A43A171A237A48A46A239A149A28A26A152A38A28A26A162A47A41A163A25A42A163A187A43A43A171A113A49A50A46A239A149A28A26A152A38A28A26A162A47A51A41A163A25A42A163A187A43A43A171A31A32A52A53A18A156A28A30A30A180A54A29A162A16A55A41A163A25A42A163A187A43A43A171A88A32A52A53A18A156A28A30A30A180A54A29A162A16A55A41A163A25A42A163A187A43A43A171A41A177A25A55A17A188A56A243A57A58A59A60A47A17A55A17A55A61A62A63A237A48A239A64A65A113A49A50A239A64A36A186A66A16A17A187A18A19A83A45A113A20A21A22A23A24A177A25A152A26A27A28A29A27A29A28A158A30A27A237A48A239A64A65A113A49A50A239A64A36A162A46A239A149A28A26A152A38A28A26A162A47A41A163A25A42A163A187A43A43A171A41A177A25A67A68A67A55A17A188A56A243A57A58A59A60七、创建主键71处方信息表主键的创建A69A70A71A72A73A74A75A76A77A78A79A80A81A82A84A85A86A87A89A90A87A85A91A86A89A92A93A94A95A96A85A97A97A98A99A100A161A87A90A85A101A100A87A102A103A104A92A93A94A95A96A105A90A101A106A85A90A107A192A89A107A98A86A108A161A87A89A90A89A97A109A102A103A110A111A99A112A70A114A115A116A117A119A213A12072医生名单和药剂师名单表主键的创建A69A70A71A72A73A74A75A76A77A78A79A80A81A82A84A85A86A87A89A90A87A85A91A86A89A121A122A123A124A125A76A126A127A123A124A96A85A97A97A98A99A100A161A87A90A85A101A100A87A128A123A104A121A122A123A124A125A76A126A127A123A124A96A105A90A101A106A85A90A107A192A89A107A98A86A108A161A87A89A90A89A97A109A128A123A110A111A99A112A70A114A115A116A117A119A213A120八、创建查询81查询医生名单和药剂师名单表中所有医生和药剂师的记录A129A131A129A132A133A135A133A136A137A194A138A151A139A140A141A142A143A144A145A146A147A148A143A144A15382查询处方信息表中指定患者姓名的记录A132A133A135A133A136A137A194A138A151A139A140A154A155A159A160A153A179A164A133A151A133A169A143A173A175A195A229A17583用查询分析器创建视图A178A181A193A181A196A197A198A199A200A201A202A250A203A204A205A206A208A210A211A212A214A215A216A217A218A219A220A230A221A222A223A224A225A226A227A228A231A232A233A234A238A240A241A242A208A196A219A244A246A219A244A246A248A206A249A251A252A248A206A249A253A254A255A248A206A249A227A228A40A0A1A88A253A40A0A33A96A90A208A81A220A230A108A105A221A200A2A214A3A4A214A211A212A214A215A3A3A3A179A5A6A7A130A8A200A9A10A11A6A5A12A8A164A13A13A214A161A214A14A4A244A246A248A206A249A251A252A248A206A249A253A254A255A248A206A249A227A228A40A0A1A88A253A40A0A189A2A183A156A227A228A231A232A233A215A153A214A2A214A241A242A173A175A196A175A178A181A193A181A217A78A197A198A199A200A201A202A178A15A206A208A210A3A3A3A218A219A220A230A33A222A223A178A15A208A225A226A227A228A231A232A233A234A241A242A208A203A217A204A219A244A246A219A244A246A248A206A249A251A252A248A206A249A253A254A255A248A206A249A227A228A40A0A1A88A253A40A0A33A96A90A16A17A18A19A20A81A220A230A219A21A22A23A24A25A154A26A27A28A18A167A29A219A207A30A221A164A161A4A214A2A211A212A214A215A3A3A3A164A13A13A214A161A214A14A4A244A246A248A206A249A251A252A248A206A249A253A254A255A248A206A249A227A228A40A0A1A88A253A40A0A189A2A183A156A227A228A231A232A233A215A153A214A2A214A241A242A173A175A166A175A179A5A6A7A200A7A130A200A31A12A11A6A5A12A885创建存储过程A32A34A32A178A181A191A181A196A250A203A204A205A206A208A210A160A160A160A218A219A35A36A37A38A221A197A39A198A41A227A228A231A232A233A219A18A19A231A232A221A210A17A211A197A81A35A36A37A38A221A14A2A214A3A4A214A42A2A183A14A160A160A160A3A13A13A214A161A214A14A4A194A189A2A183A156A227A228A231A232A233A43A183A214A184A214A14A160A160A160A178A181A191A181A217A250A203A204A205A206A208A210A3A160A218A219A35A36A37A38A33A197A39A44A45A251A252A206A46A1A253A254A255A206A46A233A234A47A29A248A206A219A48A49A33A193A212A248A206A213A211A197A50A214A29A221A210A17A211A197A81A35A36A37A38A221A14A2A214A3A4A214A42A2A183A14A3A160A215A3A14A153A3A2A152A190A182A3A13A51A214A161A214A4A214A251A252A206A46A1A253A254A255A206A46A233A215A153A214A2A214A248A206A173A215A3A43A183A214A184A214A14A3A160A175A216A52A17587创建触发器A250A203A204A205A206A208A210A14A14A218A219A53A54A202A33A55A218A227A228A231A232A233A219A108A48A49A50A33A81A53A54A202A56A57A225A226A227A228A231A232A233A219A18A19A231A232A221A14A2A214A3A4A214A4A2A212A43A43A214A2A14A14A183A58A227A228A231A232A233A189A183A2A212A58A13A214A2A4A3A13A13A214A161A214A14A4A194A189A2A183A156A227A228A231A232A233A43A183A212A58A13A214A2A4A212A58A4A183A227A228A231A232A233A211A3A161A150A214A13A152A175A166A175A168A175A216A59A175A168A175A195A195A175A168A175A216A52A175A168A175A217A236A196A196A131A196A236A131A193A236A175A168A175A217A236A196A196A131A196A196A131A217A175A182A32A60A32九、总结A83A61A113A62A63A64A65A66A67A68A222A69A68A70A224A119A71A72A63A64A73A74A75A76A63A64A77A79A67A68A80A217A82A84A73A85A86A87A225A89A91A73A92A93A94A77A73A87A95A97A157A98A99A100A151A67A68A80A217A101A102A103A104A100A101A102A106A107A109A94A77A73A82A84A98A99A100A110A111A67A68A112A114A226A115A114A87A95A85A100A80A217A115A114A116A95A85A67A68A112A117A118A73A120A121A87A95A122A227A98A99A73A112A114A100A123A124A100A67A68A125A126A73A228A127A120A229A128A129A114A132A87A95A122A73A122A133A134A76A80A217A232A135A113A62A63A64A65A66A73A136A137A138A139A100A233A140A141A93A89A142A143A144A73A145A146A100A234A147A89A148A149A127A155A117A158A159A144A73A64A162A100A148A163A165A169A170A171A143A172A173A149A127A155A65A66A238A174A89A175A240A176A241A100A177A120A241A217A137A180A100A181A185A186A149A127A172A242A100A148A149A127A155A138A139A64A187A125A243A188A192A196A112A83A73A197A198A100A181A199A201A202A205A93A206A187A138A139A100A208A209A220A230A73A85A221A100A245A246A89A175A240A196A223A149A127A155A172A173A217A137A180A73A247A198A100A177A120A241A180A185A85A125A231A84A65A235A248A73A185A186A125A64A162A76A136A137A138A139A249A237A145A239A100A116A244A180A250A252A89A253A251A100A254A142A89A253A251A76A255A1A105A6A136A137A138A139A73A0A2A100A3A12A4A5A76A7A91A250A252A73A65A66A8A196A159A144A152A9A73A10A11A13A71A223A100A14A15A78A250A163A165A40A105A16A186A40A1