pettype.java~14~

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

package gxaccp.t07.guoneng_wei.petclinicmanagesystem.beans;

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

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class PetType
    implements Serializable {
  private String id="";//宠物类型编号
  private String petTypeName="";//宠物类型名
  public PetType() {
  }

  public String getId() {
    return id;
  }

  public String getPetTypeName() {
    return petTypeName;
  }

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

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

  public 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.setPetTypeName(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;
  }

}