基于学分制系统开发与设计

基于学分制系统开发与设计登录注册界面

基于学分制系统开发与设计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_kc(
	id int primary key auto_increment comment '主键',
	xnxq varchar(100) comment '学年学期',
	kcName varchar(100) comment '课程',
	kcdm varchar(100) comment '课程代码',
	types varchar(100) comment '课程性质',
	bj varchar(100) comment '班级',
	ls varchar(100) comment '老师',
	skdd varchar(100) comment '上课地点',
	sksj varchar(100) comment '上课时间',
	nums int comment '人数',
	xf int comment '学分'
) comment '课程';

课程选择表创建语句如下:


create table t_kcxz(
	id int primary key auto_increment comment '主键',
	studentId int comment '课程选择',
	kcId int comment '课程',
	fs int comment '分数',
	xf int comment '学分',
	status varchar(100) comment '状态',
	pj 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 '电话',
	pic varchar(100) comment '头像',
	bj varchar(100) comment '班级',
	yx varchar(100) comment '院校',
	zzmm varchar(100) comment '政治面貌',
	jtzz 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 '电话',
	pic 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_kc(
	id integer,
	xnxq varchar(100),
	kcName varchar(100),
	kcdm varchar(100),
	types varchar(100),
	bj varchar(100),
	ls varchar(100),
	skdd varchar(100),
	sksj varchar(100),
	nums int,
	xf int
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.xnxq is '学年学期';
comment on column t_kc.kcName is '课程';
comment on column t_kc.kcdm is '课程代码';
comment on column t_kc.types is '课程性质';
comment on column t_kc.bj is '班级';
comment on column t_kc.ls is '老师';
comment on column t_kc.skdd is '上课地点';
comment on column t_kc.sksj is '上课时间';
comment on column t_kc.nums is '人数';
comment on column t_kc.xf is '学分';
--课程表加注释
comment on table t_kc is '课程';

课程选择表创建语句如下:


create table t_kcxz(
	id integer,
	studentId int,
	kcId int,
	fs int,
	xf int,
	status varchar(100),
	pj varchar(100)
);
--课程选择字段加注释
comment on column t_kcxz.id is '主键';
comment on column t_kcxz.studentId is '课程选择';
comment on column t_kcxz.kcId is '课程';
comment on column t_kcxz.fs is '分数';
comment on column t_kcxz.xf is '学分';
comment on column t_kcxz.status is '状态';
comment on column t_kcxz.pj is '评价';
--课程选择表加注释
comment on table t_kcxz 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),
	pic varchar(100),
	bj varchar(100),
	yx varchar(100),
	zzmm varchar(100),
	jtzz 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.pic is '头像';
comment on column t_student.bj is '班级';
comment on column t_student.yx is '院校';
comment on column t_student.zzmm is '政治面貌';
comment on column t_student.jtzz 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),
	pic 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.pic is '头像';
--老师表加注释
comment on table t_teacher is '老师';

oracle特有,对应序列如下:


create sequence s_t_kc;
create sequence s_t_kcxz;
create sequence s_t_student;
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_kc(
	id int identity(1,1) primary key not null,--主键
	xnxq varchar(100),--学年学期
	kcName varchar(100),--课程
	kcdm varchar(100),--课程代码
	types varchar(100),--课程性质
	bj varchar(100),--班级
	ls varchar(100),--老师
	skdd varchar(100),--上课地点
	sksj varchar(100),--上课时间
	nums int,--人数
	xf int--学分
);

课程选择表创建语句如下:


--课程选择表注释
create table t_kcxz(
	id int identity(1,1) primary key not null,--主键
	studentId int,--课程选择
	kcId int,--课程
	fs int,--分数
	xf int,--学分
	status varchar(100),--状态
	pj 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),--电话
	pic varchar(100),--头像
	bj varchar(100),--班级
	yx varchar(100),--院校
	zzmm varchar(100),--政治面貌
	jtzz 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),--电话
	pic varchar(100)--头像
);

基于学分制系统开发与设计登录后主页

基于学分制系统开发与设计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_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 xnxq;
//课程
private String kcName;
//课程代码
private String kcdm;
//课程性质
private String types;
//班级
private String bj;
//老师
private String ls;
//上课地点
private String skdd;
//上课时间
private String sksj;
//人数
private Integer nums;
//学分
private Integer xf;
public String getXnxq() {return xnxq;}
public void setXnxq(String xnxq) {this.xnxq = xnxq;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getKcdm() {return kcdm;}
public void setKcdm(String kcdm) {this.kcdm = kcdm;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getLs() {return ls;}
public void setLs(String ls) {this.ls = ls;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
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_kcxz")
public class Kcxz {
//主键
@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 kcId;
//分数
private Integer fs;
//学分
private Integer xf;
//状态
private String status;
//评价
private String pj;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
}

学生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 pic;
//班级
private String bj;
//院校
private String yx;
//政治面貌
private String zzmm;
//家庭住址
private String jtzz;
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
public String getZzmm() {return zzmm;}
public void setZzmm(String zzmm) {this.zzmm = zzmm;}
public String getJtzz() {return jtzz;}
public void setJtzz(String jtzz) {this.jtzz = jtzz;}
}

老师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 pic;
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

基于学分制系统开发与设计spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

课程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 xnxq;
//课程
private String kcName;
//课程代码
private String kcdm;
//课程性质
private String types;
//班级
private String bj;
//老师
private String ls;
//上课地点
private String skdd;
//上课时间
private String sksj;
//人数
private Integer nums;
//学分
private Integer xf;
public String getXnxq() {return xnxq;}
public void setXnxq(String xnxq) {this.xnxq = xnxq;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getKcdm() {return kcdm;}
public void setKcdm(String kcdm) {this.kcdm = kcdm;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getLs() {return ls;}
public void setLs(String ls) {this.ls = ls;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getSksj() {return sksj;}
public void setSksj(String sksj) {this.sksj = sksj;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
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 Kcxz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程选择
private Integer studentId;
//课程
private Integer kcId;
//分数
private Integer fs;
//学分
private Integer xf;
//状态
private String status;
//评价
private String pj;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public Integer getFs() {return fs;}
public void setFs(Integer fs) {this.fs = fs;}
public Integer getXf() {return xf;}
public void setXf(Integer xf) {this.xf = xf;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
}

学生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 pic;
//班级
private String bj;
//院校
private String yx;
//政治面貌
private String zzmm;
//家庭住址
private String jtzz;
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
public String getZzmm() {return zzmm;}
public void setZzmm(String zzmm) {this.zzmm = zzmm;}
public String getJtzz() {return jtzz;}
public void setJtzz(String jtzz) {this.jtzz = jtzz;}
}

老师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 pic;
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

源代码下载点这里

评论