一、系统介绍

运行环境：idea、eclispe、mysql

二、功能展示

1.主页

2.添加图书

3.图书列表

4.根据图书名称号查询图书信息

5.根据编号删除图书信息

6.根据编号编辑图书信息

7.退出系统

三、数据库

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80021
 Source Host           : localhost:3306
 Source Schema         : booksmanage

 Target Server Type    : MySQL
 Target Server Version : 80021
 File Encoding         : 65001

 Date: 06/07/2022 15:50:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for book_info
-- ----------------------------
DROP TABLE IF EXISTS `book_info`;
CREATE TABLE `book_info`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `publish` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `isbn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `introduction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of book_info
-- ----------------------------
INSERT INTO `book_info` VALUES (1, 西游记, 施耐庵, 机械工业出版社, 100011, 师徒四人去西天取真经);
INSERT INTO `book_info` VALUES (2, 三国演义, 罗贯中, 清华大学出版社, 100012, 东汉末年分三国);
INSERT INTO `book_info` VALUES (5, 红楼梦, 曹雪芹, 北京大学出版社, 100013, 宝玉与众多男女之间故事);

SET FOREIGN_KEY_CHECKS = 1;

四、其它

1.其他系统实现

点击下载