Java JDBC connect SQL Server 2019 in Netbeans IDE (Full Tutorial 2021)

Java JDBC connect SQL Server 2019 in Netbeans IDE (Full Tutorial 2021)

Code in Video:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
*
* @author DELL
*/
public class BDConnection {
   
   public static void main(String[] args,int a) throws ClassNotFoundException, SQLException{
      String hostname = "localhost";
           String sqlInstanceName = " "; //computer name
           String sqlDatabase = " ";  //sql server database name
           String sqlUser = "sa";
           String sqlPassword = " "; //passwrod sa account

           Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

           //jdbc:sqlserver://localhost:1433;instance=COMPUTERBERRY;databaseName=Database;
           String connectURL = "jdbc:sqlserver://" + hostname + ":1433"
                   + ";instance=" + sqlInstanceName + ";databaseName=" + sqlDatabase;

           Connection conn = DriverManager.getConnection(connectURL, sqlUser, sqlPassword);
           System.out.println("Connect to database successful!!");
   }
   
}


Web mvnrepository JDBC Library:
https://mvnrepository.com/artifact/co...

System requirements for the JDBC driver:
https://docs.microsoft.com/en-us/sql/...

Using the JDBC driver with Maven Central:
https://docs.microsoft.com/vi-vn/sql/...