第十七天dbutils的使用------CommonsDbUtils(Apache)第三方的:只是对JDBC编码进行了简单的封装 - 数据库编程

所实现的功能差不多。这是第三方开发的，要导入相应的jar包(就一个jar包)，比自己写的强大。强大之处在于结果集的处理。主要涉及的类是

org.apache.commons.dbutils
Class QueryRunner

API如下：

Constructor Summary
QueryRunner() Constructor for QueryRunner.
QueryRunner(boolean pmdKnownBroken) Constructor for QueryRunner, allows workaround for Oracle drivers
QueryRunner(DataSource ds) Constructor for QueryRunner which takes a DataSource.
QueryRunner(DataSource ds, boolean pmdKnownBroken) Constructor for QueryRunner, allows workaround for Oracle drivers.

Method Summary

int[] batch(Connection conn, String sql, Object[][] params)
Execute a batch of SQL INSERT, UPDATE, or DELETE queries.

int[] batch(String sql, Object[][] params)
Execute a batch of SQL INSERT, UPDATE, or DELETE queries.

query(Connection conn, String sql, Object[] params, ResultSetHandler rsh)
Deprecated. Use query(Connection,String,ResultSetHandler,Object...) instead

query(Connection conn, String sql, Object param, ResultSetHandler rsh)
Deprecated. Use query(Connection, String, ResultSetHandler, Object...)

query(Connection conn, String sql, ResultSetHandler rsh)
Execute an SQL SELECT query without any replacement parameters.

query(Connection conn, String sql, ResultSetHandler rsh, Object... params)
Execute an SQL SELECT query with replacement parameters.

query(String sql, Object[] params, ResultSetHandler rsh)
Deprecated. Use query(String, ResultSetHandler, Object...)

query(String sql, Object param, ResultSetHandler rsh)
Deprecated. Use query(String, ResultSetHandler, Object...)

query(String sql, ResultSetHandler rsh)
Executes the given SELECT SQL without any replacement parameters.

query(String sql, ResultSetHandler rsh, Object... params)
Executes the given SELECT SQL query and returns a result object.

int update(Connection conn, String sql)
Execute an SQL INSERT, UPDATE, or DELETE query without replacement parameters.

int update(Connection conn, String sql, Object... params)
Execute an SQL INSERT, UPDATE, or DELETE query.

int update(Connection conn, String sql, Object param)
Execute an SQL INSERT, UPDATE, or DELETE query with a single replacement parameter.

int update(String sql)
Executes the given INSERT, UPDATE, or DELETE SQL statement without any replacement parameters.

int update(String sql, Object... params)
Executes the given INSERT, UPDATE, or DELETE SQL statement.

int update(String sql, Object param)
Executes the given INSERT, UPDATE, or DELETE SQL statement with a single replacement parameter.

一、框架编写准备：数据库元数据的获取
1、元数据：数据库、表、列的定义信息
二、编写自己的框架简化JDBC开发

CUD：语句不同和参数不同。

三、ORM：
O：Object
R：Relation
M：Mapping
对象关系映射

JavaBean 关系数据库表结构：对应的映射关系

Hibernate：ORM映射框架 -----》规范化：JPA（Java Persistent API)
IBatis(Apache):ORM映射框架----------->2010(google) MyBatis
Commons DbUtils(Apache):只是对JDBC编码进行了简单的封装。
Spring JDBC Template:只是对JDBC编码进行了简单的封装。

例子：不用自己关闭资源，底层源代码已经关了，而且是结合dbcp使用的，关闭不是真的关闭，而是加入到连接池中，以后就放心使用，一句话解决crud操作。

//账户维护
public class DBUtilDemo {
	private QueryRunner qr = new QueryRunner(DBCPUtil.getDataSource());
	@Test
	public void testAdd() throws Exception{
		qr.update("insert into account(name,money) values( , )", "fff",1000);
	}
	@Test
	public void testFindOne() throws Exception{
		Account a = qr.query("select * from a

第十七天dbutils的使用------CommonsDbUtils(Apache)第三方的:只是对JDBC编码进行了简单的封装(一)