Richie's Blog 心情车站

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBConnection {
    public static Connection getConnection() {
        String drivrename = “com.microsoft.sqlserver.jdbc.SQLServerDriver”;
        String dabaseurl = “jdbc:sqlserver://localhost:1433;DatabaseName=yourdb”;
        String dbUser = “sa”;
        String dbPassword = “”;
        Connection con = null;

        try {
            Class.forName(drivrename);
            con = DriverManager.getConnection(dabaseurl, dbUser, dbPassword);
            return con;
        } catch (java.lang.ClassNotFoundException e) {
            System.err.println(e);
        } catch (SQLException er) {
            System.err.println(er.getMessage());
        }

        return null;
    }

}