professiontype.java~29~

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

package gxaccp.t07.guoneng_wei.petclinicmanagesystem.beans;

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

import gxaccp.t07.guoneng_wei.jdbc.*;

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

  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("!!!!!!!!!异常出现在获取宠物类型时的getProfessionType方法里!!!!!!!!!");
    }
    finally {
      DataBaseAccess.closeResultSet(rs);
      DataBaseAccess.closeStatement(pst);
      DataBaseAccess.closeConnection(con);
    }
    return null;
  }

  public String getId() {
    return id;
  }

  public String getProfessionName() {
    return professionName;
  }

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

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

  public boolean addNewProfessionType() {
    Connection con = DataBaseAccess.getConnection();
    PreparedStatement pst = null;
    boolean insert = false;
    try {
      pst = con.prepareStatement(
          "INSERT INTO ProfessionType (ProfessionName) VALUES(?)");
      pst.setString(1, this.getProfessionName());
      if (pst.executeUpdate() > 0) {
        insert = true;
      }

    }
    catch (Exception ex) {
      System.out.println("!!!!!!!!!异常出现在获取宠物类型时的addProfessionType方法里!!!!!!!!!");
    }
    finally {

      DataBaseAccess.closeStatement(pst);
      DataBaseAccess.closeConnection(con);
    }
    return insert;
  }

}