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

基于BS的照相管理系统的设计与实现

基于BS的照相管理系统的设计与实现登录注册界面

基于BS的照相管理系统的设计与实现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_banji(
	id int primary key auto_increment comment '主键',
	banjiName varchar(100) comment '班级'
) comment '班级';

照片表创建语句如下:


create table t_pic(
	id int primary key auto_increment comment '主键',
	pic varchar(100) comment '照片',
	remark varchar(100) comment '备注',
	studentId int comment '学生',
	insertDate datetime comment '日期',
	typesId int 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 '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	xueyuanName varchar(100) comment '学院',
	banjiName varchar(100) comment '班级'
) comment '学生';

通知表创建语句如下:


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

分类表创建语句如下:


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

学院表创建语句如下:


create table t_xueyuan(
	id int primary key auto_increment comment '主键',
	xueyuanName varchar(100) comment '学院'
) comment '学院';

基于BS的照相管理系统的设计与实现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_banji(
	id integer,
	banjiName varchar(100)
);
--班级字段加注释
comment on column t_banji.id is '主键';
comment on column t_banji.banjiName is '班级';
--班级表加注释
comment on table t_banji is '班级';

照片表创建语句如下:


create table t_pic(
	id integer,
	pic varchar(100),
	remark varchar(100),
	studentId int,
	insertDate datetime,
	typesId int
);
--照片字段加注释
comment on column t_pic.id is '主键';
comment on column t_pic.pic is '照片';
comment on column t_pic.remark is '备注';
comment on column t_pic.studentId is '学生';
comment on column t_pic.insertDate is '日期';
comment on column t_pic.typesId is '分类';
--照片表加注释
comment on table t_pic is '照片';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	headPic varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	xueyuanName varchar(100),
	banjiName varchar(100)
);
--学生字段加注释
comment on column t_student.id is '主键';
comment on column t_student.username is '账号';
comment on column t_student.password is '密码';
comment on column t_student.studentName is '姓名';
comment on column t_student.headPic is '头像';
comment on column t_student.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.xueyuanName is '学院';
comment on column t_student.banjiName is '班级';
--学生表加注释
comment on table t_student is '学生';

通知表创建语句如下:


create table t_tongzhi(
	id integer,
	title varchar(100),
	pic varchar(100),
	remark varchar(100),
	insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.pic is '图片';
comment on column t_tongzhi.remark is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知表加注释
comment on table t_tongzhi 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_xueyuan(
	id integer,
	xueyuanName varchar(100)
);
--学院字段加注释
comment on column t_xueyuan.id is '主键';
comment on column t_xueyuan.xueyuanName is '学院';
--学院表加注释
comment on table t_xueyuan is '学院';

oracle特有,对应序列如下:


create sequence s_t_banji;
create sequence s_t_pic;
create sequence s_t_student;
create sequence s_t_tongzhi;
create sequence s_t_types;
create sequence s_t_xueyuan;

基于BS的照相管理系统的设计与实现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_banji(
	id int identity(1,1) primary key not null,--主键
	banjiName varchar(100)--班级
);

照片表创建语句如下:


--照片表注释
create table t_pic(
	id int identity(1,1) primary key not null,--主键
	pic varchar(100),--照片
	remark varchar(100),--备注
	studentId int,--学生
	insertDate datetime,--日期
	typesId int--分类
);

学生表创建语句如下:


--学生表注释
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),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--性别
	xueyuanName varchar(100),--学院
	banjiName varchar(100)--班级
);

通知表创建语句如下:


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

分类表创建语句如下:


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

学院表创建语句如下:


--学院表注释
create table t_xueyuan(
	id int identity(1,1) primary key not null,--主键
	xueyuanName varchar(100)--学院
);

基于BS的照相管理系统的设计与实现登录后主页

基于BS的照相管理系统的设计与实现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_banji")
public class Banji {
//主键
@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 banjiName;
public String getBanjiName() {return banjiName;}
public void setBanjiName(String banjiName) {this.banjiName = banjiName;}
}

照片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_pic")
public class Pic {
//主键
@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 pic;
//备注
private String remark;
//学生
private Integer studentId;
//日期
private Date insertDate;
//分类
private Integer typesId;
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_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 phone;
//年龄
private String age;
//性别
private String sex;
//学院
private String xueyuanName;
//班级
private String banjiName;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getXueyuanName() {return xueyuanName;}
public void setXueyuanName(String xueyuanName) {this.xueyuanName = xueyuanName;}
public String getBanjiName() {return banjiName;}
public void setBanjiName(String banjiName) {this.banjiName = banjiName;}
}

通知javaBean创建语句如下:


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

//通知
@Table(name = "t_tongzhi")
public class Tongzhi {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String remark;
//日期
private Date insertDate;
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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_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_xueyuan")
public class Xueyuan {
//主键
@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 xueyuanName;
public String getXueyuanName() {return xueyuanName;}
public void setXueyuanName(String xueyuanName) {this.xueyuanName = xueyuanName;}
}

基于BS的照相管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

班级javaBean创建语句如下:


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

//班级
public class Banji  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班级
private String banjiName;
public String getBanjiName() {return banjiName;}
public void setBanjiName(String banjiName) {this.banjiName = banjiName;}
}

照片javaBean创建语句如下:


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

//照片
public class Pic  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//照片
private String pic;
//备注
private String remark;
//学生
private Integer studentId;
//日期
private Date insertDate;
//分类
private Integer typesId;
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 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 phone;
//年龄
private String age;
//性别
private String sex;
//学院
private String xueyuanName;
//班级
private String banjiName;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getXueyuanName() {return xueyuanName;}
public void setXueyuanName(String xueyuanName) {this.xueyuanName = xueyuanName;}
public String getBanjiName() {return banjiName;}
public void setBanjiName(String banjiName) {this.banjiName = banjiName;}
}

通知javaBean创建语句如下:


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

//通知
public class Tongzhi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String remark;
//日期
private Date insertDate;
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 getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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 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 Xueyuan  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学院
private String xueyuanName;
public String getXueyuanName() {return xueyuanName;}
public void setXueyuanName(String xueyuanName) {this.xueyuanName = xueyuanName;}
}

评论