MyBatis异常

Error updating database.
Cause: java.sql.SQLException: Field 'id' doesn't have a default value

名为id类型的属性值没有默认值,可能是在创建表单的过程中没有将id设置为主键自增长类型(在写入数据设置id为主键自增长类型)

 

public class Student {
    private Integer id;//使用Intger可以进行非空判断if(id==null)
    private String name;
    private int age;
    private double score;

    public Student() {
    }

    public Student( String name, int age, double score) {
        this.name = name;
        this.age = age;
        this.score = score;
    }



    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public double getScore() {
        return score;
    }

    public void setScore(double score) {
        this.score = score;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                ", score=" + score +
                '}';
    }
}

public class MyTest {
/*测试类*/

private IStudent iStudent ;
@Before
public void before(){
iStudent = new IStudentIMP();//多态(接口)
}
@Test
public void testInsert(){
Student student = new Student("张三",24,88.8);
iStudent.insertStu(student);
}

  

在上传数据至数据库时没有设置id的值)

posted @ 2020-07-30 21:47  star_0114  阅读(238)  评论(0)    收藏  举报