jdbc总结8-DBUtils使用初步

下载DBUtilsjar包，到官网下载，然后导包

编码实现

package DBUtils;

import java.sql.Connection;
import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class DBUprim {

	public static void main(String[] args) throws Exception {
//		利用c3p0创建数据库连接池对象
		ComboPooledDataSource cpds=new ComboPooledDataSource("myc3p0");
		System.out.println(cpds);
//		利用数据库连接池对象创建数据库连接
		Connection cnn=cpds.getConnection();
		System.out.println(cnn);
//		创建queryrunner对象
//		QueryRunner对象底层是preparedstatement
		QueryRunner qr=new QueryRunner();
		String sql="insert into student(name,sex,id,age)values(?,?,?,?)";
		Object[] param= {"李四","男","123","17"};
//		执行sql语句
		qr.update(cnn,sql, param);
		DbUtils.closeQuietly(cnn);

	}

}

结果正确