DBUtils是怎么样关闭数据库连接的，什么时候自动关闭，什么时候需要人为关闭

创建QueryRunner时传入对象是dataSource的

// Create a QueryRunner that will use connections from// the given DataSourceQueryRunnerrun=newQueryRunner(dataSource);

// Execute the query and get the results back from the handler

Object[]result=run.query("SELECT * FROM Person WHERE name=?",h,"John Doe");

 

 

创建QR对象时没有传入参数

Notice that you are responsible for closing the Connection in this example

注意，在这个示例中，您将负责关闭连接

ResultSetHandler h = ... // Define a handler the same as above example

// No DataSource so we must handle Connections manually

QueryRunner run = new QueryRunner();

Connection conn = ... // open a connection

try{

Object[] result = run.query(

conn, "SELECT*FROMPersonWHEREname=?", h, "John Doe");

// do something with the result

} finally {

// Use this helper method so we don't have to check for null

//这时需要我们手动来关闭

DbUtils.close(conn);

}

 

得出结论,DBUtils在创建QueryRunner时传入dataSource对象每次在执行完之后都会自动关闭Connection连接对象~所以再也不用担心没有关闭对象而导致的问题了~

如果没有传入dataSource的话  需要手动关闭