基于微信小程序的毕业设计题目管理系统

学生可以通过毕业设计题目管理系统查看可选题目信息(查看的信息包括题目详细信息,发布时间,也包括发布题目的老师姓名、联系方式、邮箱等)和结果(待老师同意和已同意两种状态),能够在线选题或修改选题(选题或修改选题需要老师确认方可完成),能够根据毕业设计的题目向老师发起提问留言;

 注:学生注册时需要有姓名,学号,专业,联系方式,邮箱等(注册时自己设置密码),登录时使用学号加密码和专业,学生只能看见其专业的题目,不适用其专业的题目看不见

 

2.老师可以通过毕业设计题目管理系统上传毕业设计题目(包括发布人,时间,适用专业,课题类型(下拉框选择纵向课题,横向课题,自拟课题三选一)题目的详细信息)到系统中以供院部审核(上传时系统有查重功能,已有的题目不能重复上传,弹出提示框该题目已存在),审核通过的题目展示在系统中供学生选择,能够对审核未通过的题目进行修改再提交,能够查看学生选题信息和结果,能够查看学生的信息(姓名,学号,专业,班级,联系方式,邮箱等)能够同意或否定学生的选题,能够对学生发起的留言进行回复;

 

3.管理员能够通过毕业设计题目管理系统对老师、学生信息进行管理,能够对毕业设计的题目进行审核管理,给予通过或不通过(不通过的需要反馈原因),能够对毕业设计的题目进行增删改查等调整;

 

4.系统展示给学生的选题信息分为已选和未选两种状态,尚未选题的学生只能选择未选的题目且只能选择一个,已选择题目的学生则不可重复选,老师否定选题后方可重新选择。

基于微信小程序的毕业设计题目管理系统登录注册界面

基于微信小程序的毕业设计题目管理系统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_contact(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	phone varchar(100) comment '联系方式',
	content varchar(100) comment '内容',
	insertDate datetime comment '日期'
) comment '建议';

客户表创建语句如下:


create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	name varchar(100) comment '姓名',
	sex varchar(100) comment '性别',
	address varchar(100) comment '地址',
	mobile varchar(100) comment '手机',
	zyId 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_message(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	messageContent varchar(100) comment '内容',
	types int comment '',
	insertDate datetime comment '时间'
) comment '信息交流';

订单表创建语句如下:


create table t_order(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	productDetail varchar(100) comment '订单详细',
	allPrice varchar(100) comment '订单总价格',
	status varchar(100) comment '状态',
	orderNum varchar(100) comment '',
	pl varchar(100) comment '',
	insertDate datetime comment ''
) comment '订单';

产品表创建语句如下:


create table t_product(
	id int primary key auto_increment comment '主键',
	productName varchar(100) comment '产品名称',
	productPic varchar(100) comment '图片',
	price varchar(100) comment '价格',
	content 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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '学院领导';

购物车表创建语句如下:


create table t_shopcar(
	id int primary key auto_increment comment '主键',
	productId int comment '产品',
	num int comment '数量',
	customerId int comment ''
) comment '购物车';

老师表创建语句如下:


create table t_teacher(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	teacherName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	email varchar(100) comment '邮箱'
) comment '老师';

题目表创建语句如下:


create table t_tm(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	tmName varchar(100) comment '题目名称',
	tmbh varchar(100) comment '题目编号',
	fileUrl varchar(100) comment '文件',
	content varchar(100) comment '详细说明',
	zyId int comment '专业',
	types varchar(100) comment '课题类型',
	insertDate datetime comment '时间',
	status varchar(100) comment '状态',
	btg varchar(100) comment '不通过理由'
) comment '题目';

题目留言表创建语句如下:


create table t_tmly(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	tmId int comment '题目',
	customerId int comment '学生',
	content varchar(100) comment '内容',
	insertDate datetime comment '留言日期',
	back varchar(100) comment '回复'
) comment '题目留言';

题目申请表创建语句如下:


create table t_tmsq(
	id int primary key auto_increment comment '主键',
	teacherId int comment '老师',
	tmId int comment '题目',
	customerId int comment '学生',
	sqsm varchar(100) comment '申请说明',
	status varchar(100) comment '状态',
	content varchar(100) comment '不同意说明'
) comment '题目申请';

普通员工表创建语句如下:


create table t_user(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	name varchar(100) comment '姓名',
	gh varchar(100) comment '工号',
	mobile varchar(100) comment '手机'
) comment '普通员工';

专业表创建语句如下:


create table t_zy(
	id int primary key auto_increment comment '主键',
	zyName varchar(100) comment '专业'
) comment '专业';

基于微信小程序的毕业设计题目管理系统oracle数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

建议表创建语句如下:


create table t_contact(
	id integer,
	customerId int,
	phone varchar(100),
	content varchar(100),
	insertDate datetime
);
--建议字段加注释
comment on column t_contact.id is '主键';
comment on column t_contact.customerId is '用户';
comment on column t_contact.phone is '联系方式';
comment on column t_contact.content is '内容';
comment on column t_contact.insertDate is '日期';
--建议表加注释
comment on table t_contact is '建议';

客户表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	name varchar(100),
	sex varchar(100),
	address varchar(100),
	mobile varchar(100),
	zyId 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.name is '姓名';
comment on column t_customer.sex is '性别';
comment on column t_customer.address is '地址';
comment on column t_customer.mobile is '手机';
comment on column t_customer.zyId is '';
--客户表加注释
comment on table t_customer 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_message(
	id integer,
	customerId int,
	messageContent varchar(100),
	types int,
	insertDate datetime
);
--信息交流字段加注释
comment on column t_message.id is '主键';
comment on column t_message.customerId is '用户';
comment on column t_message.messageContent is '内容';
comment on column t_message.types is '';
comment on column t_message.insertDate is '时间';
--信息交流表加注释
comment on table t_message is '信息交流';

订单表创建语句如下:


create table t_order(
	id integer,
	customerId int,
	productDetail varchar(100),
	allPrice varchar(100),
	status varchar(100),
	orderNum varchar(100),
	pl varchar(100),
	insertDate datetime
);
--订单字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '用户';
comment on column t_order.productDetail is '订单详细';
comment on column t_order.allPrice is '订单总价格';
comment on column t_order.status is '状态';
comment on column t_order.orderNum is '';
comment on column t_order.pl is '';
comment on column t_order.insertDate is '';
--订单表加注释
comment on table t_order is '订单';

产品表创建语句如下:


create table t_product(
	id integer,
	productName varchar(100),
	productPic varchar(100),
	price varchar(100),
	content varchar(100)
);
--产品字段加注释
comment on column t_product.id is '主键';
comment on column t_product.productName is '产品名称';
comment on column t_product.productPic is '图片';
comment on column t_product.price is '价格';
comment on column t_product.content is '内容';
--产品表加注释
comment on table t_product is '产品';

学院领导表创建语句如下:


create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100)
);
--学院领导字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码 ';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
comment on column t_ptadmin.phone is '电话';
--学院领导表加注释
comment on table t_ptadmin is '学院领导';

购物车表创建语句如下:


create table t_shopcar(
	id integer,
	productId int,
	num int,
	customerId int
);
--购物车字段加注释
comment on column t_shopcar.id is '主键';
comment on column t_shopcar.productId is '产品';
comment on column t_shopcar.num is '数量';
comment on column t_shopcar.customerId is '';
--购物车表加注释
comment on table t_shopcar 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),
	email 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.email is '邮箱';
--老师表加注释
comment on table t_teacher is '老师';

题目表创建语句如下:


create table t_tm(
	id integer,
	teacherId int,
	tmName varchar(100),
	tmbh varchar(100),
	fileUrl varchar(100),
	content varchar(100),
	zyId int,
	types varchar(100),
	insertDate datetime,
	status varchar(100),
	btg varchar(100)
);
--题目字段加注释
comment on column t_tm.id is '主键';
comment on column t_tm.teacherId is '老师';
comment on column t_tm.tmName is '题目名称';
comment on column t_tm.tmbh is '题目编号';
comment on column t_tm.fileUrl is '文件';
comment on column t_tm.content is '详细说明';
comment on column t_tm.zyId is '专业';
comment on column t_tm.types is '课题类型';
comment on column t_tm.insertDate is '时间';
comment on column t_tm.status is '状态';
comment on column t_tm.btg is '不通过理由';
--题目表加注释
comment on table t_tm is '题目';

题目留言表创建语句如下:


create table t_tmly(
	id integer,
	teacherId int,
	tmId int,
	customerId int,
	content varchar(100),
	insertDate datetime,
	back varchar(100)
);
--题目留言字段加注释
comment on column t_tmly.id is '主键';
comment on column t_tmly.teacherId is '老师';
comment on column t_tmly.tmId is '题目';
comment on column t_tmly.customerId is '学生';
comment on column t_tmly.content is '内容';
comment on column t_tmly.insertDate is '留言日期';
comment on column t_tmly.back is '回复';
--题目留言表加注释
comment on table t_tmly is '题目留言';

题目申请表创建语句如下:


create table t_tmsq(
	id integer,
	teacherId int,
	tmId int,
	customerId int,
	sqsm varchar(100),
	status varchar(100),
	content varchar(100)
);
--题目申请字段加注释
comment on column t_tmsq.id is '主键';
comment on column t_tmsq.teacherId is '老师';
comment on column t_tmsq.tmId is '题目';
comment on column t_tmsq.customerId is '学生';
comment on column t_tmsq.sqsm is '申请说明';
comment on column t_tmsq.status is '状态';
comment on column t_tmsq.content is '不同意说明';
--题目申请表加注释
comment on table t_tmsq is '题目申请';

普通员工表创建语句如下:


create table t_user(
	id integer,
	username varchar(100),
	password varchar(100),
	name varchar(100),
	gh varchar(100),
	mobile varchar(100)
);
--普通员工字段加注释
comment on column t_user.id is '主键';
comment on column t_user.username is '账号';
comment on column t_user.password is '密码';
comment on column t_user.name is '姓名';
comment on column t_user.gh is '工号';
comment on column t_user.mobile is '手机';
--普通员工表加注释
comment on table t_user is '普通员工';

专业表创建语句如下:


create table t_zy(
	id integer,
	zyName varchar(100)
);
--专业字段加注释
comment on column t_zy.id is '主键';
comment on column t_zy.zyName is '专业';
--专业表加注释
comment on table t_zy is '专业';

oracle特有,对应序列如下:


create sequence s_t_contact;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_message;
create sequence s_t_order;
create sequence s_t_product;
create sequence s_t_ptadmin;
create sequence s_t_shopcar;
create sequence s_t_teacher;
create sequence s_t_tm;
create sequence s_t_tmly;
create sequence s_t_tmsq;
create sequence s_t_user;
create sequence s_t_zy;

基于微信小程序的毕业设计题目管理系统sqlserver数据库版本源码:

超级管理员表创建语句如下:


--超级管理员
create table t_admin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--超级管理员账号
	password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');

建议表创建语句如下:


--建议表注释
create table t_contact(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	phone varchar(100),--联系方式
	content varchar(100),--内容
	insertDate datetime--日期
);

客户表创建语句如下:


--客户表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	name varchar(100),--姓名
	sex varchar(100),--性别
	address varchar(100),--地址
	mobile varchar(100),--手机
	zyId 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_message(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	messageContent varchar(100),--内容
	types int,--
	insertDate datetime--时间
);

订单表创建语句如下:


--订单表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	productDetail varchar(100),--订单详细
	allPrice varchar(100),--订单总价格
	status varchar(100),--状态
	orderNum varchar(100),--
	pl varchar(100),--
	insertDate datetime--
);

产品表创建语句如下:


--产品表注释
create table t_product(
	id int identity(1,1) primary key not null,--主键
	productName varchar(100),--产品名称
	productPic varchar(100),--图片
	price varchar(100),--价格
	content varchar(100)--内容
);

学院领导表创建语句如下:


--学院领导表注释
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	ptadminName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100)--电话
);

购物车表创建语句如下:


--购物车表注释
create table t_shopcar(
	id int identity(1,1) primary key not null,--主键
	productId int,--产品
	num int,--数量
	customerId int--
);

老师表创建语句如下:


--老师表注释
create table t_teacher(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码 
	teacherName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	email varchar(100)--邮箱
);

题目表创建语句如下:


--题目表注释
create table t_tm(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	tmName varchar(100),--题目名称
	tmbh varchar(100),--题目编号
	fileUrl varchar(100),--文件
	content varchar(100),--详细说明
	zyId int,--专业
	types varchar(100),--课题类型
	insertDate datetime,--时间
	status varchar(100),--状态
	btg varchar(100)--不通过理由
);

题目留言表创建语句如下:


--题目留言表注释
create table t_tmly(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	tmId int,--题目
	customerId int,--学生
	content varchar(100),--内容
	insertDate datetime,--留言日期
	back varchar(100)--回复
);

题目申请表创建语句如下:


--题目申请表注释
create table t_tmsq(
	id int identity(1,1) primary key not null,--主键
	teacherId int,--老师
	tmId int,--题目
	customerId int,--学生
	sqsm varchar(100),--申请说明
	status varchar(100),--状态
	content varchar(100)--不同意说明
);

普通员工表创建语句如下:


--普通员工表注释
create table t_user(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	name varchar(100),--姓名
	gh varchar(100),--工号
	mobile varchar(100)--手机
);

专业表创建语句如下:


--专业表注释
create table t_zy(
	id int identity(1,1) primary key not null,--主键
	zyName varchar(100)--专业
);

基于微信小程序的毕业设计题目管理系统登录后主页

基于微信小程序的毕业设计题目管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计:

建议javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//建议
@Table(name = "t_contact")
public class Contact {
//主键
@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 phone;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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_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 name;
//性别
private String sex;
//地址
private String address;
//手机
private String mobile;
//
private String 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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
public String getZyId() {return zyId;}
public void setZyId(String 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_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_message")
public class Message {
//主键
@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 messageContent;
//
private Integer types;
//时间
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getMessageContent() {return messageContent;}
public void setMessageContent(String messageContent) {this.messageContent = messageContent;}
public Integer getTypes() {return types;}
public void setTypes(Integer types) {this.types = types;}
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_order")
public class Order {
//主键
@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 productDetail;
//订单总价格
private String allPrice;
//状态
private String status;
//
private String orderNum;
//
private String pl;
//
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getProductDetail() {return productDetail;}
public void setProductDetail(String productDetail) {this.productDetail = productDetail;}
public String getAllPrice() {return allPrice;}
public void setAllPrice(String allPrice) {this.allPrice = allPrice;}
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;}
public String getPl() {return pl;}
public void setPl(String pl) {this.pl = pl;}
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_product")
public class Product {
//主键
@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 productName;
//图片
private String productPic;
//价格
private String price;
//内容
private String content;
public String getProductName() {return productName;}
public void setProductName(String productName) {this.productName = productName;}
public String getProductPic() {return productPic;}
public void setProductPic(String productPic) {this.productPic = productPic;}
public String getPrice() {return price;}
public void setPrice(String price) {this.price = price;}
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_ptadmin")
public class Ptadmin {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码 
private String password;
//姓名
private String ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

购物车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_shopcar")
public class Shopcar {
//主键
@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 productId;
//数量
private Integer num;
//
private Integer customerId;
public Integer getProductId() {return productId;}
public void setProductId(Integer productId) {this.productId = productId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}

老师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 email;
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 getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
}

题目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_tm")
public class Tm {
//主键
@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 teacherId;
//题目名称
private String tmName;
//题目编号
private String tmbh;
//文件
private String fileUrl;
//详细说明
private String content;
//专业
private Integer zyId;
//课题类型
private String types;
//时间
private Date insertDate;
//状态
private String status;
//不通过理由
private String btg;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getTmName() {return tmName;}
public void setTmName(String tmName) {this.tmName = tmName;}
public String getTmbh() {return tmbh;}
public void setTmbh(String tmbh) {this.tmbh = tmbh;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getZyId() {return zyId;}
public void setZyId(Integer zyId) {this.zyId = zyId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 getBtg() {return btg;}
public void setBtg(String btg) {this.btg = btg;}
}

题目留言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_tmly")
public class Tmly {
//主键
@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 teacherId;
//题目
private Integer tmId;
//学生
private Integer customerId;
//内容
private String content;
//留言日期
private Date insertDate;
//回复
private String back;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Integer getTmId() {return tmId;}
public void setTmId(Integer tmId) {this.tmId = tmId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 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_tmsq")
public class Tmsq {
//主键
@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 teacherId;
//题目
private Integer tmId;
//学生
private Integer customerId;
//申请说明
private String sqsm;
//状态
private String status;
//不同意说明
private String content;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Integer getTmId() {return tmId;}
public void setTmId(Integer tmId) {this.tmId = tmId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSqsm() {return sqsm;}
public void setSqsm(String sqsm) {this.sqsm = sqsm;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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_user")
public class User {
//主键
@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 name;
//工号
private String gh;
//手机
private String mobile;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
}

专业javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//专业
@Table(name = "t_zy")
public class Zy {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//专业
private String zyName;
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
}

基于微信小程序的毕业设计题目管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

建议javaBean创建语句如下:


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

//建议
public class Contact  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//联系方式
private String phone;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 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 name;
//性别
private String sex;
//地址
private String address;
//手机
private String mobile;
//
private String 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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
public String getZyId() {return zyId;}
public void setZyId(String zyId) {this.zyId = zyId;}
}

公告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 Message  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//内容
private String messageContent;
//
private Integer types;
//时间
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getMessageContent() {return messageContent;}
public void setMessageContent(String messageContent) {this.messageContent = messageContent;}
public Integer getTypes() {return types;}
public void setTypes(Integer types) {this.types = types;}
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 Order  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//订单详细
private String productDetail;
//订单总价格
private String allPrice;
//状态
private String status;
//
private String orderNum;
//
private String pl;
//
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getProductDetail() {return productDetail;}
public void setProductDetail(String productDetail) {this.productDetail = productDetail;}
public String getAllPrice() {return allPrice;}
public void setAllPrice(String allPrice) {this.allPrice = allPrice;}
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;}
public String getPl() {return pl;}
public void setPl(String pl) {this.pl = pl;}
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 Product  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品名称
private String productName;
//图片
private String productPic;
//价格
private String price;
//内容
private String content;
public String getProductName() {return productName;}
public void setProductName(String productName) {this.productName = productName;}
public String getProductPic() {return productPic;}
public void setProductPic(String productPic) {this.productPic = productPic;}
public String getPrice() {return price;}
public void setPrice(String price) {this.price = price;}
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 Ptadmin  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码 
private String password;
//姓名
private String ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

购物车javaBean创建语句如下:


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

//购物车
public class Shopcar  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品
private Integer productId;
//数量
private Integer num;
//
private Integer customerId;
public Integer getProductId() {return productId;}
public void setProductId(Integer productId) {this.productId = productId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}

老师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 email;
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 getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
}

题目javaBean创建语句如下:


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

//题目
public class Tm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//题目名称
private String tmName;
//题目编号
private String tmbh;
//文件
private String fileUrl;
//详细说明
private String content;
//专业
private Integer zyId;
//课题类型
private String types;
//时间
private Date insertDate;
//状态
private String status;
//不通过理由
private String btg;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getTmName() {return tmName;}
public void setTmName(String tmName) {this.tmName = tmName;}
public String getTmbh() {return tmbh;}
public void setTmbh(String tmbh) {this.tmbh = tmbh;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getZyId() {return zyId;}
public void setZyId(Integer zyId) {this.zyId = zyId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 getBtg() {return btg;}
public void setBtg(String btg) {this.btg = btg;}
}

题目留言javaBean创建语句如下:


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

//题目留言
public class Tmly  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//题目
private Integer tmId;
//学生
private Integer customerId;
//内容
private String content;
//留言日期
private Date insertDate;
//回复
private String back;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Integer getTmId() {return tmId;}
public void setTmId(Integer tmId) {this.tmId = tmId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 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 Tmsq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//题目
private Integer tmId;
//学生
private Integer customerId;
//申请说明
private String sqsm;
//状态
private String status;
//不同意说明
private String content;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public Integer getTmId() {return tmId;}
public void setTmId(Integer tmId) {this.tmId = tmId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSqsm() {return sqsm;}
public void setSqsm(String sqsm) {this.sqsm = sqsm;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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 User  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 name;
//工号
private String gh;
//手机
private String mobile;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
}

专业javaBean创建语句如下:


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

//专业
public class Zy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//专业
private String zyName;
public String getZyName() {return zyName;}
public void setZyName(String zyName) {this.zyName = zyName;}
}

源代码下载点这里

评论