javaEE连接SQL server2005采用dbutils插入时报错

最新推荐文章于 2022-12-19 16:30:21 发布

dhzbkj

最新推荐文章于 2022-12-19 16:30:21 发布

阅读量242

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/dhzbkj/article/details/80577909

版权

数据库专栏收录该内容

12 篇文章 0 订阅

订阅专栏

在尝试使用DBUtils和JavaEE进行SQL Server数据插入时，遇到了'WHERE'关键字附近语法错误的问题。错误源于SQL语句中缺少了空格，正确的语句应为`insert into category (id,name,description) values (?,?,?)`。修复此问题后，代码在MySQL中运行正常，但对于Oracle数据库的行为未验证。" 104129707,9275706,使用createinstallmedia命令创建MAC OS纯净安装U盘,"['macos', 'mac', 'boot', '系统安装', '终端命令']

摘要由CSDN通过智能技术生成

原代码：
import org.apache.commons.dbutils.QueryRunner;

public class CategoryDaoImpl implements CategoryDao {

public void add(Category c){

try {

Connection conn=JdbcUtils.getConnection();

QueryRunner runner=new QueryRunner();

String sql=" insert into category(id,name,description)values (?,?,?)";

String params[]={c.getId(),c.getName(),c.getDescription()};

runner.update(conn, sql, params);

} catch (Exception e) {

throw new RuntimeException(e);

}

}
出现以下错误：

java.lang.RuntimeException: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: 关键字 'WHERE' 附近有语法错误。 Query: insert into category(id,name,description)values (?,?,?) Parameters: [3, vb开发类, 有价值vb的书籍]

at cn.itcast.dao.impl.CategoryDaoImpl.add(CategoryDaoImpl.java:32)

at cn.itcast.test.CategoryTest.testcategory(CategoryTest.java:19)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)

at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)

at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)

at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)

at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)

at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)

at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)

at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)

at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)

at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)

at org.junit.runners.ParentRunner.run(ParentRunner.java:236)

at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)

at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

Caused by: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: 关键字 'WHERE' 附近有语法错误。 Query: insert into category(id,name,description)values (?,?,?) Parameters: [3, vb开发类, 有价值vb的书籍]

at org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:540)

at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:597)

at cn.itcast.dao.impl.CategoryDaoImpl.add(CategoryDaoImpl.java:28)

... 24 more

解决：String sql=" insert into category(id,name,description) values(?,?,?)";改为category后面加空格，values后面加空格。
String sql="insert into category (id,name,description) values (?,?,?)";
但采用mysql数据却不需要，oracle没用过，不知道会怎样