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/com.microsoft.sqlserver/mssql-jdbc

System requirements for the JDBC driver:
https://docs.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver?view=sql-server-ver15

Using the JDBC driver with Maven Central:
https://docs.microsoft.com/vi-vn/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-201 #using-the-jdbc-driver-with-maven-central