更多成品,定做java毕业设计,请咨询管理员qq:2812491287

基于WEB的社情民意采集与管理系统,java程序毕业设计

基于WEB的社情民意采集与管理系统登录注册界面

基于WEB的社情民意采集与管理系统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__city(
	id int primary key auto_increment comment '主键',
	region_id varchar(100) comment '',
	region_name varchar(100) comment '',
	level varchar(100) comment '',
	parent_id varchar(100) comment '',
	displayorder varchar(100) comment ''
) comment '';

表创建语句如下:


create table t__login_error(
	id int primary key auto_increment comment '主键',
	ipAddress varchar(100) comment '',
	insertDate datetime comment ''
) comment '';

表创建语句如下:


create table t__pv_url(
	id int primary key auto_increment comment '主键',
	url varchar(100) comment '',
	ip_address varchar(100) comment '',
	customer_id int comment '',
	insert_date datetime comment ''
) comment '';

表创建语句如下:


create table t__role(
	id int primary key auto_increment comment '主键',
	roleId int comment '',
	roleName varchar(100) comment '',
	remark varchar(100) comment ''
) comment '';

表创建语句如下:


create table t__role_tree(
	id int primary key auto_increment comment '主键',
	roleId int comment '',
	nodeId int comment ''
) comment '';

表创建语句如下:


create table t__tree_menu(
	id int primary key auto_increment comment '主键',
	node_id int comment '',
	super_node_id int comment '',
	node_url varchar(100) comment '',
	node_level int comment '',
	node_name varchar(100) comment '',
	orders int comment '',
	remark varchar(100) comment '',
	state int comment ''
) comment '';

表创建语句如下:


create table t__url_view(
	id int primary key auto_increment comment '主键',
	view_date varchar(100) comment '',
	pv int comment '',
	uv int comment '',
	ip int comment ''
) comment '';

表创建语句如下:


create table t__user(
	id int primary key auto_increment comment '主键',
	account varchar(100) comment '',
	password varchar(100) comment '',
	picUrl varchar(100) comment '',
	email varchar(100) comment '',
	state int comment '',
	lastlogindate datetime comment '',
	lastloginip varchar(100) comment '',
	errorcount int comment '',
	errordate datetime comment '',
	islock int comment '',
	createdate datetime comment '',
	phone int comment '',
	userName varchar(100) comment ''
) comment '';

表创建语句如下:


create table t__user_role(
	id int primary key auto_increment comment '主键',
	roleId int comment '',
	userId int comment ''
) comment '';

表创建语句如下:


create table t__uv_url(
	id int primary key auto_increment comment '主键',
	url varchar(100) comment '',
	ip_address varchar(100) comment '',
	customer_id int comment '',
	insert_date datetime comment ''
) comment '';

一级分类表创建语句如下:


create table t_fenone(
	id int primary key auto_increment comment '主键',
	fenoneName varchar(100) comment '名称'
) comment '一级分类';

二级分类表创建语句如下:


create table t_fentwo(
	id int primary key auto_increment comment '主键',
	fenoneId int comment '一级分类',
	fentwoName varchar(100) comment '名称'
) comment '二级分类';

社情民意内容表创建语句如下:


create table t_my(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	fenone varchar(100) comment '一级分类',
	fentwo varchar(100) comment '二级分类',
	bsdw varchar(100) comment '报送单位',
	jjcd varchar(100) comment '紧急程度',
	xxly varchar(100) comment '信息来源',
	fyr varchar(100) comment '反映人',
	pzr varchar(100) comment '批准人',
	bjr varchar(100) comment '编辑人',
	bz varchar(100) comment '备注',
	zw varchar(100) comment '正文',
	fj varchar(100) comment '附件',
	status varchar(100) comment '状态',
	userId int comment '当前用户',
	code int comment ''
) comment '社情民意内容';

基于WEB的社情民意采集与管理系统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__city(
	id integer,
	region_id varchar(100),
	region_name varchar(100),
	level varchar(100),
	parent_id varchar(100),
	displayorder varchar(100)
);
--字段加注释
comment on column t__city.id is '主键';
comment on column t__city.region_id is '';
comment on column t__city.region_name is '';
comment on column t__city.level is '';
comment on column t__city.parent_id is '';
comment on column t__city.displayorder is '';
--表加注释
comment on table t__city is '';

表创建语句如下:


create table t__login_error(
	id integer,
	ipAddress varchar(100),
	insertDate datetime
);
--字段加注释
comment on column t__login_error.id is '主键';
comment on column t__login_error.ipAddress is '';
comment on column t__login_error.insertDate is '';
--表加注释
comment on table t__login_error is '';

表创建语句如下:


create table t__pv_url(
	id integer,
	url varchar(100),
	ip_address varchar(100),
	customer_id int,
	insert_date datetime
);
--字段加注释
comment on column t__pv_url.id is '主键';
comment on column t__pv_url.url is '';
comment on column t__pv_url.ip_address is '';
comment on column t__pv_url.customer_id is '';
comment on column t__pv_url.insert_date is '';
--表加注释
comment on table t__pv_url is '';

表创建语句如下:


create table t__role(
	id integer,
	roleId int,
	roleName varchar(100),
	remark varchar(100)
);
--字段加注释
comment on column t__role.id is '主键';
comment on column t__role.roleId is '';
comment on column t__role.roleName is '';
comment on column t__role.remark is '';
--表加注释
comment on table t__role is '';

表创建语句如下:


create table t__role_tree(
	id integer,
	roleId int,
	nodeId int
);
--字段加注释
comment on column t__role_tree.id is '主键';
comment on column t__role_tree.roleId is '';
comment on column t__role_tree.nodeId is '';
--表加注释
comment on table t__role_tree is '';

表创建语句如下:


create table t__tree_menu(
	id integer,
	node_id int,
	super_node_id int,
	node_url varchar(100),
	node_level int,
	node_name varchar(100),
	orders int,
	remark varchar(100),
	state int
);
--字段加注释
comment on column t__tree_menu.id is '主键';
comment on column t__tree_menu.node_id is '';
comment on column t__tree_menu.super_node_id is '';
comment on column t__tree_menu.node_url is '';
comment on column t__tree_menu.node_level is '';
comment on column t__tree_menu.node_name is '';
comment on column t__tree_menu.orders is '';
comment on column t__tree_menu.remark is '';
comment on column t__tree_menu.state is '';
--表加注释
comment on table t__tree_menu is '';

表创建语句如下:


create table t__url_view(
	id integer,
	view_date varchar(100),
	pv int,
	uv int,
	ip int
);
--字段加注释
comment on column t__url_view.id is '主键';
comment on column t__url_view.view_date is '';
comment on column t__url_view.pv is '';
comment on column t__url_view.uv is '';
comment on column t__url_view.ip is '';
--表加注释
comment on table t__url_view is '';

表创建语句如下:


create table t__user(
	id integer,
	account varchar(100),
	password varchar(100),
	picUrl varchar(100),
	email varchar(100),
	state int,
	lastlogindate datetime,
	lastloginip varchar(100),
	errorcount int,
	errordate datetime,
	islock int,
	createdate datetime,
	phone int,
	userName varchar(100)
);
--字段加注释
comment on column t__user.id is '主键';
comment on column t__user.account is '';
comment on column t__user.password is '';
comment on column t__user.picUrl is '';
comment on column t__user.email is '';
comment on column t__user.state is '';
comment on column t__user.lastlogindate is '';
comment on column t__user.lastloginip is '';
comment on column t__user.errorcount is '';
comment on column t__user.errordate is '';
comment on column t__user.islock is '';
comment on column t__user.createdate is '';
comment on column t__user.phone is '';
comment on column t__user.userName is '';
--表加注释
comment on table t__user is '';

表创建语句如下:


create table t__user_role(
	id integer,
	roleId int,
	userId int
);
--字段加注释
comment on column t__user_role.id is '主键';
comment on column t__user_role.roleId is '';
comment on column t__user_role.userId is '';
--表加注释
comment on table t__user_role is '';

表创建语句如下:


create table t__uv_url(
	id integer,
	url varchar(100),
	ip_address varchar(100),
	customer_id int,
	insert_date datetime
);
--字段加注释
comment on column t__uv_url.id is '主键';
comment on column t__uv_url.url is '';
comment on column t__uv_url.ip_address is '';
comment on column t__uv_url.customer_id is '';
comment on column t__uv_url.insert_date is '';
--表加注释
comment on table t__uv_url is '';

一级分类表创建语句如下:


create table t_fenone(
	id integer,
	fenoneName varchar(100)
);
--一级分类字段加注释
comment on column t_fenone.id is '主键';
comment on column t_fenone.fenoneName is '名称';
--一级分类表加注释
comment on table t_fenone is '一级分类';

二级分类表创建语句如下:


create table t_fentwo(
	id integer,
	fenoneId int,
	fentwoName varchar(100)
);
--二级分类字段加注释
comment on column t_fentwo.id is '主键';
comment on column t_fentwo.fenoneId is '一级分类';
comment on column t_fentwo.fentwoName is '名称';
--二级分类表加注释
comment on table t_fentwo is '二级分类';

社情民意内容表创建语句如下:


create table t_my(
	id integer,
	title varchar(100),
	fenone varchar(100),
	fentwo varchar(100),
	bsdw varchar(100),
	jjcd varchar(100),
	xxly varchar(100),
	fyr varchar(100),
	pzr varchar(100),
	bjr varchar(100),
	bz varchar(100),
	zw varchar(100),
	fj varchar(100),
	status varchar(100),
	userId int,
	code int
);
--社情民意内容字段加注释
comment on column t_my.id is '主键';
comment on column t_my.title is '标题';
comment on column t_my.fenone is '一级分类';
comment on column t_my.fentwo is '二级分类';
comment on column t_my.bsdw is '报送单位';
comment on column t_my.jjcd is '紧急程度';
comment on column t_my.xxly is '信息来源';
comment on column t_my.fyr is '反映人';
comment on column t_my.pzr is '批准人';
comment on column t_my.bjr is '编辑人';
comment on column t_my.bz is '备注';
comment on column t_my.zw is '正文';
comment on column t_my.fj is '附件';
comment on column t_my.status is '状态';
comment on column t_my.userId is '当前用户';
comment on column t_my.code is '';
--社情民意内容表加注释
comment on table t_my is '社情民意内容';

oracle特有,对应序列如下:


create sequence s_t__city;
create sequence s_t__login_error;
create sequence s_t__pv_url;
create sequence s_t__role;
create sequence s_t__role_tree;
create sequence s_t__tree_menu;
create sequence s_t__url_view;
create sequence s_t__user;
create sequence s_t__user_role;
create sequence s_t__uv_url;
create sequence s_t_fenone;
create sequence s_t_fentwo;
create sequence s_t_my;

基于WEB的社情民意采集与管理系统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__city(
	id int identity(1,1) primary key not null,--主键
	region_id varchar(100),--
	region_name varchar(100),--
	level varchar(100),--
	parent_id varchar(100),--
	displayorder varchar(100)--
);

表创建语句如下:


--表注释
create table t__login_error(
	id int identity(1,1) primary key not null,--主键
	ipAddress varchar(100),--
	insertDate datetime--
);

表创建语句如下:


--表注释
create table t__pv_url(
	id int identity(1,1) primary key not null,--主键
	url varchar(100),--
	ip_address varchar(100),--
	customer_id int,--
	insert_date datetime--
);

表创建语句如下:


--表注释
create table t__role(
	id int identity(1,1) primary key not null,--主键
	roleId int,--
	roleName varchar(100),--
	remark varchar(100)--
);

表创建语句如下:


--表注释
create table t__role_tree(
	id int identity(1,1) primary key not null,--主键
	roleId int,--
	nodeId int--
);

表创建语句如下:


--表注释
create table t__tree_menu(
	id int identity(1,1) primary key not null,--主键
	node_id int,--
	super_node_id int,--
	node_url varchar(100),--
	node_level int,--
	node_name varchar(100),--
	orders int,--
	remark varchar(100),--
	state int--
);

表创建语句如下:


--表注释
create table t__url_view(
	id int identity(1,1) primary key not null,--主键
	view_date varchar(100),--
	pv int,--
	uv int,--
	ip int--
);

表创建语句如下:


--表注释
create table t__user(
	id int identity(1,1) primary key not null,--主键
	account varchar(100),--
	password varchar(100),--
	picUrl varchar(100),--
	email varchar(100),--
	state int,--
	lastlogindate datetime,--
	lastloginip varchar(100),--
	errorcount int,--
	errordate datetime,--
	islock int,--
	createdate datetime,--
	phone int,--
	userName varchar(100)--
);

表创建语句如下:


--表注释
create table t__user_role(
	id int identity(1,1) primary key not null,--主键
	roleId int,--
	userId int--
);

表创建语句如下:


--表注释
create table t__uv_url(
	id int identity(1,1) primary key not null,--主键
	url varchar(100),--
	ip_address varchar(100),--
	customer_id int,--
	insert_date datetime--
);

一级分类表创建语句如下:


--一级分类表注释
create table t_fenone(
	id int identity(1,1) primary key not null,--主键
	fenoneName varchar(100)--名称
);

二级分类表创建语句如下:


--二级分类表注释
create table t_fentwo(
	id int identity(1,1) primary key not null,--主键
	fenoneId int,--一级分类
	fentwoName varchar(100)--名称
);

社情民意内容表创建语句如下:


--社情民意内容表注释
create table t_my(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	fenone varchar(100),--一级分类
	fentwo varchar(100),--二级分类
	bsdw varchar(100),--报送单位
	jjcd varchar(100),--紧急程度
	xxly varchar(100),--信息来源
	fyr varchar(100),--反映人
	pzr varchar(100),--批准人
	bjr varchar(100),--编辑人
	bz varchar(100),--备注
	zw varchar(100),--正文
	fj varchar(100),--附件
	status varchar(100),--状态
	userId int,--当前用户
	code int--
);

基于WEB的社情民意采集与管理系统登录后主页

基于WEB的社情民意采集与管理系统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__city")
public class _city {
//主键
@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 region_id;
//
private String region_name;
//
private String level;
//
private String parent_id;
//
private String displayorder;
public String getRegion_id() {return region_id;}
public void setRegion_id(String region_id) {this.region_id = region_id;}
public String getRegion_name() {return region_name;}
public void setRegion_name(String region_name) {this.region_name = region_name;}
public String getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
public String getParent_id() {return parent_id;}
public void setParent_id(String parent_id) {this.parent_id = parent_id;}
public String getDisplayorder() {return displayorder;}
public void setDisplayorder(String displayorder) {this.displayorder = displayorder;}
}

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__login_error")
public class _login_error {
//主键
@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 ipAddress;
//
private Date insertDate;
public String getIpAddress() {return ipAddress;}
public void setIpAddress(String ipAddress) {this.ipAddress = ipAddress;}
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__pv_url")
public class _pv_url {
//主键
@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 url;
//
private String ip_address;
//
private Integer customer_id;
//
private Date insert_date;
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
public String getIp_address() {return ip_address;}
public void setIp_address(String ip_address) {this.ip_address = ip_address;}
public Integer getCustomer_id() {return customer_id;}
public void setCustomer_id(Integer customer_id) {this.customer_id = customer_id;}
public Date getInsert_date() {return insert_date;}
public void setInsert_date(Date insert_date) {this.insert_date = insert_date;}
}

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__role")
public class _role {
//主键
@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 roleId;
//
private String roleName;
//
private String remark;
public Integer getRoleId() {return roleId;}
public void setRoleId(Integer roleId) {this.roleId = roleId;}
public String getRoleName() {return roleName;}
public void setRoleName(String roleName) {this.roleName = roleName;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

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__role_tree")
public class _role_tree {
//主键
@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 roleId;
//
private Integer nodeId;
public Integer getRoleId() {return roleId;}
public void setRoleId(Integer roleId) {this.roleId = roleId;}
public Integer getNodeId() {return nodeId;}
public void setNodeId(Integer nodeId) {this.nodeId = nodeId;}
}

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__tree_menu")
public class _tree_menu {
//主键
@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 node_id;
//
private Integer super_node_id;
//
private String node_url;
//
private Integer node_level;
//
private String node_name;
//
private Integer orders;
//
private String remark;
//
private Integer state;
public Integer getNode_id() {return node_id;}
public void setNode_id(Integer node_id) {this.node_id = node_id;}
public Integer getSuper_node_id() {return super_node_id;}
public void setSuper_node_id(Integer super_node_id) {this.super_node_id = super_node_id;}
public String getNode_url() {return node_url;}
public void setNode_url(String node_url) {this.node_url = node_url;}
public Integer getNode_level() {return node_level;}
public void setNode_level(Integer node_level) {this.node_level = node_level;}
public String getNode_name() {return node_name;}
public void setNode_name(String node_name) {this.node_name = node_name;}
public Integer getOrders() {return orders;}
public void setOrders(Integer orders) {this.orders = orders;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getState() {return state;}
public void setState(Integer state) {this.state = state;}
}

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__url_view")
public class _url_view {
//主键
@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 view_date;
//
private Integer pv;
//
private Integer uv;
//
private Integer ip;
public String getView_date() {return view_date;}
public void setView_date(String view_date) {this.view_date = view_date;}
public Integer getPv() {return pv;}
public void setPv(Integer pv) {this.pv = pv;}
public Integer getUv() {return uv;}
public void setUv(Integer uv) {this.uv = uv;}
public Integer getIp() {return ip;}
public void setIp(Integer ip) {this.ip = ip;}
}

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__user")
public class _user {
//主键
@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 account;
//
private String password;
//
private String picUrl;
//
private String email;
//
private Integer state;
//
private Date lastlogindate;
//
private String lastloginip;
//
private Integer errorcount;
//
private Date errordate;
//
private Integer islock;
//
private Date createdate;
//
private Integer phone;
//
private String userName;
public String getAccount() {return account;}
public void setAccount(String account) {this.account = account;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getPicUrl() {return picUrl;}
public void setPicUrl(String picUrl) {this.picUrl = picUrl;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public Integer getState() {return state;}
public void setState(Integer state) {this.state = state;}
public Date getLastlogindate() {return lastlogindate;}
public void setLastlogindate(Date lastlogindate) {this.lastlogindate = lastlogindate;}
public String getLastloginip() {return lastloginip;}
public void setLastloginip(String lastloginip) {this.lastloginip = lastloginip;}
public Integer getErrorcount() {return errorcount;}
public void setErrorcount(Integer errorcount) {this.errorcount = errorcount;}
public Date getErrordate() {return errordate;}
public void setErrordate(Date errordate) {this.errordate = errordate;}
public Integer getIslock() {return islock;}
public void setIslock(Integer islock) {this.islock = islock;}
public Date getCreatedate() {return createdate;}
public void setCreatedate(Date createdate) {this.createdate = createdate;}
public Integer getPhone() {return phone;}
public void setPhone(Integer phone) {this.phone = phone;}
public String getUserName() {return userName;}
public void setUserName(String userName) {this.userName = userName;}
}

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__user_role")
public class _user_role {
//主键
@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 roleId;
//
private Integer userId;
public Integer getRoleId() {return roleId;}
public void setRoleId(Integer roleId) {this.roleId = roleId;}
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
}

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__uv_url")
public class _uv_url {
//主键
@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 url;
//
private String ip_address;
//
private Integer customer_id;
//
private Date insert_date;
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
public String getIp_address() {return ip_address;}
public void setIp_address(String ip_address) {this.ip_address = ip_address;}
public Integer getCustomer_id() {return customer_id;}
public void setCustomer_id(Integer customer_id) {this.customer_id = customer_id;}
public Date getInsert_date() {return insert_date;}
public void setInsert_date(Date insert_date) {this.insert_date = insert_date;}
}

一级分类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_fenone")
public class Fenone {
//主键
@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 fenoneName;
public String getFenoneName() {return fenoneName;}
public void setFenoneName(String fenoneName) {this.fenoneName = fenoneName;}
}

二级分类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_fentwo")
public class Fentwo {
//主键
@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 fenoneId;
//名称
private String fentwoName;
public Integer getFenoneId() {return fenoneId;}
public void setFenoneId(Integer fenoneId) {this.fenoneId = fenoneId;}
public String getFentwoName() {return fentwoName;}
public void setFentwoName(String fentwoName) {this.fentwoName = fentwoName;}
}

社情民意内容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_my")
public class My {
//主键
@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 fenone;
//二级分类
private String fentwo;
//报送单位
private String bsdw;
//紧急程度
private String jjcd;
//信息来源
private String xxly;
//反映人
private String fyr;
//批准人
private String pzr;
//编辑人
private String bjr;
//备注
private String bz;
//正文
private String zw;
//附件
private String fj;
//状态
private String status;
//当前用户
private Integer userId;
//
private Integer code;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFenone() {return fenone;}
public void setFenone(String fenone) {this.fenone = fenone;}
public String getFentwo() {return fentwo;}
public void setFentwo(String fentwo) {this.fentwo = fentwo;}
public String getBsdw() {return bsdw;}
public void setBsdw(String bsdw) {this.bsdw = bsdw;}
public String getJjcd() {return jjcd;}
public void setJjcd(String jjcd) {this.jjcd = jjcd;}
public String getXxly() {return xxly;}
public void setXxly(String xxly) {this.xxly = xxly;}
public String getFyr() {return fyr;}
public void setFyr(String fyr) {this.fyr = fyr;}
public String getPzr() {return pzr;}
public void setPzr(String pzr) {this.pzr = pzr;}
public String getBjr() {return bjr;}
public void setBjr(String bjr) {this.bjr = bjr;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public Integer getCode() {return code;}
public void setCode(Integer code) {this.code = code;}
}

基于WEB的社情民意采集与管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

javaBean创建语句如下:


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

//
public class _city  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String region_id;
//
private String region_name;
//
private String level;
//
private String parent_id;
//
private String displayorder;
public String getRegion_id() {return region_id;}
public void setRegion_id(String region_id) {this.region_id = region_id;}
public String getRegion_name() {return region_name;}
public void setRegion_name(String region_name) {this.region_name = region_name;}
public String getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
public String getParent_id() {return parent_id;}
public void setParent_id(String parent_id) {this.parent_id = parent_id;}
public String getDisplayorder() {return displayorder;}
public void setDisplayorder(String displayorder) {this.displayorder = displayorder;}
}

javaBean创建语句如下:


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

//
public class _login_error  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String ipAddress;
//
private Date insertDate;
public String getIpAddress() {return ipAddress;}
public void setIpAddress(String ipAddress) {this.ipAddress = ipAddress;}
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 _pv_url  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String url;
//
private String ip_address;
//
private Integer customer_id;
//
private Date insert_date;
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
public String getIp_address() {return ip_address;}
public void setIp_address(String ip_address) {this.ip_address = ip_address;}
public Integer getCustomer_id() {return customer_id;}
public void setCustomer_id(Integer customer_id) {this.customer_id = customer_id;}
public Date getInsert_date() {return insert_date;}
public void setInsert_date(Date insert_date) {this.insert_date = insert_date;}
}

javaBean创建语句如下:


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

//
public class _role  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer roleId;
//
private String roleName;
//
private String remark;
public Integer getRoleId() {return roleId;}
public void setRoleId(Integer roleId) {this.roleId = roleId;}
public String getRoleName() {return roleName;}
public void setRoleName(String roleName) {this.roleName = roleName;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

javaBean创建语句如下:


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

//
public class _role_tree  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer roleId;
//
private Integer nodeId;
public Integer getRoleId() {return roleId;}
public void setRoleId(Integer roleId) {this.roleId = roleId;}
public Integer getNodeId() {return nodeId;}
public void setNodeId(Integer nodeId) {this.nodeId = nodeId;}
}

javaBean创建语句如下:


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

//
public class _tree_menu  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer node_id;
//
private Integer super_node_id;
//
private String node_url;
//
private Integer node_level;
//
private String node_name;
//
private Integer orders;
//
private String remark;
//
private Integer state;
public Integer getNode_id() {return node_id;}
public void setNode_id(Integer node_id) {this.node_id = node_id;}
public Integer getSuper_node_id() {return super_node_id;}
public void setSuper_node_id(Integer super_node_id) {this.super_node_id = super_node_id;}
public String getNode_url() {return node_url;}
public void setNode_url(String node_url) {this.node_url = node_url;}
public Integer getNode_level() {return node_level;}
public void setNode_level(Integer node_level) {this.node_level = node_level;}
public String getNode_name() {return node_name;}
public void setNode_name(String node_name) {this.node_name = node_name;}
public Integer getOrders() {return orders;}
public void setOrders(Integer orders) {this.orders = orders;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getState() {return state;}
public void setState(Integer state) {this.state = state;}
}

javaBean创建语句如下:


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

//
public class _url_view  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String view_date;
//
private Integer pv;
//
private Integer uv;
//
private Integer ip;
public String getView_date() {return view_date;}
public void setView_date(String view_date) {this.view_date = view_date;}
public Integer getPv() {return pv;}
public void setPv(Integer pv) {this.pv = pv;}
public Integer getUv() {return uv;}
public void setUv(Integer uv) {this.uv = uv;}
public Integer getIp() {return ip;}
public void setIp(Integer ip) {this.ip = ip;}
}

javaBean创建语句如下:


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

//
public class _user  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String account;
//
private String password;
//
private String picUrl;
//
private String email;
//
private Integer state;
//
private Date lastlogindate;
//
private String lastloginip;
//
private Integer errorcount;
//
private Date errordate;
//
private Integer islock;
//
private Date createdate;
//
private Integer phone;
//
private String userName;
public String getAccount() {return account;}
public void setAccount(String account) {this.account = account;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getPicUrl() {return picUrl;}
public void setPicUrl(String picUrl) {this.picUrl = picUrl;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public Integer getState() {return state;}
public void setState(Integer state) {this.state = state;}
public Date getLastlogindate() {return lastlogindate;}
public void setLastlogindate(Date lastlogindate) {this.lastlogindate = lastlogindate;}
public String getLastloginip() {return lastloginip;}
public void setLastloginip(String lastloginip) {this.lastloginip = lastloginip;}
public Integer getErrorcount() {return errorcount;}
public void setErrorcount(Integer errorcount) {this.errorcount = errorcount;}
public Date getErrordate() {return errordate;}
public void setErrordate(Date errordate) {this.errordate = errordate;}
public Integer getIslock() {return islock;}
public void setIslock(Integer islock) {this.islock = islock;}
public Date getCreatedate() {return createdate;}
public void setCreatedate(Date createdate) {this.createdate = createdate;}
public Integer getPhone() {return phone;}
public void setPhone(Integer phone) {this.phone = phone;}
public String getUserName() {return userName;}
public void setUserName(String userName) {this.userName = userName;}
}

javaBean创建语句如下:


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

//
public class _user_role  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer roleId;
//
private Integer userId;
public Integer getRoleId() {return roleId;}
public void setRoleId(Integer roleId) {this.roleId = roleId;}
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
}

javaBean创建语句如下:


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

//
public class _uv_url  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String url;
//
private String ip_address;
//
private Integer customer_id;
//
private Date insert_date;
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
public String getIp_address() {return ip_address;}
public void setIp_address(String ip_address) {this.ip_address = ip_address;}
public Integer getCustomer_id() {return customer_id;}
public void setCustomer_id(Integer customer_id) {this.customer_id = customer_id;}
public Date getInsert_date() {return insert_date;}
public void setInsert_date(Date insert_date) {this.insert_date = insert_date;}
}

一级分类javaBean创建语句如下:


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

//一级分类
public class Fenone  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//名称
private String fenoneName;
public String getFenoneName() {return fenoneName;}
public void setFenoneName(String fenoneName) {this.fenoneName = fenoneName;}
}

二级分类javaBean创建语句如下:


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

//二级分类
public class Fentwo  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//一级分类
private Integer fenoneId;
//名称
private String fentwoName;
public Integer getFenoneId() {return fenoneId;}
public void setFenoneId(Integer fenoneId) {this.fenoneId = fenoneId;}
public String getFentwoName() {return fentwoName;}
public void setFentwoName(String fentwoName) {this.fentwoName = fentwoName;}
}

社情民意内容javaBean创建语句如下:


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

//社情民意内容
public class My  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//一级分类
private String fenone;
//二级分类
private String fentwo;
//报送单位
private String bsdw;
//紧急程度
private String jjcd;
//信息来源
private String xxly;
//反映人
private String fyr;
//批准人
private String pzr;
//编辑人
private String bjr;
//备注
private String bz;
//正文
private String zw;
//附件
private String fj;
//状态
private String status;
//当前用户
private Integer userId;
//
private Integer code;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFenone() {return fenone;}
public void setFenone(String fenone) {this.fenone = fenone;}
public String getFentwo() {return fentwo;}
public void setFentwo(String fentwo) {this.fentwo = fentwo;}
public String getBsdw() {return bsdw;}
public void setBsdw(String bsdw) {this.bsdw = bsdw;}
public String getJjcd() {return jjcd;}
public void setJjcd(String jjcd) {this.jjcd = jjcd;}
public String getXxly() {return xxly;}
public void setXxly(String xxly) {this.xxly = xxly;}
public String getFyr() {return fyr;}
public void setFyr(String fyr) {this.fyr = fyr;}
public String getPzr() {return pzr;}
public void setPzr(String pzr) {this.pzr = pzr;}
public String getBjr() {return bjr;}
public void setBjr(String bjr) {this.bjr = bjr;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public Integer getCode() {return code;}
public void setCode(Integer code) {this.code = code;}
}

评论