《Java基础案例教程第十三章大作业
：jdk推荐版本书jdk1.8.0_333 （给个下载方法传送门：http://t.csdn.cn/iJHI8） 推荐的sql的jar文件版本5.1.38(给出传送门的下载方法:http://t.csdn.cn/Pm6gG） 上面的版本应该比它更新。我没试过
1. java扫描书本后面的二维码下载代码，包括sql代码也在里面
2.不能下载，最后提供代码
3.开始教书管理器如何正确运行
（1）修改jdk版本：
右键文件夹，打开模块设置 选择1.8版本的路径，软件识别不了你刚刚下的jdk版本的学生，搜索自己的解决方案
（2）修改jar包：
在这个文件夹里找到mysql-connector-java.jar这个文件 把你刚下载的jar替换包的版本 只要这个是合理的jar包跟你的mysql一致或更高的版本可以成功运行
（3）修改java代码内容：
在这个类中 如果您的用户名和密码被修改(默认密码为123456)sql忘记密码，直接重新安装。不管怎样，大学生的数据库并不重要。更改密码很麻烦 ）
（4）创建sql表(推荐使用sqlyog这个软件win r也行）
这是书本扫码下的东西，sql用记事本打开， 这里我用sqlyog来做： 首先创建一个bookmannager的库 然后复制并粘贴记事本中的所有代码到操作框 一起运行，没有报错就行 刷新一下 看到四张表成功，然后打开user这个表 role这一列是1是普通账户，2是管理员账户，软件可以注册新的
(4)打开软件的方法:操作以下类别
(5)如果要交作业，不能每个人都一样，可以改背景图
JFrame软件包中的代码中有背景图代码。只需更改此代码 图片的位置是： 压缩打开即可
以下以下代码
java代码:书上有，看着打，我很累。 sql代码：
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for book -- ---------------------------- DROP TABLE IF EXISTS `book`; CREATE TABLE `book` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `book_name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `type_id` INT(11) NULL DEFAULT NULL, `author` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `publish` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `price` DOUBLE(10, 2) NULL DEFAULT NULL, `number` INT(11) NULL DEFAULT NULL, `status` INT(11) NULL DEFAULT 1 COMMENT '状态 1上架0下架', `remark` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = INNODB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of book -- ---------------------------- INSERT INTO `book` VALUES (4, '西游记', 3, '吴承恩', '机械工业出版社', 23.00, 213, 1, '四大名著之一'); INSERT INTO `book` VALUES (6, 'SpringCloud微服务架构开发', 1, '黑马程序员', '人民邮电出版社', 28.00, 20, 1, '微服务实战开发'); INSERT INTO `book` VALUES (7, '水浒传', 3, '施耐庵 ', '人民文学出版社', 29.00, 30, 1, '四大名著之一'); INSERT INTO `book` VALUES (8, 'Java基础入门（第2版）', 1, '黑马程序员', '清华大学出版社', 30.20, 22, 1, '提高Java编程功底必备'); INSERT INTO `book` VALUES (9, '中国文学编年史', 2, '陈文新', '湖南人民出版社', 35.30, 36, 1, '中国文学编年史'); INSERT INTO `book` VALUES (10, 'JavaWeb程序设计任务教程', 1, '黑马程序员', '人民邮电出版社', 25.50, 16, 1, '学习JavaWeb的好帮手'); INSERT INTO `book` VALUES (11, 'SSH框架整合实战教程', 1, '传智播客高教产品研发部', '清华大学出版社', 59.00, 12, 1, 'SSH项目开发实战'); INSERT INTO `book` VALUES (12, '朝花夕拾', 3, '鲁迅', '辽海出版社', 44.60, 30, 1, '鲁迅小说全集系列'); INSERT INTO `book` VALUES (13, '彷徨', 3, '鲁迅', '辽海出版社', 44.60, 16, 1, '鲁迅小说全集系列'); INSERT INTO `book` VALUES (14, '呐喊', 3, '鲁迅', '辽海出版社', 44.50, 16, 1, '鲁迅小说全集系列'); INSERT INTO `book` VALUES (15, '阿Q正传', 3, '鲁迅', '辽海出版社', 29.00, 33, 1, '鲁迅小说全集系列'); -- ---------------------------- -- Table structure for book_type -- ---------------------------- DROP TABLE IF EXISTS `book_type`; CREATE TABLE `book_type` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `type_name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `remark` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = INNODB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of book_type -- ---------------------------- INSERT INTO `book_type` VALUES (1, '技术', '技术类'); INSERT INTO `book_type` VALUES (2, '人文', '人文类'); INSERT INTO `book_type` VALUES (3, '小说', '人生情感小说'); -- ---------------------------- -- Table structure for borrowdetail -- ---------------------------- DROP TABLE IF EXISTS `borrowdetail`; CREATE TABLE `borrowdetail` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `user_id` INT(11) NOT NULL, `book_id` INT(11) NOT NULL, `status` INT(11) NOT NULL COMMENT '状态 1在借2已还', `borrow_time` BIGINT(20) NULL DEFAULT NULL, `return_time` BIGINT(20) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = INNODB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of borrowdetail -- ---------------------------- INSERT INTO `borrowdetail` VALUES (1, 1, 2, 2, 1546414916391, 1546414948498); INSERT INTO `borrowdetail` VALUES (2, 1, 3, 2, 1546414932877, 1556417443285); INSERT INTO `borrowdetail` VALUES (3, 1, 2, 2, 1546416530026, 1546416640210); INSERT INTO `borrowdetail` VALUES (4, 1, 1, 2, 1546565100120, 1556334334816); INSERT INTO `borrowdetail` VALUES (5, 1, 4, 1, 1546565102870, NULL); INSERT INTO `borrowdetail` VALUES (6, 3, 1, 2, 1546565519776, 1556207839074); INSERT INTO `borrowdetail` VALUES (7, 3, 4, 1, 1546565522374, NULL); INSERT INTO `borrowdetail` VALUES (8, 1, 1, 1, 1556427836809, NULL); INSERT INTO `borrowdetail` VALUES (9, 4, 3, 1, 1556433544156, NULL); INSERT INTO `borrowdetail` VALUES (10, 7, 5, 1, 1556503388763, NULL); INSERT INTO `borrowdetail` VALUES (11, 8, 5, 2, 1556507260569, 1556507349243); INSERT INTO `borrowdetail` VALUES (12, 8, 13, 1, 1556507333043, NULL); INSERT INTO `borrowdetail` VALUES (13, 8, 14, 1, 1556507390633, NULL); INSERT INTO `borrowdetail` VALUES (14, 5, 4, 2, 1556523317389, 1556523338061); INSERT INTO `borrowdetail` VALUES (15, 5, 12, 1, 1556523321541, NULL); INSERT INTO `borrowdetail` VALUES (16, 5, 13, 2, 1556523324149, 1556535561206); INSERT INTO `borrowdetail` VALUES (17, 5, 10, 1, 1556535626582, NULL); INSERT INTO `borrowdetail` VALUES (18, 5, 8, 2, 1556535629488, 1556585064182); INSERT INTO `borrowdetail` VALUES (19, 5, 6, 1, 1556539744896, NULL); INSERT INTO `borrowdetail` VALUES (20, 1, 5, 1, 1556539946226, NULL); INSERT INTO `borrowdetail` VALUES (21, 9, 2, 2, 1556583833816, 1556583847518); INSERT INTO `borrowdetail` VALUES (22, 9, 7, 1, 1556583838018, NULL); INSERT INTO `borrowdetail` VALUES (23, 5, 14, 1, 1556585092996, NULL); INSERT INTO `borrowdetail` VALUES (24, 5, 11, 1, 1556585100866, NULL); INSERT INTO `borrowdetail` VALUES (25, 1, 12, 1, 1556845403233, NULL); INSERT INTO `borrowdetail` VALUES (26, 11, 2, 2, 1561804768359, 1561804772616); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `username` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `password` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `role` INT(255) NULL DEFAULT NULL COMMENT '角色 1学生 2管理员', `sex` VARCHAR(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `phone` CHAR(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = INNODB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (1, 'xkj', 'xkj123', 1, '男', '13195648799'); INSERT INTO `user` VALUES (2, 'admin', '111111', 2, '男', '13198645975'); INSERT INTO `user` VALUES (3, '徐某人', 'xkj123', 1, '女', '13195648529'); INSERT INTO `user` VALUES (4, '肖淼', 'sdf78978', 1, '女', '13195698458'); INSERT INTO `user` VALUES (5, '张军伟', 'zjw520', 1, '女', '13195689458'); INSERT INTO `user` VALUES (6, '杨帆', 'dfd757', 1, '女', '15246598568'); INSERT INTO `user` VALUES (7, '九头蛇', 'kkk111', 1, '男', '13194959879'); INSERT INTO `user` VALUES (8, '蔡佳铭', 'cjm7418', 1, '女', '13164649855'); INSERT INTO 标签： 28zjw印制板连接器