当前位置：Gxlcms > 数据库问题 > 基于tomcat+spring+mysql搭建的个人博客

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

时间：2021-07-01 10:21:17 帮助过：3人阅读

用户表； 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;

@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; 
    }
    
}
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

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！