基于tomcat+spring+mysql搭建的个人博客 – 方方和圆圆

  基于tomcat和spring开发的个人博客, 服务器是基于tomcat, 用了spring框架, web.xml的配置简单明了,我们只要配置MYSQL和用户过滤器等, 服务器的jsp就是负责VIEW, 用户通过ajax请求, 与服务器进行交互, 编辑器使用了百度的UEeditor;;

     

  数据表

  数据库有四个表,一切基于数据进行展开, 用户表, 博客内容表, 博客评论表以及友情链接的表:

//用户表;
CREATE TABLE `user` (
`username`
varchar(20) NOT NULL DEFAULT ,
`password`
varchar(20) DEFAULT NULL,
PRIMARY KEY (`username`)
) ENGINE
=InnoDB DEFAULT CHARSET=gb2312 COMMENT=用户;

//博客内容表;
CREATE TABLE `article` (
`Id`
int(11) NOT NULL AUTO_INCREMENT,
`title`
varchar(50) DEFAULT NULL,
`content`
text,
`username`
varchar(50) DEFAULT NULL,
`date`
datetime DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `username` (`username`),
CONSTRAINT `article_ibfk_1` FOREIGN KEY (`username`) REFERENCES `user` (`username`)
) ENGINE
=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312 COMMENT=博客内容;

//博客评论;
CREATE TABLE `critique` (
`Id`
int(11) NOT NULL AUTO_INCREMENT,
`AId`
int(11) DEFAULT NULL,
`content`
text,
`username`
varchar(50) DEFAULT NULL,
PRIMARY KEY (`Id`),
KEY `AId` (`AId`),
CONSTRAINT `critique_ibfk_1` FOREIGN KEY (`AId`) REFERENCES `article` (`Id`)
) ENGINE
=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312 COMMENT=博客评论;

//友情链接的表
CREATE TABLE `links` (
`name`
varchar(20) NOT NULL DEFAULT ,
`url`
varchar(80) DEFAULT NULL
) ENGINE
=InnoDB DEFAULT CHARSET=gb2312 COMMENT=友情链接;

 

  路由

  首页的路由和用户的路由: 所有博客内容列表路由, 博客登录路由, 博客的详细内容路由, 写博客的路由, 比如登录路由和写博客的路由既包含post也包含get

  主界面路由 MainCon.java

package com.nono.Controller;

import java.util.ArrayList;

import javax.naming.LinkRef;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import net.sf.jsqlparser.expression.operators.arithmetic.Addition;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.servlet.ModelAndView;

import com.nono.Dao.GetLinks;
import com.nono.Service.CompareUserService;
import com.nono.Service.GetAllArticle;
import com.nono.po.ArticlePo;
import com.nono.po.Link;

@Controller
public class MainCon {

@Autowired
CompareUserService compareUserService;

@Autowired
GetAllArticle getAllArticle;

@Autowired
GetLinks getLinks;

@RequestMapping(value=”index”,method = RequestMethod.GET)
public ModelAndView index(ServletRequest request, ServletResponse response) {
ArrayList
<ArticlePo> list = getAllArticle.getAll();
ModelAndView maView
= new ModelAndView(“list-index”);
maView.addObject(
“list”, list);
maView.addObject(
“links”, getLinks.getLinks());
ArrayList
<Link> links = getLinks.getLinks();
return maView;
}

@RequestMapping(value=”login”,method = RequestMethod.GET)
public String login(ServletRequest request, ServletResponse response) {
return “login”;
}

@RequestMapping(value=”login”,method = RequestMethod.POST)
public ModelAndView loginPost(HttpServletRequest request, HttpServletResponse response) {
String nameString
= (String)request.getParameter(“username”);
String password
= (String)request.getParameter(“password”);
//获取session;
HttpSession session = request.getSession(false);
ModelAndView mav;
Boolean boolean1
= compareUserService.isRightPassword(nameString, password);
ArrayList
<ArticlePo> list = getAllArticle.getAll();

if(boolean1 == true) {
mav
= new ModelAndView(“list-index”);
//设置用户名字为session;
session.setAttribute(“user”, nameString);

mav.addObject(“list”, list);
mav.addObject(
“links”, getLinks.getLinks());
}
else{
mav
= new ModelAndView(“login”);
mav.addObject(
“state”, “密码错误”);
};
mav.addObject(
“links”, getLinks.getLinks());
return mav;
}

}

  博客的详细内容和写博客的路由 ArticleCon.java

package com.nono.Controller;

import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import com.nono.Dao.AddArt;
import com.nono.Dao.AddCommentDao;
import com.nono.Dao.GetLinks;
import com.nono.Service.GetArticalByIdService;
import com.nono.po.ArticlePo;

@Controller
@RequestMapping (“user”)
public class ArticleCon {

@Autowired
GetArticalByIdService getArticalByIdSer;

@Autowired
AddCommentDao addCommentDao;

@Autowired
GetLinks getLinks;

@Autowired
AddArt addArt;

@RequestMapping(value=”add”, method=RequestMethod.GET)
public String addArticle(ServletRequest request, ServletResponse response) {
return “addArticle”;
}

@RequestMapping(value=”show”, method=RequestMethod.GET)
public ModelAndView showArticle(ServletRequest request, ServletResponse response) {
ModelAndView mavAndView
= new ModelAndView(“showArticle”);
int articalID = Integer.parseInt( request.getParameter(“aid”) );
ArticlePo articlePo
= getArticalByIdSer.getByAid( articalID );
mavAndView.addObject(
“art”, articlePo);
mavAndView.addObject(
“coms”, getArticalByIdSer.getComByAid(articalID));
mavAndView.addObject(
“links”, getLinks.getLinks());
return mavAndView;
}

@RequestMapping(value=”addComment”,method=RequestMethod.POST)
@ResponseBody
public String post(ServletRequest request, ServletResponse response) {
String string
= “false”;
String aid
= request.getParameter(“aid”);
String name
= request.getParameter(“name”);
String content
= request.getParameter(“content”);
if(true == addCommentDao.addCommentDao(aid, name, content) ) {
string
= “true”;
};
return string;
}

@RequestMapping(value=”addArt”,method=RequestMethod.POST)
@ResponseBody
public String addArt(ServletRequest request, ServletResponse response) {
String string
= “false”;
String content
= request.getParameter(“content”);
String title
= request.getParameter(“title”);
if(true == addArt.addArt(title, content) ) {
string
= “true”;
};
return string;
}

}

 

 

  项目的结构如图:

  

  

  web.xml和application-servlet.xml的配置:

<?xml version=”1.0″ encoding=”UTF-8″?>
<web-app version=”3.0″
xmlns
=”http://java.sun.com/xml/ns/javaee”
xmlns:xsi
=”http://www.w3.org/2001/XMLSchema-instance”
xsi:schemaLocation
=”http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd”
>
<display-name></display-name>
<welcome-file-list>
<welcome-file>index.htm</welcome-file>
</welcome-file-list>

<servlet>
<servlet-name>application</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>

<servlet-mapping>
<servlet-name>application</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>

<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

<!–
使用Spring中的过滤器解决在请求和应答中的中文乱码问题
–>
<filter>
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf-8</param-value>
</init-param>
<init-param>
<!–
强制转换编码(request和response均适用)
–>
<param-name>ForceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>

<filter>
<filter-name>SecurityServlet</filter-name>
<filter-class>com.nono.Filter.UserFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>SecurityServlet</filter-name>
<url-pattern>*.do</url-pattern>
</filter-mapping>

<context-param>
<param-name>
contextConfigLocation
</param-name>
<param-value>
/WEB-INF/application-servlet.xml
</param-value>
</context-param>
</web-app>

<?xml version=”1.0″ encoding=”UTF-8″ ?>
<beans xmlns=”http://www.springframework.org/schema/beans”
xmlns:xsi
=”http://www.w3.org/2001/XMLSchema-instance” xmlns:p=”http://www.springframework.org/schema/p”
xmlns:context
=”http://www.springframework.org/schema/context”
xmlns:aop
=”http://www.springframework.org/schema/aop”
xmlns:tx
=”http://www.springframework.org/schema/tx”
xmlns:mvc
=”http://www.springframework.org/schema/mvc”
xmlns:task
=”http://www.springframework.org/schema/task”
xsi:schemaLocation
=”http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
http://www.springframework.org/schema/task
http://www.springframework.org/schema/task/spring-task-3.0.xsd”
>

<context:annotation-config> </context:annotation-config>
<context:component-scan base-package=”com.nono” > </context:component-scan>

<bean name=”dataSource” class=”org.springframework.jdbc.datasource.DriverManagerDataSource”>
<property name=”driverClassName” value=”com.mysql.jdbc.Driver” />
<property name=”url” value=”jdbc:mysql://127.0.0.1:3306/db_blog_” />
<property name=”username” value=”root” />
<property name=”password” value=”111111″ />
</bean>

<bean id=”jdbcTemplate” class=”org.springframework.jdbc.core.JdbcTemplate” abstract=”false” lazy-init=”false” autowire=”default”>
<!– 把这个bean传进去 –>
<property name=”dataSource” ref=”dataSource”>
</property>
</bean>

<bean id=”jdbcDao” class=”com.nono.Dao.JdbcDao”>
<property name=”jdbcTemplate” ref=”jdbcTemplate”></property>
</bean>

<bean id=”viewResolver” class=”org.springframework.web.servlet.view.InternalResourceViewResolver”>
<property name=”suffix”>
<value>.jsp</value>
</property>
</bean>
</beans>

 

 

  

  使用了Filter过滤器实现用户只有登录的情况下才能发布博客, 否则只能允许跳转到登录界面, 主界面如下:       

  

  下面为静态界面, 包含登录页, 首页, 博客详细页, 添加博客页,( •̀ ω •́ )y;

  login.do:

<%@ page language=java contentType=text/html; charset=utf-8%>
<%@ taglib uri=http://java.sun.com/jsp/jstl/core prefix=c%>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml” lang=”en” xml:lang=”en”>
<head>
<title>博客系统登录</title>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
<link type=”text/css” rel=”stylesheet” href=”css/main.css” media=”all” />
<!–[if IE 6]><link type=”text/css” rel=”stylesheet” href=”css/ie6.css” media=”all” /><![endif]–>
<script type=”text/javascript” src=”js/mootools.js”></script>
<script type=”text/javascript” src=”js/site.js”></script>
</head>
<body>
<div id=”wrapper”>
<div id=”container”>
<div id=”scene”> <img src=”images/scene.jpg” alt=”” />
<div id=”scale_area”>
<div id=”scale_knob”>&raquo; Font Size &laquo;</div>
</div>
</div>
<div id=”content”>
<div id=”col_left”>
<div class=”post”>
<div class=”meta”></div>
<div class=”comments”><div class=”comment”></div>
<h2>博客登录</h2>
<form class=”h” method=”post”>
<p>
${state}
</p>
<div>
<label>用户名:</label>
<input type=”text” name=”username” />
</div>
<div>
<label>密码:</label>
<input type=”password” name=”password” />
</div>
<div>
<label></label>
<div class=”clear”> </div>
</div>
<div class=”button_wrapper”>
<input name=”提交” type=”submit” class=”button” value=”登录” />
</div>
</form>
</div>
</div>
</div>
<div id=”col_right”>
<div id=”links”>
<c:forEach items=”${links}” var=”item”>
<a href=”${item.url}”> ${item.name} </a>
</c:forEach>
</div>
<div id=”sidebar”>
<h2>页面导航</h2>
<ul>
<li class=”holder”> <a href=”index.do”>文章列表</a> </li>
<c:if test=”${user==null}”>
<li class=”holder”> <a href=”login.do”>博客登录</a> </li>
</c:if>
<c:if test=”${user!=null}”>
<li class=”holder”> <a href=”user/add.do”>写新博客</a> </li>
</c:if>
</ul>
</div>
</div>
<div class=”clear”> </div>
</div>
<div id=”footer”>
<div class=”clear”> </div>
<hr />
<p class=”credit”>博客网站系统</p>
</div>
</div>
</div>
</body>
</html>

  index.do:

<%@ page language=java contentType=text/html; charset=utf-8%>
<%@ taglib uri=http://java.sun.com/jsp/jstl/core prefix=c%>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml” lang=”en” xml:lang=”en”>
<head>
<title>博客系统首页</title>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
<link type=”text/css” rel=”stylesheet” href=”css/main.css” media=”all” />
<!–[if IE 6]><link type=”text/css” rel=”stylesheet” href=”css/ie6.css” media=”all” /><![endif]–>
<script type=”text/javascript” src=”js/mootools.js”></script>
<script type=”text/javascript” src=”js/site.js”></script>
</head>
<body>
<div id=”wrapper”>
<div id=”container”>
<div id=”scene”>
<img src=”images/scene.jpg” alt=”” />
<div id=”scale_area”>
<div id=”scale_knob”>&raquo; Font Size &laquo;</div>
</div>
</div>
<div id=”content”>
<div id=”col_left”>
<div class=”post”>
<div class=”meta”><a class=”title” href=””>博客系统首页</a>
<div class=”clear”></div>
</div>
<!– 循环输出 –>

<c:forEach items=”${list}” var=”item”>

<div class=”comments”>
<div class=”comment”>
<div class=”meta”> <span><a href=”user/show.do?aid=${item.id}”>${item.title}</a> <small>:</small></span>
<div class=”clear”> </div>
</div>
<div>
${item.content}
</div>
</div>
<div class=”comment alt”>
<div class=”meta”><span class=”datetime”>
<!– 发表时间 –>
发表于:
${item.date}
</span>
<div class=”clear”> </div>
</div>
</div>
</div>

</c:forEach>

</div>
</div>
<div id=”col_right”>
<div id=”links”>
<c:forEach items=”${links}” var=”item”>
<a href=”${item.url}”> ${item.name} </a>
</c:forEach>
</div>
<div id=”sidebar”>
<h2>页面导航</h2>
<ul>
<li class=”holder”> <a href=”index.do”>文章列表</a> </li>
<c:if test=”${user==null}”>
<li class=”holder”> <a href=”login.do”>博客登录</a> </li>
</c:if>
<c:if test=”${user!=null}”>
<li class=”holder”> <a href=”user/add.do”>写新博客</a> </li>
</c:if>
</ul>
</div>
</div>
<div class=”clear”> </div>
</div>
<div id=”footer”>
<div class=”clear”> </div>
<hr />
<p class=”credit”>博客网站系统</p>
</div>
</div>
</div>
</body>
</html>

  add.do:

<%@ page language=java import=java.util.* pageEncoding=utf-8%>
<%@ taglib uri=http://java.sun.com/jsp/jstl/core prefix=c%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+://+request.getServerName()+:+request.getServerPort()+path;
%>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml” lang=”en” xml:lang=”en”>
<head>
<title>添加文章</title>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
<link type=”text/css” rel=”stylesheet” href=”../css/main.css” media=”all” />
<script src=”http://cdn.bootcss.com/jquery/1.9.0/jquery.js”></script>
<!–[if IE 6]><link type=”text/css” rel=”stylesheet” href=”css/ie6.css” media=”all” /><![endif]–>
<script type=”text/javascript” src=”../js/mootools.js”></script>
<script type=”text/javascript” src=”../js/site.js”></script>
<script type=”text/javascript” charset=”utf-8″ src=”<%=basePath%>/editor/ueditor.config.js”></script>
<script type=”text/javascript” charset=”utf-8″ src=”<%=basePath%>/editor/ueditor.all.min.js”> </script>
<!–建议手动加在语言,避免在ie下有时因为加载语言失败导致编辑器加载失败–>
<!–这里加载的语言文件会覆盖你在配置项目里添加的语言类型,比如你在配置项目里配置的是英文,这里加载的中文,那最后就是中文–>
<script type=”text/javascript” charset=”utf-8″ src=”<%=basePath%>/editor/lang/zh-cn/zh-cn.js”></script>
</head>
<body>
<div id=”wrapper”>
<div id=”container”>
<div id=”scene”> <img src=”../images/scene.jpg” alt=”” />
<div id=”scale_area”>
<div id=”scale_knob”>&raquo; Font Size &laquo;</div>
</div>
</div>
<div id=”content”>
<div id=”col_left”>
<div class=”post”>
<div class=”meta”></div>
<div class=”comments”><div class=”comment”></div>
<h2>添加文章</h2>
<div>
<label>标题:</label>
<input id=”title” type=”text” name=”title” />
</div>
<div>
<label>内容:</label>
<div>
<script id=”c” type=”text/plain”></script>
</div>

</div>
<div>
<label></label>
<div class=”clear”> </div>
</div>
<div class=”button_wrapper”>
<input id=”submit” name=”提交” type=”submit” class=”button” value=”提交” />
</div>
<script>
jQuery(
#submit).click(function() {
jQuery.post(
addArt.do, {content:window.ue.getContent(), title: jQuery(#title).val()}, function( response ) {
if(response === true) {
location.href
= ../index.do;
}
});
});
jQuery(
function(){
window.ue
= UE.getEditor(c);
});
</script>
</div>
</div>
</div>
<div id=”col_right”>
<div id=”links”>
<c:forEach items=”${links}” var=”item”>
<a href=”${item.url}”> ${item.name} </a>
</c:forEach>
</div>
<div id=”sidebar”>
<h2>页面导航</h2>
<ul>
<li class=”holder”> <a href=”../index.do”>文章列表</a> </li>
<c:if test=”${user==null}”>
<li class=”holder”> <a href=”../login.do”>博客登录</a> </li>
</c:if>
<c:if test=”${user!=null}”>
<li class=”holder”> <a href=”add.do”>写新博客</a> </li>
</c:if>
</ul>
</div>
</div>
<div class=”clear”> </div>
</div>
<div id=”footer”>
<div class=”clear”> </div>
<hr />
<p class=”credit”>博客网站系统</p>
</div>
</div>
</div>
</body>
</html>

  show.do:

<%@ page language=java contentType=text/html; charset=utf-8%>
<%@ taglib uri=http://java.sun.com/jsp/jstl/core prefix=c%>
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml” lang=”en” xml:lang=”en”>
<head>
<title>我的文章</title>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
<link type=”text/css” rel=”stylesheet” href=”../css/main.css” media=”all” />
<!–[if IE 6]><link type=”text/css” rel=”stylesheet” href=”css/ie6.css” media=”all” /><![endif]–>
<script src=”http://cdn.bootcss.com/jquery/1.9.0/jquery.js”></script>
<script type=”text/javascript” src=”../js/mootools.js”></script>
<script type=”text/javascript” src=”../js/site.js”></script>
</head>
<body>
<div id=”wrapper”>
<div id=”container”>
<div id=”scene”>
<img src=”../images/scene.jpg” alt=”” />
<div id=”scale_area”>
<div id=”scale_knob”>&raquo; Font Size &laquo;</div>
</div>
</div>
<div id=”content”>
<div id=”col_left”>
<div class=”post”>
<div class=”meta”>
<a class=”title” href=””>${art.title}</a>
<div class=”clear”></div>
<div class=”blog_content”>
${art.content}
</div>
</div>
<c:forEach items=”${coms}” var=”item”>
<div class=”comments”>
<div class=”comment”>
<div class=”meta”>
<span>
${item.username}:
${item.content}
</span>
<div class=”clear”> </div>
</div>
</div>
</div>
</c:forEach>
<!– 循环输出 –>
<div class=”clear”> </div>
<div class=”comment”>
<h2>发表评论</h2>
<div>
<input id=”c” type=”text” value=”” placeHolder=”评论”/>
<input id=”n” type=”text” value=”匿名” placeHolder=”您的名字”/>
<br/>
<br/>
<div class=”button_wrapper”>
<input id=”submit” name=”提交” type=”submit” class=”button” value=”提交” />
</div>
</div>
<script>
$(
submit).addEvent(click,function(ev) {
jQuery.post(
./addComment.do,{aid : location.href.substr(location.href.indexOf(aid)+4), name:jQuery(#n).val(), content:jQuery(#c).val()},function( res ){
if(res===true) {
location.reload();
};
});
});
</script>
</div>
</div>
</div>
<div id=”col_right”>
<div id=”links”>
<c:forEach items=”${links}” var=”item”>
<a href=”${item.url}”> ${item.name} </a>
</c:forEach>
</div>
<div id=”sidebar”>
<h2>页面导航</h2>
<ul>
<li class=”holder”> <a href=”../index.do”>文章列表</a> </li>
<c:if test=”${user==null}”>
<li class=”holder”> <a href=”../login.do”>博客登录</a> </li>
</c:if>
<c:if test=”${user!=null}”>
<li class=”holder”> <a href=”add.do”>写新博客</a> </li>
</c:if>
</ul>
</div>
</div>
<div class=”clear”> </div>
</div>
<div id=”footer”>
<div class=”clear”> </div>
<hr />
<p class=”credit”>博客网站系统</p>
</div>
</div>
</body>
</html>

 

  项目源代码分享到百度云盘,jar包等都全部导出了,可作为参考:打开

 

作者: NONO
出处:http://www.cnblogs.com/diligenceday/
QQ:287101329 

本文链接:基于tomcat+spring+mysql搭建的个人博客,转载请注明。



You must enable javascript to see captcha here!

Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress

无觅相关文章插件,快速提升流量