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

基于JSP的环境保护与宣传平台,基于java的毕业设计

基于JSP的环境保护与宣传平台登录注册界面

基于JSP的环境保护与宣传平台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_contact(
	id int primary key auto_increment comment '主键',
	name varchar(100) comment '姓名',
	email varchar(100) comment '邮箱',
	subject varchar(100) comment '建议',
	message 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 '入库日期'
) comment '用户';

保护人士表创建语句如下:


create table t_people(
	id int primary key auto_increment comment '主键',
	peopleName varchar(100) comment '姓名',
	peopleUrl varchar(100) comment '图片'
) comment '保护人士';

评论表创建语句如下:


create table t_scpl(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	sctpId int comment '图片',
	content varchar(100) comment '内容',
	insertDate datetime comment '日期'
) comment '评论';

图片表创建语句如下:


create table t_sctp(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	pic varchar(100) comment '图片',
	zan int comment '赞',
	cai int comment '踩'
) comment '图片';

宣传图片表创建语句如下:


create table t_tp(
	id int primary key auto_increment comment '主键',
	peopleUrl varchar(100) comment '图片'
) comment '宣传图片';

基于JSP的环境保护与宣传平台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_contact(
	id integer,
	name varchar(100),
	email varchar(100),
	subject varchar(100),
	message varchar(100)
);
--联系我们字段加注释
comment on column t_contact.id is '主键';
comment on column t_contact.name is '姓名';
comment on column t_contact.email is '邮箱';
comment on column t_contact.subject is '建议';
comment on column t_contact.message is '消息';
--联系我们表加注释
comment on table t_contact 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
);
--用户字段加注释
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 table t_customer is '用户';

保护人士表创建语句如下:


create table t_people(
	id integer,
	peopleName varchar(100),
	peopleUrl varchar(100)
);
--保护人士字段加注释
comment on column t_people.id is '主键';
comment on column t_people.peopleName is '姓名';
comment on column t_people.peopleUrl is '图片';
--保护人士表加注释
comment on table t_people is '保护人士';

评论表创建语句如下:


create table t_scpl(
	id integer,
	customerId int,
	sctpId int,
	content varchar(100),
	insertDate datetime
);
--评论字段加注释
comment on column t_scpl.id is '主键';
comment on column t_scpl.customerId is '用户';
comment on column t_scpl.sctpId is '图片';
comment on column t_scpl.content is '内容';
comment on column t_scpl.insertDate is '日期';
--评论表加注释
comment on table t_scpl is '评论';

图片表创建语句如下:


create table t_sctp(
	id integer,
	customerId int,
	pic varchar(100),
	zan int,
	cai int
);
--图片字段加注释
comment on column t_sctp.id is '主键';
comment on column t_sctp.customerId is '用户';
comment on column t_sctp.pic is '图片';
comment on column t_sctp.zan is '赞';
comment on column t_sctp.cai is '踩';
--图片表加注释
comment on table t_sctp is '图片';

宣传图片表创建语句如下:


create table t_tp(
	id integer,
	peopleUrl varchar(100)
);
--宣传图片字段加注释
comment on column t_tp.id is '主键';
comment on column t_tp.peopleUrl is '图片';
--宣传图片表加注释
comment on table t_tp is '宣传图片';

oracle特有,对应序列如下:


create sequence s_t_contact;
create sequence s_t_customer;
create sequence s_t_people;
create sequence s_t_scpl;
create sequence s_t_sctp;
create sequence s_t_tp;

基于JSP的环境保护与宣传平台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_contact(
	id int identity(1,1) primary key not null,--主键
	name varchar(100),--姓名
	email varchar(100),--邮箱
	subject varchar(100),--建议
	message 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--入库日期
);

保护人士表创建语句如下:


--保护人士表注释
create table t_people(
	id int identity(1,1) primary key not null,--主键
	peopleName varchar(100),--姓名
	peopleUrl varchar(100)--图片
);

评论表创建语句如下:


--评论表注释
create table t_scpl(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	sctpId int,--图片
	content varchar(100),--内容
	insertDate datetime--日期
);

图片表创建语句如下:


--图片表注释
create table t_sctp(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	pic varchar(100),--图片
	zan int,--赞
	cai int--踩
);

宣传图片表创建语句如下:


--宣传图片表注释
create table t_tp(
	id int identity(1,1) primary key not null,--主键
	peopleUrl varchar(100)--图片
);

基于JSP的环境保护与宣传平台登录后主页

基于JSP的环境保护与宣传平台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_contact")
public class Contact {
//主键
@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 name;
//邮箱
private String email;
//建议
private String subject;
//消息
private String message;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getSubject() {return subject;}
public void setSubject(String subject) {this.subject = subject;}
public String getMessage() {return message;}
public void setMessage(String message) {this.message = message;}
}

用户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;
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;}
}

保护人士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_people")
public class People {
//主键
@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 peopleName;
//图片
private String peopleUrl;
public String getPeopleName() {return peopleName;}
public void setPeopleName(String peopleName) {this.peopleName = peopleName;}
public String getPeopleUrl() {return peopleUrl;}
public void setPeopleUrl(String peopleUrl) {this.peopleUrl = peopleUrl;}
}

评论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_scpl")
public class Scpl {
//主键
@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 sctpId;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getSctpId() {return sctpId;}
public void setSctpId(Integer sctpId) {this.sctpId = sctpId;}
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_sctp")
public class Sctp {
//主键
@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 pic;
//赞
private Integer zan;
//踩
private Integer cai;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getZan() {return zan;}
public void setZan(Integer zan) {this.zan = zan;}
public Integer getCai() {return cai;}
public void setCai(Integer cai) {this.cai = cai;}
}

宣传图片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_tp")
public class Tp {
//主键
@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 peopleUrl;
public String getPeopleUrl() {return peopleUrl;}
public void setPeopleUrl(String peopleUrl) {this.peopleUrl = peopleUrl;}
}

基于JSP的环境保护与宣传平台spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

联系我们javaBean创建语句如下:


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

//联系我们
public class Contact  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String name;
//邮箱
private String email;
//建议
private String subject;
//消息
private String message;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getSubject() {return subject;}
public void setSubject(String subject) {this.subject = subject;}
public String getMessage() {return message;}
public void setMessage(String message) {this.message = message;}
}

用户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;
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;}
}

保护人士javaBean创建语句如下:


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

//保护人士
public class People  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String peopleName;
//图片
private String peopleUrl;
public String getPeopleName() {return peopleName;}
public void setPeopleName(String peopleName) {this.peopleName = peopleName;}
public String getPeopleUrl() {return peopleUrl;}
public void setPeopleUrl(String peopleUrl) {this.peopleUrl = peopleUrl;}
}

评论javaBean创建语句如下:


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

//评论
public class Scpl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//图片
private Integer sctpId;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getSctpId() {return sctpId;}
public void setSctpId(Integer sctpId) {this.sctpId = sctpId;}
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 Sctp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//图片
private String pic;
//赞
private Integer zan;
//踩
private Integer cai;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getZan() {return zan;}
public void setZan(Integer zan) {this.zan = zan;}
public Integer getCai() {return cai;}
public void setCai(Integer cai) {this.cai = cai;}
}

宣传图片javaBean创建语句如下:


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

//宣传图片
public class Tp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//图片
private String peopleUrl;
public String getPeopleUrl() {return peopleUrl;}
public void setPeopleUrl(String peopleUrl) {this.peopleUrl = peopleUrl;}
}

评论