ownersdao.java

宠物医院 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 AddOwners(String name, String address,
                             String city, String telephone) {
        boolean flag = false;
        DBcon dbcon = new DBcon();
        try {
            con = dbcon.GetConnection();
            String sql =
                    "insert into owners(oname,oaddress,ocity,otelephone) values(?,?,?,?)";
            ps = con.prepareStatement(sql);
            ps.setString(1, name);
            ps.setString(2, address);
            ps.setString(3, city);
            ps.setString(4, telephone);

            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;
        }
    }
    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;
            }
        }

}