本系统在设计方面采用B/S模式，同时使用JSP技术进行基本页面的设计与功能实现，后台数据库选用MYSQL数据库。

CREATE TABLE `t_b_book` (
  `id` varchar(36) NOT NULL,
  `bookname` varchar(30) DEFAULT NULL COMMENT '书名',
  `author` varchar(20) DEFAULT NULL COMMENT '作者',
  `booktype` varchar(2) DEFAULT NULL COMMENT '分类',
  `isbn` varchar(30) DEFAULT NULL COMMENT 'isbn',
  `pressname` varchar(30) DEFAULT NULL COMMENT '出版社名称',
  `status` varchar(1) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_b_book`
--

LOCK TABLES `t_b_book` WRITE;
/*!40000 ALTER TABLE `t_b_book` DISABLE KEYS */;
INSERT INTO `t_b_book` VALUES ('ec','Struts框架技术','王勇','8','111-1','动力节点','2'),('ec5b00002','spring框架技术','王勇','8','111-2','动力节点','2'),('ec5e70003','hibernate框架技术','王勇','8','111-3','动力节点','2'),('ec','Java基础','杜聚宾','8','111-4','动力节点','2'),('ec','Java零基础','吴士忠','8','111-5','动力节点','2'),('ec','西游记','吴承恩','2','222-1','北京出版社','2'),('ec','盗墓笔记','南派三叔','2','223-4','北京出版社','2'),('ec','鬼吹灯','天下霸唱','2','234-5345','北京出版社','2'),('ec6b80009','艺术学概论','彭吉象','3','23-957','北京出版社','2'),('ec6da000a','灌篮高手','井上雄彦','1','9234-23','北京出版社','2'),('ec6fb000b','足球小将','高桥阳一','1','1928-578','北京出版社','2'),('ec71c000c','秘密','拜恩','4','389-34','北京出版社','2'),('ec73f000d','巧厨娘','孙春娜','5','34-34859','北京出版社','2'),('ec75f000e','人文在高处','熊培云','6','4398-348','北京出版社','2'),('ecf','金字塔原理','芭芭拉','7','3489-34','北京出版社','2'),('ec7a40010','小学生看图说话','博尔','9','283-23','北京出版社','2'),('ec7ce0011','成语词典','商务印馆研究中心','10','28748-9','北京出版社','2');
/*!40000 ALTER TABLE `t_b_book` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_b_lend`
--

DROP TABLE IF EXISTS `t_b_lend`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_b_lend` (
  `id` varchar(36) NOT NULL COMMENT '主键',
  `bookid` varchar(36) DEFAULT NULL COMMENT '图书id',
  `bookname` varchar(30) DEFAULT NULL COMMENT '书名',
  `author` varchar(20) DEFAULT NULL COMMENT '作者',
  `isbn` varchar(30) DEFAULT NULL COMMENT 'isbn',
  `userid` varchar(36) DEFAULT NULL COMMENT '读者id',
  `realname` varchar(30) DEFAULT NULL COMMENT '读者姓名',
  `lenddate` datetime DEFAULT NULL COMMENT '借阅时间',
  `returndate` datetime DEFAULT NULL COMMENT '归还时间',
  `debit` decimal(5,2) DEFAULT '0.00' COMMENT '扣款',
  `totalcount` varchar(1) DEFAULT NULL COMMENT '续借次数',
  `status` varchar(1) DEFAULT NULL COMMENT '状态',
  `username` varchar(30) DEFAULT NULL COMMENT '读者编号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_b_lend`
--

LOCK TABLES `t_b_lend` WRITE;
/*!40000 ALTER TABLE `t_b_lend` DISABLE KEYS */;
/*!40000 ALTER TABLE `t_b_lend` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_b_press`
--

DROP TABLE IF EXISTS `t_b_press`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client &#java基础视频吴士忠61; utf8 */;
CREATE TABLE `t_b_press` (
  `id` varchar(36) NOT NULL,
  `pressname` varchar(30) DEFAULT NULL COMMENT '出版社名称',
  `pressaddr` varchar(40) DEFAULT NULL COMMENT '出版社地址',
  `presstel` varchar(15) DEFAULT NULL COMMENT '出版社电话',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_b_press`
--

LOCK TABLES `t_b_press` WRITE;
/*!40000 ALTER TABLE `t_b_press` DISABLE KEYS */;
INSERT INTO `t_b_press` VALUES ('eec030001','动力节点','北京天通苑本四区10号楼4层','0'),('e54582fed4d0001','北京出版社','北京','0');
/*!40000 ALTER TABLE `t_b_press` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_s_attachment`
--