vetdto.java

宠物医院

package bean;

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

import ClassType.*;

public class VetDTO {
  private int vetId;
  private int specId;
  private String vetName;
  private String specName;
  private String number;
  private String telephone;
  private String address;
  private String resume;


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


  public VetDTO() {
  }

  public void setVetId(int vetId) {
    this.vetId = vetId;
  }

  public void setSpecId(int specId) {
    this.specId = specId;
  }

  public void setVetName(String vetName) {
    this.vetName = vetName;
  }

  public void setSpecName(String specName) {
    this.specName = specName;
  }

  public void setNumber(String number) {
    this.number = number;
  }

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

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

  public void setResume(String resume) {
    this.resume = resume;
  }

  public int getVetId() {
    return vetId;
  }

  public int getSpecId() {
    return specId;
  }

  public String getVetName() {
    return vetName;
  }

  public String getSpecName() {

    return specName;
  }

  public String getNumber() {
    return number;
  }

  public String getTelephone() {
    return telephone;
  }

  public String getAddress() {
    return address;
  }

  public String getResume() {
    return resume;
  }

  public Vector selectAll()
  {
    try
    {
      vc.clear();  //使得查询结果清空
      sql="select v.number,v.name,s.name from vet_specialties as vs  inner join specialties as s on(vs.specialty_id=s.id) inner join vets as v  on(vs.vet_id=v.id) ";
      pstm=con.prepareStatement(sql);
      rs=pstm.executeQuery();
      while(rs.next())
      {
        String[] arr=new String[3];
        arr[0]=rs.getString(1);
        arr[1]=rs.getString(2);
        arr[2]=rs.getString(3);
        vc.add(arr);  //将信息添加到Vector中
      }
      rs.close();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
    return vc;
  }

  public Vector selectVet()
  {
    try
    {
      String spec="%"+getSpecName()+"%";
      String vet="%"+getVetName()+"%";
      sql="exec  proc_selectvet '"+spec+"','"+vet+"'";
      s=con.createStatement();
      rs=s.executeQuery(sql);
      while(rs.next())
      {
        String[] arr2=new String[4];
        arr2[0]=rs.getString(1);
        arr2[1]=rs.getString(2);
        arr2[2]=rs.getString(3);
        int  spesid=rs.getInt(4);
        arr2[3]=String.valueOf(spesid);
        vc.add(arr2);
      }
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
   return vc;
  }
  public boolean insertVet()   //添加兽医信息与专业
  {
    try
    {
      sql=" exec pro_vetNew  ?,?,?,?,?";
      pstm=con.prepareStatement(sql);
      pstm.setString(1,getVetName());
      pstm.setString(2,getSpecName());
      pstm.setString(3,getTelephone());
      pstm.setString(4,getAddress());
      pstm.setString(5,getResume());
      pstm.executeUpdate();
      return true;
    }
    catch(Exception e)
    {
      e.printStackTrace();
      return false;
    }
  }
  public Vector selectSpesName()  //得到专业名称
  {
    try
    {
      sql="select name from specialties";
      pstm=con.prepareStatement(sql);
      rs=pstm.executeQuery();
      vc.clear();
      while(rs.next())
      {
        vc.addElement(rs.getString(1));
      }

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

  public boolean deleteVet()
  {
    try
    {
      sql="exec proc_delete_vet ?,?,?,?";
      pstm=con.prepareStatement(sql);
      pstm.setString(1,getVetName());
      pstm.setString(2,getNumber());
      pstm.setString(3,getTelephone());
      pstm.setString(4,getAddress());
      pstm.executeUpdate();
    }
    catch(Exception e)
    {
      e.printStackTrace();
      return false;
    }
    return true;
  }
}