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

相关文章

SQLServer中生成雪花ID(Snowflake ID)的实现方法

《SQLServer中生成雪花ID(SnowflakeID)的实现方法》:本文主要介绍在SQLServer中生成雪花ID(SnowflakeID)的实现方法,文中通过示例代码介绍的非常详细,... 目录前言认识雪花ID雪花ID的核心特点雪花ID的结构(64位)雪花ID的优势雪花ID的局限性雪花ID的应用场景

python生成随机唯一id的几种实现方法

《python生成随机唯一id的几种实现方法》在Python中生成随机唯一ID有多种方法,根据不同的需求场景可以选择最适合的方案,文中通过示例代码介绍的非常详细,需要的朋友们下面随着小编来一起学习学习... 目录方法 1:使用 UUID 模块(推荐)方法 2:使用 Secrets 模块(安全敏感场景)方法

mybatis执行insert返回id实现详解

《mybatis执行insert返回id实现详解》MyBatis插入操作默认返回受影响行数,需通过useGeneratedKeys+keyProperty或selectKey获取主键ID,确保主键为自... 目录 两种方式获取自增 ID:1. ​​useGeneratedKeys+keyProperty(推

C++中NULL与nullptr的区别小结

《C++中NULL与nullptr的区别小结》本文介绍了C++编程中NULL与nullptr的区别,文中通过示例代码介绍的非常详细,对大家的学习或者工作具有一定的参考学习价值,需要的朋友们下面随着小编... 目录C++98空值——NULLC++11空值——nullptr区别对比示例 C++98空值——NUL

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(一万条数