Hackforge Academy

Explanation

JDBC is used to establish a connection
between a Java application and a database.

Code:

Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/testdb",
"root","password");

Explanation

Statement interface is used to execute simple SQL queries.

Code:

Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM users");

Explanation

ResultSet is used to retrieve data returned from a query.

Code:

while(rs.next()){
  System.out.println(rs.getString("name"));
}

Explanation

JDBC Driver must be loaded before
establishing connection (older versions).

Code:

Class.forName("com.mysql.cj.jdbc.Driver");

Explanation

Connection should be closed to release database resources.

Code:

con.close();