mybatis insert 数据 NullPointerException

来源：互联网发布：淘宝延长收货花呗编辑：程序博客网时间：2024/05/16 00:40

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，

0 0