JavaBeginner#jdbc

What is JDBC and what are its main components?

Java Database Connectivity is an API for connecting Java applications to relational databases. Key components: DriverManager (obtains connections), Connection (session with the DB), Statement/PreparedStatement (executes SQL), and ResultSet (holds query results).

Example
Connection conn = DriverManager.getConnection(url, user, pass);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM users");

Related Questions

1
JavaBeginner#jdbc

What is the difference between Statement and PreparedStatement?

Open
2
JavaIntermediate#jdbc

What is a CallableStatement used for?

Open
3
JavaIntermediate#jdbc

What is connection pooling and why is it important?

Open