- 基于java的新能源汽车网站mysql数据库创建语句
- 基于java的新能源汽车网站oracle数据库创建语句
- 基于java的新能源汽车网站sqlserver数据库创建语句
- 基于java的新能源汽车网站spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于java的新能源汽车网站spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于java的新能源汽车网站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_bk(
id int primary key auto_increment comment '主键',
bkName varchar(100) comment '分类名称'
) comment '分类';
汽车表创建语句如下：
create table t_car(
id int primary key auto_increment comment '主键',
ppId int comment '品牌',
title varchar(100) comment '车名',
pic1 varchar(100) comment '图片1',
pic2 varchar(100) comment '图片2',
pic3 varchar(100) comment '图片3',
pic4 varchar(100) comment '图片4',
xh int comment '续航',
jg int comment '价格',
content varchar(100) comment '详情',
jb varchar(100) comment '级别',
show1 varchar(100) comment '能源分类',
show2 varchar(100) comment '续航分类'
) comment '汽车';
销量排行榜表创建语句如下：
create table t_carpm(
id int primary key auto_increment comment '主键',
carId int comment '车',
xl int comment '销量'
) comment '销量排行榜';
冲点卡办理表创建语句如下：
create table t_cdk(
id int primary key auto_increment comment '主键',
title varchar(100) comment '冲点卡办理 '
) comment '冲点卡办理';
用户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
name varchar(100) comment '姓名',
phone varchar(100) comment '手机',
sex varchar(100) comment '性别',
age varchar(100) comment '年龄',
address varchar(100) comment '住址',
idcard varchar(100) comment '身份证',
insertDate datetime comment '入库日期',
headPic varchar(100) comment '头像',
ispl varchar(100) comment '评论权限',
mb1 varchar(100) comment '密保1',
mb2 varchar(100) comment '密保2',
mb3 varchar(100) comment '密保3'
) comment '用户';
购买表创建语句如下：
create table t_gm(
id int primary key auto_increment comment '主键',
orderNum varchar(100) comment '订单编号',
customerId int comment '用户',
carId int comment '购买汽车',
insertDate datetime comment '购买时间',
status varchar(100) comment '状态',
v1 int comment '车船税',
v2 int comment '购置税',
v3 int comment '上牌费',
v4 int comment '保险',
v5 int comment '车价',
v6 int comment '合计'
) comment '购买';
轮播图表创建语句如下：
create table t_lbt(
id int primary key auto_increment comment '主键',
pic varchar(100) comment '图片'
) comment '轮播图';
网站说明表创建语句如下：
create table t_ltsm(
id int primary key auto_increment comment '主键',
title varchar(100) comment '网站说明'
) comment '网站说明';
评论表创建语句如下：
create table t_pinglun(
id int primary key auto_increment comment '主键',
wdxxId int comment '评论信息',
customerId int comment '评论人',
content varchar(100) comment '评论内容',
insertDate datetime comment '评论日期'
) comment '评论';
品牌名称表创建语句如下：
create table t_pp(
id int primary key auto_increment comment '主键',
ppName varchar(100) comment '品牌'
) comment '品牌名称';
热门视频表创建语句如下：
create table t_rmsp(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
url varchar(100) comment '地址',
content varchar(100) comment '内容'
) comment '热门视频';
热门视资讯表创建语句如下：
create table t_rmxz(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容'
) comment '热门视资讯';
我的消息表创建语句如下：
create table t_wdxx(
id int primary key auto_increment comment '主键',
customerId int comment '我',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
zan int comment '赞',
insertDate datetime comment '发布日期',
nologin varchar(100) comment '游客是否可见',
bkId int comment ''
) comment '我的消息';
政策补贴表创建语句如下：
create table t_zcbt(
id int primary key auto_increment comment '主键',
title varchar(100) comment '政策补贴'
) comment '政策补贴';
基于java的新能源汽车网站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_bk(
id integer,
bkName varchar(100)
);
--分类字段加注释
comment on column t_bk.id is '主键';
comment on column t_bk.bkName is '分类名称';
--分类表加注释
comment on table t_bk is '分类';
汽车表创建语句如下：
create table t_car(
id integer,
ppId int,
title varchar(100),
pic1 varchar(100),
pic2 varchar(100),
pic3 varchar(100),
pic4 varchar(100),
xh int,
jg int,
content varchar(100),
jb varchar(100),
show1 varchar(100),
show2 varchar(100)
);
--汽车字段加注释
comment on column t_car.id is '主键';
comment on column t_car.ppId is '品牌';
comment on column t_car.title is '车名';
comment on column t_car.pic1 is '图片1';
comment on column t_car.pic2 is '图片2';
comment on column t_car.pic3 is '图片3';
comment on column t_car.pic4 is '图片4';
comment on column t_car.xh is '续航';
comment on column t_car.jg is '价格';
comment on column t_car.content is '详情';
comment on column t_car.jb is '级别';
comment on column t_car.show1 is '能源分类';
comment on column t_car.show2 is '续航分类';
--汽车表加注释
comment on table t_car is '汽车';
销量排行榜表创建语句如下：
create table t_carpm(
id integer,
carId int,
xl int
);
--销量排行榜字段加注释
comment on column t_carpm.id is '主键';
comment on column t_carpm.carId is '车';
comment on column t_carpm.xl is '销量';
--销量排行榜表加注释
comment on table t_carpm is '销量排行榜';
冲点卡办理表创建语句如下：
create table t_cdk(
id integer,
title varchar(100)
);
--冲点卡办理字段加注释
comment on column t_cdk.id is '主键';
comment on column t_cdk.title is '冲点卡办理 ';
--冲点卡办理表加注释
comment on table t_cdk is '冲点卡办理';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
name varchar(100),
phone varchar(100),
sex varchar(100),
age varchar(100),
address varchar(100),
idcard varchar(100),
insertDate datetime,
headPic varchar(100),
ispl varchar(100),
mb1 varchar(100),
mb2 varchar(100),
mb3 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.name is '姓名';
comment on column t_customer.phone is '手机';
comment on column t_customer.sex is '性别';
comment on column t_customer.age is '年龄';
comment on column t_customer.address is '住址';
comment on column t_customer.idcard is '身份证';
comment on column t_customer.insertDate is '入库日期';
comment on column t_customer.headPic is '头像';
comment on column t_customer.ispl is '评论权限';
comment on column t_customer.mb1 is '密保1';
comment on column t_customer.mb2 is '密保2';
comment on column t_customer.mb3 is '密保3';
--用户表加注释
comment on table t_customer is '用户';
购买表创建语句如下：
create table t_gm(
id integer,
orderNum varchar(100),
customerId int,
carId int,
insertDate datetime,
status varchar(100),
v1 int,
v2 int,
v3 int,
v4 int,
v5 int,
v6 int
);
--购买字段加注释
comment on column t_gm.id is '主键';
comment on column t_gm.orderNum is '订单编号';
comment on column t_gm.customerId is '用户';
comment on column t_gm.carId is '购买汽车';
comment on column t_gm.insertDate is '购买时间';
comment on column t_gm.status is '状态';
comment on column t_gm.v1 is '车船税';
comment on column t_gm.v2 is '购置税';
comment on column t_gm.v3 is '上牌费';
comment on column t_gm.v4 is '保险';
comment on column t_gm.v5 is '车价';
comment on column t_gm.v6 is '合计';
--购买表加注释
comment on table t_gm is '购买';
轮播图表创建语句如下：
create table t_lbt(
id integer,
pic varchar(100)
);
--轮播图字段加注释
comment on column t_lbt.id is '主键';
comment on column t_lbt.pic is '图片';
--轮播图表加注释
comment on table t_lbt is '轮播图';
网站说明表创建语句如下：
create table t_ltsm(
id integer,
title varchar(100)
);
--网站说明字段加注释
comment on column t_ltsm.id is '主键';
comment on column t_ltsm.title is '网站说明';
--网站说明表加注释
comment on table t_ltsm is '网站说明';
评论表创建语句如下：
create table t_pinglun(
id integer,
wdxxId int,
customerId int,
content varchar(100),
insertDate datetime
);
--评论字段加注释
comment on column t_pinglun.id is '主键';
comment on column t_pinglun.wdxxId is '评论信息';
comment on column t_pinglun.customerId is '评论人';
comment on column t_pinglun.content is '评论内容';
comment on column t_pinglun.insertDate is '评论日期';
--评论表加注释
comment on table t_pinglun is '评论';
品牌名称表创建语句如下：
create table t_pp(
id integer,
ppName varchar(100)
);
--品牌名称字段加注释
comment on column t_pp.id is '主键';
comment on column t_pp.ppName is '品牌';
--品牌名称表加注释
comment on table t_pp is '品牌名称';
热门视频表创建语句如下：
create table t_rmsp(
id integer,
title varchar(100),
pic varchar(100),
url varchar(100),
content varchar(100)
);
--热门视频字段加注释
comment on column t_rmsp.id is '主键';
comment on column t_rmsp.title is '标题';
comment on column t_rmsp.pic is '图片';
comment on column t_rmsp.url is '地址';
comment on column t_rmsp.content is '内容';
--热门视频表加注释
comment on table t_rmsp is '热门视频';
热门视资讯表创建语句如下：
create table t_rmxz(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100)
);
--热门视资讯字段加注释
comment on column t_rmxz.id is '主键';
comment on column t_rmxz.title is '标题';
comment on column t_rmxz.pic is '图片';
comment on column t_rmxz.content is '内容';
--热门视资讯表加注释
comment on table t_rmxz is '热门视资讯';
我的消息表创建语句如下：
create table t_wdxx(
id integer,
customerId int,
title varchar(100),
pic varchar(100),
content varchar(100),
zan int,
insertDate datetime,
nologin varchar(100),
bkId int
);
--我的消息字段加注释
comment on column t_wdxx.id is '主键';
comment on column t_wdxx.customerId is '我';
comment on column t_wdxx.title is '标题';
comment on column t_wdxx.pic is '图片';
comment on column t_wdxx.content is '内容';
comment on column t_wdxx.zan is '赞';
comment on column t_wdxx.insertDate is '发布日期';
comment on column t_wdxx.nologin is '游客是否可见';
comment on column t_wdxx.bkId is '';
--我的消息表加注释
comment on table t_wdxx is '我的消息';
政策补贴表创建语句如下：
create table t_zcbt(
id integer,
title varchar(100)
);
--政策补贴字段加注释
comment on column t_zcbt.id is '主键';
comment on column t_zcbt.title is '政策补贴';
--政策补贴表加注释
comment on table t_zcbt is '政策补贴';
oracle特有，对应序列如下：
create sequence s_t_bk;
create sequence s_t_car;
create sequence s_t_carpm;
create sequence s_t_cdk;
create sequence s_t_customer;
create sequence s_t_gm;
create sequence s_t_lbt;
create sequence s_t_ltsm;
create sequence s_t_pinglun;
create sequence s_t_pp;
create sequence s_t_rmsp;
create sequence s_t_rmxz;
create sequence s_t_wdxx;
create sequence s_t_zcbt;
基于java的新能源汽车网站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_bk(
id int identity(1,1) primary key not null,--主键
bkName varchar(100)--分类名称
);
汽车表创建语句如下：
--汽车表注释
create table t_car(
id int identity(1,1) primary key not null,--主键
ppId int,--品牌
title varchar(100),--车名
pic1 varchar(100),--图片1
pic2 varchar(100),--图片2
pic3 varchar(100),--图片3
pic4 varchar(100),--图片4
xh int,--续航
jg int,--价格
content varchar(100),--详情
jb varchar(100),--级别
show1 varchar(100),--能源分类
show2 varchar(100)--续航分类
);
销量排行榜表创建语句如下：
--销量排行榜表注释
create table t_carpm(
id int identity(1,1) primary key not null,--主键
carId int,--车
xl int--销量
);
冲点卡办理表创建语句如下：
--冲点卡办理表注释
create table t_cdk(
id int identity(1,1) primary key not null,--主键
title varchar(100)--冲点卡办理
);
用户表创建语句如下：
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
name varchar(100),--姓名
phone varchar(100),--手机
sex varchar(100),--性别
age varchar(100),--年龄
address varchar(100),--住址
idcard varchar(100),--身份证
insertDate datetime,--入库日期
headPic varchar(100),--头像
ispl varchar(100),--评论权限
mb1 varchar(100),--密保1
mb2 varchar(100),--密保2
mb3 varchar(100)--密保3
);
购买表创建语句如下：
--购买表注释
create table t_gm(
id int identity(1,1) primary key not null,--主键
orderNum varchar(100),--订单编号
customerId int,--用户
carId int,--购买汽车
insertDate datetime,--购买时间
status varchar(100),--状态
v1 int,--车船税
v2 int,--购置税
v3 int,--上牌费
v4 int,--保险
v5 int,--车价
v6 int--合计
);
轮播图表创建语句如下：
--轮播图表注释
create table t_lbt(
id int identity(1,1) primary key not null,--主键
pic varchar(100)--图片
);
网站说明表创建语句如下：
--网站说明表注释
create table t_ltsm(
id int identity(1,1) primary key not null,--主键
title varchar(100)--网站说明
);
评论表创建语句如下：
--评论表注释
create table t_pinglun(
id int identity(1,1) primary key not null,--主键
wdxxId int,--评论信息
customerId int,--评论人
content varchar(100),--评论内容
insertDate datetime--评论日期
);
品牌名称表创建语句如下：
--品牌名称表注释
create table t_pp(
id int identity(1,1) primary key not null,--主键
ppName varchar(100)--品牌
);
热门视频表创建语句如下：
--热门视频表注释
create table t_rmsp(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
url varchar(100),--地址
content varchar(100)--内容
);
热门视资讯表创建语句如下：
--热门视资讯表注释
create table t_rmxz(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100)--内容
);
我的消息表创建语句如下：
--我的消息表注释
create table t_wdxx(
id int identity(1,1) primary key not null,--主键
customerId int,--我
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
zan int,--赞
insertDate datetime,--发布日期
nologin varchar(100),--游客是否可见
bkId int--
);
政策补贴表创建语句如下：
--政策补贴表注释
create table t_zcbt(
id int identity(1,1) primary key not null,--主键
title varchar(100)--政策补贴
);
登录后主页.jpg?x-oss-process=style/00001)
基于java的新能源汽车网站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_bk")
public class Bk {
//主键
@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 bkName;
public String getBkName() {return bkName;}
public void setBkName(String bkName) {this.bkName = bkName;}
}汽车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_car")
public class Car {
//主键
@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 Integer ppId;
//车名
private String title;
//图片1
private String pic1;
//图片2
private String pic2;
//图片3
private String pic3;
//图片4
private String pic4;
//续航
private Integer xh;
//价格
private Integer jg;
//详情
private String content;
//级别
private String jb;
//能源分类
private String show1;
//续航分类
private String show2;
public Integer getPpId() {return ppId;}
public void setPpId(Integer ppId) {this.ppId = ppId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic1() {return pic1;}
public void setPic1(String pic1) {this.pic1 = pic1;}
public String getPic2() {return pic2;}
public void setPic2(String pic2) {this.pic2 = pic2;}
public String getPic3() {return pic3;}
public void setPic3(String pic3) {this.pic3 = pic3;}
public String getPic4() {return pic4;}
public void setPic4(String pic4) {this.pic4 = pic4;}
public Integer getXh() {return xh;}
public void setXh(Integer xh) {this.xh = xh;}
public Integer getJg() {return jg;}
public void setJg(Integer jg) {this.jg = jg;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getJb() {return jb;}
public void setJb(String jb) {this.jb = jb;}
public String getShow1() {return show1;}
public void setShow1(String show1) {this.show1 = show1;}
public String getShow2() {return show2;}
public void setShow2(String show2) {this.show2 = show2;}
}销量排行榜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_carpm")
public class Carpm {
//主键
@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 Integer carId;
//销量
private Integer xl;
public Integer getCarId() {return carId;}
public void setCarId(Integer carId) {this.carId = carId;}
public Integer getXl() {return xl;}
public void setXl(Integer xl) {this.xl = xl;}
}冲点卡办理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_cdk")
public class Cdk {
//主键
@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;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}用户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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//头像
private String headPic;
//评论权限
private String ispl;
//密保1
private String mb1;
//密保2
private String mb2;
//密保3
private String mb3;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getIspl() {return ispl;}
public void setIspl(String ispl) {this.ispl = ispl;}
public String getMb1() {return mb1;}
public void setMb1(String mb1) {this.mb1 = mb1;}
public String getMb2() {return mb2;}
public void setMb2(String mb2) {this.mb2 = mb2;}
public String getMb3() {return mb3;}
public void setMb3(String mb3) {this.mb3 = mb3;}
}购买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_gm")
public class Gm {
//主键
@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 orderNum;
//用户
private Integer customerId;
//购买汽车
private Integer carId;
//购买时间
private Date insertDate;
//状态
private String status;
//车船税
private Integer v1;
//购置税
private Integer v2;
//上牌费
private Integer v3;
//保险
private Integer v4;
//车价
private Integer v5;
//合计
private Integer v6;
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getCarId() {return carId;}
public void setCarId(Integer carId) {this.carId = carId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
public Integer getV6() {return v6;}
public void setV6(Integer v6) {this.v6 = v6;}
}轮播图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_lbt")
public class Lbt {
//主键
@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 pic;
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}网站说明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_ltsm")
public class Ltsm {
//主键
@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;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}评论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_pinglun")
public class Pinglun {
//主键
@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 Integer wdxxId;
//评论人
private Integer customerId;
//评论内容
private String content;
//评论日期
private Date insertDate;
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}品牌名称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_pp")
public class Pp {
//主键
@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 ppName;
public String getPpName() {return ppName;}
public void setPpName(String ppName) {this.ppName = ppName;}
}热门视频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_rmsp")
public class Rmsp {
//主键
@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 url;
//内容
private String content;
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 getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}热门视资讯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_rmxz")
public class Rmxz {
//主键
@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 content;
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
}我的消息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_wdxx")
public class Wdxx {
//主键
@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 Integer customerId;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//赞
private Integer zan;
//发布日期
private Date insertDate;
//游客是否可见
private String nologin;
//
private Integer bkId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getZan() {return zan;}
public void setZan(Integer zan) {this.zan = zan;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getNologin() {return nologin;}
public void setNologin(String nologin) {this.nologin = nologin;}
public Integer getBkId() {return bkId;}
public void setBkId(Integer bkId) {this.bkId = bkId;}
}政策补贴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_zcbt")
public class Zcbt {
//主键
@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;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}基于java的新能源汽车网站spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
分类javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//分类
public class Bk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//分类名称
private String bkName;
public String getBkName() {return bkName;}
public void setBkName(String bkName) {this.bkName = bkName;}
}汽车javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//汽车
public class Car extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//品牌
private Integer ppId;
//车名
private String title;
//图片1
private String pic1;
//图片2
private String pic2;
//图片3
private String pic3;
//图片4
private String pic4;
//续航
private Integer xh;
//价格
private Integer jg;
//详情
private String content;
//级别
private String jb;
//能源分类
private String show1;
//续航分类
private String show2;
public Integer getPpId() {return ppId;}
public void setPpId(Integer ppId) {this.ppId = ppId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic1() {return pic1;}
public void setPic1(String pic1) {this.pic1 = pic1;}
public String getPic2() {return pic2;}
public void setPic2(String pic2) {this.pic2 = pic2;}
public String getPic3() {return pic3;}
public void setPic3(String pic3) {this.pic3 = pic3;}
public String getPic4() {return pic4;}
public void setPic4(String pic4) {this.pic4 = pic4;}
public Integer getXh() {return xh;}
public void setXh(Integer xh) {this.xh = xh;}
public Integer getJg() {return jg;}
public void setJg(Integer jg) {this.jg = jg;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getJb() {return jb;}
public void setJb(String jb) {this.jb = jb;}
public String getShow1() {return show1;}
public void setShow1(String show1) {this.show1 = show1;}
public String getShow2() {return show2;}
public void setShow2(String show2) {this.show2 = show2;}
}销量排行榜javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//销量排行榜
public class Carpm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车
private Integer carId;
//销量
private Integer xl;
public Integer getCarId() {return carId;}
public void setCarId(Integer carId) {this.carId = carId;}
public Integer getXl() {return xl;}
public void setXl(Integer xl) {this.xl = xl;}
}冲点卡办理javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//冲点卡办理
public class Cdk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//冲点卡办理
private String title;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}用户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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//头像
private String headPic;
//评论权限
private String ispl;
//密保1
private String mb1;
//密保2
private String mb2;
//密保3
private String mb3;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getIspl() {return ispl;}
public void setIspl(String ispl) {this.ispl = ispl;}
public String getMb1() {return mb1;}
public void setMb1(String mb1) {this.mb1 = mb1;}
public String getMb2() {return mb2;}
public void setMb2(String mb2) {this.mb2 = mb2;}
public String getMb3() {return mb3;}
public void setMb3(String mb3) {this.mb3 = mb3;}
}购买javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//购买
public class Gm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//订单编号
private String orderNum;
//用户
private Integer customerId;
//购买汽车
private Integer carId;
//购买时间
private Date insertDate;
//状态
private String status;
//车船税
private Integer v1;
//购置税
private Integer v2;
//上牌费
private Integer v3;
//保险
private Integer v4;
//车价
private Integer v5;
//合计
private Integer v6;
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getCarId() {return carId;}
public void setCarId(Integer carId) {this.carId = carId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
public Integer getV6() {return v6;}
public void setV6(Integer v6) {this.v6 = v6;}
}轮播图javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//轮播图
public class Lbt extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//图片
private String pic;
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}网站说明javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//网站说明
public class Ltsm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//网站说明
private String title;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}评论javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//评论
public class Pinglun extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//评论信息
private Integer wdxxId;
//评论人
private Integer customerId;
//评论内容
private String content;
//评论日期
private Date insertDate;
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}品牌名称javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//品牌名称
public class Pp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//品牌
private String ppName;
public String getPpName() {return ppName;}
public void setPpName(String ppName) {this.ppName = ppName;}
}热门视频javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//热门视频
public class Rmsp 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 url;
//内容
private String content;
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 getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}热门视资讯javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//热门视资讯
public class Rmxz 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 content;
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
}我的消息javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//我的消息
public class Wdxx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//我
private Integer customerId;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//赞
private Integer zan;
//发布日期
private Date insertDate;
//游客是否可见
private String nologin;
//
private Integer bkId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getZan() {return zan;}
public void setZan(Integer zan) {this.zan = zan;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getNologin() {return nologin;}
public void setNologin(String nologin) {this.nologin = nologin;}
public Integer getBkId() {return bkId;}
public void setBkId(Integer bkId) {this.bkId = bkId;}
}政策补贴javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//政策补贴
public class Zcbt extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//政策补贴
private String title;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}