package java.sql

1. DriverManager

1.1. static Connection getConnection(String url, String user, String password)

2. Connection

2.1. Statement createStatement()

2.2. Statement createStatement(int tipo, int concorrência)

2.3. PreparedStatement prepareStatement(String sql)

2.4. PreparedStatement prepareStatement(String sql, int tipo, int concorrência)

2.4.1. tipo

2.4.1.1. TYPE_FORWARD_ONLY

2.4.1.2. TYPE_SCROLL_INSENSITIVE

2.4.1.3. TYPE_SCROLL_SENSITIVE

2.4.2. concorrência

2.4.2.1. CONCUR_READ_ONLY

2.4.2.2. CONCUR_UPDATABLE

2.5. void setAutoCommint(boolean autoCommit)

2.6. void commit()

2.7. void rollback()

2.8. void close()

3. Statement

3.1. ResultSet executeQuery(String sql)

3.2. int executeUpdate(String sql)

3.3. void addBatch(String sql)

3.4. int[] executeBatch()

3.5. void clearBatch()

3.6. void close()

4. SQLException

4.1. String getSQLState

4.2. int getErrorCode

4.3. SQLException getNextException

5. ResultSet

5.1. boolean next()

5.2. Xxx getXxx(int coluna)

5.3. Xxx getXxx(String coluna)

5.4. int findColumn(String coluna)

5.5. void close()

5.6. boolean previous()

5.7. int getRow()

5.8. boolean absolute(int r)

5.9. boolean relative(int d)

5.10. boolean first()

5.11. boolean last()

5.12. boolean beforeFirst()

5.13. boolean afterLast()

5.14. boolean isFirst()

5.15. boolean isLast()

5.16. boolean isBeforeFirst()

5.17. boolean isAfterLast()

5.18. void moveToInsertRow()

5.19. void moveToCurrentRow()

5.20. void insertRow()

5.21. void deleteRow()

5.22. void updateXxx(int coluna, Xxx x)

5.23. void updateXxx(String coluna, Xxx x)

5.24. void updateRow()

5.25. void cancelRowUpdates()

6. PreparedStatement

6.1. void setXxx(int n, Xxx x)

6.2. void clearParameters()

6.3. ResultSet executeQuery()

6.4. int executeUpdate()