package bean;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class JDBCBean {
  private Connection con=null;
  public JDBCBean() {
  }
  public Connection getCon()
  {
    try
    {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con=DriverManager.getConnection("jdbc:odbc:Pet","sa","");
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
    return this.con;
  }

  //關閉數據庫連接
  public void closeAll(PreparedStatement pstm,ResultSet rs)
  {
    try
    {
      pstm.close();
      rs.close();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }
}