使用dbutils时insert语句报错

最新推荐文章于 2022-07-22 20:25:10 发布

abc45628

最新推荐文章于 2022-07-22 20:25:10 发布

阅读量2.5k

点赞数

分类专栏： dbutils

本文链接：https://blog.youkuaiyun.com/abc45628/article/details/46403463

版权

dbutils 专栏收录该内容

2 篇文章

订阅专栏

String registSQL = "INSERT INTO manager ( username , password , phone ) VALUES ( '112' , '121' , '121' )";
Connection connection = DbConnection.getConnection();
QueryRunner runner = new QueryRunner();
int count = runner.update(connection, registSQL);
connection.close();

报错信息

Exception in thread "main" java.sql.SQLException: Wrong number of parameters: expected 3, was given 0 Query: INSERT INTO manager ( username , password , phone ) VALUES ( '112' , '121' , '121' ) Parameters: []

无语至极，只能用?代替值