JavaWeb 项目 --- 博客系统

转x33g5p2x  于2022-05-16 转载在 Java  
字(37.0k)|赞(0)|评价(0)|浏览(619)

1. 创建 maven 项目

创建必要的目录.引入需要的依赖

2. 设计数据库

本系统要存入博客文章的信息,
创建博客表.博客的id,博客的标题,博客的内容,博客的日期,博文的博主id
也要存入用户的信息,
创建用户表,用户id,用户名,用户密码

  1. create database if not exists MyBlogSystem;
  3. use MyBlogSystem;
  5. drop table if exists blog;
  7. -- 创建一个博客表
  8. create table blog (
  9.     blogId int primary key auto_increment,
  10.     title varchar(1024),
  11.     content mediumtext,
  12.     postTime datetime,
  13.     userId int
  14. );
  16. drop table if exists user;
  18. -- 创建一个用户信息表
  19. create table user (
  20.     userId int primary key auto_increment,
  21.     username varchar(128) unique,
  22.     password varchar(128)
  23. );

3. 封装数据库的操作代码

创建包Dao用来放数据库的代码.

3.1 创建 DBUtil 类

用来连接数据库

  1. package Dao;
  3. import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;
  5. import javax.sql.DataSource;
  6. import java.sql.Connection;
  7. import java.sql.PreparedStatement;
  8. import java.sql.ResultSet;
  9. import java.sql.SQLException;
  11. public class DBUtil {
  12.     private static final String URL = "jdbc:mysql://127.0.0.1:3306/MyBlogSystem?characterEncoding=utf8&useSSL=true&serverTimezone=UTC";
  13.     private static final String USERNAME = "root";
  14.     private static final String PASSWORD = "0000";
  16.     private static volatile DataSource dataSource = null;
  18.     private static DataSource getDataSource() {
  19.         if(dataSource == null){
  20.             synchronized(DBUtil.class){
  21.                 if(dataSource == null){
  22.                     dataSource = new MysqlDataSource();
  23.                     ((MysqlDataSource) dataSource).setURL(URL);
  24.                     ((MysqlDataSource) dataSource).setUser(USERNAME);
  25.                     ((MysqlDataSource) dataSource).setPassword(PASSWORD);
  26.                 }
  27.             }
  28.         }
  29.         return dataSource;
  30.     }
  32.     public static Connection getConnection() throws SQLException {
  33.         return getDataSource().getConnection();
  34.     }
  36.     public static void close(Connection connection, PreparedStatement statement, ResultSet resultSet){
  37.         if(resultSet != null){
  38.             try {
  39.                 resultSet.close();
  40.             } catch (SQLException e) {
  41.                 e.printStackTrace();
  42.             }
  43.         }
  44.         if(statement != null){
  45.             try {
  46.                 statement.close();
  47.             } catch (SQLException e) {
  48.                 e.printStackTrace();
  49.             }
  50.         }
  51.         if(connection != null){
  52.             try {
  53.                 connection.close();
  54.             } catch (SQLException e) {
  55.                 e.printStackTrace();
  56.             }
  57.         }
  58.     }
  59. }

3.2 创建类 Blog (代表一篇博客)

Blog

  1. package Dao;
  3. import java.sql.Timestamp;
  5. public class Blog {
  6.     public int blogId;
  7.     public String title;
  8.     public String content;
  9.     public Timestamp postTime;
  10.     public int userId;
  12.     public int getBlogId() {
  13.         return blogId;
  14.     }
  16.     public void setBlogId(int blogId) {
  17.         this.blogId = blogId;
  18.     }
  20.     public String getTitle() {
  21.         return title;
  22.     }
  24.     public void setTitle(String title) {
  25.         this.title = title;
  26.     }
  28.     public String getContent() {
  29.         return content;
  30.     }
  32.     public void setContent(String content) {
  33.         this.content = content;
  34.     }
  36.     public Timestamp getPostTime() {
  37.         return postTime;
  38.     }
  40.     public void setPostTime(Timestamp postTime) {
  41.         this.postTime = postTime;
  42.     }
  44.     public int getUserId() {
  45.         return userId;
  46.     }
  48.     public void setUserId(int userId) {
  49.         this.userId = userId;
  50.     }
  51. }

3.3 创建类 User (代表一个用户)

  1. package Dao;
  3. public class User {
  4.     public int userId;
  5.     public String username;
  6.     public String password;
  8.     public int getUserId() {
  9.         return userId;
  10.     }
  12.     public void setUserId(int userId) {
  13.         this.userId = userId;
  14.     }
  16.     public String getUserName() {
  17.         return username;
  18.     }
  20.     public void setUserName(String userName) {
  21.         this.username = userName;
  22.     }
  24.     public String getPassWord() {
  25.         return password;
  26.     }
  28.     public void setPassWord(String passWord) {
  29.         this.password = passWord;
  30.     }
  31. }

3.4 创建类 BlogDao (对博客表进行操作)

  1. package Dao;
  3. import java.sql.*;
  4. import java.util.ArrayList;
  5. import java.util.List;
  7. public class BlogDao {
  8.     // 1. 插入一篇博客
  9.     public void insert(Blog blog) {
  10.         Connection connection = null;
  11.         PreparedStatement statement = null;
  12.         try {
  13.             // 1. 建立连接
  14.             connection = DBUtil.getConnection();
  15.             // 2. 拼装 SQL 语句
  16.             String sql = "insert into blog values(null,?,?,?,?)";
  17.             statement = connection.prepareStatement(sql);
  18.             statement.setString(1,blog.getTitle());
  19.             statement.setString(2,blog.getContent());
  20.             statement.setTimestamp(3,blog.getPostTime());
  21.             statement.setInt(4,blog.getUserId());
  22.             // 3. 执行 SQL 语句
  23.             int ret = statement.executeUpdate();
  24.             if(ret == 1){
  25.                 System.out.println("插入成功");
  26.             }else {
  27.                 System.out.println("插入失败");
  28.             }
  29.         } catch (SQLException e) {
  30.             e.printStackTrace();
  31.         } finally {
  32.             DBUtil.close(connection,statement,null);
  33.         }
  34.     }
  36.     // 2. 获取全部博客
  37.     public List<Blog> selectAll() {
  38.         Connection connection = null;
  39.         PreparedStatement statement = null;
  40.         ResultSet resultSet = null;
  41.         List<Blog> list = new ArrayList<>();
  42.         try {
  43.             // 1. 建立连接
  44.             connection = DBUtil.getConnection();
  45.             // 2. 拼装 SQL 语句
  46.             // 这里加上order by postTime desc 就可以根据时间排序了.
  47.             String sql = "select * from blog order by postTime desc ";
  48.             statement = connection.prepareStatement(sql);
  49.             // 3. 执行 SQL 语句
  50.             resultSet = statement.executeQuery();
  51.             // 4. 遍历结果集
  52.             while (resultSet.next()){
  53.                 Blog blog = new Blog();
  54.                 blog.setBlogId(resultSet.getInt("blogId"));
  55.                 blog.setTitle(resultSet.getString("title"));
  56.                 blog.setContent(resultSet.getString("content"));
  57.                 blog.setPostTime(resultSet.getTimestamp("postTime"));
  58.                 blog.setUserId(resultSet.getInt("userId"));
  59.                 list.add(blog);
  60.             }
  61.         } catch (SQLException e) {
  62.             e.printStackTrace();
  63.         } finally {
  64.             DBUtil.close(connection,statement,resultSet);
  65.         }
  66.         return list;
  67.     }
  69.     // 3. 获取个人博客
  70.     public List<Blog> selectAllPerson(int userId){
  71.         Connection connection = null;
  72.         PreparedStatement statement = null;
  73.         ResultSet resultSet = null;
  74.         List<Blog> list = new ArrayList<>();
  75.         try {
  76.             // 1. 建立连接
  77.             connection = DBUtil.getConnection();
  78.             // 2. 拼装 SQL 语句
  79.             // 这里加上order by postTime desc 就可以根据时间排序了.
  80.             String sql = "select * from blog where userId = ? order by postTime desc ";
  81.             statement = connection.prepareStatement(sql);
  82.             statement.setInt(1,userId);
  83.             // 3. 执行 SQL 语句
  84.             resultSet = statement.executeQuery();
  85.             // 4. 遍历结果集
  86.             while (resultSet.next()){
  87.                 Blog blog = new Blog();
  88.                 blog.setBlogId(resultSet.getInt("blogId"));
  89.                 blog.setTitle(resultSet.getString("title"));
  90.                 blog.setContent(resultSet.getString("content"));
  91.                 blog.setPostTime(resultSet.getTimestamp("postTime"));
  92.                 blog.setUserId(resultSet.getInt("userId"));
  93.                 list.add(blog);
  94.             }
  95.         } catch (SQLException e) {
  96.             e.printStackTrace();
  97.         } finally {
  98.             DBUtil.close(connection,statement,resultSet);
  99.         }
  100.         return list;
  101.     }
  103.     // 4. 根据文章id获取指定博客
  104.     public Blog selectOne(int blogId) {
  105.         Connection connection = null;
  106.         PreparedStatement statement = null;
  107.         ResultSet resultSet = null;
  108.         try {
  109.             // 1. 建立连接
  110.             connection = DBUtil.getConnection();
  111.             // 2. 拼装 SQL 语句
  112.             // 这里加上order by postTime desc 就可以根据时间排序了.
  113.             String sql = "select * from blog where blogId = ? ";
  114.             statement = connection.prepareStatement(sql);
  115.             statement.setInt(1,blogId);
  116.             // 3. 执行 SQL 语句
  117.             resultSet = statement.executeQuery();
  118.             // 4. 遍历结果集
  119.             if (resultSet.next()){
  120.                 Blog blog = new Blog();
  121.                 blog.setBlogId(resultSet.getInt("blogId"));
  122.                 blog.setTitle(resultSet.getString("title"));
  123.                 blog.setContent(resultSet.getString("content"));
  124.                 blog.setPostTime(resultSet.getTimestamp("postTime"));
  125.                 blog.setUserId(resultSet.getInt("userId"));
  126.                 return blog;
  127.             }
  128.         } catch (SQLException e) {
  129.             e.printStackTrace();
  130.         } finally {
  131.             DBUtil.close(connection,statement,resultSet);
  132.         }
  133.         return null;
  134.     }
  136.     // 5. 删除指定文章id的博客
  137.     public void delete(int blogId) {
  138.         Connection connection = null;
  139.         PreparedStatement statement = null;
  140.         try {
  141.             // 1. 建立连接
  142.             connection = DBUtil.getConnection();
  143.             // 2. 拼装 SQL 语句
  144.             String sql = "delete from blog where blogId = ?";
  145.             statement = connection.prepareStatement(sql);
  146.             statement.setInt(1,blogId);
  147.             // 3. 执行 SQL 语句
  148.             int ret = statement.executeUpdate();
  149.             if(ret == 1){
  150.                 System.out.println("删除成功");
  151.             }else{
  152.                 System.out.println("删除失败");
  153.             }
  154.         } catch (SQLException e) {
  155.             e.printStackTrace();
  156.         } finally {
  157.             DBUtil.close(connection,statement,null);
  158.         }
  159.     }
  160.     // 6. 计算个人文章的总数
  161.     public Integer selectTotal(int userId) {
  162.         Connection connection = null;
  163.         PreparedStatement statement = null;
  164.         ResultSet resultSet = null;
  165.         try {
  166.             // 1. 建立连接
  167.             connection = DBUtil.getConnection();
  168.             // 2. 拼装 SQL 语句
  169.             String sql = "select count(userId) from blog where userId = ?";
  170.             statement = connection.prepareStatement(sql);
  171.             statement.setInt(1,userId);
  172.             // 3. 执行 SQL 语句
  173.             resultSet = statement.executeQuery();
  174.             // 4. 遍历结果集
  175.             if (resultSet.next()){
  176.                 return resultSet.getInt("count(userId)");
  177.             }
  178.         } catch (SQLException e) {
  179.             e.printStackTrace();
  180.         } finally {
  181.             DBUtil.close(connection,statement,resultSet);
  182.         }
  183.         return null;
  184.     }
  186.     public static void main(String[] args) {
  187.         BlogDao blogDao = new BlogDao();
  188.         Blog blog = new Blog();
  189.         blog.setContent("你好");
  190.         blog.setTitle("你好");
  191.         blog.setUserId(1);
  192.         blog.setPostTime(new Timestamp(System.currentTimeMillis()));
  193.         blogDao.insert(blog);
  195.         System.out.println(blogDao.selectAll());
  196.     }
  197. }

3.5 创建类 UserDao (对用户表进行操作)

  1. package Dao;
  3. import java.sql.Connection;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  8. public class UserDao {
  9.     // 注册账号
  10.     public void insert(User user){
  11.         Connection connection = null;
  12.         PreparedStatement statement = null;
  13.         try {
  14.             // 1. 建立连接
  15.             connection = DBUtil.getConnection();
  16.             // 2. 拼装 SQL 语句
  17.             String sql = "insert into user values (null,?,?)";
  18.             statement = connection.prepareStatement(sql);
  19.             statement.setString(1,user.getUserName());
  20.             statement.setString(2, user.getPassWord());
  21.             // 3. 执行 SQL 语句
  22.             int ret = statement.executeUpdate();
  23.             if(ret == 1){
  24.                 System.out.println("注册成功!");
  25.             }else{
  26.                 System.out.println("注册失败!");
  27.             }
  28.         } catch (SQLException e) {
  29.             e.printStackTrace();
  30.         } finally {
  31.             DBUtil.close(connection,statement,null);
  32.         }
  33.     }
  34.     // 通过用户名查找
  35.     public User selectByName(String username){
  36.         Connection connection = null;
  37.         PreparedStatement statement = null;
  38.         ResultSet resultSet = null;
  39.         try {
  40.             // 1. 建立连接
  41.             connection = DBUtil.getConnection();
  42.             // 2. 拼装 SQL 语句
  43.             String sql = "select * from user where username = ?";
  44.             statement = connection.prepareStatement(sql);
  45.             statement.setString(1,username);
  46.             // 3. 执行 SQL 语句
  47.             resultSet = statement.executeQuery();
  48.             // 4. 查找结果集
  49.             if (resultSet.next()){
  50.                 User user = new User();
  51.                 user.setUserId(resultSet.getInt("userId"));
  52.                 user.setUserName(resultSet.getString("username"));
  53.                 user.setPassWord(resultSet.getString("password"));
  54.                 return user;
  55.             }
  56.         } catch (SQLException e) {
  57.             e.printStackTrace();
  58.         } finally {
  59.             DBUtil.close(connection,statement,resultSet);
  60.         }
  61.         return null;
  62.     }
  63.     // 通过用户id查找
  64.     public User selectById(int userId){
  65.         Connection connection = null;
  66.         PreparedStatement statement = null;
  67.         ResultSet resultSet = null;
  68.         try {
  69.             // 1. 建立连接
  70.             connection = DBUtil.getConnection();
  71.             // 2. 拼装 SQL 语句
  72.             String sql = "select * from user where userId = ?";
  73.             statement = connection.prepareStatement(sql);
  74.             statement.setInt(1,userId);
  75.             // 3. 执行 SQL 语句
  76.             resultSet = statement.executeQuery();
  77.             // 4. 遍历结果集
  78.             if (resultSet.next()){
  79.                User user = new User();
  80.                 user.setUserId(resultSet.getInt("userId"));
  81.                 user.setUserName(resultSet.getString("username"));
  82.                 user.setPassWord(resultSet.getString("password"));
  83.                 return user;
  84.             }
  85.         } catch (SQLException e) {
  86.             e.printStackTrace();
  87.         } finally {
  88.             DBUtil.close(connection,statement,resultSet);
  89.         }
  90.         return null;
  91.     }
  92. }

4. 初始化 TemplateEngine

  1. package View;
  3. import org.thymeleaf.TemplateEngine;
  4. import org.thymeleaf.templateresolver.ServletContextTemplateResolver;
  6. import javax.servlet.ServletContext;
  7. import javax.servlet.ServletContextEvent;
  8. import javax.servlet.ServletContextListener;
  9. import javax.servlet.annotation.WebListener;
  11. @WebListener
  12. public class ThymeleafConfig implements ServletContextListener {
  13.     @Override
  14.     public void contextInitialized(ServletContextEvent servletContextEvent) {
  15.         ServletContext context = servletContextEvent.getServletContext();
  16.         // 1. 创建 engine 实例
  17.         TemplateEngine engine = new TemplateEngine();
  18.         // 2. 创建 resolve 对象
  19.         ServletContextTemplateResolver resolver = new ServletContextTemplateResolver(context);
  20.         resolver.setCharacterEncoding("utf-8");
  21.         resolver.setPrefix("/WEB-INF/template/");
  22.         resolver.setSuffix(".html");
  23.         // 3. 把 resolve 对象和 engine 关联起来
  24.         engine.setTemplateResolver(resolver);
  25.         // 4. 把 engine 放到 ServletContext;
  26.         context.setAttribute("engine",engine);
  27.     }
  29.     @Override
  30.     public void contextDestroyed(ServletContextEvent servletContextEvent) {
  32.     }
  33. }

5. 实现主页界面

观看可以看出,内容的部分是动态的,其他都是静态的.(用户个人界面暂不管)

5.1 创建网页模板

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.     <title>Document</title>
  8.     <link rel="stylesheet" href="css/list.css">
  9.     <link rel="stylesheet" href="css/common.css">
  10. </head>
  11. <body>
  12. <div class="nav">
  13.     <img src="image/2.png" alt="头像">
  14.     <span class="title">我的博客系统</span>
  15.     <a href="home.html">主页</a>
  16.     <a href="edit.html">创作</a>
  17.     <a href="login.html">注销</a>
  18. </div>
  20. <div class="parent">
  21.     <div class="left">
  22.         <div class="card">
  23.             <img src="image/头像.jpg">
  24.             <span class="name">蜡笔小新</span>
  25.             <a href="#">github 地址</a>
  26.             <div class='one'>
  27.                 <span>文章</span>
  28.                 <span>分类</span>
  29.             </div>
  30.             <div class='one'>
  31.                 <span>2</span>
  32.                 <span>1</span>
  33.             </div>
  34.         </div>
  35.     </div>
  36.     <div class="right">
  37.         <div class="article" th:each="blog : ${blogs}">
  38.             <h2 class="title" th:text="${blog.title}">我的第一篇博客</h2>
  39.             <span class="date" th:text="${blog.postTime}">2022-4-17</span>
  40.             <div class="desc" th:text="${blog.content}">今天开始我要认真写博客</div>
  41.             <a th:href="${'details.html?blogId=' + blog.blogId}" class="more" >查看全文&gt;&gt;</a>
  42.         </div>
  43.     </div>
  44. </div>
  46. </body>
  47. </html>

5.2 创建 IndexServlet

  1. package View;
  3. import Dao.Blog;
  4. import Dao.BlogDao;
  5. import org.thymeleaf.TemplateEngine;
  6. import org.thymeleaf.context.WebContext;
  8. import javax.servlet.ServletException;
  9. import javax.servlet.annotation.WebServlet;
  10. import javax.servlet.http.HttpServlet;
  11. import javax.servlet.http.HttpServletRequest;
  12. import javax.servlet.http.HttpServletResponse;
  13. import java.io.IOException;
  14. import java.util.List;
  16. @WebServlet("/index.html")
  17. public class IndexServlet extends HttpServlet {
  18.     @Override
  19.     protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  20.         resp.setContentType("text/html;charset=utf-8");
  22.         // 1.从数据库拿到所有的博客列表
  23.         BlogDao blogDao = new BlogDao();
  24.         List<Blog> blogs = blogDao.selectAll();
  25.         // 2.通过模板引擎渲染页面
  26.         TemplateEngine engine = (TemplateEngine) getServletContext().getAttribute("engine");
  27.         WebContext webContext = new WebContext(req,resp,getServletContext());
  28.         webContext.setVariable("blogs",blogs);
  29.         engine.process("index",webContext, resp.getWriter());
  30.     }
  31. }

5.3 发现问题

插入太多会超出文章的页面

在之前css里面加上 overflow: auto 就有一个滚动条了

发现显示的内容每次显示的情况不一样

只需更改 SelectAll()中的代码.这里的80是随便设置的

6. 实现详情页界面

6.1 创建网页模板

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.   <meta charset="UTF-8">
  5.   <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6.   <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.   <title>Document</title>
  8.   <link rel="stylesheet" href="css/moreList.css">
  9.   <link rel="stylesheet" href="css/common.css">
  10. </head>
  11. <body>
  12. <div class="nav">
  13.   <img src="image/2.png" alt="头像">
  14.   <span class="title">我的博客系统</span>
  15.   <a href="home.html">主页</a>
  16.   <a href="edit.html">创作</a>
  17.   <a href="login.html">注销</a>
  18. </div>
  19. <div class="parent">
  20.   <div class="left">
  21.     <div class="card">
  22.       <img src="image/头像.jpg">
  23.       <span class="name">蜡笔小新</span>
  24.       <a href="#">github 地址</a>
  25.       <div class='one'>
  26.         <span>文章</span>
  27.         <span>分类</span>
  28.       </div>
  29.       <div class='one'>
  30.         <span>2</span>
  31.         <span>1</span>
  32.       </div>
  33.     </div>
  34.   </div>
  35.   <div class="right">
  36.     <div class="article">
  37.       <h2 class="title" th:text="${blog.title}">我的第一篇博客</h2>
  38.       <span class="date" th:text="${blog.postTime}">2022-4-17</span>
  39.       <div class="desc" th:text="${blog.content}">1</div>
  40.     </div>
  41.   </div>
  42. </div>
  43. </body>
  44. </html>

6.2 创建 DetailsServlet

  1. package View;
  3. import Dao.Blog;
  4. import Dao.BlogDao;
  5. import com.sun.xml.internal.bind.v2.schemagen.xmlschema.List;
  6. import org.thymeleaf.TemplateEngine;
  7. import org.thymeleaf.context.WebContext;
  9. import javax.servlet.ServletException;
  10. import javax.servlet.annotation.WebServlet;
  11. import javax.servlet.http.HttpServlet;
  12. import javax.servlet.http.HttpServletRequest;
  13. import javax.servlet.http.HttpServletResponse;
  14. import java.io.IOException;
  16. @WebServlet("/details.html")
  17. public class DetailsServlet extends HttpServlet {
  18.     @Override
  19.     protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  20.         resp.setContentType("text/html;charset=utf-8");
  22.         String str = req.getParameter("blogId");
  23.         if(str == null || str.length() == 0){
  24.             resp.getWriter().write("blogId缺失!");
  25.             return;
  26.         }
  27.         int blogId = Integer.parseInt(str);
  28.         BlogDao blogDao = new BlogDao();
  29.         Blog blog = blogDao.selectOne(blogId);
  30.         if(blog == null){
  31.             resp.getWriter().write("当前博客不存在!");
  32.             return;
  33.         }
  35.         TemplateEngine engine = (TemplateEngine) getServletContext().getAttribute("engine");
  36.         WebContext webContext = new WebContext(req,resp,getServletContext());
  37.         webContext.setVariable("blog",blog);
  39.         engine.process("details",webContext,resp.getWriter());
  40.     }
  41. }

7. 实现博客登录界面

7.1 修改之前的前端代码

7.2 创建 LoginServlet

  1. package View;
  3. import Dao.User;
  4. import Dao.UserDao;
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11. import javax.servlet.http.HttpSession;
  12. import java.io.IOException;
  14. @WebServlet("/login")
  15. public class LoginServlet extends HttpServlet {
  16.     @Override
  17.     protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  18.         resp.setContentType("text/html;charset=utf-8");
  19.         // 1. 获取用户名密码
  20.         String username = req.getParameter("username");
  21.         String password = req.getParameter("password");
  22.         // 2. 判断用户名密码是否为空
  23.         if(username == null || "".equals(username) || password == null || "".equals(password)){
  24.             resp.getWriter().write("<h3>用户名或者密码为空,登录失败!</h3>");
  25.             return;
  26.         }
  27.         // 3. 判断输入的用户名或者密码是否正确
  28.         UserDao userDao = new UserDao();
  29.         User user = userDao.selectByName(username);
  30.         if(user == null){
  31.             resp.getWriter().write("<h3>用户名或者密码错误,登录失败!</h3>");
  32.             return;
  33.         }
  35.         if(!user.getPassWord().equals(password)){
  36.             resp.getWriter().write("<h3>用户名或者密码错误,登录失败!</h3>");
  37.             return;
  38.         }
  39.         // 4. 登陆成功,就把user存到HttpSession中
  40.         HttpSession session = req.getSession(true);
  41.         session.setAttribute("user",user);
  42.         // 5. 重定向到主页
  43.         resp.sendRedirect("index.html");
  44.     }
  45. }

8. 实现博客的注销功能

8.1 创建 LogoutServlet 类

  1. package View;
  3. import javax.servlet.ServletException;
  4. import javax.servlet.annotation.WebServlet;
  5. import javax.servlet.http.HttpServlet;
  6. import javax.servlet.http.HttpServletRequest;
  7. import javax.servlet.http.HttpServletResponse;
  8. import javax.servlet.http.HttpSession;
  9. import java.io.IOException;
  11. @WebServlet("/logout")
  12. public class LogoutServlet extends HttpServlet {
  13.     @Override
  14.     protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  15.         resp.setContentType("text/html;charset=utf-8");
  16.         // 1. 检查当前的用户是否登录
  17.         HttpSession session = req.getSession(false);
  18.         if(session == null){
  19.             resp.getWriter().write("<h3>当前未登录</h3>");
  20.             return;
  21.         }
  22.         // 2. 删除user
  23.         session.removeAttribute("user");
  24.         // 3. 重定向到登录页面
  25.         resp.sendRedirect("login.html");
  26.     }
  27. }

9. 实现博客的注册功能

9.1 创建前端页面

  1. <!doctype html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta name="viewport"
  6.           content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
  7.     <meta http-equiv="X-UA-Compatible" content="ie=edge">
  8.     <title>Document</title>
  9.     <link rel="stylesheet" href="css/common.css">
  10.     <link rel="stylesheet" href="css/login.css">
  11. </head>
  12. <body>
  13. <div class="nav">
  14.     <img src="image/logo.png" alt="头像">
  15.     <span class="title">我的博客系统</span>
  16.     <a href="index.html">主页</a>
  17.     <a href="edit.html">创作</a>
  18.     <a href="register.html">注册</a>
  19. </div>
  20. <div id="one">
  21.     <div class="login">
  22.         <form action="register" method="post">
  23.             <div class="text">注册</div>
  24.             <div class="one"><span class="name">用户名</span><input type="text" class="user" name="username"></div>
  25.             <div class="one"><span class="name">密码</span><input type="password" class="password" name="password1"></div>
  26.             <div class="one"><span class="name">确认密码</span><input type="password" class="password" name="password2"></div>
  27.             <div class="submit"><input type="submit" value="注 册" ></div>
  28.         </form>
  29.     </div>
  30. </div>
  31. </body>
  32. </html>

9.2 创建 RegisterServlet

  1. package View;
  3. import Dao.User;
  4. import Dao.UserDao;
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11. import java.io.IOException;
  13. @WebServlet("/register")
  14. public class RegisterServlet extends HttpServlet {
  15.     @Override
  16.     protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  17.         resp.setContentType("text/html; charset=utf-8");
  19.         // 1. 获取输入的用户名和密码
  20.         String username = req.getParameter("username");
  21.         String password1 = req.getParameter("password1");
  22.         String password2 = req.getParameter("password2");
  23.         // 2. 如果有一个为空就注册失败
  24.         if (username == null || password1 == null || password2 == null || "".equals(username) || "".equals(password1) || "".equals(password2)) {
  25.             resp.getWriter().write("<h3>输入有误!注册失败!</h3>");
  26.             return;
  27.         }
  28.         UserDao userDao = new UserDao();
  29.         User user = userDao.selectByName(username);
  30.         // 如果user不为空.表示有人注册了
  31.         if(user!=null){
  32.             resp.getWriter().write("<h3>用户名已经被使用了</h3>");
  33.             return;
  34.         }
  35.         // 如果两次密码不一致注册失败
  36.         if(!password1.equals(password2)){
  37.             resp.getWriter().write("<h3>两次输入的密码不一致,注册失败!");
  38.             return;
  39.         }
  40.         // 这里就注册成功了
  41.         User user1 = new User();
  42.         user1.setUserName(username);
  43.         user1.setPassWord(password1);
  44.         userDao.insert(user1);
  46.         resp.sendRedirect("login.html");
  47.     }
  48. }

10. 实现博客编辑界面

10.1 修改之前前端代码

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.     <title>Document</title>
  8.     <link rel="stylesheet" href="css/common.css">
  9.     <link rel="stylesheet" href="css/edit.css">
  10.     <!-- 引入 editor.md 的依赖 -->
  11.     <link rel="stylesheet" href="editor.md/css/editormd.min.css" />
  12.     <script src="js/jquery.min.js"></script>
  13.     <script src="editor.md/lib/marked.min.js"></script>
  14.     <script src="editor.md/lib/prettify.min.js"></script>
  15.     <script src="editor.md/editormd.js"></script>
  16. </head>
  17. <body>
  18. <div class="nav">
  19.     <img src="image/2.png" alt="头像">
  20.     <span class="title">我的博客系统</span>
  21.     <a href="index.html">主页</a>
  22.     <a href="edit.html">创作</a>
  23.     <a href="logout">注销</a>
  24. </div>
  25. <div class="leader">
  26.     <form action="edit" method="post" style="height:100%">
  27.         <div class="empOne">
  28.             <input type="text" class="title" value="在这里写下文章标题" onblur="if(this.value == '')this.value='在这里写下文章标题';" onclick="if(this.value == '在这里写下文章标题')this.value='';" name="title">
  29.             <input type="submit" value="发布文章" class="publish">
  30.         </div>
  31.         <div id="editor">
  32.             <textarea name="content" style="display:none;"></textarea>
  33.         </div>
  34.     </form>
  35. </div>
  37. <script>
  38.         // 初始化编辑器
  39.         var editor = editormd("editor", {
  40.             // 这里的尺寸必须在这里设置. 设置样式会被 editormd 自动覆盖掉.
  41.             width: "100%",
  42.             // 高度 100% 意思是和父元素一样高. 要在父元素的基础上去掉标题编辑区的高度
  43.             height: "calc(100% - 75px)",
  44.             // 编辑器中的初始内容
  45.             markdown: "# 在这里写下一篇博客",
  46.             // 指定 editor.md 依赖的插件路径
  47.             path: "editor.md/lib/",
  48.             saveHTMLToTextarea: true
  49.         });
  50.     </script>
  51. </body>
  52. </html>

10.2 实现 EditServlet

  1. package View;
  3. import Dao.Blog;
  4. import Dao.BlogDao;
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11. import java.io.IOException;
  12. import java.sql.Timestamp;
  14. @WebServlet("/edit")
  15. public class EditServlet extends HttpServlet {
  16.     @Override
  17.     protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  18.         resp.setContentType("text/html;charset=utf-8");
  20.         // 1. 获取参数
  21.         String title = req.getParameter("title");
  22.         String content = req.getParameter("content");
  23.         // 2. 判断是否存在
  24.         if(title==null || "".equals(title) || content==null || "".equals(content)){
  25.             resp.getWriter().write("<h3>文章标题或者内容不存在</h3>");
  26.             return;
  27.         }
  29.         // 插入到数据库中
  30.         Blog blog = new Blog();
  31.         blog.setContent(content);
  32.         blog.setTitle(title);
  33.         blog.setPostTime(new Timestamp(System.currentTimeMillis()));
  34.         BlogDao blogDao = new BlogDao();
  35.         blogDao.insert(blog);
  36.         // 重定向
  37.         resp.sendRedirect("index.html");
  38.     }
  39. }

11. 实现博客的删除功能

11.1 查看博客详情页

根据这里的blogId查找当前的userId,如果登录的userId等于当前的userId 就有删除按钮

前端改进

添加样式

  1. #deleteA {
  2.     margin: 5px;
  3.     display: block;
  4.     text-align: center;
  5.     color:black;
  6.     text-decoration: none;
  7. }
  9. #deleteA:hover{
  10.     background-color: rgba(206, 144, 64, 0.8);
  11. }

修改 DetailsServlet

11.2 创建 DeleteServlet

  1. package View;
  2. import Dao.BlogDao;
  4. import javax.servlet.ServletException;
  5. import javax.servlet.annotation.WebServlet;
  6. import javax.servlet.http.HttpServlet;
  7. import javax.servlet.http.HttpServletRequest;
  8. import javax.servlet.http.HttpServletResponse;
  9. import java.io.IOException;
  11. @WebServlet("/delete")
  12. public class DeleteServlet extends HttpServlet {
  13.     @Override
  14.     protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  15.         resp.setContentType("text/html;charset=utf-8");
  16.         String str = req.getParameter("blogId");
  17.         int blogId = Integer.parseInt(str);
  18.         BlogDao blogDao = new BlogDao();
  19.         blogDao.delete(blogId);
  20.         resp.sendRedirect("index.html");
  21.     }
  22. }

12. 改进

12.1 点击每个页面的时候,判断是否登录了

12.1.1 创建一个 Util类

  1. package common;
  3. import Dao.User;
  5. import javax.servlet.http.HttpServletRequest;
  6. import javax.servlet.http.HttpSession;
  8. public class Util {
  9.     public static User checkLoginStatus (HttpServletRequest req){
  10.         // 判断是否登录了. 如果能够拿到 Session, 并且拿到 Session 里的 user对象,就认为是登录状态
  11.         HttpSession session = req.getSession(false);
  12.         if(session == null){
  13.             // 没有登录的情况
  14.             return null;
  15.         }
  16.         User user = (User) session.getAttribute("user");
  18.         return user;
  19.     }
  21. }

12.1.2 改进各个界面的代码

12.2 对个人资料的名字进行修改.

12.3 内容没有支持markdown语法

12.3.1 修改details.html的代码

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.   <meta charset="UTF-8">
  5.   <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6.   <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.   <title>Document</title>
  8.   <link rel="stylesheet" href="css/moreList.css">
  9.   <link rel="stylesheet" href="css/common.css">
  11.   <!-- 引入 editor.md 的依赖 -->
  12.   <link rel="stylesheet" href="editor.md/css/editormd.min.css" />
  13.   <script src="js/jquery.min.js"></script>
  14.   <script src="editor.md/lib/marked.min.js"></script>
  15.   <script src="editor.md/lib/prettify.min.js"></script>
  16.   <script src="editor.md/editormd.js"></script>
  17. </head>
  18. <body>
  19. <div class="nav">
  20.   <img src="image/2.png" alt="头像">
  21.   <span class="title">我的博客系统</span>
  22.   <a href="index.html">主页</a>
  23.   <a href="personlist.html">我的</a>
  24.   <a href="edit.html">创作</a>
  25.   <a href="logout">注销</a>
  26. </div>
  27. <div class="parent">
  28.   <div class="left">
  29.     <div class="card">
  30.       <img src="image/头像.jpg">
  31.       <span class="name" th:text="${user.username}">蜡笔小新</span>
  32.       <a href="#">github 地址</a>
  33.       <div class='one'>
  34.         <span>文章</span>
  35.         <span>分类</span>
  36.       </div>
  37.       <div class='one'>
  38.         <span>2</span>
  39.         <span>1</span>
  40.       </div>
  41.     </div>
  42.   </div>
  43.   <div class="right">
  44.     <div class="article">
  45.       <h2 class="title" th:text="${blog.title}">我的第一篇博客</h2>
  46.       <span class="date" th:text="${blog.postTime}">2022-4-17</span>
  47.       <a th:href="${'delete?blogId=' + blog.blogId}" id="deleteA" th:if="${showDelete}">删除文章</a>
  48.       <div class="desc" id="content" th:text="${blog.content}" style="background-color: transparent;"></div>
  49.     </div>
  50.   </div>
  51. </div>
  53. <script>
  54.   function renderMD() {
  55.       let contentDiv = document.querySelector('#content');
  56.       let markdown = contentDiv.innerHTML;
  57.       // 1把contentDiv清空
  58.       contentDiv.innerHTML = '';
  59.       editormd.markdownToHTML('content',{
  60.           markdown: markdown
  61.       });
  62.   }
  63.   renderMD();
  64. </script>
  65. </body>
  66. </html>

12.4 在左侧动态的显示自己的文章总数

13. 添加个人主页功能

13.1 创建前端代码

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.     <title>Document</title>
  8.     <link rel="stylesheet" href="css/list.css">
  9.     <link rel="stylesheet" href="css/common.css">
  10. </head>
  11. <body>
  12.     <div class="nav">
  13.         <img src="image/2.png" alt="头像">
  14.         <span class="title">我的博客系统</span>
  15.         <a href="index.html">主页</a>
  16.         <a href="personlist.html">个人主页</a>
  17.         <a href="edit.html">创作</a>
  18.         <a href="logout">注销</a>
  19.     </div>
  20.     <div class="parent">
  21.         <div class="left">
  22.             <div class="card">
  23.                 <img src="image/头像.jpg">
  24.                 <span class="name" th:text="${user.username}">蜡笔小新</span>
  25.                 <a href="#">github 地址</a>
  26.                 <div class='one'>
  27.                   <span>文章</span>
  28.                   <span>分类</span>
  29.                 </div>
  30.                 <div class='one'>
  31.                   <span>2</span>
  32.                   <span>1</span>
  33.                 </div>
  34.               </div>
  35.         </div>
  36.         <div class="right">
  37.             <div class="article" th:each="blog : ${blogs}">
  38.                 <h2 class="title" th:text="${blog.title}">我的第一篇博客</h2>
  39.                 <span class="date" th:text="${blog.postTime}">2022-4-17</span>
  40.                 <div class="desc" th:text="${blog.content}">.</div>
  41.                 <a th:href="${'details.html?blogId=' + blog.blogId}" class="more">查看全文&gt;&gt;</a>
  42.             </div>
  43.         </div>
  44.     </div>
  45. </body>
  46. </html>

13.2 创建 PersonServlet

  1. package View;
  3. import Dao.Blog;
  4. import Dao.BlogDao;
  5. import Dao.User;
  6. import Dao.UserDao;
  7. import common.Util;
  8. import org.thymeleaf.TemplateEngine;
  9. import org.thymeleaf.context.WebContext;
  11. import javax.servlet.ServletException;
  12. import javax.servlet.annotation.WebServlet;
  13. import javax.servlet.http.HttpServlet;
  14. import javax.servlet.http.HttpServletRequest;
  15. import javax.servlet.http.HttpServletResponse;
  16. import java.io.IOException;
  17. import java.util.List;
  19. @WebServlet("/personlist.html")
  20. public class PersonServlet extends HttpServlet {
  21.     @Override
  22.     protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  23.         resp.setContentType("text/html;charset=utf-8");
  24.         User user = Util.checkLoginStatus(req);
  25.         if(user == null){
  26.             resp.sendRedirect("login.html");
  27.             return;
  28.         }
  30.         BlogDao blogDao = new BlogDao();
  31.         List<Blog> blogs = blogDao.selectAllPerson(user.getUserId());
  33.         TemplateEngine engine = (TemplateEngine) getServletContext().getAttribute("engine");
  34.         WebContext webContext = new WebContext(req,resp,getServletContext());
  35.         webContext.setVariable("blogs",blogs);
  36.         engine.process("personlist",webContext,resp.getWriter());
  37.     }
  38. }

14. 实现博客的编辑功能

14.1 修改博客详情页的前端代码

14.2 在数据中实现修改博客的操作

  1. public void update(Blog blog){
  2.         Connection connection = null;
  3.         PreparedStatement statement = null;
  4.         try {
  5.             // 1. 建立连接
  6.             connection = DBUtil.getConnection();
  7.             // 2. 拼装 SQL 语句
  8.             String sql = "update blog set content = ? ,title = ?,postTime = ? where blogId = ?";
  9.             statement = connection.prepareStatement(sql);
  10.             statement.setString(1,blog.getContent());
  11.             statement.setString(2,blog.getTitle());
  12.             statement.setTimestamp(3,blog.getPostTime());
  13.             statement.setInt(4,blog.getBlogId());
  14.             // 3. 执行 SQL 语句
  15.             int ret = statement.executeUpdate();
  16.             if(ret == 1){
  17.                 System.out.println("编辑成功");
  18.             }else{
  19.                 System.out.println("编辑失败");
  20.             }
  21.         } catch (SQLException e) {
  22.             e.printStackTrace();
  23.         } finally {
  24.             DBUtil.close(connection,statement,null);
  25.         }
  26.     }

14.3 编写一个编辑的界面

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4.   <meta charset="UTF-8">
  5.   <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6.   <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7.   <title>Document</title>
  8.   <link rel="stylesheet" href="css/common.css">
  9.   <link rel="stylesheet" href="css/edit.css">
  10.   <!-- 引入 editor.md 的依赖 -->
  11.   <link rel="stylesheet" href="editor.md/css/editormd.min.css" />
  12.   <script src="js/jquery.min.js"></script>
  13.   <script src="editor.md/lib/marked.min.js"></script>
  14.   <script src="editor.md/lib/prettify.min.js"></script>
  15.   <script src="editor.md/editormd.js"></script>
  16. </head>
  17. <body>
  18. <div class="nav">
  19.   <img src="image/2.png" alt="头像">
  20.   <span class="title">我的博客系统</span>
  21.   <a href="index.html">主页</a>
  22.   <a href="personlist.html">我的</a>
  23.   <a href="edit.html">创作</a>
  24.   <a href="logout">注销</a>
  25. </div>
  26. <div class="leader">
  27.   <form th:action="${'update?blogId=' + blog.blogId}" method="post" style="height:100%">
  28.     <div class="empOne">
  29.       <input type="text" class="title" th:value="${blog.title}" name="title">
  30.       <input type="submit" value="发布文章" class="publish">
  31.     </div>
  32.     <div id="editor">
  33.       <textarea name="content" style="display:none;" th:text="${blog.content}"></textarea>
  34.     </div>
  35.   </form>
  36. </div>
  38. <script>
  39.         // 初始化编辑器
  40.         var editor = editormd("editor", {
  41.             // 这里的尺寸必须在这里设置. 设置样式会被 editormd 自动覆盖掉.
  42.             width: "100%",
  43.             // 高度 100% 意思是和父元素一样高. 要在父元素的基础上去掉标题编辑区的高度
  44.             height: "calc(100% - 75px)",
  45.             // 指定 editor.md 依赖的插件路径
  46.             path: "editor.md/lib/",
  47.             saveHTMLToTextarea: true
  48.         });
  49.     </script>
  50. </body>
  51. </html>

14.4 实现 UpdateServlet

这里的 doget 请求是进入编辑页
dopost请求是提交编辑后的内容

  1. package View;
  3. import Dao.Blog;
  4. import Dao.BlogDao;
  5. import Dao.User;
  6. import common.Util;
  7. import org.thymeleaf.TemplateEngine;
  8. import org.thymeleaf.context.WebContext;
  10. import javax.servlet.ServletException;
  11. import javax.servlet.annotation.WebServlet;
  12. import javax.servlet.http.HttpServlet;
  13. import javax.servlet.http.HttpServletRequest;
  14. import javax.servlet.http.HttpServletResponse;
  15. import java.io.IOException;
  16. import java.sql.Timestamp;
  18. @WebServlet("/update")
  19. public class UpdateServlet extends HttpServlet{
  20.     @Override
  21.     protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  22.         resp.setContentType("text/html;charset=utf-8");
  23.         String str = req.getParameter("blogId");
  24.         if(str==null || "".equals(str)){
  25.             resp.getWriter().write("<h3>博客Id不存在</h3>");
  26.             return;
  27.         }
  28.         int blogId = Integer.parseInt(str);
  30.         BlogDao blogDao = new BlogDao();
  31.         Blog blog = blogDao.selectOne(blogId);
  32.         if(blog == null){
  33.             resp.getWriter().write("<h3>博文不存在</h3>");
  34.             return;
  35.         }
  36.         TemplateEngine engine = (TemplateEngine) getServletContext().getAttribute("engine");
  37.         WebContext webContext = new WebContext(req,resp,getServletContext());
  38.         webContext.setVariable("blog",blog);
  40.         engine.process("alter",webContext,resp.getWriter());
  41.     }
  42.     @Override
  43.     protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  44.         resp.setContentType("text/html;charset=utf-8");
  45.         req.setCharacterEncoding("utf-8");
  47.         User user = Util.checkLoginStatus(req);
  48.         if(user == null){
  49.             resp.sendRedirect("login.html");
  50.             return;
  51.         }
  53.         // 1. 获取参数
  54.         String title = req.getParameter("title");
  55.         String content = req.getParameter("content");
  56.         String str = req.getParameter("blogId");
  57.         if(str==null || "".equals(str)){
  58.             System.out.println("blogId不存在");
  59.             return;
  60.         }
  61.         int blogId = Integer.parseInt(str);
  62.         // 2. 判断是否存在
  63.         if(title==null || "".equals(title) || content==null || "".equals(content)){
  64.             resp.getWriter().write("<h3>文章标题或者内容不存在</h3>");
  65.             return;
  66.         }
  68.         // 插入到数据库中
  69.         Blog blog = new Blog();
  70.         blog.setContent(content);
  71.         blog.setTitle(title);
  72.         blog.setPostTime(new Timestamp(System.currentTimeMillis()));
  73.         blog.setBlogId(blogId);
  74.         BlogDao blogDao = new BlogDao();
  75.         blogDao.update(blog);
  76.         // 重定向
  77.         resp.sendRedirect("personlist.html");
  78.     }
  79. }

版权说明 : 本文为转载文章, 版权归原作者所有 版权申明

原文链接 : https://wangzhi430.blog.csdn.net/article/details/124669731

内容来源于网络，如有侵权，请联系作者删除！

JavamysqlMavenjava web

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    目录

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com