Chapter 13: Database Programming using JDBC – Exam Revision Notes
1. Introduction 2. JDBC Architecture Component Purpose DriverManager Manages database drivers Connection Represents a connection to the database Statement Used to execute SQL queries ResultSet Holds data returned from queries 3. Steps to Connect Database Class.forName(“com.mysql.cj.jdbc.Driver”); Connection con = DriverManager.getConnection(“jdbc:mysql://localhost:3306/dbname”,”user”,”password”); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(“SELECT * FROM Students”); while(rs.next()) { System.out.println(rs.getString(“name”) +…