“共享书角”图书借还管理系统 小程序-计算机毕业设计源码+LW文档

小程序框架：uniapp
小程序开发软件：HBuilder X
小程序运行软件：微信开发者

数据库：

DROP TABLE IF EXISTS `chujiezhe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chujiezhe` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `chujiezhanghao` varchar(200) DEFAULT NULL COMMENT '出借账号',
  `mima` varchar(200) DEFAULT NULL COMMENT '密码',
  `chujiexingming` varchar(200) DEFAULT NULL COMMENT '出借姓名',
  `touxiang` longtext COMMENT '头像',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
  `shidejine` int(11) DEFAULT NULL COMMENT '实得金额',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='出借者';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chujiezhe`
--

LOCK TABLES `chujiezhe` WRITE;
/*!40000 ALTER TABLE `chujiezhe` DISABLE KEYS */;
INSERT INTO `chujiezhe` VALUES (11,'2023-02-24 08:38:34','出借账号1','123456','出借姓名1','upload/chujiezhe_touxiang1.jpg','男','13823888881',1),(12,'2023-02-24 08:38:34','出借账号2','123456','出借姓名2','upload/chujiezhe_touxiang2.jpg','男','13823888882',2),(13,'2023-02-24 08:38:34','出借账号3','123456','出借姓名3','upload/chujiezhe_touxiang3.jpg','男','13823888883',3),(14,'2023-02-24 08:38:34','出借账号4','123456','出借姓名4','upload/chujiezhe_touxiang4.jpg','男','13823888884',4),(15,'2023-02-24 08:38:34','出借账号5','123456','出借姓名5','upload/chujiezhe_touxiang5.jpg','男','13823888885',5),(16,'2023-02-24 08:38:34','出借账号6','123456','出借姓名6','upload/chujiezhe_touxiang6.jpg','男','13823888886',6),(17,'2023-02-24 08:38:34','出借账号7','123456','出借姓名7','upload/chujiezhe_touxiang7.jpg','男','13823888887',7),(18,'2023-02-24 08:38:34','出借账号8','123456','出借姓名8','upload/chujiezhe_touxiang8.jpg','男','13823888888',8);
/*!40000 ALTER TABLE `chujiezhe` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chuzushouru`
--

DROP TABLE IF EXISTS `chuzushouru`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chuzushouru` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zhuti` varchar(200) DEFAULT NULL COMMENT '主题',
  `chujiezhanghao` varchar(200) DEFAULT NULL COMMENT '出借账号',
  `chujiexingming` varchar(200) DEFAULT NULL COMMENT '出借姓名',
  `jine` int(11) NOT NULL COMMENT '金额',
  `tuihaiyajin` varchar(200) NOT NULL COMMENT '退还压金',
  `shidejine` varchar(200) NOT NULL COMMENT '实得金额',
  `riqi` date DEFAULT NULL COMMENT '日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='出租收入';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chuzushouru`
--

LOCK TABLES `chuzushouru` WRITE;
/*!40000 ALTER TABLE `chuzushouru` DISABLE KEYS */;
INSERT INTO `chuzushouru` VALUES (81,'2023-02-24 08:38:35','出借收入','出借账号1','出借姓名1',1,'退还压金1','实得金额1','2023-02-24'),(82,'2023-02-24 08:38:35','出借收入','出借账号2','出借姓名2',2,'退还压金2','实得金额2','2023-02-24'),(83,'2023-02-24 08:38:35','出借收入','出借账号3','出借姓名3',3,'退还压金3','实得金额3','2023-02-24'),(84,'2023-02-24 08:38:35','出借收入','出借账号4','出借姓名4',4,'退还压金4','实得金额4','2023-02-24'),(85,'2023-02-24 08:38:35','出借收入','出借账号5','出借姓名5',5,'退还压金5','实得金额5','2023-02-24'),(86,'2023-02-24 08:38:35','出借收入','出借账号6','出借姓名6',6,'退还压金6','实得金额6','2023-02-24'),(87,'2023-02-24 08:38:35','出借收入','出借账号7','出借姓名7',7,'退还压金7','实得金额7','2023-02-24'),(88,'2023-02-24 08:38:35','出借收入','出借账号8','出借姓名8',8,'退还压金8','实得金额8','2023-02-24');
/*!40000 ALTER TABLE `chuzushouru` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config`
--

DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config`
--

LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discusstushuxinxi`
--