基于SSM的专利分析系统,基于java的毕业设计

基于SSM的专利分析系统登录注册界面

基于SSM的专利分析系统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_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 '头像',
	level varchar(100) comment '层级',
	isft 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_hyzx(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	pic varchar(100) comment '图片',
	showDate varchar(100) comment '日期'
) comment '行业资讯';

论坛说明表创建语句如下:


create table t_ltsm(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '论坛说明'
) comment '论坛说明';

敏感词表创建语句如下:


create table t_mgc(
	id int primary key auto_increment comment '主键',
	mgc 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_sq(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	wdxxId int comment '资源',
	insertDate datetime comment '申请时间'
) comment '资源申请';

专利申请表创建语句如下:


create table t_sqzl(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	sqzlName varchar(100) comment '申请专利标题',
	content varchar(100) comment '内容',
	fileurl varchar(100) comment '附件',
	status varchar(100) comment '状态',
	back 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 '分类',
	money varchar(100) comment '交易金额',
	v1 varchar(100) comment '联系电话',
	v2 varchar(100) comment '状态',
	v3 varchar(100) comment '专利号',
	v4 varchar(100) comment '分类号',
	v5 varchar(100) comment '专利权人(公司)',
	v6 varchar(100) comment '发明人',
	v7 varchar(100) comment '公开(公告)日',
	v8 varchar(100) comment '申请号',
	v9 varchar(100) comment '申请日',
	v10 varchar(100) comment '申请人',
	v11 varchar(100) comment 'IPC分类号'
) comment '专利';

资料表创建语句如下:


create table t_zl(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	url varchar(100) comment '连接',
	content varchar(100) comment '简要说明'
) comment '资料';

专利好处表创建语句如下:


create table t_zlhc(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	pic varchar(100) comment '图片',
	showDate varchar(100) comment '日期'
) comment '专利好处';

专利价值表创建语句如下:


create table t_zljz(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	pic varchar(100) comment '图片',
	showDate varchar(100) comment '日期'
) comment '专利价值';

在线客服表创建语句如下:


create table t_zxkf(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	sqzlName varchar(100) comment '说明',
	content varchar(100) comment '内容',
	status varchar(100) comment '状态',
	back varchar(100) comment '回复'
) comment '在线客服';

基于SSM的专利分析系统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_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),
	level varchar(100),
	isft 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.level is '层级';
comment on column t_customer.isft 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_hyzx(
	id integer,
	title varchar(100),
	content varchar(100),
	pic varchar(100),
	showDate varchar(100)
);
--行业资讯字段加注释
comment on column t_hyzx.id is '主键';
comment on column t_hyzx.title is '标题';
comment on column t_hyzx.content is '内容';
comment on column t_hyzx.pic is '图片';
comment on column t_hyzx.showDate is '日期';
--行业资讯表加注释
comment on table t_hyzx 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_mgc(
	id integer,
	mgc varchar(100)
);
--敏感词字段加注释
comment on column t_mgc.id is '主键';
comment on column t_mgc.mgc is '敏感词';
--敏感词表加注释
comment on table t_mgc 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_sq(
	id integer,
	customerId int,
	wdxxId int,
	insertDate datetime
);
--资源申请字段加注释
comment on column t_sq.id is '主键';
comment on column t_sq.customerId is '用户';
comment on column t_sq.wdxxId is '资源';
comment on column t_sq.insertDate is '申请时间';
--资源申请表加注释
comment on table t_sq is '资源申请';

专利申请表创建语句如下:


create table t_sqzl(
	id integer,
	customerId int,
	sqzlName varchar(100),
	content varchar(100),
	fileurl varchar(100),
	status varchar(100),
	back varchar(100)
);
--专利申请字段加注释
comment on column t_sqzl.id is '主键';
comment on column t_sqzl.customerId is '用户';
comment on column t_sqzl.sqzlName is '申请专利标题';
comment on column t_sqzl.content is '内容';
comment on column t_sqzl.fileurl is '附件';
comment on column t_sqzl.status is '状态';
comment on column t_sqzl.back is '回复';
--专利申请表加注释
comment on table t_sqzl 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,
	money varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100),
	v8 varchar(100),
	v9 varchar(100),
	v10 varchar(100),
	v11 varchar(100)
);
--专利字段加注释
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 column t_wdxx.money is '交易金额';
comment on column t_wdxx.v1 is '联系电话';
comment on column t_wdxx.v2 is '状态';
comment on column t_wdxx.v3 is '专利号';
comment on column t_wdxx.v4 is '分类号';
comment on column t_wdxx.v5 is '专利权人(公司)';
comment on column t_wdxx.v6 is '发明人';
comment on column t_wdxx.v7 is '公开(公告)日';
comment on column t_wdxx.v8 is '申请号';
comment on column t_wdxx.v9 is '申请日';
comment on column t_wdxx.v10 is '申请人';
comment on column t_wdxx.v11 is 'IPC分类号';
--专利表加注释
comment on table t_wdxx is '专利';

资料表创建语句如下:


create table t_zl(
	id integer,
	title varchar(100),
	url varchar(100),
	content varchar(100)
);
--资料字段加注释
comment on column t_zl.id is '主键';
comment on column t_zl.title is '标题';
comment on column t_zl.url is '连接';
comment on column t_zl.content is '简要说明';
--资料表加注释
comment on table t_zl is '资料';

专利好处表创建语句如下:


create table t_zlhc(
	id integer,
	title varchar(100),
	content varchar(100),
	pic varchar(100),
	showDate varchar(100)
);
--专利好处字段加注释
comment on column t_zlhc.id is '主键';
comment on column t_zlhc.title is '标题';
comment on column t_zlhc.content is '内容';
comment on column t_zlhc.pic is '图片';
comment on column t_zlhc.showDate is '日期';
--专利好处表加注释
comment on table t_zlhc is '专利好处';

专利价值表创建语句如下:


create table t_zljz(
	id integer,
	title varchar(100),
	content varchar(100),
	pic varchar(100),
	showDate varchar(100)
);
--专利价值字段加注释
comment on column t_zljz.id is '主键';
comment on column t_zljz.title is '标题';
comment on column t_zljz.content is '内容';
comment on column t_zljz.pic is '图片';
comment on column t_zljz.showDate is '日期';
--专利价值表加注释
comment on table t_zljz is '专利价值';

在线客服表创建语句如下:


create table t_zxkf(
	id integer,
	customerId int,
	sqzlName varchar(100),
	content varchar(100),
	status varchar(100),
	back varchar(100)
);
--在线客服字段加注释
comment on column t_zxkf.id is '主键';
comment on column t_zxkf.customerId is '用户';
comment on column t_zxkf.sqzlName is '说明';
comment on column t_zxkf.content is '内容';
comment on column t_zxkf.status is '状态';
comment on column t_zxkf.back is '回复';
--在线客服表加注释
comment on table t_zxkf is '在线客服';

oracle特有,对应序列如下:


create sequence s_t_bk;
create sequence s_t_customer;
create sequence s_t_hyzx;
create sequence s_t_ltsm;
create sequence s_t_mgc;
create sequence s_t_pinglun;
create sequence s_t_sq;
create sequence s_t_sqzl;
create sequence s_t_wdxx;
create sequence s_t_zl;
create sequence s_t_zlhc;
create sequence s_t_zljz;
create sequence s_t_zxkf;

基于SSM的专利分析系统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_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),--头像
	level varchar(100),--层级
	isft varchar(100),--发帖权限
	ispl varchar(100),--评论权限
	mb1 varchar(100),--密保1
	mb2 varchar(100),--密保2
	mb3 varchar(100)--密保3
);

行业资讯表创建语句如下:


--行业资讯表注释
create table t_hyzx(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content varchar(100),--内容
	pic varchar(100),--图片
	showDate varchar(100)--日期
);

论坛说明表创建语句如下:


--论坛说明表注释
create table t_ltsm(
	id int identity(1,1) primary key not null,--主键
	title varchar(100)--论坛说明
);

敏感词表创建语句如下:


--敏感词表注释
create table t_mgc(
	id int identity(1,1) primary key not null,--主键
	mgc 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_sq(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	wdxxId int,--资源
	insertDate datetime--申请时间
);

专利申请表创建语句如下:


--专利申请表注释
create table t_sqzl(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	sqzlName varchar(100),--申请专利标题
	content varchar(100),--内容
	fileurl varchar(100),--附件
	status varchar(100),--状态
	back 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,--分类
	money varchar(100),--交易金额
	v1 varchar(100),--联系电话
	v2 varchar(100),--状态
	v3 varchar(100),--专利号
	v4 varchar(100),--分类号
	v5 varchar(100),--专利权人(公司)
	v6 varchar(100),--发明人
	v7 varchar(100),--公开(公告)日
	v8 varchar(100),--申请号
	v9 varchar(100),--申请日
	v10 varchar(100),--申请人
	v11 varchar(100)--IPC分类号
);

资料表创建语句如下:


--资料表注释
create table t_zl(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	url varchar(100),--连接
	content varchar(100)--简要说明
);

专利好处表创建语句如下:


--专利好处表注释
create table t_zlhc(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content varchar(100),--内容
	pic varchar(100),--图片
	showDate varchar(100)--日期
);

专利价值表创建语句如下:


--专利价值表注释
create table t_zljz(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content varchar(100),--内容
	pic varchar(100),--图片
	showDate varchar(100)--日期
);

在线客服表创建语句如下:


--在线客服表注释
create table t_zxkf(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	sqzlName varchar(100),--说明
	content varchar(100),--内容
	status varchar(100),--状态
	back varchar(100)--回复
);

基于SSM的专利分析系统登录后主页

基于SSM的专利分析系统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_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 level;
//发帖权限
private String isft;
//评论权限
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 getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
public String getIsft() {return isft;}
public void setIsft(String isft) {this.isft = isft;}
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_hyzx")
public class Hyzx {
//主键
@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 content;
//图片
private String pic;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

论坛说明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_mgc")
public class Mgc {
//主键
@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 mgc;
public String getMgc() {return mgc;}
public void setMgc(String mgc) {this.mgc = mgc;}
}

评论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_sq")
public class Sq {
//主键
@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 Integer wdxxId;
//申请时间
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
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_sqzl")
public class Sqzl {
//主键
@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 sqzlName;
//内容
private String content;
//附件
private String fileurl;
//状态
private String status;
//回复
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSqzlName() {return sqzlName;}
public void setSqzlName(String sqzlName) {this.sqzlName = sqzlName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileurl() {return fileurl;}
public void setFileurl(String fileurl) {this.fileurl = fileurl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

专利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;
//交易金额
private String money;
//联系电话
private String v1;
//状态
private String v2;
//专利号
private String v3;
//分类号
private String v4;
//专利权人(公司)
private String v5;
//发明人
private String v6;
//公开(公告)日
private String v7;
//申请号
private String v8;
//申请日
private String v9;
//申请人
private String v10;
//IPC分类号
private String v11;
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;}
public String getMoney() {return money;}
public void setMoney(String money) {this.money = money;}
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 String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
public String getV11() {return v11;}
public void setV11(String v11) {this.v11 = v11;}
}

资料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_zl")
public class Zl {
//主键
@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 url;
//简要说明
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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_zlhc")
public class Zlhc {
//主键
@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 content;
//图片
private String pic;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

专利价值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_zljz")
public class Zljz {
//主键
@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 content;
//图片
private String pic;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

在线客服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_zxkf")
public class Zxkf {
//主键
@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 sqzlName;
//内容
private String content;
//状态
private String status;
//回复
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSqzlName() {return sqzlName;}
public void setSqzlName(String sqzlName) {this.sqzlName = sqzlName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

基于SSM的专利分析系统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 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 level;
//发帖权限
private String isft;
//评论权限
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 getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
public String getIsft() {return isft;}
public void setIsft(String isft) {this.isft = isft;}
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 Hyzx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//图片
private String pic;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

论坛说明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 Mgc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//敏感词
private String mgc;
public String getMgc() {return mgc;}
public void setMgc(String mgc) {this.mgc = mgc;}
}

评论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 Sq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//资源
private Integer wdxxId;
//申请时间
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
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 Sqzl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//申请专利标题
private String sqzlName;
//内容
private String content;
//附件
private String fileurl;
//状态
private String status;
//回复
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSqzlName() {return sqzlName;}
public void setSqzlName(String sqzlName) {this.sqzlName = sqzlName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileurl() {return fileurl;}
public void setFileurl(String fileurl) {this.fileurl = fileurl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

专利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;
//交易金额
private String money;
//联系电话
private String v1;
//状态
private String v2;
//专利号
private String v3;
//分类号
private String v4;
//专利权人(公司)
private String v5;
//发明人
private String v6;
//公开(公告)日
private String v7;
//申请号
private String v8;
//申请日
private String v9;
//申请人
private String v10;
//IPC分类号
private String v11;
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;}
public String getMoney() {return money;}
public void setMoney(String money) {this.money = money;}
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 String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
public String getV11() {return v11;}
public void setV11(String v11) {this.v11 = v11;}
}

资料javaBean创建语句如下:


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

//资料
public class Zl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//连接
private String url;
//简要说明
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 Zlhc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//图片
private String pic;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

专利价值javaBean创建语句如下:


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

//专利价值
public class Zljz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//图片
private String pic;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

在线客服javaBean创建语句如下:


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

//在线客服
public class Zxkf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//说明
private String sqzlName;
//内容
private String content;
//状态
private String status;
//回复
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSqzlName() {return sqzlName;}
public void setSqzlName(String sqzlName) {this.sqzlName = sqzlName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

评论