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

相关文章

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类型每种策略的作

SpringBoot基于MyBatis-Plus实现Lambda Query查询的示例代码

《SpringBoot基于MyBatis-Plus实现LambdaQuery查询的示例代码》MyBatis-Plus是MyBatis的增强工具,简化了数据库操作,并提高了开发效率,它提供了多种查询方... 目录引言基础环境配置依赖配置(Maven)application.yml 配置表结构设计demo_st

ImportError: cannot import name ‘print_log‘ from ‘logging‘

mmcv升级到2.+后删除了很多 解决 查FAQ文档,找到 添加到mmcv.utils下即可

vue 父组件调用子组件的方法报错,“TypeError: Cannot read property ‘subDialogRef‘ of undefined“

vue 父组件调用子组件的方法报错,“TypeError: Cannot read property ‘subDialogRef’ of undefined” 最近用vue做的一个界面,引入了一个子组件,在父组件中调用子组件的方法时,报错提示: [Vue warn]: Error in v-on handler: “TypeError: Cannot read property ‘methods

4-4.Andorid Camera 之简化编码模板(获取摄像头 ID、选择最优预览尺寸)

一、Camera 简化思路 在 Camera 的开发中,其实我们通常只关注打开相机、图像预览和关闭相机,其他的步骤我们不应该花费太多的精力 为此,应该提供一个工具类,它有处理相机的一些基本工具方法,包括获取摄像头 ID、选择最优预览尺寸以及打印相机参数信息 二、Camera 工具类 CameraIdResult.java public class CameraIdResult {