typedao.java

宠物医院 JSP项目 我是一个初学者 请大家多多指教

package da0;

import java.util.*;
import java.sql.*;
import dto.*;
public class Typedao {
    PreparedStatement ps = null;
  ResultSet rs = null;
  Connection con = null;

    public Typedao() {
    }
    public ArrayList search() {
      ArrayList arr = new ArrayList();
      DBcon dbcon = new DBcon();
      try {
          con = dbcon.GetConnection();
          String sql = "select tid,tname from types";

          ps = con.prepareStatement(sql);
          rs = ps.executeQuery();
          while(rs.next()){
             Typedto typedto = new Typedto();
             typedto.setTid(rs.getInt("tid"));
             typedto.setTname(rs.getString("tname"));
             arr.add(typedto);
          }
      } catch (Exception ex) {
          ex.printStackTrace();
      } finally {
          dbcon.CloseRs(rs);
          dbcon.ClosePs(ps);
          dbcon.CloseCon(con);
          return arr;
      }
  }

}