JDBC Database Connectivity
Java Database Connectivity
Connect Java applications to relational databases.
JDBC Example
import java.sql.*;
// Connection
String url = "jdbc:mysql://localhost:3306/mydb";
Connection conn = DriverManager.getConnection(url, "user", "pass");
// PreparedStatement
PreparedStatement ps = conn.prepareStatement("SELECT * FROM users WHERE id = ?");
ps.setInt(1, 123);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
String name = rs.getString("name");
}Key Points
- Load driver:
Class.forName("com.mysql.jdbc.Driver"). - Connection, Statement, PreparedStatement, ResultSet.
- Prevent SQL injection with PreparedStatement.
- Connection pooling for performance.