owerdto.java

宠物医院

package bean;

import java.sql.*;
import java.util.*;
import java.sql.Statement;

public class OwerDTO {
  private int ID;
  private String name;
  private String address;
  private String city;
  private String telephone;

  JDBCBean jdbc=new JDBCBean();
  private Connection con=jdbc.getCon();
  private PreparedStatement pstm=null;
  Statement s=null;
  private ResultSet rs=null;
  Vector vc=new Vector();
  String sql;
  private String searchType;
  private String keyword;

  public OwerDTO() {
  }

  public void setID(int ID) {
    this.ID = ID;
  }

  public int getID() {
    return ID;
  }

  public void setName(String name) {
    this.name = name;
  }

  public void setAddress(String address) {
    this.address = address;
  }

  public void setCity(String city) {
    this.city = city;
  }

  public void setTelephone(String telephone) {
    this.telephone = telephone;
  }

  public void setSearchType(String searchType) {
    this.searchType = searchType;
  }

  public void setKeyword(String keyword) {
    this.keyword = keyword;
  }

  public String getName() {
    return name;
  }

  public String getAddress() {
    return address;
  }

  public String getCity() {
    return city;
  }

  public String getTelephone() {
    return telephone;
  }

  public String getSearchType() {
    return searchType;
  }

  public String getKeyword() {
    return keyword;
  }

  public boolean add()   //添加客户信息
  {
    try
    {
      sql="insert into owners (name,address,city,telephone) "+
          "values (?,?,?,?)";
      pstm=con.prepareStatement(sql);
      pstm.setString(1,getName());
      pstm.setString(2,getAddress());
      pstm.setString(3,getCity());
      pstm.setString(4,getTelephone());
      pstm.executeUpdate();
      pstm.close();
      sql="select id from owners where name=? and address=? and city=? and telephone=?";
      pstm=con.prepareStatement(sql);
      pstm.setString(1,getName());
      pstm.setString(2,getAddress());
      pstm.setString(3,getCity());
      pstm.setString(4,getTelephone());
      rs=pstm.executeQuery();
      if(rs.next())
      {
        setID(rs.getInt(1)); //设置id的值
        return true;
      }
      pstm.close();
    }
    catch(Exception e)
    {
      e.printStackTrace();
      return false;
    }

    return false;
  }

  public Vector selectAll()
  {
    try
    {
      vc.clear();
      sql="select id, name,address,city,telephone from owners";
      pstm=con.prepareStatement(sql);
      rs=pstm.executeQuery();
      while(rs.next())
      {
        String[] arry=new String[5];
        // arry[0]=rs.getString(1);
        int owerId= rs.getInt(1);
        arry[0]=String.valueOf(owerId);
        arry[1]=rs.getString(2);
        arry[2]=rs.getString(3);
        arry[3]=rs.getString(4);
        arry[4]=rs.getString(5);
        vc.addElement(arry);
      }
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
    return vc;
  }

  public Vector selectOwer()
  {
    try
    {
      String keyWordtemp=getKeyword();
      String searchTypetemp=getSearchType();
      sql="exec proc_selectOwer  '"+searchTypetemp+"','"+keyWordtemp+"'";
      s=con.createStatement();
      rs=s.executeQuery(sql);
      while(rs.next())
      {
        String[] arr2=new String[5];
        int owerid=rs.getInt(1);
        arr2[0]=String.valueOf(owerid);
        arr2[1]=rs.getString(2);
        arr2[2]=rs.getString(3);
        arr2[3]=rs.getString(4);
        arr2[4]=rs.getString(5);
        vc.add(arr2);
      }
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
    return vc;
  }

  public Vector get_OwerName_ID()
  {
    try
    {
      vc.clear();
      sql="select id, name from owners";
      s=con.createStatement();
      rs=s.executeQuery(sql);
      while(rs.next())
      {
        String[] arry3=new String[2];
        int id=rs.getInt(1);
        arry3[0]=String.valueOf(id);
        arry3[1]=rs.getString(2);
        vc.add(arry3);
      }
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
    return vc;
  }

  public Vector search_Ower_Id()
  {
    try
    {
      vc.clear();
      String owerName="%"+getName()+"%";
      int owerId=getID();
      sql="exec proc_Ower_Id '"+owerName+"','"+owerId+"'";
      System.out.println(owerName);
      System.out.println(owerId);
      s=con.createStatement();
      rs=s.executeQuery(sql);
      while(rs.next())
      {
        String[] arr4=new String[2];
        int id=rs.getInt(1);
        System.out.println(id+1);
        arr4[0]=String.valueOf(id);
        System.out.println(arr4[0]+1);
        arr4[1]=rs.getString(2);
        System.out.println(arr4[1]);

        vc.add(arr4);
      }
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
    return vc;
  }
}