评论内容添加不到表里面,一直报user_id不能为空,目前解决不了问题
您的每一个用心回答,都会让这个世界变得更美好一些!
评论:
@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; } }
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;
评论: