package testsystem;
import java.sql.*;
import javax.swing.*;
import java.awt.*;

public class DBcon {
    public static Connection link()
    {
        Connection con=null;
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection("jdbc:odbc:Driver={SQL server};server=.;database=TestSystem;uid=sa;pwd=8823016");
            //JOptionPane.showMessageDialog(null,"數據庫連接成功！");
        }
        catch(ClassNotFoundException ce)
        {
            JOptionPane.showMessageDialog(null,ce.getMessage());
        }
        catch(SQLException co)
        {
            JOptionPane.showMessageDialog(null,co.getMessage());
        }
        return con;
    }
}