如何使用Spring Data JPA自动生成数据库表

首先新建一个类,比如News.java新闻类,这个类里面有唯一关键字ID,新闻标题,新闻内容,新闻图片的URL,新闻状态,新闻的浏览次数,新闻的赞赏功能,新闻的转载许可,新闻的评论许可,新闻的发布,新闻是否推荐,新闻创建时间,新闻的更新时间,新闻的类型,新闻的标签,新闻的作者,新闻的评论,新闻的标签ID,新闻的描述。
然后创建对应得get、set方法和构造函数以及toString()方法。最后也是最关键的一步,就是给这个类里面加上注解,方便JPA进行自动生成数据库表。

package com.zhongruan.entity;

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

@Entity
@Table(name = "t_news")
public class News {

    @Id
    @GeneratedValue
    private Long id;

    private String title;           // 新闻标题
    private String content;         // 新闻内容
    private String firstPicture;    // 新闻图片的url
    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 = "news")
    private List<Comment> comments = new ArrayList<>();  // 新闻的评论

    @Transient
    private String tagIds;

    private String description;

    public News() {
    }

    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 "News{" +
                "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 +
                ", type=" + type +
                ", tags=" + tags +
                ", user=" + user +
                ", comments=" + comments +
                ", tagIds='" + tagIds + '\'' +
                ", description='" + description + '\'' +
                '}';
    }

    public void initTags(Long id) {
        //3,4,5
        List<Tag> tags = this.getTags();
        StringBuffer ids=new StringBuffer();
        if(!tags.isEmpty()){
            Boolean flag=false;
            for(Tag t:tags){
                if(flag){
                    ids.append(t.getId());
                    flag=true;
                }else {
                    ids.append(",");
                    ids.append(t.getId());
                }

            }
            this.setTagIds(ids.toString());
        }

    }
}

执行完毕以后发现t_news这张表就被成功生成了!

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值