ERROR [com.czljy.app.action.CourseAction] - <CourseAction.addComment:评论nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.lang.NullPointerException
### The error may involve com.czljy.mapper.CzlResourceCommentMapper.add-Inline
### The error occurred while setting parameters
### SQL: insert into czl_resource_comment (id,resourceId,userId,userName,answer,createDate,score) values (?,?,?,?,?,?,?)
### Cause: java.lang.NullPointerException>
2016-11-30 14:29:10,921 ERROR [com.czljy.app.action.CourseAction] - <CourseAction.addComment:评论nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: java.lang.NullPointerException
package com.czljy.bean;
import org.springframework.format.annotation.DateTimeFormat;
public class CzlResourceComment extends BaseBean {
private Integer id;// ID
private String resourceId;// 问答答案ID
private Integer userId;// 评论人
private String userName;// 评论人姓名
private String answer;// 评论
private java.sql.Timestamp createDate;// 评论时间
private Integer score;// 评分(这个类型要做修改)
public Integer getId() {
return this.id;
}
public void setId(Integer id) {
this.id=id;
}
public String getResourceId() {
return this.resourceId;
}
public void setResourceId(String resourceId) {
this.resourceId=resourceId;
}
public Integer getUserId() {
return this.userId;
}
public void setUserId(Integer userId) {
this.userId=userId;
}
public String getUserName() {
return this.userName;
}
public void setUserName(String userName) {
this.userName=userName;
}
public String getAnswer() {
return this.answer;
}
public void setAnswer(String answer) {
this.answer=answer;
}
public java.sql.Timestamp getCreateDate() {
return this.createDate;
}
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
public void setCreateDate(java.sql.Timestamp createDate) {
this.createDate=createDate;
}
public int getScore() {
return score;
}
public void setScore(int score) {
this.score = score;
}
}
当实体类CzlResourceComment: score不传入值时,为报这种错误。
因为score为Integer,插入时,类型不匹配,Integer默认为null。
把score类型从Integer改为int
,int是基本数据类型,不初始化值时,默认为0,