更多成品,定做java毕业设计,请咨询管理员qq:2812491287

校友录管理系统

校友录管理系统登录注册界面

校友录管理系统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 '班级',
	zy varchar(100) comment '专业',
	bzr varchar(100) comment '班主任'
) comment '班级';

班级公告表创建语句如下:


create table t_bjgg(
	id int primary key auto_increment comment '主键',
	bjId int comment '班级',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	cotnent varchar(100) comment '内容',
	showDate datetime comment '日期'
) comment '班级公告';

校园活动表创建语句如下:


create table t_bjhd(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	cotnent varchar(100) comment '内容',
	showDate datetime comment '日期'
) comment '校园活动';

班级照片表创建语句如下:


create table t_bjzp(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '照片',
	bjId int comment '班级'
) comment '班级照片';

讨论平台表创建语句如下:


create table t_jiaoliu(
	id int primary key auto_increment comment '主键',
	fbr varchar(100) comment '发布人',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容'
) comment '讨论平台';

讨论平台记录表创建语句如下:


create table t_jiaoliulist(
	id int primary key auto_increment comment '主键',
	jiaoliuId int comment '交流平台',
	hdrName varchar(100) comment '回答人',
	insertDate datetime comment '日期',
	content 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 '姓名',
	headPic varchar(100) comment '头像',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	xh varchar(100) comment '学号',
	bjId int 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),
	zy varchar(100),
	bzr varchar(100)
);
--班级字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.bjName is '班级';
comment on column t_bj.zy is '专业';
comment on column t_bj.bzr is '班主任';
--班级表加注释
comment on table t_bj is '班级';

班级公告表创建语句如下:


create table t_bjgg(
	id integer,
	bjId int,
	title varchar(100),
	pic varchar(100),
	cotnent varchar(100),
	showDate datetime
);
--班级公告字段加注释
comment on column t_bjgg.id is '主键';
comment on column t_bjgg.bjId is '班级';
comment on column t_bjgg.title is '标题';
comment on column t_bjgg.pic is '图片';
comment on column t_bjgg.cotnent is '内容';
comment on column t_bjgg.showDate is '日期';
--班级公告表加注释
comment on table t_bjgg is '班级公告';

校园活动表创建语句如下:


create table t_bjhd(
	id integer,
	title varchar(100),
	pic varchar(100),
	cotnent varchar(100),
	showDate datetime
);
--校园活动字段加注释
comment on column t_bjhd.id is '主键';
comment on column t_bjhd.title is '标题';
comment on column t_bjhd.pic is '图片';
comment on column t_bjhd.cotnent is '内容';
comment on column t_bjhd.showDate is '日期';
--校园活动表加注释
comment on table t_bjhd is '校园活动';

班级照片表创建语句如下:


create table t_bjzp(
	id integer,
	title varchar(100),
	pic varchar(100),
	bjId int
);
--班级照片字段加注释
comment on column t_bjzp.id is '主键';
comment on column t_bjzp.title is '标题';
comment on column t_bjzp.pic is '照片';
comment on column t_bjzp.bjId is '班级';
--班级照片表加注释
comment on table t_bjzp is '班级照片';

讨论平台表创建语句如下:


create table t_jiaoliu(
	id integer,
	fbr varchar(100),
	title varchar(100),
	pic varchar(100),
	content varchar(100)
);
--讨论平台字段加注释
comment on column t_jiaoliu.id is '主键';
comment on column t_jiaoliu.fbr is '发布人';
comment on column t_jiaoliu.title is '标题';
comment on column t_jiaoliu.pic is '图片';
comment on column t_jiaoliu.content is '内容';
--讨论平台表加注释
comment on table t_jiaoliu is '讨论平台';

讨论平台记录表创建语句如下:


create table t_jiaoliulist(
	id integer,
	jiaoliuId int,
	hdrName varchar(100),
	insertDate datetime,
	content varchar(100)
);
--讨论平台记录字段加注释
comment on column t_jiaoliulist.id is '主键';
comment on column t_jiaoliulist.jiaoliuId is '交流平台';
comment on column t_jiaoliulist.hdrName is '回答人';
comment on column t_jiaoliulist.insertDate is '日期';
comment on column t_jiaoliulist.content is '内容';
--讨论平台记录表加注释
comment on table t_jiaoliulist is '讨论平台记录';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	headPic varchar(100),
	age varchar(100),
	sex varchar(100),
	xh varchar(100),
	bjId 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.headPic is '头像';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.xh is '学号';
comment on column t_student.bjId is '班级';
--学生表加注释
comment on table t_student is '学生';

oracle特有,对应序列如下:


create sequence s_t_bj;
create sequence s_t_bjgg;
create sequence s_t_bjhd;
create sequence s_t_bjzp;
create sequence s_t_jiaoliu;
create sequence s_t_jiaoliulist;
create sequence s_t_student;

校友录管理系统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),--班级
	zy varchar(100),--专业
	bzr varchar(100)--班主任
);

班级公告表创建语句如下:


--班级公告表注释
create table t_bjgg(
	id int identity(1,1) primary key not null,--主键
	bjId int,--班级
	title varchar(100),--标题
	pic varchar(100),--图片
	cotnent varchar(100),--内容
	showDate datetime--日期
);

校园活动表创建语句如下:


--校园活动表注释
create table t_bjhd(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	cotnent varchar(100),--内容
	showDate datetime--日期
);

班级照片表创建语句如下:


--班级照片表注释
create table t_bjzp(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--照片
	bjId int--班级
);

讨论平台表创建语句如下:


--讨论平台表注释
create table t_jiaoliu(
	id int identity(1,1) primary key not null,--主键
	fbr varchar(100),--发布人
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100)--内容
);

讨论平台记录表创建语句如下:


--讨论平台记录表注释
create table t_jiaoliulist(
	id int identity(1,1) primary key not null,--主键
	jiaoliuId int,--交流平台
	hdrName varchar(100),--回答人
	insertDate datetime,--日期
	content varchar(100)--内容
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	studentName varchar(100),--姓名
	headPic varchar(100),--头像
	age varchar(100),--年龄
	sex varchar(100),--性别
	xh varchar(100),--学号
	bjId int--班级
);

校友录管理系统登录后主页

校友录管理系统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;
//专业
private String zy;
//班主任
private String bzr;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
}

班级公告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_bjgg")
public class Bjgg {
//主键
@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 bjId;
//标题
private String title;
//图片
private String pic;
//内容
private String cotnent;
//日期
private Date showDate;
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
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 getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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_bjhd")
public class Bjhd {
//主键
@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 cotnent;
//日期
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 getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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_bjzp")
public class Bjzp {
//主键
@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 Integer bjId;
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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}

讨论平台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_jiaoliu")
public class Jiaoliu {
//主键
@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 fbr;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
public String getFbr() {return fbr;}
public void setFbr(String fbr) {this.fbr = fbr;}
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;}
}

讨论平台记录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_jiaoliulist")
public class Jiaoliulist {
//主键
@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 jiaoliuId;
//回答人
private String hdrName;
//日期
private Date insertDate;
//内容
private String content;
public Integer getJiaoliuId() {return jiaoliuId;}
public void setJiaoliuId(Integer jiaoliuId) {this.jiaoliuId = jiaoliuId;}
public String getHdrName() {return hdrName;}
public void setHdrName(String hdrName) {this.hdrName = hdrName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

学生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 headPic;
//年龄
private String age;
//性别
private String sex;
//学号
private String xh;
//班级
private Integer bjId;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}

校友录管理系统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;
//专业
private String zy;
//班主任
private String bzr;
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getBzr() {return bzr;}
public void setBzr(String bzr) {this.bzr = bzr;}
}

班级公告javaBean创建语句如下:


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

//班级公告
public class Bjgg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private Integer bjId;
//标题
private String title;
//图片
private String pic;
//内容
private String cotnent;
//日期
private Date showDate;
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
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 getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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 Bjhd  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 cotnent;
//日期
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 getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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 Bjzp  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 Integer bjId;
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 Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}

讨论平台javaBean创建语句如下:


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

//讨论平台
public class Jiaoliu  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发布人
private String fbr;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
public String getFbr() {return fbr;}
public void setFbr(String fbr) {this.fbr = fbr;}
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;}
}

讨论平台记录javaBean创建语句如下:


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

//讨论平台记录
public class Jiaoliulist  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//交流平台
private Integer jiaoliuId;
//回答人
private String hdrName;
//日期
private Date insertDate;
//内容
private String content;
public Integer getJiaoliuId() {return jiaoliuId;}
public void setJiaoliuId(Integer jiaoliuId) {this.jiaoliuId = jiaoliuId;}
public String getHdrName() {return hdrName;}
public void setHdrName(String hdrName) {this.hdrName = hdrName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

学生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 headPic;
//年龄
private String age;
//性别
private String sex;
//学号
private String xh;
//班级
private Integer bjId;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public Integer getBjId() {return bjId;}
public void setBjId(Integer bjId) {this.bjId = bjId;}
}

评论