敬老院管理系统（java）.rar

账号、密码和职位选择登录表： create table login( login_id varchar(20), login_password varchar(20), login_position varchar(30) ) insert into login values('wsw123','123456','院长'); insert into login values('wsw123','','游客'); insert into login values('wsw123','','游客'); 添加老人入住信息： 老人档案表： create table old_archives( old_archives_id varchar(20), old_name varchar(20), old_sex varchar(20), old_go_time varchar(20), old_nation varchar(20), old_phone varchar(20), old_document_type varchar(20), old_document_number varchar(20), old_home_address varchar(20) ); 在字段后面加个注解，方式为:--字段中文; 主键约束 alter table old_archives add constraint dept_key primary key(old_archives_id); 查看表 select * from old_archives; 删除表 drop table old_archives; 删除一行数据 delete from old_archives where old_archives_id = 'wsw001'; 修改 update old_archives set old_name = '汪思伍02',old_sex = '男', old_go_time = '2020--9-10', old_nation = '身份证', old_phone = '11111111', old_document_type = '2222222', old_document_number ='33333333', old_home_address = '湖南长沙中医药' where old_archives_id = 'wsw002'; --护理居住信息 create table nursing_information( nursing_old_archives_id varchar(20), nursing_type varchar(20), nursing_discount_money varchar(20), nursing_bed_select varchar(20) ); 查看表 select * from nursing_information; 删除一行数据 delete from nursing_information where nursing_old_archives_id = 'wsw001'; 修改 update nursing_information set nursing_type = '三级护理每月4000',nursing_discount_money ='0' ,nursing_bed_select = '二人间每月8000' where nursing_old_archives_id = 'wsw002'; 费用明细与结算： 未结算项目信息： create table arrears_information( arrears_old_archives_id varchar(20), arrears_name varchar(20), arrears_nursing_type_money varchar(20), arrears_discount_money varchar(20), arrears_bed_select_money varchar(20) ); 查询表： select * from arrears_information; 删除表 drop table arrears_information;