1. Driver 2. DriverManager 1. public Connection getConnection(String url, String usn, String pwd) 2. public void registerDriver() 3. public void deregisterDriver() 3. Connection 1. public Statement createStatement(), createStatement(int rt, int rc) 2. public PreparedStatement prepareStatement(String sql), prepareStatement(String sql, int rt, int rc) 3. public CallableStatement callableStatement(String sql), callableStatement(String sql, int rt, int rc) 4. public void setAutoCommit(boolean commit) 5. public void commit() 6. public void rollback() 7. public void close() 4. Statement 1. public boolean execute(String sql) a. public ResultSet getResultSet() b. public int getUpdateCount() 2. public void executeUpdate(String sql) 3. public void executeQuery(String sql) 4. public void addBatch(String sql) 5. public int[] executeBatch() 6. public void clearBatch() 7. public void close() 5. PreparedStatement 1. public void setXxx(int parameterIndex, xxx value) This method is available one per each data type seperatly Ex: public void setInt(int parameterIndex, int value) public void setDouble(int parameterIndex, double value) public void setString(int parameterIndex, String value) 2. public booelan execute() 3. public int executeUpdate() 4. public ResultSet executeQuery() 5. public void addBatch() 6. public void close() 6. ResultSet 1. public boolean next() 2. public xxx getXxx(int columnIndex) or public xxx getXxx(String columnLabel) Ex: public int getInt(int columnIndex) public int getInt(String columnLabel) public String getString(int columnIndex) public String getString(String columnLabel) . . . . 7. ResultSetMetaData 1. public String getColumnName(int columnIndex); 2. public String getColumnLabel(int columnIndex); 3. public int getColumnDisplaySize(int coulumnIndex); 4. public String getColumnTypeName(int columnIndex) public int getColumnType(int columnIndex) In Types class every sql data is mapped with a number Ex: varchr = 12 double = 8 int = 4 ect... getColumnTypeName() returns name of the data type getColumnType() returns value of the dat type 5. public int getColumnCount()