pettype.java~6~

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

package gxaccp.t07.guoneng_wei.petclinicmanagesystem.bean;

import java.sql.*;

import java.util.Vector;

import gxaccp.t07.guoneng_wei.jdbc.DataBaseAccess;

public class PetType {
  private String id;
  private String petTypeName;
  public PetType() {
  }

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

  public void setPetTypeName(String petTypeName) {
    this.petTypeName = petTypeName;
  }

  public String getId() {
    return id;
  }

  public String getPetTypeName() {
    return petTypeName;
  }

  public synchronized static Vector getPetType() {
    String select = "SELECT * FROM PetTypeInfo";
    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()) {
        PetType pt = new PetType();
        pt.setId(rs.getString("ID"));
        pt.setTypeName(rs.getString("PetTypeName"));
        v.addElement(pt);
      }
      return v;
    }
    catch (SQLException ex) {
      System.out.println("!!!!!!!!!异常出现在获取宠物类型时的getPetType方法里!!!!!!!!!");
    }
    finally {
      DataBaseAccess.closeResultSet(rs);
      DataBaseAccess.closeStatement(pst);
      DataBaseAccess.closeConnection(con);
    }
    return null;
  }

}