connection.java

这是一个教学管理代码

package sims;

import java.sql.*;

public class connection
{

    public Connection createConnection()
    {
        try
      {

          String url = "jdbc:odbc:dazuoye";
          String name = "sa";
          String password = "";

          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          Connection con = DriverManager.getConnection(url, name, password);
          return con;
      }
      catch (Exception e)
      {return null;}
    }
    public void close(ResultSet rs,PreparedStatement ptmt,Connection con)
    {
        try {
            rs.close();
            ptmt.close();
            con.close();
        } catch (Exception ee) {}
    }
    public void close(PreparedStatement ptmt ,Connection con)
    {
        try{
            ptmt.close();
            con.close();
        }catch (Exception ee){}
    }
}