绿色植物养护管理系统的设计与实现

绿色植物养护管理系统的设计与实现登录注册界面

绿色植物养护管理系统的设计与实现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_clikcsave(
	id int primary key auto_increment comment '主键',
	customerId int comment '',
	insertDate datetime comment '',
	zwxxId int comment ''
) comment '查看记录';

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


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

植物类型表创建语句如下:


create table t_types(
	id int primary key auto_increment comment '主键',
	typesName varchar(100) comment '类型名称'
) comment '植物类型';

问题表创建语句如下:


create table t_wt(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '问题描述',
	pic varchar(100) comment '图片',
	content varchar(100) comment '详细说明',
	customerId int comment '用户',
	insertDate datetime comment '发起日期',
	hdr varchar(100) comment '回答人',
	hdDate datetime comment '回答日期',
	back varchar(100) comment '回复内容',
	status varchar(100) comment '状态'
) comment '问题';

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


create table t_zjadmin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	zjadminName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment ''
) comment '中级管理员';

植物信息表创建语句如下:


create table t_zwxx(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '名称',
	pic varchar(100) comment '图片',
	content varchar(100) comment '详细说明',
	status varchar(100) comment '状态',
	addName varchar(100) comment '添加人',
	typesId int comment ''
) comment '植物信息';

绿色植物养护管理系统的设计与实现oracle数据库版本源码:

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


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

查看记录表创建语句如下:


create table t_clikcsave(
	id integer,
	customerId int,
	insertDate datetime,
	zwxxId int
);
--查看记录字段加注释
comment on column t_clikcsave.id is '主键';
comment on column t_clikcsave.customerId is '';
comment on column t_clikcsave.insertDate is '';
comment on column t_clikcsave.zwxxId is '';
--查看记录表加注释
comment on table t_clikcsave is '查看记录';

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


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

植物类型表创建语句如下:


create table t_types(
	id integer,
	typesName varchar(100)
);
--植物类型字段加注释
comment on column t_types.id is '主键';
comment on column t_types.typesName is '类型名称';
--植物类型表加注释
comment on table t_types is '植物类型';

问题表创建语句如下:


create table t_wt(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	customerId int,
	insertDate datetime,
	hdr varchar(100),
	hdDate datetime,
	back varchar(100),
	status varchar(100)
);
--问题字段加注释
comment on column t_wt.id is '主键';
comment on column t_wt.title is '问题描述';
comment on column t_wt.pic is '图片';
comment on column t_wt.content is '详细说明';
comment on column t_wt.customerId is '用户';
comment on column t_wt.insertDate is '发起日期';
comment on column t_wt.hdr is '回答人';
comment on column t_wt.hdDate is '回答日期';
comment on column t_wt.back is '回复内容';
comment on column t_wt.status is '状态';
--问题表加注释
comment on table t_wt is '问题';

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


create table t_zjadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	zjadminName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic varchar(100)
);
--中级管理员字段加注释
comment on column t_zjadmin.id is '主键';
comment on column t_zjadmin.username is '账号';
comment on column t_zjadmin.password is '密码';
comment on column t_zjadmin.zjadminName is '姓名';
comment on column t_zjadmin.age is '年龄';
comment on column t_zjadmin.sex is '性别';
comment on column t_zjadmin.phone is '电话';
comment on column t_zjadmin.pic is '';
--中级管理员表加注释
comment on table t_zjadmin is '中级管理员';

植物信息表创建语句如下:


create table t_zwxx(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	status varchar(100),
	addName varchar(100),
	typesId int
);
--植物信息字段加注释
comment on column t_zwxx.id is '主键';
comment on column t_zwxx.title is '名称';
comment on column t_zwxx.pic is '图片';
comment on column t_zwxx.content is '详细说明';
comment on column t_zwxx.status is '状态';
comment on column t_zwxx.addName is '添加人';
comment on column t_zwxx.typesId is '';
--植物信息表加注释
comment on table t_zwxx is '植物信息';

oracle特有,对应序列如下:


create sequence s_t_clikcsave;
create sequence s_t_customer;
create sequence s_t_types;
create sequence s_t_wt;
create sequence s_t_zjadmin;
create sequence s_t_zwxx;

绿色植物养护管理系统的设计与实现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_clikcsave(
	id int identity(1,1) primary key not null,--主键
	customerId int,--
	insertDate datetime,--
	zwxxId int--
);

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


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

植物类型表创建语句如下:


--植物类型表注释
create table t_types(
	id int identity(1,1) primary key not null,--主键
	typesName varchar(100)--类型名称
);

问题表创建语句如下:


--问题表注释
create table t_wt(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--问题描述
	pic varchar(100),--图片
	content varchar(100),--详细说明
	customerId int,--用户
	insertDate datetime,--发起日期
	hdr varchar(100),--回答人
	hdDate datetime,--回答日期
	back varchar(100),--回复内容
	status varchar(100)--状态
);

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


--中级管理员表注释
create table t_zjadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	zjadminName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100)--
);

植物信息表创建语句如下:


--植物信息表注释
create table t_zwxx(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--名称
	pic varchar(100),--图片
	content varchar(100),--详细说明
	status varchar(100),--状态
	addName varchar(100),--添加人
	typesId int--
);

绿色植物养护管理系统的设计与实现登录后主页

绿色植物养护管理系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计:

查看记录javaBean创建语句如下:


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

//查看记录
@Table(name = "t_clikcsave")
public class Clikcsave {
//主键
@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 Date insertDate;
//
private Integer zwxxId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getZwxxId() {return zwxxId;}
public void setZwxxId(Integer zwxxId) {this.zwxxId = zwxxId;}
}

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


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

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

植物类型javaBean创建语句如下:


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

//植物类型
@Table(name = "t_types")
public class Types {
//主键
@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 typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}

问题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_wt")
public class Wt {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//问题描述
private String title;
//图片
private String pic;
//详细说明
private String content;
//用户
private Integer customerId;
//发起日期
private Date insertDate;
//回答人
private String hdr;
//回答日期
private Date hdDate;
//回复内容
private String back;
//状态
private String status;
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 getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getHdr() {return hdr;}
public void setHdr(String hdr) {this.hdr = hdr;}
public Date getHdDate() {return hdDate;}
public void setHdDate(Date hdDate) {this.hdDate = hdDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

中级管理员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_zjadmin")
public class Zjadmin {
//主键
@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 zjadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//
private String pic;
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 getZjadminName() {return zjadminName;}
public void setZjadminName(String zjadminName) {this.zjadminName = zjadminName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

植物信息javaBean创建语句如下:


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

//植物信息
@Table(name = "t_zwxx")
public class Zwxx {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//名称
private String title;
//图片
private String pic;
//详细说明
private String content;
//状态
private String status;
//添加人
private String addName;
//
private Integer typesId;
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 String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getAddName() {return addName;}
public void setAddName(String addName) {this.addName = addName;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
}

绿色植物养护管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

查看记录javaBean创建语句如下:


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

//查看记录
public class Clikcsave  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer customerId;
//
private Date insertDate;
//
private Integer zwxxId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getZwxxId() {return zwxxId;}
public void setZwxxId(Integer zwxxId) {this.zwxxId = zwxxId;}
}

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


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

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

植物类型javaBean创建语句如下:


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

//植物类型
public class Types  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型名称
private String typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}

问题javaBean创建语句如下:


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

//问题
public class Wt  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//问题描述
private String title;
//图片
private String pic;
//详细说明
private String content;
//用户
private Integer customerId;
//发起日期
private Date insertDate;
//回答人
private String hdr;
//回答日期
private Date hdDate;
//回复内容
private String back;
//状态
private String status;
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 getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getHdr() {return hdr;}
public void setHdr(String hdr) {this.hdr = hdr;}
public Date getHdDate() {return hdDate;}
public void setHdDate(Date hdDate) {this.hdDate = hdDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

中级管理员javaBean创建语句如下:


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

//中级管理员
public class Zjadmin  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 zjadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//
private String pic;
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 getZjadminName() {return zjadminName;}
public void setZjadminName(String zjadminName) {this.zjadminName = zjadminName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

植物信息javaBean创建语句如下:


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

//植物信息
public class Zwxx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//名称
private String title;
//图片
private String pic;
//详细说明
private String content;
//状态
private String status;
//添加人
private String addName;
//
private Integer typesId;
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 String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getAddName() {return addName;}
public void setAddName(String addName) {this.addName = addName;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
}

源代码下载点这里

评论