基于SSM的图书管理系统,java专业毕业设计

基于SSM的图书管理系统登录注册界面

基于SSM的图书管理系统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_book(
	id int primary key auto_increment comment '主键',
	bookName varchar(100) comment '类型名称',
	bookDesc varchar(100) comment '图书简介',
	bookPic varchar(100) comment '图片',
	status varchar(100) comment '状态',
	sjId int comment '书架',
	lxId int comment '类型'
) comment '图书档案';

读者档案表创建语句如下:


create table t_dz(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	dzName varchar(100) comment '姓名',
	phone varchar(100) comment '手机',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	idcard varchar(100) comment '身份证'
) comment '读者档案';

图书档案表创建语句如下:


create table t_js(
	id int primary key auto_increment comment '主键',
	bookId int comment '书',
	dzId int comment '用户',
	backTime varchar(100) comment '归还日期',
	jsDate varchar(100) comment '借书日期'
) comment '图书档案';

图书类型表创建语句如下:


create table t_lx(
	id int primary key auto_increment comment '主键',
	lxName varchar(100) comment '类型名称'
) comment '图书类型';

书架表创建语句如下:


create table t_sj(
	id int primary key auto_increment comment '主键',
	sjName varchar(100) comment '书架名称'
) comment '书架';

图书馆信息表创建语句如下:


create table t_tsg(
	id int primary key auto_increment comment '主键',
	tsgName varchar(100) comment '图书馆名称',
	tsgContent varchar(100) comment '图书馆简介',
	tsgDesc varchar(100) comment '图书馆借阅事项'
) comment '图书馆信息';

基于SSM的图书管理系统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_book(
	id integer,
	bookName varchar(100),
	bookDesc varchar(100),
	bookPic varchar(100),
	status varchar(100),
	sjId int,
	lxId int
);
--图书档案字段加注释
comment on column t_book.id is '主键';
comment on column t_book.bookName is '类型名称';
comment on column t_book.bookDesc is '图书简介';
comment on column t_book.bookPic is '图片';
comment on column t_book.status is '状态';
comment on column t_book.sjId is '书架';
comment on column t_book.lxId is '类型';
--图书档案表加注释
comment on table t_book is '图书档案';

读者档案表创建语句如下:


create table t_dz(
	id integer,
	username varchar(100),
	password varchar(100),
	dzName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	idcard varchar(100)
);
--读者档案字段加注释
comment on column t_dz.id is '主键';
comment on column t_dz.username is '账号';
comment on column t_dz.password is '密码';
comment on column t_dz.dzName is '姓名';
comment on column t_dz.phone is '手机';
comment on column t_dz.age is '年龄';
comment on column t_dz.sex is '性别';
comment on column t_dz.idcard is '身份证';
--读者档案表加注释
comment on table t_dz is '读者档案';

图书档案表创建语句如下:


create table t_js(
	id integer,
	bookId int,
	dzId int,
	backTime varchar(100),
	jsDate varchar(100)
);
--图书档案字段加注释
comment on column t_js.id is '主键';
comment on column t_js.bookId is '书';
comment on column t_js.dzId is '用户';
comment on column t_js.backTime is '归还日期';
comment on column t_js.jsDate is '借书日期';
--图书档案表加注释
comment on table t_js is '图书档案';

图书类型表创建语句如下:


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

书架表创建语句如下:


create table t_sj(
	id integer,
	sjName varchar(100)
);
--书架字段加注释
comment on column t_sj.id is '主键';
comment on column t_sj.sjName is '书架名称';
--书架表加注释
comment on table t_sj is '书架';

图书馆信息表创建语句如下:


create table t_tsg(
	id integer,
	tsgName varchar(100),
	tsgContent varchar(100),
	tsgDesc varchar(100)
);
--图书馆信息字段加注释
comment on column t_tsg.id is '主键';
comment on column t_tsg.tsgName is '图书馆名称';
comment on column t_tsg.tsgContent is '图书馆简介';
comment on column t_tsg.tsgDesc is '图书馆借阅事项';
--图书馆信息表加注释
comment on table t_tsg is '图书馆信息';

oracle特有,对应序列如下:


create sequence s_t_book;
create sequence s_t_dz;
create sequence s_t_js;
create sequence s_t_lx;
create sequence s_t_sj;
create sequence s_t_tsg;

基于SSM的图书管理系统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_book(
	id int identity(1,1) primary key not null,--主键
	bookName varchar(100),--类型名称
	bookDesc varchar(100),--图书简介
	bookPic varchar(100),--图片
	status varchar(100),--状态
	sjId int,--书架
	lxId int--类型
);

读者档案表创建语句如下:


--读者档案表注释
create table t_dz(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	dzName varchar(100),--姓名
	phone varchar(100),--手机
	age varchar(100),--年龄
	sex varchar(100),--性别
	idcard varchar(100)--身份证
);

图书档案表创建语句如下:


--图书档案表注释
create table t_js(
	id int identity(1,1) primary key not null,--主键
	bookId int,--书
	dzId int,--用户
	backTime varchar(100),--归还日期
	jsDate varchar(100)--借书日期
);

图书类型表创建语句如下:


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

书架表创建语句如下:


--书架表注释
create table t_sj(
	id int identity(1,1) primary key not null,--主键
	sjName varchar(100)--书架名称
);

图书馆信息表创建语句如下:


--图书馆信息表注释
create table t_tsg(
	id int identity(1,1) primary key not null,--主键
	tsgName varchar(100),--图书馆名称
	tsgContent varchar(100),--图书馆简介
	tsgDesc varchar(100)--图书馆借阅事项
);

基于SSM的图书管理系统登录后主页

基于SSM的图书管理系统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_book")
public class Book {
//主键
@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 bookName;
//图书简介
private String bookDesc;
//图片
private String bookPic;
//状态
private String status;
//书架
private Integer sjId;
//类型
private Integer lxId;
public String getBookName() {return bookName;}
public void setBookName(String bookName) {this.bookName = bookName;}
public String getBookDesc() {return bookDesc;}
public void setBookDesc(String bookDesc) {this.bookDesc = bookDesc;}
public String getBookPic() {return bookPic;}
public void setBookPic(String bookPic) {this.bookPic = bookPic;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getSjId() {return sjId;}
public void setSjId(Integer sjId) {this.sjId = sjId;}
public Integer getLxId() {return lxId;}
public void setLxId(Integer lxId) {this.lxId = lxId;}
}

读者档案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_dz")
public class Dz {
//主键
@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 dzName;
//手机
private String phone;
//年龄
private String age;
//性别
private String sex;
//身份证
private String idcard;
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 getDzName() {return dzName;}
public void setDzName(String dzName) {this.dzName = dzName;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}

图书档案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_js")
public class Js {
//主键
@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 bookId;
//用户
private Integer dzId;
//归还日期
private String backTime;
//借书日期
private String jsDate;
public Integer getBookId() {return bookId;}
public void setBookId(Integer bookId) {this.bookId = bookId;}
public Integer getDzId() {return dzId;}
public void setDzId(Integer dzId) {this.dzId = dzId;}
public String getBackTime() {return backTime;}
public void setBackTime(String backTime) {this.backTime = backTime;}
public String getJsDate() {return jsDate;}
public void setJsDate(String jsDate) {this.jsDate = jsDate;}
}

图书类型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_lx")
public class Lx {
//主键
@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 lxName;
public String getLxName() {return lxName;}
public void setLxName(String lxName) {this.lxName = lxName;}
}

书架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_sj")
public class Sj {
//主键
@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 sjName;
public String getSjName() {return sjName;}
public void setSjName(String sjName) {this.sjName = sjName;}
}

图书馆信息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_tsg")
public class Tsg {
//主键
@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 tsgName;
//图书馆简介
private String tsgContent;
//图书馆借阅事项
private String tsgDesc;
public String getTsgName() {return tsgName;}
public void setTsgName(String tsgName) {this.tsgName = tsgName;}
public String getTsgContent() {return tsgContent;}
public void setTsgContent(String tsgContent) {this.tsgContent = tsgContent;}
public String getTsgDesc() {return tsgDesc;}
public void setTsgDesc(String tsgDesc) {this.tsgDesc = tsgDesc;}
}

基于SSM的图书管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

图书档案javaBean创建语句如下:


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

//图书档案
public class Book  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型名称
private String bookName;
//图书简介
private String bookDesc;
//图片
private String bookPic;
//状态
private String status;
//书架
private Integer sjId;
//类型
private Integer lxId;
public String getBookName() {return bookName;}
public void setBookName(String bookName) {this.bookName = bookName;}
public String getBookDesc() {return bookDesc;}
public void setBookDesc(String bookDesc) {this.bookDesc = bookDesc;}
public String getBookPic() {return bookPic;}
public void setBookPic(String bookPic) {this.bookPic = bookPic;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getSjId() {return sjId;}
public void setSjId(Integer sjId) {this.sjId = sjId;}
public Integer getLxId() {return lxId;}
public void setLxId(Integer lxId) {this.lxId = lxId;}
}

读者档案javaBean创建语句如下:


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

//读者档案
public class Dz  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 dzName;
//手机
private String phone;
//年龄
private String age;
//性别
private String sex;
//身份证
private String idcard;
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 getDzName() {return dzName;}
public void setDzName(String dzName) {this.dzName = dzName;}
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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
}

图书档案javaBean创建语句如下:


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

//图书档案
public class Js  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//书
private Integer bookId;
//用户
private Integer dzId;
//归还日期
private String backTime;
//借书日期
private String jsDate;
public Integer getBookId() {return bookId;}
public void setBookId(Integer bookId) {this.bookId = bookId;}
public Integer getDzId() {return dzId;}
public void setDzId(Integer dzId) {this.dzId = dzId;}
public String getBackTime() {return backTime;}
public void setBackTime(String backTime) {this.backTime = backTime;}
public String getJsDate() {return jsDate;}
public void setJsDate(String jsDate) {this.jsDate = jsDate;}
}

图书类型javaBean创建语句如下:


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

//图书类型
public class Lx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型名称
private String lxName;
public String getLxName() {return lxName;}
public void setLxName(String lxName) {this.lxName = lxName;}
}

书架javaBean创建语句如下:


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

//书架
public class Sj  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//书架名称
private String sjName;
public String getSjName() {return sjName;}
public void setSjName(String sjName) {this.sjName = sjName;}
}

图书馆信息javaBean创建语句如下:


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

//图书馆信息
public class Tsg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//图书馆名称
private String tsgName;
//图书馆简介
private String tsgContent;
//图书馆借阅事项
private String tsgDesc;
public String getTsgName() {return tsgName;}
public void setTsgName(String tsgName) {this.tsgName = tsgName;}
public String getTsgContent() {return tsgContent;}
public void setTsgContent(String tsgContent) {this.tsgContent = tsgContent;}
public String getTsgDesc() {return tsgDesc;}
public void setTsgDesc(String tsgDesc) {this.tsgDesc = tsgDesc;}
}

源代码下载点这里

评论