0
  • 最佳答案

    评论:

    @Entity
    @Table ( name ="tb_comment" )
    public class Comment {
    
       @Id
       private String id;
       @Column(name = "parent_content" )
       private String parentContent;
       @Column(name = "article_id" )
       private String articleId;
       @Column(name = "content" )
       private String content;
       @Column(name = "user_id" )
       private String user_id;
       @Column(name = "user_avatar" )
       private String user_avatar;
       @Column(name = "user_name" )
       private String user_name;
       @Column(name = "state" )
       private String state;
       @Column(name = "create_time" )
       private Date createTime;
       @Column(name = "update_time" )
       private Date updateTime;
    
    
       public String getId() {
          return id;
       }
    
       public void setId(String id) {
          this.id = id;
       }
    
    
       public String getParentContent() {
          return parentContent;
       }
    
       public void setParentContent(String parentContent) {
          this.parentContent = parentContent;
       }
    
    
       public String getArticleId() {
          return articleId;
       }
    
       public void setArticleId(String articleId) {
          this.articleId = articleId;
       }
    
    
       public String getContent() {
          return content;
       }
    
       public void setContent(String content) {
          this.content = content;
       }
    
    
       public String getUser_id() {
          return user_id;
       }
    
       public void setUser_id(String user_id) {
          this.user_id = user_id;
       }
    
    
       public String getUser_avatar() {
          return user_avatar;
       }
    
       public void setUser_avatar(String user_avatar) {
          this.user_avatar = user_avatar;
       }
    
    
       public String getUser_name() {
          return user_name;
       }
    
       public void setUser_name(String user_name) {
          this.user_name = user_name;
       }
    
    
       public String getState() {
          return state;
       }
    
       public void setState(String state) {
          this.state = state;
       }
    
       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;
       }
    }
    


    1139423796017500160  评论     打赏       断点-含光君
    • 断点-含光君  回复 @断点-含光君
      Page<Comment> findAllByArticleId(String articleId, Pageable pageable); Comment findOneById(String commentId); int deleteAllByArticleId(String articleId);
      断点-含光君 2021-02-03 21:33   回复 1139423796017500160
    • 断点-含光君  回复 @断点-含光君
      我的就这样
      断点-含光君 2021-02-03 21:33   回复 1139423796017500160
    • bugdr  回复 @断点-含光君
      你的评论表的是这样写的吗
      bugdr 2021-02-04 10:41   回复 1347474750661849088
    • bugdr  回复 @断点-含光君
      这个是加在dao层里面吗
      bugdr 2021-02-04 10:54   回复 1347474750661849088
    • 断点-含光君  回复 @bugdr
      上面那个是表的Java。下面代码是dao,代码,其实没多少。 就是几个简单的查询
      断点-含光君 2021-02-04 11:49   回复 1139423796017500160
    • bugdr  回复 @断点-含光君
      可能是我数据库没设置好,导致这个user表里面的主键id的值传不到评论表里面,或者是中途直接给他删除了
      bugdr 2021-02-04 12:28   回复 1347474750661849088
    • bugdr  回复 @断点-含光君
      他是插入不成功,就是报user_id不能为空,我给评论表里面加入了数据都没用,估计就是中途给删除了
      bugdr 2021-02-04 12:30   回复 1347474750661849088
    • 断点-含光君  回复 @bugdr
      这个表结构,我记得是课程里面,资料里面有的,是一个sql的脚本 。直接导入就可以了。
      断点-含光君 2021-02-04 13:59   回复 1139423796017500160
  • CREATE TABLE `tb_comment` (
      `id` varchar(20) NOT NULL COMMENT 'ID',
      `parent_content` text COMMENT '父内容',
      `article_id` varchar(20) NOT NULL COMMENT '文章ID',
      `content` text NOT NULL COMMENT '评论内容',
      `user_id` varchar(20) NOT NULL COMMENT '评论用户的ID',
      `user_avatar` varchar(1024) DEFAULT NULL COMMENT '评论用户的头像',
      `user_name` varchar(32) DEFAULT NULL COMMENT '评论用户的名称',
      `state` varchar(1) NOT NULL COMMENT '状态(0表示删除,1表示正常)',
      `create_time` datetime NOT NULL COMMENT '创建时间',
      `update_time` datetime NOT NULL COMMENT '更新时间',
      PRIMARY KEY (`id`),
      KEY `fk_user_comment_on_user_id` (`user_id`),
      KEY `fk_article_comment_on_article_id` (`article_id`),
      CONSTRAINT `fk_article_comment_on_article_id` FOREIGN KEY (`article_id`) REFERENCES `tb_article` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
      CONSTRAINT `fk_user_comment_on_user_id` FOREIGN KEY (`user_id`) REFERENCES `tb_user` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
    ) ENGINE=INNODB CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
    
    1347474750661849088  评论     打赏       bugdr
    相关问题
    deanhu · AOSP
    2024-04-25 21:53 2 10
    幻影~ · 提问
    2024-04-13 20:13 10 2
    幻影~ · 找工作
    2024-04-07 10:44 16 2
    幻影~ · 问题
    2024-03-31 17:20 7 2
    TONYGFX · AOSP
    2024-03-28 17:11 4 2