- 学生在校信息管理系统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_bj(
id int primary key auto_increment comment '主键',
bjName varchar(100) comment '班级',
bzr varchar(100) comment '班主任'
) comment '班级';
成绩表创建语句如下：
create table t_cj(
id int primary key auto_increment comment '主键',
xh varchar(100) comment '学号',
km varchar(100) comment '科目',
cj int comment '成绩',
xq varchar(100) comment '学期'
) comment '成绩';
用户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
sex varchar(100) comment '',
age varchar(100) comment '年龄',
phone varchar(100) comment '电话',
headPic varchar(100) comment '头像',
sfz varchar(100) comment '身份证',
address varchar(100) comment '地址',
bjId int comment '班级',
v1 varchar(100) comment '籍贯',
v2 text comment '学籍详情',
xh varchar(100) comment '学号'
) comment '用户';
奖励惩罚表创建语句如下：
create table t_jc(
id int primary key auto_increment comment '主键',
xh varchar(100) comment '学号',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content text comment '详细内容',
lx varchar(100) comment '',
showDate datetime 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 ''
) 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),
bzr varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级';
comment on column t_bj.bzr is '班主任';
--班级表加注释
comment on table t_bj is '班级';
成绩表创建语句如下：
create table t_cj(
id integer,
xh varchar(100),
km varchar(100),
cj int,
xq varchar(100)
);
--成绩字段加注释
comment on column t_cj.id is '主键';
comment on column t_cj.xh is '学号';
comment on column t_cj.km is '科目';
comment on column t_cj.cj is '成绩';
comment on column t_cj.xq is '学期';
--成绩表加注释
comment on table t_cj is '成绩';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
sex varchar(100),
age varchar(100),
phone varchar(100),
headPic varchar(100),
sfz varchar(100),
address varchar(100),
bjId int,
v1 varchar(100),
v2 text,
xh 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.sex is '';
comment on column t_customer.age is '年龄';
comment on column t_customer.phone is '电话';
comment on column t_customer.headPic is '头像';
comment on column t_customer.sfz is '身份证';
comment on column t_customer.address is '地址';
comment on column t_customer.bjId is '班级';
comment on column t_customer.v1 is '籍贯';
comment on column t_customer.v2 is '学籍详情';
comment on column t_customer.xh is '学号';
--用户表加注释
comment on table t_customer is '用户';
奖励惩罚表创建语句如下：
create table t_jc(
id integer,
xh varchar(100),
title varchar(100),
pic varchar(100),
content text,
lx varchar(100),
showDate datetime
);
--奖励惩罚字段加注释
comment on column t_jc.id is '主键';
comment on column t_jc.xh is '学号';
comment on column t_jc.title is '标题';
comment on column t_jc.pic is '图片';
comment on column t_jc.content is '详细内容';
comment on column t_jc.lx is '';
comment on column t_jc.showDate is '发生日期';
--奖励惩罚表加注释
comment on table t_jc 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)
);
--老师字段加注释
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 table t_teacher is '老师';
oracle特有，对应序列如下：
create sequence s_t_bj;
create sequence s_t_cj;
create sequence s_t_customer;
create sequence s_t_jc;
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),--班级
bzr varchar(100)--班主任
);
成绩表创建语句如下：
--成绩表注释
create table t_cj(
id int identity(1,1) primary key not null,--主键
xh varchar(100),--学号
km varchar(100),--科目
cj int,--成绩
xq varchar(100)--学期
);
用户表创建语句如下：
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
sex varchar(100),--
age varchar(100),--年龄
phone varchar(100),--电话
headPic varchar(100),--头像
sfz varchar(100),--身份证
address varchar(100),--地址
bjId int,--班级
v1 varchar(100),--籍贯
v2 text,--学籍详情
xh varchar(100)--学号
);
奖励惩罚表创建语句如下：
--奖励惩罚表注释
create table t_jc(
id int identity(1,1) primary key not null,--主键
xh varchar(100),--学号
title varchar(100),--标题
pic varchar(100),--图片
content text,--详细内容
lx varchar(100),--
showDate datetime--发生日期
);
老师表创建语句如下：
--老师表注释
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)--
);
登录后主页.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_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;
//班主任
private String bzr;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
}成绩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_cj")
public class Cj {
//主键
@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 xh;
//科目
private String km;
//成绩
private Integer cj;
//学期
private String xq;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getKm() {return km;}
public void setKm(String km) {this.km = km;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public String getXq() {return xq;}
public void setXq(String xq) {this.xq = xq;}
}用户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 sex;
//年龄
private String age;
//电话
private String phone;
//头像
private String headPic;
//身份证
private String sfz;
//地址
private String address;
//班级
private Long bjId;
//籍贯
private String v1;
//学籍详情
private String v2;
//学号
private String xh;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Long getBjId() {return bjId;}
public void setBjId(Long bjId) {this.bjId = bjId;}
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
}奖励惩罚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_jc")
public class Jc {
//主键
@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 xh;
//标题
private String title;
//图片
private String pic;
//详细内容
private String content;
//
private String lx;
//发生日期
private Date showDate;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
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_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;
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;}
}学生在校信息管理系统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;
//班主任
private String bzr;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
}成绩javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//成绩
public class Cj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学号
private String xh;
//科目
private String km;
//成绩
private Integer cj;
//学期
private String xq;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getKm() {return km;}
public void setKm(String km) {this.km = km;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public String getXq() {return xq;}
public void setXq(String xq) {this.xq = xq;}
}用户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 sex;
//年龄
private String age;
//电话
private String phone;
//头像
private String headPic;
//身份证
private String sfz;
//地址
private String address;
//班级
private Long bjId;
//籍贯
private String v1;
//学籍详情
private String v2;
//学号
private String xh;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Long getBjId() {return bjId;}
public void setBjId(Long bjId) {this.bjId = bjId;}
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
}奖励惩罚javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//奖励惩罚
public class Jc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学号
private String xh;
//标题
private String title;
//图片
private String pic;
//详细内容
private String content;
//
private String lx;
//发生日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
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 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;
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;}
}