某學校的學生資訊管理系統網站

某學校的學生資訊管理系統網站

• 某學校的學生資訊管理系統網站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_bj(
	id int primary key auto_increment comment '主鍵',
	bjName varchar(100) comment '班級'
) comment '班級';

成績表建立語句如下：

create table t_cj(
	id int primary key auto_increment comment '主鍵',
	studentId int comment '學生',
	kcName varchar(100) comment '課程名稱',
	jc int comment '分數'
) comment '成績';

公告表建立語句如下：

create table t_gg(
	id int primary key auto_increment comment '主鍵',
	title varchar(100) comment '標題',
	pic varchar(100) comment '圖片',
	content varchar(100) comment '內容',
	showDate datetime comment '日期'
) comment '公告';

系部領導表建立語句如下：

create table t_ptadmin(
	id int primary key auto_increment comment '主鍵',
	username varchar(100) comment '賬號',
	password varchar(100) comment '密碼 ',
	ptadminName varchar(100) comment '姓名',
	age varchar(100) comment '年齡',
	sex varchar(100) comment '性別',
	phone varchar(100) comment '電話',
	yxId 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 '姓名',
	bjId int comment '班級',
	yxId int comment '院系',
	age varchar(100) comment '年齡',
	sex varchar(100) comment '性別',
	phone varchar(100) comment '電話',
	qq varchar(100) comment 'QQ',
	email varchar(100) comment '郵箱',
	pic varchar(100) comment '頭像',
	zyId int 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 '頭像',
	bjId int comment '班級',
	yxId int comment '院系'
) comment '老師';

院系表建立語句如下：

create table t_yx(
	id int primary key auto_increment comment '主鍵',
	yxName varchar(100) comment '院系'
) comment '院系';

專業表建立語句如下：

create table t_zy(
	id int primary key auto_increment comment '主鍵',
	zyName 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)
);
--班級欄位加註釋
comment on column t_bj.id is '主鍵';
comment on column t_bj.bjName is '班級';
--班級表加註釋
comment on table t_bj is '班級';

成績表建立語句如下：

create table t_cj(
	id integer,
	studentId int,
	kcName varchar(100),
	jc int
);
--成績欄位加註釋
comment on column t_cj.id is '主鍵';
comment on column t_cj.studentId is '學生';
comment on column t_cj.kcName is '課程名稱';
comment on column t_cj.jc is '分數';
--成績表加註釋
comment on table t_cj is '成績';

公告表建立語句如下：

create table t_gg(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime
);
--公告欄位加註釋
comment on column t_gg.id is '主鍵';
comment on column t_gg.title is '標題';
comment on column t_gg.pic is '圖片';
comment on column t_gg.content is '內容';
comment on column t_gg.showDate is '日期';
--公告表加註釋
comment on table t_gg is '公告';

系部領導表建立語句如下：

create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	yxId int
);
--系部領導欄位加註釋
comment on column t_ptadmin.id is '主鍵';
comment on column t_ptadmin.username is '賬號';
comment on column t_ptadmin.password is '密碼 ';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.age is '年齡';
comment on column t_ptadmin.sex is '性別';
comment on column t_ptadmin.phone is '電話';
comment on column t_ptadmin.yxId is '院系';
--系部領導表加註釋
comment on table t_ptadmin is '系部領導';

學生表建立語句如下：

create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	bjId int,
	yxId int,
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	qq varchar(100),
	email varchar(100),
	pic varchar(100),
	zyId int
);
--學生欄位加註釋
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.bjId is '班級';
comment on column t_student.yxId 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.qq is 'QQ';
comment on column t_student.email is '郵箱';
comment on column t_student.pic is '頭像';
comment on column t_student.zyId 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),
	bjId int,
	yxId int
);
--老師欄位加註釋
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 column t_teacher.bjId is '班級';
comment on column t_teacher.yxId is '院系';
--老師表加註釋
comment on table t_teacher is '老師';

院系表建立語句如下：

create table t_yx(
	id integer,
	yxName varchar(100)
);
--院系欄位加註釋
comment on column t_yx.id is '主鍵';
comment on column t_yx.yxName is '院系';
--院系表加註釋
comment on table t_yx is '院系';

專業表建立語句如下：

create table t_zy(
	id integer,
	zyName varchar(100)
);
--專業欄位加註釋
comment on column t_zy.id is '主鍵';
comment on column t_zy.zyName is '專業';
--專業表加註釋
comment on table t_zy is '專業';

oracle特有，對應序列如下：

create sequence s_t_bj;
create sequence s_t_cj;
create sequence s_t_gg;
create sequence s_t_ptadmin;
create sequence s_t_student;
create sequence s_t_teacher;
create sequence s_t_yx;
create sequence s_t_zy;

某學校的學生資訊管理系統網站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)--班級
);

成績表建立語句如下：

--成績表註釋
create table t_cj(
	id int identity(1,1) primary key not null,--主鍵
	studentId int,--學生
	kcName varchar(100),--課程名稱
	jc int--分數
);

公告表建立語句如下：

--公告表註釋
create table t_gg(
	id int identity(1,1) primary key not null,--主鍵
	title varchar(100),--標題
	pic varchar(100),--圖片
	content varchar(100),--內容
	showDate datetime--日期
);

系部領導表建立語句如下：

--系部領導表註釋
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主鍵
	username varchar(100),--賬號
	password varchar(100),--密碼 
	ptadminName varchar(100),--姓名
	age varchar(100),--年齡
	sex varchar(100),--性別
	phone varchar(100),--電話
	yxId int--院系
);

學生表建立語句如下：

--學生表註釋
create table t_student(
	id int identity(1,1) primary key not null,--主鍵
	username varchar(100),--賬號
	password varchar(100),--密碼 
	studentName varchar(100),--姓名
	bjId int,--班級
	yxId int,--院系
	age varchar(100),--年齡
	sex varchar(100),--性別
	phone varchar(100),--電話
	qq varchar(100),--QQ
	email varchar(100),--郵箱
	pic varchar(100),--頭像
	zyId int--專業
);

老師表建立語句如下：

--老師表註釋
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),--頭像
	bjId int,--班級
	yxId int--院系
);

院系表建立語句如下：

--院系表註釋
create table t_yx(
	id int identity(1,1) primary key not null,--主鍵
	yxName varchar(100)--院系
);

專業表建立語句如下：

--專業表註釋
create table t_zy(
	id int identity(1,1) primary key not null,--主鍵
	zyName 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_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;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}

成績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 Integer studentId;
//課程名稱
private String kcName;
//分數
private Integer jc;
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 getJc() {return jc;}
public void setJc(Integer jc) {this.jc = jc;}
}

公告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_gg")
public class Gg {
//主鍵
@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 content;
//日期
private Date 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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_ptadmin")
public class Ptadmin {
//主鍵
@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 ptadminName;
//年齡
private String age;
//性別
private String sex;
//電話
private String phone;
//院系
private Integer yxId;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
}

學生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 Integer bjId;
//院系
private Integer yxId;
//年齡
private String age;
//性別
private String sex;
//電話
private String phone;
//QQ
private String qq;
//郵箱
private String email;
//頭像
private String pic;
//專業
private Integer zyId;
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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
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 getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getZyId() {return zyId;}
public void setZyId(Integer zyId) {this.zyId = zyId;}
}

老師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;
//班級
private Integer bjId;
//院系
private Integer yxId;
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;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
}

院系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_yx")
public class Yx {
//主鍵
@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 yxName;
public String getYxName() {return yxName;}
public void setYxName(String yxName) {this.yxName = yxName;}
}

專業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_zy")
public class Zy {
//主鍵
@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 zyName;
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
}

某學校的學生資訊管理系統網站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;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}

成績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 Integer studentId;
//課程名稱
private String kcName;
//分數
private Integer jc;
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 getJc() {return jc;}
public void setJc(Integer jc) {this.jc = jc;}
}

公告javaBean建立語句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gg  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 content;
//日期
private Date 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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Ptadmin  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 ptadminName;
//年齡
private String age;
//性別
private String sex;
//電話
private String phone;
//院系
private Integer yxId;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
}

學生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 Integer bjId;
//院系
private Integer yxId;
//年齡
private String age;
//性別
private String sex;
//電話
private String phone;
//QQ
private String qq;
//郵箱
private String email;
//頭像
private String pic;
//專業
private Integer zyId;
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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
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 getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getZyId() {return zyId;}
public void setZyId(Integer zyId) {this.zyId = zyId;}
}

老師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;
//班級
private Integer bjId;
//院系
private Integer yxId;
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;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
public Integer getYxId() {return yxId;}
public void setYxId(Integer yxId) {this.yxId = yxId;}
}

院系javaBean建立語句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//院系
public class Yx  extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//院系
private String yxName;
public String getYxName() {return yxName;}
public void setYxName(String yxName) {this.yxName = yxName;}
}

專業javaBean建立語句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//專業
public class Zy  extends BaseBean{
//主鍵
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//專業
private String zyName;
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
}