- 基于WEB的经济管理学院技能学分认定系统设计与实现mysql数据库创建语句
- 基于WEB的经济管理学院技能学分认定系统设计与实现oracle数据库创建语句
- 基于WEB的经济管理学院技能学分认定系统设计与实现sqlserver数据库创建语句
- 基于WEB的经济管理学院技能学分认定系统设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于WEB的经济管理学院技能学分认定系统设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于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_jn(
id int primary key auto_increment comment '主键',
jnName varchar(100) comment '技能名称',
jnCode varchar(100) comment '技能分数'
) comment '技能';
留言板主题表创建语句如下：
create table t_lyb(
id int primary key auto_increment comment '主键',
lybTitle varchar(100) comment '留言板主题'
) comment '留言板主题';
留言内容表创建语句如下：
create table t_lyblist(
id int primary key auto_increment comment '主键',
lybId int comment '留言板',
v1 varchar(100) comment '留言人',
v2 datetime comment '时间',
v3 varchar(100) comment '内容'
) comment '留言内容';
技能评分申请表创建语句如下：
create table t_pf(
id int primary key auto_increment comment '主键',
jnId int comment '技能',
studetnId int comment '学生',
content varchar(100) comment '内容',
picUrl varchar(100) comment '图片',
insertDate datetime comment '申请日期',
shrId int comment '审核人',
shDate datetime comment '审核时间',
status varchar(100) comment '状态'
) comment '技能评分申请';
学生表创建语句如下：
create table t_student(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
studentName varchar(100) comment '学生名称',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
pf varchar(100) comment '评分权限'
) comment '学生';
老师表创建语句如下：
create table t_teacher(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
teacherName varchar(100) comment '老师名称',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
sh varchar(100) 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_jn(
id integer,
jnName varchar(100),
jnCode varchar(100)
);
--技能字段加注释
comment on column t_jn.id is '主键';
comment on column t_jn.jnName is '技能名称';
comment on column t_jn.jnCode is '技能分数';
--技能表加注释
comment on table t_jn is '技能';
留言板主题表创建语句如下：
create table t_lyb(
id integer,
lybTitle varchar(100)
);
--留言板主题字段加注释
comment on column t_lyb.id is '主键';
comment on column t_lyb.lybTitle is '留言板主题';
--留言板主题表加注释
comment on table t_lyb is '留言板主题';
留言内容表创建语句如下：
create table t_lyblist(
id integer,
lybId int,
v1 varchar(100),
v2 datetime,
v3 varchar(100)
);
--留言内容字段加注释
comment on column t_lyblist.id is '主键';
comment on column t_lyblist.lybId is '留言板';
comment on column t_lyblist.v1 is '留言人';
comment on column t_lyblist.v2 is '时间';
comment on column t_lyblist.v3 is '内容';
--留言内容表加注释
comment on table t_lyblist is '留言内容';
技能评分申请表创建语句如下：
create table t_pf(
id integer,
jnId int,
studetnId int,
content varchar(100),
picUrl varchar(100),
insertDate datetime,
shrId int,
shDate datetime,
status varchar(100)
);
--技能评分申请字段加注释
comment on column t_pf.id is '主键';
comment on column t_pf.jnId is '技能';
comment on column t_pf.studetnId is '学生';
comment on column t_pf.content is '内容';
comment on column t_pf.picUrl is '图片';
comment on column t_pf.insertDate is '申请日期';
comment on column t_pf.shrId is '审核人';
comment on column t_pf.shDate is '审核时间';
comment on column t_pf.status is '状态';
--技能评分申请表加注释
comment on table t_pf is '技能评分申请';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
pf varchar(100)
);
--学生字段加注释
comment on column t_student.id is '主键';
comment on column t_student.username is '账号';
comment on column t_student.password is '密码';
comment on column t_student.studentName is '学生名称';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.phone is '电话';
comment on column t_student.pf is '评分权限';
--学生表加注释
comment on table t_student is '学生';
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
sh varchar(100)
);
--老师字段加注释
comment on column t_teacher.id is '主键';
comment on column t_teacher.username is '账号';
comment on column t_teacher.password is '密码';
comment on column t_teacher.teacherName is '老师名称';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.sh is '审核审核';
--老师表加注释
comment on table t_teacher is '老师';
oracle特有，对应序列如下：
create sequence s_t_jn;
create sequence s_t_lyb;
create sequence s_t_lyblist;
create sequence s_t_pf;
create sequence s_t_student;
create sequence s_t_teacher;
基于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_jn(
id int identity(1,1) primary key not null,--主键
jnName varchar(100),--技能名称
jnCode varchar(100)--技能分数
);
留言板主题表创建语句如下：
--留言板主题表注释
create table t_lyb(
id int identity(1,1) primary key not null,--主键
lybTitle varchar(100)--留言板主题
);
留言内容表创建语句如下：
--留言内容表注释
create table t_lyblist(
id int identity(1,1) primary key not null,--主键
lybId int,--留言板
v1 varchar(100),--留言人
v2 datetime,--时间
v3 varchar(100)--内容
);
技能评分申请表创建语句如下：
--技能评分申请表注释
create table t_pf(
id int identity(1,1) primary key not null,--主键
jnId int,--技能
studetnId int,--学生
content varchar(100),--内容
picUrl varchar(100),--图片
insertDate datetime,--申请日期
shrId int,--审核人
shDate datetime,--审核时间
status varchar(100)--状态
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--学生名称
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
pf varchar(100)--评分权限
);
老师表创建语句如下：
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--老师名称
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
sh varchar(100)--审核审核
);
登录后主页.jpg?x-oss-process=style/00001)
基于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_jn")
public class Jn {
//主键
@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 jnName;
//技能分数
private String jnCode;
public String getJnName() {return jnName;}
public void setJnName(String jnName) {this.jnName = jnName;}
public String getJnCode() {return jnCode;}
public void setJnCode(String jnCode) {this.jnCode = jnCode;}
}留言板主题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_lyb")
public class Lyb {
//主键
@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 lybTitle;
public String getLybTitle() {return lybTitle;}
public void setLybTitle(String lybTitle) {this.lybTitle = lybTitle;}
}留言内容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_lyblist")
public class Lyblist {
//主键
@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 lybId;
//留言人
private String v1;
//时间
private Date v2;
//内容
private String v3;
public Integer getLybId() {return lybId;}
public void setLybId(Integer lybId) {this.lybId = lybId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getV2() {return v2;}
public void setV2(Date v2) {this.v2 = v2;}
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_pf")
public class Pf {
//主键
@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 jnId;
//学生
private Integer studetnId;
//内容
private String content;
//图片
private String picUrl;
//申请日期
private Date insertDate;
//审核人
private Integer shrId;
//审核时间
private Date shDate;
//状态
private String status;
public Integer getJnId() {return jnId;}
public void setJnId(Integer jnId) {this.jnId = jnId;}
public Integer getStudetnId() {return studetnId;}
public void setStudetnId(Integer studetnId) {this.studetnId = studetnId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPicUrl() {return picUrl;}
public void setPicUrl(String picUrl) {this.picUrl = picUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getShrId() {return shrId;}
public void setShrId(Integer shrId) {this.shrId = shrId;}
public Date getShDate() {return shDate;}
public void setShDate(Date shDate) {this.shDate = shDate;}
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_student")
public class Student {
//主键
@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 studentName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//评分权限
private String pf;
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
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 getPf() {return pf;}
public void setPf(String pf) {this.pf = pf;}
}老师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_teacher")
public class Teacher {
//主键
@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 teacherName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//审核审核
private String sh;
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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 getSh() {return sh;}
public void setSh(String sh) {this.sh = sh;}
}基于WEB的经济管理学院技能学分认定系统设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
技能javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//技能
public class Jn extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//技能名称
private String jnName;
//技能分数
private String jnCode;
public String getJnName() {return jnName;}
public void setJnName(String jnName) {this.jnName = jnName;}
public String getJnCode() {return jnCode;}
public void setJnCode(String jnCode) {this.jnCode = jnCode;}
}留言板主题javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//留言板主题
public class Lyb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//留言板主题
private String lybTitle;
public String getLybTitle() {return lybTitle;}
public void setLybTitle(String lybTitle) {this.lybTitle = lybTitle;}
}留言内容javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//留言内容
public class Lyblist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//留言板
private Integer lybId;
//留言人
private String v1;
//时间
private Date v2;
//内容
private String v3;
public Integer getLybId() {return lybId;}
public void setLybId(Integer lybId) {this.lybId = lybId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getV2() {return v2;}
public void setV2(Date v2) {this.v2 = v2;}
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 Pf extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//技能
private Integer jnId;
//学生
private Integer studetnId;
//内容
private String content;
//图片
private String picUrl;
//申请日期
private Date insertDate;
//审核人
private Integer shrId;
//审核时间
private Date shDate;
//状态
private String status;
public Integer getJnId() {return jnId;}
public void setJnId(Integer jnId) {this.jnId = jnId;}
public Integer getStudetnId() {return studetnId;}
public void setStudetnId(Integer studetnId) {this.studetnId = studetnId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPicUrl() {return picUrl;}
public void setPicUrl(String picUrl) {this.picUrl = picUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getShrId() {return shrId;}
public void setShrId(Integer shrId) {this.shrId = shrId;}
public Date getShDate() {return shDate;}
public void setShDate(Date shDate) {this.shDate = shDate;}
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 Student 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 studentName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//评分权限
private String pf;
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 getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
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 getPf() {return pf;}
public void setPf(String pf) {this.pf = pf;}
}老师javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//老师
public class Teacher 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 teacherName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//审核审核
private String sh;
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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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 getSh() {return sh;}
public void setSh(String sh) {this.sh = sh;}
}