# bookApp

**Repository Path**: pensiveboys/bookApp

## Basic Information

- **Project Name**: bookApp
- **Description**: 十个字符十个字符十个
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-01-26
- **Last Updated**: 2023-11-04

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

序言 - 懒是人类进步的阶梯，由于不想坐在电脑前所以选择了app，又由于市场上的app太复杂，所以自己开发了一款非常简单的app，最后发现==坐在电脑前的目的不是为了更好地写作，而是为了更好地防止睡觉。

>画面兼容ipad(笔者用的是HUAWEI MatePad)以及Android手机

效果如下


<img src="QQ%E5%9B%BE%E7%89%8720231001130412.jpg" width="310px">

<img src="Screenshot_20231001_125951.jpg" width="310px">


开始 -

拉去项目后找到BaseDB类，将数据源修改为自己的即可。

Android studio 打包生成APK步骤：https://www.exceptionsnull.cn/v2Article/CAPP1

默认登录账户密码root，admin，存放在app_customer表中，并且要求每过7天重新输一次账户密码,如果是本机则永不要求再次输入密码

下面是数据表


```
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for app_customer
-- ----------------------------
DROP TABLE IF EXISTS `app_customer`;
CREATE TABLE `app_customer`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `last_login_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `android_id` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `index_primary`(`id`) USING BTREE,
  UNIQUE INDEX `index_android`(`android_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of app_customer
-- ----------------------------
INSERT INTO `app_customer` VALUES (1, 'root', 'admin', '2023-02-16 12:13:35', '2023-02-16 12:13:39', '2023-09-28 17:53:51', '6588cd7ed4811f53');

SET FOREIGN_KEY_CHECKS = 1;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for app_customer
-- ----------------------------
DROP TABLE IF EXISTS `app_customer`;
CREATE TABLE `app_customer`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `last_login_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `android_id` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `index_primary`(`id`) USING BTREE,
  UNIQUE INDEX `index_android`(`android_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of app_customer
-- ----------------------------
INSERT INTO `app_customer` VALUES (1, 'root', 'admin', '2023-02-16 12:13:35', '2023-02-16 12:13:39', '2023-09-28 17:53:51', '6588cd7ed4811f53');

SET FOREIGN_KEY_CHECKS = 1;

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for book_chapters
-- ----------------------------
DROP TABLE IF EXISTS `book_chapters`;
CREATE TABLE `book_chapters`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `chapter_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `chapter_title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `chapter_synopsis` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `ref_book_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
  `ref_book_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'book_info的外键',
  `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `modify_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `chapter_info` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `is_show` tinyint(4) NULL DEFAULT 1 COMMENT '是否公开(0否1是)',
  `is_back_up` tinyint(4) NULL DEFAULT 0 COMMENT '0未备份1已备份',
  `is_recommend` tinyint(4) NULL DEFAULT 0 COMMENT '是否推荐(0否1是)',
  `count` int(11) NULL DEFAULT 0 COMMENT '字数',
  `back_up_count` int(11) NULL DEFAULT 0,
  `update_count` int(11) NULL DEFAULT 0,
  `device` tinyint(4) NULL DEFAULT 0 COMMENT '0windows1android',
  `is_chapter_relevant` tinyint(4) NULL DEFAULT 0 COMMENT '0chapter 1 relevant',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `seq_index_id`(`id`) USING BTREE,
  UNIQUE INDEX `seq_index_cid`(`chapter_id`) USING BTREE,
  INDEX `seq_index_bid`(`ref_book_id`) USING BTREE,
  INDEX `seq_index_recommend`(`is_recommend`) USING BTREE,
  INDEX `seq_index_device`(`device`) USING BTREE,
  INDEX `seq_index_ischapter`(`is_chapter_relevant`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 570 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '书籍章节' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;


```

关于数据库无法添加表情图案的解决方案：


```
#查看数据库参数
SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';
```

因为字符长度限制utf-8不支持表情图，所以需要将变量name为
character_set_client、
character_set_connection、
character_set_database、
character_set_server、
character_set_results从utf-8
统一改为utf8mb4




免费的书籍封面设计 https://www.canva.cn/design  建议封面分辨率统一，我使用的是1410X2250