Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Paramet

2024-03-26 22:18

本文主要是介绍Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Paramet,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

2013-1-17 22:16:07 org.apache.catalina.core.AprLifecycleListener init
信息: Loaded APR based Apache Tomcat Native library 1.1.22.
2013-1-17 22:16:07 org.apache.catalina.core.AprLifecycleListener init
信息: APR capabilities: IPv6 [false], sendfile [true], accept filters [false], random [true].
2013-1-17 22:16:16 org.apache.coyote.http11.Http11AprProtocol init
信息: Initializing Coyote HTTP/1.1 on http-8080
2013-1-17 22:16:16 org.apache.coyote.ajp.AjpAprProtocol init
信息: Initializing Coyote AJP/1.3 on ajp-8009
2013-1-17 22:16:16 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 10090 ms
2013-1-17 22:16:17 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2013-1-17 22:16:17 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/6.0.35
2013-1-17 22:16:17 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor day22.xml
2013-1-17 22:16:17 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor host-manager.xml
2013-1-17 22:16:17 org.apache.catalina.startup.HostConfig deployDescriptor
信息: Deploying configuration descriptor manager.xml
2013-1-17 22:16:17 org.apache.catalina.startup.HostConfig deployWAR
信息: Deploying web application archive livestore.war
2013-1-17 22:16:17 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory bookstore
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory day20
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory day21
ServletContextAttribute域中添加了新对象
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory day22_log4j
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory docs
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory examples
2013-1-17 22:16:18 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2013-1-17 22:16:18 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2013-1-17 22:16:18 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory ItheimaTfyBookstore
2013-1-17 22:16:19 org.apache.catalina.startup.HostConfig deployDirectory
信息: Deploying web application directory ROOT
2013-1-17 22:16:19 org.apache.coyote.http11.Http11AprProtocol start
信息: Starting Coyote HTTP/1.1 on http-8080
2013-1-17 22:16:19 org.apache.coyote.ajp.AjpAprProtocol start
信息: Starting Coyote AJP/1.3 on ajp-8009
2013-1-17 22:16:19 org.apache.catalina.startup.Catalina start
信息: Server startup in 2376 ms
log4j:WARN No appenders could be found for logger (org.apache.commons.beanutils.converters.BooleanConverter).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
com.itheima.tfy.exception.DaoException: java.sql.SQLException: Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Parameters: [5cfa378d-4336-4373-975b-8423c05a75c2, null, ??????java????¨??????????  java????¨???????]
at com.itheima.tfy.dao.impl.CategoryDaoImpl.addCategory(CategoryDaoImpl.java:25)
at com.itheima.tfy.serice.impl.BusinessServiceImpl.addCategory(BusinessServiceImpl.java:19)
at com.itheima.tfy.web.servlet.ManagerServlet.addCategory(ManagerServlet.java:35)
at com.itheima.tfy.web.servlet.ManagerServlet.doGet(ManagerServlet.java:24)
at com.itheima.tfy.web.servlet.ManagerServlet.doPost(ManagerServlet.java:47)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.itheima.tfy.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Parameters: [5cfa378d-4336-4373-975b-8423c05a75c2, null, ??????java????¨??????????  java????¨???????]
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.itheima.tfy.dao.impl.CategoryDaoImpl.addCategory(CategoryDaoImpl.java:20)
... 21 more
com.itheima.tfy.exception.DaoException: java.sql.SQLException: Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Parameters: [4bf4a026-4155-4dd8-8a8e-d9a7ca6ed2c0, null, ??????java????¨??????????  java????¨???????]
at com.itheima.tfy.dao.impl.CategoryDaoImpl.addCategory(CategoryDaoImpl.java:25)
at com.itheima.tfy.serice.impl.BusinessServiceImpl.addCategory(BusinessServiceImpl.java:19)
at com.itheima.tfy.web.servlet.ManagerServlet.addCategory(ManagerServlet.java:35)
at com.itheima.tfy.web.servlet.ManagerServlet.doGet(ManagerServlet.java:24)
at com.itheima.tfy.web.servlet.ManagerServlet.doPost(ManagerServlet.java:47)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.itheima.tfy.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Parameters: [4bf4a026-4155-4dd8-8a8e-d9a7ca6ed2c0, null, ??????java????¨??????????  java????¨???????]
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.itheima.tfy.dao.impl.CategoryDaoImpl.addCategory(CategoryDaoImpl.java:20)
... 21 more

这篇关于Column 'name' cannot be null Query: insert into category (id,name,description) values(?,?,?) Paramet的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/850019

相关文章

使用雪花算法产生id导致前端精度缺失问题解决方案

《使用雪花算法产生id导致前端精度缺失问题解决方案》雪花算法由Twitter提出,设计目的是生成唯一的、递增的ID,下面:本文主要介绍使用雪花算法产生id导致前端精度缺失问题的解决方案,文中通过代... 目录一、问题根源二、解决方案1. 全局配置Jackson序列化规则2. 实体类必须使用Long封装类3.

SpringBoot整合mybatisPlus实现批量插入并获取ID详解

《SpringBoot整合mybatisPlus实现批量插入并获取ID详解》这篇文章主要为大家详细介绍了SpringBoot如何整合mybatisPlus实现批量插入并获取ID,文中的示例代码讲解详细... 目录【1】saveBATch(一万条数据总耗时:2478ms)【2】集合方式foreach(一万条数

Vue3组件中getCurrentInstance()获取App实例,但是返回null的解决方案

《Vue3组件中getCurrentInstance()获取App实例,但是返回null的解决方案》:本文主要介绍Vue3组件中getCurrentInstance()获取App实例,但是返回nu... 目录vue3组件中getCurrentInstajavascriptnce()获取App实例,但是返回n

浅析Java中如何优雅地处理null值

《浅析Java中如何优雅地处理null值》这篇文章主要为大家详细介绍了如何结合Lambda表达式和Optional,让Java更优雅地处理null值,感兴趣的小伙伴可以跟随小编一起学习一下... 目录场景 1:不为 null 则执行场景 2:不为 null 则返回,为 null 则返回特定值或抛出异常场景

MySQL INSERT语句实现当记录不存在时插入的几种方法

《MySQLINSERT语句实现当记录不存在时插入的几种方法》MySQL的INSERT语句是用于向数据库表中插入新记录的关键命令,下面:本文主要介绍MySQLINSERT语句实现当记录不存在时... 目录使用 INSERT IGNORE使用 ON DUPLICATE KEY UPDATE使用 REPLACE

mysql数据库重置表主键id的实现

《mysql数据库重置表主键id的实现》在我们的开发过程中,难免在做测试的时候会生成一些杂乱无章的SQL主键数据,本文主要介绍了mysql数据库重置表主键id的实现,具有一定的参考价值,感兴趣的可以了... 目录关键语法演示案例在我们的开发过程中,难免在做测试的时候会生成一些杂乱无章的SQL主键数据,当我们

如何解决mysql出现Incorrect string value for column ‘表项‘ at row 1错误问题

《如何解决mysql出现Incorrectstringvalueforcolumn‘表项‘atrow1错误问题》:本文主要介绍如何解决mysql出现Incorrectstringv... 目录mysql出现Incorrect string value for column ‘表项‘ at row 1错误报错

Pycharm安装报错:Cannot detect a launch configuration解决办法

《Pycharm安装报错:Cannotdetectalaunchconfiguration解决办法》本文主要介绍了Pycharm安装报错:Cannotdetectalaunchconfigur... 本文主要介绍了Pycharm安装报错:Cannot detect a launch configuratio

mysql8.0无备份通过idb文件恢复数据的方法、idb文件修复和tablespace id不一致处理

《mysql8.0无备份通过idb文件恢复数据的方法、idb文件修复和tablespaceid不一致处理》文章描述了公司服务器断电后数据库故障的过程,作者通过查看错误日志、重新初始化数据目录、恢复备... 周末突然接到一位一年多没联系的妹妹打来电话,“刘哥,快来救救我”,我脑海瞬间冒出妙瓦底,电信火苲马扁.

mybatis和mybatis-plus设置值为null不起作用问题及解决

《mybatis和mybatis-plus设置值为null不起作用问题及解决》Mybatis-Plus的FieldStrategy主要用于控制新增、更新和查询时对空值的处理策略,通过配置不同的策略类型... 目录MyBATis-plusFieldStrategy作用FieldStrategy类型每种策略的作