logo设计网站知乎_专门网页制作工具有_为企业策划一次网络营销活动_seo网站关键词快速排名

基于Springmvc+MyBatis+Spring+Bootstrap+EasyUI+Mysql的个人博客系统

1.项目介绍

使用Maven3+Spring4+Springmvc+Mybatis3架构；数据库使用Mysql，数据库连接池使用阿里巴巴的Druid；
使用Bootstrap3 UI框架实现博客的分页显示，博客分类，文章归类显示；完成用户评论和分享功能；
使用EasyUI实现后台对博客、博客类别、用户评论、博主信息的管理，包括增删改查，文件上传等；实现刷新后台缓存等功能；
使用Shiro作为项目安全框架，验证不同url的请求，包括后台博主的登陆；
实现Lucene对全站的检索功能，对检索出的博客标题和内容实现高亮显示；
使用百度的Ueditor编辑器实现写博客功能，支持单图、多图上传，支持截图上传，支持代码高亮特性等。

2.数据库设计

2.1表结构

博客表

博主表

博客类型表

评论表

友情链接表

2.2ER图

3.项目设计

3.1项目配置

<?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:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd  http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd  http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd  http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.0.xsd  http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd"><!-- 鑷姩鎵弿鍖呬腑鐨刡ean --><context:component-scan base-package="ssm.blog.*" /><!-- 閰嶇疆鏁版嵁婧愶紝浣跨敤闃块噷宸村反杩炴帴姹燚ruid --><bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"><property name="url" value="jdbc:mysql://localhost:3306/db_blog"/><property name="username" value="root"/><property name="password" value="root"/></bean><!-- 閰嶇疆mybatis鐨剆qlSessionFactory --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource" /><!-- 鑷姩鎵弿mappers.xml鏂囦欢 --><property name="mapperLocations" value="classpath:ssm/blog/mappers/*.xml"></property><!-- 鍔犺浇mybatis鍏ㄥ眬閰嶇疆鏂囦欢 --><property name="configLocation" value="classpath:mybatis-config.xml"></property></bean><!-- 鎵弿mapper鎺ュ彛锛堝嵆dao锛夛紝Spring浼氳嚜鍔ㄦ煡鎵惧叾涓嬬殑绫?--><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="ssm.blog.dao" /><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property></bean><!-- 浜嬪姟绠＄悊锛坱ransaction manager锛?--><bean id="transactionManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource" /></bean><!-- 鑷畾涔塕ealm --><bean id="myRealm" class="ssm.blog.realm.MyRealm" /><!-- 瀹夊叏绠＄悊鍣?--><bean id="securityManager" class="org.apache.shiro.web.mgt.DefaultWebSecurityManager"><property name="realm" ref="myRealm" /></bean><!-- Shiro杩囨护鍣?--><bean id="shiroFilter" class="org.apache.shiro.spring.web.ShiroFilterFactoryBean"><!-- Shiro鐨勬牳蹇冨畨鍏ㄦ帴鍙?杩欎釜灞炴ф槸蹇呴』鐨?--><property name="securityManager" ref="securityManager" /><!-- 韬唤璁よ瘉澶辫触锛屽垯璺宠浆鍒扮櫥褰曢〉闈㈢殑閰嶇疆 --><property name="loginUrl" value="/login.jsp" /><!-- 鏉冮檺璁よ瘉澶辫触锛屽垯璺宠浆鍒版寚瀹氶〉闈紝鍥犱负涓汉鍗氬灏变竴涓汉鐧婚檰锛屽氨涓嶉渶瑕佹潈闄愪簡 --><!-- <property name="unauthorizedUrl" value="/unauthorized.jsp" />  --><!-- Shiro杩炴帴绾︽潫閰嶇疆,鍗宠繃婊ら摼鐨勫畾涔?--><property name="filterChainDefinitions"><value>/login=anon/admin/**=authc</value></property></bean><!-- 淇濊瘉瀹炵幇浜哠hiro鍐呴儴lifecycle鍑芥暟鐨刡ean鎵ц --><bean id="lifecycleBeanPostProcessor" class="org.apache.shiro.spring.LifecycleBeanPostProcessor" /><!-- 寮鍚疭hiro娉ㄨВ --><beanclass="org.springframework.aop.framework.autoproxy.DefaultAdvisorAutoProxyCreator"depends-on="lifecycleBeanPostProcessor" /><beanclass="org.apache.shiro.spring.security.interceptor.AuthorizationAttributeSourceAdvisor"><property name="securityManager" ref="securityManager" /></bean><!-- 閰嶇疆浜嬪姟閫氱煡灞炴?--><tx:advice id="txAdvice" transaction-manager="transactionManager"><!-- 瀹氫箟浜嬪姟浼犳挱灞炴?--><tx:attributes><tx:method name="insert*" propagation="REQUIRED" /><tx:method name="update*" propagation="REQUIRED" /><tx:method name="edit*" propagation="REQUIRED" /><tx:method name="save*" propagation="REQUIRED" /><tx:method name="add*" propagation="REQUIRED" /><tx:method name="new*" propagation="REQUIRED" /><tx:method name="set*" propagation="REQUIRED" /><tx:method name="remove*" propagation="REQUIRED" /><tx:method name="delete*" propagation="REQUIRED" /><tx:method name="change*" propagation="REQUIRED" /><tx:method name="check*" propagation="REQUIRED" /><tx:method name="get*" propagation="REQUIRED" read-only="true" /><tx:method name="find*" propagation="REQUIRED" read-only="true" /><tx:method name="load*" propagation="REQUIRED" read-only="true" /><tx:method name="*" propagation="REQUIRED" read-only="true" /></tx:attributes></tx:advice><!-- 閰嶇疆浜嬪姟鍒囬潰 --><aop:config><aop:pointcut id="pointCut" expression="execution(* ssm.blog.service.*.*(..))" /><aop:advisor advice-ref="txAdvice" pointcut-ref="pointCut" /></aop:config></beans>

3.2监听器

package ssm.blog.listener;import java.util.List;import javax.servlet.ServletContext;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import org.springframework.stereotype.Component;import ssm.blog.entity.Blog;
import ssm.blog.entity.BlogType;
import ssm.blog.entity.Blogger;
import ssm.blog.entity.Link;
import ssm.blog.service.BlogService;
import ssm.blog.service.BlogTypeService;
import ssm.blog.service.BloggerService;
import ssm.blog.service.LinkService;@Component
public class InitBloggerData implements ServletContextListener, ApplicationContextAware {private static ApplicationContext applicationContext;public void contextInitialized(ServletContextEvent sce) {System.out.println(applicationContext);//先获取servlet上下文ServletContext application = sce.getServletContext();//根据spring的上下文获取bloggerService这个beanBloggerService bloggerService = (BloggerService) applicationContext.getBean("bloggerService");//获取博主信息Blogger blogger = bloggerService.getBloggerData();//由于密码也获取到了，比较敏感，我们也不需要这个，所以把密码清空掉blogger.setPassword(null);//将博主信息存入application域中application.setAttribute("blogger", blogger);//同上，获取友情链接信息LinkService linkService = (LinkService) applicationContext.getBean("linkService");List<Link> linkList = linkService.getLinkData(); application.setAttribute("linkList", linkList);//同上，获取博客类别信息BlogTypeService blogTypeService = (BlogTypeService) applicationContext.getBean("blogTypeService");List<BlogType> blogTypeList = blogTypeService.getBlogTypeData();application.setAttribute("blogTypeList", blogTypeList);//同上，获取博客信息，按照时间分类的BlogService blogService = (BlogService) applicationContext.getBean("blogService");List<Blog> blogTimeList = blogService.getBlogData();application.setAttribute("blogTimeList", blogTimeList);}public void contextDestroyed(ServletContextEvent sce) {// TODO Auto-generated method stub}public void setApplicationContext(ApplicationContext applicationContext) throws BeansException {InitBloggerData.applicationContext = applicationContext;}}

3.3博客全文索引

/*** @Description 博客索引类* @author Ni Shengwu**/
public class BlogIndex {private Directory dir;private IndexWriter getWriter() throws Exception {		dir = FSDirectory.open(Paths.get("D:\\blog_index"));SmartChineseAnalyzer analyzer = new SmartChineseAnalyzer();IndexWriterConfig config = new IndexWriterConfig(analyzer);IndexWriter writer = new IndexWriter(dir, config);	return writer;}//添加博客索引public void addIndex(Blog blog)  throws Exception {IndexWriter writer = getWriter();Document doc = new Document();doc.add(new StringField("id", String.valueOf(blog.getId()), Field.Store.YES));doc.add(new TextField("title", blog.getTitle(), Field.Store.YES));doc.add(new StringField("releaseDate", DateUtil.formatDate(new Date(), "yyyy-MM-dd"), Field.Store.YES));		doc.add(new TextField("content", blog.getContentNoTag(), Field.Store.YES));		writer.addDocument(doc);writer.close();}//删除指定博客的索引public void deleteIndex(String blogId) throws Exception {IndexWriter writer = getWriter();writer.deleteDocuments(new Term("id", blogId));writer.forceMergeDeletes();//强制删除writer.commit();writer.close();}//更新博客索引public void updateIndex(Blog blog) throws Exception {IndexWriter writer = getWriter();Document doc = new Document();doc.add(new StringField("id", String.valueOf(blog.getId()), Field.Store.YES));doc.add(new TextField("title", blog.getTitle(), Field.Store.YES));doc.add(new StringField("releaseDate", DateUtil.formatDate(new Date(), "yyyy-MM-dd"), Field.Store.YES));		doc.add(new TextField("content", blog.getContentNoTag(), Field.Store.YES));		writer.updateDocument(new Term("id", String.valueOf(blog.getId())), doc);writer.close();}//查询博客索引信息public List<Blog> searchBlog(String q) throws Exception {dir = FSDirectory.open(Paths.get("D:\\blog_index"));IndexReader reader = DirectoryReader.open(dir);IndexSearcher search = new IndexSearcher(reader);BooleanQuery.Builder booleanQuery = new BooleanQuery.Builder();SmartChineseAnalyzer analyzer = new SmartChineseAnalyzer();QueryParser parser1 = new QueryParser("title", analyzer); //查询标题Query query1 = parser1.parse(q);QueryParser parser2 = new QueryParser("content", analyzer); //查询内容Query query2 = parser2.parse(q);booleanQuery.add(query1, BooleanClause.Occur.SHOULD);booleanQuery.add(query2, BooleanClause.Occur.SHOULD);TopDocs hits = search.search(booleanQuery.build(), 100);QueryScorer scorer = new QueryScorer(query1);//使用title得分高的排前面Fragmenter fragmenter = new SimpleSpanFragmenter(scorer); //得分高的片段SimpleHTMLFormatter simpleHTMLFormatter = new SimpleHTMLFormatter("<b><font color='red'>", "</font></b>");Highlighter highlighter = new Highlighter(simpleHTMLFormatter, scorer); //高亮显示highlighter.setTextFragmenter(fragmenter); //将得分高的片段设置进去List<Blog> blogIndexList = new LinkedList<Blog>(); //用来封装查询到的博客for(ScoreDoc score : hits.scoreDocs) {Document doc = search.doc(score.doc);Blog blog = new Blog();blog.setId(Integer.parseInt(doc.get("id")));blog.setReleaseDateStr(doc.get("releaseDate"));String title = doc.get("title");String content = doc.get("content");if(title != null) {TokenStream tokenStream = analyzer.tokenStream("title", new StringReader(title));String hTitle = highlighter.getBestFragment(tokenStream, title);if(StringUtil.isEmpty(hTitle)) {blog.setTitle(title);} else {blog.setTitle(hTitle);}}if(content != null) {TokenStream tokenStream = analyzer.tokenStream("content", new StringReader(content));String hContent = highlighter.getBestFragment(tokenStream, content);if(StringUtil.isEmpty(hContent)) {if(content.length() > 100) { //如果没查到且content内容又大于100的话blog.setContent(content.substring(0, 100)); //截取100个字符} else {blog.setContent(content);}} else {blog.setContent(hContent);}}blogIndexList.add(blog);}return blogIndexList;}
}

3.4工具类

md5加密工具类


/*** md5加密工具类* @author Administrator**/
public class CryptographyUtil {/*** @Description 使用Shiro中的md5加密* @param str* @param salt* @return*/public static String md5(String str,String salt){//Md5Hash是Shiro中的一个方法return new Md5Hash(str, salt).toString();}//我自己生成一下测试用的public static void main(String[] args) {String password="123456";System.out.println("Md5加密："+CryptographyUtil.md5(password, "javacoder"));}
}

分页工具类

/*** 分页工具类* @author Administrator**/
public class PageUtil {/*** 生成分页代码* @param targetUrl 目标地址* @param totalNum 总记录数* @param currentPage 当前页* @param pageSize 每页大小* @return*/public static String genPagination(String targetUrl, //目标urllong totalNum,    //总记录数int currentPage,  //当前页int pageSize,     //每页显示记录数String param) {   //参数//计算总页数long totalPage = totalNum % pageSize==0 ? totalNum/pageSize : totalNum/pageSize+1; if(totalPage == 0){return "未查询到数据";}else{StringBuffer pageCode = new StringBuffer();if(currentPage > 1) {pageCode.append("<li><a href='" + targetUrl + "?page=1&" + param + "'>首页</a></li>");pageCode.append("<li><a href='" + targetUrl + "?page=" + (currentPage-1) + "&" + param + "'>上一页</a></li>");			}else{pageCode.append("<li class='disabled'><a>首页</a></li>");pageCode.append("<li class='disabled'><a>上一页</a></li>");		}for(int i = currentPage - 2; i <= currentPage + 2; i++) {if(i < 1 || i > totalPage) {continue;}if(i == currentPage) {pageCode.append("<li class='active'><a href='" + targetUrl + "?page=" + i + "&" + param + "'>" + i + "</a></li>");	}else{pageCode.append("<li><a href='" + targetUrl + "?page=" + i + "&" + param + "'>" + i + "</a></li>");	}}if(currentPage < totalPage) {pageCode.append("<li><a href='" + targetUrl + "?page=" + (currentPage+1) + "&" + param + "'>下一页</a></li>");pageCode.append("<li><a href='" + targetUrl + "?page=" + totalPage + "&" + param + "'>尾页</a></li>");}else{pageCode.append("<li class='disabled'><a>下一页</a></li>");	pageCode.append("<li class='disabled'><a>尾页</a></li>");}return pageCode.toString();}}public static String getPrevAndNextPageCode(Blog prev, Blog next, String projectContent) {StringBuffer pageCode = new StringBuffer();if(prev == null || prev.getId() == null) {pageCode.append("<p>上一篇：无</P>");} else {pageCode.append("<p>上一篇：<a href='" + projectContent + "/blog/articles/" + prev.getId() + ".html'>" + prev.getTitle() + "</a></p>");}if(next == null || next.getId() == null) {pageCode.append("<p>下一篇：无</P>");} else {pageCode.append("<p>上一篇：<a href='" + projectContent + "/blog/articles/" + next.getId() + ".html'>" + next.getTitle() + "</a></p>");}return pageCode.toString();}//Lucence搜索博客结果的分页public static String getUpAndDownPageCode (Integer page, Integer totalNum, String q, Integer pageSize, String projectContext) {//计算总页数long totalPage = totalNum % pageSize==0 ? totalNum/pageSize : totalNum/pageSize+1; StringBuffer pageCode = new StringBuffer();if(totalPage == 0) {return "";} else {pageCode.append("<nav>");pageCode.append("<ul class='pager'>");if(page > 1) {pageCode.append("<li><a href='"+projectContext+"/blog/search.html?page="+(page-1)+"&q="+q+"'>上一页</a></li>");} else {pageCode.append("<li class='disabled'><a>上一页</a></li>");}if(page < totalPage) {pageCode.append("<li><a href='"+projectContext+"/blog/search.html?page="+(page+1)+"&q="+q+"'>下一页</a></li>");} else {pageCode.append("<li class='disabled'><a>下一页</a></li>");}pageCode.append("</ul>");pageCode.append("<nav>");pageCode.append("<nav>");pageCode.append("<nav>");}return pageCode.toString();}}