jdbcbean.java~7~

来自「宠物医院」· JAVA~7~ 代码 · 共 41 行

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();

    }


  }
}