package com.qidi;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;
public class DBconnection {
    static String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    static String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=mydata";
    static String user="sa";
    static String password="123456";

    public static Connection getConnection(){
    try {
        Class.forName(driver);
        Connection conn = DriverManager.getConnection(url, user, password);
        System.out.println("數據庫連接成功.........");
        return conn;

    } catch (SQLException ex) {
        ex.printStackTrace();
        return null;
    } catch (ClassNotFoundException ex) {
        ex.printStackTrace();
        return null;
    }

    }
}