sqlframe1.java~1~

Student management system

package student;
import java.sql.*;

class Connectionsql {
    public Connectionsql() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    Connection cn = null;
    String DriverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    String DriverManagerURL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=xxgl";
    String userName = "sa";
    String userpassword ="sa";

    Connection getConnection() throws Exception {
        try {
            Class.forName(DriverName);
            cn = DriverManager.getConnection(DriverManagerURL,userName,userpassword);
        } catch (ClassNotFoundException e) {
            System.err.println("ClassNotFoundException:");
            System.err.println(e.getMessage());
        }
        if (cn == null) {
            System.err.println("Connection failed...");
            System.exit(0);
        }
        return cn;
    }

    private void jbInit() throws Exception {
    }
}