學籍管理系統
學籍管理系統
- 學籍管理系統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_kc(
id int primary key auto_increment comment '主鍵',
kcName varchar(100) comment '課程名稱',
xf int comment '學分'
) comment '課程';
基礎值配置表建立語句如下：
create table t_pz(
id int primary key auto_increment comment '主鍵',
lest int comment '預警值',
zd int 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 '姓名',
pic varchar(100) comment '頭像',
sex varchar(100) comment '性別',
age varchar(100) comment '年齡',
phone varchar(100) comment '電話',
idcard varchar(100) comment '身份證',
birthday varchar(100) comment '出生日期',
xuejh varchar(100) comment '學籍號',
ds varchar(100) comment '是否獨生子女',
bj varchar(100) comment '班級',
address varchar(100) comment '家庭住址',
jhr 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 '姓名',
sex varchar(100) comment '性別',
age varchar(100) comment '年齡',
phone varchar(100) comment '電話',
idcard varchar(100) comment '身份證'
) comment '老師';
通知表建立語句如下：
create table t_tz(
id int primary key auto_increment comment '主鍵',
title varchar(100) comment '標題',
pic varchar(100) comment '圖片',
wj varchar(100) comment '檔案',
content varchar(100) comment '內容',
showDate varchar(100) comment '顯示日期'
) comment '通知';
學生獲取學分情況表建立語句如下：
create table t_xsxf(
id int primary key auto_increment comment '主鍵',
studentId int comment '',
kcName varchar(100) comment '課程名稱',
df int comment '獲得學分',
ydxf int comment '應得學分',
remark 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,
kcName varchar(100),
xf int
);
--課程欄位加註釋
comment on column t_kc.id is '主鍵';
comment on column t_kc.kcName is '課程名稱';
comment on column t_kc.xf is '學分';
--課程表加註釋
comment on table t_kc is '課程';
基礎值配置表建立語句如下：
create table t_pz(
id integer,
lest int,
zd int
);
--基礎值配置欄位加註釋
comment on column t_pz.id is '主鍵';
comment on column t_pz.lest is '預警值';
comment on column t_pz.zd is '畢業最低學分';
--基礎值配置表加註釋
comment on table t_pz is '基礎值配置';
學生學籍資訊表建立語句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
pic varchar(100),
sex varchar(100),
age varchar(100),
phone varchar(100),
idcard varchar(100),
birthday varchar(100),
xuejh varchar(100),
ds varchar(100),
bj varchar(100),
address varchar(100),
jhr 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.pic is '頭像';
comment on column t_student.sex is '性別';
comment on column t_student.age is '年齡';
comment on column t_student.phone is '電話';
comment on column t_student.idcard is '身份證';
comment on column t_student.birthday is '出生日期';
comment on column t_student.xuejh is '學籍號';
comment on column t_student.ds is '是否獨生子女';
comment on column t_student.bj is '班級';
comment on column t_student.address is '家庭住址';
comment on column t_student.jhr is '監護人資訊';
--學生學籍資訊表加註釋
comment on table t_student is '學生學籍資訊';
老師表建立語句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName 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.teacherName 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 '老師';
通知表建立語句如下：
create table t_tz(
id integer,
title varchar(100),
pic varchar(100),
wj varchar(100),
content varchar(100),
showDate varchar(100)
);
--通知欄位加註釋
comment on column t_tz.id is '主鍵';
comment on column t_tz.title is '標題';
comment on column t_tz.pic is '圖片';
comment on column t_tz.wj is '檔案';
comment on column t_tz.content is '內容';
comment on column t_tz.showDate is '顯示日期';
--通知表加註釋
comment on table t_tz is '通知';
學生獲取學分情況表建立語句如下：
create table t_xsxf(
id integer,
studentId int,
kcName varchar(100),
df int,
ydxf int,
remark varchar(100)
);
--學生獲取學分情況欄位加註釋
comment on column t_xsxf.id is '主鍵';
comment on column t_xsxf.studentId is '';
comment on column t_xsxf.kcName is '課程名稱';
comment on column t_xsxf.df is '獲得學分';
comment on column t_xsxf.ydxf is '應得學分';
comment on column t_xsxf.remark is '備註';
--學生獲取學分情況表加註釋
comment on table t_xsxf is '學生獲取學分情況';
oracle特有，對應序列如下：
create sequence s_t_kc;
create sequence s_t_pz;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_tz;
create sequence s_t_xsxf;
學籍管理系統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,--主鍵
kcName varchar(100),--課程名稱
xf int--學分
);
基礎值配置表建立語句如下：
--基礎值配置表註釋
create table t_pz(
id int identity(1,1) primary key not null,--主鍵
lest int,--預警值
zd int--畢業最低學分
);
學生學籍資訊表建立語句如下：
--學生學籍資訊表註釋
create table t_student(
id int identity(1,1) primary key not null,--主鍵
username varchar(100),--賬號
password varchar(100),--密碼
studentName varchar(100),--姓名
pic varchar(100),--頭像
sex varchar(100),--性別
age varchar(100),--年齡
phone varchar(100),--電話
idcard varchar(100),--身份證
birthday varchar(100),--出生日期
xuejh varchar(100),--學籍號
ds varchar(100),--是否獨生子女
bj varchar(100),--班級
address varchar(100),--家庭住址
jhr varchar(100)--監護人資訊
);
老師表建立語句如下：
--老師表註釋
create table t_teacher(
id int identity(1,1) primary key not null,--主鍵
username varchar(100),--賬號
password varchar(100),--密碼
teacherName varchar(100),--姓名
sex varchar(100),--性別
age varchar(100),--年齡
phone varchar(100),--電話
idcard varchar(100)--身份證
);
通知表建立語句如下：
--通知表註釋
create table t_tz(
id int identity(1,1) primary key not null,--主鍵
title varchar(100),--標題
pic varchar(100),--圖片
wj varchar(100),--檔案
content varchar(100),--內容
showDate varchar(100)--顯示日期
);
學生獲取學分情況表建立語句如下：
--學生獲取學分情況表註釋
create table t_xsxf(
id int identity(1,1) primary key not null,--主鍵
studentId int,--
kcName varchar(100),--課程名稱
df int,--獲得學分
ydxf int,--應得學分
remark 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 kcName;
//學分
private Integer xf;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
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_pz")
public class Pz {
//主鍵
@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 lest;
//畢業最低學分
private Integer zd;
public Integer getLest() {return lest;}
public void setLest(Integer lest) {this.lest = lest;}
public Integer getZd() {return zd;}
public void setZd(Integer zd) {this.zd = zd;}
}學生學籍資訊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 pic;
//性別
private String sex;
//年齡
private String age;
//電話
private String phone;
//身份證
private String idcard;
//出生日期
private String birthday;
//學籍號
private String xuejh;
//是否獨生子女
private String ds;
//班級
private String bj;
//家庭住址
private String address;
//監護人資訊
private String jhr;
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
public String getXuejh() {return xuejh;}
public void setXuejh(String xuejh) {this.xuejh = xuejh;}
public String getDs() {return ds;}
public void setDs(String ds) {this.ds = ds;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getJhr() {return jhr;}
public void setJhr(String jhr) {this.jhr = jhr;}
}老師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 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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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;}
}通知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_tz")
public class Tz {
//主鍵
@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 title;
//圖片
private String pic;
//檔案
private String wj;
//內容
private String content;
//顯示日期
private String showDate;
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 getWj() {return wj;}
public void setWj(String wj) {this.wj = wj;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String 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_xsxf")
public class Xsxf {
//主鍵
@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 String kcName;
//獲得學分
private Integer df;
//應得學分
private Integer ydxf;
//備註
private String remark;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Integer getDf() {return df;}
public void setDf(Integer df) {this.df = df;}
public Integer getYdxf() {return ydxf;}
public void setYdxf(Integer ydxf) {this.ydxf = ydxf;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}學籍管理系統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 kcName;
//學分
private Integer xf;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
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 Pz extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//預警值
private Integer lest;
//畢業最低學分
private Integer zd;
public Integer getLest() {return lest;}
public void setLest(Integer lest) {this.lest = lest;}
public Integer getZd() {return zd;}
public void setZd(Integer zd) {this.zd = zd;}
}學生學籍資訊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 pic;
//性別
private String sex;
//年齡
private String age;
//電話
private String phone;
//身份證
private String idcard;
//出生日期
private String birthday;
//學籍號
private String xuejh;
//是否獨生子女
private String ds;
//班級
private String bj;
//家庭住址
private String address;
//監護人資訊
private String jhr;
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
public String getBirthday() {return birthday;}
public void setBirthday(String birthday) {this.birthday = birthday;}
public String getXuejh() {return xuejh;}
public void setXuejh(String xuejh) {this.xuejh = xuejh;}
public String getDs() {return ds;}
public void setDs(String ds) {this.ds = ds;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getJhr() {return jhr;}
public void setJhr(String jhr) {this.jhr = jhr;}
}老師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 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 getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
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;}
}通知javaBean建立語句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//通知
public class Tz extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//標題
private String title;
//圖片
private String pic;
//檔案
private String wj;
//內容
private String content;
//顯示日期
private String showDate;
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 getWj() {return wj;}
public void setWj(String wj) {this.wj = wj;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}學生獲取學分情況javaBean建立語句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//學生獲取學分情況
public class Xsxf extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer studentId;
//課程名稱
private String kcName;
//獲得學分
private Integer df;
//應得學分
private Integer ydxf;
//備註
private String remark;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public Integer getDf() {return df;}
public void setDf(Integer df) {this.df = df;}
public Integer getYdxf() {return ydxf;}
public void setYdxf(Integer ydxf) {this.ydxf = ydxf;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}相關文章
- 學生學籍管理系統~~功能介面
- C++實現控制檯學生學籍管理系統C++
- 【C語言課程設計】學生學籍管理系統C語言
- SSM框架整合——書籍管理系統SSM框架
- 學生管理系統
- 10本適合於系統管理員的最佳書籍
- SchoolCMS學校管理系統
- 學生成績管理系統
- 系統分析師書籍
- 學生管理系統(springMVC)SpringMVC
- JAVA學生宿舍管理系統Java
- 【C++】學生管理系統C++
- 學生管理系統程式碼
- 學生選題資訊管理系統
- （十）ArrayList&&學生管理系統
- 【練習】學生成績管理系統
- 學生資訊管理系統用例
- 【學生資訊管理系統】系統的介面與後臺
- 系統維護開發核心祕籍
- Java簡單學生資訊管理系統Java
- Django練習-學生管理系統案例Django
- 9、ArrayList集合完成學生管理系統
- 基於php學生資訊管理系統PHP
- Python簡易學生管理系統Python
- 學生資訊管理系統之深度理解
- 學生資訊管理系統之優化優化
- 【學生資訊管理系統】EOF 和 BOF
- 學生管理系統 四色原型原型
- 某學校的學生資訊管理系統網站網站
- 技術管理—管理書籍推薦
- Linux作業系統上必需要學的系統管理命令Linux作業系統
- 校園圖書管理系統開發-中小學智慧圖書管理系統開發
- 個人管理系統-03-學會閱讀
- C語言學生管理系統原始碼C語言原始碼
- 學生資訊管理系統課程設計
- Linux系統學習之檔案管理Linux
- Linux系統學習之網路管理Linux
- 學生管理系統java簡單實現Java