展示医院科室的下拉列表（连接数据库数据）

使用android连接数据库 （1）

第一次在csdn写博客，记录下在学习过程遇到的问题，好好总结，以便以后的学习。好，说来就来，那就来写第一篇文章，可能排版不太好看咯。

1. 创建数据库, 在这里我创建了两个表

• 表BigDepartment(大科)

DBigDepart DBID 内科 N

• 表Department（具体科室）

DID DName DBDID N01 心血管科 N

DBDID映射到BigDepartment表中的DBID，从而就可以拿到大科的名称，所以在这里设置了外键。

为什么要设置两个表呢？
因为如果设置一个表的时候，数据如下表所示

DID DName DBDID DBigDepart N01 心血管科 N 内科 N02 肠胃科 N 内科 N03 呼吸科 N 内科

由此，发现了，一个表中N与内科的对应关系写入数据库多次，数据发生冗余，浪费存储空间，有可能还会使查询数据库效率变慢。

如果呼吸科下面还有呼吸一科、呼吸二科的话，就再建立一个表，设置外键即可

DID DSName DSID N03 呼吸一科 N0101

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运行即可，数据库建立完成，接下来就是测试数据了。