基于Java web的房屋出租系统（源码+数据库脚本）.zip

create tablespace ZFDB datafile 'F:\作业（房屋出租系统）\DB\NerDB.ora' size 10m autoextend on; Create TEMPORARY tablespace TempDB tempfile 'F:\作业（房屋出租系统）\DB\TempDB.ora' size 10m autoextend on ; create user Lxp identified by Lxp; alter user Lxp default tablespace ZFDB; alter user Lxp temporary tablespace TempDB; grant connect,resource to Lxp; create table UserLogin ( "uid" number(10) primary key, uname varchar2(100) not null, upass varchar2(100) not null ); CREATE TABLE TBL_FWLX ( lxid number(4) primary key , fwlx varchar2(2000) ); CREATE TABLE TBL_FWXX ( fwid number(4) primary key , "uid" number(4) NULL , jdid number(4) NULL , qxid number(4) NULL , lxid number(4) NULL , shi number(4) NULL , ting number(4) NULL , fwxx varchar2(2000) NULL , zj float NULL , title varchar2(2000) NOT NULL , "date" varchar2(2000) NULL , telephone varchar2(2000) NULL , lxr varchar2(2000) NULL ) ; CREATE TABLE TBL_QX ( qxid number(4) primary key , qx varchar2(2000) NULL ); CREATE TABLE TBL_JD ( jdid number(4) primary key , jd varchar2(2000) NULL , qxid number(4) NOT NULL ); --房屋信息表 insert into tbl_fwxx values(81,80,2,1,3,2,1,'水电煤气，欢迎看房，现住一人，再招一人，限女生，要求：年龄18－22岁，身高165左右，相貌好，性格开朗，脾气好，未婚，没有男朋友。 帅哥＋好房速抢！','1000.00','北大附近招合租','07 3 2007 9:38AM','010-12345678','周星星'); insert into tbl_fwxx values(82,80,38,4,4,1,1,'房间干净家具电器全有.24小时保安.24小时热水.交通购物方便.房子紧邻万达广场.华贸.阳光100.后现代.房子非常适合在附近上班的人士居住. ','1200.00','健翔桥一居出租了','07 3 2007 10:01AM','133123123321','刘景杨'); insert into tbl_fwxx values(83,54,46,2,3,2,1,'冲着我你也得来','2100.00','出租2居','07 3 2007 1:04AM','87654321','伊先生'); insert into tbl_fwxx values(84,80,92,3,2,5,2,'如此宝地，如此好房，快抢，先来先得','2500.00','便宜出租前门四合院','07 3 2007 1:10AM','13456789023','赵大宝'); insert into tbl_fwxx values(85,54,136,6,3,3,1,'西便门住宅小区北二区，简装修、3居1厅2卫、带阳台，新房从未居住过，小区环境优雅，交通购物方便，离城铁走路需5分钟。价格可商议！有意者请速于我联系。','1900.00','西便门北二区出租3室1厅','07 3 2007 1:14AM','13311582033','陈先生'); insert into tbl_fwxx values(86,54,26,1,0,6,1,'房子是新房,新装修,两个卫生间,一个客厅,有独立卫生间,环境好,交通方便,欢迎入住','1000.00','北太平庄房屋出租','07 3 2007 1:16AM','13141406453 ','米女士 '); insert into tbl_fwxx values(87,82,91,2,4,1,1,'房间干净家具电器全有.24小时保安.24小时热水.交通购物方便.房子紧邻万达广场.华贸.阳光100.后现代.房子非常适合在附近上班的人士居住. ','2400.00','后现代城一居室出租','07 3 2007 1:18AM','13240775017','时先生'); insert into tbl_fwxx values(88,56,26,1,3,2,1,'房子地理位置好,就在三环边上,有几座大学,小区环境也相当好,屋内家电家具全都有.这的房子这个价可是最便宜的了,好房子快快来电话吧!7月10号以后能住.中介勿扰! ','2200.00','北三环北太平庄蓟门桥蓟门里小区两居','07 3 2007 1:19AM','13661193065','钟小姐'); insert into tbl_fwxx values(89,82,147,6,3,1,1,'房子是一个单间,和一个厨房,两间都能洗澡,电视,冰箱,洗衣机,空调什么都齐全,有意者尽快与我联系! ','1500.00','出租鼓楼地铁附近/鼓楼西大街!','07 3 2007 1:20AM','15801424883','赵先生 '); insert into tbl_fwxx values(98,54,39,2,3,1,1,'电器齐全，交通便利','1100.00','出租健翔桥二居室','08 15 2007 9:56AM','03114525655','伊先生'); --fwlx表 insert into tbl_fwlx values(0,'不限--'); insert into tbl_fwlx values(1,'地下室'); insert into tbl_fwlx values(2,'平房'); insert into tbl_fwlx values(3,'普通住宅'); insert into tbl_fwlx values(4,'公寓'); insert into tbl_fwlx values(5,'别墅'); --fwqx表 insert into tbl_qx values(0,'不限--'); insert into tbl_qx values(1,'海淀'); insert into tbl_qx values(2,'朝阳'); insert into tbl_qx values(3,'崇文'); insert into tbl_qx values(4,'宣武'); insert into tbl_qx values(5,'东城'); insert into tbl_qx values(6,'西城'); insert into tbl_qx values(7,'通州'); insert into tbl_qx values(8,'丰台'); insert into tbl_qx values(9,'昌平'); insert into tbl_qx values(10,'大兴'); insert into tbl_qx values(11,'门头沟'); insert into tbl_qx values(12,'石景山'); insert into tbl_qx values(13,'房山'); insert into tbl_qx values(14,'顺义'); insert into tbl_qx values(15,'密云'); insert into tbl_qx values(16,'怀柔'); insert into tbl_qx values(17,'延庆'); insert into tbl_qx values(18,'平谷'); insert into tbl_qx values(21,'ss'); --jd表 insert into tbl_jd values(0,'不限--',0); insert into tbl_jd values(1,'中关村',1); insert into tbl_jd values(2,'北京大学',1); insert into tbl_jd values(3,'清华大学',1); insert into tbl_jd values(4,'上地',1); insert into tbl_jd values(5,'白颐路',1); insert into tbl_jd values(6,'西三环',1); insert into tbl_jd values(7,'学院路',1); insert into tbl_jd values(8,'西直门外',1); insert into tbl_jd values(9,'紫竹院',1); insert into tbl_jd values(10,'八里庄',1); insert into tbl_jd values(11,'公主坟',1); insert into tbl_jd values(12,'五道口',1); insert into tbl_jd values(13,'双榆树',1); insert into tbl_jd values(14,'西三旗',1); insert into tbl_jd values(15,'清河',1); insert into tbl_jd values(16,'马连洼',1); insert into tbl_jd values(17,'青龙桥',1); insert into tbl_jd values(18,'香山',1); insert into tbl_jd values(19,'田村路',1); insert into tbl_jd values(20,'永定路',1); insert into tbl_jd values(21,'万寿路',1); insert into tbl_jd values(22,'羊坊店',1); insert into tbl_jd values(23,'甘家口',1); insert into tbl_jd values(24,'北航',1); insert into tbl_jd values(25,'北下关',1); insert into tbl_jd values(26,'北太平庄',1); insert into tbl_jd values(27,'万柳',1); insert into tbl_jd values(28,'东升',1); insert into tbl_jd values(29,'四季青',1); insert into tbl_jd values(30,'西北旺',1); insert into tbl_jd values(31,'温泉镇',1); insert into tbl_jd values(32,'苏家坨',1); insert into tbl_jd values(33,'上庄',1); insert into tbl_jd values(34,'魏公村',1); insert into tbl_jd values(35,'航天桥',1); insert into tbl_jd values(36,'花园路',1); insert into tbl_jd values(37,'动物园',1); insert into tbl_jd values(39,'亚运村',2); insert into tbl_jd values(40,'三元桥',2); insert into tbl_jd values(41,'建外大街',2); insert into tbl_jd values(42,'国展',2); insert into tbl_jd values(43,'三里屯',2); insert into tbl_jd values(44,'劲松',2); insert into tbl_jd values(45,'燕莎',2); insert into tbl_jd values(46,'团结湖',2); insert into tbl_jd values(47,'京广桥',2); insert into tbl_jd values(48,'望京',2); insert into tbl_jd values(49,'安贞桥',2); insert into tbl_jd values(50,'潘家园',2); insert into tbl_jd values(51,'酒仙桥',2); insert into tbl_jd values(52,'呼家楼',2); insert into tbl_jd values(53,'双井',2); insert into tbl_jd values(54,'垡头',2); insert into tbl_jd values(55,'六里屯',2); insert into tbl_jd values(56,'麦子店',2); insert into tbl_jd values(57,'左家庄',2); insert into tbl_jd values(58,'香河园',2); insert into tbl_jd values(59,'首都机场',2); insert into tbl_jd values(60,'小关',2); insert into tbl_jd values(61,'和平街',2); insert into tbl_jd values(62,'小红门',2); insert into tbl_jd values(63,'十八里店',2); insert into tbl_jd values(64,'豆各庄',2); insert into tbl_jd values(65,'黑庄户',2); insert into tbl_jd values(66,'王四营',2); insert into tbl_jd values(67,'南磨房',2); insert into tbl_jd values(68,'三间房',2); insert into tbl_jd values(69,'管庄',2); insert into tbl_jd values(70,'高碑店',2); insert into tbl_jd values(71,'常营',2); insert into tbl_jd values(72,'平房',2); insert into tbl_jd values(73,'东风',2); insert into tbl_jd values(74,'东坝',2); insert into tbl_jd values(75,'金盏',2); insert into tbl_jd values(76,'将台',2); insert into tbl_jd values(77,'崔各庄',2); insert into tbl_jd values(78,'孙河',2); insert into tbl_jd values(79,'来广营',2); insert into tbl_jd values(80,'太阳宫',2); insert into tbl_jd values(81,'大屯',2); insert into tbl_jd values(82,'奥运村',2); insert into tbl_jd values(83,'国贸'