vetdao.java

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

package da0;

import java.util.*;
import java.sql.*;
import dto.*;

public class Vetdao {
    PreparedStatement ps = null;
    ResultSet rs = null;
    Connection con = null;

    public Vetdao() {
    }

    public ArrayList search(String name, String speciality) {
        ArrayList arr = new ArrayList();
        DBcon dbcon = new DBcon();
        try {
            con = dbcon.GetConnection();
            String sql = "select vname,sname from view_vets_speci where 1=1";
            if(!name.equals("")){
                sql = sql+" and vname like '%"+name+"%'";
            }
            if(!speciality.equals("")){
                sql = sql+" and sname like '%"+speciality+"%'";
            }
            ps = con.prepareStatement(sql);
            rs = ps.executeQuery();
            while(rs.next()){
                Vetdto vetdto = new Vetdto();

                vetdto.setVname(rs.getString("vname"));
                vetdto.setSname(rs.getString("sname"));
                arr.add(vetdto);
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            dbcon.CloseRs(rs);
            dbcon.ClosePs(ps);
            dbcon.CloseCon(con);
            return arr;
        }
    }
}