- 学生业务审批系统mysql数据库创建语句
- 学生业务审批系统oracle数据库创建语句
- 学生业务审批系统sqlserver数据库创建语句
- 学生业务审批系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 学生业务审批系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
学生业务审批系统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_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号(学号，工号)',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
zjz varchar(100) comment '证件照',
email varchar(100) comment '邮箱',
js varchar(100) comment '角色',
phone varchar(100) comment '电话'
) comment '用户';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '标题',
showDate datetime comment '日期',
v3 varchar(100) comment '内容'
) comment '公告';
高级管理员表创建语句如下：
create table t_gjadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
gjadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话'
) comment '高级管理员';
通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
txName varchar(100) comment '标题',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '通知';
上一级业务审批人员表创建语句如下：
create table t_ywadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ywadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话'
) comment '上一级业务审批人员';
业务审批表创建语句如下：
create table t_ywsp(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
types varchar(100) comment '类别',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
pic varchar(100) comment '图片',
fileUlr varchar(100) comment '附件',
insertDate datetime comment '发送日期',
back varchar(100) comment '回复批注',
hfr varchar(100) comment '回复人',
hfsj datetime comment '回复时间',
status varchar(100) 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_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
zjz varchar(100),
email varchar(100),
js varchar(100),
phone 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.zjz is '证件照';
comment on column t_customer.email is '邮箱';
comment on column t_customer.js is '角色';
comment on column t_customer.phone is '电话';
--用户表加注释
comment on table t_customer is '用户';
公告表创建语句如下：
create table t_gg(
id integer,
v1 varchar(100),
showDate datetime,
v3 varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--公告表加注释
comment on table t_gg is '公告';
高级管理员表创建语句如下：
create table t_gjadmin(
id integer,
username varchar(100),
password varchar(100),
gjadminName varchar(100),
phone varchar(100)
);
--高级管理员字段加注释
comment on column t_gjadmin.id is '主键';
comment on column t_gjadmin.username is '账号';
comment on column t_gjadmin.password is '密码';
comment on column t_gjadmin.gjadminName is '姓名';
comment on column t_gjadmin.phone is '电话';
--高级管理员表加注释
comment on table t_gjadmin is '高级管理员';
通知表创建语句如下：
create table t_tongzhi(
id integer,
customerId int,
txName varchar(100),
content varchar(100),
insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.customerId is '用户';
comment on column t_tongzhi.txName is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知表加注释
comment on table t_tongzhi is '通知';
上一级业务审批人员表创建语句如下：
create table t_ywadmin(
id integer,
username varchar(100),
password varchar(100),
ywadminName varchar(100),
phone varchar(100)
);
--上一级业务审批人员字段加注释
comment on column t_ywadmin.id is '主键';
comment on column t_ywadmin.username is '账号';
comment on column t_ywadmin.password is '密码';
comment on column t_ywadmin.ywadminName is '姓名';
comment on column t_ywadmin.phone is '电话';
--上一级业务审批人员表加注释
comment on table t_ywadmin is '上一级业务审批人员';
业务审批表创建语句如下：
create table t_ywsp(
id integer,
customerId int,
types varchar(100),
title varchar(100),
content varchar(100),
pic varchar(100),
fileUlr varchar(100),
insertDate datetime,
back varchar(100),
hfr varchar(100),
hfsj datetime,
status varchar(100)
);
--业务审批字段加注释
comment on column t_ywsp.id is '主键';
comment on column t_ywsp.customerId is '用户';
comment on column t_ywsp.types is '类别';
comment on column t_ywsp.title is '标题';
comment on column t_ywsp.content is '内容';
comment on column t_ywsp.pic is '图片';
comment on column t_ywsp.fileUlr is '附件';
comment on column t_ywsp.insertDate is '发送日期';
comment on column t_ywsp.back is '回复批注';
comment on column t_ywsp.hfr is '回复人';
comment on column t_ywsp.hfsj is '回复时间';
comment on column t_ywsp.status is '状态';
--业务审批表加注释
comment on table t_ywsp is '业务审批';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_gjadmin;
create sequence s_t_tongzhi;
create sequence s_t_ywadmin;
create sequence s_t_ywsp;
学生业务审批系统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_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号(学号，工号)
password varchar(100),--密码
customerName varchar(100),--姓名
zjz varchar(100),--证件照
email varchar(100),--邮箱
js varchar(100),--角色
phone varchar(100)--电话
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--标题
showDate datetime,--日期
v3 varchar(100)--内容
);
高级管理员表创建语句如下：
--高级管理员表注释
create table t_gjadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
gjadminName varchar(100),--姓名
phone varchar(100)--电话
);
通知表创建语句如下：
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
txName varchar(100),--标题
content varchar(100),--内容
insertDate datetime--日期
);
上一级业务审批人员表创建语句如下：
--上一级业务审批人员表注释
create table t_ywadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ywadminName varchar(100),--姓名
phone varchar(100)--电话
);
业务审批表创建语句如下：
--业务审批表注释
create table t_ywsp(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
types varchar(100),--类别
title varchar(100),--标题
content varchar(100),--内容
pic varchar(100),--图片
fileUlr varchar(100),--附件
insertDate datetime,--发送日期
back varchar(100),--回复批注
hfr varchar(100),--回复人
hfsj datetime,--回复时间
status varchar(100)--状态
);
登录后主页.jpg?x-oss-process=style/00001)
学生业务审批系统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_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 zjz;
//邮箱
private String email;
//角色
private String js;
//电话
private String phone;
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 getZjz() {return zjz;}
public void setZjz(String zjz) {this.zjz = zjz;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}公告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_gg")
public class Gg {
//主键
@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 v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}高级管理员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_gjadmin")
public class Gjadmin {
//主键
@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 gjadminName;
//电话
private String phone;
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 getGjadminName() {return gjadminName;}
public void setGjadminName(String gjadminName) {this.gjadminName = gjadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}通知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_tongzhi")
public class Tongzhi {
//主键
@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 txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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_ywadmin")
public class Ywadmin {
//主键
@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 ywadminName;
//电话
private String phone;
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 getYwadminName() {return ywadminName;}
public void setYwadminName(String ywadminName) {this.ywadminName = ywadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}业务审批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_ywsp")
public class Ywsp {
//主键
@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 types;
//标题
private String title;
//内容
private String content;
//图片
private String pic;
//附件
private String fileUlr;
//发送日期
private Date insertDate;
//回复批注
private String back;
//回复人
private String hfr;
//回复时间
private Date hfsj;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 getFileUlr() {return fileUlr;}
public void setFileUlr(String fileUlr) {this.fileUlr = fileUlr;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getHfr() {return hfr;}
public void setHfr(String hfr) {this.hfr = hfr;}
public Date getHfsj() {return hfsj;}
public void setHfsj(Date hfsj) {this.hfsj = hfsj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}学生业务审批系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
用户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 zjz;
//邮箱
private String email;
//角色
private String js;
//电话
private String phone;
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 getZjz() {return zjz;}
public void setZjz(String zjz) {this.zjz = zjz;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}高级管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//高级管理员
public class Gjadmin 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 gjadminName;
//电话
private String phone;
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 getGjadminName() {return gjadminName;}
public void setGjadminName(String gjadminName) {this.gjadminName = gjadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}通知javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//通知
public class Tongzhi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//标题
private String txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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 Ywadmin 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 ywadminName;
//电话
private String phone;
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 getYwadminName() {return ywadminName;}
public void setYwadminName(String ywadminName) {this.ywadminName = ywadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}业务审批javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//业务审批
public class Ywsp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//类别
private String types;
//标题
private String title;
//内容
private String content;
//图片
private String pic;
//附件
private String fileUlr;
//发送日期
private Date insertDate;
//回复批注
private String back;
//回复人
private String hfr;
//回复时间
private Date hfsj;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 getFileUlr() {return fileUlr;}
public void setFileUlr(String fileUlr) {this.fileUlr = fileUlr;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getHfr() {return hfr;}
public void setHfr(String hfr) {this.hfr = hfr;}
public Date getHfsj() {return hfsj;}
public void setHfsj(Date hfsj) {this.hfsj = hfsj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}