今天早上在写代码时忽然想起昨天写的关于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的话 需要手动关闭