dbcon.java

这个是学生考试系统,里面有完整的代码加数据库SQL server

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=sa");
            //JOptionPane.showMessageDialog(null,"数据库连接成功！");
        }
        catch(ClassNotFoundException ce)
        {
            JOptionPane.showMessageDialog(null,ce.getMessage());
        }
        catch(SQLException co)
        {
            JOptionPane.showMessageDialog(null,co.getMessage());
        }
        return con;
    }
}