基于springboot+mybatis+thymeleaf个人博客项目.zip

/* Navicat Premium Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 50515 Source Host : localhost:3306 Source Schema : blog Target Server Type : MySQL Target Server Version : 50515 File Encoding : 65001 Date: 24/03/2020 18:22:54 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_blog -- ---------------------------- DROP TABLE IF EXISTS `t_blog`; CREATE TABLE `t_blog` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `first_picture` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `flag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `views` int(11) NULL DEFAULT NULL, `appreciation` int(11) NOT NULL DEFAULT 0, `share_statement` int(11) NOT NULL DEFAULT 0, `commentabled` int(11) NOT NULL DEFAULT 0, `published` int(11) NOT NULL DEFAULT 0, `recommend` int(11) NOT NULL DEFAULT 0, `create_time` datetime NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, `type_id` bigint(20) NULL DEFAULT NULL, `user_id` bigint(20) NULL DEFAULT NULL, `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `tag_ids` varchar(100) 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 t_blog -- ---------------------------- INSERT INTO `t_blog` VALUES (1, 'maven中静态资源的过滤', '# maven中静态资源的过滤\r\n\r\npom.xml文件中加入下面配置\r\n\r\n### 可以过滤java和resources文件夹里面所有的的.properties和.xml文件\r\n**directory：指定资源所在的目录，目录的路径是相对于pom.xml文件的\r\nincludes：指定要包含哪些文件**\r\n**filtering标签中：false表示不过滤，true表示过滤**\r\n\r\n```java\r\n <build>\r\n <resources>\r\n <resource>\r\n <directory>src/main/java</directory>\r\n <includes>\r\n <include>**/*.properties</include>\r\n <include>**/*.xml</include>\r\n </includes>\r\n <filtering>false</filtering>\r\n </resource>\r\n <resource>\r\n <directory>src/main/resources</directory>\r\n <includes>\r\n <include>**/*.properties</include>\r\n <include>**/*.xml</include>\r\n </includes>\r\n <filtering>false</filtering>\r\n </resource>\r\n </resources>\r\n </build>\r\n```\r\n', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1584367888190&di=7855ff350e759b4b3de8c614978673b4&imgtype=0&src=http%3A%2F%2Fb-ssl.duitang.com%2Fuploads%2Fitem%2F201612%2F07%2F20161207154722_Cmce5.thumb.400_0.gif', '原创', 0, 1, 1, 1, 1, 1, '2020-03-12 08:25:47', '2020-03-13 11:56:19', 3, 1, 'pom.xml文件中加入下面配置\r\n可以过滤java和resources文件夹里面所有的的.properties和.xml文件', '4'); INSERT INTO `t_blog` VALUES (2, '使用System.out.format()格式化输出', '#### JDK5.0允许java像C语言那样直接用printf()方法来格式化输出\r\n#### System.out.format()功能与printf()一样，可以使用%d,%f等参数。\r\n使用System.out.format()完成**左对齐，补0，千位分隔符，小数点位数，本地化表达**\r\n```java\r\npublic class TestNumber {\r\n \r\n public static void main(String[] args) {\r\n int year = 2020;\r\n //左对齐，补0，千位分隔符，小数点位数，本地化表达\r\n \r\n //直接打印数字\r\n System.out.println(year);\r\n \r\n //直接打印数字\r\n System.out.format(\"%d%n\",year);\r\n //总长度是8,默认右对齐\r\n System.out.format(\"%8d%n\",year);\r\n //总长度是8,左对齐\r\n System.out.format(\"%-8d%n\",year);\r\n //总长度是8,不够补0\r\n System.out.format(\"%08d%n\",year);\r\n //千位分隔符\r\n System.out.format(\"%,8d%n\",year*10000);\r\n \r\n //保留5位小数\r\n System.out.format(\"%.5f%n\",Math.PI);\r\n \r\n //不同国家的千位分隔符\r\n System.out.format(Locale.FRANCE,\"%,.2f%n\",Math.PI*10000);\r\n System.out.format(Locale.US,\"%,.2f%n\",Math.PI*10000);\r\n System.out.format(Locale.UK,\"%,.2f%n\",Math.PI*10000);\r\n \r\n }\r\n}\r\n```\r\n输出结果：\r\n\r\n```java\r\n2020\r\n2020\r\n 2020\r\n2020 \r\n00002020\r\n20,200,000\r\n3.14159\r\n31?415,93\r\n31,415.93\r\n31,415.93\r\n```\r\n', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1584368822685&di=19855856bbd158b52926a49b51e876c0&imgtype=0&src=http%3A%2F%2Fwx2.sinaimg.cn%2Fcrop.0.4.1280.711%2F70745653ly1fvuflwe10zj20zk0k0n06.jpg', '原创', 0, 1, 1, 1, 1, 1, '2019-03-12 13:42:14', '2019-03-13 12:00:08', 6, 1, 'JDK5.0允许java像C语言那样直接用printf()方法来格式化输出\r\nSystem.out.format()功能与printf()一样，可以使用%d,%f等参数。\r\n\r\n使用System.out.format()完成左对齐，补0，千位分隔符，小数点位数，本地化表达', '7'); INSERT INTO `t_blog` VALUES (3, 'Springboot中PageHelper 分页查询使用方法', '### 一：导入依赖\r\n\r\n```java\r\n<dependency>\r\n <groupId>com.github.pagehelper</groupId>\r\n <artifactId>pagehelper-spring-boot-starter</artifactId>\r\n <version>1.2.13</version>\r\n</dependency>\r\n```\r\n### 二：配置yml文件中PageHelper的属性\r\n\r\n```java\r\npagehelper: #分页插件\r\n helper-dialect: mysql\r\n reasonable: true\r\n support-methods-arguments: true\r\n params:\r\n```\r\n### 三：在controller类中使用，\r\n##### 1.在查询方法上调用PageHelper.startPage()方法，设置分页的页数和每页信息数，\r\n##### 2.将查询出来的结果集用PageInfo的构造函数初始化为一个分页结果对象\r\n##### 3.将分页结果对象存入model，返回前端页面\r\n```java\r\n@GetMapping(\"/types\")\r\npublic String types(@RequestParam(required = false,defaultValue = \"1\",value = \"pagenum\")int pagenum, Model model){\r\n\r\n PageHelper.startPage(pagenum, 5); //pagenum：页数，pagesize:每页的信息数\r\n \r\n List<Type> allType = typeService.getAllType(); //调用业务层查询方法\r\n \r\n PageInfo<Type> pageInfo = new PageInfo<>(allType); //得到分页结果对象\r\n \r\n model.addAttribute(\"pageInfo\", pageInfo); //携带分页结果信息\r\n \r\n return \"admin/types\"; //回到前端展示页面\r\n}\r\n```\r\n### 四：前端展示分页（thymeleaf+semantic-ui）,这里ui用自己的就行，比如bootstrap或layui，主要是thymeleaf的使用。\r\n\r\n```java\r\n<table class=\"ui compact celled teal table\">\r\n <thead>\r\n <tr>\r\n <th></th>\r\n <th>名称</th>\r\n <th>操作</th>\r\n </tr>\r\n </thead>\r\n <tbody>\r\n <tr th:each=\"type, iterStat : ${pageInfo.list}\">\r\n <td th:text=\"${iterStat.count}\">1</td>\r\n <td th:text=\"${type.name}\">摸鱼方法</td>\r\n <td>\r\n <a href=\"#\" th:href=\"@{/admin/types/{id}/input(id=${type.id})}\" class=\"ui mini teal basic button\">编辑</a>\r\n <a href=\"#\" th:href=\"@{/admin/types/{id}/delete(id=${type.id})}\" class=\"ui mini red basic button\">删除</a>\r\n </td>\r\n </tr>\r\n </tbody>\r\n <tfoot>\r\n <tr>\r\n <th colspan=\"7\">\r\n <div class=\"ui mini pagination menu\" >\r\n <div class=\"item\"><a th:href=\"@{/admin/types}\">首页</a></div>\r\n <div class=\"item\"><a th:href=\"@{/admi