java.sql.SQLException: Field ‘id‘ doesn‘t have a default value Query

java.sql.SQLException: Field ‘id’ doesn’t have a default value Query: insert into user(email,nickname,pwd,recipient,address,phone) values(?,?,?,?,?,?) Parameters: [2025227736@qq.com, cyfwlp3, Aa123456!, 陈一发, 重庆, 18700213652]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:320)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:489)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:455)
at com.cskaoyan.mall.dao.UserDaoImpl.signup(UserDaoImpl.java:66)
at com.cskaoyan.mall.service.UserServiceImpl.signup(UserServiceImpl.java:46)
at com.cskaoyan.mall.controller.mall.UserServlet.signup(UserServlet.java:48)
at com.cskaoyan.mall.controller.mall.UserServlet.doPost(UserServlet.java:36)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.cskaoyan.mall.filter.MallFilter.doFilter(MallFilter.java:50)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)atorg.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1627)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)atorg.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)

往数据库插入的数据的时候报这个错误，
sql语句是
insert into user(email,nickname,pwd,recipient,address,phone) values(?,?,?,?,?,?)

这是我的数据库字段

开始 专门给id也赋值null，但是报错说id不能为null

后来不给id赋值，也就是上面的sql语句， 就报这个错误
bug的原因是 属性id不能拥有一个默认的值

解决办法是 建表的时候 把id设为主键的同时，还要把id 设为自增长，这样继续执行上面的sql语句就不会报错了。

![(https://img-blog.csdnimg.cn/20200811204652440.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzQ2NTY2MDIz,size_16,color_FFFFFF,t_70)

查到还有一种还有方法，没有试验，若id不为主键，则设置可以为空或者赋值为默认值。