To connect Java to a relational database with JDBC, add that database vendor’s JDBC driver, obtain a connection using a vendor-specific URL or a configured DataSource, execute SQL, process any results, and close JDBC resources. Use PreparedStatement parameters for changing data values rather than concatenating them into SQL. For a deployed application, Java’s current API identifies DataSource as the preferred connection approach.
How JDBC connects a Java application to a database
JDBC is Java’s standard API for working with data sources. Its core workflow uses a Connection to represent a database connection, a statement object to send SQL, and a ResultSet to read rows returned by a query. The Java API specifies that workflow; the driver and connection configuration come from the database vendor.
Before writing connection code, choose the database and consult its current JDBC driver documentation. You will need a Java SDK, the database or access to a database server, and that vendor’s JDBC driver. Driver coordinates, authentication, TLS, and URL syntax vary, so there is no universal JDBC dependency or connection string. Oracle’s older JDBC tutorial outlines the setup conceptually, but notes that its examples were written for JDK 8 and may omit later improvements: JDBC Basics.
Choose how the application obtains a connection
| Approach | Best fit | Configuration and pooling |
|---|---|---|
DriverManager |
A small introductory program or a simple standalone utility. | The application calls getConnection with connection details. Pooling is not provided merely by choosing this API. |
DataSource |
Deployed applications, especially those managed by a server or framework. | A configured implementation supplies connections; it may provide pooling or distributed-transaction support. Those capabilities depend on the implementation and environment. |
The Java SE 25 DriverManager API calls DataSource the preferred means of connecting to a data source. A basic DataSource need not pool connections; pooling-capable and distributed-transaction implementations are distinct options. Distributed transactions are not required for ordinary work against one database. See the Java SE 25 DriverManager API and Oracle’s DataSource tutorial.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →#1 Best Overall
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
Connect with DriverManager in a small example
The following example uses MySQL Connector/J’s URL pattern solely as an example. The URL is MySQL-specific, not a template to reuse unchanged with another database. Confirm the current syntax, driver dependency, and supported authentication options in the MySQL Connector/J URL documentation.
String url = "jdbc:mysql://db.example.com:3306/appdb";
String user = System.getenv("DB_USER");
String password = System.getenv("DB_PASSWORD");
try (Connection connection = DriverManager.getConnection(url, user, password)) {
// Run database work using this connection.
}Supply credentials through an environment or secrets-management configuration rather than committing them to source control. Avoid embedding secrets in a URL that may be logged. The Java API also documents overloads that accept properties; if a property is specified both in the URL and separately, precedence is implementation-defined. Keep each setting in one place and follow the chosen driver’s guidance.
Rank #2
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
JDBC 4.0 drivers available on the classpath are loaded automatically. Explicitly calling Class.forName is therefore not a required step for a modern JDBC driver, though older drivers may have different requirements. Oracle’s tutorial illustrates MySQL Connector/J’s pattern as jdbc:mysql://[host][:port]/[database]; it cites 127.0.0.1 and 3306 as tutorial defaults, which should not be assumed for every installation or current configuration. See the Oracle connection tutorial.
Run queries with statements and process results
Use Statement for fixed SQL with no changing values. When values vary or a statement may be reused, use PreparedStatement and bind each value with the setter that matches its type. Placeholders represent data values, not SQL structure such as a table name or sort direction.
Rank #3
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
String sql = "SELECT id, name FROM customers WHERE email = ?";
try (Connection connection = DriverManager.getConnection(url, user, password);
PreparedStatement statement = connection.prepareStatement(sql)) {
statement.setString(1, email);
try (ResultSet results = statement.executeQuery()) {
while (results.next()) {
long id = results.getLong("id");
String name = results.getString("name");
System.out.println(id + ": " + name);
}
}
}The question mark is bound to email using the first parameter index, 1. This keeps the supplied value separate from SQL syntax. Oracle’s tutorial explains that prepared statements treat client-supplied data as parameter content rather than part of the SQL statement: Using Prepared Statements.
For a query that changes rows, use an appropriate update method such as executeUpdate; for a query that returns rows, use executeQuery. Let the statement type and execution method match the SQL operation, and inspect the database driver’s documentation for vendor-specific behavior.
Rank #4
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
Close connections, statements, and result sets
Use try-with-resources for JDBC objects that implement AutoCloseable. Each declared resource is closed when its block exits, including when an exception occurs; nested resources close in reverse declaration order. This prevents forgotten statements and result sets from retaining resources. Oracle’s Database 21 JDBC guide warns that failing to close statements and result sets can cause memory leaks or exhaust database cursors: Oracle Database JDBC Developer’s Guide.
Group related changes in a transaction
When several database operations must succeed or fail together, perform them in one transaction. JDBC connections use auto-commit by default in the usual configuration, so disable it before the group of operations, commit only after all succeed, and roll back if an operation fails. Restore the original auto-commit setting if the connection will continue to be used.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Best Value
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
boolean originalAutoCommit = connection.getAutoCommit();
try {
connection.setAutoCommit(false);
// Execute related updates here.
connection.commit();
} catch (SQLException e) {
connection.rollback();
throw e;
} finally {
connection.setAutoCommit(originalAutoCommit);
}In production code, account for failures during rollback or restoring connection state, and ensure the connection is closed or returned to the pool in a known state. The JDBC tutorial’s transaction lesson covers the transaction workflow: Managing Transactions.
Use a DataSource and pooling in deployed applications
In a server-side application, a container, framework, or pooling library commonly configures a DataSource with the driver and connection settings. Application code requests a connection from that source and uses the same statement and resource-management workflow; pooling does not change how SQL parameters work. The pool can reuse connections instead of opening a new physical connection for every database access. Whether pooling is useful, and how it should be sized and configured, depends on workload and hosting setup.
Do not select a pool or distributed-transaction implementation solely because JDBC supports those options. Use the integration already supported by the hosting environment, and consult its documentation for pool lifecycle, timeouts, validation, credentials, and transaction configuration.
