基于jsp重庆理工大学体育馆管理系统开发与设计

课题内容

随着信息技术的高速发展,体育场的运营管理趋向于信息化、网络化,会员制管理及体育器材、场地租赁作为运营管理的重要内容,将其信息化对体育场的管理具有重要作用。

本课题针对重庆理工大学体育场会员制与器材场地租赁管理信息化的需求,针对性设计重庆理工大学体育场运营管理系统。该系统包括系统管理模块、基本信息管理模块、会员管理模块、预定模块、租赁管理模块、收费模块、教练排课等。

 

课题任务要求

  • 系统管理模块完成用户管理、权限管理、密码管理、备份等;
  • 基本信息管理模块完成工作人员管理、各个场馆的信息管理、器材的信息管理、教练信息管理等,其中器材管理涉及到器材的添置与报损;
  • 会员管理模块完成会员的基本信息管理,年费信息管理,会员票价信息管理;
  • 预定模块实现对场地和器材的查询以及提前预定功能;
  • 租赁管理模块完成各个器材和场地的对外租赁,实现时间段管理、费用计算;
  • 收费模块实现对场地租赁和器材租赁的收费管理。
  • 教练排课模块实现教练、会员之间课程的安排等;
  • 用Java语言在MyEclipse平台上实现系统的各个功能模块信息的编辑、修改、删除、查询的操作。
  • 进行软件性能测试,对软件功能及界面细节进行完善。

主要参考文献(由指导教师选定)  

[1]刘永华 于春花 李晓利《Java网络编程技术》清华大学出版社

[2]Gary B.Shelly Thomas J.Cachman Harry J.Rosenblatt

   译者:史晟辉  王艳清  李芳  耿志强 《系统分析与设计教程》机械工业出版社

[3]谢星星《企业应用架构设计》中国水利水电出版社

[4]李彦  唐鑫 唐继强 崔英志《ASP.NET 3.5系统开发精髓》电子工业出版社

[5]陈家兴  陈风  朱国鸿《Java图形用户界面设计与实例》冶金工业出版社

[6]柴晟 刘莹 蔡锦城《SQL Server数据库应用教程》清华大学出版社 

基于jsp重庆理工大学体育馆管理系统开发与设计登录注册界面

基于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_cg(
	id int primary key auto_increment comment '主键',
	cgName varchar(100) comment '场馆名称',
	address varchar(100) comment '地址 ',
	fzr varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '场馆照片',
	typesId int comment '类型'
) comment '场馆';

场馆预定表创建语句如下:


create table t_cgyd(
	id int primary key auto_increment comment '主键',
	cgId int comment '场馆',
	showDate varchar(100) comment '日期',
	ampm varchar(100) comment '上午下午'
) comment '场馆预定';

会员表创建语句如下:


create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	customerName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像'
) comment '会员';

工作人员表创建语句如下:


create table t_employeename(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	employeeName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) 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_nf(
	id int primary key auto_increment comment '主键',
	customerId int comment '会员',
	fee int comment '金额',
	nd varchar(100) comment '年度',
	blrq datetime comment '办理日期',
	remark varchar(100) comment '备注'
) comment '年费';

排课表创建语句如下:


create table t_pk(
	id int primary key auto_increment comment '主键',
	customerId int comment '会员',
	teacherId int comment '教练',
	showDate datetime comment '课程日期',
	kcName varchar(100) comment '课程名称',
	address varchar(100) comment '地点',
	remark varchar(100) comment '内容'
) comment '排课';

器材信息表创建语句如下:


create table t_qc(
	id int primary key auto_increment comment '主键',
	qcName varchar(100) comment '器材名称',
	bh varchar(100) comment '器材编号',
	sl varchar(100) comment '数量',
	remark varchar(100) comment '备注'
) comment '器材信息';

器材表创建语句如下:


create table t_qcgl(
	id int primary key auto_increment comment '主键',
	qcId int comment '器材',
	types varchar(100) comment '类型',
	showDate datetime comment '操作日期',
	sl varchar(100) comment '数量',
	remark varchar(100) comment '备注'
) comment '器材';

教练表创建语句如下:


create table t_teacher(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	teacherName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像'
) comment '教练';

类型表创建语句如下:


create table t_types(
	id int primary key auto_increment comment '主键',
	typesName varchar(100) comment '类型名称'
) comment '类型';

预定表创建语句如下:


create table t_yd(
	id int primary key auto_increment comment '主键',
	customerId int comment '会员',
	types varchar(100) comment '类型',
	showDate datetime comment '预定日期',
	remark varchar(100) comment '内容',
	status varchar(100) comment '状态',
	orderNum varchar(100) comment ''
) comment '预定';

租赁收费表创建语句如下:


create table t_zlsf(
	id int primary key auto_increment comment '主键',
	customerId int comment '会员',
	types varchar(100) comment '类型',
	beginDate datetime comment '开始日期',
	endDate datetime comment '结束日期',
	remark varchar(100) comment '内容',
	fee int comment '租赁费',
	status varchar(100) comment '状态',
	ydId int 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_cg(
	id integer,
	cgName varchar(100),
	address varchar(100),
	fzr varchar(100),
	phone varchar(100),
	pic varchar(100),
	typesId int
);
--场馆字段加注释
comment on column t_cg.id is '主键';
comment on column t_cg.cgName is '场馆名称';
comment on column t_cg.address is '地址 ';
comment on column t_cg.fzr is '姓名';
comment on column t_cg.phone is '电话';
comment on column t_cg.pic is '场馆照片';
comment on column t_cg.typesId is '类型';
--场馆表加注释
comment on table t_cg is '场馆';

场馆预定表创建语句如下:


create table t_cgyd(
	id integer,
	cgId int,
	showDate varchar(100),
	ampm varchar(100)
);
--场馆预定字段加注释
comment on column t_cgyd.id is '主键';
comment on column t_cgyd.cgId is '场馆';
comment on column t_cgyd.showDate is '日期';
comment on column t_cgyd.ampm is '上午下午';
--场馆预定表加注释
comment on table t_cgyd is '场馆预定';

会员表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic varchar(100)
);
--会员字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码 ';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
comment on column t_customer.pic is '头像';
--会员表加注释
comment on table t_customer is '会员';

工作人员表创建语句如下:


create table t_employeename(
	id integer,
	username varchar(100),
	password varchar(100),
	employeeName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--工作人员字段加注释
comment on column t_employeename.id is '主键';
comment on column t_employeename.username is '账号';
comment on column t_employeename.password is '密码 ';
comment on column t_employeename.employeeName is '姓名';
comment on column t_employeename.age is '年龄';
comment on column t_employeename.sex is '性别';
comment on column t_employeename.phone is '电话';
--工作人员表加注释
comment on table t_employeename 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_nf(
	id integer,
	customerId int,
	fee int,
	nd varchar(100),
	blrq datetime,
	remark varchar(100)
);
--年费字段加注释
comment on column t_nf.id is '主键';
comment on column t_nf.customerId is '会员';
comment on column t_nf.fee is '金额';
comment on column t_nf.nd is '年度';
comment on column t_nf.blrq is '办理日期';
comment on column t_nf.remark is '备注';
--年费表加注释
comment on table t_nf is '年费';

排课表创建语句如下:


create table t_pk(
	id integer,
	customerId int,
	teacherId int,
	showDate datetime,
	kcName varchar(100),
	address varchar(100),
	remark varchar(100)
);
--排课字段加注释
comment on column t_pk.id is '主键';
comment on column t_pk.customerId is '会员';
comment on column t_pk.teacherId is '教练';
comment on column t_pk.showDate is '课程日期';
comment on column t_pk.kcName is '课程名称';
comment on column t_pk.address is '地点';
comment on column t_pk.remark is '内容';
--排课表加注释
comment on table t_pk is '排课';

器材信息表创建语句如下:


create table t_qc(
	id integer,
	qcName varchar(100),
	bh varchar(100),
	sl varchar(100),
	remark varchar(100)
);
--器材信息字段加注释
comment on column t_qc.id is '主键';
comment on column t_qc.qcName is '器材名称';
comment on column t_qc.bh is '器材编号';
comment on column t_qc.sl is '数量';
comment on column t_qc.remark is '备注';
--器材信息表加注释
comment on table t_qc is '器材信息';

器材表创建语句如下:


create table t_qcgl(
	id integer,
	qcId int,
	types varchar(100),
	showDate datetime,
	sl varchar(100),
	remark varchar(100)
);
--器材字段加注释
comment on column t_qcgl.id is '主键';
comment on column t_qcgl.qcId is '器材';
comment on column t_qcgl.types is '类型';
comment on column t_qcgl.showDate is '操作日期';
comment on column t_qcgl.sl is '数量';
comment on column t_qcgl.remark is '备注';
--器材表加注释
comment on table t_qcgl 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)
);
--教练字段加注释
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 table t_teacher is '教练';

类型表创建语句如下:


create table t_types(
	id integer,
	typesName varchar(100)
);
--类型字段加注释
comment on column t_types.id is '主键';
comment on column t_types.typesName is '类型名称';
--类型表加注释
comment on table t_types is '类型';

预定表创建语句如下:


create table t_yd(
	id integer,
	customerId int,
	types varchar(100),
	showDate datetime,
	remark varchar(100),
	status varchar(100),
	orderNum varchar(100)
);
--预定字段加注释
comment on column t_yd.id is '主键';
comment on column t_yd.customerId is '会员';
comment on column t_yd.types is '类型';
comment on column t_yd.showDate is '预定日期';
comment on column t_yd.remark is '内容';
comment on column t_yd.status is '状态';
comment on column t_yd.orderNum is '';
--预定表加注释
comment on table t_yd is '预定';

租赁收费表创建语句如下:


create table t_zlsf(
	id integer,
	customerId int,
	types varchar(100),
	beginDate datetime,
	endDate datetime,
	remark varchar(100),
	fee int,
	status varchar(100),
	ydId int
);
--租赁收费字段加注释
comment on column t_zlsf.id is '主键';
comment on column t_zlsf.customerId is '会员';
comment on column t_zlsf.types is '类型';
comment on column t_zlsf.beginDate is '开始日期';
comment on column t_zlsf.endDate is '结束日期';
comment on column t_zlsf.remark is '内容';
comment on column t_zlsf.fee is '租赁费';
comment on column t_zlsf.status is '状态';
comment on column t_zlsf.ydId is '';
--租赁收费表加注释
comment on table t_zlsf is '租赁收费';

oracle特有,对应序列如下:


create sequence s_t_cg;
create sequence s_t_cgyd;
create sequence s_t_customer;
create sequence s_t_employeename;
create sequence s_t_gg;
create sequence s_t_nf;
create sequence s_t_pk;
create sequence s_t_qc;
create sequence s_t_qcgl;
create sequence s_t_teacher;
create sequence s_t_types;
create sequence s_t_yd;
create sequence s_t_zlsf;

基于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_cg(
	id int identity(1,1) primary key not null,--主键
	cgName varchar(100),--场馆名称
	address varchar(100),--地址 
	fzr varchar(100),--姓名
	phone varchar(100),--电话
	pic varchar(100),--场馆照片
	typesId int--类型
);

场馆预定表创建语句如下:


--场馆预定表注释
create table t_cgyd(
	id int identity(1,1) primary key not null,--主键
	cgId int,--场馆
	showDate varchar(100),--日期
	ampm varchar(100)--上午下午
);

会员表创建语句如下:


--会员表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	customerName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100)--头像
);

工作人员表创建语句如下:


--工作人员表注释
create table t_employeename(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	employeeName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

公告表创建语句如下:


--公告表注释
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_nf(
	id int identity(1,1) primary key not null,--主键
	customerId int,--会员
	fee int,--金额
	nd varchar(100),--年度
	blrq datetime,--办理日期
	remark varchar(100)--备注
);

排课表创建语句如下:


--排课表注释
create table t_pk(
	id int identity(1,1) primary key not null,--主键
	customerId int,--会员
	teacherId int,--教练
	showDate datetime,--课程日期
	kcName varchar(100),--课程名称
	address varchar(100),--地点
	remark varchar(100)--内容
);

器材信息表创建语句如下:


--器材信息表注释
create table t_qc(
	id int identity(1,1) primary key not null,--主键
	qcName varchar(100),--器材名称
	bh varchar(100),--器材编号
	sl varchar(100),--数量
	remark varchar(100)--备注
);

器材表创建语句如下:


--器材表注释
create table t_qcgl(
	id int identity(1,1) primary key not null,--主键
	qcId int,--器材
	types varchar(100),--类型
	showDate datetime,--操作日期
	sl varchar(100),--数量
	remark varchar(100)--备注
);

教练表创建语句如下:


--教练表注释
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)--头像
);

类型表创建语句如下:


--类型表注释
create table t_types(
	id int identity(1,1) primary key not null,--主键
	typesName varchar(100)--类型名称
);

预定表创建语句如下:


--预定表注释
create table t_yd(
	id int identity(1,1) primary key not null,--主键
	customerId int,--会员
	types varchar(100),--类型
	showDate datetime,--预定日期
	remark varchar(100),--内容
	status varchar(100),--状态
	orderNum varchar(100)--
);

租赁收费表创建语句如下:


--租赁收费表注释
create table t_zlsf(
	id int identity(1,1) primary key not null,--主键
	customerId int,--会员
	types varchar(100),--类型
	beginDate datetime,--开始日期
	endDate datetime,--结束日期
	remark varchar(100),--内容
	fee int,--租赁费
	status varchar(100),--状态
	ydId int--
);

基于jsp重庆理工大学体育馆管理系统开发与设计登录后主页

基于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_cg")
public class Cg {
//主键
@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 cgName;
//地址 
private String address;
//姓名
private String fzr;
//电话
private String phone;
//场馆照片
private String pic;
//类型
private Integer typesId;
public String getCgName() {return cgName;}
public void setCgName(String cgName) {this.cgName = cgName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
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 getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
}

场馆预定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_cgyd")
public class Cgyd {
//主键
@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 cgId;
//日期
private String showDate;
//上午下午
private String ampm;
public Integer getCgId() {return cgId;}
public void setCgId(Integer cgId) {this.cgId = cgId;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getAmpm() {return ampm;}
public void setAmpm(String ampm) {this.ampm = ampm;}
}

会员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_customer")
public class Customer {
//主键
@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 customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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;}
}

工作人员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_employeename")
public class Employeename {
//主键
@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 employeeName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
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;}
}

公告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_nf")
public class Nf {
//主键
@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 customerId;
//金额
private Integer fee;
//年度
private String nd;
//办理日期
private Date blrq;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getNd() {return nd;}
public void setNd(String nd) {this.nd = nd;}
public Date getBlrq() {return blrq;}
public void setBlrq(Date blrq) {this.blrq = blrq;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

排课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_pk")
public class Pk {
//主键
@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 customerId;
//教练
private Integer teacherId;
//课程日期
private Date showDate;
//课程名称
private String kcName;
//地点
private String address;
//内容
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

器材信息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_qc")
public class Qc {
//主键
@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 qcName;
//器材编号
private String bh;
//数量
private String sl;
//备注
private String remark;
public String getQcName() {return qcName;}
public void setQcName(String qcName) {this.qcName = qcName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

器材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_qcgl")
public class Qcgl {
//主键
@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 qcId;
//类型
private String types;
//操作日期
private Date showDate;
//数量
private String sl;
//备注
private String remark;
public Integer getQcId() {return qcId;}
public void setQcId(Integer qcId) {this.qcId = qcId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

教练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;
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;}
}

类型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_types")
public class Types {
//主键
@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 typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}

预定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_yd")
public class Yd {
//主键
@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 customerId;
//类型
private String types;
//预定日期
private Date showDate;
//内容
private String remark;
//状态
private String status;
//
private String orderNum;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
}

租赁收费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_zlsf")
public class Zlsf {
//主键
@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 customerId;
//类型
private String types;
//开始日期
private Date beginDate;
//结束日期
private Date endDate;
//内容
private String remark;
//租赁费
private Integer fee;
//状态
private String status;
//
private Integer ydId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getYdId() {return ydId;}
public void setYdId(Integer ydId) {this.ydId = ydId;}
}

基于jsp重庆理工大学体育馆管理系统开发与设计spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

场馆javaBean创建语句如下:


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

//场馆
public class Cg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//场馆名称
private String cgName;
//地址 
private String address;
//姓名
private String fzr;
//电话
private String phone;
//场馆照片
private String pic;
//类型
private Integer typesId;
public String getCgName() {return cgName;}
public void setCgName(String cgName) {this.cgName = cgName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
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 getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
}

场馆预定javaBean创建语句如下:


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

//场馆预定
public class Cgyd  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//场馆
private Integer cgId;
//日期
private String showDate;
//上午下午
private String ampm;
public Integer getCgId() {return cgId;}
public void setCgId(Integer cgId) {this.cgId = cgId;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getAmpm() {return ampm;}
public void setAmpm(String ampm) {this.ampm = ampm;}
}

会员javaBean创建语句如下:


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

//会员
public class Customer  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 customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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;}
}

工作人员javaBean创建语句如下:


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

//工作人员
public class Employeename  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 employeeName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
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;}
}

公告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 Nf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//会员
private Integer customerId;
//金额
private Integer fee;
//年度
private String nd;
//办理日期
private Date blrq;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getNd() {return nd;}
public void setNd(String nd) {this.nd = nd;}
public Date getBlrq() {return blrq;}
public void setBlrq(Date blrq) {this.blrq = blrq;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

排课javaBean创建语句如下:


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

//排课
public class Pk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//会员
private Integer customerId;
//教练
private Integer teacherId;
//课程日期
private Date showDate;
//课程名称
private String kcName;
//地点
private String address;
//内容
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

器材信息javaBean创建语句如下:


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

//器材信息
public class Qc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//器材名称
private String qcName;
//器材编号
private String bh;
//数量
private String sl;
//备注
private String remark;
public String getQcName() {return qcName;}
public void setQcName(String qcName) {this.qcName = qcName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

器材javaBean创建语句如下:


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

//器材
public class Qcgl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//器材
private Integer qcId;
//类型
private String types;
//操作日期
private Date showDate;
//数量
private String sl;
//备注
private String remark;
public Integer getQcId() {return qcId;}
public void setQcId(Integer qcId) {this.qcId = qcId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

教练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;
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;}
}

类型javaBean创建语句如下:


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

//类型
public class Types  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型名称
private String typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}

预定javaBean创建语句如下:


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

//预定
public class Yd  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//会员
private Integer customerId;
//类型
private String types;
//预定日期
private Date showDate;
//内容
private String remark;
//状态
private String status;
//
private String orderNum;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
}

租赁收费javaBean创建语句如下:


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

//租赁收费
public class Zlsf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//会员
private Integer customerId;
//类型
private String types;
//开始日期
private Date beginDate;
//结束日期
private Date endDate;
//内容
private String remark;
//租赁费
private Integer fee;
//状态
private String status;
//
private Integer ydId;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getYdId() {return ydId;}
public void setYdId(Integer ydId) {this.ydId = ydId;}
}

源代码下载点这里

评论