professiontype.java~18~

来自「一个基于JAVA的BS结构的宠物诊所管理系统.是当年在学校时写的,大家指点一下.」· JAVA~18~ 代码 · 共 64 行

package gxaccp.t07.guoneng_wei.petclinicmanagesystem.bean;

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

import gxaccp.t07.guoneng_wei.jdbc.*;

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