- 基于JSP高校新生报道管理系统mysql数据库创建语句
- 基于JSP高校新生报道管理系统oracle数据库创建语句
- 基于JSP高校新生报道管理系统sqlserver数据库创建语句
- 基于JSP高校新生报道管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于JSP高校新生报道管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于JSP高校新生报道管理系统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_bw(
id int primary key auto_increment comment '主键',
bwName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
address varchar(100) comment '位置'
) comment '保卫位置';
缴费表创建语句如下：
create table t_jf(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
v1 varchar(100) comment '缴费金额',
v2 varchar(100) comment '缴费时间'
) comment '缴费';
课程表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
kcName varchar(100) comment '课程名称',
v2 varchar(100) comment '院系',
v3 varchar(100) comment '上课地点',
v4 varchar(100) comment '上课老师',
v5 varchar(100) comment '上课时间'
) comment '课程';
录取通知书表创建语句如下：
create table t_lqtzs(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
title varchar(100) comment '录取通知标题',
pic varchar(100) comment '拍照',
fileUrl varchar(100) comment '附件'
) comment '录取通知书';
宿舍表创建语句如下：
create table t_ss(
id int primary key auto_increment comment '主键',
ssName varchar(100) comment '宿舍编号',
v2 varchar(100) comment '宿舍地点',
v3 varchar(100) comment '宿舍说明'
) comment '宿舍';
采购寝具用品表创建语句如下：
create table t_sscg(
id int primary key auto_increment comment '主键',
ssId int comment '宿舍',
sscgName varchar(100) comment '采购物品名称',
v2 varchar(100) comment '采购地点',
v3 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 '电话',
bj varchar(100) comment '班级',
zyId int comment '专业'
) comment '学生';
学生宿舍表创建语句如下：
create table t_sxss(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
ssId int comment '宿舍'
) comment '学生宿舍';
学生排课表创建语句如下：
create table t_xskc(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
kcId int comment '课程'
) comment '学生排课';
银行卡表创建语句如下：
create table t_yhk(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
kh varchar(100) comment '卡号',
yhmc varchar(100) comment '银行名称'
) comment '银行卡';
银行卡扣款表创建语句如下：
create table t_yhkkk(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
yhkId int comment '银行卡',
kkje varchar(100) comment '扣款金额',
insertDate datetime comment '扣款时间'
) comment '银行卡扣款';
一卡通表创建语句如下：
create table t_ykt(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
yktName varchar(100) comment '一卡通卡号',
v2 varchar(100) comment '一卡通密码',
v3 varchar(100) comment '余额',
v4 varchar(100) comment '备注',
v5 varchar(100) comment '开卡时间'
) comment '一卡通';
辅导员表创建语句如下：
create table t_yxfdy(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '院系',
v2 varchar(100) comment '辅导员名称',
v3 varchar(100) comment '辅导员电话',
v4 varchar(100) comment '辅导员办公地点',
v5 varchar(100) comment '辅导员qq',
v6 varchar(100) comment '辅导员微信'
) comment '辅导员';
申请助学贷款表创建语句如下：
create table t_zxdk(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
zxdkName varchar(100) comment '申请说明',
content varchar(100) comment '具体原因',
insertDate datetime comment '申请日期',
status varchar(100) comment '状态',
back varchar(100) comment '回复'
) comment '申请助学贷款';
专业表创建语句如下：
create table t_zy(
id int primary key auto_increment comment '主键',
zyName varchar(100) comment '专业名称',
zyContent varchar(100) comment '专业描述'
) comment '专业';
基于JSP高校新生报道管理系统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_bw(
id integer,
bwName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
address varchar(100)
);
--保卫位置字段加注释
comment on column t_bw.id is '主键';
comment on column t_bw.bwName is '姓名';
comment on column t_bw.age is '年龄';
comment on column t_bw.sex is '性别';
comment on column t_bw.phone is '电话';
comment on column t_bw.address is '位置';
--保卫位置表加注释
comment on table t_bw is '保卫位置';
缴费表创建语句如下：
create table t_jf(
id integer,
studentId int,
v1 varchar(100),
v2 varchar(100)
);
--缴费字段加注释
comment on column t_jf.id is '主键';
comment on column t_jf.studentId is '学生';
comment on column t_jf.v1 is '缴费金额';
comment on column t_jf.v2 is '缴费时间';
--缴费表加注释
comment on table t_jf is '缴费';
课程表创建语句如下：
create table t_kc(
id integer,
kcName varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.v2 is '院系';
comment on column t_kc.v3 is '上课地点';
comment on column t_kc.v4 is '上课老师';
comment on column t_kc.v5 is '上课时间';
--课程表加注释
comment on table t_kc is '课程';
录取通知书表创建语句如下：
create table t_lqtzs(
id integer,
studentId int,
title varchar(100),
pic varchar(100),
fileUrl varchar(100)
);
--录取通知书字段加注释
comment on column t_lqtzs.id is '主键';
comment on column t_lqtzs.studentId is '学生';
comment on column t_lqtzs.title is '录取通知标题';
comment on column t_lqtzs.pic is '拍照';
comment on column t_lqtzs.fileUrl is '附件';
--录取通知书表加注释
comment on table t_lqtzs is '录取通知书';
宿舍表创建语句如下：
create table t_ss(
id integer,
ssName varchar(100),
v2 varchar(100),
v3 varchar(100)
);
--宿舍字段加注释
comment on column t_ss.id is '主键';
comment on column t_ss.ssName is '宿舍编号';
comment on column t_ss.v2 is '宿舍地点';
comment on column t_ss.v3 is '宿舍说明';
--宿舍表加注释
comment on table t_ss is '宿舍';
采购寝具用品表创建语句如下：
create table t_sscg(
id integer,
ssId int,
sscgName varchar(100),
v2 varchar(100),
v3 varchar(100)
);
--采购寝具用品字段加注释
comment on column t_sscg.id is '主键';
comment on column t_sscg.ssId is '宿舍';
comment on column t_sscg.sscgName is '采购物品名称';
comment on column t_sscg.v2 is '采购地点';
comment on column t_sscg.v3 is '采购说明';
--采购寝具用品表加注释
comment on table t_sscg 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),
bj 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.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.phone is '电话';
comment on column t_student.bj is '班级';
comment on column t_student.zyId is '专业';
--学生表加注释
comment on table t_student is '学生';
学生宿舍表创建语句如下：
create table t_sxss(
id integer,
studentId int,
ssId int
);
--学生宿舍字段加注释
comment on column t_sxss.id is '主键';
comment on column t_sxss.studentId is '学生';
comment on column t_sxss.ssId is '宿舍';
--学生宿舍表加注释
comment on table t_sxss is '学生宿舍';
学生排课表创建语句如下：
create table t_xskc(
id integer,
studentId int,
kcId int
);
--学生排课字段加注释
comment on column t_xskc.id is '主键';
comment on column t_xskc.studentId is '学生';
comment on column t_xskc.kcId is '课程';
--学生排课表加注释
comment on table t_xskc is '学生排课';
银行卡表创建语句如下：
create table t_yhk(
id integer,
studentId int,
kh varchar(100),
yhmc varchar(100)
);
--银行卡字段加注释
comment on column t_yhk.id is '主键';
comment on column t_yhk.studentId is '学生';
comment on column t_yhk.kh is '卡号';
comment on column t_yhk.yhmc is '银行名称';
--银行卡表加注释
comment on table t_yhk is '银行卡';
银行卡扣款表创建语句如下：
create table t_yhkkk(
id integer,
studentId int,
yhkId int,
kkje varchar(100),
insertDate datetime
);
--银行卡扣款字段加注释
comment on column t_yhkkk.id is '主键';
comment on column t_yhkkk.studentId is '学生';
comment on column t_yhkkk.yhkId is '银行卡';
comment on column t_yhkkk.kkje is '扣款金额';
comment on column t_yhkkk.insertDate is '扣款时间';
--银行卡扣款表加注释
comment on table t_yhkkk is '银行卡扣款';
一卡通表创建语句如下：
create table t_ykt(
id integer,
studentId int,
yktName varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100)
);
--一卡通字段加注释
comment on column t_ykt.id is '主键';
comment on column t_ykt.studentId is '学生';
comment on column t_ykt.yktName is '一卡通卡号';
comment on column t_ykt.v2 is '一卡通密码';
comment on column t_ykt.v3 is '余额';
comment on column t_ykt.v4 is '备注';
comment on column t_ykt.v5 is '开卡时间';
--一卡通表加注释
comment on table t_ykt is '一卡通';
辅导员表创建语句如下：
create table t_yxfdy(
id integer,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100)
);
--辅导员字段加注释
comment on column t_yxfdy.id is '主键';
comment on column t_yxfdy.v1 is '院系';
comment on column t_yxfdy.v2 is '辅导员名称';
comment on column t_yxfdy.v3 is '辅导员电话';
comment on column t_yxfdy.v4 is '辅导员办公地点';
comment on column t_yxfdy.v5 is '辅导员qq';
comment on column t_yxfdy.v6 is '辅导员微信';
--辅导员表加注释
comment on table t_yxfdy is '辅导员';
申请助学贷款表创建语句如下：
create table t_zxdk(
id integer,
studentId int,
zxdkName varchar(100),
content varchar(100),
insertDate datetime,
status varchar(100),
back varchar(100)
);
--申请助学贷款字段加注释
comment on column t_zxdk.id is '主键';
comment on column t_zxdk.studentId is '学生';
comment on column t_zxdk.zxdkName is '申请说明';
comment on column t_zxdk.content is '具体原因';
comment on column t_zxdk.insertDate is '申请日期';
comment on column t_zxdk.status is '状态';
comment on column t_zxdk.back is '回复';
--申请助学贷款表加注释
comment on table t_zxdk is '申请助学贷款';
专业表创建语句如下：
create table t_zy(
id integer,
zyName varchar(100),
zyContent varchar(100)
);
--专业字段加注释
comment on column t_zy.id is '主键';
comment on column t_zy.zyName is '专业名称';
comment on column t_zy.zyContent is '专业描述';
--专业表加注释
comment on table t_zy is '专业';
oracle特有，对应序列如下：
create sequence s_t_bw;
create sequence s_t_jf;
create sequence s_t_kc;
create sequence s_t_lqtzs;
create sequence s_t_ss;
create sequence s_t_sscg;
create sequence s_t_student;
create sequence s_t_sxss;
create sequence s_t_xskc;
create sequence s_t_yhk;
create sequence s_t_yhkkk;
create sequence s_t_ykt;
create sequence s_t_yxfdy;
create sequence s_t_zxdk;
create sequence s_t_zy;
基于JSP高校新生报道管理系统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_bw(
id int identity(1,1) primary key not null,--主键
bwName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
address varchar(100)--位置
);
缴费表创建语句如下：
--缴费表注释
create table t_jf(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
v1 varchar(100),--缴费金额
v2 varchar(100)--缴费时间
);
课程表创建语句如下：
--课程表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
kcName varchar(100),--课程名称
v2 varchar(100),--院系
v3 varchar(100),--上课地点
v4 varchar(100),--上课老师
v5 varchar(100)--上课时间
);
录取通知书表创建语句如下：
--录取通知书表注释
create table t_lqtzs(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
title varchar(100),--录取通知标题
pic varchar(100),--拍照
fileUrl varchar(100)--附件
);
宿舍表创建语句如下：
--宿舍表注释
create table t_ss(
id int identity(1,1) primary key not null,--主键
ssName varchar(100),--宿舍编号
v2 varchar(100),--宿舍地点
v3 varchar(100)--宿舍说明
);
采购寝具用品表创建语句如下：
--采购寝具用品表注释
create table t_sscg(
id int identity(1,1) primary key not null,--主键
ssId int,--宿舍
sscgName varchar(100),--采购物品名称
v2 varchar(100),--采购地点
v3 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),--电话
bj varchar(100),--班级
zyId int--专业
);
学生宿舍表创建语句如下：
--学生宿舍表注释
create table t_sxss(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
ssId int--宿舍
);
学生排课表创建语句如下：
--学生排课表注释
create table t_xskc(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
kcId int--课程
);
银行卡表创建语句如下：
--银行卡表注释
create table t_yhk(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
kh varchar(100),--卡号
yhmc varchar(100)--银行名称
);
银行卡扣款表创建语句如下：
--银行卡扣款表注释
create table t_yhkkk(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
yhkId int,--银行卡
kkje varchar(100),--扣款金额
insertDate datetime--扣款时间
);
一卡通表创建语句如下：
--一卡通表注释
create table t_ykt(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
yktName varchar(100),--一卡通卡号
v2 varchar(100),--一卡通密码
v3 varchar(100),--余额
v4 varchar(100),--备注
v5 varchar(100)--开卡时间
);
辅导员表创建语句如下：
--辅导员表注释
create table t_yxfdy(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--院系
v2 varchar(100),--辅导员名称
v3 varchar(100),--辅导员电话
v4 varchar(100),--辅导员办公地点
v5 varchar(100),--辅导员qq
v6 varchar(100)--辅导员微信
);
申请助学贷款表创建语句如下：
--申请助学贷款表注释
create table t_zxdk(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
zxdkName varchar(100),--申请说明
content varchar(100),--具体原因
insertDate datetime,--申请日期
status varchar(100),--状态
back varchar(100)--回复
);
专业表创建语句如下：
--专业表注释
create table t_zy(
id int identity(1,1) primary key not null,--主键
zyName varchar(100),--专业名称
zyContent varchar(100)--专业描述
);
登录后主页.jpg?x-oss-process=style/00001)
基于JSP高校新生报道管理系统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_bw")
public class Bw {
//主键
@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 bwName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//位置
private String address;
public String getBwName() {return bwName;}
public void setBwName(String bwName) {this.bwName = bwName;}
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 getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}缴费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_jf")
public class Jf {
//主键
@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 v1;
//缴费时间
private String v2;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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;}
}课程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 v2;
//上课地点
private String v3;
//上课老师
private String v4;
//上课时间
private String v5;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}录取通知书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_lqtzs")
public class Lqtzs {
//主键
@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 title;
//拍照
private String pic;
//附件
private String fileUrl;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}宿舍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_ss")
public class Ss {
//主键
@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 ssName;
//宿舍地点
private String v2;
//宿舍说明
private String v3;
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}采购寝具用品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_sscg")
public class Sscg {
//主键
@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 ssId;
//采购物品名称
private String sscgName;
//采购地点
private String v2;
//采购说明
private String v3;
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
public String getSscgName() {return sscgName;}
public void setSscgName(String sscgName) {this.sscgName = sscgName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}学生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 bj;
//专业
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 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 getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
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_sxss")
public class Sxss {
//主键
@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 ssId;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
}学生排课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_xskc")
public class Xskc {
//主键
@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;
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;}
}银行卡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_yhk")
public class Yhk {
//主键
@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 kh;
//银行名称
private String yhmc;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getKh() {return kh;}
public void setKh(String kh) {this.kh = kh;}
public String getYhmc() {return yhmc;}
public void setYhmc(String yhmc) {this.yhmc = yhmc;}
}银行卡扣款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_yhkkk")
public class Yhkkk {
//主键
@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 yhkId;
//扣款金额
private String kkje;
//扣款时间
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getYhkId() {return yhkId;}
public void setYhkId(Integer yhkId) {this.yhkId = yhkId;}
public String getKkje() {return kkje;}
public void setKkje(String kkje) {this.kkje = kkje;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}一卡通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_ykt")
public class Ykt {
//主键
@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 yktName;
//一卡通密码
private String v2;
//余额
private String v3;
//备注
private String v4;
//开卡时间
private String v5;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getYktName() {return yktName;}
public void setYktName(String yktName) {this.yktName = yktName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}辅导员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_yxfdy")
public class Yxfdy {
//主键
@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 v1;
//辅导员名称
private String v2;
//辅导员电话
private String v3;
//辅导员办公地点
private String v4;
//辅导员qq
private String v5;
//辅导员微信
private String v6;
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 getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}申请助学贷款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_zxdk")
public class Zxdk {
//主键
@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 zxdkName;
//具体原因
private String content;
//申请日期
private Date insertDate;
//状态
private String status;
//回复
private String back;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getZxdkName() {return zxdkName;}
public void setZxdkName(String zxdkName) {this.zxdkName = zxdkName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}专业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;
//专业描述
private String zyContent;
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
public String getZyContent() {return zyContent;}
public void setZyContent(String zyContent) {this.zyContent = zyContent;}
}基于JSP高校新生报道管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
保卫位置javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//保卫位置
public class Bw extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String bwName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//位置
private String address;
public String getBwName() {return bwName;}
public void setBwName(String bwName) {this.bwName = bwName;}
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 getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}缴费javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//缴费
public class Jf extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//缴费金额
private String v1;
//缴费时间
private String v2;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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;}
}课程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 v2;
//上课地点
private String v3;
//上课老师
private String v4;
//上课时间
private String v5;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}录取通知书javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//录取通知书
public class Lqtzs extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//录取通知标题
private String title;
//拍照
private String pic;
//附件
private String fileUrl;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}宿舍javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//宿舍
public class Ss extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//宿舍编号
private String ssName;
//宿舍地点
private String v2;
//宿舍说明
private String v3;
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}采购寝具用品javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//采购寝具用品
public class Sscg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//宿舍
private Integer ssId;
//采购物品名称
private String sscgName;
//采购地点
private String v2;
//采购说明
private String v3;
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
public String getSscgName() {return sscgName;}
public void setSscgName(String sscgName) {this.sscgName = sscgName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}学生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 bj;
//专业
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 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 getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
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 Sxss extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//宿舍
private Integer ssId;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
}学生排课javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//学生排课
public class Xskc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//课程
private Integer kcId;
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;}
}银行卡javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//银行卡
public class Yhk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//卡号
private String kh;
//银行名称
private String yhmc;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getKh() {return kh;}
public void setKh(String kh) {this.kh = kh;}
public String getYhmc() {return yhmc;}
public void setYhmc(String yhmc) {this.yhmc = yhmc;}
}银行卡扣款javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//银行卡扣款
public class Yhkkk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//银行卡
private Integer yhkId;
//扣款金额
private String kkje;
//扣款时间
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getYhkId() {return yhkId;}
public void setYhkId(Integer yhkId) {this.yhkId = yhkId;}
public String getKkje() {return kkje;}
public void setKkje(String kkje) {this.kkje = kkje;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}一卡通javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//一卡通
public class Ykt extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//一卡通卡号
private String yktName;
//一卡通密码
private String v2;
//余额
private String v3;
//备注
private String v4;
//开卡时间
private String v5;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getYktName() {return yktName;}
public void setYktName(String yktName) {this.yktName = yktName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}辅导员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//辅导员
public class Yxfdy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//院系
private String v1;
//辅导员名称
private String v2;
//辅导员电话
private String v3;
//辅导员办公地点
private String v4;
//辅导员qq
private String v5;
//辅导员微信
private String v6;
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 getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}申请助学贷款javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//申请助学贷款
public class Zxdk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//申请说明
private String zxdkName;
//具体原因
private String content;
//申请日期
private Date insertDate;
//状态
private String status;
//回复
private String back;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getZxdkName() {return zxdkName;}
public void setZxdkName(String zxdkName) {this.zxdkName = zxdkName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}专业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;
//专业描述
private String zyContent;
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
public String getZyContent() {return zyContent;}
public void setZyContent(String zyContent) {this.zyContent = zyContent;}
}