基于tomcat+spring+mysql搭建的个人博客
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了基于tomcat+spring+mysql搭建的个人博客，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含12634字，纯文字阅读大概需要19分钟。
内容图文
用户表；
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">» Font Size «</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 <span style="color: #ff0 本文系统来源：http://www.cnblogs.com/diligenceday/p/4702136.html
内容总结
以上是互联网集市为您收集整理的基于tomcat+spring+mysql搭建的个人博客全部内容，希望文章能够帮你解决基于tomcat+spring+mysql搭建的个人博客所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】