- 基于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_class(
id int primary key auto_increment comment '主键',
className varchar(100) comment '',
classMan varchar(100) comment '',
deptId varchar(100) comment ''
) comment '';
表创建语句如下：
create table t_dept(
id int primary key auto_increment comment '主键',
deptName varchar(100) comment '',
deptMan varchar(100) comment ''
) comment '';
表创建语句如下：
create table t_exam(
id int primary key auto_increment comment '主键',
kcId int comment '',
examName varchar(100) comment '',
studentId int comment '',
examDate varchar(100) comment '',
code int comment '',
jkls varchar(100) comment ''
) comment '';
表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
kcName varchar(100) comment '',
zy varchar(100) comment '',
sfxu varchar(100) comment '',
sksj varchar(100) comment '',
skls varchar(100) comment '',
skdd varchar(100) comment ''
) comment '';
表创建语句如下：
create table t_student(
id int primary key auto_increment comment '主键',
studentName varchar(100) comment '',
studentNo varchar(100) comment '',
age int comment '',
sex varchar(100) comment '',
address varchar(100) comment '',
mobile varchar(100) comment '',
insertDate datetime comment '',
classId int comment '',
username varchar(100) comment '',
password varchar(100) comment ''
) comment '';
老师表创建语句如下：
create table t_teacher(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
name varchar(100) comment '姓名',
sex varchar(100) comment '性别',
age varchar(100) comment '年龄',
phone varchar(100) comment '电话',
idcard 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_class(
id integer,
className varchar(100),
classMan varchar(100),
deptId varchar(100)
);
--字段加注释
comment on column t_class.id is '主键';
comment on column t_class.className is '';
comment on column t_class.classMan is '';
comment on column t_class.deptId is '';
--表加注释
comment on table t_class is '';
表创建语句如下：
create table t_dept(
id integer,
deptName varchar(100),
deptMan varchar(100)
);
--字段加注释
comment on column t_dept.id is '主键';
comment on column t_dept.deptName is '';
comment on column t_dept.deptMan is '';
--表加注释
comment on table t_dept is '';
表创建语句如下：
create table t_exam(
id integer,
kcId int,
examName varchar(100),
studentId int,
examDate varchar(100),
code int,
jkls varchar(100)
);
--字段加注释
comment on column t_exam.id is '主键';
comment on column t_exam.kcId is '';
comment on column t_exam.examName is '';
comment on column t_exam.studentId is '';
comment on column t_exam.examDate is '';
comment on column t_exam.code is '';
comment on column t_exam.jkls is '';
--表加注释
comment on table t_exam is '';
表创建语句如下：
create table t_kc(
id integer,
kcName varchar(100),
zy varchar(100),
sfxu varchar(100),
sksj varchar(100),
skls varchar(100),
skdd varchar(100)
);
--字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '';
comment on column t_kc.zy is '';
comment on column t_kc.sfxu is '';
comment on column t_kc.sksj is '';
comment on column t_kc.skls is '';
comment on column t_kc.skdd is '';
--表加注释
comment on table t_kc is '';
表创建语句如下：
create table t_student(
id integer,
studentName varchar(100),
studentNo varchar(100),
age int,
sex varchar(100),
address varchar(100),
mobile varchar(100),
insertDate datetime,
classId int,
username varchar(100),
password varchar(100)
);
--字段加注释
comment on column t_student.id is '主键';
comment on column t_student.studentName is '';
comment on column t_student.studentNo is '';
comment on column t_student.age is '';
comment on column t_student.sex is '';
comment on column t_student.address is '';
comment on column t_student.mobile is '';
comment on column t_student.insertDate is '';
comment on column t_student.classId is '';
comment on column t_student.username is '';
comment on column t_student.password is '';
--表加注释
comment on table t_student is '';
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
name varchar(100),
sex varchar(100),
age varchar(100),
phone varchar(100),
idcard 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.name is '姓名';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.phone is '电话';
comment on column t_teacher.idcard is '身份证';
--老师表加注释
comment on table t_teacher is '老师';
oracle特有，对应序列如下：
create sequence s_t_class;
create sequence s_t_dept;
create sequence s_t_exam;
create sequence s_t_kc;
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_class(
id int identity(1,1) primary key not null,--主键
className varchar(100),--
classMan varchar(100),--
deptId varchar(100)--
);
表创建语句如下：
--表注释
create table t_dept(
id int identity(1,1) primary key not null,--主键
deptName varchar(100),--
deptMan varchar(100)--
);
表创建语句如下：
--表注释
create table t_exam(
id int identity(1,1) primary key not null,--主键
kcId int,--
examName varchar(100),--
studentId int,--
examDate varchar(100),--
code int,--
jkls varchar(100)--
);
表创建语句如下：
--表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
kcName varchar(100),--
zy varchar(100),--
sfxu varchar(100),--
sksj varchar(100),--
skls varchar(100),--
skdd varchar(100)--
);
表创建语句如下：
--表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
studentName varchar(100),--
studentNo varchar(100),--
age int,--
sex varchar(100),--
address varchar(100),--
mobile varchar(100),--
insertDate datetime,--
classId int,--
username varchar(100),--
password varchar(100)--
);
老师表创建语句如下：
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
name varchar(100),--姓名
sex varchar(100),--性别
age varchar(100),--年龄
phone varchar(100),--电话
idcard 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_class")
public class Class {
//主键
@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 className;
//
private String classMan;
//
private String deptId;
public String getClassName() {return className;}
public void setClassName(String className) {this.className = className;}
public String getClassMan() {return classMan;}
public void setClassMan(String classMan) {this.classMan = classMan;}
public String getDeptId() {return deptId;}
public void setDeptId(String deptId) {this.deptId = deptId;}
}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_dept")
public class Dept {
//主键
@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 deptName;
//
private String deptMan;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
public String getDeptMan() {return deptMan;}
public void setDeptMan(String deptMan) {this.deptMan = deptMan;}
}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_exam")
public class Exam {
//主键
@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 kcId;
//
private String examName;
//
private Integer studentId;
//
private String examDate;
//
private Integer code;
//
private String jkls;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public String getExamName() {return examName;}
public void setExamName(String examName) {this.examName = examName;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getExamDate() {return examDate;}
public void setExamDate(String examDate) {this.examDate = examDate;}
public Integer getCode() {return code;}
public void setCode(Integer code) {this.code = code;}
public String getJkls() {return jkls;}
public void setJkls(String jkls) {this.jkls = jkls;}
}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_kc")
public class Kc {
//主键
@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 kcName;
//
private String zy;
//
private String sfxu;
//
private String sksj;
//
private String skls;
//
private String skdd;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getSfxu() {return sfxu;}
public void setSfxu(String sfxu) {this.sfxu = sfxu;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public String getSkls() {return skls;}
public void setSkls(String skls) {this.skls = skls;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
}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 studentName;
//
private String studentNo;
//
private Integer age;
//
private String sex;
//
private String address;
//
private String mobile;
//
private Date insertDate;
//
private Integer classId;
//
private String username;
//
private String password;
public String getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getStudentNo() {return studentNo;}
public void setStudentNo(String studentNo) {this.studentNo = studentNo;}
public Integer getAge() {return age;}
public void setAge(Integer age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getClassId() {return classId;}
public void setClassId(Integer classId) {this.classId = classId;}
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;}
}老师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 name;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//身份证
private String idcard;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}基于WEB的学生信息管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//
public class Class extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String className;
//
private String classMan;
//
private String deptId;
public String getClassName() {return className;}
public void setClassName(String className) {this.className = className;}
public String getClassMan() {return classMan;}
public void setClassMan(String classMan) {this.classMan = classMan;}
public String getDeptId() {return deptId;}
public void setDeptId(String deptId) {this.deptId = deptId;}
}javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//
public class Dept extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String deptName;
//
private String deptMan;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
public String getDeptMan() {return deptMan;}
public void setDeptMan(String deptMan) {this.deptMan = deptMan;}
}javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//
public class Exam extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer kcId;
//
private String examName;
//
private Integer studentId;
//
private String examDate;
//
private Integer code;
//
private String jkls;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public String getExamName() {return examName;}
public void setExamName(String examName) {this.examName = examName;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getExamDate() {return examDate;}
public void setExamDate(String examDate) {this.examDate = examDate;}
public Integer getCode() {return code;}
public void setCode(Integer code) {this.code = code;}
public String getJkls() {return jkls;}
public void setJkls(String jkls) {this.jkls = jkls;}
}javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//
public class Kc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String kcName;
//
private String zy;
//
private String sfxu;
//
private String sksj;
//
private String skls;
//
private String skdd;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getSfxu() {return sfxu;}
public void setSfxu(String sfxu) {this.sfxu = sfxu;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public String getSkls() {return skls;}
public void setSkls(String skls) {this.skls = skls;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
}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 studentName;
//
private String studentNo;
//
private Integer age;
//
private String sex;
//
private String address;
//
private String mobile;
//
private Date insertDate;
//
private Integer classId;
//
private String username;
//
private String password;
public String getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getStudentNo() {return studentNo;}
public void setStudentNo(String studentNo) {this.studentNo = studentNo;}
public Integer getAge() {return age;}
public void setAge(Integer age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Integer getClassId() {return classId;}
public void setClassId(Integer classId) {this.classId = classId;}
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;}
}老师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 name;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//身份证
private String idcard;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}