java项目,使用dbutils进行添加数据,在runner后面获取连接池报错...

发布网友发布时间：2024-03-29 09:43

共1个回答

热心网友时间：2024-07-24 15:39

private static void update() throws SQLException{
QueryRunner runner = new QueryRunner();
Connection conn = DBManager.getConnection();
String sql = "UPDATE test SET xxx = ? WHERE xxx = ?";
Object [] params = new Object[]{"xxx", 111};

runner.update(conn, sql, params);
}

private static void insert() throws SQLException{
QueryRunner runner = new QueryRunner();
Connection conn = DBManager.getConnection();
String sql = "INSERT INTO xxx";
Object [] params = new Object[]{xxx,xxx};
runner.update(conn, sql, params);
}
参考这样写

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com