import javax.swing.*;
import java.sql.*;
public class DatabaseCon extends JFrame {
  JTextArea taInfo=new JTextArea();
  public DatabaseCon()   {
    super("連接數(shù)據(jù)庫");
    setSize(200,150);
    this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE );
    this.getContentPane().add(taInfo);
  }
  public void connecion()   {
    try{
      //加載JDBC-ODBC橋驅(qū)動(dòng)程序
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch(ClassNotFoundException ex){
      taInfo.setText(ex.getMessage());
      System.exit(-1);
    }
    try{
      //試圖通過JDBC-ODBC橋建立一個(gè)與學(xué)生信息管理數(shù)據(jù)數(shù)據(jù)源的連接
     String URL = "jdbc:odbc:學(xué)生信息管理";
    Connection con = DriverManager.getConnection(URL);
     if(!con.isClosed()){//判斷數(shù)據(jù)庫連接是否成功
       taInfo.setText("數(shù)據(jù)庫連接成功");
     }
     else{
       taInfo.setText("數(shù)據(jù)庫連接失敗");
     }
     con.close();
    }
    catch(SQLException ex){
      taInfo.setText(ex.getMessage());
    }
  }
  public static void main(String[] args)   {
    DatabaseCon frame = new DatabaseCon();
    frame.show();
    frame.connecion();
  }
 }