ownersdao.java~1~

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

package da0;

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

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

    public Ownersdao() {
    }

    public ArrayList search() {
        ArrayList arr = new ArrayList();
        DBcon dbcon = new DBcon();
        try {
            con = dbcon.GetConnection();
            String sql = "select oid,oname from owners";

            ps = con.prepareStatement(sql);
            rs = ps.executeQuery();
            while (rs.next()) {
                Ownersdto ownersdto = new Ownersdto();
                ownersdto.setOid(rs.getInt("oid"));
                ownersdto.setOname(rs.getString("oname"));
                arr.add(ownersdto);
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            dbcon.CloseRs(rs);
            dbcon.ClosePs(ps);
            dbcon.CloseCon(con);
            return arr;
        }
    }

    public Ownersdto search(int oid) {
         Ownersdto ownersdto = new Ownersdto();
        DBcon dbcon = new DBcon();
        try {
            con = dbcon.GetConnection();
            String sql = "select * from owners where oid =?";
             ps = con.prepareStatement(sql);
            ps.setInt(1, oid);

            rs = ps.executeQuery();
           if(rs.next()) {

                ownersdto.setOid(rs.getInt("oid"));
                 ownersdto.setOname(rs.getString("oname"));
                ownersdto.setOaddress(rs.getString("oaddress"));

                ownersdto.setOcity(rs.getString("ocity"));
                ownersdto.setOtelephone(rs.getString("otelephone"));

            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            dbcon.CloseRs(rs);
            dbcon.ClosePs(ps);
            dbcon.CloseCon(con);
            return ownersdto;
        }
    }

    public boolean UpdateOwners(int oid, String name, String address,
                                String city, String telephone) {
        boolean flag = false;
        DBcon dbcon = new DBcon();
        try {
            con = dbcon.GetConnection();
            String sql =
                    "update owners set oname=?,oaddress=?,ocity=?,otelephone=? where oid=?";
            ps = con.prepareStatement(sql);
            ps.setString(1, name);
            ps.setString(2, address);
            ps.setString(3, city);
            ps.setString(4, telephone);
            ps.setInt(5, oid);

          int i = ps.executeUpdate();
            if(i>0){
                flag=true;
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            dbcon.CloseRs(rs);
            dbcon.ClosePs(ps);
            dbcon.CloseCon(con);
            return flag;
        }
    }
}