- Java Connect to Microsoft SQL Server Example
- 1. Download Microsoft JDBC driver for SQL server
- 2. JDBC database URL for SQL Server
- 3. Register JDBC driver for SQL Server and establish connection
- 4. Java Code Example to connect to SQL Server
- JDBC API References:
- Related JDBC Tutorials:
- About the Author:
- Download Microsoft JDBC Driver for SQL Server
- Download
- Version information
- Available languages
- Release notes
- Previous releases
- Using the JDBC driver with Maven Central
- Unsupported drivers
- Next steps
- Feedback
- Скачивание драйвера Microsoft JDBC Driver for SQL Server
- Скачивание
- Сведения о версии
- Доступные языки
- Заметки о выпуске
- Предыдущие выпуски
- Использование JDBC Driver с Maven Central
- Неподдерживаемые драйверы
- Дальнейшие действия
Java Connect to Microsoft SQL Server Example
This JDBC tutorial helps you understand how to get JDBC driver and write code for making database connection to Microsoft SQL Server from a Java client. Suppose you have a light weight version of SQL Server installed, such as Microsoft SQL Server Express.
Table of content:
1. Download Microsoft JDBC driver for SQL server
To enable a Java program connects to Microsoft SQL Server database, we need to have a suitable JDBC driver present in the classpath. Click here to download the latest version of Microsoft JDBC Driver for SQL Server. Currently, the latest version is Microsoft JDBC driver 8.2 which supports Java 8, 11 and 13.
Extract the downloaded archive file, and put the mssql-jdbc-8.2.0.jreVERSION.jar to your project’s classpath. If you use Maven, then declare the following dependency:
com.microsoft.sqlserver mssql-jdbc 8.2.1.jre11
2. JDBC database URL for SQL Server
jdbc:sqlserver:// [serverName[\instanceName][:portNumber]][;property=value[;property=value]]
-
- serverName : host name or IP address of the machine on which SQL server is running.
- instanceName : name of the instance to connect to on serverName . The default instance is used if this parameter is not specified.
- portNumber : port number of SQL server, default is 1433. If this parameter is missing, the default port is used.
- property=value : specify one or more additional connection properties. To see the properties specific to SQL server, visit Setting the Connection Properties.
-
- Windows authentication: using current Windows user account to log on SQL Server. This mode is for the case both the client and the SQL server are running on the same machine. We specify this mode by adding the property integratedSecurity=true to the URL.
- SQL Server authentication: using a SQL Server account to authenticate. We have to specify username and password explicitly for this mode.
— Connect to default instance of SQL server running on the same machine as the JDBC client, using Windows authentication:
jdbc:sqlserver://localhost;integratedSecurity=true;
— Connect to an instance named sqlexpress on the host dbServer , using SQL Server authentication:
jdbc:sqlserver://dbHost\sqlexpress;user=sa;password=secret
— Connect to a named database testdb on localhost using Windows authentication:
jdbc:sqlserver://localhost:1433;databaseName=testdb;integratedSecurity=true;
3. Register JDBC driver for SQL Server and establish connection
The JDBC driver class of SQL Server is com.microsoft.sqlserver.jdbc.SQLServerDriver , so to register this driver, use the following statement:
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
However, that is not required since JDBC 4.0 (JDK 6.0) because the driver manager can detect and load the driver class automatically as long as a suitable JDBC driver present in the classpath.
To make a connection, call the method getConnection() of the DriverManager class. Here is a code snippet that connects the user sa with password secret to the instance sqlexpress on localhost :
String dbURL = «jdbc:sqlserver://localhost\\sqlexpress;user=sa;password=secret»; Connection conn = DriverManager.getConnection(dbURL); if (conn != null)
String dbURL = "jdbc:sqlserver://localhost\\sqlexpress"; String user = "sa"; String pass = "secret"; conn = DriverManager.getConnection(dbURL, user, pass);
We can also use a java.util.Properties object to store connection properties, as in the following example:
String dbURL = "jdbc:sqlserver://localhost\\sqlexpress"; Properties properties = new Properties(); properties.put("user", "sa"); properties.put("password", "secret"); conn = DriverManager.getConnection(dbURL, properties);
NOTE: if you want to use Windows authentication mode ( integratedSecurity=true ), you must have the sqljdbc_auth.dll in the classpath.
4. Java Code Example to connect to SQL Server
To demonstrate, we create a small program that connects to an SQL Server instance on localhost and print out some database information as follows:
package net.codejava.jdbc; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.SQLException; /** * This program demonstrates how to establish database connection to Microsoft * SQL Server. * @author www.codejava.net * */ public class JdbcSQLServerConnection < public static void main(String[] args) < Connection conn = null; try < String dbURL = "jdbc:sqlserver://localhost\\sqlexpress"; String user = "sa"; String pass = "secret"; conn = DriverManager.getConnection(dbURL, user, pass); if (conn != null) < DatabaseMetaData dm = (DatabaseMetaData) conn.getMetaData(); System.out.println("Driver name: " + dm.getDriverName()); System.out.println("Driver version: " + dm.getDriverVersion()); System.out.println("Product name: " + dm.getDatabaseProductName()); System.out.println("Product version: " + dm.getDatabaseProductVersion()); >> catch (SQLException ex) < ex.printStackTrace(); >finally < try < if (conn != null && !conn.isClosed()) < conn.close(); >> catch (SQLException ex) < ex.printStackTrace(); >> > >
Driver name: Microsoft JDBC Driver 8.2 for SQL Server Driver version: 8.2.0.0 Product name: Microsoft SQL Server Product version: 15.00.2000
That’s some Java code example to establish database connection to Microsoft SQL Server. For a video guide, you can watch the following video:
JDBC API References:
Related JDBC Tutorials:
About the Author:
Nam Ha Minh is certified Java programmer (SCJP and SCWCD). He started programming with Java in the time of Java 1.4 and has been falling in love with Java since then. Make friend with him on Facebook and watch his Java videos you YouTube.
Download Microsoft JDBC Driver for SQL Server
The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available on the Java platform. The driver downloads are available to all users at no extra charge. They provide access to SQL Server from any Java application, application server, or Java-enabled applet.
Download
Version 12.2 is the latest general availability (GA) version. It supports Java 8, 11, 17, and 19. If you need to use an older Java runtime, see the Java and JDBC specification support matrix to see if there’s a supported driver version you can use. We’re continually improving Java connectivity support. As such we highly recommend that you work with the latest version of Microsoft JDBC driver.
Version information
When you download the driver, there are multiple JAR files. The name of the JAR file indicates the version of Java that it supports.
If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please select Read in English at the top of this page. You can download different languages from the US-English version site by selecting available languages.
Available languages
This release of Microsoft JDBC Driver for SQL Server is available in the following languages:
Release notes
For details about this release, see the release notes and system requirements.
Previous releases
Using the JDBC driver with Maven Central
The JDBC driver can be added to a Maven project by adding it as a dependency in the POM.xml file with the following code:
com.microsoft.sqlserver mssql-jdbc 12.2.0.jre11 Unsupported drivers
Unsupported driver versions aren’t available for download here. We’re continually improving the Java connectivity support. As such we highly recommend that you work with the latest version of Microsoft JDBC driver.
Next steps
For more information about the Microsoft JDBC Driver for SQL Server, see Overview of the JDBC driver and the JDBC driver GitHub repository.
Feedback
Submit and view feedback for
Скачивание драйвера Microsoft JDBC Driver for SQL Server
Microsoft JDBC Driver for SQL Server — это драйвер JDBC типа 4, который обеспечивает обмен данными с базами данных через стандартные API-интерфейсы JDBC, доступные на платформе Java. Все пользователи могут скачать драйвер без дополнительной оплаты. Они предоставляют доступ к SQL Server из любого приложения Java, сервера приложений Java или приложения с поддержкой Java.
Скачивание
Версия 12.2 является последней общедоступной версией. Он поддерживает Java 8, 11, 17 и 19. Если вам нужно использовать среду выполнения Java более ранней версии, ознакомьтесь с таблицей поддержки спецификаций Java и JDBC, чтобы узнать, можете ли вы использовать поддерживаемую версию. Мы постоянно работаем над улучшением поддержки возможностей подключения Java. Настоятельно рекомендуем использовать последнюю версию драйвера Microsoft JDBC.
Сведения о версии
При скачивании драйвера вы увидите несколько JAR-файлов. Имя каждого JAR-файла обозначает поддерживаемую версию Java.
Если вы открываете локализованную версию этой страницы и хотите просмотреть наиболее актуальное содержимое, выберите элемент Прочитать на английском в верхней части этой страницы. С версии сайта US-English вы можете скачать SSMS на других языках из числа доступных.
Доступные языки
Этот выпуск драйвера Microsoft JDBC Driver for SQL Server доступен на следующих языках:
Заметки о выпуске
Дополнительные сведения об этом выпуске см. в заметках о выпуске и требованиях к системе.
Предыдущие выпуски
Использование JDBC Driver с Maven Central
JDBC Driver можно включить в проект Maven, добавив его в качестве зависимости в файл POM.xml с помощью следующего кода:
com.microsoft.sqlserver mssql-jdbc 12.2.0.jre11 Неподдерживаемые драйверы
Скачивание неподдерживаемых версий драйверов здесь недоступно. Мы постоянно работаем над улучшением поддержки возможностей подключения Java. Настоятельно рекомендуем использовать последнюю версию драйвера Microsoft JDBC.
Дальнейшие действия
Дополнительные сведения о драйвере Microsoft JDBC для SQL Server см. в статье Общие сведения о JDBC Driver и в репозитории JDBC Driver на сайте GitHub.