展示医院科室的下拉列表(连接数据库数据)
来源:互联网 发布:透明头像生成软件 编辑:程序博客网 时间:2024/06/08 14:53
使用android连接数据库 (1)
第一次在csdn写博客,记录下在学习过程遇到的问题,好好总结,以便以后的学习。好,说来就来,那就来写第一篇文章,可能排版不太好看咯。
1. 创建数据库, 在这里我创建了两个表
- 表BigDepartment(大科)
- 表Department(具体科室)
DBDID映射到BigDepartment表中的DBID,从而就可以拿到大科的名称,所以在这里设置了外键。
为什么要设置两个表呢?
因为如果设置一个表的时候,数据如下表所示
由此,发现了,一个表中N与内科的对应关系写入数据库多次,数据发生冗余,浪费存储空间,有可能还会使查询数据库效率变慢。
如果呼吸科下面还有呼吸一科、呼吸二科的话,就再建立一个表,设置外键即可
2.数据库的代码
CREATE DATABASE Department_DataBase; USE Department_DataBase;CREATE TABLE Department( DID VARCHAR(10), DName VARCHAR(20) NOT NULL, DBDID VARCHAR(10), PRIMARY KEY(DID), FOREIGN KEY(DBDID) REFERENCES BigDepartment(DBID));CREATE TABLE BigDepartment( DBigDepart VARCHAR(10) NOT NULL, DBID VARCHAR(10),PRIMARY KEY(DBID),);INSERT INTO BigDepartment(DBigDepart,DBID) VALUES("N","内科");INSERT INTO BigDepartment(DBigDepart,DBID) VALUES("F","妇产科");INSERT INTO BigDepartment(DBigDepart,DBID) VALUES("G","骨科");INSERT INTO BigDepartment(DBigDepart,DBID) VALUES("Z","肿瘤科");INSERT INTO BigDepartment(DBigDepart,DBID) VALUES("W","外科");INSERT INTO BigDepartment(DBigDepart,DBID) VALUES("S","辅助部门");INSERT INTO Department(DID,DName,DBDID) VALUES("N01","心血管科","N"); INSERT INTO Department(DID,DName,DBDID) VALUES("N02","脾胃病科","N"); INSERT INTO Department(DID,DName,DBDID) VALUES("N03","肾病科","N"); INSERT INTO Department(DID,DName,DBDID) VALUES("N04","脑病科","N"); INSERT INTO Department(DID,DName,DBDID) VALUES("N05","呼吸科","N"); INSERT INTO Department(DID,DName,DBDID) VALUES("N06","内分泌科","N"); INSERT INTO Department(DID,DName,DBDID) VALUES("N07","血液科","N"); INSERT INTO Department(DID,DName,DBDID) VALUES("N08","风湿病科","N"); INSERT INTO Department(DID,DName,DBDID) VALUES("N09","重症医学科","N"); INSERT INTO Department(DID,DName,DBDID) VALUES("N10","综合科","N"); INSERT INTO Department(DID,DName,DBDID) VALUES("N11","急诊科","N");INSERT INTO Department(DID,DName,DBDID) VALUES("F01","一妇科","F"); INSERT INTO Department(DID,DName,DBDID) VALUES("F02","二妇科","F"); INSERT INTO Department(DID,DName,DBDID) VALUES("F03","产 科","F"); INSERT INTO Department(DID,DName,DBDID) VALUES("F04","新生儿科","F");INSERT INTO Department(DID,DName,DBDID) VALUES("G01","一骨科","G"); INSERT INTO Department(DID,DName,DBDID) VALUES("G02","二骨科","G"); INSERT INTO Department(DID,DName,DBDID) VALUES("G03","三骨科","G"); INSERT INTO Department(DID,DName,DBDID) VALUES("G04","四骨科","G");INSERT INTO Department(DID,DName,DBDID) VALUES("Z01","一肿瘤科","Z"); INSERT INTO Department(DID,DName,DBDID) VALUES("Z02","二肿瘤科","Z"); INSERT INTO Department(DID,DName,DBDID) VALUES("Z03","三肿瘤科","Z"); INSERT INTO Department(DID,DName,DBDID) VALUES("Z04","四肿瘤科","Z"); INSERT INTO Department(DID,DName,DBDID) VALUES("W01","一外科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W02","二外科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W03","三外科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W04","四外科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W05","肛肠科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W06","乳腺科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W07","颅脑科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W08","皮肤科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W09","针灸科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W10","推拿科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W11","儿科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W12","护理部","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W13","麻醉科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W14","口腔科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W15","耳鼻喉科","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W16","药学部","W"); INSERT INTO Department(DID,DName,DBDID) VALUES("W17","眼科","W");INSERT INTO Department(DID,DName,DBDID) VALUES("S01","医技科","S"); INSERT INTO Department(DID,DName,DBDID) VALUES("S02","影像科","S"); INSERT INTO Department(DID,DName,DBDID) VALUES("S03","检验科","S"); INSERT INTO Department(DID,DName,DBDID) VALUES("S04","实验中心","S"); INSERT INTO Department(DID,DName,DBDID) VALUES("S05","消化内镜室","S");
好了,把它丢进去mysql运行即可,数据库建立完成,接下来就是测试数据了。
阅读全文
0 0
- 展示医院科室的下拉列表(连接数据库数据)
- 科室的下拉列表(mysql)
- 医院科室随访软件
- 下拉列表数据展示和导出
- Java下拉列表联动的实现(从数据库读取数据)
- PHP连接数据库&通过下拉列表及具体条件查询数据
- 下拉列表显示数据库对应数据
- 利用枚举展示下拉列表
- 北京医院科室强项实力排行榜
- ssmspring+ springmvc + hibernate的 列表展示数据
- 表格点击当前行,在其下边展示其子信息列表(即下拉显示数据)
- JSP 如何获取下拉列表的选中的值是数据库表的对应数据
- 去除下拉列表中不想显示的从数据库取出的数据
- jquery下拉框展示数据
- easyui的下拉框展示的Json数据生成方法
- # winform comboBox动态下拉列表,comboBox动态绑定数据库里的数据
- 从数据库里查询数据,显示在jsp的下拉列表框里
- 从数据库获取数据填充下拉列表,然后选中特定项提示不存在的问题。
- C语言基础
- HappyNumber leetcode算法题
- Spark的存储分析过程(一)
- 【JavaScript】Made a Person创建对象启示
- Frida官方手册
- 展示医院科室的下拉列表(连接数据库数据)
- 金蝶K3批量禁用物料的语句
- Tips:在控制台(Console)中调用CFile、CString等
- 这可能是Docker宣布拥抱Kubernetes的真实原因
- 在杨氏矩阵中查找某个数,找到了返回true,找不到返回false。
- Vue项目结构介绍
- 友盟register failed: -11 accs bindapp error!
- 栈和队列的基本操作
- 寂寞让我如此美丽