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:
mvnrepository....
System requirements for the JDBC driver:
docs.microsoft...
Using the JDBC driver with Maven Central:
docs.microsoft...
13 окт 2024