forked from zhongzx8080/BadBlog
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathbadblog.sql
227 lines (211 loc) · 206 KB
/
badblog.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
/*
Navicat MySQL Data Transfer
Source Server : local_mysql
Source Server Version : 50717
Source Host : localhost:3306
Source Database : badblog
Target Server Type : MYSQL
Target Server Version : 50717
File Encoding : 65001
Date: 2017-11-05 19:38:08
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
`aid` int(11) NOT NULL AUTO_INCREMENT COMMENT '博客文章ID',
`uid` int(11) DEFAULT NULL COMMENT '文章作者ID',
`title` varchar(255) DEFAULT NULL COMMENT '文章标题',
`markdown` text COMMENT 'markdown 源码',
`html` text COMMENT 'html源码',
`gmt_post` datetime DEFAULT NULL COMMENT '发表时间',
`view` int(11) DEFAULT '0' COMMENT '浏览次数',
PRIMARY KEY (`aid`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of article
-- ----------------------------
INSERT INTO `article` VALUES ('78', '1', '批量重命名文件', '## 思路\r\n\r\n- `ls dir`列出目录下的文件\r\n- `sed` 替换文件名\r\n- `mv `重命名\r\n\r\n\r\n\r\n## 脚本\r\n\r\n```shell\r\n#!/bin/bash\r\n\r\n# 批量重命名文件\r\n\r\nread -p \"输入源目录(请一次正确输入目录): \" src_dir\r\n\r\n# 删除最后一个斜杠\r\nsrc_dir=${src_dir%\\/}\r\n\r\n# 判断目录是否存在\r\nif [ ! -d $src_dir ];\r\nthen\r\n echo \"该目录不存在！\"\r\n exit 2\r\nfi\r\n\r\n# 在 sed 中使用自定义变量要使用双引号(很谜)\r\nread -p \"输入正则表达式: \" reg\r\nread -p \"输入替换内容: \" replacement\r\n\r\nfor f in `ls $src_dir` ;\r\ndo\r\n new_filename=`echo $f | sed \"s/$reg/$replacement/\"`\r\n #echo $src_dir/$f $src_dir/$new_filename\r\n mv $src_dir/$f $src_dir/$new_filename\r\ndone\r\n```\r\n\r\n', '<h2 id=\"h2-u601Du8DEF\"><a name=\"思路\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>思路</h2><ul>\r\n<li><code>ls dir</code>列出目录下的文件</li><li><code>sed</code> 替换文件名</li><li><code>mv</code>重命名</li></ul>\r\n<h2 id=\"h2-u811Au672C\"><a name=\"脚本\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>脚本</h2><pre><code class=\"lang-shell\">#!/bin/bash\r\n\r\n# 批量重命名文件\r\n\r\nread -p "输入源目录(请一次正确输入目录): " src_dir\r\n\r\n# 删除最后一个斜杠\r\nsrc_dir=${src_dir%\\/}\r\n\r\n# 判断目录是否存在\r\nif [ ! -d $src_dir ];\r\nthen\r\n echo "该目录不存在！"\r\n exit 2\r\nfi\r\n\r\n# 在 sed 中使用自定义变量要使用双引号(很谜)\r\nread -p "输入正则表达式: " reg\r\nread -p "输入替换内容: " replacement\r\n\r\nfor f in `ls $src_dir` ;\r\ndo\r\n new_filename=`echo $f | sed "s/$reg/$replacement/"`\r\n #echo $src_dir/$f $src_dir/$new_filename\r\n mv $src_dir/$f $src_dir/$new_filename\r\ndone\r\n</code></pre>\r\n', '2017-09-05 23:50:22', '354');
INSERT INTO `article` VALUES ('79', '1', '输入进程名终止进程', '## 思路\r\n\r\n- `ps -ef` 列出当前运行的进程\r\n- `grep -i process_name` 查找需要终止的进程\r\n- `awk` 找出进程 id \r\n- `xargs` 获取进程id,`kill -9` 强制终止进程\r\n\r\n\r\n\r\n## 脚本\r\n\r\n```shell\r\n#!/bin/bash\r\n# 输入进程名,终止进程\r\nread -p \"输入进程名: \" process\r\n\r\n#echo $process\r\nps -ef | grep -i $process | awk \'{ print $2; }\' | xargs kill -9 \r\n#ps -ef | grep -i $process | awk \' NR == 1 { print $2; }\' | xargs kill -9 | grep -i $process\r\n```\r\n\r\n\r\n\r\n## 运行结果\r\n\r\n', '<h2 id=\"h2-u601Du8DEF\"><a name=\"思路\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>思路</h2><ul>\r\n<li><code>ps -ef</code> 列出当前运行的进程</li><li><code>grep -i process_name</code> 查找需要终止的进程</li><li><code>awk</code> 找出进程 id </li><li><code>xargs</code> 获取进程id,<code>kill -9</code> 强制终止进程</li></ul>\r\n<h2 id=\"h2-u811Au672C\"><a name=\"脚本\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>脚本</h2><pre><code class=\"lang-shell\">#!/bin/bash\r\n# 输入进程名,终止进程\r\nread -p "输入进程名: " process\r\n\r\n#echo $process\r\nps -ef | grep -i $process | awk '{ print $2; }' | xargs kill -9 \r\n#ps -ef | grep -i $process | awk ' NR == 1 { print $2; }' | xargs kill -9 | grep -i $process\r\n</code></pre>\r\n<h2 id=\"h2-u8FD0u884Cu7ED3u679C\"><a name=\"运行结果\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>运行结果</h2><p><img src=\"https://github.com/programmerzzx/MarkdownPictures/blob/master/scripts/kill_process.PNG?raw=true\" alt=\"kill_process\"></p>\r\n', '2017-09-08 23:51:52', '173');
INSERT INTO `article` VALUES ('80', '1', '基于SpringBoot爬取教务处最新消息推送至邮箱', '## 简介 ([项目地址](https://github.com/programmerzzx/NewsCrawler))\r\n\r\n基于`SpringBoot`定时任务，每隔 1h 爬取[教务处消息](http://jwc.wyu.edu.cn/www/newslist.asp?id=51) ，若有新消息则发送至指定邮箱 。\r\n\r\n\r\n\r\n## 使用技术\r\n\r\n- JSoup\r\n- SpringBoot 定时任务,SpringBoot 邮件发送\r\n\r\n\r\n\r\n## 步骤\r\n\r\n- `.properties`文件配置邮箱服务\r\n- 创建`SpringBoot`定时任务\r\n- `JSoup`获取 [教务处](http://jwc.wyu.edu.cn/www/newslist.asp?id=51) 消息列表\r\n- 根据当天日期判断是否有新消息\r\n- 解析爬取消息具体的内容\r\n- 消息`url`作为 `HashMap` 键值去重(每隔`1h`，当天消息会重复)\r\n- `JavaMailSender`发送消息至邮箱', '<h2 id=\"h2--\"><a name=\"简介 ( 项目地址 )\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>简介 (<a href=\"https://github.com/programmerzzx/NewsCrawler\">项目地址</a>)</h2><p>基于<code>SpringBoot</code>定时任务，每隔 1h 爬取<a href=\"http://jwc.wyu.edu.cn/www/newslist.asp?id=51\">教务处消息</a> ，若有新消息则发送至指定邮箱 。</p>\r\n<h2 id=\"h2-u4F7Fu7528u6280u672F\"><a name=\"使用技术\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>使用技术</h2><ul>\r\n<li>JSoup</li><li>SpringBoot 定时任务,SpringBoot 邮件发送</li></ul>\r\n<h2 id=\"h2-u6B65u9AA4\"><a name=\"步骤\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>步骤</h2><ul>\r\n<li><code>.properties</code>文件配置邮箱服务</li><li>创建<code>SpringBoot</code>定时任务</li><li><code>JSoup</code>获取 <a href=\"http://jwc.wyu.edu.cn/www/newslist.asp?id=51\">教务处</a> 消息列表</li><li>根据当天日期判断是否有新消息</li><li>解析爬取消息具体的内容</li><li>消息<code>url</code>作为 <code>HashMap</code> 键值去重(每隔<code>1h</code>，当天消息会重复)</li><li><code>JavaMailSender</code>发送消息至邮箱</li></ul>\r\n', '2017-09-19 23:52:53', '49');
INSERT INTO `article` VALUES ('81', '1', '阿里云ESC(Debian 8) 搭建 FTP', '## 安装 `vsftpd`\r\n\r\n> `#apt-get install vsftpd -y`\r\n\r\n\r\n\r\n## 添加 FTP 用户及目录\r\n\r\n- 查 看`nologin`的位置\r\n\r\n > `#whereis nologin`\r\n\r\n- 创建用户,指定 `/ftp`为用户`ftpuser`的家目录\r\n\r\n > `#adduser -d /ftp -s /usr/sbin/nologin ftpuser `\r\n\r\n- 修改用户密码\r\n\r\n > `#passwd ftpuser`\r\n\r\n- 修改指定目录权限\r\n\r\n > `#chown -R ftpuser.ftpuser /ftp`\r\n\r\n\r\n\r\n## 配置 `vsftpd`\r\n\r\n- 编辑 `vsftp`配置文件\r\n\r\n > `#vi /etc/vsftpd.conf`\r\n\r\n - `anonymous_enable=YES` 改为`anonymous_enable=NO`\r\n - 取消注释(删除行首`#`即可)`#local_enable=YES`\r\n\r\n - 取消注释`#write_enable=YES`\r\n\r\n - 取消注释`#chroot_local_user=YES`\r\n\r\n - 取消注释`#ascii_upload_enable`\r\n\r\n - 取消注释`#ascii_download_enable`\r\n\r\n - 取消注释`#chroot_list_enable=YES`\r\n\r\n - 取消注释`#chroot_list_file=/etc/vsftpd.chroot_list`\r\n\r\n\r\n - 保存文件编辑`/etc/vsftpd.chroot_list`文件,将之前新建用户`ftpuser`添加到文件中,保存退出.\r\n\r\n\r\n\r\n\r\n## 修改 `shell`配置\r\n\r\n> `#vi /etc/shells`\r\n>\r\n> 如果文件中没有`/usr/sbin/nologin`或`/sbin/nologin`则添加进去\r\n\r\n\r\n\r\n## 测试\r\n\r\n> 启动服务`#service vsftpd start`\r\n>\r\n> 查看服务状态`#service vsftpd status`,显示`running`即启动成功,若不成功检查配置文件排查;\r\n\r\n', '<h2 id=\"h2--code-vsftpd-code-\"><a name=\"安装 <code>vsftpd</code>\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>安装 <code>vsftpd</code></h2><blockquote>\r\n<p><code>#apt-get install vsftpd -y</code></p>\r\n</blockquote>\r\n<h2 id=\"h2--ftp-\"><a name=\"添加 FTP 用户及目录\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>添加 FTP 用户及目录</h2><ul>\r\n<li><p>查 看<code>nologin</code>的位置</p>\r\n<blockquote>\r\n<p><code>#whereis nologin</code></p>\r\n</blockquote>\r\n</li><li><p>创建用户,指定 <code>/ftp</code>为用户<code>ftpuser</code>的家目录</p>\r\n<blockquote>\r\n<p><code>#adduser -d /ftp -s /usr/sbin/nologin ftpuser</code></p>\r\n</blockquote>\r\n</li><li><p>修改用户密码</p>\r\n<blockquote>\r\n<p><code>#passwd ftpuser</code></p>\r\n</blockquote>\r\n</li><li><p>修改指定目录权限</p>\r\n<blockquote>\r\n<p><code>#chown -R ftpuser.ftpuser /ftp</code></p>\r\n</blockquote>\r\n</li></ul>\r\n<h2 id=\"h2--code-vsftpd-code-\"><a name=\"配置 <code>vsftpd</code>\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>配置 <code>vsftpd</code></h2><ul>\r\n<li><p>编辑 <code>vsftp</code>配置文件</p>\r\n<blockquote>\r\n<p><code>#vi /etc/vsftpd.conf</code></p>\r\n</blockquote>\r\n<ul>\r\n<li><code>anonymous_enable=YES</code> 改为<code>anonymous_enable=NO</code></li><li><p>取消注释(删除行首<code>#</code>即可)<code>#local_enable=YES</code></p>\r\n</li><li><p>取消注释<code>#write_enable=YES</code></p>\r\n</li><li><p>取消注释<code>#chroot_local_user=YES</code></p>\r\n</li><li><p>取消注释<code>#ascii_upload_enable</code></p>\r\n</li><li><p>取消注释<code>#ascii_download_enable</code></p>\r\n</li><li><p>取消注释<code>#chroot_list_enable=YES</code></p>\r\n</li><li><p>取消注释<code>#chroot_list_file=/etc/vsftpd.chroot_list</code></p>\r\n</li></ul>\r\n</li></ul>\r\n<ul>\r\n<li>保存文件编辑<code>/etc/vsftpd.chroot_list</code>文件,将之前新建用户<code>ftpuser</code>添加到文件中,保存退出.</li></ul>\r\n<h2 id=\"h2--code-shell-code-\"><a name=\"修改 <code>shell</code>配置\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>修改 <code>shell</code>配置</h2><blockquote>\r\n<p> <code>#vi /etc/shells</code></p>\r\n<p> 如果文件中没有<code>/usr/sbin/nologin</code>或<code>/sbin/nologin</code>则添加进去</p>\r\n</blockquote>\r\n<h2 id=\"h2-u6D4Bu8BD5\"><a name=\"测试\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>测试</h2><blockquote>\r\n<p>启动服务<code>#service vsftpd start</code></p>\r\n<p>查看服务状态<code>#service vsftpd status</code>,显示<code>running</code>即启动成功,若不成功检查配置文件排查;</p>\r\n</blockquote>\r\n', '2017-09-21 17:54:12', '35');
INSERT INTO `article` VALUES ('82', '1', 'SpringBoot 常用配置', '> SpringBoot 常用配置\r\n\r\n\r\n\r\n```xml\r\n# mysql 连接\r\nspring.datasource.driver-class-name=com.mysql.jdbc.Driver\r\nspring.datasource.url=jdbc:mysql://localhost:3306/badblog?useUnicode=true&characterEncoding=utf8\r\nspring.datasource.username=root\r\nspring.datasource.password=root\r\n\r\nserver.session.tracking-modes=COOKIE\r\n\r\n# 控制台输出 sql 语句\r\nlogging.level.com.xing.mapper=DEBUG\r\n\r\n# \r\nspring.thymeleaf.cache=false\r\nspring.thymeleaf.mode=LEGACYHTML5\r\n\r\n# 日志输出\r\n#logging.file=BadBlog.log\r\n\r\n#邮箱配置\r\n#spring.mail.host=smtp.mxhichina.com\r\n#spring.mail.username=***\r\n#spring.mail.password=***\r\n#spring.mail.default-encoding=utf-8\r\n\r\nspring.mail.host=smtp.mxhichina.com\r\nspring.mail.port=465\r\[email protected]\r\nspring.mail.password=*******\r\nspring.mail.default-encoding=utf-8\r\n\r\nspring.mail.properties.mail.smtp.ssl.enable=true\r\nspring.mail.properties.mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory \r\nspring.mail.properties.mail.smtp.auth=true\r\nspring.mail.properties.mail.smtp.starttls.enable=true\r\nspring.mail.properties.mail.smtp.starttls.required=true\r\n\r\n\r\n# 修改内置 tomcat 端口\r\nserver.port=8888\r\n\r\n\r\n# 日志输出目录\r\nlogging.path=log\r\n```\r\n\r\n', '<blockquote>\r\n<p>SpringBoot 常用配置</p>\r\n</blockquote>\r\n<pre><code class=\"lang-xml\"># mysql 连接\r\nspring.datasource.driver-class-name=com.mysql.jdbc.Driver\r\nspring.datasource.url=jdbc:mysql://localhost:3306/badblog?useUnicode=true&characterEncoding=utf8\r\nspring.datasource.username=root\r\nspring.datasource.password=root\r\n\r\nserver.session.tracking-modes=COOKIE\r\n\r\n# 控制台输出 sql 语句\r\nlogging.level.com.xing.mapper=DEBUG\r\n\r\n# \r\nspring.thymeleaf.cache=false\r\nspring.thymeleaf.mode=LEGACYHTML5\r\n\r\n# 日志输出\r\n#logging.file=BadBlog.log\r\n\r\n#邮箱配置\r\n#spring.mail.host=smtp.mxhichina.com\r\n#spring.mail.username=***\r\n#spring.mail.password=***\r\n#spring.mail.default-encoding=utf-8\r\n\r\nspring.mail.host=smtp.mxhichina.com\r\nspring.mail.port=465\r\[email protected]\r\nspring.mail.password=*******\r\nspring.mail.default-encoding=utf-8\r\n\r\nspring.mail.properties.mail.smtp.ssl.enable=true\r\nspring.mail.properties.mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory \r\nspring.mail.properties.mail.smtp.auth=true\r\nspring.mail.properties.mail.smtp.starttls.enable=true\r\nspring.mail.properties.mail.smtp.starttls.required=true\r\n\r\n\r\n# 修改内置 tomcat 端口\r\nserver.port=8888\r\n\r\n\r\n# 日志输出目录\r\nlogging.path=log\r\n</code></pre>\r\n', '2017-09-23 13:55:17', '25');
INSERT INTO `article` VALUES ('83', '1', 'MyBatis 常用', '## foreach \r\n\r\n```java\r\n@Insert(\"<script>insert into article_category(`aid`,`cid`) values <foreach collection=\\\"list\\\" item=\\\"cid\\\" open=\\\"(\\\" separator=\\\"),(\\\" close=\\\")\\\">#{aid},#{cid}</foreach> </script>\")\r\n void insertRecords(@Param(\"aid\") Integer aid,@Param(\"list\")List<Integer> cidList);\r\n```\r\n\r\n\r\n\r\n## 返回插入主键 ID\r\n\r\n```java\r\n@Insert(\"INSERT INTO `article` (`uid`,`title`,`markdown`,`html`,`gmt_post`) VALUES (#{uid},#{title},#{markdown},#{html},NOW()) \")\r\n @SelectKey(statement = \"select LAST_INSERT_ID()\", keyProperty = \"aid\", keyColumn = \"aid\", before = false, resultType = int.class)\r\n @Results(value = {\r\n @Result(column = \"gmt_post\", property = \"gmtPost\", javaType = java.util.Date.class, jdbcType = JdbcType.TIMESTAMP)\r\n })\r\n```\r\n\r\n\r\n\r\n## ResultType\r\n\r\n```java\r\n@Select(\"SELECT `aid`,`uid`,`title`,`markdown`,`html`,`gmt_post`,`view` FROM `article` WHERE `aid` = #{aid} \")\r\n @Results(value = {@Result(id = true, property = \"aid\", column = \"aid\"),\r\n @Result(property = \"uid\", column = \"uid\"),\r\n @Result(property = \"title\", column = \"title\"),\r\n @Result(property = \"markdown\", column = \"markdown\"),\r\n @Result(property = \"html\", column = \"html\"),\r\n @Result(property = \"gmtPost\", column = \"gmt_post\", javaType = java.util.Date.class, jdbcType = JdbcType.TIMESTAMP),\r\n @Result(property = \"view\", column = \"view\")\r\n }\r\n )\r\n\r\nArticle getArticleByAid(@Param(\"aid\") Integer aid);\r\n```\r\n\r\n', '<h2 id=\"h2-foreach\"><a name=\"foreach\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>foreach</h2><pre><code class=\"lang-java\">@Insert("<script>insert into article_category(`aid`,`cid`) values <foreach collection=\\"list\\" item=\\"cid\\" open=\\"(\\" separator=\\"),(\\" close=\\")\\">#{aid},#{cid}</foreach> </script>")\r\n void insertRecords(@Param("aid") Integer aid,@Param("list")List<Integer> cidList);\r\n</code></pre>\r\n<h2 id=\"h2--id\"><a name=\"返回插入主键 ID\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>返回插入主键 ID</h2><pre><code class=\"lang-java\">@Insert("INSERT INTO `article` (`uid`,`title`,`markdown`,`html`,`gmt_post`) VALUES (#{uid},#{title},#{markdown},#{html},NOW()) ")\r\n @SelectKey(statement = "select LAST_INSERT_ID()", keyProperty = "aid", keyColumn = "aid", before = false, resultType = int.class)\r\n @Results(value = {\r\n @Result(column = "gmt_post", property = "gmtPost", javaType = java.util.Date.class, jdbcType = JdbcType.TIMESTAMP)\r\n })\r\n</code></pre>\r\n<h2 id=\"h2-resulttype\"><a name=\"ResultType\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>ResultType</h2><pre><code class=\"lang-java\">@Select("SELECT `aid`,`uid`,`title`,`markdown`,`html`,`gmt_post`,`view` FROM `article` WHERE `aid` = #{aid} ")\r\n @Results(value = {@Result(id = true, property = "aid", column = "aid"),\r\n @Result(property = "uid", column = "uid"),\r\n @Result(property = "title", column = "title"),\r\n @Result(property = "markdown", column = "markdown"),\r\n @Result(property = "html", column = "html"),\r\n @Result(property = "gmtPost", column = "gmt_post", javaType = java.util.Date.class, jdbcType = JdbcType.TIMESTAMP),\r\n @Result(property = "view", column = "view")\r\n }\r\n )\r\n\r\nArticle getArticleByAid(@Param("aid") Integer aid);\r\n</code></pre>\r\n', '2017-09-24 09:57:02', '22');
INSERT INTO `article` VALUES ('84', '1', 'MyBatis逆向工程', '- XML配置\r\n\r\n```xml\r\n<!DOCTYPE generatorConfiguration\r\n PUBLIC \"-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN\"\r\n \"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd\">\r\n<generatorConfiguration>\r\n <context id=\"context\" targetRuntime=\"MyBatis3\">\r\n <!--\r\n 数据库连接的信息：驱动类、连接地址、用户名、密码\r\n -->\r\n <jdbcConnection driverClass=\"com.mysql.jdbc.Driver\"\r\n connectionURL=\"jdbc:mysql://localhost:3306/mybatis\"\r\n userId=\"root\" password=\"root\" >\r\n </jdbcConnection>\r\n\r\n <!--\r\n 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和\r\n NUMERIC 类型解析为java.math.BigDecimal\r\n -->\r\n <javaTypeResolver >\r\n <property name=\"forceBigDecimals\" value=\"true\" />\r\n </javaTypeResolver>\r\n\r\n <!--\r\n 生成pojo\r\n targetProject:生成PO类的位置\r\n enableSubPackages:是否让schema作为包的后缀\r\n trimStrings:从数据库返回的值被清理前后的空格\r\n -->\r\n <javaModelGenerator targetPackage=\"po\" targetProject=\".\\src\">\r\n <property name=\"enableSubPackages\" value=\"false\" />\r\n <property name=\"trimStrings\" value=\"true\" />\r\n </javaModelGenerator>\r\n\r\n <!--\r\n 生成mapper.xml\r\n -->\r\n <sqlMapGenerator targetPackage=\"mapper\" targetProject=\".\\src\">\r\n <property name=\"enableSubPackages\" value=\"false\" />\r\n </sqlMapGenerator>\r\n\r\n <!--\r\n 生成mapper\r\n -->\r\n <javaClientGenerator type=\"XMLMAPPER\" targetPackage=\"mapper\" targetProject=\".\\src\">\r\n <property name=\"enableSubPackages\" value=\"false\" />\r\n </javaClientGenerator>\r\n <!--\r\n 指定数据库表\r\n -->\r\n <table tableName=\"user\"></table>\r\n <table tableName=\"items\"></table>\r\n <table tableName=\"orders\"></table>\r\n <table tableName=\"orderdetail\"></table>\r\n </context>\r\n</generatorConfiguration>\r\n```\r\n\r\n\r\n\r\n- 测试代码\r\n```java\r\nimport java.io.File;\r\nimport java.util.ArrayList;\r\nimport java.util.List;\r\n\r\npublic class MyBatisGeneratorTest {\r\n public static void main(String[] args) throws Exception {\r\n List<String> warnings = new ArrayList<String>();\r\n boolean overwrite = true;\r\n String path = \"G:\\\\program\\\\IdeaProjects\\\\Framework\\\\MyBatisGenerator\\\\src\\\\config\\\\generatorConfig.xml\";\r\n //File configFile = new File(\"generatorConfig.xml\");\r\n File configFile = new File(path);\r\n ConfigurationParser cp = new ConfigurationParser(warnings);\r\n Configuration config = cp.parseConfiguration(configFile);\r\n DefaultShellCallback callback = new DefaultShellCallback(overwrite);\r\n MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);\r\n myBatisGenerator.generate(null);\r\n }\r\n}\r\n```', '<ul>\r\n<li>XML配置</li></ul>\r\n<pre><code class=\"lang-xml\"><!DOCTYPE generatorConfiguration\r\n PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"\r\n "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">\r\n<generatorConfiguration>\r\n <context id="context" targetRuntime="MyBatis3">\r\n <!--\r\n 数据库连接的信息：驱动类、连接地址、用户名、密码\r\n -->\r\n <jdbcConnection driverClass="com.mysql.jdbc.Driver"\r\n connectionURL="jdbc:mysql://localhost:3306/mybatis"\r\n userId="root" password="root" >\r\n </jdbcConnection>\r\n\r\n <!--\r\n 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和\r\n NUMERIC 类型解析为java.math.BigDecimal\r\n -->\r\n <javaTypeResolver >\r\n <property name="forceBigDecimals" value="true" />\r\n </javaTypeResolver>\r\n\r\n <!--\r\n 生成pojo\r\n targetProject:生成PO类的位置\r\n enableSubPackages:是否让schema作为包的后缀\r\n trimStrings:从数据库返回的值被清理前后的空格\r\n -->\r\n <javaModelGenerator targetPackage="po" targetProject=".\\src">\r\n <property name="enableSubPackages" value="false" />\r\n <property name="trimStrings" value="true" />\r\n </javaModelGenerator>\r\n\r\n <!--\r\n 生成mapper.xml\r\n -->\r\n <sqlMapGenerator targetPackage="mapper" targetProject=".\\src">\r\n <property name="enableSubPackages" value="false" />\r\n </sqlMapGenerator>\r\n\r\n <!--\r\n 生成mapper\r\n -->\r\n <javaClientGenerator type="XMLMAPPER" targetPackage="mapper" targetProject=".\\src">\r\n <property name="enableSubPackages" value="false" />\r\n </javaClientGenerator>\r\n <!--\r\n 指定数据库表\r\n -->\r\n <table tableName="user"></table>\r\n <table tableName="items"></table>\r\n <table tableName="orders"></table>\r\n <table tableName="orderdetail"></table>\r\n </context>\r\n</generatorConfiguration>\r\n</code></pre>\r\n<ul>\r\n<li>测试代码<br>```java<br>import java.io.File;<br>import java.util.ArrayList;<br>import java.util.List;</li></ul>\r\n<p>public class MyBatisGeneratorTest {<br> public static void main(String[] args) throws Exception {<br> List<String> warnings = new ArrayList<String>();<br> boolean overwrite = true;<br> String path = “G:\\program\\IdeaProjects\\Framework\\MyBatisGenerator\\src\\config\\generatorConfig.xml”;<br> //File configFile = new File(“generatorConfig.xml”);<br> File configFile = new File(path);<br> ConfigurationParser cp = new ConfigurationParser(warnings);<br> Configuration config = cp.parseConfiguration(configFile);<br> DefaultShellCallback callback = new DefaultShellCallback(overwrite);<br> MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);<br> myBatisGenerator.generate(null);<br> }<br>}<br>```</p>\r\n', '2017-09-25 10:01:27', '6');
INSERT INTO `article` VALUES ('85', '1', 'SpringMVC 拦截器', '- 新建 Interceptor (实现 HandlerInterceptor)\r\n\r\n ```java\r\n import org.springframework.stereotype.Component;\r\n import org.springframework.web.servlet.HandlerInterceptor;\r\n import org.springframework.web.servlet.ModelAndView;\r\n \r\n import javax.servlet.http.HttpServletRequest;\r\n import javax.servlet.http.HttpServletResponse;\r\n \r\n @Component\r\n public class MarkdownInterceptor implements HandlerInterceptor {\r\n @Override\r\n public boolean preHandle(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o) throws Exception {\r\n System.out.println(\"markdown interceptor preHandle run ......\");\r\n return true;\r\n }\r\n \r\n @Override\r\n public void postHandle(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, ModelAndView modelAndView) throws Exception {\r\n System.out.println(\"markdown interceptor postHandle run ......\" + httpServletRequest.getRequestURI() );\r\n }\r\n \r\n @Override\r\n public void afterCompletion(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, Exception e) throws Exception {\r\n System.out.println(\"markdown interceptor afterCompletion run ......\");\r\n }\r\n }\r\n ```\r\n\r\n- 配置拦截路径(继承`WebMvcConfigurerAdapter` 覆盖`addInterceptors` 方法)\r\n\r\n ```java\r\n @SpringBootApplication\r\n public class EditormdApplication extends WebMvcConfigurerAdapter {\r\n \r\n @Autowired\r\n private MarkdownInterceptor markdownInterceptor;\r\n \r\n public static void main(String[] args) {\r\n SpringApplication.run(EditormdApplication.class, args);\r\n }\r\n \r\n @Override\r\n public void addInterceptors(InterceptorRegistry registry) {\r\n super.addInterceptors(registry);\r\n registry.addInterceptor(markdownInterceptor).addPathPatterns(\"/**\");\r\n }\r\n }\r\n ```\r\n\r\n ', '<ul>\r\n<li><p>新建 Interceptor (实现 HandlerInterceptor)</p>\r\n<pre><code class=\"lang-java\">import org.springframework.stereotype.Component;\r\nimport org.springframework.web.servlet.HandlerInterceptor;\r\nimport org.springframework.web.servlet.ModelAndView;\r\n\r\nimport javax.servlet.http.HttpServletRequest;\r\nimport javax.servlet.http.HttpServletResponse;\r\n\r\n<a href=\"https://github.com/Component\" title=\"@Component\" class=\"at-link\">@Component</a>\r\npublic class MarkdownInterceptor implements HandlerInterceptor {\r\n <a href=\"https://github.com/Override\" title=\"@Override\" class=\"at-link\">@Override</a>\r\n public boolean preHandle(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o) throws Exception {\r\n System.out.println("markdown interceptor preHandle run ......");\r\n return true;\r\n }\r\n\r\n <a href=\"https://github.com/Override\" title=\"@Override\" class=\"at-link\">@Override</a>\r\n public void postHandle(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, ModelAndView modelAndView) throws Exception {\r\n System.out.println("markdown interceptor postHandle run ......" + httpServletRequest.getRequestURI() );\r\n }\r\n\r\n <a href=\"https://github.com/Override\" title=\"@Override\" class=\"at-link\">@Override</a>\r\n public void afterCompletion(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, Exception e) throws Exception {\r\n System.out.println("markdown interceptor afterCompletion run ......");\r\n }\r\n}\r\n</code></pre>\r\n</li><li><p>配置拦截路径(继承<code>WebMvcConfigurerAdapter</code> 覆盖<code>addInterceptors</code> 方法)</p>\r\n<pre><code class=\"lang-java\"><a href=\"https://github.com/SpringBootApplication\" title=\"@SpringBootApplication\" class=\"at-link\">@SpringBootApplication</a>\r\npublic class EditormdApplication extends WebMvcConfigurerAdapter {\r\n\r\n <a href=\"https://github.com/Autowired\" title=\"@Autowired\" class=\"at-link\">@Autowired</a>\r\n private MarkdownInterceptor markdownInterceptor;\r\n\r\n public static void main(String[] args) {\r\n SpringApplication.run(EditormdApplication.class, args);\r\n }\r\n\r\n <a href=\"https://github.com/Override\" title=\"@Override\" class=\"at-link\">@Override</a>\r\n public void addInterceptors(InterceptorRegistry registry) {\r\n super.addInterceptors(registry);\r\n registry.addInterceptor(markdownInterceptor).addPathPatterns("/**");\r\n }\r\n}\r\n</code></pre>\r\n<p></p>\r\n</li></ul>\r\n', '2017-09-26 19:02:44', '3');
INSERT INTO `article` VALUES ('86', '1', 'SpringMVC checkbox 提交', '- HTML 页面(请求参数 name=\"category\" )\r\n\r\n ```html\r\n <div class=\"row\">\r\n <div class=\"col s1 offset-s1\">\r\n <input type=\"checkbox\" name=\"category\" id=\"category1\" value=\"Default\" />\r\n <label for=\"category1\">Default</label>\r\n </div>\r\n <div class=\"col s1\">\r\n <input type=\"checkbox\" name=\"category\" id=\"category2\" value=\"Spring\" />\r\n <label for=\"category2\">Spring</label>\r\n </div>\r\n <div class=\"col s1\">\r\n <input type=\"checkbox\" name=\"category\" id=\"category3\" value=\"随笔\" />\r\n <label for=\"category3\">随笔</label>\r\n </div>\r\n <div class=\"col s1\">\r\n <input type=\"checkbox\" name=\"category\" id=\"category4\" value=\"MySQL\" />\r\n <label for=\"category4\">MySQL</label>\r\n </div>\r\n <div class=\"col s1\">\r\n <input type=\"checkbox\" name=\"category\" id=\"category5\" value=\"JavaScript\" />\r\n <label for=\"category5\">JavaScript</label>\r\n </div>\r\n <div class=\"col s1\">\r\n <input type=\"checkbox\" name=\"category\" id=\"category6\" value=\"SpringMVC\" />\r\n <label for=\"category6\">SpringMVC</label>\r\n </div>\r\n <div class=\"col s1\">\r\n <input type=\"checkbox\" name=\"category\" id=\"category7\" value=\"Python\" />\r\n <label for=\"category7\">Python</label>\r\n </div>\r\n <div class=\"col s1\">\r\n <input type=\"checkbox\" name=\"category\" id=\"category8\" value=\"CSS\" />\r\n <label for=\"category8\">CSS</label>\r\n </div>\r\n <div class=\"col s1\">\r\n <input type=\"checkbox\" name=\"category\" id=\"category9\" value=\"Linux\" />\r\n <label for=\"category9\">Linux</label>\r\n </div>\r\n </div>\r\n ```\r\n\r\n- SpringMVC \r\n\r\n ```java\r\n @PostMapping(\"/article/publish\")\r\n public String publishArticle(@RequestParam(\"title\") String title,\r\n @RequestParam(\"content\") String content,\r\n @RequestParam(\"category\") String[] category) {\r\n System.out.println(title);\r\n System.out.println(content);\r\n System.out.println(category.length);\r\n for (int i = 0; i < category.length; i++) {\r\n System.out.println(category[i]);\r\n }\r\n return \"displayArticle\";\r\n }\r\n ```\r\n\r\n \r\n\r\n', '<ul>\r\n<li><p>HTML 页面(请求参数 name=”category” )</p>\r\n<pre><code class=\"lang-html\"><div class="row">\r\n <div class="col s1 offset-s1">\r\n <input type="checkbox" name="category" id="category1" value="Default" />\r\n <label for="category1">Default</label>\r\n </div>\r\n <div class="col s1">\r\n <input type="checkbox" name="category" id="category2" value="Spring" />\r\n <label for="category2">Spring</label>\r\n </div>\r\n <div class="col s1">\r\n <input type="checkbox" name="category" id="category3" value="随笔" />\r\n <label for="category3">随笔</label>\r\n </div>\r\n <div class="col s1">\r\n <input type="checkbox" name="category" id="category4" value="MySQL" />\r\n <label for="category4">MySQL</label>\r\n </div>\r\n <div class="col s1">\r\n <input type="checkbox" name="category" id="category5" value="JavaScript" />\r\n <label for="category5">JavaScript</label>\r\n </div>\r\n <div class="col s1">\r\n <input type="checkbox" name="category" id="category6" value="SpringMVC" />\r\n <label for="category6">SpringMVC</label>\r\n </div>\r\n <div class="col s1">\r\n <input type="checkbox" name="category" id="category7" value="Python" />\r\n <label for="category7">Python</label>\r\n </div>\r\n <div class="col s1">\r\n <input type="checkbox" name="category" id="category8" value="CSS" />\r\n <label for="category8">CSS</label>\r\n </div>\r\n <div class="col s1">\r\n <input type="checkbox" name="category" id="category9" value="Linux" />\r\n <label for="category9">Linux</label>\r\n </div>\r\n</div>\r\n</code></pre>\r\n</li><li><p>SpringMVC </p>\r\n<pre><code class=\"lang-java\"><a href=\"https://github.com/PostMapping\" title=\"@PostMapping\" class=\"at-link\">@PostMapping</a>("/article/publish")\r\n public String publishArticle(<a href=\"https://github.com/RequestParam\" title=\"@RequestParam\" class=\"at-link\">@RequestParam</a>("title") String title,\r\n <a href=\"https://github.com/RequestParam\" title=\"@RequestParam\" class=\"at-link\">@RequestParam</a>("content") String content,\r\n <a href=\"https://github.com/RequestParam\" title=\"@RequestParam\" class=\"at-link\">@RequestParam</a>("category") String[] category) {\r\n System.out.println(title);\r\n System.out.println(content);\r\n System.out.println(category.length);\r\n for (int i = 0; i < category.length; i++) {\r\n System.out.println(category[i]);\r\n }\r\n return "displayArticle";\r\n }\r\n</code></pre>\r\n<p></p>\r\n</li></ul>\r\n', '2017-09-28 18:03:24', '3');
INSERT INTO `article` VALUES ('87', '1', 'Thymeleaf 常用', '\r\n### 不移除html标签\r\n\r\n- th:inline=\'text\'\r\n\r\n```html\r\n<span class=\"right-align\" th:inline=\"text\">\r\n 作者:[[ ${article.username} ]]\r\n </span>\r\n```\r\n\r\n\r\n\r\n### 格式化时间\r\n\r\n```html\r\n${#dates.format(article.post,\"YYYY-MM-dd HH:mm:ss\")}\r\n```\r\n\r\n\r\n\r\n### 转移 html 源码\r\n\r\n```html\r\n使用 th:utext\r\n```\r\n\r\n\r\n\r\n### 解决 html 标签限制\r\n\r\n- `pom.xml` 中添加依赖\r\n\r\n ```xml\r\n <dependency>\r\n <groupId>net.sourceforge.nekohtml</groupId>\r\n <artifactId>nekohtml</artifactId>\r\n <version>1.9.22</version>\r\n </dependency>\r\n ```\r\n\r\n- `application.properties` 中添加如下行\r\n\r\n ```xml\r\n spring.thymeleaf.cache=false\r\n spring.thymeleaf.mode=LEGACYHTML5\r\n ```\r\n\r\n ', '<h3 id=\"h3--html-\"><a name=\"不移除html标签\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>不移除html标签</h3><ul>\r\n<li>th:inline=’text’</li></ul>\r\n<pre><code class=\"lang-html\"><span class="right-align" th:inline="text">\r\n 作者:[[ ${article.username} ]]\r\n </span>\r\n</code></pre>\r\n<h3 id=\"h3-u683Cu5F0Fu5316u65F6u95F4\"><a name=\"格式化时间\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>格式化时间</h3><pre><code class=\"lang-html\">${#dates.format(article.post,"YYYY-MM-dd HH:mm:ss")}\r\n</code></pre>\r\n<h3 id=\"h3--html-\"><a name=\"转移 html 源码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>转移 html 源码</h3><pre><code class=\"lang-html\">使用 th:utext\r\n</code></pre>\r\n<h3 id=\"h3--html-\"><a name=\"解决 html 标签限制\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>解决 html 标签限制</h3><ul>\r\n<li><p><code>pom.xml</code> 中添加依赖</p>\r\n<pre><code class=\"lang-xml\"><dependency>\r\n <groupId>net.sourceforge.nekohtml</groupId>\r\n <artifactId>nekohtml</artifactId>\r\n <version>1.9.22</version>\r\n</dependency>\r\n</code></pre>\r\n</li><li><p><code>application.properties</code> 中添加如下行</p>\r\n<pre><code class=\"lang-xml\">spring.thymeleaf.cache=false\r\nspring.thymeleaf.mode=LEGACYHTML5\r\n</code></pre>\r\n<p></p>\r\n</li></ul>\r\n', '2017-08-29 23:04:34', '19');
INSERT INTO `article` VALUES ('88', '1', '分页', '> SpringBoot 中使用分页\r\n\r\n\r\n\r\n## Java 对象\r\n\r\n- `Page` 对象\r\n\r\n```java\r\npublic class Page {\r\n private int everyPage; //每页显示记录数\r\n private int totalCount; //总记录数\r\n private int totalPage; //总页数\r\n private int currentPage; //当前页\r\n private int startIndex; //数据库查询起始点\r\n private boolean hasPrePage; //是否有上一页\r\n private boolean hasNextPage; //是否有下一页\r\n\r\n public Page() {\r\n }\r\n\r\n public Page(int everyPage, int totalCount, int totalPage, int currentPage, int startIndex, boolean hasPrePage, boolean hasNextPage) {\r\n this.everyPage = everyPage;\r\n this.totalCount = totalCount;\r\n this.totalPage = totalPage;\r\n this.currentPage = currentPage;\r\n this.startIndex = startIndex;\r\n this.hasPrePage = hasPrePage;\r\n this.hasNextPage = hasNextPage;\r\n }\r\n\r\n public int getEveryPage() {\r\n return everyPage;\r\n }\r\n public void setEveryPage(int everyPage) {\r\n this.everyPage = everyPage;\r\n }\r\n public int getTotalCount() {\r\n return totalCount;\r\n }\r\n public void setTotalCount(int totalCount) {\r\n this.totalCount = totalCount;\r\n }\r\n public int getTotalPage() {\r\n return totalPage;\r\n }\r\n public void setTotalPage(int totalPage) {\r\n this.totalPage = totalPage;\r\n }\r\n public int getCurrentPage() {\r\n return currentPage;\r\n }\r\n public void setCurrentPage(int currentPage) {\r\n this.currentPage = currentPage;\r\n }\r\n public int getStartIndex() {\r\n return startIndex;\r\n }\r\n public void setStartIndex(int startIndex) {\r\n this.startIndex = startIndex;\r\n }\r\n public boolean isHasPrePage() {\r\n return hasPrePage;\r\n }\r\n public void setHasPrePage(boolean hasPrePage) {\r\n this.hasPrePage = hasPrePage;\r\n }\r\n public boolean isHasNextPage() {\r\n return hasNextPage;\r\n }\r\n public void setHasNextPage(boolean hasNextPage) {\r\n this.hasNextPage = hasNextPage;\r\n }\r\n}\r\n```\r\n\r\n- `PageUtil` 对象\r\n\r\n```java\r\npublic class PageUtil {\r\n //通过 每页显示数,总记录数,当前页构造Page\r\n public static Page createPage(int everyPage, int totalCount, int currentPage) {\r\n everyPage = everyPage == 0 ? 5 : everyPage;\r\n currentPage = currentPage < 1 ? 1 : currentPage;\r\n int totalPage = getTotalPage(everyPage, totalCount);\r\n int startIndex = (currentPage - 1) * everyPage;\r\n boolean hasPrePage = currentPage <= 1 ? false : true;\r\n boolean hasNextPage = ((currentPage == totalPage) || (totalPage == 0)) ? false : true;\r\n return new Page(everyPage,totalCount,totalPage,currentPage,startIndex,hasPrePage,hasNextPage);\r\n }\r\n\r\n private static int getTotalPage(int everyPage, int totalCount) {\r\n int totalPage = 0;\r\n if (totalCount != 0 && totalCount % everyPage == 0) {\r\n totalPage = totalCount / everyPage;\r\n } else {\r\n totalPage = (totalCount / everyPage) + 1;\r\n }\r\n return totalPage;\r\n }\r\n\r\n}\r\n```\r\n\r\n\r\n\r\n## MySQL\r\n\r\n```sql\r\nSELECT * FROM `article` LIMIT #{startIndex},#{count} \r\n```\r\n\r\n\r\n\r\n## Thymeleaf\r\n\r\n```html\r\n<div class=\"text-center\">\r\n <nav aria-label=\"Page navigation\">\r\n <ul class=\"pagination pagination-lg\">\r\n <li th:if=\"${page.hasPrePage}\">\r\n <a th:href=\"@{\'/p/\' + ${ page.currentPage - 1} }\" aria-label=\"Previous\">\r\n <span aria-hidden=\"true\">«</span>\r\n </a>\r\n </li>\r\n\r\n <li>\r\n <a href=\"/p/1\">首页</a>\r\n </li>\r\n <!-- 最多显示 7 页 -->\r\n <li th:each=\"p : ${#numbers.sequence( (page.totalPage - page.currentPage < 7) ? (page.totalPage - 7 > 0 ? page.totalPage - 7:1) :page.currentPage , page.currentPage + 7 < page.totalPage ? page.currentPage + 7 : page.totalPage )}\"\r\n th:class=\"${p == page.currentPage ? \'active\' :\'\' }\">\r\n <a th:href=\"@{\'/p/\' + ${p} }\" th:text=\"${p}\"></a>\r\n </li>\r\n\r\n <li>\r\n <a th:href=\"@{ \'/p/\' +${page.totalPage} }\">尾页</a>\r\n </li>\r\n\r\n <li th:if=\"${page.hasNextPage}\">\r\n <a th:href=\"@{\'/p/\' + ${ page.currentPage + 1} }\" aria-label=\"Next\">\r\n <span aria-hidden=\"true\">»</span>\r\n </a>\r\n </li>\r\n\r\n\r\n </ul>\r\n </nav>\r\n <div>\r\n <div class=\"form-inline\">\r\n <div class=\"form-group\">\r\n <div class=\"input-group\">\r\n <div class=\"input-group-addon\" th:inline=\"text\">共[[${page.totalPage}]]页</div>\r\n <input id=\"totalPage\" type=\"hidden\" th:value=\"${page.totalPage}\">\r\n <input type=\"text\" class=\"form-control\" id=\"jumpTo\" placeholder=\"跳转页\"\r\n required=\"required\">\r\n </div>\r\n </div>\r\n <button type=\"button\" class=\"btn btn-primary\" onclick=\"jumpTo();\">跳转</button>\r\n </div>\r\n </div>\r\n </div>\r\n```\r\n\r\n', '<blockquote>\r\n<p>SpringBoot 中使用分页</p>\r\n</blockquote>\r\n<h2 id=\"h2-java-\"><a name=\"Java 对象\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Java 对象</h2><ul>\r\n<li><code>Page</code> 对象</li></ul>\r\n<pre><code class=\"lang-java\">public class Page {\r\n private int everyPage; //每页显示记录数\r\n private int totalCount; //总记录数\r\n private int totalPage; //总页数\r\n private int currentPage; //当前页\r\n private int startIndex; //数据库查询起始点\r\n private boolean hasPrePage; //是否有上一页\r\n private boolean hasNextPage; //是否有下一页\r\n\r\n public Page() {\r\n }\r\n\r\n public Page(int everyPage, int totalCount, int totalPage, int currentPage, int startIndex, boolean hasPrePage, boolean hasNextPage) {\r\n this.everyPage = everyPage;\r\n this.totalCount = totalCount;\r\n this.totalPage = totalPage;\r\n this.currentPage = currentPage;\r\n this.startIndex = startIndex;\r\n this.hasPrePage = hasPrePage;\r\n this.hasNextPage = hasNextPage;\r\n }\r\n\r\n public int getEveryPage() {\r\n return everyPage;\r\n }\r\n public void setEveryPage(int everyPage) {\r\n this.everyPage = everyPage;\r\n }\r\n public int getTotalCount() {\r\n return totalCount;\r\n }\r\n public void setTotalCount(int totalCount) {\r\n this.totalCount = totalCount;\r\n }\r\n public int getTotalPage() {\r\n return totalPage;\r\n }\r\n public void setTotalPage(int totalPage) {\r\n this.totalPage = totalPage;\r\n }\r\n public int getCurrentPage() {\r\n return currentPage;\r\n }\r\n public void setCurrentPage(int currentPage) {\r\n this.currentPage = currentPage;\r\n }\r\n public int getStartIndex() {\r\n return startIndex;\r\n }\r\n public void setStartIndex(int startIndex) {\r\n this.startIndex = startIndex;\r\n }\r\n public boolean isHasPrePage() {\r\n return hasPrePage;\r\n }\r\n public void setHasPrePage(boolean hasPrePage) {\r\n this.hasPrePage = hasPrePage;\r\n }\r\n public boolean isHasNextPage() {\r\n return hasNextPage;\r\n }\r\n public void setHasNextPage(boolean hasNextPage) {\r\n this.hasNextPage = hasNextPage;\r\n }\r\n}\r\n</code></pre>\r\n<ul>\r\n<li><code>PageUtil</code> 对象</li></ul>\r\n<pre><code class=\"lang-java\">public class PageUtil {\r\n //通过 每页显示数,总记录数,当前页构造Page\r\n public static Page createPage(int everyPage, int totalCount, int currentPage) {\r\n everyPage = everyPage == 0 ? 5 : everyPage;\r\n currentPage = currentPage < 1 ? 1 : currentPage;\r\n int totalPage = getTotalPage(everyPage, totalCount);\r\n int startIndex = (currentPage - 1) * everyPage;\r\n boolean hasPrePage = currentPage <= 1 ? false : true;\r\n boolean hasNextPage = ((currentPage == totalPage) || (totalPage == 0)) ? false : true;\r\n return new Page(everyPage,totalCount,totalPage,currentPage,startIndex,hasPrePage,hasNextPage);\r\n }\r\n\r\n private static int getTotalPage(int everyPage, int totalCount) {\r\n int totalPage = 0;\r\n if (totalCount != 0 && totalCount % everyPage == 0) {\r\n totalPage = totalCount / everyPage;\r\n } else {\r\n totalPage = (totalCount / everyPage) + 1;\r\n }\r\n return totalPage;\r\n }\r\n\r\n}\r\n</code></pre>\r\n<h2 id=\"h2-mysql\"><a name=\"MySQL\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>MySQL</h2><pre><code class=\"lang-sql\">SELECT * FROM `article` LIMIT #{startIndex},#{count}\r\n</code></pre>\r\n<h2 id=\"h2-thymeleaf\"><a name=\"Thymeleaf\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Thymeleaf</h2><pre><code class=\"lang-html\"><div class="text-center">\r\n <nav aria-label="Page navigation">\r\n <ul class="pagination pagination-lg">\r\n <li th:if="${page.hasPrePage}">\r\n <a th:href="@{'/p/' + ${ page.currentPage - 1} }" aria-label="Previous">\r\n <span aria-hidden="true">&laquo;</span>\r\n </a>\r\n </li>\r\n\r\n <li>\r\n <a href="/p/1">首页</a>\r\n </li>\r\n <!-- 最多显示 7 页 -->\r\n <li th:each="p : ${#numbers.sequence( (page.totalPage - page.currentPage < 7) ? (page.totalPage - 7 > 0 ? page.totalPage - 7:1) :page.currentPage , page.currentPage + 7 < page.totalPage ? page.currentPage + 7 : page.totalPage )}"\r\n th:class="${p == page.currentPage ? 'active' :'' }">\r\n <a th:href="@{'/p/' + ${p} }" th:text="${p}"></a>\r\n </li>\r\n\r\n <li>\r\n <a th:href="@{ '/p/' +${page.totalPage} }">尾页</a>\r\n </li>\r\n\r\n <li th:if="${page.hasNextPage}">\r\n <a th:href="@{'/p/' + ${ page.currentPage + 1} }" aria-label="Next">\r\n <span aria-hidden="true">&raquo;</span>\r\n </a>\r\n </li>\r\n\r\n\r\n </ul>\r\n </nav>\r\n <div>\r\n <div class="form-inline">\r\n <div class="form-group">\r\n <div class="input-group">\r\n <div class="input-group-addon" th:inline="text">共[[${page.totalPage}]]页</div>\r\n <input id="totalPage" type="hidden" th:value="${page.totalPage}">\r\n <input type="text" class="form-control" id="jumpTo" placeholder="跳转页"\r\n required="required">\r\n </div>\r\n </div>\r\n <button type="button" class="btn btn-primary" onclick="jumpTo();">跳转</button>\r\n </div>\r\n </div>\r\n </div>\r\n</code></pre>\r\n', '2017-10-01 00:05:23', '14');
INSERT INTO `article` VALUES ('89', '1', '归档', '### Java\r\n\r\n```java\r\n@RequestMapping(\"/article/archive\")\r\n public String archive(Model model, HttpSession session) {\r\n User user = (User) session.getAttribute(\"user\");\r\n if (user == null) {\r\n user = new User();\r\n user.setUid(1);\r\n }\r\n //所有文章\r\n List<Article> articleList = articleService.listArticleByUid(user.getUid());\r\n\r\n /*\r\n *\r\n * 按年月归类\r\n * */\r\n\r\n LinkedHashMap<Integer, LinkedHashMap<Integer, ArrayList<Article>>> articleMap = new LinkedHashMap();\r\n\r\n articleList.forEach(article -> {\r\n Calendar calendar = Calendar.getInstance();\r\n calendar.setTime(article.getGmtPost());\r\n Integer year = calendar.get(Calendar.YEAR);\r\n Integer month = calendar.get(Calendar.MONTH) + 1;\r\n\r\n LinkedHashMap<Integer, ArrayList<Article>> monthMap = articleMap.get(year);\r\n if (monthMap == null) {\r\n monthMap = new LinkedHashMap<>();\r\n }\r\n ArrayList<Article> articles = monthMap.get(month);\r\n if (articles == null) {\r\n articles = new ArrayList<>();\r\n }\r\n articles.add(article);\r\n monthMap.put(month, articles);\r\n articleMap.put(year, monthMap);\r\n\r\n });\r\n\r\n model.addAttribute(\"articleMap\", articleMap);\r\n return \"article/archiveArticle\";\r\n }\r\n```\r\n\r\n\r\n\r\n### HTML\r\n\r\n```html\r\n<div class=\"row\" th:unless=\"${#maps.size(articleMap) == 0 }\">\r\n <div class=\"col-md-10\">\r\n <div class=\"panel panel-default\">\r\n <div class=\"panel-body\" th:each=\"map : ${articleMap}\" th:id=\"${map.key}\">\r\n <h2 th:inline=\"text\">[[${map.key}]] 年</h2>\r\n <hr class=\"divider\">\r\n <div th:each=\"month:${map.value}\">\r\n <div class=\"list-group\">\r\n <div class=\"list-group-item\" th:id=\"${ map.key + \'-\' + month.key }\" role=\"tab\">\r\n <a th:inline=\"text\" th:href=\"@{\'#collapse\' + ${map.key} + ${month.key} }\"\r\n role=\"button\"\r\n data-toggle=\"collapse\" th:attr=\"data-parent= ${\'#\'+ map.key}\"\r\n th:attrappend=\"aria-controls=${\'#collapse\' + map.key + month.key }\">\r\n <span class=\"glyphicon glyphicon-calendar\"></span>\r\n [[${month.key}]]月 ([[${#lists.size(month.value)}]]篇)\r\n </a>\r\n </div>\r\n </div>\r\n <div th:id=\"${\'collapse\'+ map.key + month.key }\" class=\"panel-collapse collapse\"\r\n role=\"tabpanel\"\r\n th:attr=\"aria-labelledby=${ map.key + \'-\' + month.key }\">\r\n\r\n <div class=\"list-group\">\r\n <a th:each=\"article:${month.value}\"\r\n th:href=\"@{\'/article/display/\' + ${article.aid} }\"\r\n class=\"list-group-item\" th:inline=\"text\" target=\"_blank\">\r\n <span class=\"glyphicon glyphicon-book\"></span> \r\n [[${#dates.format(article.gmtPost,\"dd\")}]]日: \r\n <strong>[[${article.title}]]</strong>\r\n </a>\r\n </div>\r\n\r\n </div>\r\n\r\n </div>\r\n </div>\r\n </div>\r\n </div>\r\n <div class=\"col-md-2\">\r\n <div class=\"list-group\" style=\"position: fixed;width: 10%;\">\r\n <a id=\"showHide\" href=\"javascript:void(0);\" class=\"list-group-item active\">\r\n <span class=\"glyphicon glyphicon-plus\"></span> \r\n 文章归档\r\n </a>\r\n <a class=\"list-group-item\" th:each=\"map : ${articleMap}\" th:href=\"@{\'#\' + ${map.key} }\"\r\n th:inline=\"text\">\r\n [[${map.key}]]年\r\n </a>\r\n </div>\r\n </div>\r\n </div>\r\n```\r\n\r\n', '<h3 id=\"h3-java\"><a name=\"Java\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>Java</h3><pre><code class=\"lang-java\">@RequestMapping("/article/archive")\r\n public String archive(Model model, HttpSession session) {\r\n User user = (User) session.getAttribute("user");\r\n if (user == null) {\r\n user = new User();\r\n user.setUid(1);\r\n }\r\n //所有文章\r\n List<Article> articleList = articleService.listArticleByUid(user.getUid());\r\n\r\n /*\r\n *\r\n * 按年月归类\r\n * */\r\n\r\n LinkedHashMap<Integer, LinkedHashMap<Integer, ArrayList<Article>>> articleMap = new LinkedHashMap();\r\n\r\n articleList.forEach(article -> {\r\n Calendar calendar = Calendar.getInstance();\r\n calendar.setTime(article.getGmtPost());\r\n Integer year = calendar.get(Calendar.YEAR);\r\n Integer month = calendar.get(Calendar.MONTH) + 1;\r\n\r\n LinkedHashMap<Integer, ArrayList<Article>> monthMap = articleMap.get(year);\r\n if (monthMap == null) {\r\n monthMap = new LinkedHashMap<>();\r\n }\r\n ArrayList<Article> articles = monthMap.get(month);\r\n if (articles == null) {\r\n articles = new ArrayList<>();\r\n }\r\n articles.add(article);\r\n monthMap.put(month, articles);\r\n articleMap.put(year, monthMap);\r\n\r\n });\r\n\r\n model.addAttribute("articleMap", articleMap);\r\n return "article/archiveArticle";\r\n }\r\n</code></pre>\r\n<h3 id=\"h3-html\"><a name=\"HTML\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>HTML</h3><pre><code class=\"lang-html\"><div class="row" th:unless="${#maps.size(articleMap) == 0 }">\r\n <div class="col-md-10">\r\n <div class="panel panel-default">\r\n <div class="panel-body" th:each="map : ${articleMap}" th:id="${map.key}">\r\n <h2 th:inline="text">[[${map.key}]] 年</h2>\r\n <hr class="divider">\r\n <div th:each="month:${map.value}">\r\n <div class="list-group">\r\n <div class="list-group-item" th:id="${ map.key + '-' + month.key }" role="tab">\r\n <a th:inline="text" th:href="@{'#collapse' + ${map.key} + ${month.key} }"\r\n role="button"\r\n data-toggle="collapse" th:attr="data-parent= ${'#'+ map.key}"\r\n th:attrappend="aria-controls=${'#collapse' + map.key + month.key }">\r\n &nbsp;&nbsp;<span class="glyphicon glyphicon-calendar"></span>\r\n [[${month.key}]]月 ([[${#lists.size(month.value)}]]篇)\r\n </a>\r\n </div>\r\n </div>\r\n <div th:id="${'collapse'+ map.key + month.key }" class="panel-collapse collapse"\r\n role="tabpanel"\r\n th:attr="aria-labelledby=${ map.key + '-' + month.key }">\r\n\r\n <div class="list-group">\r\n <a th:each="article:${month.value}"\r\n th:href="@{'/article/display/' + ${article.aid} }"\r\n class="list-group-item" th:inline="text" target="_blank">\r\n &nbsp;&nbsp;&nbsp;&nbsp;<span class="glyphicon glyphicon-book"></span>&nbsp;&nbsp;\r\n [[${#dates.format(article.gmtPost,"dd")}]]日: &nbsp;&nbsp;\r\n <strong>[[${article.title}]]</strong>\r\n </a>\r\n </div>\r\n\r\n </div>\r\n\r\n </div>\r\n </div>\r\n </div>\r\n </div>\r\n <div class="col-md-2">\r\n <div class="list-group" style="position: fixed;width: 10%;">\r\n <a id="showHide" href="javascript:void(0);" class="list-group-item active">\r\n <span class="glyphicon glyphicon-plus"></span> &nbsp;&nbsp;\r\n 文章归档\r\n </a>\r\n <a class="list-group-item" th:each="map : ${articleMap}" th:href="@{'#' + ${map.key} }"\r\n th:inline="text">\r\n [[${map.key}]]年\r\n </a>\r\n </div>\r\n </div>\r\n </div>\r\n</code></pre>\r\n', '2017-10-02 00:06:08', '7');
INSERT INTO `article` VALUES ('90', '1', '返回顶部', '## HTML 代码\r\n\r\n```html\r\n<a id=\"toTop\" href=\"javascript:toTop()\" data-toggle=\"tooltip\" data-placement=\"left\" title=\"返回顶部\"\r\n style=\"display:none;position: fixed;bottom:20px;background-color:#333333;right:30px;z-index: 99;border:none;outline:none;padding:15px;cursor: pointer;border-radius: 5px;\">\r\n <span class=\"glyphicon glyphicon-chevron-up\"></span>\r\n</a>\r\n```\r\n\r\n\r\n\r\n## JS 代码\r\n\r\n```javascript\r\n// 显示和隐藏\r\nfunction scrollFunction() {\r\n var scrollTop = document.documentElement.scrollTop || window.pageYOffset || document.body.scrollTop;\r\n\r\n if (scrollTop > 120) {\r\n $(\"#toTop\").fadeIn(\"slow\");\r\n } else {\r\n $(\"#toTop\").css(\"display\",\"none\");\r\n }\r\n\r\n}\r\n\r\n// 点击返回顶部\r\nfunction toTop() {\r\n $(\"html,body\").animate({scrollTop: 0}, 500);\r\n}\r\n```\r\n\r\n', '<h2 id=\"h2-html-\"><a name=\"HTML 代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>HTML 代码</h2><pre><code class=\"lang-html\"><a id="toTop" href="javascript:toTop()" data-toggle="tooltip" data-placement="left" title="返回顶部"\r\n style="display:none;position: fixed;bottom:20px;background-color:#333333;right:30px;z-index: 99;border:none;outline:none;padding:15px;cursor: pointer;border-radius: 5px;">\r\n <span class="glyphicon glyphicon-chevron-up"></span>\r\n</a>\r\n</code></pre>\r\n<h2 id=\"h2-js-\"><a name=\"JS 代码\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>JS 代码</h2><pre><code class=\"lang-javascript\">// 显示和隐藏\r\nfunction scrollFunction() {\r\n var scrollTop = document.documentElement.scrollTop || window.pageYOffset || document.body.scrollTop;\r\n\r\n if (scrollTop > 120) {\r\n $("#toTop").fadeIn("slow");\r\n } else {\r\n $("#toTop").css("display","none");\r\n }\r\n\r\n}\r\n\r\n// 点击返回顶部\r\nfunction toTop() {\r\n $("html,body").animate({scrollTop: 0}, 500);\r\n}\r\n</code></pre>\r\n', '2017-08-03 00:06:53', '7');
INSERT INTO `article` VALUES ('91', '1', '背景粒子效果', '\r\n### HTML\r\n\r\n```html\r\n<body>\r\n <canvas class=\"background\"></canvas>\r\n ......\r\n</body>\r\n```\r\n\r\n\r\n\r\n## CSS\r\n\r\n```css\r\n.background {\r\n position: absolute;\r\n display: block;\r\n top: 0;\r\n left: 0;\r\n z-index: 0;\r\n }\r\n```\r\n\r\n\r\n\r\n## JS\r\n\r\n```javascript\r\n<!-- 引入 particles.min.js -->\r\n<script th:src=\"@{/js/particles.min.js}\"></script>\r\n\r\n// 加载粒子效果\r\nfunction loadParticles() {\r\n\r\n Particles.init({\r\n selector: \'.background\',\r\n color: \"#3c763d\",\r\n connectParticles: true,\r\n speed: 1.5,\r\n });\r\n}\r\n\r\nwindow.onload = function () {\r\n loadParticles();\r\n};\r\n```\r\n\r\n', '<h3 id=\"h3-html\"><a name=\"HTML\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>HTML</h3><pre><code class=\"lang-html\"><body>\r\n <canvas class="background"></canvas>\r\n ......\r\n</body>\r\n</code></pre>\r\n<h2 id=\"h2-css\"><a name=\"CSS\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>CSS</h2><pre><code class=\"lang-css\">.background {\r\n position: absolute;\r\n display: block;\r\n top: 0;\r\n left: 0;\r\n z-index: 0;\r\n }\r\n</code></pre>\r\n<h2 id=\"h2-js\"><a name=\"JS\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>JS</h2><pre><code class=\"lang-javascript\"><!-- 引入 particles.min.js -->\r\n<script th:src="@{/js/particles.min.js}"></script>\r\n\r\n// 加载粒子效果\r\nfunction loadParticles() {\r\n\r\n Particles.init({\r\n selector: '.background',\r\n color: "#3c763d",\r\n connectParticles: true,\r\n speed: 1.5,\r\n });\r\n}\r\n\r\nwindow.onload = function () {\r\n loadParticles();\r\n};\r\n</code></pre>\r\n', '2017-10-04 00:07:41', '7');
INSERT INTO `article` VALUES ('92', '1', '导航条的显示与隐藏', '> 滚动条下滚隐藏导航条，上滚显示导航条\r\n\r\n## HTML\r\n\r\n- 导航条\r\n\r\n ```html\r\n <nav id=\"navbar\" class=\"navbar navbar-default navbar-fixed-top\">\r\n <div class=\"container-fluid\">\r\n <div class=\"navbar-header\">\r\n <button aria-controls=\"navbar-collapse\" aria-expanded=\"false\" class=\"navbar-toggle collapsed\"\r\n data-target=\"#navbar-collapse\" data-toggle=\"collapse\" type=\"button\">\r\n <span class=\"sr-only\">Toggle navigation</span>\r\n <span class=\"icon-bar\"></span>\r\n <span class=\"icon-bar\"></span>\r\n <span class=\"icon-bar\"></span>\r\n </button>\r\n <a class=\"navbar-brand\" href=\"/\">BadBlog</a>\r\n </div>\r\n <div class=\"collapse navbar-collapse\" id=\"navbar-collapse\">\r\n <ul class=\"nav navbar-nav\">\r\n <li><a href=\"/\">首页</a></li>\r\n <li><a href=\"/create\">新建</a></li>\r\n <li><a href=\"/manage/article\">管理</a></li>\r\n <li><a href=\"/category/all\">分类</a></li>\r\n <li><a href=\"/article/archive\"></span> 归档</a></li>\r\n <li><a href=\"https://github.com/programmerzzx/BadBlog/blob/master/README.md\" target=\"_blank\">关于</a></li>\r\n </ul>\r\n <form class=\"navbar-form navbar-left\" action=\"/search\">\r\n <div class=\"form-group\">\r\n <input id=\"search\" name=\"keyword\" type=\"text\" class=\"form-control\" placeholder=\"搜索\" required>\r\n </div>\r\n <button type=\"submit\" class=\"btn btn-default\">\r\n <span class=\"glyphicon glyphicon-search\"></span>\r\n </button>\r\n </form>\r\n </div>\r\n </div>\r\n </nav>\r\n ```\r\n\r\n \r\n\r\n\r\n\r\n## JS \r\n\r\n```javascript\r\nfunction showOrHide() {\r\n // 获取浏览器名称\r\n var agent = navigator.userAgent;\r\n var scrollTop = document.documentElement.scrollTop || window.pageYOffset || document.body.scrollTop;\r\n if (/.*Firefox.*/.test(agent)) {\r\n document.addEventListener(\"DOMMouseScroll\", function (e) {\r\n e = e || window.event;\r\n var detail = e.detail;\r\n // console.log(\"火狐上滚还是下滚: \" + e.detail);\r\n if (detail > 0 && scrollTop > 100) {\r\n $(\"#navbar\").css(\"display\", \"none\");\r\n } else {\r\n $(\"#navbar\").css(\"display\", \"block\");\r\n }\r\n });\r\n } else {\r\n document.onmousewheel = function (e) {\r\n e = e || window.event;\r\n var wheelDelta = e.wheelDelta;\r\n if (wheelDelta > 0 || scrollTop < 100) {\r\n $(\"#navbar\").css(\"display\", \"block\");\r\n } else {\r\n $(\"#navbar\").css(\"display\", \"none\");\r\n }\r\n }\r\n }\r\n\r\n}\r\n\r\n\r\nwindow.onscroll = function () {\r\n showOrHide();\r\n};\r\n```\r\n\r\n\r\n\r\n', '<blockquote>\r\n<p>滚动条下滚隐藏导航条，上滚显示导航条</p>\r\n</blockquote>\r\n<h2 id=\"h2-html\"><a name=\"HTML\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>HTML</h2><ul>\r\n<li><p>导航条</p>\r\n<pre><code class=\"lang-html\"><nav id="navbar" class="navbar navbar-default navbar-fixed-top">\r\n <div class="container-fluid">\r\n <div class="navbar-header">\r\n <button aria-controls="navbar-collapse" aria-expanded="false" class="navbar-toggle collapsed"\r\n data-target="#navbar-collapse" data-toggle="collapse" type="button">\r\n <span class="sr-only">Toggle navigation</span>\r\n <span class="icon-bar"></span>\r\n <span class="icon-bar"></span>\r\n <span class="icon-bar"></span>\r\n </button>\r\n <a class="navbar-brand" href="/">BadBlog</a>\r\n </div>\r\n <div class="collapse navbar-collapse" id="navbar-collapse">\r\n <ul class="nav navbar-nav">\r\n <li><a href="/">首页</a></li>\r\n <li><a href="/create">新建</a></li>\r\n <li><a href="/manage/article">管理</a></li>\r\n <li><a href="/category/all">分类</a></li>\r\n <li><a href="/article/archive"></span> 归档</a></li>\r\n <li><a href="https://github.com/programmerzzx/BadBlog/blob/master/README.md" target="_blank">关于</a></li>\r\n </ul>\r\n <form class="navbar-form navbar-left" action="/search">\r\n <div class="form-group">\r\n <input id="search" name="keyword" type="text" class="form-control" placeholder="搜索" required>\r\n </div>\r\n <button type="submit" class="btn btn-default">\r\n <span class="glyphicon glyphicon-search"></span>\r\n </button>\r\n </form>\r\n </div>\r\n </div>\r\n</nav>\r\n</code></pre>\r\n<p></p>\r\n</li></ul>\r\n<h2 id=\"h2-js\"><a name=\"JS\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>JS</h2><pre><code class=\"lang-javascript\">function showOrHide() {\r\n // 获取浏览器名称\r\n var agent = navigator.userAgent;\r\n var scrollTop = document.documentElement.scrollTop || window.pageYOffset || document.body.scrollTop;\r\n if (/.*Firefox.*/.test(agent)) {\r\n document.addEventListener("DOMMouseScroll", function (e) {\r\n e = e || window.event;\r\n var detail = e.detail;\r\n // console.log("火狐上滚还是下滚: " + e.detail);\r\n if (detail > 0 && scrollTop > 100) {\r\n $("#navbar").css("display", "none");\r\n } else {\r\n $("#navbar").css("display", "block");\r\n }\r\n });\r\n } else {\r\n document.onmousewheel = function (e) {\r\n e = e || window.event;\r\n var wheelDelta = e.wheelDelta;\r\n if (wheelDelta > 0 || scrollTop < 100) {\r\n $("#navbar").css("display", "block");\r\n } else {\r\n $("#navbar").css("display", "none");\r\n }\r\n }\r\n }\r\n\r\n}\r\n\r\n\r\nwindow.onscroll = function () {\r\n showOrHide();\r\n};\r\n</code></pre>\r\n', '2017-08-05 00:08:40', '4');
INSERT INTO `article` VALUES ('93', '1', 'Sublime Text 3 配置', '```xml\r\n{\r\n \"auto_find_in_selection\": true,\r\n \"bold_folder_labels\": true,\r\n \"color_scheme\": \"Packages/Color Scheme - Default/Solarized (Dark).tmTheme\",\r\n \"default_line_ending\": \"unix\",\r\n \"draw_minimap_border\": true,\r\n \"ensure_newline_at_eof_on_save\": true,\r\n \"fade_fold_buttons\": false,\r\n \"font_face\": \"Source Code Pro\",\r\n \"font_size\": 14,\r\n \"highlight_line\": true,\r\n \"highlight_modified_tabs\": true,\r\n \"ignored_packages\":\r\n [\r\n \"Vintage\"\r\n ],\r\n \"save_on_focus_lost\": true,\r\n \"translate_tabs_to_spaces\": true,\r\n \"trim_automatic_white_space\": true,\r\n \"trim_trailing_white_space_on_save\": true,\r\n \"update_check\": false,\r\n \"word_wrap\": \"true\"\r\n}\r\n```\r\n\r\n', '<pre><code class=\"lang-xml\">{\r\n "auto_find_in_selection": true,\r\n "bold_folder_labels": true,\r\n "color_scheme": "Packages/Color Scheme - Default/Solarized (Dark).tmTheme",\r\n "default_line_ending": "unix",\r\n "draw_minimap_border": true,\r\n "ensure_newline_at_eof_on_save": true,\r\n "fade_fold_buttons": false,\r\n "font_face": "Source Code Pro",\r\n "font_size": 14,\r\n "highlight_line": true,\r\n "highlight_modified_tabs": true,\r\n "ignored_packages":\r\n [\r\n "Vintage"\r\n ],\r\n "save_on_focus_lost": true,\r\n "translate_tabs_to_spaces": true,\r\n "trim_automatic_white_space": true,\r\n "trim_trailing_white_space_on_save": true,\r\n "update_check": false,\r\n "word_wrap": "true"\r\n}\r\n</code></pre>\r\n', '2017-08-06 00:09:25', '6');
INSERT INTO `article` VALUES ('94', '1', 'VIM配置', '```xml\r\nif v:lang =~ \"utf8$\" || v:lang =~ \"UTF-8$\"\r\n set fileencodings=utf-8,latin1\r\nendif\r\nset syntax=on\r\nset tabstop=4\r\nset softtabstop=4\r\nset shiftwidth=4\r\nset nobackup\r\nset nu\r\nset nocompatible \" Use Vim defaults (much better!)\r\nset bs=indent,eol,start \" allow backspacing over everything in insert mode\r\n\"set ai \" always set autoindenting on\r\n\"set backup \" keep a backup file\r\nset viminfo=\'20,\\\"50 \" read/write a .viminfo file, don\'t store more\r\n \" than 50 lines of registers\r\nset history=50 \" keep 50 lines of command line history\r\nset ruler \" show the cursor position all the time\r\n\r\n\" Only do this part when compiled with support for autocommands\r\nif has(\"autocmd\")\r\n augroup redhat\r\n \" In text files, always limit the width of text to 78 characters\r\n autocmd BufRead *.txt set tw=78\r\n \" When editing a file, always jump to the last cursor position\r\n autocmd BufReadPost *\r\n \\ if line(\"\'\\\"\") > 0 && line (\"\'\\\"\") <= line(\"$\") |\r\n \\ exe \"normal! g\'\\\"\" |\r\n \\ endif\r\n augroup END\r\nendif\r\n\r\nif has(\"cscope\") && filereadable(\"/usr/bin/cscope\")\r\n set csprg=/usr/bin/cscope\r\n set csto=0\r\n set cst\r\n set nocsverb\r\n \" add any database in current directory\r\n if filereadable(\"cscope.out\")\r\n cs add cscope.out\r\n \" else add database pointed to by environment\r\n elseif $CSCOPE_DB != \"\"\r\n cs add $CSCOPE_DB\r\n endif\r\n set csverb\r\nendif\r\n\r\n\" Switch syntax highlighting on, when the terminal has colors\r\n\" Also switch on highlighting the last used search pattern.\r\nif &t_Co > 2 || has(\"gui_running\")\r\n syntax on\r\n set hlsearch\r\nendif\r\n\r\nif &term==\"xterm\"\r\n set t_Co=8\r\n set t_Sb=[4%dm\r\n set t_Sf=[3%dm\r\nendif\r\n```\r\n\r\n', '<pre><code class=\"lang-xml\">if v:lang =~ "utf8$" || v:lang =~ "UTF-8$"\r\n set fileencodings=utf-8,latin1\r\nendif\r\nset syntax=on\r\nset tabstop=4\r\nset softtabstop=4\r\nset shiftwidth=4\r\nset nobackup\r\nset nu\r\nset nocompatible " Use Vim defaults (much better!)\r\nset bs=indent,eol,start " allow backspacing over everything in insert mode\r\n"set ai " always set autoindenting on\r\n"set backup " keep a backup file\r\nset viminfo='20,\\"50 " read/write a .viminfo file, don't store more\r\n " than 50 lines of registers\r\nset history=50 " keep 50 lines of command line history\r\nset ruler " show the cursor position all the time\r\n\r\n" Only do this part when compiled with support for autocommands\r\nif has("autocmd")\r\n augroup redhat\r\n " In text files, always limit the width of text to 78 characters\r\n autocmd BufRead *.txt set tw=78\r\n " When editing a file, always jump to the last cursor position\r\n autocmd BufReadPost *\r\n \\ if line("'\\"") > 0 && line ("'\\"") <= line("$") |\r\n \\ exe "normal! g'\\"" |\r\n \\ endif\r\n augroup END\r\nendif\r\n\r\nif has("cscope") && filereadable("/usr/bin/cscope")\r\n set csprg=/usr/bin/cscope\r\n set csto=0\r\n set cst\r\n set nocsverb\r\n " add any database in current directory\r\n if filereadable("cscope.out")\r\n cs add cscope.out\r\n " else add database pointed to by environment\r\n elseif $CSCOPE_DB != ""\r\n cs add $CSCOPE_DB\r\n endif\r\n set csverb\r\nendif\r\n\r\n" Switch syntax highlighting on, when the terminal has colors\r\n" Also switch on highlighting the last used search pattern.\r\nif &t_Co > 2 || has("gui_running")\r\n syntax on\r\n set hlsearch\r\nendif\r\n\r\nif &term=="xterm"\r\n set t_Co=8\r\n set t_Sb=[4%dm\r\n set t_Sf=[3%dm\r\nendif\r\n</code></pre>\r\n', '2016-12-08 00:09:56', '2');
INSERT INTO `article` VALUES ('95', '1', '反射学习', '- 测试对象\r\n\r\n ```java\r\n public class Person {\r\n public String name = \"HelloWorld\";\r\n private int age;\r\n\r\n public Person(String name) {\r\n System.out.println(\"public Person(String name) constructor...\");\r\n }\r\n\r\n private Person(int age) {\r\n System.out.println(\"private Person(int age) constructor...\");\r\n }\r\n\r\n public Person() {\r\n System.out.println(\"public Person() constructor...\");\r\n }\r\n\r\n public static void main(String[] args) {\r\n System.out.println(\"main run...\");\r\n }\r\n }\r\n ```\r\n\r\n- 反射剖析\r\n\r\n ```java\r\n import java.lang.reflect.Constructor;\r\n import java.lang.reflect.Field;\r\n import java.lang.reflect.Method;\r\n\r\n public class Reflect {\r\n public static void main(String[] args) throws Exception {\r\n /*\r\n * 反射:加载类并解剖出类的各个组成成分\r\n *\r\n * 1.获取字节码对象\r\n * |-- Class.forName();\r\n * |-- 对象.getClass();\r\n * |-- 数据类型.class; void.class\r\n * 2.获取函数\r\n * |--获取构造函数\r\n * |-- 调用Class的getConstructor(Class<?>... parameterTypes)方法\r\n * |--获取一般函数\r\n * |-- 1.调用Class的getMethod(String methodName,Class<?>... parameterTypes);\r\n * 2.执行函数，调用Method类的 Object invoke(Object obj, Object... args);\r\n * |--获取私有函数\r\n * |-- 1.获取私有成员,调用的是Class的getDeclared*()方法\r\n * 2.setAccessible(true);\r\n *\r\n * 3.获取字段\r\n * |--获取非私有字段\r\n * 1.调用的是Class的getField(String name)方法\r\n * 2.可以通过Field类的getType(),get()方法获取字段类型和值;\r\n * |--获取私有字段\r\n * 1.调用Class的getDeclaredField();\r\n * 2.setAccessible(true);\r\n * */\r\n\r\n // accessClass();\r\n\r\n // accessConstructor();\r\n\r\n // accessMethod();\r\n\r\n accessField();\r\n }\r\n\r\n private static void accessField() throws Exception {\r\n /*\r\n * 获取字段\r\n *\r\n * 1.获取字节码对象\r\n *\r\n * 2.调用字节码对象的getFiled()方法 ; 参数为字段名\r\n * public Field getField(String name)\r\n throws NoSuchFieldException,\r\n SecurityException\r\n 3.调用Field的get()方法获取字段值\r\n public Object get(Object obj)\r\n throws IllegalArgumentException,\r\n IllegalAccessException\r\n\r\n ps:Field的getType()方法可以获取字段类型\r\n * */\r\n\r\n Class clazz = Class.forName(\"Person\");\r\n //获取字段\r\n Field field = clazz.getField(\"name\");\r\n\r\n //获取值\r\n String value=(String) field.get(new Person());\r\n System.out.println(value);\r\n\r\n }\r\n\r\n private static void accessMethod() throws Exception {\r\n /*\r\n * 获取方法\r\n *\r\n * 1.获取字节码对象\r\n *\r\n * 2.调用字节码对象的getMethod()方法; name.equals(方法名); parameterTypes参数类型的字节码对象\r\n * public Method getMethod(String name,\r\n Class<?>... parameterTypes)\r\n throws NoSuchMethodException,\r\n SecurityException\r\n * 3.调用Method类的invoke(); obj就是调用此方法的对象\r\n * public Object invoke(Object obj,\r\n Object... args)\r\n throws IllegalAccessException,\r\n IllegalArgumentException,\r\n InvocationTargetException\r\n *\r\n * */\r\n\r\n //获取main函数\r\n\r\n Person p = new Person();\r\n Class clazz = Class.forName(\"Person\");\r\n Method method=clazz.getMethod(\"main\",String[].class);\r\n method.invoke(p,new Object[]{new String[]{\"Hello\",\"World\"}});\r\n ```\r\n\r\n\r\n }\r\n\r\n\r\n private static void accessConstructor() throws Exception {\r\n\r\n /*\r\n * 获取构造函数\r\n *\r\n * 1.获取字节码对象\r\n *\r\n * 2.调用字节码对象的getConstructor()方法;\r\n public Constructor<T> getConstructor(Class<?>... parameterTypes)\r\n throws NoSuchMethodException,SecurityException\r\n \r\n * 3.通过Constructor的newInstance()方法构造相对应的实例\r\n * public T newInstance(Object... initargs)\r\n throws InstantiationException,\r\n IllegalAccessException,\r\n IllegalArgumentException,\r\n InvocationTargetException\r\n\r\n\r\n ps:setAccessible可以用来访问私有成员。(暴力反射)\r\n 而且当访问私有成员时调用的是getDeclared*()的函数;\r\n \r\n * */\r\n \r\n Class clazz = Class.forName(\"Person\");\r\n Constructor con=clazz.getDeclaredConstructor(String.class);\r\n Person p=(Person)con.newInstance();\r\n\r\n\r\n /*\r\n * 访问私有构造函数private Person(int age)\r\n * Class clazz = Class.forName(\"Person\");\r\n *\r\n * Constructor con=clazz.getDeclaredConstructor(int.class);\r\n *\r\n * con.setAccessible(true);\r\n *\r\n * Person p=(Person)con.newInstance(24);\r\n * */\r\n \r\n }\r\n \r\n private static void accessClass() throws Exception {\r\n \r\n /*\r\n * 获取字节码对象的方式\r\n *\r\n 1.public static Class<?> forName(String className) throws ClassNotFoundException\r\n 2.对象.getclass(); Person p = new Person(); Class clazz=p.getClass();\r\n 3.类名.class Clazz clazz=Person.class;或 int.class void.class...\r\n * */\r\n \r\n Class clazz = Class.forName(\"Person\");\r\n System.out.println(clazz);\r\n \r\n /*Person p = new Person();\r\n Class clazz=p.getClass();\r\n System.out.println(clazz);*/\r\n \r\n /*Class clazz=Person.class;\r\n System.out.println(clazz);*/\r\n \r\n }\r\n\r\n }\r\n ```\r\n\r\n \r\n ```', '<ul>\r\n<li><p>测试对象</p>\r\n<pre><code class=\"lang-java\">public class Person {\r\n public String name = "HelloWorld";\r\n private int age;\r\n\r\n public Person(String name) {\r\n System.out.println("public Person(String name) constructor...");\r\n }\r\n\r\n private Person(int age) {\r\n System.out.println("private Person(int age) constructor...");\r\n }\r\n\r\n public Person() {\r\n System.out.println("public Person() constructor...");\r\n }\r\n\r\n public static void main(String[] args) {\r\n System.out.println("main run...");\r\n }\r\n}\r\n</code></pre>\r\n</li><li><p>反射剖析</p>\r\n<pre><code class=\"lang-java\">import java.lang.reflect.Constructor;\r\nimport java.lang.reflect.Field;\r\nimport java.lang.reflect.Method;\r\n\r\npublic class Reflect {\r\n public static void main(String[] args) throws Exception {\r\n /*\r\n * 反射:加载类并解剖出类的各个组成成分\r\n *\r\n * 1.获取字节码对象\r\n * |-- Class.forName();\r\n * |-- 对象.getClass();\r\n * |-- 数据类型.class; void.class\r\n * 2.获取函数\r\n * |--获取构造函数\r\n * |-- 调用Class的getConstructor(Class<?>... parameterTypes)方法\r\n * |--获取一般函数\r\n * |-- 1.调用Class的getMethod(String methodName,Class<?>... parameterTypes);\r\n * 2.执行函数，调用Method类的 Object invoke(Object obj, Object... args);\r\n * |--获取私有函数\r\n * |-- 1.获取私有成员,调用的是Class的getDeclared*()方法\r\n * 2.setAccessible(true);\r\n *\r\n * 3.获取字段\r\n * |--获取非私有字段\r\n * 1.调用的是Class的getField(String name)方法\r\n * 2.可以通过Field类的getType(),get()方法获取字段类型和值;\r\n * |--获取私有字段\r\n * 1.调用Class的getDeclaredField();\r\n * 2.setAccessible(true);\r\n * */\r\n\r\n// accessClass();\r\n\r\n// accessConstructor();\r\n\r\n// accessMethod();\r\n\r\n accessField();\r\n }\r\n\r\n private static void accessField() throws Exception {\r\n /*\r\n * 获取字段\r\n *\r\n * 1.获取字节码对象\r\n *\r\n * 2.调用字节码对象的getFiled()方法 ; 参数为字段名\r\n * public Field getField(String name)\r\n throws NoSuchFieldException,\r\n SecurityException\r\n 3.调用Field的get()方法获取字段值\r\n public Object get(Object obj)\r\n throws IllegalArgumentException,\r\n IllegalAccessException\r\n\r\n ps:Field的getType()方法可以获取字段类型\r\n * */\r\n\r\n Class clazz = Class.forName("Person");\r\n //获取字段\r\n Field field = clazz.getField("name");\r\n\r\n //获取值\r\n String value=(String) field.get(new Person());\r\n System.out.println(value);\r\n\r\n }\r\n\r\n private static void accessMethod() throws Exception {\r\n /*\r\n * 获取方法\r\n *\r\n * 1.获取字节码对象\r\n *\r\n * 2.调用字节码对象的getMethod()方法; name.equals(方法名); parameterTypes参数类型的字节码对象\r\n * public Method getMethod(String name,\r\n Class<?>... parameterTypes)\r\n throws NoSuchMethodException,\r\n SecurityException\r\n * 3.调用Method类的invoke(); obj就是调用此方法的对象\r\n * public Object invoke(Object obj,\r\n Object... args)\r\n throws IllegalAccessException,\r\n IllegalArgumentException,\r\n InvocationTargetException\r\n *\r\n * */\r\n\r\n //获取main函数\r\n\r\n Person p = new Person();\r\n Class clazz = Class.forName("Person");\r\n Method method=clazz.getMethod("main",String[].class);\r\n method.invoke(p,new Object[]{new String[]{"Hello","World"}});\r\n</code></pre>\r\n</li></ul>\r\n<pre><code>}\r\n\r\n\r\nprivate static void accessConstructor() throws Exception {\r\n\r\n /*\r\n * 获取构造函数\r\n *\r\n * 1.获取字节码对象\r\n *\r\n * 2.调用字节码对象的getConstructor()方法;\r\n public Constructor<T> getConstructor(Class<?>... parameterTypes)\r\n throws NoSuchMethodException,SecurityException\r\n\r\n * 3.通过Constructor的newInstance()方法构造相对应的实例\r\n * public T newInstance(Object... initargs)\r\n throws InstantiationException,\r\n IllegalAccessException,\r\n IllegalArgumentException,\r\n InvocationTargetException\r\n\r\n\r\n ps:setAccessible可以用来访问私有成员。(暴力反射)\r\n 而且当访问私有成员时调用的是getDeclared*()的函数;\r\n\r\n * */\r\n\r\n Class clazz = Class.forName("Person");\r\n Constructor con=clazz.getDeclaredConstructor(String.class);\r\n Person p=(Person)con.newInstance();\r\n\r\n\r\n /*\r\n * 访问私有构造函数private Person(int age)\r\n * Class clazz = Class.forName("Person");\r\n *\r\n * Constructor con=clazz.getDeclaredConstructor(int.class);\r\n *\r\n * con.setAccessible(true);\r\n *\r\n * Person p=(Person)con.newInstance(24);\r\n * */\r\n\r\n}\r\n\r\nprivate static void accessClass() throws Exception {\r\n\r\n /*\r\n * 获取字节码对象的方式\r\n *\r\n 1.public static Class<?> forName(String className) throws ClassNotFoundException\r\n 2.对象.getclass(); Person p = new Person(); Class clazz=p.getClass();\r\n 3.类名.class Clazz clazz=Person.class;或 int.class void.class...\r\n * */\r\n\r\n Class clazz = Class.forName("Person");\r\n System.out.println(clazz);\r\n\r\n /*Person p = new Person();\r\n Class clazz=p.getClass();\r\n System.out.println(clazz);*/\r\n\r\n /*Class clazz=Person.class;\r\n System.out.println(clazz);*/\r\n\r\n}\r\n</code></pre><p> }</p>\r\n<pre><code>\r\n\r\n</code></pre>', '2016-12-16 00:10:43', '7');
INSERT INTO `article` VALUES ('96', '1', '标签云特效实现', '> 标签云特效\r\n\r\n\r\n\r\n### HTML \r\n\r\n```html\r\n<div id=\"tagscloud\">\r\n <a target=\"_blank\" class=\"tagc1\" href=\"/category/all#1\">SpringMVC</a>\r\n <a target=\"_blank\" class=\"tagc2\" href=\"/category/all#2\">MyBatis</a>\r\n <a target=\"_blank\" class=\"tagc0\" href=\"/category/all#3\">Thymeleaf</a>\r\n <a target=\"_blank\" class=\"tagc1\" href=\"/category/all#4\">SpringBoot</a>\r\n <a target=\"_blank\" class=\"tagc2\" href=\"/category/all#5\">Shell</a>\r\n <a target=\"_blank\" class=\"tagc0\" href=\"/category/all#6\">JavaSE</a>\r\n <a target=\"_blank\" class=\"tagc1\" href=\"/category/all#7\">Others</a>\r\n <a target=\"_blank\" class=\"tagc2\" href=\"/category/all#11\">CSS</a>\r\n <a target=\"_blank\" class=\"tagc0\" href=\"/category/all#13\">AWK</a>\r\n <a target=\"_blank\" class=\"tagc1\" href=\"/category/all#14\">JavaScript</a>\r\n <a target=\"_blank\" class=\"tagc2\" href=\"/category/all#15\">SED</a>\r\n </div>\r\n```\r\n\r\n\r\n\r\n### CSS\r\n\r\n```css\r\n#tagscloud {\r\n width: 250px;\r\n height: 260px;\r\n position: relative;\r\n font-size: 12px;\r\n color: #333;\r\n margin: 20px auto 0;\r\n text-align: center;\r\n}\r\n\r\n#tagscloud a {\r\n position: absolute;\r\n top: 0px;\r\n left: 0px;\r\n color: #333;\r\n font-family: Arial;\r\n text-decoration: none;\r\n margin: 0 10px 15px 0;\r\n line-height: 18px;\r\n text-align: center;\r\n font-size: 12px;\r\n padding: 1px 5px;\r\n display: inline-block;\r\n border-radius: 3px;\r\n}\r\n\r\n#tagscloud a.tagc0 {\r\n background: #006633;\r\n color: #fff;\r\n}\r\n\r\n#tagscloud a.tagc1 {\r\n background: #666;\r\n color: #fff;\r\n}\r\n\r\n#tagscloud a.tagc2 {\r\n background: #F16E50;\r\n color: #fff;\r\n}\r\n\r\n#tagscloud a:hover {\r\n background: #0099ff;\r\n color: #fff;\r\n}\r\n```\r\n\r\n\r\n\r\n### JavaScript\r\n\r\n> 将 js 脚本放置最`body`元素最底部\r\n\r\n```javascript\r\n// JavaScript Document\r\nvar radius = 90;\r\nvar d = 200;\r\nvar dtr = Math.PI / 180;\r\nvar mcList = [];\r\nvar lasta = 1;\r\nvar lastb = 1;\r\nvar distr = true;\r\nvar tspeed = 11;\r\nvar size = 200;\r\nvar mouseX = 0;\r\nvar mouseY = 10;\r\nvar howElliptical = 1;\r\nvar aA = null;\r\nvar oDiv = null;\r\nwindow.onload=function ()\r\n{\r\n var i=0;\r\n var oTag=null;\r\n oDiv=document.getElementById(\'tagscloud\');\r\n aA=oDiv.getElementsByTagName(\'a\');\r\n for(i=0;i<aA.length;i++)\r\n {\r\n oTag={}; \r\n aA[i].onmouseover = (function (obj) {\r\n return function () {\r\n obj.on = true;\r\n this.style.zIndex = 9999;\r\n this.style.color = \'#fff\';\r\n this.style.padding = \'5px 5px\';\r\n this.style.filter = \"alpha(opacity=100)\";\r\n this.style.opacity = 1;\r\n }\r\n })(oTag)\r\n aA[i].onmouseout = (function (obj) {\r\n return function () {\r\n obj.on = false;\r\n this.style.zIndex = obj.zIndex;\r\n this.style.color = \'#fff\';\r\n this.style.padding = \'5px\';\r\n this.style.filter = \"alpha(opacity=\" + 100 * obj.alpha + \")\";\r\n this.style.opacity = obj.alpha;\r\n this.style.zIndex = obj.zIndex;\r\n }\r\n })(oTag)\r\n oTag.offsetWidth = aA[i].offsetWidth;\r\n oTag.offsetHeight = aA[i].offsetHeight;\r\n mcList.push(oTag);\r\n }\r\n sineCosine( 0,0,0 );\r\n positionAll();\r\n (function () {\r\n update();\r\n setTimeout(arguments.callee, 40);\r\n })();\r\n};\r\nfunction update()\r\n{\r\n var a, b, c = 0;\r\n a = (Math.min(Math.max(-mouseY, -size), size) / radius) * tspeed;\r\n b = (-Math.min(Math.max(-mouseX, -size), size) / radius) * tspeed;\r\n lasta = a;\r\n lastb = b;\r\n if (Math.abs(a) <= 0.01 && Math.abs(b) <= 0.01) {\r\n return;\r\n }\r\n sineCosine(a, b, c);\r\n for (var i = 0; i < mcList.length; i++) {\r\n if (mcList[i].on) {\r\n continue;\r\n }\r\n var rx1 = mcList[i].cx;\r\n var ry1 = mcList[i].cy * ca + mcList[i].cz * (-sa);\r\n var rz1 = mcList[i].cy * sa + mcList[i].cz * ca;\r\n\r\n var rx2 = rx1 * cb + rz1 * sb;\r\n var ry2 = ry1;\r\n var rz2 = rx1 * (-sb) + rz1 * cb;\r\n\r\n var rx3 = rx2 * cc + ry2 * (-sc);\r\n var ry3 = rx2 * sc + ry2 * cc;\r\n var rz3 = rz2;\r\n\r\n mcList[i].cx = rx3;\r\n mcList[i].cy = ry3;\r\n mcList[i].cz = rz3;\r\n\r\n per = d / (d + rz3);\r\n\r\n mcList[i].x = (howElliptical * rx3 * per) - (howElliptical * 2);\r\n mcList[i].y = ry3 * per;\r\n mcList[i].scale = per;\r\n var alpha = per;\r\n alpha = (alpha - 0.6) * (10 / 6);\r\n mcList[i].alpha = alpha * alpha * alpha - 0.2;\r\n mcList[i].zIndex = Math.ceil(100 - Math.floor(mcList[i].cz));\r\n }\r\n doPosition();\r\n}\r\nfunction positionAll()\r\n{\r\n var phi = 0;\r\n var theta = 0;\r\n var max = mcList.length;\r\n for (var i = 0; i < max; i++) {\r\n if (distr) {\r\n phi = Math.acos(-1 + (2 * (i + 1) - 1) / max);\r\n theta = Math.sqrt(max * Math.PI) * phi;\r\n } else {\r\n phi = Math.random() * (Math.PI);\r\n theta = Math.random() * (2 * Math.PI);\r\n }\r\n \r\n mcList[i].cx = radius * Math.cos(theta) * Math.sin(phi);\r\n mcList[i].cy = radius * Math.sin(theta) * Math.sin(phi);\r\n mcList[i].cz = radius * Math.cos(phi);\r\n\r\n aA[i].style.left = mcList[i].cx + oDiv.offsetWidth / 2 - mcList[i].offsetWidth / 2 + \'px\';\r\n aA[i].style.top = mcList[i].cy + oDiv.offsetHeight / 2 - mcList[i].offsetHeight / 2 + \'px\';\r\n }\r\n}\r\nfunction doPosition()\r\n{\r\n var l = oDiv.offsetWidth / 2;\r\n var t = oDiv.offsetHeight / 2;\r\n for (var i = 0; i < mcList.length; i++) {\r\n if (mcList[i].on) {\r\n continue;\r\n }\r\n var aAs = aA[i].style;\r\n if (mcList[i].alpha > 0.1) {\r\n if (aAs.display != \'\')\r\n aAs.display = \'\';\r\n } else {\r\n if (aAs.display != \'none\')\r\n aAs.display = \'none\';\r\n continue;\r\n }\r\n aAs.left = mcList[i].cx + l - mcList[i].offsetWidth / 2 + \'px\';\r\n aAs.top = mcList[i].cy + t - mcList[i].offsetHeight / 2 + \'px\';\r\n aAs.filter = \"alpha(opacity=\" + 100 * mcList[i].alpha + \")\";\r\n aAs.zIndex = mcList[i].zIndex;\r\n aAs.opacity = mcList[i].alpha;\r\n }\r\n}\r\nfunction sineCosine( a, b, c)\r\n{\r\n sa = Math.sin(a * dtr);\r\n ca = Math.cos(a * dtr);\r\n sb = Math.sin(b * dtr);\r\n cb = Math.cos(b * dtr);\r\n sc = Math.sin(c * dtr);\r\n cc = Math.cos(c * dtr);\r\n}\r\n```\r\n\r\n', '<blockquote>\r\n<p>标签云特效</p>\r\n</blockquote>\r\n<h3 id=\"h3-html\"><a name=\"HTML\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>HTML</h3><pre><code class=\"lang-html\"><div id="tagscloud">\r\n <a target="_blank" class="tagc1" href="/category/all#1">SpringMVC</a>\r\n <a target="_blank" class="tagc2" href="/category/all#2">MyBatis</a>\r\n <a target="_blank" class="tagc0" href="/category/all#3">Thymeleaf</a>\r\n <a target="_blank" class="tagc1" href="/category/all#4">SpringBoot</a>\r\n <a target="_blank" class="tagc2" href="/category/all#5">Shell</a>\r\n <a target="_blank" class="tagc0" href="/category/all#6">JavaSE</a>\r\n <a target="_blank" class="tagc1" href="/category/all#7">Others</a>\r\n <a target="_blank" class="tagc2" href="/category/all#11">CSS</a>\r\n <a target="_blank" class="tagc0" href="/category/all#13">AWK</a>\r\n <a target="_blank" class="tagc1" href="/category/all#14">JavaScript</a>\r\n <a target="_blank" class="tagc2" href="/category/all#15">SED</a>\r\n </div>\r\n</code></pre>\r\n<h3 id=\"h3-css\"><a name=\"CSS\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>CSS</h3><pre><code class=\"lang-css\">#tagscloud {\r\n width: 250px;\r\n height: 260px;\r\n position: relative;\r\n font-size: 12px;\r\n color: #333;\r\n margin: 20px auto 0;\r\n text-align: center;\r\n}\r\n\r\n#tagscloud a {\r\n position: absolute;\r\n top: 0px;\r\n left: 0px;\r\n color: #333;\r\n font-family: Arial;\r\n text-decoration: none;\r\n margin: 0 10px 15px 0;\r\n line-height: 18px;\r\n text-align: center;\r\n font-size: 12px;\r\n padding: 1px 5px;\r\n display: inline-block;\r\n border-radius: 3px;\r\n}\r\n\r\n#tagscloud a.tagc0 {\r\n background: #006633;\r\n color: #fff;\r\n}\r\n\r\n#tagscloud a.tagc1 {\r\n background: #666;\r\n color: #fff;\r\n}\r\n\r\n#tagscloud a.tagc2 {\r\n background: #F16E50;\r\n color: #fff;\r\n}\r\n\r\n#tagscloud a:hover {\r\n background: #0099ff;\r\n color: #fff;\r\n}\r\n</code></pre>\r\n<h3 id=\"h3-javascript\"><a name=\"JavaScript\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>JavaScript</h3><blockquote>\r\n<p>将 js 脚本放置最<code>body</code>元素最底部</p>\r\n</blockquote>\r\n<pre><code class=\"lang-javascript\">// JavaScript Document\r\nvar radius = 90;\r\nvar d = 200;\r\nvar dtr = Math.PI / 180;\r\nvar mcList = [];\r\nvar lasta = 1;\r\nvar lastb = 1;\r\nvar distr = true;\r\nvar tspeed = 11;\r\nvar size = 200;\r\nvar mouseX = 0;\r\nvar mouseY = 10;\r\nvar howElliptical = 1;\r\nvar aA = null;\r\nvar oDiv = null;\r\nwindow.onload=function ()\r\n{\r\n var i=0;\r\n var oTag=null;\r\n oDiv=document.getElementById('tagscloud');\r\n aA=oDiv.getElementsByTagName('a');\r\n for(i=0;i<aA.length;i++)\r\n {\r\n oTag={}; \r\n aA[i].onmouseover = (function (obj) {\r\n return function () {\r\n obj.on = true;\r\n this.style.zIndex = 9999;\r\n this.style.color = '#fff';\r\n this.style.padding = '5px 5px';\r\n this.style.filter = "alpha(opacity=100)";\r\n this.style.opacity = 1;\r\n }\r\n })(oTag)\r\n aA[i].onmouseout = (function (obj) {\r\n return function () {\r\n obj.on = false;\r\n this.style.zIndex = obj.zIndex;\r\n this.style.color = '#fff';\r\n this.style.padding = '5px';\r\n this.style.filter = "alpha(opacity=" + 100 * obj.alpha + ")";\r\n this.style.opacity = obj.alpha;\r\n this.style.zIndex = obj.zIndex;\r\n }\r\n })(oTag)\r\n oTag.offsetWidth = aA[i].offsetWidth;\r\n oTag.offsetHeight = aA[i].offsetHeight;\r\n mcList.push(oTag);\r\n }\r\n sineCosine( 0,0,0 );\r\n positionAll();\r\n (function () {\r\n update();\r\n setTimeout(arguments.callee, 40);\r\n })();\r\n};\r\nfunction update()\r\n{\r\n var a, b, c = 0;\r\n a = (Math.min(Math.max(-mouseY, -size), size) / radius) * tspeed;\r\n b = (-Math.min(Math.max(-mouseX, -size), size) / radius) * tspeed;\r\n lasta = a;\r\n lastb = b;\r\n if (Math.abs(a) <= 0.01 && Math.abs(b) <= 0.01) {\r\n return;\r\n }\r\n sineCosine(a, b, c);\r\n for (var i = 0; i < mcList.length; i++) {\r\n if (mcList[i].on) {\r\n continue;\r\n }\r\n var rx1 = mcList[i].cx;\r\n var ry1 = mcList[i].cy * ca + mcList[i].cz * (-sa);\r\n var rz1 = mcList[i].cy * sa + mcList[i].cz * ca;\r\n\r\n var rx2 = rx1 * cb + rz1 * sb;\r\n var ry2 = ry1;\r\n var rz2 = rx1 * (-sb) + rz1 * cb;\r\n\r\n var rx3 = rx2 * cc + ry2 * (-sc);\r\n var ry3 = rx2 * sc + ry2 * cc;\r\n var rz3 = rz2;\r\n\r\n mcList[i].cx = rx3;\r\n mcList[i].cy = ry3;\r\n mcList[i].cz = rz3;\r\n\r\n per = d / (d + rz3);\r\n\r\n mcList[i].x = (howElliptical * rx3 * per) - (howElliptical * 2);\r\n mcList[i].y = ry3 * per;\r\n mcList[i].scale = per;\r\n var alpha = per;\r\n alpha = (alpha - 0.6) * (10 / 6);\r\n mcList[i].alpha = alpha * alpha * alpha - 0.2;\r\n mcList[i].zIndex = Math.ceil(100 - Math.floor(mcList[i].cz));\r\n }\r\n doPosition();\r\n}\r\nfunction positionAll()\r\n{\r\n var phi = 0;\r\n var theta = 0;\r\n var max = mcList.length;\r\n for (var i = 0; i < max; i++) {\r\n if (distr) {\r\n phi = Math.acos(-1 + (2 * (i + 1) - 1) / max);\r\n theta = Math.sqrt(max * Math.PI) * phi;\r\n } else {\r\n phi = Math.random() * (Math.PI);\r\n theta = Math.random() * (2 * Math.PI);\r\n }\r\n\r\n mcList[i].cx = radius * Math.cos(theta) * Math.sin(phi);\r\n mcList[i].cy = radius * Math.sin(theta) * Math.sin(phi);\r\n mcList[i].cz = radius * Math.cos(phi);\r\n\r\n aA[i].style.left = mcList[i].cx + oDiv.offsetWidth / 2 - mcList[i].offsetWidth / 2 + 'px';\r\n aA[i].style.top = mcList[i].cy + oDiv.offsetHeight / 2 - mcList[i].offsetHeight / 2 + 'px';\r\n }\r\n}\r\nfunction doPosition()\r\n{\r\n var l = oDiv.offsetWidth / 2;\r\n var t = oDiv.offsetHeight / 2;\r\n for (var i = 0; i < mcList.length; i++) {\r\n if (mcList[i].on) {\r\n continue;\r\n }\r\n var aAs = aA[i].style;\r\n if (mcList[i].alpha > 0.1) {\r\n if (aAs.display != '')\r\n aAs.display = '';\r\n } else {\r\n if (aAs.display != 'none')\r\n aAs.display = 'none';\r\n continue;\r\n }\r\n aAs.left = mcList[i].cx + l - mcList[i].offsetWidth / 2 + 'px';\r\n aAs.top = mcList[i].cy + t - mcList[i].offsetHeight / 2 + 'px';\r\n aAs.filter = "alpha(opacity=" + 100 * mcList[i].alpha + ")";\r\n aAs.zIndex = mcList[i].zIndex;\r\n aAs.opacity = mcList[i].alpha;\r\n }\r\n}\r\nfunction sineCosine( a, b, c)\r\n{\r\n sa = Math.sin(a * dtr);\r\n ca = Math.cos(a * dtr);\r\n sb = Math.sin(b * dtr);\r\n cb = Math.cos(b * dtr);\r\n sc = Math.sin(c * dtr);\r\n cc = Math.cos(c * dtr);\r\n}\r\n</code></pre>\r\n', '2017-10-06 12:54:49', '11');
INSERT INTO `article` VALUES ('97', '1', '备份数据库至码云私有仓库', '### 思路\r\n\r\n- `mysqldump -u$mysql_user -p$mysql_password --skill-dump-date` 命令导出数据库数据\r\n- `git status | grep modified` 判断 sql 脚本是否修改，如果没有退出程序\r\n- `git push`到码云私有仓库\r\n- `crontab -e` 设置执行时间\r\n\r\n\r\n\r\n### 脚本\r\n\r\n```shell\r\n#!/bin/bash\r\n# 备份数据库到 码云 私有仓库\r\n\r\n# 指定数据库信息\r\nmysql_user=root\r\nmysql_password=root\r\ndatabase=badblog\r\n\r\n# git 项目目录\r\ngit_dir=~/document/git/Backup\r\n\r\n# 备份函数\r\nbackup() {\r\n \r\n # 判断是否是 root \r\n if [ $UID -ne 0 ];\r\n then\r\n echo \"非 root 用户无法执行!\"\r\n exit\r\n fi\r\n\r\n # 导出数据库数据 (没有指定用户名及密码是因为在 /etc/mysql/my.cnf 配置了用户名及密码 )\r\n # --dump-date 将导出时间添加至输出文件中, --skip-dump-date 关闭选项 ; 目的为判断 sql 文件是否有数据更变\r\n mysqldump -u$mysql_user -p$mysql_password $database --skip-dump-date > \"$git_dir/$database.sql\"\r\n\r\n # git 备份至码云\r\n cd $git_dir\r\n\r\n # 判断数据是否 modified \r\n git add $database.sql\r\n \r\n modified=`git status | grep modified`\r\n if [ -z \"$modified\" ];\r\n then\r\n echo \"数据没有被修改过,退出备份\"\r\n exit\r\n fi \r\n\r\n git commit -m $database\r\n git push origin master\r\n\r\n}\r\n\r\nbackup\r\n```\r\n\r\n', '<h3 id=\"h3-u601Du8DEF\"><a name=\"思路\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>思路</h3><ul>\r\n<li><code>mysqldump -u$mysql_user -p$mysql_password --skill-dump-date</code> 命令导出数据库数据</li><li><code>git status | grep modified</code> 判断 sql 脚本是否修改，如果没有退出程序</li><li><code>git push</code>到码云私有仓库</li><li><code>crontab -e</code> 设置执行时间</li></ul>\r\n<h3 id=\"h3-u811Au672C\"><a name=\"脚本\" class=\"reference-link\"></a><span class=\"header-link octicon octicon-link\"></span>脚本</h3><pre><code class=\"lang-shell\">#!/bin/bash\r\n# 备份数据库到 码云 私有仓库\r\n\r\n# 指定数据库信息\r\nmysql_user=root\r\nmysql_password=root\r\ndatabase=badblog\r\n\r\n# git 项目目录\r\ngit_dir=~/document/git/Backup\r\n\r\n# 备份函数\r\nbackup() {\r\n\r\n # 判断是否是 root \r\n if [ $UID -ne 0 ];\r\n then\r\n echo "非 root 用户无法执行!"\r\n exit\r\n fi\r\n\r\n # 导出数据库数据 (没有指定用户名及密码是因为在 /etc/mysql/my.cnf 配置了用户名及密码 )\r\n # --dump-date 将导出时间添加至输出文件中, --skip-dump-date 关闭选项 ; 目的为判断 sql 文件是否有数据更变\r\n mysqldump -u$mysql_user -p$mysql_password $database --skip-dump-date > "$git_dir/$database.sql"\r\n\r\n # git 备份至码云\r\n cd $git_dir\r\n\r\n # 判断数据是否 modified \r\n git add $database.sql\r\n\r\n modified=`git status | grep modified`\r\n if [ -z "$modified" ];\r\n then\r\n echo "数据没有被修改过,退出备份"\r\n exit\r\n fi \r\n\r\n git commit -m $database\r\n git push origin master\r\n\r\n}\r\n\r\nbackup\r\n</code></pre>\r\n', '2017-09-07 19:54:59', '146');
INSERT INTO `article` VALUES ('98', '5', 'Again', '- 夢のつづき 追いかけていたはずなのに\r\n >(梦的延续 本应继续追寻)\r\n\r\n- 曲がりくねった 細い道 人につまずく\r\n >(这弯弯曲曲的 细细的小道 将人绊倒)\r\n\r\n- あの頃みたいにって 戻りたい訳じゃないの\r\n >(其实并不想再回到 像那个时候一样)\r\n\r\n- 無くしてきた空を 探してる\r\n >(却不断地寻找那片渐渐消失的天空)\r\n\r\n- わかってくれますように 犠牲になったような 悲しい顔はやめてよ\r\n >(请慢慢地开始理解吧 不要摆出一张像是牺牲了一样的悲伤的脸)\r\n\r\n- 罪の最後は涙じゃないよ ずっと苦しく背負ってくんだ\r\n >(罪孽的最后并不是眼泪 而是要一直背负着苦痛)\r\n\r\n- 出口見えない感情迷路に 誰を待ってるの?\r\n >(在看不见出口的感情迷途中在等待着谁？)\r\n\r\n- 白いノートに綴ったように もっと素直に吐き出したいよ\r\n >(像白纸黑字写着的那样 本想更坦率地说出来的)\r\n\r\n- 何から 逃れたいんだ …現実ってやつ?\r\n >(可是 在逃避什么呢 …莫非是现实？)\r\n\r\n- 叶えるために 生きてるんだって\r\n >(为了实现愿望而生存下去)\r\n\r\n- 忘れちゃいそうな 夜の真ん中\r\n >(在这深夜里像已忘却一般)\r\n\r\n- 無難になんて やってられないから …帰る場所もないの\r\n >(平平庸庸什么的 不想成为那样 …已经无路可退)\r\n\r\n- この想いを 消してしまうには まだ人生長いでしょ?\r\n >(I\'m on the way)(在这份思念消失之前 人生还很漫长吧？)\r\n\r\n- 懐かしくなる こんな痛みも歓迎じゃん\r\n >(如此地怀念 何不欢迎这痛苦)\r\n\r\n- 謝らなくちゃいけないよね ah ごめんね\r\n >(不得不道歉呢 啊 对不起了)\r\n\r\n- うまく言えなくて 心配かけたままだったね\r\n >(虽然不能很好地表达 却一直在心里惦记))\r\n\r\n- あの日かかえた全部 あしたかかえる全部\r\n >(那一天所担负的全部 明天将要担负的全部)\r\n\r\n- 順番つけたりは しないから\r\n >(不会把这些一一排序)\r\n\r\n- わかってくれますように そっと目を閉じたんだ\r\n >(请慢慢地开始理解吧 偷偷地闭上眼睛)\r\n\r\n- 見たくないものまで 見えんだもん\r\n >(那是为了看不到 不想看到的东西)\r\n\r\n- いらないウワサにちょっと 初めて聞く発言どっち?\r\n >(不需要的流言 最初说出来的是谁？)\r\n >2回会ったら友達だって?? ウソはやめてね\r\n >(见面两次就是朋友？？别说这种谎话了)\r\n\r\n- 赤いハートが苛立つように 身体ん中燃えているんだ\r\n >(赤红的心急不可耐 在身体之中燃烧)\r\n\r\n- ホントは 期待してんの …現実ってやつ?\r\n >(真正地 期待着的 …难道是现实？)\r\n\r\n- 叶えるために 生きてるんだって\r\n >(为了实现愿望 而生存下去)\r\n\r\n- 叫びたくなるよ 聞こえていますか?\r\n >(想要放声大喊 是否能被听见？)\r\n\r\n- 無難になんて やってられないから …帰る場所もないの\r\n >(平平庸庸什么的 不想成为那样 …已经无路可退)\r\n\r\n- 優しさには いつも感謝してる だから強くなりたい\r\n >(I\'m on the way)(对你的温柔 我一直心存感激 因此想要变得强大)\r\n\r\n- 進むために 敵も味方も歓迎じゃん\r\n >(为了前进 何不欢迎一切敌友)\r\n\r\n- どうやって次のドア 開けるんだっけ?考えてる?\r\n >(要怎样才能打开 下一扇门？考虑了吗？)\r\n\r\n- もう引き返せない 物語 始まってるんだ\r\n >(已经不能回去了 故事 已经开始了)\r\n\r\n- 目を覚ませ 目を覚ませ\r\n >(觉醒吧 觉醒吧)\r\n\r\n- この想いを 消してしまうには まだ人生長いでしょ\r\n >?(在这份思念消失之前 人生还很漫长吧？)\r\n\r\n- やり残してるコト やり直してみたいから\r\n >(未能完成的事情 还想重新再来一次)\r\n\r\n- もう一度ゆこう 叶えるために 生きてるんだって\r\n >(再一次出发吧 为了实现愿望而生存下去)\r\n\r\n- 叫びたくなるよ 聞こえていますか?\r\n >(想要放声大喊 是否能被听见？)\r\n\r\n- 無難になんて やってられないから …帰る場所もないの\r\n >(平平庸庸什么的 不想成为那样 …已经无路可退)\r\n\r\n- 優しさには いつも感謝してる だから強くなりたい\r\n >(I\'m on the way)(对你的温柔 我一直心存感激 因此想要变得强大)\r\n\r\n- 懐かしくなる こんな痛みも歓迎じゃん\r\n >(如此地怀念 何不欢迎这痛苦)\r\n', '<ul>\r\n<li><p>夢のつづき 追いかけていたはずなのに</p>\r\n<blockquote>\r\n<p>(梦的延续 本应继续追寻)</p>\r\n</blockquote>\r\n</li><li><p>曲がりくねった 細い道 人につまずく</p>\r\n<blockquote>\r\n<p>(这弯弯曲曲的 细细的小道 将人绊倒)</p>\r\n</blockquote>\r\n</li><li><p>あの頃みたいにって 戻りたい訳じゃないの</p>\r\n<blockquote>\r\n<p>(其实并不想再回到 像那个时候一样)</p>\r\n</blockquote>\r\n</li><li><p>無くしてきた空を 探してる</p>\r\n<blockquote>\r\n<p>(却不断地寻找那片渐渐消失的天空)</p>\r\n</blockquote>\r\n</li><li><p>わかってくれますように 犠牲になったような 悲しい顔はやめてよ</p>\r\n<blockquote>\r\n<p>(请慢慢地开始理解吧 不要摆出一张像是牺牲了一样的悲伤的脸)</p>\r\n</blockquote>\r\n</li><li><p>罪の最後は涙じゃないよ ずっと苦しく背負ってくんだ</p>\r\n<blockquote>\r\n<p>(罪孽的最后并不是眼泪 而是要一直背负着苦痛)</p>\r\n</blockquote>\r\n</li><li><p>出口見えない感情迷路に 誰を待ってるの?</p>\r\n<blockquote>\r\n<p>(在看不见出口的感情迷途中在等待着谁？)</p>\r\n</blockquote>\r\n</li><li><p>白いノートに綴ったように もっと素直に吐き出したいよ</p>\r\n<blockquote>\r\n<p>(像白纸黑字写着的那样 本想更坦率地说出来的)</p>\r\n</blockquote>\r\n</li><li><p>何から 逃れたいんだ …現実ってやつ?</p>\r\n<blockquote>\r\n<p>(可是 在逃避什么呢 …莫非是现实？)</p>\r\n</blockquote>\r\n</li><li><p>叶えるために 生きてるんだって</p>\r\n<blockquote>\r\n<p>(为了实现愿望而生存下去)</p>\r\n</blockquote>\r\n</li><li><p>忘れちゃいそうな 夜の真ん中</p>\r\n<blockquote>\r\n<p>(在这深夜里像已忘却一般)</p>\r\n</blockquote>\r\n</li><li><p>無難になんて やってられないから …帰る場所もないの</p>\r\n<blockquote>\r\n<p>(平平庸庸什么的 不想成为那样 …已经无路可退)</p>\r\n</blockquote>\r\n</li><li><p>この想いを 消してしまうには まだ人生長いでしょ?</p>\r\n<blockquote>\r\n<p>(I’m on the way)(在这份思念消失之前 人生还很漫长吧？)</p>\r\n</blockquote>\r\n</li><li><p>懐かしくなる こんな痛みも歓迎じゃん</p>\r\n<blockquote>\r\n<p>(如此地怀念 何不欢迎这痛苦)</p>\r\n</blockquote>\r\n</li><li><p>謝らなくちゃいけないよね ah ごめんね</p>\r\n<blockquote>\r\n<p>(不得不道歉呢 啊 对不起了)</p>\r\n</blockquote>\r\n</li><li><p>うまく言えなくて 心配かけたままだったね</p>\r\n<blockquote>\r\n<p>(虽然不能很好地表达 却一直在心里惦记))</p>\r\n</blockquote>\r\n</li><li><p>あの日かかえた全部 あしたかかえる全部</p>\r\n<blockquote>\r\n<p>(那一天所担负的全部 明天将要担负的全部)</p>\r\n</blockquote>\r\n</li><li><p>順番つけたりは しないから</p>\r\n<blockquote>\r\n<p>(不会把这些一一排序)</p>\r\n</blockquote>\r\n</li><li><p>わかってくれますように そっと目を閉じたんだ</p>\r\n<blockquote>\r\n<p>(请慢慢地开始理解吧 偷偷地闭上眼睛)</p>\r\n</blockquote>\r\n</li><li><p>見たくないものまで 見えんだもん</p>\r\n<blockquote>\r\n<p>(那是为了看不到 不想看到的东西)</p>\r\n</blockquote>\r\n</li><li><p>いらないウワサにちょっと 初めて聞く発言どっち?</p>\r\n<blockquote>\r\n<p>(不需要的流言 最初说出来的是谁？)<br>2回会ったら友達だって?? ウソはやめてね<br>(见面两次就是朋友？？别说这种谎话了)</p>\r\n</blockquote>\r\n</li><li><p>赤いハートが苛立つように 身体ん中燃えているんだ</p>\r\n<blockquote>\r\n<p>(赤红的心急不可耐 在身体之中燃烧)</p>\r\n</blockquote>\r\n</li><li><p>ホントは 期待してんの …現実ってやつ?</p>\r\n<blockquote>\r\n<p>(真正地 期待着的 …难道是现实？)</p>\r\n</blockquote>\r\n</li><li><p>叶えるために 生きてるんだって</p>\r\n<blockquote>\r\n<p>(为了实现愿望 而生存下去)</p>\r\n</blockquote>\r\n</li><li><p>叫びたくなるよ 聞こえていますか?</p>\r\n<blockquote>\r\n<p>(想要放声大喊 是否能被听见？)</p>\r\n</blockquote>\r\n</li><li><p>無難になんて やってられないから …帰る場所もないの</p>\r\n<blockquote>\r\n<p>(平平庸庸什么的 不想成为那样 …已经无路可退)</p>\r\n</blockquote>\r\n</li><li><p>優しさには いつも感謝してる だから強くなりたい</p>\r\n<blockquote>\r\n<p>(I’m on the way)(对你的温柔 我一直心存感激 因此想要变得强大)</p>\r\n</blockquote>\r\n</li><li><p>進むために 敵も味方も歓迎じゃん</p>\r\n<blockquote>\r\n<p>(为了前进 何不欢迎一切敌友)</p>\r\n</blockquote>\r\n</li><li><p>どうやって次のドア 開けるんだっけ?考えてる?</p>\r\n<blockquote>\r\n<p>(要怎样才能打开 下一扇门？考虑了吗？)</p>\r\n</blockquote>\r\n</li><li><p>もう引き返せない 物語 始まってるんだ</p>\r\n<blockquote>\r\n<p>(已经不能回去了 故事 已经开始了)</p>\r\n</blockquote>\r\n</li><li><p>目を覚ませ 目を覚ませ</p>\r\n<blockquote>\r\n<p>(觉醒吧 觉醒吧)</p>\r\n</blockquote>\r\n</li><li><p>この想いを 消してしまうには まだ人生長いでしょ</p>\r\n<blockquote>\r\n<p>?(在这份思念消失之前 人生还很漫长吧？)</p>\r\n</blockquote>\r\n</li><li><p>やり残してるコト やり直してみたいから</p>\r\n<blockquote>\r\n<p>(未能完成的事情 还想重新再来一次)</p>\r\n</blockquote>\r\n</li><li><p>もう一度ゆこう 叶えるために 生きてるんだって</p>\r\n<blockquote>\r\n<p>(再一次出发吧 为了实现愿望而生存下去)</p>\r\n</blockquote>\r\n</li><li><p>叫びたくなるよ 聞こえていますか?</p>\r\n<blockquote>\r\n<p>(想要放声大喊 是否能被听见？)</p>\r\n</blockquote>\r\n</li><li><p>無難になんて やってられないから …帰る場所もないの</p>\r\n<blockquote>\r\n<p>(平平庸庸什么的 不想成为那样 …已经无路可退)</p>\r\n</blockquote>\r\n</li><li><p>優しさには いつも感謝してる だから強くなりたい</p>\r\n<blockquote>\r\n<p>(I’m on the way)(对你的温柔 我一直心存感激 因此想要变得强大)</p>\r\n</blockquote>\r\n</li><li><p>懐かしくなる こんな痛みも歓迎じゃん</p>\r\n<blockquote>\r\n<p>(如此地怀念 何不欢迎这痛苦)</p>\r\n</blockquote>\r\n</li></ul>\r\n', '2017-10-11 17:13:02', '26');
INSERT INTO `article` VALUES ('99', '5', 'Rolling Star', '\r\n- もう我慢ばっかしてらんないよ 言いたいことは言わなくちゃ\r\n\r\n- 不能再这样一味忍受下去了 要大声说出来\r\n\r\n- 帰り道 夕暮れのバス停 落ち込んだ背中にBye Bye Bye\r\n\r\n- 黄昏时分 在回家的车站旁 对自己失落的背影说Bye\r\n\r\n- 君のfighting pose せなきゃ oh oh\r\n\r\n- 你拼搏的身影 让我们看看\r\n\r\n- 夢にまで見たような世界は 争いもなく平和な日常\r\n\r\n- 虽然向往着在梦中的世界 之前是安宁的平凡生活\r\n\r\n- でも現実は日々トラブって たまに悔やんだりしてるそんな Rolling Days\r\n\r\n- 而现在的每天都充满着变故 往往令人陷入懊悔 在进入了那样动荡的日子之后\r\n\r\n- 転じゃったっていいんじゃないの そん時は笑ってあげる\r\n\r\n- 就算跌倒也没什么大不了 我仍会用笑容为你送行\r\n\r\n- 乗り込んだバスのから 小さく微笑みが見えた\r\n\r\n- 让乘上汽车渐渐远去的你 在看见窗外那小小微笑的时候\r\n\r\n- 君を頼りにしてるよ oh oh\r\n\r\n- 明白了你就是我心中的那个依靠\r\n\r\n- 夢にまで見たような sweet love 恋人達は隠れ家を探すの\r\n\r\n- 向往着曾经梦见的那甜美爱情 是恋人们不断寻找的隐秘地方\r\n\r\n- でも現実はあえない日々が 続きながらも信じてるの Rolling Days\r\n\r\n- 虽然在现实中始终难以找到 始终坚持着这个信仰 在这个不断改变的的日子里\r\n >oh yeah oh つまづいたって way to go 泥だらけ Rolling Star\r\n\r\n- 遭遇挫折乃要继续向前 浑身泥泞依然百折不挠\r\n\r\n- なるべく笑顔でいたいけれど 守りぬくためには仕方ないでしょ？\r\n\r\n- 虽然尽力想要保持笑容 可为了守护到底 有时也会无能为力\r\n\r\n- きっと嘘なんてそう 意味を持たないのOh my loving そうじゃなきゃやってらんない\r\n\r\n- 是的 谎言与掩饰 绝对没有意义 愿爱你所有的一切\r\n\r\n- そうじゃなきゃやってらんない\r\n\r\n- 迫切的愿望令我坐立不安\r\n\r\n- 夢にまで見たような世界は 争いもなく平和な日常\r\n\r\n- 虽然在梦中向往着的世界 之前是安宁的平凡生活\r\n\r\n- でも現実はあえない日々が 続きながらも信じてるの Rolling Days\r\n\r\n- 而现在的每天都充满着变故 往往令人陷入懊悔 在进入了那样动荡的日子之后\r\n >oh yeah oh そうわかってるって\r\n\r\n- 是的 这些我都知道\r\n >oh yeah oh つまづいたって way to go yeah yeah 泥だらけRolling star\r\n\r\n- 遭遇挫折乃要继续向前 浑身泥泞依然百折不挠\r\n', '<ul>\r\n<li><p>もう我慢ばっかしてらんないよ 言いたいことは言わなくちゃ</p>\r\n</li><li><p>不能再这样一味忍受下去了 要大声说出来</p>\r\n</li><li><p>帰り道 夕暮れのバス停 落ち込んだ背中にBye Bye Bye</p>\r\n</li><li><p>黄昏时分 在回家的车站旁 对自己失落的背影说Bye</p>\r\n</li><li><p>君のfighting pose せなきゃ oh oh</p>\r\n</li><li><p>你拼搏的身影 让我们看看</p>\r\n</li><li><p>夢にまで見たような世界は 争いもなく平和な日常</p>\r\n</li><li><p>虽然向往着在梦中的世界 之前是安宁的平凡生活</p>\r\n</li><li><p>でも現実は日々トラブって たまに悔やんだりしてるそんな Rolling Days</p>\r\n</li><li><p>而现在的每天都充满着变故 往往令人陷入懊悔 在进入了那样动荡的日子之后</p>\r\n</li><li><p>転じゃったっていいんじゃないの そん時は笑ってあげる</p>\r\n</li><li><p>就算跌倒也没什么大不了 我仍会用笑容为你送行</p>\r\n</li><li><p>乗り込んだバスのから 小さく微笑みが見えた</p>\r\n</li><li><p>让乘上汽车渐渐远去的你 在看见窗外那小小微笑的时候</p>\r\n</li><li><p>君を頼りにしてるよ oh oh</p>\r\n</li><li><p>明白了你就是我心中的那个依靠</p>\r\n</li><li><p>夢にまで見たような sweet love 恋人達は隠れ家を探すの</p>\r\n</li><li><p>向往着曾经梦见的那甜美爱情 是恋人们不断寻找的隐秘地方</p>\r\n</li><li><p>でも現実はあえない日々が 続きながらも信じてるの Rolling Days</p>\r\n</li><li><p>虽然在现实中始终难以找到 始终坚持着这个信仰 在这个不断改变的的日子里</p>\r\n<blockquote>\r\n<p>oh yeah oh つまづいたって way to go 泥だらけ Rolling Star</p>\r\n</blockquote>\r\n</li><li><p>遭遇挫折乃要继续向前 浑身泥泞依然百折不挠</p>\r\n</li><li><p>なるべく笑顔でいたいけれど 守りぬくためには仕方ないでしょ？</p>\r\n</li><li><p>虽然尽力想要保持笑容 可为了守护到底 有时也会无能为力</p>\r\n</li><li><p>きっと嘘なんてそう 意味を持たないのOh my loving そうじゃなきゃやってらんない</p>\r\n</li><li><p>是的 谎言与掩饰 绝对没有意义 愿爱你所有的一切</p>\r\n</li><li><p>そうじゃなきゃやってらんない</p>\r\n</li><li><p>迫切的愿望令我坐立不安</p>\r\n</li><li><p>夢にまで見たような世界は 争いもなく平和な日常</p>\r\n</li><li><p>虽然在梦中向往着的世界 之前是安宁的平凡生活</p>\r\n</li><li><p>でも現実はあえない日々が 続きながらも信じてるの Rolling Days</p>\r\n</li><li><p>而现在的每天都充满着变故 往往令人陷入懊悔 在进入了那样动荡的日子之后</p>\r\n<blockquote>\r\n<p>oh yeah oh そうわかってるって</p>\r\n</blockquote>\r\n</li><li><p>是的 这些我都知道</p>\r\n<blockquote>\r\n<p>oh yeah oh つまづいたって way to go yeah yeah 泥だらけRolling star</p>\r\n</blockquote>\r\n</li><li><p>遭遇挫折乃要继续向前 浑身泥泞依然百折不挠</p>\r\n</li></ul>\r\n', '2017-10-08 17:13:58', '3');
INSERT INTO `article` VALUES ('100', '5', 'Photograph', '\r\n- Loving can hurt\r\n >爱会让人伤心\r\n\r\n- Loving can hurt sometimes\r\n >爱有时总会让我们伤心\r\n\r\n- But it’s the only thing that I’ve known\r\n >但这是我唯一了解的事\r\n\r\n- When it gets hard\r\n >当我们的爱陷入困顿艰难\r\n\r\n- You know it can get hard sometimes\r\n >你知道我们总会遇到些许困难\r\n\r\n- It is the only thing that makes us feel alive\r\n >而爱就是让我们感觉到生命意义的唯一存在\r\n\r\n- We keep this love in a photograph\r\n >我们用照片将爱定格\r\n\r\n- We made these memories for ourselves\r\n >为彼此留下回忆的深刻\r\n\r\n- Where our eyes are never closing\r\n >因为在照片里你我的笑眼永远闪烁\r\n\r\n- Our hearts hearts were never broken\r\n >相爱的心永远不会支离剥落\r\n\r\n- And times forever frozen still\r\n >而时间也仿佛永远停留在最美的一刻\r\n\r\n- So you can keep me inside the pocket of your ripped jeans\r\n >而这样我就可以藏进你的牛仔裤袋里 不再离去\r\n\r\n- Holding me close until our eyes meet\r\n >而当你拿起照片回忆 我就可以和你无比靠近直到四目相遇\r\n\r\n- You will never be alone\r\n >这样你就再也不会孤单无依\r\n\r\n- Wait for me to come home\r\n >等我靠近你\r\n\r\n- Loving can heal\r\n >爱能将一切治愈\r\n\r\n- Loving can mend your soul\r\n >爱能抚慰你孤单的心灵\r\n\r\n- And it’s the only thing that I’ve known\r\n >这是爱教会我的唯一的事情\r\n\r\n- I swear it will get easier\r\n >我知道回忆能让我不再那么伤心\r\n\r\n- Remember that with every piece of ya\r\n >当我记起关于你的点点滴滴 会倍感温馨\r\n\r\n- And it’s the only thing to take with us when we die\r\n >而如若有一天我离去 这也是我唯一能带走的东西\r\n\r\n- We keep this love in a photograph\r\n >我们用照片将爱定格\r\n\r\n- We made these memories for ourselves\r\n >为彼此留下回忆的深刻\r\n\r\n- Where our eyes are never closing\r\n >因为在照片里你我的笑眼永远闪烁\r\n\r\n- Our hearts were never broken\r\n >相爱的心永远不会支离剥落\r\n\r\n- And times forever frozen still\r\n >而时间也仿佛永远停留在最美的一刻\r\n\r\n- So you can keep me inside the pocket of your ripped jeans\r\n >而这样我就可以藏进你的牛仔裤袋里 不再离去\r\n\r\n- Holding me close until our eyes meet\r\n >而当你拿起照片回忆 我就可以和你无比靠近直到四目相遇\r\n\r\n- You won’t ever be alone\r\n >这样你就再也不会孤单无依\r\n\r\n- And if you hurt me that’s okay baby\r\n >而就算有天你伤害了我 我也会说亲爱的没关系\r\n\r\n- Only words bleed\r\n >言语会哭泣 但我不会伤心\r\n\r\n- Inside these pages you just hold me\r\n >在那些回忆里你我依然紧紧相拥在一起\r\n\r\n- And I will never let you go\r\n >而我也会依旧把你抱紧不让你离去\r\n\r\n- Wait for me to come home\r\n >等我回到你身边 等我再次将你抱紧\r\n\r\n- And you could fit me inside the necklace you got\r\n >而你也可以把我的照片嵌进\r\n\r\n- When you were sixteen\r\n >你十六岁生日时买到的那条项链里\r\n\r\n- Next to your heart right where I should be\r\n >让我与你的心无比靠近 那才是我理想的归属之地\r\n\r\n- Keep it deep within your soul\r\n >我深藏其中并抚慰着你的心灵\r\n\r\n- And if you hurt me\r\n >而就算有天你让我伤心\r\n\r\n- But that’s okay baby\r\n >亲爱的我会对你说没关系\r\n\r\n- Only words bleed\r\n >因为相片里的我不会伤心哭泣\r\n\r\n- Inside these pages you just hold me\r\n >因为在那些回忆里你我依然紧紧相拥在一起\r\n\r\n- And I won’t ever let you go\r\n >而我也会依旧把你抱紧不让你离去\r\n\r\n- When I’m away\r\n >当有一天我真的逝去\r\n\r\n- I will remember how you kissed me\r\n >我会记得我们相拥亲吻的场景\r\n\r\n- Under the lamppost back on 6th street\r\n >和六号大街的路灯下那个最美的你\r\n\r\n- Hearing you whisper through the phone\r\n >我还能依稀听到你在电话那头的温柔低语\r\n\r\n- Wait for me to come home\r\n >说你会等着我回去\r\n', '<ul>\r\n<li><p>Loving can hurt</p>\r\n<blockquote>\r\n<p>爱会让人伤心</p>\r\n</blockquote>\r\n</li><li><p>Loving can hurt sometimes</p>\r\n<blockquote>\r\n<p>爱有时总会让我们伤心</p>\r\n</blockquote>\r\n</li><li><p>But it’s the only thing that I’ve known</p>\r\n<blockquote>\r\n<p>但这是我唯一了解的事</p>\r\n</blockquote>\r\n</li><li><p>When it gets hard</p>\r\n<blockquote>\r\n<p>当我们的爱陷入困顿艰难</p>\r\n</blockquote>\r\n</li><li><p>You know it can get hard sometimes</p>\r\n<blockquote>\r\n<p>你知道我们总会遇到些许困难</p>\r\n</blockquote>\r\n</li><li><p>It is the only thing that makes us feel alive</p>\r\n<blockquote>\r\n<p>而爱就是让我们感觉到生命意义的唯一存在</p>\r\n</blockquote>\r\n</li><li><p>We keep this love in a photograph</p>\r\n<blockquote>\r\n<p>我们用照片将爱定格</p>\r\n</blockquote>\r\n</li><li><p>We made these memories for ourselves</p>\r\n<blockquote>\r\n<p>为彼此留下回忆的深刻</p>\r\n</blockquote>\r\n</li><li><p>Where our eyes are never closing</p>\r\n<blockquote>\r\n<p>因为在照片里你我的笑眼永远闪烁</p>\r\n</blockquote>\r\n</li><li><p>Our hearts hearts were never broken</p>\r\n<blockquote>\r\n<p>相爱的心永远不会支离剥落</p>\r\n</blockquote>\r\n</li><li><p>And times forever frozen still</p>\r\n<blockquote>\r\n<p>而时间也仿佛永远停留在最美的一刻</p>\r\n</blockquote>\r\n</li><li><p>So you can keep me inside the pocket of your ripped jeans</p>\r\n<blockquote>\r\n<p>而这样我就可以藏进你的牛仔裤袋里 不再离去</p>\r\n</blockquote>\r\n</li><li><p>Holding me close until our eyes meet</p>\r\n<blockquote>\r\n<p>而当你拿起照片回忆 我就可以和你无比靠近直到四目相遇</p>\r\n</blockquote>\r\n</li><li><p>You will never be alone</p>\r\n<blockquote>\r\n<p>这样你就再也不会孤单无依</p>\r\n</blockquote>\r\n</li><li><p>Wait for me to come home</p>\r\n<blockquote>\r\n<p>等我靠近你</p>\r\n</blockquote>\r\n</li><li><p>Loving can heal</p>\r\n<blockquote>\r\n<p>爱能将一切治愈</p>\r\n</blockquote>\r\n</li><li><p>Loving can mend your soul</p>\r\n<blockquote>\r\n<p>爱能抚慰你孤单的心灵</p>\r\n</blockquote>\r\n</li><li><p>And it’s the only thing that I’ve known</p>\r\n<blockquote>\r\n<p>这是爱教会我的唯一的事情</p>\r\n</blockquote>\r\n</li><li><p>I swear it will get easier</p>\r\n<blockquote>\r\n<p>我知道回忆能让我不再那么伤心</p>\r\n</blockquote>\r\n</li><li><p>Remember that with every piece of ya</p>\r\n<blockquote>\r\n<p>当我记起关于你的点点滴滴 会倍感温馨</p>\r\n</blockquote>\r\n</li><li><p>And it’s the only thing to take with us when we die</p>\r\n<blockquote>\r\n<p>而如若有一天我离去 这也是我唯一能带走的东西</p>\r\n</blockquote>\r\n</li><li><p>We keep this love in a photograph</p>\r\n<blockquote>\r\n<p>我们用照片将爱定格</p>\r\n</blockquote>\r\n</li><li><p>We made these memories for ourselves</p>\r\n<blockquote>\r\n<p>为彼此留下回忆的深刻</p>\r\n</blockquote>\r\n</li><li><p>Where our eyes are never closing</p>\r\n<blockquote>\r\n<p>因为在照片里你我的笑眼永远闪烁</p>\r\n</blockquote>\r\n</li><li><p>Our hearts were never broken</p>\r\n<blockquote>\r\n<p>相爱的心永远不会支离剥落</p>\r\n</blockquote>\r\n</li><li><p>And times forever frozen still</p>\r\n<blockquote>\r\n<p>而时间也仿佛永远停留在最美的一刻</p>\r\n</blockquote>\r\n</li><li><p>So you can keep me inside the pocket of your ripped jeans</p>\r\n<blockquote>\r\n<p>而这样我就可以藏进你的牛仔裤袋里 不再离去</p>\r\n</blockquote>\r\n</li><li><p>Holding me close until our eyes meet</p>\r\n<blockquote>\r\n<p>而当你拿起照片回忆 我就可以和你无比靠近直到四目相遇</p>\r\n</blockquote>\r\n</li><li><p>You won’t ever be alone</p>\r\n<blockquote>\r\n<p>这样你就再也不会孤单无依</p>\r\n</blockquote>\r\n</li><li><p>And if you hurt me that’s okay baby</p>\r\n<blockquote>\r\n<p>而就算有天你伤害了我 我也会说亲爱的没关系</p>\r\n</blockquote>\r\n</li><li><p>Only words bleed</p>\r\n<blockquote>\r\n<p>言语会哭泣 但我不会伤心</p>\r\n</blockquote>\r\n</li><li><p>Inside these pages you just hold me</p>\r\n<blockquote>\r\n<p>在那些回忆里你我依然紧紧相拥在一起</p>\r\n</blockquote>\r\n</li><li><p>And I will never let you go</p>\r\n<blockquote>\r\n<p>而我也会依旧把你抱紧不让你离去</p>\r\n</blockquote>\r\n</li><li><p>Wait for me to come home</p>\r\n<blockquote>\r\n<p>等我回到你身边 等我再次将你抱紧</p>\r\n</blockquote>\r\n</li><li><p>And you could fit me inside the necklace you got</p>\r\n<blockquote>\r\n<p>而你也可以把我的照片嵌进</p>\r\n</blockquote>\r\n</li><li><p>When you were sixteen</p>\r\n<blockquote>\r\n<p>你十六岁生日时买到的那条项链里</p>\r\n</blockquote>\r\n</li><li><p>Next to your heart right where I should be</p>\r\n<blockquote>\r\n<p>让我与你的心无比靠近 那才是我理想的归属之地</p>\r\n</blockquote>\r\n</li><li><p>Keep it deep within your soul</p>\r\n<blockquote>\r\n<p>我深藏其中并抚慰着你的心灵</p>\r\n</blockquote>\r\n</li><li><p>And if you hurt me</p>\r\n<blockquote>\r\n<p>而就算有天你让我伤心</p>\r\n</blockquote>\r\n</li><li><p>But that’s okay baby</p>\r\n<blockquote>\r\n<p>亲爱的我会对你说没关系</p>\r\n</blockquote>\r\n</li><li><p>Only words bleed</p>\r\n<blockquote>\r\n<p>因为相片里的我不会伤心哭泣</p>\r\n</blockquote>\r\n</li><li><p>Inside these pages you just hold me</p>\r\n<blockquote>\r\n<p>因为在那些回忆里你我依然紧紧相拥在一起</p>\r\n</blockquote>\r\n</li><li><p>And I won’t ever let you go</p>\r\n<blockquote>\r\n<p>而我也会依旧把你抱紧不让你离去</p>\r\n</blockquote>\r\n</li><li><p>When I’m away</p>\r\n<blockquote>\r\n<p>当有一天我真的逝去</p>\r\n</blockquote>\r\n</li><li><p>I will remember how you kissed me</p>\r\n<blockquote>\r\n<p>我会记得我们相拥亲吻的场景</p>\r\n</blockquote>\r\n</li><li><p>Under the lamppost back on 6th street</p>\r\n<blockquote>\r\n<p>和六号大街的路灯下那个最美的你</p>\r\n</blockquote>\r\n</li><li><p>Hearing you whisper through the phone</p>\r\n<blockquote>\r\n<p>我还能依稀听到你在电话那头的温柔低语</p>\r\n</blockquote>\r\n</li><li><p>Wait for me to come home</p>\r\n<blockquote>\r\n<p>说你会等着我回去</p>\r\n</blockquote>\r\n</li></ul>\r\n', '2017-10-05 17:16:27', '1');
INSERT INTO `article` VALUES ('101', '5', 'Thinking Out Loud', '\r\n- When your legs don\'t work like they used to before\r\n >当你腿脚不再如 从前那般灵活\r\n\r\n- And I can\'t sweep you off of your feet\r\n >当我也不再如从前让你神魂颠倒\r\n\r\n- Will your mouth still remember the taste of my love\r\n >你会不会 还记得我们相爱的点滴滋味\r\n\r\n- Will your eyes still smile from your cheeks\r\n >你的笑颜又是否会如从前那般闪烁\r\n\r\n- And darlin\' I will\r\n >亲爱的\r\n\r\n- Be lovin\' you\r\n >就算我们年入古稀\r\n\r\n- Till we\'re seventy\r\n >我也依然爱你\r\n\r\n- Baby my heart\r\n >我的宝贝\r\n\r\n- Could still fall as hard\r\n >我的心跳依旧如23岁遇见你时\r\n\r\n- At twenty three\r\n >那般剧烈不息\r\n\r\n- And I\'m thinking \'bout how\r\n >我也一直在想\r\n\r\n- People fall in love in mysterious ways\r\n >人们是怎样不知不觉就坠入爱河里\r\n\r\n- Maybe just a touch of a hand\r\n >也许只因掌心的触碰温暖的传递\r\n\r\n- Oh me I fall in love with you every single day\r\n >而我每一天都会比从前更爱你\r\n\r\n- And I just wanna tell you I am\r\n >我也只想让你知道我是如此爱你\r\n\r\n- So honey now\r\n >我的甜心\r\n\r\n- Take me into your lovin\' arms\r\n >让我融化在你爱的怀抱里\r\n\r\n- Kiss me under the light of a thousand stars\r\n >让我们拥吻在星光熠熠的夜空里\r\n\r\n- Place your head on my beating heart\r\n >侧耳倾听 我为你心跳不息\r\n\r\n- I\'m thinking out loud\r\n >我不禁的想\r\n\r\n- Maybe we found love right where we are\r\n >也许我们就是在这样的时刻里找到彼此 找到爱\r\n\r\n- When my hairs all but gone and my memory fades\r\n >当我头发变得花白 落满一地 记性也一天天退化\r\n\r\n- And the crowds don\'t remember my name\r\n >周围人也都记不起我的名\r\n\r\n- When my hands don\'t play the strings the same way\r\n >双手也再没有力气 为你弹奏一曲\r\n\r\n- I know you will still love me the same\r\n >我知道即使这样你还会爱我如一\r\n\r\n- \'Cause honey your soul\r\n >你充满爱的心\r\n\r\n- Can never grow old\r\n >也永远不会老去\r\n\r\n- It\'s evergreen\r\n >反而仍然青春不息\r\n\r\n- Baby your smile\'s forever in my mind in memory\r\n >你的笑脸也会永远印在我脑海里\r\n\r\n- I\'m thinking \'bout how\r\n >我一直在想\r\n\r\n- People fall in love in mysterious ways\r\n >人们是怎样不知不觉就坠入爱河里\r\n\r\n- Maybe it\'s all part of a plan\r\n >也许一切都是命中注定\r\n\r\n- I\'ll just keep on making the same mistakes\r\n >我有时可能会犯同一个错误惹你生气\r\n\r\n- Hoping that you\'ll understand\r\n >但希望你能明白我的心\r\n\r\n- But baby now\r\n >亲爱的\r\n\r\n- Take me into your loving arms\r\n >让我融化在你爱的怀抱里\r\n\r\n- Kiss me under the light of a thousand stars\r\n >让我们拥吻在星光熠熠的夜空里\r\n\r\n- Place your head on my beating heart\r\n >侧耳倾听 我为你心跳不息\r\n\r\n- I\'m thinking out loud\r\n >我不禁的想\r\n\r\n- That maybe we found love right where we are, oh\r\n >也许我们就是在这样的时刻里找到彼此 找到爱\r\n\r\n- (la la la la la la la la la la la)\r\n\r\n- la la la la la la la la la la la\r\n\r\n- So baby now\r\n >亲爱的\r\n\r\n- Take me into your loving arms\r\n >让我融化在你爱的怀抱里\r\n\r\n- Kiss me under the light of a thousand stars\r\n >让我们拥吻在星光熠熠 的夜空里\r\n\r\n- (oh darlin\')\r\n >噢亲爱的\r\n\r\n- Place your head on my beating heart\r\n >侧耳倾听 我为你心跳不息\r\n\r\n- I\'m thinking out loud\r\n >我始终不停地想\r\n\r\n- That maybe we found love right where we are\r\n >也许我们就是在这样的时刻里找到彼此 找到爱\r\n\r\n- Oh maybe we found love right where we are\r\n >也许我们就是在这样的时刻里找到彼此 找到爱\r\n\r\n- And we found love right where we are\r\n >这样的我爱上这样的你 在这样的时刻里\r\n', '<ul>\r\n<li><p>When your legs don’t work like they used to before</p>\r\n<blockquote>\r\n<p>当你腿脚不再如 从前那般灵活</p>\r\n</blockquote>\r\n</li><li><p>And I can’t sweep you off of your feet</p>\r\n<blockquote>\r\n<p>当我也不再如从前让你神魂颠倒</p>\r\n</blockquote>\r\n</li><li><p>Will your mouth still remember the taste of my love</p>\r\n<blockquote>\r\n<p>你会不会 还记得我们相爱的点滴滋味</p>\r\n</blockquote>\r\n</li><li><p>Will your eyes still smile from your cheeks</p>\r\n<blockquote>\r\n<p>你的笑颜又是否会如从前那般闪烁</p>\r\n</blockquote>\r\n</li><li><p>And darlin’ I will</p>\r\n<blockquote>\r\n<p>亲爱的</p>\r\n</blockquote>\r\n</li><li><p>Be lovin’ you</p>\r\n<blockquote>\r\n<p>就算我们年入古稀</p>\r\n</blockquote>\r\n</li><li><p>Till we’re seventy</p>\r\n<blockquote>\r\n<p>我也依然爱你</p>\r\n</blockquote>\r\n</li><li><p>Baby my heart</p>\r\n<blockquote>\r\n<p>我的宝贝</p>\r\n</blockquote>\r\n</li><li><p>Could still fall as hard</p>\r\n<blockquote>\r\n<p>我的心跳依旧如23岁遇见你时</p>\r\n</blockquote>\r\n</li><li><p>At twenty three</p>\r\n<blockquote>\r\n<p>那般剧烈不息</p>\r\n</blockquote>\r\n</li><li><p>And I’m thinking ‘bout how</p>\r\n<blockquote>\r\n<p>我也一直在想</p>\r\n</blockquote>\r\n</li><li><p>People fall in love in mysterious ways</p>\r\n<blockquote>\r\n<p>人们是怎样不知不觉就坠入爱河里</p>\r\n</blockquote>\r\n</li><li><p>Maybe just a touch of a hand</p>\r\n<blockquote>\r\n<p>也许只因掌心的触碰温暖的传递</p>\r\n</blockquote>\r\n</li><li><p>Oh me I fall in love with you every single day</p>\r\n<blockquote>\r\n<p>而我每一天都会比从前更爱你</p>\r\n</blockquote>\r\n</li><li><p>And I just wanna tell you I am</p>\r\n<blockquote>\r\n<p>我也只想让你知道我是如此爱你</p>\r\n</blockquote>\r\n</li><li><p>So honey now</p>\r\n<blockquote>\r\n<p>我的甜心</p>\r\n</blockquote>\r\n</li><li><p>Take me into your lovin’ arms</p>\r\n<blockquote>\r\n<p>让我融化在你爱的怀抱里</p>\r\n</blockquote>\r\n</li><li><p>Kiss me under the light of a thousand stars</p>\r\n<blockquote>\r\n<p>让我们拥吻在星光熠熠的夜空里</p>\r\n</blockquote>\r\n</li><li><p>Place your head on my beating heart</p>\r\n<blockquote>\r\n<p>侧耳倾听 我为你心跳不息</p>\r\n</blockquote>\r\n</li><li><p>I’m thinking out loud</p>\r\n<blockquote>\r\n<p>我不禁的想</p>\r\n</blockquote>\r\n</li><li><p>Maybe we found love right where we are</p>\r\n<blockquote>\r\n<p>也许我们就是在这样的时刻里找到彼此 找到爱</p>\r\n</blockquote>\r\n</li><li><p>When my hairs all but gone and my memory fades</p>\r\n<blockquote>\r\n<p>当我头发变得花白 落满一地 记性也一天天退化</p>\r\n</blockquote>\r\n</li><li><p>And the crowds don’t remember my name</p>\r\n<blockquote>\r\n<p>周围人也都记不起我的名</p>\r\n</blockquote>\r\n</li><li><p>When my hands don’t play the strings the same way</p>\r\n<blockquote>\r\n<p>双手也再没有力气 为你弹奏一曲</p>\r\n</blockquote>\r\n</li><li><p>I know you will still love me the same</p>\r\n<blockquote>\r\n<p>我知道即使这样你还会爱我如一</p>\r\n</blockquote>\r\n</li><li><p>‘Cause honey your soul</p>\r\n<blockquote>\r\n<p>你充满爱的心</p>\r\n</blockquote>\r\n</li><li><p>Can never grow old</p>\r\n<blockquote>\r\n<p>也永远不会老去</p>\r\n</blockquote>\r\n</li><li><p>It’s evergreen</p>\r\n<blockquote>\r\n<p>反而仍然青春不息</p>\r\n</blockquote>\r\n</li><li><p>Baby your smile’s forever in my mind in memory</p>\r\n<blockquote>\r\n<p>你的笑脸也会永远印在我脑海里</p>\r\n</blockquote>\r\n</li><li><p>I’m thinking ‘bout how</p>\r\n<blockquote>\r\n<p>我一直在想</p>\r\n</blockquote>\r\n</li><li><p>People fall in love in mysterious ways</p>\r\n<blockquote>\r\n<p>人们是怎样不知不觉就坠入爱河里</p>\r\n</blockquote>\r\n</li><li><p>Maybe it’s all part of a plan</p>\r\n<blockquote>\r\n<p>也许一切都是命中注定</p>\r\n</blockquote>\r\n</li><li><p>I’ll just keep on making the same mistakes</p>\r\n<blockquote>\r\n<p>我有时可能会犯同一个错误惹你生气</p>\r\n</blockquote>\r\n</li><li><p>Hoping that you’ll understand</p>\r\n<blockquote>\r\n<p>但希望你能明白我的心</p>\r\n</blockquote>\r\n</li><li><p>But baby now</p>\r\n<blockquote>\r\n<p>亲爱的</p>\r\n</blockquote>\r\n</li><li><p>Take me into your loving arms</p>\r\n<blockquote>\r\n<p>让我融化在你爱的怀抱里</p>\r\n</blockquote>\r\n</li><li><p>Kiss me under the light of a thousand stars</p>\r\n<blockquote>\r\n<p>让我们拥吻在星光熠熠的夜空里</p>\r\n</blockquote>\r\n</li><li><p>Place your head on my beating heart</p>\r\n<blockquote>\r\n<p>侧耳倾听 我为你心跳不息</p>\r\n</blockquote>\r\n</li><li><p>I’m thinking out loud</p>\r\n<blockquote>\r\n<p>我不禁的想</p>\r\n</blockquote>\r\n</li><li><p>That maybe we found love right where we are, oh</p>\r\n<blockquote>\r\n<p>也许我们就是在这样的时刻里找到彼此 找到爱</p>\r\n</blockquote>\r\n</li><li><p>(la la la la la la la la la la la)</p>\r\n</li><li><p>la la la la la la la la la la la</p>\r\n</li><li><p>So baby now</p>\r\n<blockquote>\r\n<p>亲爱的</p>\r\n</blockquote>\r\n</li><li><p>Take me into your loving arms</p>\r\n<blockquote>\r\n<p>让我融化在你爱的怀抱里</p>\r\n</blockquote>\r\n</li><li><p>Kiss me under the light of a thousand stars</p>\r\n<blockquote>\r\n<p>让我们拥吻在星光熠熠 的夜空里</p>\r\n</blockquote>\r\n</li><li><p>(oh darlin’)</p>\r\n<blockquote>\r\n<p>噢亲爱的</p>\r\n</blockquote>\r\n</li><li><p>Place your head on my beating heart</p>\r\n<blockquote>\r\n<p>侧耳倾听 我为你心跳不息</p>\r\n</blockquote>\r\n</li><li><p>I’m thinking out loud</p>\r\n<blockquote>\r\n<p>我始终不停地想</p>\r\n</blockquote>\r\n</li><li><p>That maybe we found love right where we are</p>\r\n<blockquote>\r\n<p>也许我们就是在这样的时刻里找到彼此 找到爱</p>\r\n</blockquote>\r\n</li><li><p>Oh maybe we found love right where we are</p>\r\n<blockquote>\r\n<p>也许我们就是在这样的时刻里找到彼此 找到爱</p>\r\n</blockquote>\r\n</li><li><p>And we found love right where we are</p>\r\n<blockquote>\r\n<p>这样的我爱上这样的你 在这样的时刻里</p>\r\n</blockquote>\r\n</li></ul>\r\n', '2017-09-09 17:17:00', '4');
INSERT INTO `article` VALUES ('102', '5', '... Ready For It ?', '![](http://p1.music.126.net/XVJ_z2ox2RMFaUddmMAO0g==/109951163018139225.jpg?param=130y130\")\r\n\r\n- Knew he was a killer first time that I saw him\r\n >早知他危险无比 初次见他我就心知肚明\r\n\r\n- Wonder how many girls he had loved and left haunted\r\n >想知道他爱上过多少女孩 又有多少对他难忘怀\r\n\r\n- But if he\'s a ghost, then I can be a phantom\r\n >但若他真如幽灵般难缠那我自然也不坏\r\n\r\n- Holdin\' him for ransom\r\n >缠住他等悬赏者来\r\n\r\n- Some, some boys are tryin\' too hard\r\n >有些男孩苦心积虑\r\n\r\n- He don\'t try at all, though\r\n >他却从来毫不费力\r\n\r\n- Younger than my exes but he act like such a man, so\r\n >比我历任都年轻但举止却如此不凡\r\n\r\n- I see nothing better, I keep him forever\r\n >我丢掉理智 想缠他一世\r\n\r\n- Like a vendetta-ta\r\n >如世仇无休无止\r\n\r\n- I-I-I see how this is gon\' go\r\n >我知道这故事会如何走下去\r\n\r\n- Touch me and you\'ll never be alone\r\n >轻轻触碰你便不再孤单无依\r\n\r\n- I-Island breeze and lights down low\r\n >海岛之风 让灯光渐隐\r\n\r\n- No one has to know\r\n >无人知其降临\r\n\r\n- In the middle of the night, in my dreams\r\n >午夜时分 在我的梦里\r\n\r\n- You should see the things we do, baby\r\n >你会看见我们所经历的经历\r\n\r\n- In the middle of the night, in my dreams\r\n >午夜时分 在我的梦里\r\n\r\n- I know I\'m gonna be with you\r\n >我知道我会和你在一起\r\n\r\n- So I take my time\r\n >所以我不慢不急\r\n\r\n- Are you ready for it?\r\n >你是否也已准备就绪\r\n\r\n- Me, I was a robber first time that he saw me\r\n >至于我 我是个偷心大盗 他初次见我就知道\r\n\r\n- Stealing hearts and running off and never saying sorry\r\n >偷走了心就逃离 毫无歉意\r\n\r\n- But if I\'m a thief, then he can join the heist\r\n >但就算我真是个盗贼 他也能加入这盗窃的聚会\r\n\r\n- And we\'ll move to an island-and\r\n >我们逃亡到个小岛\r\n\r\n- And he can be my jailer, \"Burton to this Taylor\"\r\n >他便做起我的狱卒 上演新版的伯顿恋泰勒\r\n\r\n- Every lover known in comparison is a failure\r\n >每一个人皆所知的吾爱都断送于对比之心\r\n\r\n- I forget their names now, I\'m so very tame now\r\n >如今我已忘了他们的姓名 如今我已变得十分温驯\r\n\r\n- Never be the same now, now\r\n >再不复往昔\r\n\r\n- I-I-I see how this is gon\' go\r\n >我知道这故事会如何走下去\r\n\r\n- Touch me and you\'ll never be alone\r\n >轻轻触碰你便不再孤单无依\r\n\r\n- I-Island breeze and lights down low\r\n >海岛之风 让灯光渐隐\r\n\r\n- No one has to know\r\n >无人知其降临\r\n\r\n- (No one has to know)\r\n >无人知其降临\r\n\r\n- In the middle of the night, in my dreams\r\n >午夜时分 在我的梦里\r\n\r\n- You should see the things we do, baby\r\n >你会看见我们所经历的经历\r\n\r\n- In the middle of the night in my dreams\r\n >午夜时分 在我的梦里\r\n\r\n- I know I\'m gonna be with you\r\n >我知道我会和你在一起\r\n\r\n- So I take my time\r\n >所以我不慢不急\r\n\r\n- Are you ready for it?\r\n >你是否也已准备就绪\r\n\r\n- Ooh, are you ready for it?\r\n >你是否也已准备就绪\r\n\r\n- Baby, let the games begin\r\n >宝贝 游戏就此开局\r\n\r\n- Let the games begin\r\n >游戏就此开始\r\n\r\n- Let the games begin\r\n >游戏就此开始\r\n\r\n- Baby, let the games begin\r\n >宝贝 游戏就此开局\r\n\r\n- Let the games begin\r\n >游戏就此开始\r\n\r\n- Let the games begin\r\n >游戏就此开始\r\n\r\n- I-I-I see how this is gon\' go\r\n >我知道这故事会如何走下去\r\n\r\n- Touch me and you\'ll never be alone\r\n >轻轻触碰你便不再孤单无依\r\n\r\n- I-Island breeze and lights down low\r\n >海岛之风 让灯光渐隐\r\n\r\n- No one has to know\r\n >无人知其降临\r\n\r\n- In the middle of the night, in my dreams\r\n >午夜时分 在我的梦里\r\n\r\n- You should see the things we do, baby\r\n >你会看见我们所经历的经历\r\n\r\n- In the middle of the night, in my dreams\r\n >午夜时分 在我的梦里\r\n\r\n- I know I\'m gonna be with you\r\n >我知道我会和你在一起\r\n\r\n- So I take my time\r\n >所以我不慢不急\r\n\r\n- In the middle of the night\r\n >在那梦寐的午夜里\r\n\r\n- Baby, let the games begin\r\n >宝贝 游戏就此开局\r\n\r\n- Let the games begin\r\n >游戏就此开始\r\n\r\n- Let the games begin\r\n >游戏就此开始\r\n\r\n- Are you ready for it?\r\n >你是否已准备就绪\r\n\r\n- Baby, let the games begin\r\n >游戏就此开始\r\n\r\n- Let the games begin\r\n >游戏就此开始\r\n\r\n- Let the games begin\r\n >游戏就此开始\r\n\r\n- Are you ready for it?\r\n >你是否已准备就绪\r\n', '<p><img src=\"http://p1.music.126.net/XVJ_z2ox2RMFaUddmMAO0g==/109951163018139225.jpg?param=130y130"\" alt=\"\"></p>\r\n<ul>\r\n<li><p>Knew he was a killer first time that I saw him</p>\r\n<blockquote>\r\n<p>早知他危险无比 初次见他我就心知肚明</p>\r\n</blockquote>\r\n</li><li><p>Wonder how many girls he had loved and left haunted</p>\r\n<blockquote>\r\n<p>想知道他爱上过多少女孩 又有多少对他难忘怀</p>\r\n</blockquote>\r\n</li><li><p>But if he’s a ghost, then I can be a phantom</p>\r\n<blockquote>\r\n<p>但若他真如幽灵般难缠那我自然也不坏</p>\r\n</blockquote>\r\n</li><li><p>Holdin’ him for ransom</p>\r\n<blockquote>\r\n<p>缠住他等悬赏者来</p>\r\n</blockquote>\r\n</li><li><p>Some, some boys are tryin’ too hard</p>\r\n<blockquote>\r\n<p>有些男孩苦心积虑</p>\r\n</blockquote>\r\n</li><li><p>He don’t try at all, though</p>\r\n<blockquote>\r\n<p>他却从来毫不费力</p>\r\n</blockquote>\r\n</li><li><p>Younger than my exes but he act like such a man, so</p>\r\n<blockquote>\r\n<p>比我历任都年轻但举止却如此不凡</p>\r\n</blockquote>\r\n</li><li><p>I see nothing better, I keep him forever</p>\r\n<blockquote>\r\n<p>我丢掉理智 想缠他一世</p>\r\n</blockquote>\r\n</li><li><p>Like a vendetta-ta</p>\r\n<blockquote>\r\n<p>如世仇无休无止</p>\r\n</blockquote>\r\n</li><li><p>I-I-I see how this is gon’ go</p>\r\n<blockquote>\r\n<p>我知道这故事会如何走下去</p>\r\n</blockquote>\r\n</li><li><p>Touch me and you’ll never be alone</p>\r\n<blockquote>\r\n<p>轻轻触碰你便不再孤单无依</p>\r\n</blockquote>\r\n</li><li><p>I-Island breeze and lights down low</p>\r\n<blockquote>\r\n<p>海岛之风 让灯光渐隐</p>\r\n</blockquote>\r\n</li><li><p>No one has to know</p>\r\n<blockquote>\r\n<p>无人知其降临</p>\r\n</blockquote>\r\n</li><li><p>In the middle of the night, in my dreams</p>\r\n<blockquote>\r\n<p>午夜时分 在我的梦里</p>\r\n</blockquote>\r\n</li><li><p>You should see the things we do, baby</p>\r\n<blockquote>\r\n<p>你会看见我们所经历的经历</p>\r\n</blockquote>\r\n</li><li><p>In the middle of the night, in my dreams</p>\r\n<blockquote>\r\n<p>午夜时分 在我的梦里</p>\r\n</blockquote>\r\n</li><li><p>I know I’m gonna be with you</p>\r\n<blockquote>\r\n<p>我知道我会和你在一起</p>\r\n</blockquote>\r\n</li><li><p>So I take my time</p>\r\n<blockquote>\r\n<p>所以我不慢不急</p>\r\n</blockquote>\r\n</li><li><p>Are you ready for it?</p>\r\n<blockquote>\r\n<p>你是否也已准备就绪</p>\r\n</blockquote>\r\n</li><li><p>Me, I was a robber first time that he saw me</p>\r\n<blockquote>\r\n<p>至于我 我是个偷心大盗 他初次见我就知道</p>\r\n</blockquote>\r\n</li><li><p>Stealing hearts and running off and never saying sorry</p>\r\n<blockquote>\r\n<p>偷走了心就逃离 毫无歉意</p>\r\n</blockquote>\r\n</li><li><p>But if I’m a thief, then he can join the heist</p>\r\n<blockquote>\r\n<p>但就算我真是个盗贼 他也能加入这盗窃的聚会</p>\r\n</blockquote>\r\n</li><li><p>And we’ll move to an island-and</p>\r\n<blockquote>\r\n<p>我们逃亡到个小岛</p>\r\n</blockquote>\r\n</li><li><p>And he can be my jailer, “Burton to this Taylor”</p>\r\n<blockquote>\r\n<p>他便做起我的狱卒 上演新版的伯顿恋泰勒</p>\r\n</blockquote>\r\n</li><li><p>Every lover known in comparison is a failure</p>\r\n<blockquote>\r\n<p>每一个人皆所知的吾爱都断送于对比之心</p>\r\n</blockquote>\r\n</li><li><p>I forget their names now, I’m so very tame now</p>\r\n<blockquote>\r\n<p>如今我已忘了他们的姓名 如今我已变得十分温驯</p>\r\n</blockquote>\r\n</li><li><p>Never be the same now, now</p>\r\n<blockquote>\r\n<p>再不复往昔</p>\r\n</blockquote>\r\n</li><li><p>I-I-I see how this is gon’ go</p>\r\n<blockquote>\r\n<p>我知道这故事会如何走下去</p>\r\n</blockquote>\r\n</li><li><p>Touch me and you’ll never be alone</p>\r\n<blockquote>\r\n<p>轻轻触碰你便不再孤单无依</p>\r\n</blockquote>\r\n</li><li><p>I-Island breeze and lights down low</p>\r\n<blockquote>\r\n<p>海岛之风 让灯光渐隐</p>\r\n</blockquote>\r\n</li><li><p>No one has to know</p>\r\n<blockquote>\r\n<p>无人知其降临</p>\r\n</blockquote>\r\n</li><li><p>(No one has to know)</p>\r\n<blockquote>\r\n<p>无人知其降临</p>\r\n</blockquote>\r\n</li><li><p>In the middle of the night, in my dreams</p>\r\n<blockquote>\r\n<p>午夜时分 在我的梦里</p>\r\n</blockquote>\r\n</li><li><p>You should see the things we do, baby</p>\r\n<blockquote>\r\n<p>你会看见我们所经历的经历</p>\r\n</blockquote>\r\n</li><li><p>In the middle of the night in my dreams</p>\r\n<blockquote>\r\n<p>午夜时分 在我的梦里</p>\r\n</blockquote>\r\n</li><li><p>I know I’m gonna be with you</p>\r\n<blockquote>\r\n<p>我知道我会和你在一起</p>\r\n</blockquote>\r\n</li><li><p>So I take my time</p>\r\n<blockquote>\r\n<p>所以我不慢不急</p>\r\n</blockquote>\r\n</li><li><p>Are you ready for it?</p>\r\n<blockquote>\r\n<p>你是否也已准备就绪</p>\r\n</blockquote>\r\n</li><li><p>Ooh, are you ready for it?</p>\r\n<blockquote>\r\n<p>你是否也已准备就绪</p>\r\n</blockquote>\r\n</li><li><p>Baby, let the games begin</p>\r\n<blockquote>\r\n<p>宝贝 游戏就此开局</p>\r\n</blockquote>\r\n</li><li><p>Let the games begin</p>\r\n<blockquote>\r\n<p>游戏就此开始</p>\r\n</blockquote>\r\n</li><li><p>Let the games begin</p>\r\n<blockquote>\r\n<p>游戏就此开始</p>\r\n</blockquote>\r\n</li><li><p>Baby, let the games begin</p>\r\n<blockquote>\r\n<p>宝贝 游戏就此开局</p>\r\n</blockquote>\r\n</li><li><p>Let the games begin</p>\r\n<blockquote>\r\n<p>游戏就此开始</p>\r\n</blockquote>\r\n</li><li><p>Let the games begin</p>\r\n<blockquote>\r\n<p>游戏就此开始</p>\r\n</blockquote>\r\n</li><li><p>I-I-I see how this is gon’ go</p>\r\n<blockquote>\r\n<p>我知道这故事会如何走下去</p>\r\n</blockquote>\r\n</li><li><p>Touch me and you’ll never be alone</p>\r\n<blockquote>\r\n<p>轻轻触碰你便不再孤单无依</p>\r\n</blockquote>\r\n</li><li><p>I-Island breeze and lights down low</p>\r\n<blockquote>\r\n<p>海岛之风 让灯光渐隐</p>\r\n</blockquote>\r\n</li><li><p>No one has to know</p>\r\n<blockquote>\r\n<p>无人知其降临</p>\r\n</blockquote>\r\n</li><li><p>In the middle of the night, in my dreams</p>\r\n<blockquote>\r\n<p>午夜时分 在我的梦里</p>\r\n</blockquote>\r\n</li><li><p>You should see the things we do, baby</p>\r\n<blockquote>\r\n<p>你会看见我们所经历的经历</p>\r\n</blockquote>\r\n</li><li><p>In the middle of the night, in my dreams</p>\r\n<blockquote>\r\n<p>午夜时分 在我的梦里</p>\r\n</blockquote>\r\n</li><li><p>I know I’m gonna be with you</p>\r\n<blockquote>\r\n<p>我知道我会和你在一起</p>\r\n</blockquote>\r\n</li><li><p>So I take my time</p>\r\n<blockquote>\r\n<p>所以我不慢不急</p>\r\n</blockquote>\r\n</li><li><p>In the middle of the night</p>\r\n<blockquote>\r\n<p>在那梦寐的午夜里</p>\r\n</blockquote>\r\n</li><li><p>Baby, let the games begin</p>\r\n<blockquote>\r\n<p>宝贝 游戏就此开局</p>\r\n</blockquote>\r\n</li><li><p>Let the games begin</p>\r\n<blockquote>\r\n<p>游戏就此开始</p>\r\n</blockquote>\r\n</li><li><p>Let the games begin</p>\r\n<blockquote>\r\n<p>游戏就此开始</p>\r\n</blockquote>\r\n</li><li><p>Are you ready for it?</p>\r\n<blockquote>\r\n<p>你是否已准备就绪</p>\r\n</blockquote>\r\n</li><li><p>Baby, let the games begin</p>\r\n<blockquote>\r\n<p>游戏就此开始</p>\r\n</blockquote>\r\n</li><li><p>Let the games begin</p>\r\n<blockquote>\r\n<p>游戏就此开始</p>\r\n</blockquote>\r\n</li><li><p>Let the games begin</p>\r\n<blockquote>\r\n<p>游戏就此开始</p>\r\n</blockquote>\r\n</li><li><p>Are you ready for it?</p>\r\n<blockquote>\r\n<p>你是否已准备就绪</p>\r\n</blockquote>\r\n</li></ul>\r\n', '2017-09-19 17:18:15', '20');
INSERT INTO `article` VALUES ('103', '5', 'Look What You Made Me Do', '\r\n- I don\'t like your little games\r\n 你那点伎俩还是别拿出来了\r\n- Don\'t like your tilted stage\r\n 你那浮动舞台效果也逊爆了\r\n- The role you made me play\r\n 你让我扮演小丑的角色\r\n- Of the fool, no, I don\'t like you\r\n 愚蠢至极的角色，不，我真的不喜欢你\r\n- I don\'t like your perfect crime\r\n 我不喜欢你自导自演的闹剧\r\n- How you laugh when you lie\r\n 也不喜欢你笑里藏刀的嘴脸\r\n- You said the gun was mine\r\n 你先发制人，咬定是我先惹的你\r\n- Isn\'t cool, no, I don\'t like you (oh!)\r\n 想颠倒黑白？不，我嗤之以鼻\r\n- But I got smarter, I got harder in the nick of time\r\n 但我懂得适时收手全身而退，待时机成熟重夺王座\r\n- Honey, I rose up from the dead, I do it all the time\r\n 亲爱的，我向来如此，浴火重生\r\n- I’ve got a list of names and yours is in red, underlined\r\n 我手里有一长串黑名单，恭喜你被我划了红线\r\n- I check it once, then I check it twice, oh!\r\n 我翻了翻你的名字，又再三确认\r\n- Ohh, look what you made me do\r\n 噢，瞧瞧你们都让我做了些什么\r\n- Look what you made me do\r\n 瞧瞧你们都让我做了些什么\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Ohh, look what you made me do\r\n 噢，瞧瞧你们都让我做了些什么\r\n- Look what you made me do\r\n 瞧瞧你们都让我做了些什么\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- I don\'t like your kingdom keys\r\n 我不屑你们手握的奖杯\r\n- They once belonged to me\r\n 因为那些本属于我\r\n- You ask me for a place to sleep\r\n 你向我祈求一个容身之所\r\n- Locked me out and threw a feast (what?)\r\n 却把我反锁在门外，自己享用饕餮大餐(真是看错你了!)\r\n- The world moves on, another day, another drama, drama\r\n 地球依然旋转，每天上演着不同的戏码\r\n- But not for me, not for me, all I think about is karma\r\n 但这不关我事，不关我事，我只能说恶有恶报\r\n- And then the world moves on but one thing\'s for sure\r\n 地球还是会转，我也始终确信\r\n- Maybe I got mine, but you\'ll all get yours\r\n 风水轮流转，善恶终有报\r\n- But I got smarter, I got harder in the nick of time\r\n 但我懂得适时收手全身而退，待时机成熟重夺王座\r\n- Honey, I rose up from the dead, I do it all the time\r\n 亲爱的，我向来如此，浴火重生\r\n- I’ve got a list of names and yours is in red, underlined\r\n 我手里有一长串黑名单，恭喜你被我划了红线\r\n- I check it once, then I check it twice, oh!\r\n 我翻了翻你的名字，又再三确认\r\n- Ohh, look what you made me do\r\n 噢，瞧瞧你们都让我做了些什么\r\n- Look what you made me do\r\n 瞧瞧你们让我如何回应\r\n- Look what you just made me do\r\n 瞧瞧你们都让我做了些什么\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Ohh, look what you made me do\r\n 噢，瞧瞧你们都让我做了些什么\r\n- Look what you made me do\r\n 瞧瞧你们都让我做了些什么\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- I don\'t trust nobody and nobody trusts me\r\n 我不相信任何人，也不奢望别人相信我\r\n- I\'ll be the actress starring in your bad dreams\r\n 我会做女主人公，在你的噩梦中缠着你\r\n- I don\'t trust nobody and nobody trusts me\r\n 我不相信任何人，也不奢望别人相信我\r\n- I\'ll be the actress starring in your bad dreams\r\n 我会做女主人公，在你的噩梦中缠着你\r\n- I don\'t trust nobody and nobody trusts me\r\n 我不相信任何人，也不奢望别人相信我\r\n- I\'ll be the actress starring in your bad dreams\r\n 我会做女主人公，在你的噩梦中缠着你\r\n- I don\'t trust nobody and nobody trusts me\r\n 我不相信任何人，也不奢望别人相信我\r\n- I\'ll be the actress starring in your bad dreams\r\n 我会做女主人公，在你的噩梦中缠着你\r\n (Look what you made me do)\r\n 瞧瞧你们让我如何回应\r\n (Look what you made me do)\r\n 瞧瞧你们让我如何回应\r\n ”I’m sorry, the old Taylor can\'t come to the phone right now.\r\n 对不起，您呼叫的泰勒已停机，请不要再拨。”\r\n ”Why?”\r\n “为什么?”\r\n ”Oh, \'cause she\'s dead!\" (ohh!)\r\n “噢，因为原来的泰勒已经死了!”\r\n- Ooh, look what you made me do\r\n 噢，瞧瞧你们都让我做了些什么\r\n- Look what you made me do\r\n 瞧瞧你们都让我做了些什么\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Ooh, look what you made me do\r\n 噢，瞧瞧你们都让我做了些什么\r\n- Look what you made me do\r\n 瞧瞧你们都让我做了些什么\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Ooh, look what you made me do\r\n 噢，瞧瞧你们都让我做了些什么\r\n- Look what you made me do\r\n 瞧瞧你们都让我做了些什么\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Ooh, look what you made me do\r\n 噢，瞧瞧你们都让我做了些什么\r\n- Look what you made me do\r\n 瞧瞧你们都让我做了些什么\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n- Look what you just made me do\r\n 瞧瞧你们让我如何回应\r\n', '<ul>\r\n<li>I don’t like your little games<br>你那点伎俩还是别拿出来了</li><li>Don’t like your tilted stage<br>你那浮动舞台效果也逊爆了</li><li>The role you made me play<br>你让我扮演小丑的角色</li><li>Of the fool, no, I don’t like you<br>愚蠢至极的角色，不，我真的不喜欢你</li><li>I don’t like your perfect crime<br>我不喜欢你自导自演的闹剧</li><li>How you laugh when you lie<br>也不喜欢你笑里藏刀的嘴脸</li><li>You said the gun was mine<br>你先发制人，咬定是我先惹的你</li><li>Isn’t cool, no, I don’t like you (oh!)<br>想颠倒黑白？不，我嗤之以鼻</li><li>But I got smarter, I got harder in the nick of time<br>但我懂得适时收手全身而退，待时机成熟重夺王座</li><li>Honey, I rose up from the dead, I do it all the time<br>亲爱的，我向来如此，浴火重生</li><li>I’ve got a list of names and yours is in red, underlined<br>我手里有一长串黑名单，恭喜你被我划了红线</li><li>I check it once, then I check it twice, oh!<br>我翻了翻你的名字，又再三确认</li><li>Ohh, look what you made me do<br>噢，瞧瞧你们都让我做了些什么</li><li>Look what you made me do<br>瞧瞧你们都让我做了些什么</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Ohh, look what you made me do<br>噢，瞧瞧你们都让我做了些什么</li><li>Look what you made me do<br>瞧瞧你们都让我做了些什么</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>I don’t like your kingdom keys<br>我不屑你们手握的奖杯</li><li>They once belonged to me<br>因为那些本属于我</li><li>You ask me for a place to sleep<br>你向我祈求一个容身之所</li><li>Locked me out and threw a feast (what?)<br>却把我反锁在门外，自己享用饕餮大餐(真是看错你了!)</li><li>The world moves on, another day, another drama, drama<br>地球依然旋转，每天上演着不同的戏码</li><li>But not for me, not for me, all I think about is karma<br>但这不关我事，不关我事，我只能说恶有恶报</li><li>And then the world moves on but one thing’s for sure<br>地球还是会转，我也始终确信</li><li>Maybe I got mine, but you’ll all get yours<br>风水轮流转，善恶终有报</li><li>But I got smarter, I got harder in the nick of time<br>但我懂得适时收手全身而退，待时机成熟重夺王座</li><li>Honey, I rose up from the dead, I do it all the time<br>亲爱的，我向来如此，浴火重生</li><li>I’ve got a list of names and yours is in red, underlined<br>我手里有一长串黑名单，恭喜你被我划了红线</li><li>I check it once, then I check it twice, oh!<br>我翻了翻你的名字，又再三确认</li><li>Ohh, look what you made me do<br>噢，瞧瞧你们都让我做了些什么</li><li>Look what you made me do<br>瞧瞧你们让我如何回应</li><li>Look what you just made me do<br>瞧瞧你们都让我做了些什么</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Ohh, look what you made me do<br>噢，瞧瞧你们都让我做了些什么</li><li>Look what you made me do<br>瞧瞧你们都让我做了些什么</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>I don’t trust nobody and nobody trusts me<br>我不相信任何人，也不奢望别人相信我</li><li>I’ll be the actress starring in your bad dreams<br>我会做女主人公，在你的噩梦中缠着你</li><li>I don’t trust nobody and nobody trusts me<br>我不相信任何人，也不奢望别人相信我</li><li>I’ll be the actress starring in your bad dreams<br>我会做女主人公，在你的噩梦中缠着你</li><li>I don’t trust nobody and nobody trusts me<br>我不相信任何人，也不奢望别人相信我</li><li>I’ll be the actress starring in your bad dreams<br>我会做女主人公，在你的噩梦中缠着你</li><li>I don’t trust nobody and nobody trusts me<br>我不相信任何人，也不奢望别人相信我</li><li>I’ll be the actress starring in your bad dreams<br>我会做女主人公，在你的噩梦中缠着你<br>(Look what you made me do)<br>瞧瞧你们让我如何回应<br>(Look what you made me do)<br>瞧瞧你们让我如何回应<br>”I’m sorry, the old Taylor can’t come to the phone right now.<br>对不起，您呼叫的泰勒已停机，请不要再拨。”<br>”Why?”<br>“为什么?”<br>”Oh, ‘cause she’s dead!” (ohh!)<br>“噢，因为原来的泰勒已经死了!”</li><li>Ooh, look what you made me do<br>噢，瞧瞧你们都让我做了些什么</li><li>Look what you made me do<br>瞧瞧你们都让我做了些什么</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Ooh, look what you made me do<br>噢，瞧瞧你们都让我做了些什么</li><li>Look what you made me do<br>瞧瞧你们都让我做了些什么</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Ooh, look what you made me do<br>噢，瞧瞧你们都让我做了些什么</li><li>Look what you made me do<br>瞧瞧你们都让我做了些什么</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Ooh, look what you made me do<br>噢，瞧瞧你们都让我做了些什么</li><li>Look what you made me do<br>瞧瞧你们都让我做了些什么</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li><li>Look what you just made me do<br>瞧瞧你们让我如何回应</li></ul>\r\n', '2016-10-11 17:19:05', '237');
INSERT INTO `article` VALUES ('104', '5', 'Five Hundred Miles', '\r\n- If you miss the train I\'m on,\r\n >若你错过了我搭乘的那班列车\r\n\r\n- You will know that I am gone,\r\n >那就是我已独自黯然离去\r\n\r\n- You can hear the whistle blow a hundred miles.\r\n >你听那绵延百里的汽笛\r\n\r\n- A hundred miles, a hundred miles,\r\n >一百里又一百里 载我远去\r\n\r\n- A hundred miles, A hundred miles,\r\n >一百里又一百里 再回不去\r\n\r\n- You can hear the whistle blow A hundred miles.\r\n >那绵延百里的汽笛会告诉你我离去的讯息\r\n\r\n- Lord, I\'m one, Lord, I\'m two, Lord,\r\n >一百里 两百里 渐渐远去\r\n\r\n- I\'m three, Lord, I\'m four, Lord,\r\n >三百里 四百里 再回不去\r\n\r\n- I\'m five hundred miles away from home.\r\n >不知不觉我便已离家五百余里\r\n\r\n- Away from home, away from home,\r\n >背负一切 离乡背井\r\n\r\n- away from home, away from home,\r\n >家在远方 我却再难回去\r\n\r\n- Lord, I\'m five hundred miles away from home\r\n >上帝啊 家乡离我已有五百余里\r\n\r\n- Not a shirt on my back,\r\n >如今我衣衫褴褛\r\n\r\n- Not a penny to my name.\r\n >依旧是一文不名\r\n\r\n- Lord. I can\'t go back home this-a way.\r\n >上帝啊 我怎能就这样回到家去\r\n\r\n- This-a way, this-a way,\r\n >这般潦倒 这般困顿\r\n\r\n- This-a way, this-a way,\r\n >这般处境 惨惨戚戚\r\n\r\n- Lord, I can\'t go back home this-a way.\r\n >这样的我又怎好意思回到家去\r\n\r\n- If you miss the train I\'m on,\r\n >若那列车开动让我来不及见你\r\n\r\n- You will know that I am gone,\r\n >那就说明我已独自黯然离去\r\n\r\n- You can hear the whistle blow A hundred miles.\r\n >你听那绵延百里的汽笛\r\n\r\n- A hundred miles.\r\n >一百里\r\n\r\n- A hundred miles.\r\n >又一百里 载我远去\r\n\r\n- A hundred miles.\r\n >一百里\r\n\r\n- A hundred miles.\r\n >又一百里 再回不去\r\n\r\n- You can hear the whistle blow a hundred miles\r\n >你听那绵延百里的汽笛 声渐远去\r\n\r\n- You can hear the whistle blow a hundred miles\r\n >告诉着你我已离乡背井 不见归期\r\n\r\n- You can hear the whistle blow a hundred miles\r\n >那绵延百里的汽笛 一如我的叹息\r\n', '<ul>\r\n<li><p>If you miss the train I’m on,</p>\r\n<blockquote>\r\n<p>若你错过了我搭乘的那班列车</p>\r\n</blockquote>\r\n</li><li><p>You will know that I am gone,</p>\r\n<blockquote>\r\n<p>那就是我已独自黯然离去</p>\r\n</blockquote>\r\n</li><li><p>You can hear the whistle blow a hundred miles.</p>\r\n<blockquote>\r\n<p>你听那绵延百里的汽笛</p>\r\n</blockquote>\r\n</li><li><p>A hundred miles, a hundred miles,</p>\r\n<blockquote>\r\n<p>一百里又一百里 载我远去</p>\r\n</blockquote>\r\n</li><li><p>A hundred miles, A hundred miles,</p>\r\n<blockquote>\r\n<p>一百里又一百里 再回不去</p>\r\n</blockquote>\r\n</li><li><p>You can hear the whistle blow A hundred miles.</p>\r\n<blockquote>\r\n<p>那绵延百里的汽笛会告诉你我离去的讯息</p>\r\n</blockquote>\r\n</li><li><p>Lord, I’m one, Lord, I’m two, Lord,</p>\r\n<blockquote>\r\n<p>一百里 两百里 渐渐远去</p>\r\n</blockquote>\r\n</li><li><p>I’m three, Lord, I’m four, Lord,</p>\r\n<blockquote>\r\n<p>三百里 四百里 再回不去</p>\r\n</blockquote>\r\n</li><li><p>I’m five hundred miles away from home.</p>\r\n<blockquote>\r\n<p>不知不觉我便已离家五百余里</p>\r\n</blockquote>\r\n</li><li><p>Away from home, away from home,</p>\r\n<blockquote>\r\n<p>背负一切 离乡背井</p>\r\n</blockquote>\r\n</li><li><p>away from home, away from home,</p>\r\n<blockquote>\r\n<p>家在远方 我却再难回去</p>\r\n</blockquote>\r\n</li><li><p>Lord, I’m five hundred miles away from home</p>\r\n<blockquote>\r\n<p>上帝啊 家乡离我已有五百余里</p>\r\n</blockquote>\r\n</li><li><p>Not a shirt on my back,</p>\r\n<blockquote>\r\n<p>如今我衣衫褴褛</p>\r\n</blockquote>\r\n</li><li><p>Not a penny to my name.</p>\r\n<blockquote>\r\n<p>依旧是一文不名</p>\r\n</blockquote>\r\n</li><li><p>Lord. I can’t go back home this-a way.</p>\r\n<blockquote>\r\n<p>上帝啊 我怎能就这样回到家去</p>\r\n</blockquote>\r\n</li><li><p>This-a way, this-a way,</p>\r\n<blockquote>\r\n<p>这般潦倒 这般困顿</p>\r\n</blockquote>\r\n</li><li><p>This-a way, this-a way,</p>\r\n<blockquote>\r\n<p>这般处境 惨惨戚戚</p>\r\n</blockquote>\r\n</li><li><p>Lord, I can’t go back home this-a way.</p>\r\n<blockquote>\r\n<p>这样的我又怎好意思回到家去</p>\r\n</blockquote>\r\n</li><li><p>If you miss the train I’m on,</p>\r\n<blockquote>\r\n<p>若那列车开动让我来不及见你</p>\r\n</blockquote>\r\n</li><li><p>You will know that I am gone,</p>\r\n<blockquote>\r\n<p>那就说明我已独自黯然离去</p>\r\n</blockquote>\r\n</li><li><p>You can hear the whistle blow A hundred miles.</p>\r\n<blockquote>\r\n<p>你听那绵延百里的汽笛</p>\r\n</blockquote>\r\n</li><li><p>A hundred miles.</p>\r\n<blockquote>\r\n<p>一百里</p>\r\n</blockquote>\r\n</li><li><p>A hundred miles.</p>\r\n<blockquote>\r\n<p>又一百里 载我远去</p>\r\n</blockquote>\r\n</li><li><p>A hundred miles.</p>\r\n<blockquote>\r\n<p>一百里</p>\r\n</blockquote>\r\n</li><li><p>A hundred miles.</p>\r\n<blockquote>\r\n<p>又一百里 再回不去</p>\r\n</blockquote>\r\n</li><li><p>You can hear the whistle blow a hundred miles</p>\r\n<blockquote>\r\n<p>你听那绵延百里的汽笛 声渐远去</p>\r\n</blockquote>\r\n</li><li><p>You can hear the whistle blow a hundred miles</p>\r\n<blockquote>\r\n<p>告诉着你我已离乡背井 不见归期</p>\r\n</blockquote>\r\n</li><li><p>You can hear the whistle blow a hundred miles</p>\r\n<blockquote>\r\n<p>那绵延百里的汽笛 一如我的叹息</p>\r\n</blockquote>\r\n</li></ul>\r\n', '2016-10-11 17:19:59', '517');
INSERT INTO `article` VALUES ('105', '5', 'Mirrors', '\r\n- Aren\'t you somethin\' to admire\r\n >你是令我倾慕的女神\r\n\r\n- Cause your shine is somethin\' like a mirror\r\n >你的光芒如同明镜闪耀\r\n\r\n- And I can\'t help but notice\r\n >情不自禁我注意到\r\n\r\n- You reflect in this heart of mine\r\n >你我心有灵犀\r\n\r\n- If you ever feel alone and\r\n >如果你感到孤寂\r\n\r\n- The glare makes me hard to find\r\n >找不到光芒下的我\r\n\r\n- Just know that I\'m always\r\n >你要知道\r\n\r\n- Parallel on the other side\r\n >你我的另一面是相同的\r\n\r\n- Cause with your hand in my hand and a pocket full of soul\r\n >因为只要你我十指紧扣、心心相印\r\n\r\n- I can tell you there\'s no place we couldn\'t go\r\n >这世上便没有我们到不了的天涯海角\r\n\r\n- Just put your hand on the past\r\n >你陷在过去无法自拔\r\n\r\n- I\'m here tryin\' to pull you through\r\n >我会助你渡过难关\r\n\r\n- You just gotta be strong\r\n >你只需坚强起来\r\n\r\n- Cause I don\'t wanna lose you now\r\n >因为这次我不想失去你\r\n\r\n- I\'m lookin\' right at the other half of me\r\n >看着镜中的另一个自己\r\n\r\n- The biggest scene is set in my heart\r\n >这便是我心中最美的景致\r\n\r\n- There\'s a space, but now you\'re home\r\n >曾经那里空了一块，但现在你已回来\r\n\r\n- Show me how to fight for now\r\n >告诉我该怎么做\r\n\r\n- And I\'ll tell you, baby, it was easy\r\n >我会告诉你,宝贝这轻而易举\r\n\r\n- Comin\' back into you once I figured it out\r\n >一旦我明白了，就回到了你身边\r\n\r\n- You were right here all along\r\n >因为你一直都在\r\n\r\n- It\'s like you\'re my mirror\r\n >你就像是我的镜子\r\n\r\n- My mirror staring back at me\r\n >与我相互凝视的镜子\r\n\r\n- I couldn\'t get any bigger\r\n >我不可能更幸福\r\n\r\n- With anyone else beside me\r\n >除了和你在一起\r\n\r\n- And now it\'s clear as this promise\r\n >如今一切如此清晰\r\n\r\n- That we\'re making\r\n >就像我们许下的承诺\r\n\r\n- Two reflections into one\r\n >我们对彼此的映象合二为一\r\n\r\n- Cause it\'s like you\'re my mirror\r\n >因为你就像是我的镜子\r\n\r\n- My mirror staring back at me, staring back at me\r\n >像我的镜子般凝视着我，凝视着我\r\n\r\n- Aren\'t you somethin\', an original\r\n >你是如此独一无二\r\n\r\n- Cause it doesn\'t seem really as simple\r\n >看起来没有那么简单\r\n\r\n- and i can\'t help but stare cause\r\n >我忍不住会凝视\r\n\r\n- I see truth somewhere in your eyes\r\n >因为我在你的眼睛里看到了真理\r\n\r\n- I can\'t ever change without you\r\n >没有你我无法改变\r\n\r\n- You reflect me, I love that about you\r\n >你映现着我，我爱你这一点\r\n\r\n- And if I could, I\r\n >如果我可以\r\n\r\n- Would look at us all the time\r\n >我会一直看着我们\r\n\r\n- Cause with your hand in my hand and a pocket full of soul\r\n >因为只要你我十指紧扣、心心相印\r\n\r\n- I can tell you there\'s no place we couldn\'t go\r\n >这世上便没有我们到不了的天涯海角\r\n\r\n- Just put your hand on the past\r\n >你陷在过去无法自拔\r\n\r\n- I\'m here tryin\' to pull you through\r\n >我会助你渡过难关\r\n\r\n- You just gotta be strong\r\n >你只需坚强起来\r\n\r\n- Cause I don\'t wanna lose you now\r\n >因为这次我不想失去你\r\n\r\n- I\'m lookin\' right at the other half of me\r\n >看着镜中的另一个自己\r\n\r\n- The biggest scene is set in my heart\r\n >这便是我心中最美的景致\r\n\r\n- There\'s a space, but now you\'re home\r\n >曾经那里空了一块，但现在你已回来\r\n\r\n- Show me how to fight for now\r\n >告诉我该怎么做\r\n\r\n- And I\'ll tell you, baby, it was easy\r\n >我会告诉你,宝贝这轻而易举\r\n\r\n- Comin\' back into you once I figured it out\r\n >一旦我明白了，就回到了你身边\r\n\r\n- You were right here all along\r\n >因为你一直都在\r\n\r\n- It\'s like you\'re my mirror\r\n >你就像是我的镜子\r\n\r\n- My mirror staring back at me\r\n >与我相互凝视的镜子\r\n\r\n- I couldn\'t get any bigger\r\n >我不可能更幸福\r\n\r\n- With anyone else beside me\r\n >除了和你在一起\r\n\r\n- And now it\'s clear as this promise\r\n >如今一切如此清晰\r\n\r\n- That we\'re making\r\n >就像我们许下的承诺\r\n\r\n- Two reflections into one\r\n >我们对彼此的映象合二为一\r\n\r\n- Cause it\'s like you\'re my mirror\r\n >因为你就像是我的镜子\r\n\r\n- My mirror staring back at me, staring back at me\r\n >像我的镜子般凝视着我，凝视着我\r\n\r\n- Yesterday is history\r\n >昨天已成为历史\r\n\r\n- Tomorrow\'s a mystery\r\n >明天神秘不可知\r\n\r\n- I can see you lookin\' back at me\r\n >我可以看到你回头看我\r\n\r\n- Keep your eyes on me\r\n >双眼凝视着我\r\n\r\n- Baby, keep your eyes on me\r\n >宝贝，双眼凝视着我\r\n\r\n- Cause I don\'t wanna lose you now\r\n >因为我现在不想失去你\r\n\r\n- I\'m lookin\' right at the other half of me\r\n >看着镜中的另一个自己\r\n\r\n- The biggest scene is set in my heart\r\n >这便是我心中最美的景致\r\n\r\n- There\'s a space, but now you\'re home\r\n >曾经那里空了一块 但现在你已回来\r\n\r\n- Show me how to fight for now\r\n >告诉我该怎么做\r\n\r\n- And I\'ll tell you, baby, it was easy\r\n >我要告诉你，宝贝这轻而易举\r\n\r\n- Comin\' back into you once I figured it out\r\n >一旦我明白了 就回到了你身边\r\n\r\n- You were right here all along\r\n >因为你一直都在\r\n\r\n- It\'s like you\'re my mirror\r\n >你就像是我的镜子\r\n\r\n- My mirror staring back at me\r\n >与我相互凝视的镜子\r\n\r\n- I couldn\'t get any bigger\r\n >我不可能更幸福\r\n\r\n- With anyone else beside me\r\n >除了和你在一起\r\n\r\n- And now it\'s clear as this promise\r\n >如今一切如此清晰\r\n\r\n- That we\'re making\r\n >就像我们许下的承诺\r\n\r\n- Two reflections into one\r\n >我们对彼此的映象合二为一\r\n\r\n- Cause it\'s like you\'re my mirror\r\n >因为你就像是我的镜子\r\n\r\n- My mirror staring back at me, staring back at me\r\n >像我的镜子般凝视着我，凝视着我\r\n\r\n- Now you’re the inspiration for this precious song\r\n >你是这首珍贵的歌的灵感\r\n\r\n- And I just wanna see your face light up since you put me on\r\n >我想看到你找回我后幸福的表情\r\n\r\n- So now I say goodbye to the old me, it\'s already gone\r\n >所以我现在要告别那个过去的我，它已不在\r\n\r\n- And I can\'t wait wait wait wait wait to get you home\r\n >我迫不及待的想要把你带回家\r\n\r\n- Just to let you know, you are\r\n >想要让你知道，你是\r\n\r\n- Girl you\'re my reflection, all I see is you\r\n >你就是另一个我，我的眼里只有你\r\n\r\n- My reflection, in everything I do\r\n >另一个我，我所做的一切\r\n\r\n- You\'re my reflection and all I see is you\r\n >你就是另一个我，我的眼里只有你\r\n\r\n- My reflection, in everything I do\r\n >另一个我，我所做的一切\r\n', '<ul>\r\n<li><p>Aren’t you somethin’ to admire</p>\r\n<blockquote>\r\n<p>你是令我倾慕的女神</p>\r\n</blockquote>\r\n</li><li><p>Cause your shine is somethin’ like a mirror</p>\r\n<blockquote>\r\n<p>你的光芒如同明镜闪耀</p>\r\n</blockquote>\r\n</li><li><p>And I can’t help but notice</p>\r\n<blockquote>\r\n<p>情不自禁我注意到</p>\r\n</blockquote>\r\n</li><li><p>You reflect in this heart of mine</p>\r\n<blockquote>\r\n<p>你我心有灵犀</p>\r\n</blockquote>\r\n</li><li><p>If you ever feel alone and</p>\r\n<blockquote>\r\n<p>如果你感到孤寂</p>\r\n</blockquote>\r\n</li><li><p>The glare makes me hard to find</p>\r\n<blockquote>\r\n<p>找不到光芒下的我</p>\r\n</blockquote>\r\n</li><li><p>Just know that I’m always</p>\r\n<blockquote>\r\n<p>你要知道</p>\r\n</blockquote>\r\n</li><li><p>Parallel on the other side</p>\r\n<blockquote>\r\n<p>你我的另一面是相同的</p>\r\n</blockquote>\r\n</li><li><p>Cause with your hand in my hand and a pocket full of soul</p>\r\n<blockquote>\r\n<p>因为只要你我十指紧扣、心心相印</p>\r\n</blockquote>\r\n</li><li><p>I can tell you there’s no place we couldn’t go</p>\r\n<blockquote>\r\n<p>这世上便没有我们到不了的天涯海角</p>\r\n</blockquote>\r\n</li><li><p>Just put your hand on the past</p>\r\n<blockquote>\r\n<p>你陷在过去无法自拔</p>\r\n</blockquote>\r\n</li><li><p>I’m here tryin’ to pull you through</p>\r\n<blockquote>\r\n<p>我会助你渡过难关</p>\r\n</blockquote>\r\n</li><li><p>You just gotta be strong</p>\r\n<blockquote>\r\n<p>你只需坚强起来</p>\r\n</blockquote>\r\n</li><li><p>Cause I don’t wanna lose you now</p>\r\n<blockquote>\r\n<p>因为这次我不想失去你</p>\r\n</blockquote>\r\n</li><li><p>I’m lookin’ right at the other half of me</p>\r\n<blockquote>\r\n<p>看着镜中的另一个自己</p>\r\n</blockquote>\r\n</li><li><p>The biggest scene is set in my heart</p>\r\n<blockquote>\r\n<p>这便是我心中最美的景致</p>\r\n</blockquote>\r\n</li><li><p>There’s a space, but now you’re home</p>\r\n<blockquote>\r\n<p>曾经那里空了一块，但现在你已回来</p>\r\n</blockquote>\r\n</li><li><p>Show me how to fight for now</p>\r\n<blockquote>\r\n<p>告诉我该怎么做</p>\r\n</blockquote>\r\n</li><li><p>And I’ll tell you, baby, it was easy</p>\r\n<blockquote>\r\n<p>我会告诉你,宝贝这轻而易举</p>\r\n</blockquote>\r\n</li><li><p>Comin’ back into you once I figured it out</p>\r\n<blockquote>\r\n<p>一旦我明白了，就回到了你身边</p>\r\n</blockquote>\r\n</li><li><p>You were right here all along</p>\r\n<blockquote>\r\n<p>因为你一直都在</p>\r\n</blockquote>\r\n</li><li><p>It’s like you’re my mirror</p>\r\n<blockquote>\r\n<p>你就像是我的镜子</p>\r\n</blockquote>\r\n</li><li><p>My mirror staring back at me</p>\r\n<blockquote>\r\n<p>与我相互凝视的镜子</p>\r\n</blockquote>\r\n</li><li><p>I couldn’t get any bigger</p>\r\n<blockquote>\r\n<p>我不可能更幸福</p>\r\n</blockquote>\r\n</li><li><p>With anyone else beside me</p>\r\n<blockquote>\r\n<p>除了和你在一起</p>\r\n</blockquote>\r\n</li><li><p>And now it’s clear as this promise</p>\r\n<blockquote>\r\n<p>如今一切如此清晰</p>\r\n</blockquote>\r\n</li><li><p>That we’re making</p>\r\n<blockquote>\r\n<p>就像我们许下的承诺</p>\r\n</blockquote>\r\n</li><li><p>Two reflections into one</p>\r\n<blockquote>\r\n<p>我们对彼此的映象合二为一</p>\r\n</blockquote>\r\n</li><li><p>Cause it’s like you’re my mirror</p>\r\n<blockquote>\r\n<p>因为你就像是我的镜子</p>\r\n</blockquote>\r\n</li><li><p>My mirror staring back at me, staring back at me</p>\r\n<blockquote>\r\n<p>像我的镜子般凝视着我，凝视着我</p>\r\n</blockquote>\r\n</li><li><p>Aren’t you somethin’, an original</p>\r\n<blockquote>\r\n<p>你是如此独一无二</p>\r\n</blockquote>\r\n</li><li><p>Cause it doesn’t seem really as simple</p>\r\n<blockquote>\r\n<p>看起来没有那么简单</p>\r\n</blockquote>\r\n</li><li><p>and i can’t help but stare cause</p>\r\n<blockquote>\r\n<p>我忍不住会凝视</p>\r\n</blockquote>\r\n</li><li><p>I see truth somewhere in your eyes</p>\r\n<blockquote>\r\n<p>因为我在你的眼睛里看到了真理</p>\r\n</blockquote>\r\n</li><li><p>I can’t ever change without you</p>\r\n<blockquote>\r\n<p>没有你我无法改变</p>\r\n</blockquote>\r\n</li><li><p>You reflect me, I love that about you</p>\r\n<blockquote>\r\n<p>你映现着我，我爱你这一点</p>\r\n</blockquote>\r\n</li><li><p>And if I could, I</p>\r\n<blockquote>\r\n<p>如果我可以</p>\r\n</blockquote>\r\n</li><li><p>Would look at us all the time</p>\r\n<blockquote>\r\n<p>我会一直看着我们</p>\r\n</blockquote>\r\n</li><li><p>Cause with your hand in my hand and a pocket full of soul</p>\r\n<blockquote>\r\n<p>因为只要你我十指紧扣、心心相印</p>\r\n</blockquote>\r\n</li><li><p>I can tell you there’s no place we couldn’t go</p>\r\n<blockquote>\r\n<p>这世上便没有我们到不了的天涯海角</p>\r\n</blockquote>\r\n</li><li><p>Just put your hand on the past</p>\r\n<blockquote>\r\n<p>你陷在过去无法自拔</p>\r\n</blockquote>\r\n</li><li><p>I’m here tryin’ to pull you through</p>\r\n<blockquote>\r\n<p>我会助你渡过难关</p>\r\n</blockquote>\r\n</li><li><p>You just gotta be strong</p>\r\n<blockquote>\r\n<p>你只需坚强起来</p>\r\n</blockquote>\r\n</li><li><p>Cause I don’t wanna lose you now</p>\r\n<blockquote>\r\n<p>因为这次我不想失去你</p>\r\n</blockquote>\r\n</li><li><p>I’m lookin’ right at the other half of me</p>\r\n<blockquote>\r\n<p>看着镜中的另一个自己</p>\r\n</blockquote>\r\n</li><li><p>The biggest scene is set in my heart</p>\r\n<blockquote>\r\n<p>这便是我心中最美的景致</p>\r\n</blockquote>\r\n</li><li><p>There’s a space, but now you’re home</p>\r\n<blockquote>\r\n<p>曾经那里空了一块，但现在你已回来</p>\r\n</blockquote>\r\n</li><li><p>Show me how to fight for now</p>\r\n<blockquote>\r\n<p>告诉我该怎么做</p>\r\n</blockquote>\r\n</li><li><p>And I’ll tell you, baby, it was easy</p>\r\n<blockquote>\r\n<p>我会告诉你,宝贝这轻而易举</p>\r\n</blockquote>\r\n</li><li><p>Comin’ back into you once I figured it out</p>\r\n<blockquote>\r\n<p>一旦我明白了，就回到了你身边</p>\r\n</blockquote>\r\n</li><li><p>You were right here all along</p>\r\n<blockquote>\r\n<p>因为你一直都在</p>\r\n</blockquote>\r\n</li><li><p>It’s like you’re my mirror</p>\r\n<blockquote>\r\n<p>你就像是我的镜子</p>\r\n</blockquote>\r\n</li><li><p>My mirror staring back at me</p>\r\n<blockquote>\r\n<p>与我相互凝视的镜子</p>\r\n</blockquote>\r\n</li><li><p>I couldn’t get any bigger</p>\r\n<blockquote>\r\n<p>我不可能更幸福</p>\r\n</blockquote>\r\n</li><li><p>With anyone else beside me</p>\r\n<blockquote>\r\n<p>除了和你在一起</p>\r\n</blockquote>\r\n</li><li><p>And now it’s clear as this promise</p>\r\n<blockquote>\r\n<p>如今一切如此清晰</p>\r\n</blockquote>\r\n</li><li><p>That we’re making</p>\r\n<blockquote>\r\n<p>就像我们许下的承诺</p>\r\n</blockquote>\r\n</li><li><p>Two reflections into one</p>\r\n<blockquote>\r\n<p>我们对彼此的映象合二为一</p>\r\n</blockquote>\r\n</li><li><p>Cause it’s like you’re my mirror</p>\r\n<blockquote>\r\n<p>因为你就像是我的镜子</p>\r\n</blockquote>\r\n</li><li><p>My mirror staring back at me, staring back at me</p>\r\n<blockquote>\r\n<p>像我的镜子般凝视着我，凝视着我</p>\r\n</blockquote>\r\n</li><li><p>Yesterday is history</p>\r\n<blockquote>\r\n<p>昨天已成为历史</p>\r\n</blockquote>\r\n</li><li><p>Tomorrow’s a mystery</p>\r\n<blockquote>\r\n<p>明天神秘不可知</p>\r\n</blockquote>\r\n</li><li><p>I can see you lookin’ back at me</p>\r\n<blockquote>\r\n<p>我可以看到你回头看我</p>\r\n</blockquote>\r\n</li><li><p>Keep your eyes on me</p>\r\n<blockquote>\r\n<p>双眼凝视着我</p>\r\n</blockquote>\r\n</li><li><p>Baby, keep your eyes on me</p>\r\n<blockquote>\r\n<p>宝贝，双眼凝视着我</p>\r\n</blockquote>\r\n</li><li><p>Cause I don’t wanna lose you now</p>\r\n<blockquote>\r\n<p>因为我现在不想失去你</p>\r\n</blockquote>\r\n</li><li><p>I’m lookin’ right at the other half of me</p>\r\n<blockquote>\r\n<p>看着镜中的另一个自己</p>\r\n</blockquote>\r\n</li><li><p>The biggest scene is set in my heart</p>\r\n<blockquote>\r\n<p>这便是我心中最美的景致</p>\r\n</blockquote>\r\n</li><li><p>There’s a space, but now you’re home</p>\r\n<blockquote>\r\n<p>曾经那里空了一块 但现在你已回来</p>\r\n</blockquote>\r\n</li><li><p>Show me how to fight for now</p>\r\n<blockquote>\r\n<p>告诉我该怎么做</p>\r\n</blockquote>\r\n</li><li><p>And I’ll tell you, baby, it was easy</p>\r\n<blockquote>\r\n<p>我要告诉你，宝贝这轻而易举</p>\r\n</blockquote>\r\n</li><li><p>Comin’ back into you once I figured it out</p>\r\n<blockquote>\r\n<p>一旦我明白了 就回到了你身边</p>\r\n</blockquote>\r\n</li><li><p>You were right here all along</p>\r\n<blockquote>\r\n<p>因为你一直都在</p>\r\n</blockquote>\r\n</li><li><p>It’s like you’re my mirror</p>\r\n<blockquote>\r\n<p>你就像是我的镜子</p>\r\n</blockquote>\r\n</li><li><p>My mirror staring back at me</p>\r\n<blockquote>\r\n<p>与我相互凝视的镜子</p>\r\n</blockquote>\r\n</li><li><p>I couldn’t get any bigger</p>\r\n<blockquote>\r\n<p>我不可能更幸福</p>\r\n</blockquote>\r\n</li><li><p>With anyone else beside me</p>\r\n<blockquote>\r\n<p>除了和你在一起</p>\r\n</blockquote>\r\n</li><li><p>And now it’s clear as this promise</p>\r\n<blockquote>\r\n<p>如今一切如此清晰</p>\r\n</blockquote>\r\n</li><li><p>That we’re making</p>\r\n<blockquote>\r\n<p>就像我们许下的承诺</p>\r\n</blockquote>\r\n</li><li><p>Two reflections into one</p>\r\n<blockquote>\r\n<p>我们对彼此的映象合二为一</p>\r\n</blockquote>\r\n</li><li><p>Cause it’s like you’re my mirror</p>\r\n<blockquote>\r\n<p>因为你就像是我的镜子</p>\r\n</blockquote>\r\n</li><li><p>My mirror staring back at me, staring back at me</p>\r\n<blockquote>\r\n<p>像我的镜子般凝视着我，凝视着我</p>\r\n</blockquote>\r\n</li><li><p>Now you’re the inspiration for this precious song</p>\r\n<blockquote>\r\n<p>你是这首珍贵的歌的灵感</p>\r\n</blockquote>\r\n</li><li><p>And I just wanna see your face light up since you put me on</p>\r\n<blockquote>\r\n<p>我想看到你找回我后幸福的表情</p>\r\n</blockquote>\r\n</li><li><p>So now I say goodbye to the old me, it’s already gone</p>\r\n<blockquote>\r\n<p>所以我现在要告别那个过去的我，它已不在</p>\r\n</blockquote>\r\n</li><li><p>And I can’t wait wait wait wait wait to get you home</p>\r\n<blockquote>\r\n<p>我迫不及待的想要把你带回家</p>\r\n</blockquote>\r\n</li><li><p>Just to let you know, you are</p>\r\n<blockquote>\r\n<p>想要让你知道，你是</p>\r\n</blockquote>\r\n</li><li><p>Girl you’re my reflection, all I see is you</p>\r\n<blockquote>\r\n<p>你就是另一个我，我的眼里只有你</p>\r\n</blockquote>\r\n</li><li><p>My reflection, in everything I do</p>\r\n<blockquote>\r\n<p>另一个我，我所做的一切</p>\r\n</blockquote>\r\n</li><li><p>You’re my reflection and all I see is you</p>\r\n<blockquote>\r\n<p>你就是另一个我，我的眼里只有你</p>\r\n</blockquote>\r\n</li><li><p>My reflection, in everything I do</p>\r\n<blockquote>\r\n<p>另一个我，我所做的一切</p>\r\n</blockquote>\r\n</li></ul>\r\n', '2016-10-11 17:20:49', '124');
-- ----------------------------
-- Table structure for association
-- ----------------------------
DROP TABLE IF EXISTS `association`;
CREATE TABLE `association` (
`acid` int(11) NOT NULL AUTO_INCREMENT COMMENT '类别-文章关联ID',
`aid` int(11) DEFAULT NULL COMMENT '文章ID',
`cid` int(11) DEFAULT NULL COMMENT '类别ID',
PRIMARY KEY (`acid`),
UNIQUE KEY `aid` (`aid`,`cid`),
KEY `category_fk` (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=311 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of association
-- ----------------------------
INSERT INTO `association` VALUES ('285', '78', '5');
INSERT INTO `association` VALUES ('286', '78', '15');
INSERT INTO `association` VALUES ('287', '78', '16');
INSERT INTO `association` VALUES ('288', '79', '5');
INSERT INTO `association` VALUES ('289', '79', '13');
INSERT INTO `association` VALUES ('290', '79', '16');
INSERT INTO `association` VALUES ('299', '80', '1');
INSERT INTO `association` VALUES ('300', '80', '2');
INSERT INTO `association` VALUES ('301', '80', '4');
INSERT INTO `association` VALUES ('260', '81', '7');
INSERT INTO `association` VALUES ('261', '82', '4');
INSERT INTO `association` VALUES ('263', '83', '2');
INSERT INTO `association` VALUES ('264', '84', '2');
INSERT INTO `association` VALUES ('281', '85', '1');
INSERT INTO `association` VALUES ('282', '85', '4');
INSERT INTO `association` VALUES ('266', '86', '1');
INSERT INTO `association` VALUES ('267', '87', '3');
INSERT INTO `association` VALUES ('268', '88', '3');
INSERT INTO `association` VALUES ('269', '88', '6');
INSERT INTO `association` VALUES ('270', '89', '1');
INSERT INTO `association` VALUES ('271', '89', '3');
INSERT INTO `association` VALUES ('272', '90', '11');
INSERT INTO `association` VALUES ('273', '90', '14');
INSERT INTO `association` VALUES ('274', '91', '11');
INSERT INTO `association` VALUES ('275', '91', '14');
INSERT INTO `association` VALUES ('276', '92', '11');
INSERT INTO `association` VALUES ('277', '92', '14');
INSERT INTO `association` VALUES ('278', '93', '7');
INSERT INTO `association` VALUES ('279', '94', '7');
INSERT INTO `association` VALUES ('280', '95', '6');
INSERT INTO `association` VALUES ('283', '96', '11');
INSERT INTO `association` VALUES ('284', '96', '14');
INSERT INTO `association` VALUES ('297', '97', '5');
INSERT INTO `association` VALUES ('298', '97', '16');
INSERT INTO `association` VALUES ('303', '98', '18');
INSERT INTO `association` VALUES ('302', '98', '20');
INSERT INTO `association` VALUES ('304', '99', '18');
INSERT INTO `association` VALUES ('305', '100', '17');
INSERT INTO `association` VALUES ('306', '101', '17');
INSERT INTO `association` VALUES ('307', '102', '12');
INSERT INTO `association` VALUES ('308', '103', '12');
INSERT INTO `association` VALUES ('309', '104', '19');
INSERT INTO `association` VALUES ('310', '105', '19');
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`cid` int(11) NOT NULL AUTO_INCREMENT COMMENT '类别ID',
`uid` int(11) DEFAULT NULL COMMENT '类别创建者ID',
`category` varchar(255) DEFAULT NULL COMMENT '类别名称',
`gmt_create` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '类别创建时间',
PRIMARY KEY (`cid`),
UNIQUE KEY `uidCategory` (`uid`,`category`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1', '1', 'SpringMVC', '2017-10-05 23:47:11');
INSERT INTO `category` VALUES ('2', '1', 'MyBatis', '2017-10-05 23:47:22');
INSERT INTO `category` VALUES ('3', '1', 'Thymeleaf', '2017-10-05 23:47:33');
INSERT INTO `category` VALUES ('4', '1', 'SpringBoot', '2017-10-05 23:47:40');
INSERT INTO `category` VALUES ('5', '1', 'Shell', '2017-10-05 23:47:47');
INSERT INTO `category` VALUES ('6', '1', 'JavaSE', '2017-10-05 23:47:56');
INSERT INTO `category` VALUES ('7', '1', 'Others', '2017-09-21 10:35:37');
INSERT INTO `category` VALUES ('11', '1', 'CSS', '2017-10-05 23:48:15');
INSERT INTO `category` VALUES ('12', '5', 'Taylor Swift', '2017-10-11 17:08:36');
INSERT INTO `category` VALUES ('13', '1', 'AWK', '2017-10-05 23:49:06');
INSERT INTO `category` VALUES ('14', '1', 'JavaScript', '2017-10-05 23:48:32');
INSERT INTO `category` VALUES ('15', '1', 'SED', '2017-10-05 23:48:57');
INSERT INTO `category` VALUES ('16', '1', 'Linux', '2017-10-06 12:54:34');
INSERT INTO `category` VALUES ('17', '5', 'Ed', '2017-10-11 17:09:16');
INSERT INTO `category` VALUES ('18', '5', 'YUI', '2017-10-11 17:11:46');
INSERT INTO `category` VALUES ('19', '5', 'Justin Timberlake', '2017-10-11 17:09:53');
INSERT INTO `category` VALUES ('20', '5', 'Fullmetal Alchemist', '2017-10-11 17:10:48');
-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`cid` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论ID',
`uid` int(11) DEFAULT NULL COMMENT '用户ID',
`aid` int(11) DEFAULT NULL COMMENT '文章ID',
`comment` text COMMENT '评论内容',
`gmt_comment` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '评论时间',
PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of comment
-- ----------------------------
-- ----------------------------
-- Table structure for history
-- ----------------------------
DROP TABLE IF EXISTS `history`;
CREATE TABLE `history` (
`hid` int(11) NOT NULL AUTO_INCREMENT COMMENT '历史记录ID',
`ip` varchar(15) DEFAULT NULL COMMENT 'IP地址',
`location` varchar(255) DEFAULT NULL,
`uid` int(11) DEFAULT NULL COMMENT '用户ID',
`description` varchar(255) DEFAULT NULL COMMENT '记录描述',
`gmt_record` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '记录时间',
PRIMARY KEY (`hid`)
) ENGINE=InnoDB AUTO_INCREMENT=4183 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of history
-- ----------------------------
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`uid` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`username` varchar(255) NOT NULL COMMENT '用户名',
`password` varchar(255) DEFAULT NULL COMMENT '密码',
`email` varchar(255) DEFAULT NULL COMMENT '邮箱',
`gmt_register` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '注册时间',
`level` int(11) DEFAULT '1' COMMENT '用户等级',
PRIMARY KEY (`uid`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('5', 'test', 'test', '[email protected]', '2017-10-16 15:48:59', '1');
DROP TRIGGER IF EXISTS `deleteByaid`;
DELIMITER ;;
CREATE TRIGGER `deleteByaid` AFTER DELETE ON `article` FOR EACH ROW BEGIN
DELETE FROM `association` WHERE `aid` = old.aid;
END
;;
DELIMITER ;
DROP TRIGGER IF EXISTS `deleteByCid`;
DELIMITER ;;
CREATE TRIGGER `deleteByCid` AFTER DELETE ON `category` FOR EACH ROW BEGIN
DELETE FROM `association` WHERE `aid` = old.cid;
END
;;
DELIMITER ;
SET FOREIGN_KEY_CHECKS=1;