高考志愿填报辅助系统(xfa90)_mysql_oracle代码分享

• 高考志愿填报辅助系统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_dq(
	id int primary key auto_increment comment '主键',
	dqName varchar(100) comment '地区'
) comment '地区';

风险表创建语句如下：

create table t_fx(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content text comment '内容',
	lb varchar(100) comment '类别',
	fileUrl varchar(100) comment '附件',
	djl varchar(100) 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 '姓名',
	headPic varchar(100) comment '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex 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 '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '',
	zy varchar(100) comment '专业',
	xx varchar(100) comment '学校'
) comment '学生';

通知表创建语句如下：

create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content text comment '内容',
	insertDate datetime comment '日期'
) comment '通知';

学校表创建语句如下：

create table t_xuexiao(
	id int primary key auto_increment comment '主键',
	xuexiaoName varchar(100) comment '学校',
	logo varchar(100) comment 'logo',
	dqId int comment '地区',
	lb varchar(100) comment '类别',
	wl varchar(100) comment '',
	nf varchar(100) comment '',
	zdf int comment '最低分',
	pjf int comment '平均分',
	fx varchar(100) comment '',
	zy varchar(100) comment '专业',
	remark text 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_dq(
	id integer,
	dqName varchar(100)
);
--地区字段加注释
comment on column t_dq.id is '主键';
comment on column t_dq.dqName is '地区';
--地区表加注释
comment on table t_dq is '地区';

风险表创建语句如下：

create table t_fx(
	id integer,
	title varchar(100),
	content text,
	lb varchar(100),
	fileUrl varchar(100),
	djl varchar(100)
);
--风险字段加注释
comment on column t_fx.id is '主键';
comment on column t_fx.title is '标题';
comment on column t_fx.content is '内容';
comment on column t_fx.lb is '类别';
comment on column t_fx.fileUrl is '附件';
comment on column t_fx.djl is '点击量';
--风险表加注释
comment on table t_fx is '风险';

普通管理员表创建语句如下：

create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	headPic varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100)
);
--普通管理员字段加注释
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.headPic is '头像';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';

学生表创建语句如下：

create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	zy varchar(100),
	xx 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.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '';
comment on column t_student.zy is '专业';
comment on column t_student.xx is '学校';
--学生表加注释
comment on table t_student is '学生';

通知表创建语句如下：

create table t_tongzhi(
	id integer,
	title varchar(100),
	content text,
	insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知表加注释
comment on table t_tongzhi is '通知';

学校表创建语句如下：

create table t_xuexiao(
	id integer,
	xuexiaoName varchar(100),
	logo varchar(100),
	dqId int,
	lb varchar(100),
	wl varchar(100),
	nf varchar(100),
	zdf int,
	pjf int,
	fx varchar(100),
	zy varchar(100),
	remark text
);
--学校字段加注释
comment on column t_xuexiao.id is '主键';
comment on column t_xuexiao.xuexiaoName is '学校';
comment on column t_xuexiao.logo is 'logo';
comment on column t_xuexiao.dqId is '地区';
comment on column t_xuexiao.lb is '类别';
comment on column t_xuexiao.wl is '';
comment on column t_xuexiao.nf is '';
comment on column t_xuexiao.zdf is '最低分';
comment on column t_xuexiao.pjf is '平均分';
comment on column t_xuexiao.fx is '';
comment on column t_xuexiao.zy is '专业';
comment on column t_xuexiao.remark is '备注';
--学校表加注释
comment on table t_xuexiao is '学校';

oracle特有，对应序列如下：

create sequence s_t_dq;
create sequence s_t_fx;
create sequence s_t_ptadmin;
create sequence s_t_student;
create sequence s_t_tongzhi;
create sequence s_t_xuexiao;

高考志愿填报辅助系统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_dq(
	id int identity(1,1) primary key not null,--主键
	dqName varchar(100)--地区
);

风险表创建语句如下：

--风险表注释
create table t_fx(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content text,--内容
	lb varchar(100),--类别
	fileUrl varchar(100),--附件
	djl varchar(100)--点击量
);

普通管理员表创建语句如下：

--普通管理员表注释
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	ptadminName varchar(100),--姓名
	headPic varchar(100),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100)--
);

学生表创建语句如下：

--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	studentName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--
	zy varchar(100),--专业
	xx varchar(100)--学校
);

通知表创建语句如下：

--通知表注释
create table t_tongzhi(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content text,--内容
	insertDate datetime--日期
);

学校表创建语句如下：

--学校表注释
create table t_xuexiao(
	id int identity(1,1) primary key not null,--主键
	xuexiaoName varchar(100),--学校
	logo varchar(100),--logo
	dqId int,--地区
	lb varchar(100),--类别
	wl varchar(100),--
	nf varchar(100),--
	zdf int,--最低分
	pjf int,--平均分
	fx varchar(100),--
	zy varchar(100),--专业
	remark text--备注
);

高考志愿填报辅助系统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_dq")
public class Dq {
//主键
@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 dqName;
public String getDqName() {return dqName;}
public void setDqName(String dqName) {this.dqName = dqName;}
}

风险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_fx")
public class Fx {
//主键
@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 content;
//类别
private String lb;
//附件
private String fileUrl;
//点击量
private String djl;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getDjl() {return djl;}
public void setDjl(String djl) {this.djl = djl;}
}

普通管理员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 headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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;}
}

学生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 phone;
//年龄
private String age;
//
private String sex;
//专业
private String zy;
//学校
private String xx;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getXx() {return xx;}
public void setXx(String xx) {this.xx = xx;}
}

通知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_tongzhi")
public class Tongzhi {
//主键
@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 content;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
}

学校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_xuexiao")
public class Xuexiao {
//主键
@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 xuexiaoName;
//logo
private String logo;
//地区
private Long dqId;
//类别
private String lb;
//
private String wl;
//
private String nf;
//最低分
private Integer zdf;
//平均分
private Integer pjf;
//
private String fx;
//专业
private String zy;
//备注
private String remark;
public String getXuexiaoName() {return xuexiaoName;}
public void setXuexiaoName(String xuexiaoName) {this.xuexiaoName = xuexiaoName;}
public String getLogo() {return logo;}
public void setLogo(String logo) {this.logo = logo;}
public Long getDqId() {return dqId;}
public void setDqId(Long dqId) {this.dqId = dqId;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getWl() {return wl;}
public void setWl(String wl) {this.wl = wl;}
public String getNf() {return nf;}
public void setNf(String nf) {this.nf = nf;}
public Integer getZdf() {return zdf;}
public void setZdf(Integer zdf) {this.zdf = zdf;}
public Integer getPjf() {return pjf;}
public void setPjf(Integer pjf) {this.pjf = pjf;}
public String getFx() {return fx;}
public void setFx(String fx) {this.fx = fx;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
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 Dq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//地区
private String dqName;
public String getDqName() {return dqName;}
public void setDqName(String dqName) {this.dqName = dqName;}
}

风险javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//风险
public class Fx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//类别
private String lb;
//附件
private String fileUrl;
//点击量
private String djl;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getDjl() {return djl;}
public void setDjl(String djl) {this.djl = djl;}
}

普通管理员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 headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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;}
}

学生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 phone;
//年龄
private String age;
//
private String sex;
//专业
private String zy;
//学校
private String xx;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getXx() {return xx;}
public void setXx(String xx) {this.xx = xx;}
}

通知javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//通知
public class Tongzhi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
}

学校javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//学校
public class Xuexiao  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学校
private String xuexiaoName;
//logo
private String logo;
//地区
private Long dqId;
//类别
private String lb;
//
private String wl;
//
private String nf;
//最低分
private Integer zdf;
//平均分
private Integer pjf;
//
private String fx;
//专业
private String zy;
//备注
private String remark;
public String getXuexiaoName() {return xuexiaoName;}
public void setXuexiaoName(String xuexiaoName) {this.xuexiaoName = xuexiaoName;}
public String getLogo() {return logo;}
public void setLogo(String logo) {this.logo = logo;}
public Long getDqId() {return dqId;}
public void setDqId(Long dqId) {this.dqId = dqId;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getWl() {return wl;}
public void setWl(String wl) {this.wl = wl;}
public String getNf() {return nf;}
public void setNf(String nf) {this.nf = nf;}
public Integer getZdf() {return zdf;}
public void setZdf(Integer zdf) {this.zdf = zdf;}
public Integer getPjf() {return pjf;}
public void setPjf(Integer pjf) {this.pjf = pjf;}
public String getFx() {return fx;}
public void setFx(String fx) {this.fx = fx;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}