- 实验室排课系统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 '性别'
) comment '用户';
课表表创建语句如下：
create table t_kb(
id int primary key auto_increment comment '主键',
k1 varchar(100) comment '年度',
k2 varchar(100) comment '单双周',
v1 varchar(100) comment '节次',
v2 varchar(100) comment '实验室',
v3 varchar(100) comment '实验台数',
x11 varchar(100) comment '星期一班级',
x21 varchar(100) comment '星期二班级',
x31 varchar(100) comment '星期三班级',
x41 varchar(100) comment '星期四班级',
x51 varchar(100) comment '星期五班级',
x12 varchar(100) comment '星期一课程',
x22 varchar(100) comment '星期二课程',
x32 varchar(100) comment '星期三课程',
x42 varchar(100) comment '星期四课程',
x52 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),
phone varchar(100),
age varchar(100),
sex 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 table t_customer is '用户';
课表表创建语句如下：
create table t_kb(
id integer,
k1 varchar(100),
k2 varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
x11 varchar(100),
x21 varchar(100),
x31 varchar(100),
x41 varchar(100),
x51 varchar(100),
x12 varchar(100),
x22 varchar(100),
x32 varchar(100),
x42 varchar(100),
x52 varchar(100)
);
--课表字段加注释
comment on column t_kb.id is '主键';
comment on column t_kb.k1 is '年度';
comment on column t_kb.k2 is '单双周';
comment on column t_kb.v1 is '节次';
comment on column t_kb.v2 is '实验室';
comment on column t_kb.v3 is '实验台数';
comment on column t_kb.x11 is '星期一班级';
comment on column t_kb.x21 is '星期二班级';
comment on column t_kb.x31 is '星期三班级';
comment on column t_kb.x41 is '星期四班级';
comment on column t_kb.x51 is '星期五班级';
comment on column t_kb.x12 is '星期一课程';
comment on column t_kb.x22 is '星期二课程';
comment on column t_kb.x32 is '星期三课程';
comment on column t_kb.x42 is '星期四课程';
comment on column t_kb.x52 is '星期五课程';
--课表表加注释
comment on table t_kb is '课表';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_kb;
实验室排课系统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)--性别
);
课表表创建语句如下：
--课表表注释
create table t_kb(
id int identity(1,1) primary key not null,--主键
k1 varchar(100),--年度
k2 varchar(100),--单双周
v1 varchar(100),--节次
v2 varchar(100),--实验室
v3 varchar(100),--实验台数
x11 varchar(100),--星期一班级
x21 varchar(100),--星期二班级
x31 varchar(100),--星期三班级
x41 varchar(100),--星期四班级
x51 varchar(100),--星期五班级
x12 varchar(100),--星期一课程
x22 varchar(100),--星期二课程
x32 varchar(100),--星期三课程
x42 varchar(100),--星期四课程
x52 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 phone;
//年龄
private String age;
//性别
private String sex;
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;}
}课表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_kb")
public class Kb {
//主键
@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 k1;
//单双周
private String k2;
//节次
private String v1;
//实验室
private String v2;
//实验台数
private String v3;
//星期一班级
private String x11;
//星期二班级
private String x21;
//星期三班级
private String x31;
//星期四班级
private String x41;
//星期五班级
private String x51;
//星期一课程
private String x12;
//星期二课程
private String x22;
//星期三课程
private String x32;
//星期四课程
private String x42;
//星期五课程
private String x52;
public String getK1() {return k1;}
public void setK1(String k1) {this.k1 = k1;}
public String getK2() {return k2;}
public void setK2(String k2) {this.k2 = k2;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getX11() {return x11;}
public void setX11(String x11) {this.x11 = x11;}
public String getX21() {return x21;}
public void setX21(String x21) {this.x21 = x21;}
public String getX31() {return x31;}
public void setX31(String x31) {this.x31 = x31;}
public String getX41() {return x41;}
public void setX41(String x41) {this.x41 = x41;}
public String getX51() {return x51;}
public void setX51(String x51) {this.x51 = x51;}
public String getX12() {return x12;}
public void setX12(String x12) {this.x12 = x12;}
public String getX22() {return x22;}
public void setX22(String x22) {this.x22 = x22;}
public String getX32() {return x32;}
public void setX32(String x32) {this.x32 = x32;}
public String getX42() {return x42;}
public void setX42(String x42) {this.x42 = x42;}
public String getX52() {return x52;}
public void setX52(String x52) {this.x52 = x52;}
}实验室排课系统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;
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;}
}课表javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//课表
public class Kb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//年度
private String k1;
//单双周
private String k2;
//节次
private String v1;
//实验室
private String v2;
//实验台数
private String v3;
//星期一班级
private String x11;
//星期二班级
private String x21;
//星期三班级
private String x31;
//星期四班级
private String x41;
//星期五班级
private String x51;
//星期一课程
private String x12;
//星期二课程
private String x22;
//星期三课程
private String x32;
//星期四课程
private String x42;
//星期五课程
private String x52;
public String getK1() {return k1;}
public void setK1(String k1) {this.k1 = k1;}
public String getK2() {return k2;}
public void setK2(String k2) {this.k2 = k2;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getX11() {return x11;}
public void setX11(String x11) {this.x11 = x11;}
public String getX21() {return x21;}
public void setX21(String x21) {this.x21 = x21;}
public String getX31() {return x31;}
public void setX31(String x31) {this.x31 = x31;}
public String getX41() {return x41;}
public void setX41(String x41) {this.x41 = x41;}
public String getX51() {return x51;}
public void setX51(String x51) {this.x51 = x51;}
public String getX12() {return x12;}
public void setX12(String x12) {this.x12 = x12;}
public String getX22() {return x22;}
public void setX22(String x22) {this.x22 = x22;}
public String getX32() {return x32;}
public void setX32(String x32) {this.x32 = x32;}
public String getX42() {return x42;}
public void setX42(String x42) {this.x42 = x42;}
public String getX52() {return x52;}
public void setX52(String x52) {this.x52 = x52;}
}