dbutils連接配接mysql_Dbutils 連接配接資料庫

用了JDBC後接着學習Dbutils連接配接資料庫

1.添加驅動包

Class.forName("oracle.jdbc.driver.OracleDriver");

2.擷取資料庫連接配接

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@fwwb-439:1521:home", "scott", "tiger");

3.DButils連接配接

QueryRunner runner = new QueryRunner();

4.執行SQL

List list = runner.query(conn,"select * from emp",new BeanListHandler(Emp.class));

循環周遊

for(int i=0;i

Emp emp = list.get(i);

System.out.println(emp.getEmpno()+","+emp.getEname()+","+emp.getJob()+","+emp.getSal());

}