//获取链接
Connection connect=OracleDriverUtil.getConnect();
//准备sql
String sql=“select * from ban_account”;
//转载sql
PreparedStatement ps=connect.prepareStatement(sql);
//执行
ResultSet result=ps.executeQuery();
//收参
BankAccount bankAccount=null;
while (result.next()) {
int id=result.getInt(1);
String num=result.getString(“num”);
Double balbance=result.getDouble(“balance”);
Date date=result.getDate(“create_date”);
bankAccount=new BankAccount(id,num,balbance,date);
banklist.add(bankAccount);
}
//关闭流
OracleDriverUtil.flowClose(connect,ps,result);
return banklist;