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(){
    Class.forName(driver);
    Connection conn=DriverManager.getConnection(url,user,password);
    return conn;
    
    }
}