professiontype.java~17~

一个基于JAVA的BS结构的宠物诊所管理系统.是当年在学校时写的,大家指点一下.

package gxaccp.t07.guoneng_wei.petclinicmanagesystem.bean;

import java.io.*;
import java.util.Vector;
import gxaccp.t07.guoneng_wei.jdbc.DataBaseAccess;
import java.sql.*;

public class ProfessionType implements Serializable {
  private String professionName="";
  private String id="";
  public ProfessionType() {
  }

  public void setProfessionName(String professionName) {
    if(professionName!=null){
      this.professionName = professionName;
    }
  }

  public void setId(String id) {
    if (id!=null) {
      this.id = id;
    }
  }

  public String getProfessionName() {
    return professionName;
  }

  public String getId() {
    return id;
  }

  public static Vector getProfessionTypes() {
    String select = "SELECT * FROM ProfessionType";
    Connection con =DataBaseAccess.getConnection();
    PreparedStatement pst = null;
    ResultSet rs = null;
    try {
      Vector v = new Vector();
      pst=con.prepareStatement(select);
      rs=pst.executeQuery();
      while (rs.next()) {
        ProfessionType pft = new  ProfessionType();
        pft.setId(rs.getString("ID"));
        pft.setProfessionName(rs.getString("ProfessionName"));
        v.addElement(pft);
      }
      return v;
    }
    catch (Exception ex) {
      System.out.println("!!!!!!!!!异常出现在获取宠物类型时的getPetType方法里!!!!!!!!!");
    }
    finally {
      DataBaseAccess.closeResultSet(rs);
      DataBaseAccess.closeStatement(pst);
      DataBaseAccess.closeConnection(con);
    }
    return null;
  }
}