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

相关文章

Oracle 数据库数据操作如何精通 INSERT, UPDATE, DELETE

《Oracle数据库数据操作如何精通INSERT,UPDATE,DELETE》在Oracle数据库中,对表内数据进行增加、修改和删除操作是通过数据操作语言来完成的,下面给大家介绍Oracle数... 目录思维导图一、插入数据 (INSERT)1.1 插入单行数据,指定所有列的值语法:1.2 插入单行数据,指

mysql中insert into的基本用法和一些示例

《mysql中insertinto的基本用法和一些示例》INSERTINTO用于向MySQL表插入新行,支持单行/多行及部分列插入,下面给大家介绍mysql中insertinto的基本用法和一些示例... 目录基本语法插入单行数据插入多行数据插入部分列的数据插入默认值注意事项在mysql中,INSERT I

Springboot3+将ID转为JSON字符串的详细配置方案

《Springboot3+将ID转为JSON字符串的详细配置方案》:本文主要介绍纯后端实现Long/BigIntegerID转为JSON字符串的详细配置方案,s基于SpringBoot3+和Spr... 目录1. 添加依赖2. 全局 Jackson 配置3. 精准控制(可选)4. OpenAPI (Spri

MySQL查看表的最后一个ID的常见方法

《MySQL查看表的最后一个ID的常见方法》在使用MySQL数据库时,我们经常会遇到需要查看表中最后一个id值的场景,无论是为了调试、数据分析还是其他用途,了解如何快速获取最后一个id都是非常实用的技... 目录背景介绍方法一:使用MAX()函数示例代码解释适用场景方法二:按id降序排序并取第一条示例代码解

使用雪花算法产生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主键数据,当我们