dbutils的使用

package erchou;


import java.sql.Connection;
import java.util.ArrayList;
import java.util.List;


import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;


public class Demo {
    public static void main(String[] args) throws Exception{
/*Connection connection = JdbcUtil.getConnection();
String sql = "SELECT *FROM student";
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet result = statement.executeQuery();
while(result.next()){
System.out.println(result.getInt("id")+" "+result.getString("name"));
}
JdbcUtil.close(connection, null);
    DataDemo demoData = new DataDemo();
    demoData.delete(1);*/
    String sql = "SELECT *FROM student";
    QueryRunner runner = new QueryRunner();
    Connection connection = JdbcUtil.getConnection();
   
    List<student> list = runner.query(connection ,sql, new BeanListHandler<student>(student.class));
    //student stu = runner.query(connection, sql, new BeanHandler<student>(student.class),1);
    for(student stu:list){
    System.out.println(stu.toString());
    }
    JdbcUtil.close(connection, null);
   
}
}