java执行insert_自定义sql语句执行insert操作

最新推荐文章于 2024-05-11 14:32:00 发布

AA优房-小毛

最新推荐文章于 2024-05-11 14:32:00 发布

阅读量904

点赞数

文章标签： java执行insert

本文链接：https://blog.csdn.net/weixin_34928063/article/details/114766088

版权

做测试，在日志管理SysLogController类中，插入一下代码。

用框架下的函数，构造自定义sql

Sql sql = Sqls.create(

"INSERT INTO dili VALUES (100010045, NULL, 'poiuyt134b01983cc8d9ccffdcaf',('POINT (114.335413649 22.6919839930001)'), " +

"2, NULL, NULL, NULL, NULL, NULL, NULL, TRUE, NULL, NULL, NULL, 114.99867438047818, '支路')");

Sql sqlCallback = sql.setCallback(Sqls.callback.record()); //这句出错了(有时报错有时不报错)

Sql execute = dao.execute(sql);

Object result = sqlCallback.getResult();

报这个错

org.h2.jdbc.JdbcSQLException: Table "NUT_SQL" not found; SQL statement:

INSERT INTO nut_sql(sourceSql,vars,rows,params,callback,varIndex,paramIndex,customValueAdaptor,items,placeholder,sqlType) VALUES(?,?,?,?,?,?,?,?,?,?,?) [42102-197]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)

at org.h2.message.DbException.get(DbException.java:179)

at org.h2.message.DbException.get(DbException.java:155)

at org.h2.command.Parser.readTableOrView(Parser.java:5920)

at org.h2.command.Parser.readTableOrView(Parser.java:5897)

at org.h2.command.Parser.parseInsert(Parser.java:1220)

at org.h2.command.Parser.parsePrepared(Parser.java:431)

at org.h2.command.Parser.parse(Parser.java:335)

at org.h2.command.Parser.parse(Parser.java:307)

at org.h2.command.Parser.prepareCommand(Parser.java:278)

at org.h2.engine.Session.prepareLocal(Session.java:611)

at org.h2.engine.Session.prepareCommand(Session.java:549)

at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1247)

at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:76)

at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:304)

at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:349)

at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:299)

at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)

at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)

at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)

at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)

at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:159)

at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:126)

at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:93)

at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:82)

at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)

at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)

at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:56)

at org.nutz.dao.impl.NutDao.insert(NutDao.java:149)

at cn.wizzer.app.web.modules.controllers.platform.sys.SysLogController.data(SysLogController.java:87)

at cn.wizzer.app.web.modules.controllers.platform.sys.SysLogController$FM$data$50937fad7db7cae8a302fd843c05f99f.invoke(SysLogController.java)

at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)