基于网络爬虫的房产估价系统

基于网络爬虫的房产估价系统登录注册界面

基于网络爬虫的房产估价系统mysql数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '超级管理员账号',
	password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');

普通用户表创建语句如下:


create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	customerName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '普通用户';

房产信息表创建语句如下:


create table t_fdz(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '小区',
	pic varchar(100) comment '图片',
	city varchar(100) comment '区域',
	v1 varchar(100) comment '位置',
	v2 varchar(100) comment '房型',
	v3 varchar(100) comment '面积',
	fee int comment '价格'
) comment '房产信息';

房型表创建语句如下:


create table t_fdzlist(
	id int primary key auto_increment comment '主键',
	content varchar(100) comment '房型',
	fdzId int comment ''
) comment '房型';

表创建语句如下:


create table t_mjsl(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '分类',
	v2 int comment '数量'
) comment '';

基于网络爬虫的房产估价系统oracle数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

普通用户表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--普通用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码 ';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
--普通用户表加注释
comment on table t_customer is '普通用户';

房产信息表创建语句如下:


create table t_fdz(
	id integer,
	title varchar(100),
	pic varchar(100),
	city varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	fee int
);
--房产信息字段加注释
comment on column t_fdz.id is '主键';
comment on column t_fdz.title is '小区';
comment on column t_fdz.pic is '图片';
comment on column t_fdz.city is '区域';
comment on column t_fdz.v1 is '位置';
comment on column t_fdz.v2 is '房型';
comment on column t_fdz.v3 is '面积';
comment on column t_fdz.fee is '价格';
--房产信息表加注释
comment on table t_fdz is '房产信息';

房型表创建语句如下:


create table t_fdzlist(
	id integer,
	content varchar(100),
	fdzId int
);
--房型字段加注释
comment on column t_fdzlist.id is '主键';
comment on column t_fdzlist.content is '房型';
comment on column t_fdzlist.fdzId is '';
--房型表加注释
comment on table t_fdzlist is '房型';

表创建语句如下:


create table t_mjsl(
	id integer,
	v1 varchar(100),
	v2 int
);
--字段加注释
comment on column t_mjsl.id is '主键';
comment on column t_mjsl.v1 is '分类';
comment on column t_mjsl.v2 is '数量';
--表加注释
comment on table t_mjsl is '';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_fdz;
create sequence s_t_fdzlist;
create sequence s_t_mjsl;

基于网络爬虫的房产估价系统sqlserver数据库版本源码:

超级管理员表创建语句如下:


--超级管理员
create table t_admin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--超级管理员账号
	password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');

普通用户表创建语句如下:


--普通用户表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	customerName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

房产信息表创建语句如下:


--房产信息表注释
create table t_fdz(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--小区
	pic varchar(100),--图片
	city varchar(100),--区域
	v1 varchar(100),--位置
	v2 varchar(100),--房型
	v3 varchar(100),--面积
	fee int--价格
);

房型表创建语句如下:


--房型表注释
create table t_fdzlist(
	id int identity(1,1) primary key not null,--主键
	content varchar(100),--房型
	fdzId int--
);

表创建语句如下:


--表注释
create table t_mjsl(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--分类
	v2 int--数量
);

基于网络爬虫的房产估价系统登录后主页

基于网络爬虫的房产估价系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计:

普通用户javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//普通用户
@Table(name = "t_customer")
public class Customer {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码 
private String password;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

房产信息javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//房产信息
@Table(name = "t_fdz")
public class Fdz {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//小区
private String title;
//图片
private String pic;
//区域
private String city;
//位置
private String v1;
//房型
private String v2;
//面积
private String v3;
//价格
private Integer fee;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCity() {return city;}
public void setCity(String city) {this.city = city;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}

房型javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//房型
@Table(name = "t_fdzlist")
public class Fdzlist {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//房型
private String content;
//
private Integer fdzId;
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getFdzId() {return fdzId;}
public void setFdzId(Integer fdzId) {this.fdzId = fdzId;}
}

javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//
@Table(name = "t_mjsl")
public class Mjsl {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//分类
private String v1;
//数量
private Integer v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
}

基于网络爬虫的房产估价系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

普通用户javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//普通用户
public class Customer  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码 
private String password;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

房产信息javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//房产信息
public class Fdz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//小区
private String title;
//图片
private String pic;
//区域
private String city;
//位置
private String v1;
//房型
private String v2;
//面积
private String v3;
//价格
private Integer fee;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCity() {return city;}
public void setCity(String city) {this.city = city;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}

房型javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//房型
public class Fdzlist  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//房型
private String content;
//
private Integer fdzId;
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getFdzId() {return fdzId;}
public void setFdzId(Integer fdzId) {this.fdzId = fdzId;}
}

javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//
public class Mjsl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//分类
private String v1;
//数量
private Integer v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
}

源代码下载点这里

评论