医药管理信息系统
功能和界面比较简单的一个管理系统。（1）数据库管理系统选用MySQL5.5。（2）数据库访问方式选用数据源JDBC。（3）系统开发语言选择Java。（4）系统界面swing。（5）开发环境eclipse
药品由专门的采购人员从医药经销商处购进医药超市，并将药品信息记录入库，顾客从超市购买药品需填写相关个人信息，每次售药需登记经办人（医药超市员工，即销售人员）的信息，以及所售药品的信息。简化的系统数据库（MediDB）中主要包含以下三个数据表（设计时可根据实际业务需要适当追加其它的数据表），各表及其相应字段分别描述如下：
1．顾客信息表（client）
编号cno：char(10)
姓名cname：nvarchar(8)
性别csex：nchar(1) 男 或 女
年龄cage：int(4)
住址caddress：nvarchar(50)
电话cphone：nvarchar(20)
症状csymptom：nvarchar(50)
已购药品mno：char(12)
经办人ano：char(8)
录入日期cdate：datetime(8)
备注cremark：nvarchar(50)
2.经办人信息表（agency）
编号ano：char(8)
姓名aname：char(8)
性别asex：nchar(1) 男 或 女
电话aphone：char(12)
备注aremark：varchar(50)
3.药品信息表（medicine）
编号mno：char(12)
名称mname：nvarchar(50)
服用方法mmode：nchar(2) 内服 或 外用
功效mefficacy：nvarchar(50)
文件下载
资源详情
[{"title":"（ 72 个子文件 775KB ） 医药管理信息系统","children":[{"title":"《专业技能训练——数据库应用系统开发》选题及相关要求2017-2018-1.doc <span style='color:#111;'> 189.00KB </span>","children":null,"spread":false},{"title":"201524131251 温汉泉 专业技能训练","children":[{"title":"Medicine","children":[{"title":"bin","children":[{"title":"Medicine","children":[{"title":"UI","children":[{"title":"Login$3.class <span style='color:#111;'> 2.35KB </span>","children":null,"spread":false},{"title":"Login$6.class <span style='color:#111;'> 1.08KB </span>","children":null,"spread":false},{"title":"Login$2.class <span style='color:#111;'> 899B </span>","children":null,"spread":false},{"title":"Login$1.class <span style='color:#111;'> 904B </span>","children":null,"spread":false},{"title":"Login$4.class <span style='color:#111;'> 1.10KB </span>","children":null,"spread":false},{"title":"JDBC.class <span style='color:#111;'> 3.70KB </span>","children":null,"spread":false},{"title":"Interface.class <span style='color:#111;'> 13.66KB </span>","children":null,"spread":false},{"title":"Login.class <span style='color:#111;'> 8.19KB </span>","children":null,"spread":false},{"title":"Login$5.class <span style='color:#111;'> 2.54KB </span>","children":null,"spread":false}],"spread":true},{"title":"DAO","children":[{"title":"update$8.class <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"luru$5.class <span style='color:#111;'> 2.41KB </span>","children":null,"spread":false},{"title":"search.class <span style='color:#111;'> 8.06KB </span>","children":null,"spread":false},{"title":"luru.class <span style='color:#111;'> 7.93KB </span>","children":null,"spread":false},{"title":"luru$6.class <span style='color:#111;'> 1.08KB </span>","children":null,"spread":false},{"title":"sale$5.class <span style='color:#111;'> 880B </span>","children":null,"spread":false},{"title":"delete$4.class <span style='color:#111;'> 849B </span>","children":null,"spread":false},{"title":"luru$1.class <span style='color:#111;'> 2.63KB </span>","children":null,"spread":false},{"title":"search$1.class <span style='color:#111;'> 1.28KB </span>","children":null,"spread":false},{"title":"delete$7.class <span style='color:#111;'> 849B </span>","children":null,"spread":false},{"title":"luru$2.class <span style='color:#111;'> 1.08KB </span>","children":null,"spread":false},{"title":"delete.class <span style='color:#111;'> 12.62KB </span>","children":null,"spread":false},{"title":"update$4.class <span style='color:#111;'> 2.25KB </span>","children":null,"spread":false},{"title":"Jdbc.class <span style='color:#111;'> 4.84KB </span>","children":null,"spread":false},{"title":"MedModel$MyTableModel.class <span style='color:#111;'> 717B </span>","children":null,"spread":false},{"title":"update$6.class <span style='color:#111;'> 813B </span>","children":null,"spread":false},{"title":"userdelete.class <span style='color:#111;'> 7.74KB </span>","children":null,"spread":false},{"title":"update.class <span style='color:#111;'> 10.07KB </span>","children":null,"spread":false},{"title":"search$2.class <span style='color:#111;'> 3.25KB </span>","children":null,"spread":false},{"title":"liulan.class <span style='color:#111;'> 7.79KB </span>","children":null,"spread":false},{"title":"update$9.class <span style='color:#111;'> 813B </span>","children":null,"spread":false},{"title":"update$1.class <span style='color:#111;'> 2.76KB </span>","children":null,"spread":false},{"title":"sale$2.class <span style='color:#111;'> 6.17KB </span>","children":null,"spread":false},{"title":"Model.class <span style='color:#111;'> 4.05KB </span>","children":null,"spread":false},{"title":"delete$6.class <span style='color:#111;'> 2.94KB </span>","children":null,"spread":false},{"title":"update$7.class <span style='color:#111;'> 2.30KB </span>","children":null,"spread":false},{"title":"sale.class <span style='color:#111;'> 7.05KB </span>","children":null,"spread":false},{"title":"luru$4.class <span style='color:#111;'> 987B </span>","children":null,"spread":false},{"title":"delete$1.class <span style='color:#111;'> 1.30KB </span>","children":null,"spread":false},{"title":"sale$3.class <span style='color:#111;'> 883B </span>","children":null,"spread":false},{"title":"userdelete$1.class <span style='color:#111;'> 1.34KB </span>","children":null,"spread":false},{"title":"sale$4.class <span style='color:#111;'> 4.72KB </span>","children":null,"spread":false},{"title":"update$5.class <span style='color:#111;'> 933B </span>","children":null,"spread":false},{"title":"MedModel.class <span style='color:#111;'> 3.79KB </span>","children":null,"spread":false},{"title":"delete$3.class <span style='color:#111;'> 3.72KB </span>","children":null,"spread":false},{"title":"delete$2.class <span style='color:#111;'> 1.30KB </span>","children":null,"spread":false},{"title":"luru$3.class <span style='color:#111;'> 2.20KB </span>","children":null,"spread":false},{"title":"update$2.class <span style='color:#111;'> 1.19KB </span>","children":null,"spread":false},{"title":"update$3.class <span style='color:#111;'> 813B </span>","children":null,"spread":false},{"title":"delete$5.class <span style='color:#111;'> 1.30KB </span>","children":null,"spread":false},{"title":"sale$1.class <span style='color:#111;'> 1.28KB </span>","children":null,"spread":false},{"title":"export.class <span style='color:#111;'> 3.27KB </span>","children":null,"spread":false},{"title":"export$1.class <span style='color:#111;'> 2.05KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true},{"title":".settings","children":[{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 598B </span>","children":null,"spread":false}],"spread":true},{"title":"src","children":[{"title":"Medicine","children":[{"title":"UI","children":[{"title":"Interface.java <span style='color:#111;'> 28.68KB </span>","children":null,"spread":false},{"title":"Login.java <span style='color:#111;'> 12.24KB </span>","children":null,"spread":false},{"title":"JDBC.java <span style='color:#111;'> 2.78KB </span>","children":null,"spread":false}],"spread":true},{"title":"DAO","children":[{"title":"Model.java <span style='color:#111;'> 3.24KB </span>","children":null,"spread":false},{"title":"export.java <span style='color:#111;'> 2.62KB </span>","children":null,"spread":false},{"title":"sale.java <span style='color:#111;'> 13.50KB </span>","children":null,"spread":false},{"title":"search.java <span style='color:#111;'> 7.84KB </span>","children":null,"spread":false},{"title":"liulan.java <span style='color:#111;'> 6.55KB </span>","children":null,"spread":false},{"title":"Jdbc.java <span style='color:#111;'> 2.95KB </span>","children":null,"spread":false},{"title":"update.java <span style='color:#111;'> 13.93KB </span>","children":null,"spread":false},{"title":"luru.java <span style='color:#111;'> 11.94KB </span>","children":null,"spread":false},{"title":"userdelete.java <span style='color:#111;'> 6.92KB </span>","children":null,"spread":false},{"title":"MedModel.java <span style='color:#111;'> 3.03KB </span>","children":null,"spread":false},{"title":"delete.java <span style='color:#111;'> 15.33KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true},{"title":".project <span style='color:#111;'> 384B </span>","children":null,"spread":false},{"title":".classpath <span style='color:#111;'> 474B </span>","children":null,"spread":false}],"spread":true},{"title":"201524131251温汉泉实验报告.docx <span style='color:#111;'> 603.03KB </span>","children":null,"spread":false},{"title":"数据库.sql <span style='color:#111;'> 5.67KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]
评论信息
其他资源
- 《系统辨识与自适应控制》考核试题+答案
- Matlab 鼠标抓取三维点坐标
- STM32 8位数码管动态扫描实验（不用库函数） 完整C语言代码 供学习和参考
- STM32_FreeRTOS+STemWin+FatFS+USB Host
- 微机课设——交通信号灯自动控制模拟指示系统
- 最优状态估计 卡尔曼，H∞及非线性滤波_中文版
- 数字通信_基础与应用(第二版)_865页_21.5M.pdf.pdf
- 基于反向学习的人工蜂群算法
- SQL入门必备是三部著作SQL Server从入门到精通、SQL入门经典（第四版）、数据库基础与应用实践教程
- 信息论实验报告（包括求信息量、香农编码、费诺编码、哈弗曼编码、循环码和模P信道编码）
- 词法分析器源代码
- java中文排序,数字字母汉字排序
- 10个ASP.NET项目源码
- 暨南大学《数据结构》12-18年考研试卷真题.pdf
- day02-Ant Design以及Ant Design Pro入门.zip
- 常用会议签到表格格式
- 查看jar源码插件jd-eclipse-2.0.0.zip
- 基于OPNET的无线传感器网络仿真
- 基于Hausdorff距离匹配的算法资料
- 思迅软件实施工具箱
- TeeChart.Pro.v5.ActiveX
免责申明
【只为小站】的资源来自网友分享，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论 【只为小站】 经营者是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明
本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二条之规定，若资源存在侵权或相关问题请联系本站客服人员，zhiweidada#qq.com，请把#换成@，本站将给予最大的支持与配合，做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明