使用dbutils时insert语句报错

来源:互联网 发布:淘宝实名认证用银行卡 编辑:程序博客网 时间:2024/05/01 02:54

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: []

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

0 0
原创粉丝点击