DbUtils的使用
时间：2021-07-01 10:21:17
帮助过：11人阅读
public class TestDbUtils {
2
3 @Test
4 /*
5 * 匿名内部类实现
6 */
7 public void test()
throws SQLException {
8 ComboPooledDataSource ds =
new ComboPooledDataSource();
9 QueryRunner runner =
new QueryRunner(ds);
10
11 Person person = runner.query("select * from person where id=?",
new ResultSetHandler<Person>
() {
12
13 @Override
14 public Person handle(ResultSet rs)
throws SQLException {
15 Person p =
null;
16 while(rs.next()) {
17 String name = rs.getString("name"
);
18 int age = rs.getInt("age"
);
19 Date time = rs.getDate("time"
);
20 String address = rs.getString("address"
);
21 p =
new Person(name, age, time, address);
22 }
23 return p;
24 }
25 }, 2
);
26 System.out.println(person);
27 }
28
29 @Test
30 /*
31 * 使用ResultSetHandler接口的实现类
32 */
33 public void test2()
throws SQLException {
34 ComboPooledDataSource ds =
new ComboPooledDataSource();
35 QueryRunner runner =
new QueryRunner(ds);
36
37 Person person = runner.query("select * from person where id=?",
new BeanHandler<Person>(Person.
class), 2
);
38 System.out.println(person);
39 }
40 }
查询多个
1 public class TestDbUtils {
2
3 /*
4 * 使用ResultSetHandler接口的实现类
5 */
6 @Test
7 public void test2() throws SQLException {
8 ComboPooledDataSource ds = new ComboPooledDataSource();
9 QueryRunner runner = new QueryRunner(ds);
10
11 List<Person> list = runner.query("select * from person ", new BeanListHandler<Person>(Person.class));
12 for (Person person : list) {
13 System.out.println(person);
14 }
15 }
16 }
输出
Person [name=smile, age=12, time=2018-03-06 19:32:35.0, address=null]
Person [name=wxf, age=13, time=2018-03-07 19:33:37.0, address=null]
Person [name=smile, age=24, time=1970-01-01 00:00:00.0, address=null]
DbUtils的使用
标签：ora throws public 简单 bean eth out jar包 address
