package test;
import javax.swing.*;
import java.sql.*;
import java.awt.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class SearchDB {
    public static Connection link()
    {
        Connection con=null;
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection("jdbc:odbc:Driver={SQL server};server=.;database=test;uid=sa;pwd=sa");
            JOptionPane.showMessageDialog(null,"連接數據庫成功!");
        }
        catch(ClassNotFoundException ce)
        {
            JOptionPane.showMessageDialog(null,ce.getMessage());
        }
        catch(SQLException co)
        {
            JOptionPane.showMessageDialog(null,co.getMessage());
        }
        return con;
    }
}