sqlframe1.java

Java学生管理系统学生及成绩记录的查询删除修改

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 ="";
    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 {
    }
}