create.sql

基于JSP的学生宿舍管理系统的设计与实习

drop table admin;
drop table electric;
drop table	house;
drop table repair;
drop table standard;
drop table student;
drop table studenthouse;
drop table water;

select * from admin;
select * from electric;
select * from house;
select * from  repair;
select * from standard;
select * from student;
select * from  studenthouse;
select * from  water;


create table admin(
	username	varchar(20) primary key,
	password	varchar(10),
	manage		varchar(8)	
);


create table electric(
	donghao		varchar(2),
	houseid		varchar(3),
	dishu		number(8),
	xianshu		number(8),
	newdate		date,
	date1		date,
	primary key (donghao,houseid)
);

create table house(
	donghao		varchar(4),
	houseid		varchar(4),
	sex			varchar(4),
	phone		varchar(8),
	kezhu		number(4),
	ruzhu		number(4),
	expense		number(8)
		
);


create table repair(
	id			number(10),
	donghao		number(2),
	houseid		number(3),
	things		varchar(10),
	calldate	date,
	yuanyin		varchar(10),
	isrepair	varchar(2),
	repairdate  date,
	expense		number(8),
	zheren		varchar(8),
	peichang	varchar(2)
);
create table standard(
	id			number(4) primary key,
	wstd		number(8,1),
	estd		number(8,1)
);
create table student(
	studentid	varchar(10) primary key,
	name		varchar(8),
	sex			varchar(2),
	home		varchar(50),
	years		varchar(4),
	nianzhi		number(4),
	xi		    varchar(10),
	classid		varchar(20),
);

create table studenthouse(
	studentid	varchar(10),
	donghao		varchar(2),
	houseid		varchar(3),
	intime		date
);

create table water(
	donghao		varchar(2),
	houseid		varchar(3),
	dishu		number(8),
	xianshu		number(8),
	shangci		date,
	newdate		date,
	expense		number(8)
);

insert into admin values('admin','admin','a');
insert into admin values('chen','123','a');
insert into admin values('manager','manager','m');
insert into house values('2','001','1','234567','6','1','1000');
insert into house values('3','606','1','2653998','4','1','1200');
insert into house values('2','002','0','223455','6','1','1000');
insert into house values('1','002','1','524552','4','1','1200');
insert into house values('1','001','0','565262','4','1','1200');
insert into electric values('2','001','12','23',sysdate,sysdate,0.5,);
insert into electric values('2','002','13','21',sysdate,sysdate,0.5,);
insert into student values('000001','li','1','shanghai','1234',4,'法学院','1','kong');
insert into student values('000002','zhang','0','shanghai','2345',4,'法学院','1','kong');

insert into studenthouse values('000001','2','001',sysdate);
insert into studenthouse values('000002','2','002',sysdate);


create sequense qiao;


commit;