亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb

首頁 > 學院 > 開發設計 > 正文

基于tomcat+spring+mysql搭建的個人博客

2019-11-15 01:11:31
字體:
來源:轉載
供稿:網友
基于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='友情鏈接';
View Code

  路由

  首頁的路由和用戶的路由: 所有博客內容列表路由, 博客登錄路由, 博客的詳細內容路由, 寫博客的路由, 比如登錄路由和寫博客的路由既包含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;@Controllerpublic 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;     }    }
View Code

  博客的詳細內容和寫博客的路由 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;    }    }
View Code

  項目的結構如圖:

  

  

  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>
View Code
<?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>
View Code

  

  使用了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>
View Code

  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>
View Code

  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>
View Code

  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>
View Code

  項目源代碼分享到百度云盤,jar包等都全部導出了,可作為參考:打開

作者: NONO 出處:http://www.49028c.com/diligenceday/QQ:287101329


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
亚洲香蕉成人av网站在线观看_欧美精品成人91久久久久久久_久久久久久久久久久亚洲_热久久视久久精品18亚洲精品_国产精自产拍久久久久久_亚洲色图国产精品_91精品国产网站_中文字幕欧美日韩精品_国产精品久久久久久亚洲调教_国产精品久久一区_性夜试看影院91社区_97在线观看视频国产_68精品久久久久久欧美_欧美精品在线观看_国产精品一区二区久久精品_欧美老女人bb
亚洲欧美在线免费| 一个人看的www久久| www.精品av.com| www.精品av.com| 97在线视频一区| 精品视频久久久久久| 欧美日韩精品二区| 伊人精品在线观看| 日韩在线观看成人| 国产精品夜色7777狼人| 欧美黑人性生活视频| 久久精品国产99国产精品澳门| 国产精品av在线| 亚洲电影免费观看高清完整版在线观看| 精品国产欧美一区二区三区成人| 日韩欧美高清在线视频| 精品国产一区二区三区久久狼5月| 97香蕉超级碰碰久久免费软件| 国产偷国产偷亚洲清高网站| 在线播放日韩av| 97视频在线播放| 国产午夜精品全部视频在线播放| 国产一区二区香蕉| 国产精品av免费在线观看| 97视频在线观看免费| 国产精品欧美日韩久久| 成人综合国产精品| 91精品久久久久久综合乱菊| 日韩美女中文字幕| 91精品久久久久久久| 亚洲国产日韩欧美在线图片| 欧美夫妻性生活视频| 日韩在线免费高清视频| 欧美丝袜一区二区三区| 欧美美女18p| 北条麻妃久久精品| 国产精品91视频| 国产视频精品久久久| 亚洲综合精品一区二区| 欧美福利视频在线观看| 在线日韩精品视频| 亚洲国产精品悠悠久久琪琪| 中文.日本.精品| 精品国产网站地址| 成人免费视频在线观看超级碰| 91麻豆国产语对白在线观看| 久久成人精品一区二区三区| 综合网日日天干夜夜久久| 亚洲精品成a人在线观看| 91精品国产91久久久久久久久| 91性高湖久久久久久久久_久久99| 国内精品视频在线| 精品亚洲男同gayvideo网站| 国产人妖伪娘一区91| 欧美一区二区三区图| 国产精品一二区| 日韩国产在线看| 日本精品性网站在线观看| 日韩成人中文字幕| 91成品人片a无限观看| 日韩第一页在线| 久久成人一区二区| 日韩av电影国产| 中文字幕精品久久| 日韩视频免费观看| 久久91超碰青草是什么| 日韩有码视频在线| 国产欧美日韩中文| 奇米影视亚洲狠狠色| 欧美区二区三区| 亚洲精品一区二区在线| 中国人与牲禽动交精品| 欧美精品制服第一页| 91免费电影网站| 久久久久久国产精品| 精品久久久久久亚洲国产300| 日韩在线不卡视频| 啪一啪鲁一鲁2019在线视频| 欧美天堂在线观看| 亚洲一区二区免费| 国产精品第二页| 伊人青青综合网站| 欧美日韩成人在线播放| 成人免费视频在线观看超级碰| 亚洲欧美中文日韩在线| 欧美一级淫片丝袜脚交| 日韩中文字幕不卡视频| 全色精品综合影院| xvideos亚洲| 久久中文字幕在线视频| 亚洲午夜久久久久久久| 91社区国产高清| 亚洲小视频在线| 久久99青青精品免费观看| 伊人久久久久久久久久| 久久久久女教师免费一区| 羞羞色国产精品| 亚洲男女自偷自拍图片另类| 欧美激情视频一区| 亚洲欧美国产精品专区久久| 久久久久久国产精品三级玉女聊斋| 久久激情视频久久| 日韩免费观看高清| 俺去亚洲欧洲欧美日韩| 亚洲国产欧美一区二区三区同亚洲| 日韩精品久久久久久福利| 久久久久99精品久久久久| 欧美亚洲另类在线| 国产精品久久久久久亚洲调教| 久久精品国产亚洲7777| 精品成人乱色一区二区| 3344国产精品免费看| 欧美一级片免费在线| 日产日韩在线亚洲欧美| 欧美性xxxx极品hd欧美风情| 国产ts人妖一区二区三区| 欧美成人午夜影院| 国产精品久久久久久久电影| 久久最新资源网| 国外色69视频在线观看| 国产精品免费久久久久影院| 日韩欧美精品网址| 91免费看片在线| 国产精品看片资源| 国产精品色悠悠| 91精品国产综合久久男男| 精品亚洲永久免费精品| 欧美猛交ⅹxxx乱大交视频| 国产999精品视频| 亚洲成人激情图| 欧美激情在线观看视频| 色婷婷综合久久久久中文字幕1| 最新国产成人av网站网址麻豆| 中文字幕日韩欧美| 日韩精品在线免费观看| 国产成人短视频| 亚洲国产日韩一区| 国产精品久久久久久av下载红粉| 国产精品久久久久久久久影视| 91精品国产高清久久久久久| 国模精品视频一区二区三区| 亚洲一区二区中文| 国语自产精品视频在线看| 国产精品久久不能| 国产日产欧美a一级在线| 日韩av一区在线| 成人国产精品免费视频| 国产精品嫩草影院一区二区| 国产日韩欧美影视| 欧美另类高清videos| 欧美高清视频免费观看| 久久精品影视伊人网| 国产精品99久久久久久www| 国产69精品99久久久久久宅男| 欧美午夜久久久| 亚洲视频一区二区| 国产一区二区三区四区福利| 国产精品三级美女白浆呻吟| 亚洲热线99精品视频| 国产精品99久久久久久白浆小说| 欧美视频中文字幕在线| 91成人在线视频| 国产不卡视频在线| 国产视频欧美视频|