最新数据库实验 学生宿舍管理系统设计大作业(12)

/*导入工作人员基本信息*/ Insert into Worker values('wahua','0201','woman','15050504532','cleanner','1500','1',);

insert into Worker values('zhayue','0202','woman','15050504242','manage','1500','1');

insert into Worker values('liran','0203','woman','15050504524','cleanner','1500','2');

insert into Worker values('huhg','0204','woman','15050504552','manage','1500','3');

insert into Worker values('jilan','0205','woman','15050504557','cleanner','1500','3');

insert into Worker values('liyue','0206','woman','15050504595','manage','1500','2');

insert into Worker values('wangqiang','0207','man','15050502452','manage','1500','6');

insert into Worker values('qianzhan','0208','man','15050504456','cleanner','1500','6');

insert into Worker values('zhaobin','0209','man','15050504534','manage','1500','4');

insert into Worker values('sunwen','0212','man','15050504567','cleanner','1500','4');

insert into Worker values('zhangli','0214','man','15050504522','manage','1500','5');

insert into Worker values('qianqian','0215','man','15050504546','cleanner','1500','4');

/*导入访问基本信息*/

insert into Visit values('1','613','wen','anne','525','525'); insert into Visit values('2','314','li','arce','525','526'); insert into Visit values('4','202','yue','rose','524','525'); insert into Visit values('6','432','zhang','li','525','527'); insert into Visit values('1','613','wang','Dmdn','525','525');