我的博客网站设计

最新推荐文章于 2022-12-13 11:49:27 发布
原创 最新推荐文章于 2022-12-13 11:49:27 发布 · 2.1k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文详细介绍了博客系统的核心功能，包括用户注册、文章发布、评论互动、好友动态浏览等，并深入探讨了其背后的技术栈，如servlet+jsp+spring+jpa、jQuery以及MySQL数据库。重点阐述了JPA开发环境搭建步骤，从persistence.xml配置到Spring与JPA的整合，再到数据库表设计，涵盖了master、friend、artical、articalType、photo和word等关键表的设计。

网站简介

一个博客系统，能够注册用户，发表博文，浏览博文，评论博文，查看好友博文，上传照片等


网站技术

后台：servlet+jsp+spring+jpa

前台：jquery

数据库：mysql

网站具体设计

网站开发环境搭建

网站所需jar包：

MVC各个包的对应情况

搭建JPA开发环境

在MATA—INF文件夹下放置persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0">
  <persistence-unit name="itcast" transaction-type="RESOURCE_LOCAL">
      <properties>
         <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/>
         <property name="hibernate.connection.driver_class" value="org.gjt.mm.mysql.Driver"/>
         <property name="hibernate.connection.username" value="root"/>
         <property name="hibernate.connection.password" value="syj123"/>
         <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/itcast?useUnicode=true&characterEncoding=UTF-8"/>
         <property name="hibernate.max_fetch_depth" value="3"/>
         <property name="hibernate.hbm2ddl.auto" value="update"/>
      </properties>
  </persistence-unit>
</persistence>

搭建Spring与JPA的开发环境

主要在是beans.xml中实现JPA常用基础类的加载

<?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:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-2.5.xsd
           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
           http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
  
  <context:component-scan base-package="cn.itcast"/>
  
  <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">
      <property name="persistenceUnitName" value="itcast"/>
  </bean>  

  <bean id="txManager" class="org.springframework.orm.jpa.JpaTransactionManager">
  	<property name="entityManagerFactory" ref="entityManagerFactory"/>
  </bean>
  
  <tx:annotation-driven transaction-manager="txManager"/>
</beans>



数据库

采用jpa设计数据库：

各个数据表的设计

master(用户)

package cn.itcast.bean.db;




import java.util.Date;
import java.util.HashSet;
import java.util.Set;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

@Entity
public class Master {
	private int QICQ;
	private String name;
	private String password;
	private String sex;
	private String email;

	private Date regiestdate;
	private Set<Friend> friendset=new HashSet<Friend>();
	private Set<Photo> photoset=new HashSet<Photo>();
	private Set<Artical> articalset=new HashSet<Artical>();
	private Set<Word> wordset=new HashSet<Word>();
	@OneToMany(cascade=CascadeType.REFRESH,fetch=FetchType.LAZY,mappedBy="master")
	public Set<Word> getWordset() {
		return wordset;
	}
	public void setWordset(Set<Word> wordset) {
		this.wordset = wordset;
	}
	@OneToMany(cascade=CascadeType.REFRESH,fetch=FetchType.LAZY,mappedBy="master")
	public Set<Artical> getArticalset() {
		return articalset;
	}

	public void setArticalset(Set<Artical> articalset) {
		this.articalset = articalset;
	}
	@Column(length=50)
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
    @OneToMany(cascade=CascadeType.REFRESH,mappedBy="master",fetch=FetchType.LAZY)
	public Set<Photo> getPhotoset() {
		return photoset;
	}
	public void setPhotoset(Set<Photo> photoset) {
		this.photoset = photoset;
	}
	@Id @GeneratedValue
	public int getQICQ() {
		return QICQ;
	}
	public void setQICQ(int qICQ) {
		QICQ = qICQ;
	}
	public void setName(String name) {
		this.name = name;
	}
	@Column(length=20,nullable=false)
	public String getName() {
		return name;
	}

	@Column(length=20,nullable=false)
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	@Column(length=5,nullable=false)
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	@Temporal(TemporalType.DATE)
	public Date getRegiestdate() {
		return regiestdate;
	}
	public void setRegiestdate(Date regiestdate) {
		this.regiestdate = regiestdate;
	}
	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + (int) (QICQ ^ (QICQ >>> 32));
		return result;
	}
	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		Master other = (Master) obj;
		if (QICQ != other.QICQ)
			return false;
		return true;
	}
	@OneToMany(cascade=(CascadeType.REFRESH),mappedBy="master",fetch=FetchType.LAZY)
	public Set<Friend> getFriendset() {
		return friendset;
	}
	public void setFriendset(Set<Friend> friendset) {
		this.friendset = friendset;
	}
	public void addFriend(Friend friend)
	{
		friend.setMaster(this);
		this.friendset.add(friend);
	}
	public void removefriend(Friend friend)
	{
		if(this.friendset.contains(friend))
		{
			this.friendset.remove(friend);
		}
		
	}

}
Feriend(用户好友表) 

package cn.itcast.bean.db;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
@Entity
public class Friend {
	private int id;
	private String name;
	private String sex;
	private String QICQ;
	private Master master;
	@Id @GeneratedValue

	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	@Column(length=30)
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	@Column(length=5)
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getQICQ() {
		return QICQ;
	}
	public void setQICQ(String qICQ) {
		QICQ = qICQ;
	}
	@ManyToOne(cascade=CascadeType.REFRESH)
	@JoinColumn(name="master_QICQ")
	public Master getMaster() {
		return master;
	}
	public void setMaster(Master master) {
		this.master = master;
	}
	

}

Artical(文章表) 

package cn.itcast.bean.db;

import java.util.Date;
import java.util.HashSet;
import java.util.Set;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.Lob;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

@Entity
public class Artical {
	private int Id;
	private String title;//标题
	private ArticalType articalType;//文章类型
	private String content;//正文内容
	private Date sdTime;//写文章时间
	private String info;//注释
	private String comeform;
	private int count;//阅读此时
	private Set<Word> wordset=new HashSet<Word>();
	private Master master;
	@ManyToOne(cascade=CascadeType.REFRESH)
	@JoinColumn(name="master_id")
	public Master getMaster() {
		return master;
	}
	public void setMaster(Master master) {
		this.master = master;
	}
	@OneToMany(cascade=CascadeType.REFRESH,mappedBy="artical",fetch=FetchType.LAZY)
	public Set<Word> getWordset() {
		return wordset;
	}
	public void setWordset(Set<Word> wordset) {
		this.wordset = wordset;
	}
	@Lob
	public String getContent() {
		return content;
	}
	public void setContent(String content) {
		this.content = content;
	}
	@Temporal(TemporalType.DATE)
	public Date getSdTime() {
		return sdTime;
	}
	public void setSdTime(Date sdTime) {
		this.sdTime = sdTime;
	}
	public String getInfo() {
		return info;
	}
	public void setInfo(String info) {
		this.info = info;
	}
	public int getCount() {
		return count;
	}
	public void setCount(int count) {
		this.count = count;
	}
	@ManyToOne
	@JoinColumn(name="articalType_id")
	public ArticalType getArticalType() {
		return articalType;
	}
	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + Id;
		return result;
	}
	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		Artical other = (Artical) obj;
		if (Id != other.Id)
			return false;
		return true;
	}
	public void setArticalType(ArticalType articalType) {
		this.articalType = articalType;
	}
	@Id @GeneratedValue
	public int getId() {
		return Id;
	}
	public void setId(int id) {
		Id = id;
	}
	@Column(length=50)
	public String getTitle() {
		return title;
	}
	public void setTitle(String title) {
		this.title = title;
	}
	@Column(length=20)
	public String getComeform() {
		return comeform;
	}
	public void setComeform(String comeform) {
		this.comeform = comeform;
	}
	


}

ArticalType(文章类型表) 

package cn.itcast.bean.db;
import java.util.HashSet;
import java.util.Set;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.OneToMany;

@Entity
public class ArticalType  {
	private int Id;
	private String name;
	private String info;
	private Set<Artical> articalset=new HashSet<Artical>();
	@OneToMany(cascade=(CascadeType.REFRESH),mappedBy="articalType",fetch=FetchType.LAZY)
	public Set<Artical> getArtical() {
		return articalset;
	}
	public void setArtical(Set<Artical> articalset) {
		this.articalset = articalset;
	}
	public void addArtical(Artical artical)
	{
		artical.setArticalType(this);
		this.articalset.add(artical);
	}
	public void removeArtical(Artical artical)
	{
		if(this.articalset.contains(artical))
		{
			this.articalset.remove(artical);
		}
	}
	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + Id;
		return result;
	}
	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		ArticalType other = (ArticalType) obj;
		if (Id != other.Id)
			return false;
		return true;
	}
	@Id @GeneratedValue
	public int getId() {
		return Id;
	}
	public void setId(int id) {
		Id = id;
	}
	@Column(length=30,nullable=false)
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getInfo() {
		return info;
	}
	public void setInfo(String info) {
		this.info = info;
	}
	
	

}

Photo(图片表) 

package cn.itcast.bean.db;

import java.util.Date;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.Lob;
import javax.persistence.ManyToOne;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
@Entity
public class Photo {
	private int id;

	private String name;
	private Date uptime;
	private String photoinfo;
	private String pathname;
	private byte[] image;
	private Master master;
	@Column(length=30)
	public String getPhotoinfo() {
		return photoinfo;
	}
	public void setPhotoinfo(String photoinfo) {
		this.photoinfo = photoinfo;
	}
	@Column(length=30)
	public String getPathname() {
		return pathname;
	}
	public void setPathname(String pathname) {
		this.pathname = pathname;
	}
	@ManyToOne(cascade=CascadeType.REFRESH)
	@JoinColumn(name="master_id")
	public Master getMaster() {
		return master;
	}
	public void setMaster(Master master) {
		this.master = master;
	}
	@Id @GeneratedValue
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	@Column(length=50)
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	@Temporal(TemporalType.DATE)
	public Date getUptime() {
		return uptime;
	}
	public void setUptime(Date uptime) {
		this.uptime = uptime;
	}

	@Lob
	public byte[] getImage() {
		return image;
	}
	public void setImage(byte[] image) {
		this.image = image;
	}
	
	

}

Word(评论表) 

package cn.itcast.bean.db;

import java.util.Date;
import java.util.HashSet;
import java.util.Set;

import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
@Entity
public class Word {
	private int id;
	private String content;
	private Date setdate;
	private Artical artical;
	private Set<Review> reviewset=new HashSet<Review>();
	private Master master;
	@ManyToOne
	@JoinColumn(name="master_id")
	public Master getMaster() {
		return master;
	}
	public void setMaster(Master master) {
		this.master = master;
	}
	@OneToMany(cascade=CascadeType.REFRESH,mappedBy="word",fetch=FetchType.LAZY)
	public Set<Review> getReviewset() {
		return reviewset;
	}
	public void setReviewset(Set<Review> reviewset) {
		this.reviewset = reviewset;
	}
	@ManyToOne(cascade=CascadeType.REFRESH)
	@JoinColumn(name="artical_id")
	public Artical getArtical() {
		return artical;
	}
	public void setArtical(Artical artical) {
		this.artical = artical;
	}
	@Id @GeneratedValue
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	
	public String getContent() {
		return content;
	}
	public void setContent(String content) {
		this.content = content;
	}
	@Temporal(TemporalType.DATE)
	public Date getSetdate() {
		return setdate;
	}
	public void setSetdate(Date setdate) {
		this.setdate = setdate;
	}

}

Review(回复评论表) 

package cn.itcast.bean.db;

import java.util.Date;

import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

@Entity
public class Review {
	private int Id;
	private String content;
	private Date setdate;
	private Word word;
	@ManyToOne(cascade=CascadeType.REFRESH)
	@JoinColumn(name="word_id")
	public Word getWord() {
		return word;
	}
	public void setWord(Word word) {
		this.word = word;
	}
	@Id @GeneratedValue
	public int getId() {
		return Id;
	}
	public void setId(int id) {
		Id = id;
	}
	
	public String getContent() {
		return content;
	}
	public void setContent(String content) {
		this.content = content;
	}
	@Temporal(TemporalType.DATE)
	public Date getSetdate() {
		return setdate;
	}
	public void setSetdate(Date setdate) {
		this.setdate = setdate;
	}
	

}




我的博客系统（前端页面设计）
m0_65012757的博客
02-23 329
个人博客系统详解+源码
我的博客网站设计源代码
11-02
Jsp+Servlet+Spring+JPA 采用MVC结构，轻松设计出属于你的博客
个人博客网站（网页设计期末作业）
06-25
这个是自己做的期末作业，一个个人博客，用表格做的，结构相对简单，但界面不错，比较美观，适合偷懒的同学“参阅”
我的博客网站静态html
10-15
我的博客页面，使用静态html页面实现，能够进行各个页面的跳转，其中功能使用div和table进行布局，使用frame框架实现整体布局，是代码演示见如下链接：http://blog.youkuaiyun.com/suwu150/article/details/52802357
基于HTML的个人博客网站设计源码
04-09
本项目是基于HTML的个人博客网站设计源码，包含1043个文件，其中939个Markdown文件，34个Stylus文件，29个EJS文件，15个YAML文件，9个JavaScript文件，2个JSON文件，2个CSS文件，2个EOT文件，2个TTF文件和2个WOFF...
基于PHP的个人博客网站设计源码
最新发布
04-15
基于PHP的个人博客网站设计源码，该项目包含121个文件，主要文件类型有68个php源文件，以及11个png图像文件。此外，还包括10个css样式文件，8个jpg图像文件，以及5个xml配置文件。该项目是一个基于PHP的个人博客网站...
基于ThinkPHP6.0的博客网站设计源码
04-07
本项目是一个基于ThinkPHP6.0语言开发的博客网站，包含1196个文件，主要文件类型包括PHP源代码、图片、JavaScript脚本、CSS样式表、HTML页面、JSON配置文件、Markdown文档和Git忽略文件。系统设计旨在为用户提供一个...
基于Javascript的个人博客网站设计源码
03-29
这是一个基于Javascript的个人博客网站设计，使用Javascript和CSS语言开发，包含217个文件。主要文件类型包括106个Pug模板文件、45个Stylus样式文件、31个JavaScript文件、15个YAML配置文件、6个Markdown文档、5个...
个人博客网站的设计与实现.rar
06-22
以上就是个人博客网站设计与实现的关键步骤和技术点。从设计到开发，再到后期的运营与维护，每个环节都对最终的用户体验产生重要影响。通过不断学习和实践，你可以创建出一个既美观又功能丰富的个人博客平台。
html个人博客静态网页制作
06-19
这是一个静态的博客，不过很好，供大家分享
我的博客网页设计
qq_44606245的博客
11-11 860
我的博客网页设计 css文档 body { width: 787px; height: 550px; border: 5px solid #CBCBCB; margin: 100px auto; } .title { height: 46px; width: 787px; font-size: 34px; text-align: center; color: #656467; font-weight: bold; mar
博客网页制作基础大二dw作业 web课程设计网页制作 个人网页设计与实现 我的个人博客网页开发
VX_WJ88950106的博客
12-13 388
📔网站布局方面：计划采用目前主流的、能兼容各大主流浏览器、显示效果稳定的浮动网页布局结构。📓网站程序方面：计划采用最新的网页编程语言HTML5+CSS3+JS程序语言完成网站的功能设计。并确保网站代码兼容目前市面上所有的主流浏览器，已达到打开后就能即时看到网站的效果。📘网站素材方面：计划收集各大平台好看的图片素材，并精挑细选适合网页风格的图片，然后使用PS做出适合网页尺寸的图片。📒网站文件方面：网站系统文件种类包含：html网页结构文件、css网页样式文件、js网页特效文件、images网页图片文件；
《博客页面制作》教程
baomg_82917的博客
12-25 2891
QQ邮箱登录的表单 <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title></title> <style type="text/css"> /*设置整个表单边框*/ #form{ width: 340px; height: 400px; border: 1px solid #a0b1c4; border
我的博客网站开发1——博客首页设计
weixin_30611509的博客
08-13 840
首先是是对导航菜单的设计，个人感觉对界面的设计还是要以大方和显著为主为好。 Html代码： 1 <div id="menu_header"> 2 <ul> 3 <li><a class="menua" href="#">首页</a></li> 4 <li><...
【Bootstarp】个人博客网站设计作品分享（附源码）
有意栽花花不发，无心插柳柳成荫。
06-12 5128
【Bootstarp】个人博客网站设计作品分享（附源码）
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值