本篇文章给大家谈谈房产公司网站源码分享,以及房源网站源码对应的知识点,文章可能有点长,但是希望大家可以阅读完,增长自己的知识,最重要的是希望对各位有所帮助,可以解决了您的问题,不要忘了收藏本站喔。
开发语言:Java
框架:ssm
JDK版本:JDK1.8
服务器:tomcat7
数据库:mysql5.7(一定要5.7版本)
数据库工具:Navicat11
开发软件:eclipse/myeclipse/idea
Maven包:Maven3.3.9
浏览器:谷歌浏览器
数据库脚本:
DROPTABLEIFEXISTS`chat`;
/*!40101SET@saved_cs_client=@@character_set_client*/;
/*!40101SETcharacter_set_client=utf8*/;
CREATETABLE`chat`(
`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,
`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,
`userid`bigint(20)NOTNULLCOMMENT&39;,
`adminid`bigint(20)DEFAULTNULLCOMMENT&39;,
`ask`longtextCOMMENT&39;,
`reply`longtextCOMMENT&39;,
`isreply`int(11)DEFAULTNULLCOMMENT&39;,
PRIMARYKEY(`id`)
)ENGINE=InnoDBAUTO_INCREMENT=1651733916921DEFAULTCHARSET=utf8COMMENT=&39;;
/*!40101SETcharacter_set_client=@saved_cs_client*/;
—
–Dumpingdatafortable`chat`
—
LOCKTABLES`chat`WRITE;
/*!40000ALTERTABLE`chat`DISABLEKEYS*/;
INSERTINTO`chat`VALUES(101,&39;,1,1,&39;,&39;,1),(102,&39;,2,2,&39;,&39;,2),(103,&39;,3,3,&39;,&39;,3),(104,&39;,4,4,&39;,&39;,4),(105,&39;,5,5,&39;,&39;,5),(106,&39;,6,6,&39;,&39;,6),(1651733800655,&39;,1651733771883,NULL,&39;,NULL,0),(1651733916920,&39;,1651733771883,1,NULL,&39;,NULL);
/*!40000ALTERTABLE`chat`ENABLEKEYS*/;
UNLOCKTABLES;
—
–Tablestructurefortable`chengshi`
—
DROPTABLEIFEXISTS`chengshi`;
/*!40101SET@saved_cs_client=@@character_set_client*/;
/*!40101SETcharacter_set_client=utf8*/;
CREATETABLE`chengshi`(
`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,
`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,
`chengshi`varchar(200)NOTNULLCOMMENT&39;,
PRIMARYKEY(`id`)
)ENGINE=InnoDBAUTO_INCREMENT=1651733824059DEFAULTCHARSET=utf8COMMENT=&39;;
/*!40101SETcharacter_set_client=@saved_cs_client*/;
—
–Dumpingdatafortable`chengshi`
—
LOCKTABLES`chengshi`WRITE;
/*!40000ALTERTABLE`chengshi`DISABLEKEYS*/;
INSERTINTO`chengshi`VALUES(21,&39;,&39;),(22,&39;,&39;),(23,&39;,&39;),(24,&39;,&39;),(25,&39;,&39;),(26,&39;,&39;),(1651733824058,&39;,&39;);
/*!40000ALTERTABLE`chengshi`ENABLEKEYS*/;
UNLOCKTABLES;
—
–Tablestructurefortable`config`
—
DROPTABLEIFEXISTS`config`;
/*!40101SET@saved_cs_client=@@character_set_client*/;
/*!40101SETcharacter_set_client=utf8*/;
CREATETABLE`config`(
`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,
`name`varchar(100)NOTNULLCOMMENT&39;,
`value`varchar(100)DEFAULTNULLCOMMENT&39;,
PRIMARYKEY(`id`)
)ENGINE=InnoDBAUTO_INCREMENT=4DEFAULTCHARSET=utf8COMMENT=&39;;
/*!40101SETcharacter_set_client=@saved_cs_client*/;
—
–Dumpingdatafortable`config`
—
LOCKTABLES`config`WRITE;
/*!40000ALTERTABLE`config`DISABLEKEYS*/;
INSERTINTO`config`VALUES(1,&39;,&39;),(2,&39;,&39;),(3,&39;,&39;);
/*!40000ALTERTABLE`config`ENABLEKEYS*/;
UNLOCKTABLES;
—
–Tablestructurefortable`dingfangxinxi`
—
DROPTABLEIFEXISTS`dingfangxinxi`;
/*!40101SET@saved_cs_client=@@character_set_client*/;
/*!40101SETcharacter_set_client=utf8*/;
CREATETABLE`dingfangxinxi`(
`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,
`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,
`dingfangbianhao`varchar(200)DEFAULTNULLCOMMENT&39;,
`loupanmingcheng`varchar(200)DEFAULTNULLCOMMENT&39;,
`fangwumingcheng`varchar(200)DEFAULTNULLCOMMENT&39;,
`fangxing`varchar(200)DEFAULTNULLCOMMENT&39;,
`mianji`floatDEFAULTNULLCOMMENT&39;,
`pingfangjia`floatDEFAULTNULLCOMMENT&39;,
`dingfangshijian`dateDEFAULTNULLCOMMENT&39;,
`kehuzhanghao`varchar(200)DEFAULTNULLCOMMENT&39;,
`kehuxingming`varchar(200)DEFAULTNULLCOMMENT&39;,
PRIMARYKEY(`id`),
UNIQUEKEY`dingfangbianhao`(`dingfangbianhao`)
)ENGINE=InnoDBAUTO_INCREMENT=1651734079141DEFAULTCHARSET=utf8COMMENT=&39;;
/*!40101SETcharacter_set_client=@saved_cs_client*/;
—
–Dumpingdatafortable`dingfangxinxi`
—
LOCKTABLES`dingfangxinxi`WRITE;
/*!40000ALTERTABLE`dingfangxinxi`DISABLEKEYS*/;
INSERTINTO`dingfangxinxi`VALUES(71,&39;,&39;,&39;,&39;,&39;,1,1,&39;,&39;,&39;),(72,&39;,&39;,&39;,&39;,&39;,2,2,&39;,&39;,&39;),(73,&39;,&39;,&39;,&39;,&39;,3,3,&39;,&39;,&39;),(74,&39;,&39;,&39;,&39;,&39;,4,4,&39;,&39;,&39;),(75,&39;,&39;,&39;,&39;,&39;,5,5,&39;,&39;,&39;),(76,&39;,&39;,&39;,&39;,&39;,6,6,&39;,&39;,&39;),(1651734079140,&39;,&39;,&39;,&39;,&39;,128,65,&39;,&39;,&39;);
/*!40000ALTERTABLE`dingfangxinxi`ENABLEKEYS*/;
UNLOCKTABLES;
—
–Tablestructurefortable`fangwuxinxi`
—
DROPTABLEIFEXISTS`fangwuxinxi`;
/*!40101SET@saved_cs_client=@@character_set_client*/;
/*!40101SETcharacter_set_client=utf8*/;
CREATETABLE`fangwuxinxi`(
`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,
`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,
`fangwubianhao`varchar(200)DEFAULTNULLCOMMENT&39;,
`loupanmingcheng`varchar(200)DEFAULTNULLCOMMENT&39;,
`fangwumingcheng`varchar(200)DEFAULTNULLCOMMENT&39;,
`fangxing`varchar(200)DEFAULTNULLCOMMENT&39;,
`tupian`varchar(200)DEFAULTNULLCOMMENT&39;,
`louceng`varchar(200)DEFAULTNULLCOMMENT&39;,
`mianji`floatDEFAULTNULLCOMMENT&39;,
`pingfangjia`floatDEFAULTNULLCOMMENT&39;,
`caiguangqingkuang`longtextCOMMENT&39;,
`fangwuxiangqing`longtextCOMMENT&39;,
PRIMARYKEY(`id`),
UNIQUEKEY`fangwubianhao`(`fangwubianhao`)
)ENGINE=InnoDBAUTO_INCREMENT=1651733888590DEFAULTCHARSET=utf8COMMENT=&39;;
/*!40101SETcharacter_set_client=@saved_cs_client*/;
—
–Dumpingdatafortable`fangwuxinxi`
—
LOCKTABLES`fangwuxinxi`WRITE;
/*!40000ALTERTABLE`fangwuxinxi`DISABLEKEYS*/;
INSERTINTO`fangwuxinxi`VALUES(41,&39;,&39;,&39;,&39;,&39;,&39;,&39;,1,1,&39;,&39;),(42,&39;,&39;,&39;,&39;,&39;,&39;,&39;,2,2,&39;,&39;),(43,&39;,&39;,&39;,&39;,&39;,&39;,&39;,3,3,&39;,&39;),(44,&39;,&39;,&39;,&39;,&39;,&39;,&39;,4,4,&39;,&39;),(45,&39;,&39;,&39;,&39;,&39;,&39;,&39;,5,5,&39;,&39;),(46,&39;,&39;,&39;,&39;,&39;,&39;,&39;,6,6,&39;,&39;),(1651733888589,&39;,&39;,&39;,&39;,&39;,&39;,&39;,128,65,&39;,&34;background-color:rgb(255,255,255);color:rgb(51,51,51);\\&34;background-color:rgb(255,255,255);color:rgb(247,49,49);\\&34;background-color:rgb(255,255,255);color:rgb(51,51,51);\\&39;);
/*!40000ALTERTABLE`fangwuxinxi`ENABLEKEYS*/;
UNLOCKTABLES;
—
–Tablestructurefortable`forum`
—
DROPTABLEIFEXISTS`forum`;
/*!40101SET@saved_cs_client=@@character_set_client*/;
/*!40101SETcharacter_set_client=utf8*/;
CREATETABLE`forum`(
`id`bigint(20)NOTNULLAUTO_INCREMENTCOMMENT&39;,
`addtime`timestampNOTNULLDEFAULTCURRENT_TIMESTAMPCOMMENT&39;,
`title`varchar(200)DEFAULTNULLCOMMENT&39;,
`content`longtextNOTNULLCOMMENT&39;,
`parentid`bigint(20)DEFAULTNULLCOMMENT&39;,
`userid`bigint(20)NOTNULLCOMMENT&39;,
`username`varchar(200)DEFAULTNULLCOMMENT&39;,
`isdone`varchar(200)DEFAULTNULLCOMMENT&39;,
PRIMARYKEY(`id`)
)ENGINE=InnoDBAUTO_INCREMENT=1651734022498DEFAULTCHARSET=utf8COMMENT=&39;;
/*!40101SETcharacter_set_client=@saved_cs_client*/;
如果你还想了解更多这方面的信息,记得收藏关注本站。
