commonajdbc.java

来自「该代码是一个关于学生成绩管理系统的源代码」· Java 代码 · 共 33 行

package appstu.util;
import java.sql.Connection;
import java.sql.DriverManager;
public class CommonaJdbc {
    public static Connection conection = null;
    public CommonaJdbc(){
        getCon();

    }
    private Connection getCon(){
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
           conection = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=DB_Student ","sa","");
  //           conection = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.1.43:1433;DatabaseName=DB_Student ","sa","");
      System.out.println("数据库操作成功，祝贺你");

        }catch(java.lang.ClassNotFoundException classnotfound){
            classnotfound.printStackTrace();
        }catch(java.sql.SQLException sql){
            new appstu.view.JF_view_error(sql.getMessage());
            sql.printStackTrace();
        }
        return conection;
    }
//    private void closeCon(){
//    	try {
//    		conection.close();
//		} catch (Exception e) {
//			// TODO: handle exception
//		}
//    }
}