blog完整版

dao

package com.zr.dao;

import com.zr.po.Blog;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface BlogDao extends JpaRepository<Blog,Long> , JpaSpecificationExecutor<Blog> {
   

    @Query("SELECT b FROM Blog b where b.recommend=true")
    List<Blog> findTop(Pageable pageable);

    @Query("SELECT b FROM Blog b WHERE b.title LIKE ?1 or b.content LIKE ?1")
    Page<Blog> findByQuery(String s, Pageable pageable);

    @Query("select function('date_format',b.updateTime,'%Y') as year from Blog b group by year order by year desc")
    List<String> findGroupYear();

    @Query("select b from Blog b where function('date_format',b.updateTime,'%Y') = ?1")
    List<Blog> findByYear(String y);
}

package com.zr.dao;

import com.zr.po.Comment;
import org.springframework.data.domain.Sort;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.List;

public interface CommentDao extends JpaRepository<Comment,Long> {
   
    List<Comment> findByBlogIdAndParentCommentNull(Long blogId, Sort sort);
}

package com.zr.dao;

import com.zr.po.Tag;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface TagDao extends JpaRepository<Tag,Long> {
   
    @Query("SELECT t FROM Tag t")
    List<Tag> findTop(Pageable pageable);
}

package com.zr.dao;

import com.zr.po.Type;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface TypeDao extends JpaRepository<Type,Long> {
   

    @Query("SELECT t FROM Type t")
    List<Type> findTop(Pageable pageable);
}

package com.zr.dao;

import com.zr.po.User;
import org.springframework.data.jpa.repository.JpaRepository;

public interface UserDao extends JpaRepository<User,Long> {
   
    User findByUsernameAndPassword(String username, String password);
}

interceptor

package com.zr.interceptor;

import org.springframework.web.servlet.handler.HandlerInterceptorAdapter;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Longinterceptor extends HandlerInterceptorAdapter {
   
    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
   
        if (request.getSession().getAttribute("user")==null){
   
            response.sendRedirect("/admin");
            return false;
        }
        return true;
    }
}

package com.zr.interceptor;

import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.InterceptorRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter;

@Configuration
public class WebConfig extends WebMvcConfigurerAdapter {
   
    @Override
    public void addInterceptors(InterceptorRegistry registry) {
   
        registry.addInterceptor(new Longinterceptor()).addPathPatterns("/admin/**").excludePathPatterns("/admin/login").excludePathPatterns("/admin");
    }
}

po

package com.zr.po;

import javax.persistence.*;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

/**
 * Created by limi on 2017/10/14.
 */
@Entity
@Table(name = "t_blog")
public class Blog {
   

    @Id
    @GeneratedValue
    private Long id;

    private String title;

    @Basic(fetch = FetchType.LAZY)
    @Lob
    private String content;
    private String firstPicture;
    private String flag;
    private Integer views;
    private boolean appreciation;
    private boolean shareStatement;
    private boolean commentabled;
    private boolean published;
    private boolean recommend;
    @Temporal(TemporalType.TIMESTAMP)
    private Date createTime;
    @Temporal(TemporalType.TIMESTAMP)
    private Date updateTime;

    @ManyToOne
    private Type type;

    @ManyToMany(cascade = {
   CascadeType.PERSIST})
    private List<Tag> tags = new ArrayList<>();


    @ManyToOne
    private User user;

    @OneToMany(mappedBy = "blog")
    private List<Comment> comments = new ArrayList<>();

    @Transient
    private String tagIds;

    private String description;

    public Blog() {
   
    }

    public Long getId() {
   
        return id;
    }

    public void setId(Long id) {
   
        this.id = id;
    }

    public String getTitle() {
   
        return title;
    }

    public void setTitle(String title) {
   
        this.title = title;
    }

    public String getContent() {
   
        return content;
    }

    public void setContent(String content) {
   
        this.content = content;
    }

    public String getFirstPicture() {
   
        return firstPicture;
    }

    public void setFirstPicture(String firstPicture) {
   
        this.firstPicture = firstPicture;
    }

    public String getFlag() {
   
        return flag;
    }

    public void setFlag(String flag) {
   
        this.flag = flag;
    }

    public Integer getViews() {
   
        return views;
    }

    public void setViews(Integer views) {
   
        this.views = views;
    }

    public boolean isAppreciation() {
   
        return appreciation;
    }

    public void setAppreciation(boolean appreciation) {
   
        this.appreciation = appreciation;
    }

    public boolean isShareStatement() {
   
        return shareStatement;
    }

    public void setShareStatement(boolean shareStatement) {
   
        this.shareStatement = shareStatement;
    }

    public boolean isCommentabled() {
   
        return commentabled;
    }

    public void setCommentabled(boolean commentabled) {
   
        this.commentabled = commentabled;
    }

    public boolean isPublished() {
   
        return published;
    }

    public void setPublished(boolean published) {
   
        this.published = published;
    }

    public boolean isRecommend() {
   
        return recommend;
    }

    public void setRecommend(boolean recommend) {
   
        this.recommend = recommend;
    }

    public Date getCreateTime() {
   
        return createTime;
    }

    public void setCreateTime(Date createTime) {
   
        this.createTime = createTime;
    }

    public Date getUpdateTime() {
   
        return updateTime;
    }

    public void setUpdateTime(Date updateTime) {
   
        this.updateTime = updateTime;
    }

    public Type getType() {
   
        return type;
    }

    public void setType(Type type) {
   
        this.type = type;
    }

    public List<Tag> getTags() {
   
        return tags;
    }

    public void setTags(List<Tag> tags) {
   
        this.tags = tags;
    }


    public User getUser() {
   
        return user;
    }

    public void setUser(User user) {
   
        this.user = user;
    }


    public List<Comment> getComments() {
   
        return comments;
    }

    public void setComments(List<Comment> comments) {
   
        this.comments = comments;
    }


    public String getTagIds() {
   
        return tagIds;
    }

    public void setTagIds(String tagIds) {
   
        this.tagIds = tagIds;
    }

    public String getDescription() {
   
        return description;
    }

    public void setDescription(String description) {
   
        this.description = description;
    }

    public void init() {
   
        this.tagIds = tagsToIds(this.getTags());
    }

    //1,2,3
    private String tagsToIds(List<Tag> tags) {
   
        if (!tags.isEmpty()) {
   
            StringBuffer ids = new StringBuffer();
            boolean flag = false;
            for (Tag tag : tags) {
   
                if (flag) {
   
                    ids.append(",");
                } else {
   
                    flag = true;
                }
                ids.append(tag.getId());
            }
            return ids.toString();
        } else {
   
            return tagIds;
        }
    }


    @Override
    public String toString() {
   
        return "Blog{" +
                "id=" + id +
                ", title='" + title + '\'' +
                ", content='" + content + '\'' +
                ", firstPicture='" + firstPicture + '\'' +
                ", flag='" + flag + '\'' +
                ", views=" + views +
                ", appreciation=" + appreciation +
                ", shareStatement=" + shareStatement +
                ", commentabled=" + commentabled +
                ", published=" + published +
                ", recommend=" + recommend +
                ", createTime=" + createTime +
                ", updateTime=" + updateTime