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
Видео Java JDBC connect SQL Server 2019 in Netbeans IDE (Full Tutorial 2021) автора Java Исследовательский Центр
Видео Java JDBC connect SQL Server 2019 in Netbeans IDE (Full Tutorial 2021) автора Java Исследовательский Центр
Информация
4 декабря 2023 г. 21:09:08
00:18:13
Похожие видео