- 学生实训管理系统mysql数据库创建语句
- 学生实训管理系统oracle数据库创建语句
- 学生实训管理系统sqlserver数据库创建语句
- 学生实训管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 学生实训管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
学生实训管理系统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_bj(
id int primary key auto_increment comment '主键',
bjName varchar(100) comment '班级'
) comment '班级';
实训课程签到表创建语句如下:
create table t_qd(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
bjId int comment '班级',
sxkcId int comment '实训课程',
insertDate datetime 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 '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
bjId int comment '班级'
) comment '学生';
实训课程表创建语句如下:
create table t_sxkc(
id int primary key auto_increment comment '主键',
sxkcName varchar(100) comment '实训课程名称',
address varchar(100) comment '上课地点',
bjId int comment '班级',
teacherId int comment '老师',
beginDate datetime comment '开始时间',
endDate datetime comment '结束时间',
ts int comment '总天数',
gz int comment '工资',
xf int comment '学费'
) comment '实训课程';
实训课程报名表创建语句如下:
create table t_sxkclist(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
bjId int comment '班级',
sxkcId int comment '实训课程',
sfjf varchar(100) comment '是否缴费',
status varchar(100) comment '状态',
qdts int comment '签到天数',
fs int 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 '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
bjId 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_bj(
id integer,
bjName varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级';
--班级表加注释
comment on table t_bj is '班级';
实训课程签到表创建语句如下:
create table t_qd(
id integer,
studentId int,
bjId int,
sxkcId int,
insertDate datetime
);
--实训课程签到字段加注释
comment on column t_qd.id is '主键';
comment on column t_qd.studentId is '学生';
comment on column t_qd.bjId is '班级';
comment on column t_qd.sxkcId is '实训课程';
comment on column t_qd.insertDate is '签到日期';
--实训课程签到表加注释
comment on table t_qd is '实训课程签到';
学生表创建语句如下:
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
bjId int
);
--学生字段加注释
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.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.bjId is '班级';
--学生表加注释
comment on table t_student is '学生';
实训课程表创建语句如下:
create table t_sxkc(
id integer,
sxkcName varchar(100),
address varchar(100),
bjId int,
teacherId int,
beginDate datetime,
endDate datetime,
ts int,
gz int,
xf int
);
--实训课程字段加注释
comment on column t_sxkc.id is '主键';
comment on column t_sxkc.sxkcName is '实训课程名称';
comment on column t_sxkc.address is '上课地点';
comment on column t_sxkc.bjId is '班级';
comment on column t_sxkc.teacherId is '老师';
comment on column t_sxkc.beginDate is '开始时间';
comment on column t_sxkc.endDate is '结束时间';
comment on column t_sxkc.ts is '总天数';
comment on column t_sxkc.gz is '工资';
comment on column t_sxkc.xf is '学费';
--实训课程表加注释
comment on table t_sxkc is '实训课程';
实训课程报名表创建语句如下:
create table t_sxkclist(
id integer,
studentId int,
bjId int,
sxkcId int,
sfjf varchar(100),
status varchar(100),
qdts int,
fs int
);
--实训课程报名字段加注释
comment on column t_sxkclist.id is '主键';
comment on column t_sxkclist.studentId is '学生';
comment on column t_sxkclist.bjId is '班级';
comment on column t_sxkclist.sxkcId is '实训课程';
comment on column t_sxkclist.sfjf is '是否缴费';
comment on column t_sxkclist.status is '状态';
comment on column t_sxkclist.qdts is '签到天数';
comment on column t_sxkclist.fs is '分数';
--实训课程报名表加注释
comment on table t_sxkclist is '实训课程报名';
老师表创建语句如下:
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
bjId int
);
--老师字段加注释
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.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.bjId is '班级';
--老师表加注释
comment on table t_teacher is '老师';
oracle特有,对应序列如下:
create sequence s_t_bj;
create sequence s_t_qd;
create sequence s_t_student;
create sequence s_t_sxkc;
create sequence s_t_sxkclist;
create sequence s_t_teacher;
学生实训管理系统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_bj(
id int identity(1,1) primary key not null,--主键
bjName varchar(100)--班级
);
实训课程签到表创建语句如下:
--实训课程签到表注释
create table t_qd(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
bjId int,--班级
sxkcId int,--实训课程
insertDate datetime--签到日期
);
学生表创建语句如下:
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
bjId int--班级
);
实训课程表创建语句如下:
--实训课程表注释
create table t_sxkc(
id int identity(1,1) primary key not null,--主键
sxkcName varchar(100),--实训课程名称
address varchar(100),--上课地点
bjId int,--班级
teacherId int,--老师
beginDate datetime,--开始时间
endDate datetime,--结束时间
ts int,--总天数
gz int,--工资
xf int--学费
);
实训课程报名表创建语句如下:
--实训课程报名表注释
create table t_sxkclist(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
bjId int,--班级
sxkcId int,--实训课程
sfjf varchar(100),--是否缴费
status varchar(100),--状态
qdts int,--签到天数
fs int--分数
);
老师表创建语句如下:
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
bjId 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_bj")
public class Bj {
//主键
@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 bjName;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}
实训课程签到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_qd")
public class Qd {
//主键
@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 studentId;
//班级
private Integer bjId;
//实训课程
private Integer sxkcId;
//签到日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getSxkcId() {return sxkcId;}
public void setSxkcId(Integer sxkcId) {this.sxkcId = sxkcId;}
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_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 phone;
//年龄
private String age;
//性别
private String sex;
//班级
private Integer bjId;
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 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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}
实训课程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_sxkc")
public class Sxkc {
//主键
@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 sxkcName;
//上课地点
private String address;
//班级
private Integer bjId;
//老师
private Integer teacherId;
//开始时间
private Date beginDate;
//结束时间
private Date endDate;
//总天数
private Integer ts;
//工资
private Integer gz;
//学费
private Integer xf;
public String getSxkcName() {return sxkcName;}
public void setSxkcName(String sxkcName) {this.sxkcName = sxkcName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getTs() {return ts;}
public void setTs(Integer ts) {this.ts = ts;}
public Integer getGz() {return gz;}
public void setGz(Integer gz) {this.gz = gz;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
}
实训课程报名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_sxkclist")
public class Sxkclist {
//主键
@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 studentId;
//班级
private Integer bjId;
//实训课程
private Integer sxkcId;
//是否缴费
private String sfjf;
//状态
private String status;
//签到天数
private Integer qdts;
//分数
private Integer fs;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getSxkcId() {return sxkcId;}
public void setSxkcId(Integer sxkcId) {this.sxkcId = sxkcId;}
public String getSfjf() {return sfjf;}
public void setSfjf(String sfjf) {this.sfjf = sfjf;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getQdts() {return qdts;}
public void setQdts(Integer qdts) {this.qdts = qdts;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
}
老师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 phone;
//年龄
private String age;
//性别
private String sex;
//班级
private Integer bjId;
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 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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}
学生实训管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:
班级javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班级
public class Bj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private String bjName;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}
实训课程签到javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//实训课程签到
public class Qd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//班级
private Integer bjId;
//实训课程
private Integer sxkcId;
//签到日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getSxkcId() {return sxkcId;}
public void setSxkcId(Integer sxkcId) {this.sxkcId = sxkcId;}
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 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 phone;
//年龄
private String age;
//性别
private String sex;
//班级
private Integer bjId;
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 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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}
实训课程javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//实训课程
public class Sxkc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//实训课程名称
private String sxkcName;
//上课地点
private String address;
//班级
private Integer bjId;
//老师
private Integer teacherId;
//开始时间
private Date beginDate;
//结束时间
private Date endDate;
//总天数
private Integer ts;
//工资
private Integer gz;
//学费
private Integer xf;
public String getSxkcName() {return sxkcName;}
public void setSxkcName(String sxkcName) {this.sxkcName = sxkcName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getTs() {return ts;}
public void setTs(Integer ts) {this.ts = ts;}
public Integer getGz() {return gz;}
public void setGz(Integer gz) {this.gz = gz;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
}
实训课程报名javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//实训课程报名
public class Sxkclist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//班级
private Integer bjId;
//实训课程
private Integer sxkcId;
//是否缴费
private String sfjf;
//状态
private String status;
//签到天数
private Integer qdts;
//分数
private Integer fs;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getSxkcId() {return sxkcId;}
public void setSxkcId(Integer sxkcId) {this.sxkcId = sxkcId;}
public String getSfjf() {return sfjf;}
public void setSfjf(String sfjf) {this.sfjf = sfjf;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getQdts() {return qdts;}
public void setQdts(Integer qdts) {this.qdts = qdts;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
}
老师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 phone;
//年龄
private String age;
//性别
private String sex;
//班级
private Integer bjId;
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 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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}