Java JDBC Notes (2012.03.06)
JDBC (Java Database Connectivity)
- Java API for database access
- Provides a standard interface regardless of the database
JDBC process:
1. Load driver: Class.forName("driver class name")
2. Get connection: DriverManager.getConnection(url, id, pw)
3. Create statement: conn.createStatement() or conn.prepareStatement(sql)
4. Execute query: stmt.executeQuery(sql) or stmt.executeUpdate(sql)
5. Process results: ResultSet
6. Close resources: close() in reverse order
