- 个人计划管理系统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 '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
sfz varchar(100) comment '身份证',
zz varchar(100) comment '住址'
) comment '用户';
公告表创建语句如下：
create table t_gonggao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '发起日期'
) comment '公告';
项目类型表创建语句如下：
create table t_lx(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
lxName varchar(100) comment '项目类型'
) comment '项目类型';
留言反馈表创建语句如下：
create table t_ly(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
content text comment '内容',
insertDate datetime comment '发起日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '留言反馈';
计划教学表创建语句如下：
create table t_sp(
id int primary key auto_increment comment '主键',
spName varchar(100) comment '教学名称',
link varchar(100) comment '视频地址',
remark text comment '内容说明',
showDate datetime comment '日期'
) comment '计划教学';
项目名称表创建语句如下：
create table t_xm(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
lxId int comment '项目类型',
xmName varchar(100) comment '项目名称'
) comment '项目名称';
项目打卡表创建语句如下：
create table t_xmlist(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
xmId int comment '项目',
insertDate datetime comment '打卡日期',
sc 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_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
sfz varchar(100),
zz 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.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '';
comment on column t_customer.sfz is '身份证';
comment on column t_customer.zz is '住址';
--用户表加注释
comment on table t_customer is '用户';
公告表创建语句如下：
create table t_gonggao(
id integer,
title varchar(100),
content text,
insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.insertDate is '发起日期';
--公告表加注释
comment on table t_gonggao is '公告';
项目类型表创建语句如下：
create table t_lx(
id integer,
customerId int,
lxName varchar(100)
);
--项目类型字段加注释
comment on column t_lx.id is '主键';
comment on column t_lx.customerId is '用户';
comment on column t_lx.lxName is '项目类型';
--项目类型表加注释
comment on table t_lx is '项目类型';
留言反馈表创建语句如下：
create table t_ly(
id integer,
customerId int,
content text,
insertDate datetime,
back text,
status varchar(100)
);
--留言反馈字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.customerId is '用户';
comment on column t_ly.content is '内容';
comment on column t_ly.insertDate is '发起日期';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--留言反馈表加注释
comment on table t_ly is '留言反馈';
计划教学表创建语句如下：
create table t_sp(
id integer,
spName varchar(100),
link varchar(100),
remark text,
showDate datetime
);
--计划教学字段加注释
comment on column t_sp.id is '主键';
comment on column t_sp.spName is '教学名称';
comment on column t_sp.link is '视频地址';
comment on column t_sp.remark is '内容说明';
comment on column t_sp.showDate is '日期';
--计划教学表加注释
comment on table t_sp is '计划教学';
项目名称表创建语句如下：
create table t_xm(
id integer,
customerId int,
lxId int,
xmName varchar(100)
);
--项目名称字段加注释
comment on column t_xm.id is '主键';
comment on column t_xm.customerId is '用户';
comment on column t_xm.lxId is '项目类型';
comment on column t_xm.xmName is '项目名称';
--项目名称表加注释
comment on table t_xm is '项目名称';
项目打卡表创建语句如下：
create table t_xmlist(
id integer,
customerId int,
xmId int,
insertDate datetime,
sc int
);
--项目打卡字段加注释
comment on column t_xmlist.id is '主键';
comment on column t_xmlist.customerId is '用户';
comment on column t_xmlist.xmId is '项目';
comment on column t_xmlist.insertDate is '打卡日期';
comment on column t_xmlist.sc is '时长';
--项目打卡表加注释
comment on table t_xmlist is '项目打卡';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_gonggao;
create sequence s_t_lx;
create sequence s_t_ly;
create sequence s_t_sp;
create sequence s_t_xm;
create sequence s_t_xmlist;
个人计划管理系统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),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
sfz varchar(100),--身份证
zz varchar(100)--住址
);
公告表创建语句如下：
--公告表注释
create table t_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime--发起日期
);
项目类型表创建语句如下：
--项目类型表注释
create table t_lx(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
lxName varchar(100)--项目类型
);
留言反馈表创建语句如下：
--留言反馈表注释
create table t_ly(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
content text,--内容
insertDate datetime,--发起日期
back text,--回复
status varchar(100)--状态
);
计划教学表创建语句如下：
--计划教学表注释
create table t_sp(
id int identity(1,1) primary key not null,--主键
spName varchar(100),--教学名称
link varchar(100),--视频地址
remark text,--内容说明
showDate datetime--日期
);
项目名称表创建语句如下：
--项目名称表注释
create table t_xm(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
lxId int,--项目类型
xmName varchar(100)--项目名称
);
项目打卡表创建语句如下：
--项目打卡表注释
create table t_xmlist(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
xmId int,--项目
insertDate datetime,--打卡日期
sc int--时长
);
登录后主页.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 phone;
//年龄
private String age;
//
private String sex;
//身份证
private String sfz;
//住址
private String zz;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
}公告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_gonggao")
public class Gonggao {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
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 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_lx")
public class Lx {
//主键
@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 Long customerId;
//项目类型
private String lxName;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getLxName() {return lxName;}
public void setLxName(String lxName) {this.lxName = lxName;}
}留言反馈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_ly")
public class Ly {
//主键
@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 Long customerId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_sp")
public class Sp {
//主键
@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 spName;
//视频地址
private String link;
//内容说明
private String remark;
//日期
private Date showDate;
public String getSpName() {return spName;}
public void setSpName(String spName) {this.spName = spName;}
public String getLink() {return link;}
public void setLink(String link) {this.link = link;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}项目名称javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//项目名称
@Table(name = "t_xm")
public class Xm {
//主键
@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 Long customerId;
//项目类型
private Long lxId;
//项目名称
private String xmName;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getLxId() {return lxId;}
public void setLxId(Long lxId) {this.lxId = lxId;}
public String getXmName() {return xmName;}
public void setXmName(String xmName) {this.xmName = xmName;}
}项目打卡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_xmlist")
public class Xmlist {
//主键
@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 Long customerId;
//项目
private Long xmId;
//打卡日期
private Date insertDate;
//时长
private Integer sc;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getXmId() {return xmId;}
public void setXmId(Long xmId) {this.xmId = xmId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getSc() {return sc;}
public void setSc(Integer sc) {this.sc = sc;}
}个人计划管理系统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 phone;
//年龄
private String age;
//
private String sex;
//身份证
private String sfz;
//住址
private String zz;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getZz() {return zz;}
public void setZz(String zz) {this.zz = zz;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gonggao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
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 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 Lx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//项目类型
private String lxName;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getLxName() {return lxName;}
public void setLxName(String lxName) {this.lxName = lxName;}
}留言反馈javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//留言反馈
public class Ly extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Sp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//教学名称
private String spName;
//视频地址
private String link;
//内容说明
private String remark;
//日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public String getSpName() {return spName;}
public void setSpName(String spName) {this.spName = spName;}
public String getLink() {return link;}
public void setLink(String link) {this.link = link;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}项目名称javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//项目名称
public class Xm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//项目类型
private Long lxId;
//项目名称
private String xmName;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getLxId() {return lxId;}
public void setLxId(Long lxId) {this.lxId = lxId;}
public String getXmName() {return xmName;}
public void setXmName(String xmName) {this.xmName = xmName;}
}项目打卡javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//项目打卡
public class Xmlist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Long customerId;
//项目
private Long xmId;
//打卡日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date insertDate;
//时长
private Integer sc;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public Long getXmId() {return xmId;}
public void setXmId(Long xmId) {this.xmId = xmId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getSc() {return sc;}
public void setSc(Integer sc) {this.sc = sc;}
}