创建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的话 需要手动关闭
作者:H_Man
链接:https://www.jianshu.com/p/c741095f12c1
來源:简书
简书著作权归作者所有,任何形式的转载都请联系作者获得授权并注明出处。