DBUtiles基础

一.DBUtil的介绍

1.DBUtil是apache上的一个开源工具包，对数据库的操作进行了二次封装

2.对于数据表的写操作，也变得很简单(只需写sql语句)

二.使用DBUtil进行增删改查

1.用数据进行增删改查

 1 package com.logos.JDBCUtil;
 2 
 3 import java.sql.ResultSet;
 4 import java.sql.SQLException;
 5 import java.util.List;
 6 
 7 import org.apache.commons.dbutils.QueryRunner;
 8 import org.apache.commons.dbutils.ResultSetHandler;
 9 import org.apache.commons.dbutils.handlers.BeanHandler;
10 import org.apache.commons.dbutils.handlers.BeanListHandler;
11 import org.junit.Test;
12 
13 import com.mchange.v2.c3p0.ComboPooledDataSource;
14 
15 public class JDBCutilDemo {
16     @Test
17     public void JDBCutilDemo() throws SQLException {
18         ComboPooledDataSource dataSource = new ComboPooledDataSource();
19         QueryRunner queryRunner = new QueryRunner(dataSource);
20         //向表中添加数据
21         queryRunner.update("insert into bank1 values(null,?,?)", "abc", 1222);
22         //在表中删除一条数据
23         queryRunner.update("delete from bank1 where id=?", 5);
24         //更改表中ID为2的数据
25         queryRunner.update("update bank1 set money = ? where id = ?", 10000, 2);
26         
27         //查询单个数据，方法一
28         Student account = queryRunner.query("select * from bank1 where id = ?", new ResultSetHandler<Student>() {
29 
30             @Override
31             public Student handle(ResultSet rs) throws SQLException {
32                 xinxi account = new xinxi();
33                 while (rs.next()) {
34                     String name = rs.getString("name");
35                     int money = rs.getInt("money");
36 
37                     account.setName(name);
38                     account.setMoney(money);
39                 }
40                 return account;
41             }
42 
43         }, 4);
44 
45         //查询单个数据，方法二
46         System.out.println(account.toString());
47         Student query = queryRunner.query("select * from bank1 where id = ?", new BeanHandler<xinxi>(Student.class),
48                 6);
49         System.out.println(query.toString());
50 
51         //查询多个数据 用LIST集合
52         List<Student> query1 = queryRunner.query("select * from bank1", new BeanListHandler<xinxi>(Student.class));
53         for (xixi xinxi1 : query1) {
54             System.out.println(xinxi1.toString());
55         }
56 
57     }
58 }

 

2.创建一个bean类，包括name，money类

 1 package com.logos.JDBCUtil;
 2 
 3 public class xinxi {
 4     private String name;
 5     private int money;
 6     public String getName() {
 7         return name;
 8     }
 9     public void setName(String name) {
10         this.name = name;
11     }
12     public int getMoney() {
13         return money;
14     }
15     public void setMoney(int money) {
16         this.money = money;
17     }
18     @Override
19     public String toString() {
20         return "Student [name=" + name + ", money=" + money + "]";
21     }
22     
23 }

 

 

posted @ 2019-07-27 16:37  从X开始  阅读(74)  评论(0)    收藏  举报