天高任我飞，java的世界里有你有我

在查询数据库中的信息时,可以用很多种封装的方法,如下:

1)vector

dao:

public synchronized Vector returnMoneyAll(String opname,String sql){
 
  Vector list = new Vector();
  ResultSet rs = null;
  ReturnMoneyModel returnMoneyModel = null;
  try{
   open2();
   rs = query(sql);
   while(rs.next()){
    String s = new String(rs.getString("BUSI_NAME").getBytes("iso-8859-1"),"GBK");
       returnMoneyModel = new ReturnMoneyModel();
    returnMoneyModel.setHost_seri(rs.getString("HOST_SERI"));
    returnMoneyModel.setBusi_name(s);
    list.add(returnMoneyModel);
   }
  }catch(Exception ex){
   ex.printStackTrace();
  }finally{
   shutdown();
  }
  
  return list;
  
 }

jsp页面:

<%
  ReturnMoneyModel rmm;
  Vector v = new Vector();
  v = (Vector)session.getAttribute("listReturnMoney");
   if(v!=null){
    java.util.Enumeration e = v.elements();
    while(e.hasMoreElements()){
     rmm = (ReturnMoneyModel)e.nextElement();
  %>

......

<td width="103"><div align="center" class="font3"><%=rmm.getHost_seri()%></div></td>

......

2)ArrayList

dao:

public synchronized ArrayList queryAll() {
        String sql = "select * from MONEY_TYPE_TBL";
        ArrayList list = new ArrayList();
        ResultSet rs = null;
        try {
            open();
            rs = query(sql);
            while (rs.next()) {
             CurrencyModel model=new CurrencyModel();
             model.setMoney_type(rs.getString("MONEY_TYPE"));
             model.setMoney_name(rs.getString("MONEY_NAME"));
             list.add(model);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            shutdown();
        }
        return list;
    }

jsp页面:

<%
ArrayList list=(ArrayList)session.getAttribute("CurrencySel");
if(list!=null)
{  int i=-1;
   Iterator iterator=list.iterator();
     while(iterator.hasNext())
     { 
        CurrencyModel model=(CurrencyModel)iterator.next();
        i+=1;
%>  

......

<td><div align="center"><%= Transform.encoding(model.getMoney_name())%></div></td>

......