1、需要下载 commons-dbutils.jar
2、pom.xml的内容增加如下
<dependency>
<groupId>commons-dbutils</groupId>
<artifactId>commons-dbutils</artifactId>
<version>1.4</version>
</dependency>
3、insert 测试样例如下
package com.pp.db;
import com.pp.util.JdbcUtil;
import org.apache.commons.dbutils.QueryRunner;
import java.sql.Connection;
import java.sql.SQLException;
public class Dbs {
public static void main(String[] args) throws SQLException {
QueryRunner qr = new QueryRunner();
String sql="insert into t1 values(?,?,?,?,?)";
Connection connection= JdbcUtil.getCconnection();
Object[] objects={7,"如家",24,96,85};
int update=qr.update(connection,sql,objects);
System.out.println(update);
}
}