Module org.itsallcode.jdbc

module org.itsallcode.jdbc

Simple-JDBC is a wrapper for the JDBC API that simplifies the use of JDBC.

• Create a SimpleConnection
  • ... with a connection factory using DriverManager, see DataSourceConnectionFactory
  • ... with a DataSource, see DataSourceConnectionFactory
  • ... with an existing Connection, see SimpleConnection.wrap(Connection, DbDialect)
• Execute statements
  • ... single statement: DbOperations.executeUpdate(String)
  • ... with a prepared statement and generic parameters: DbOperations.executeUpdate(String, List)
  • ... with a prepared statement and custom parameter setter: DbOperations.executeUpdate(String, org.itsallcode.jdbc.PreparedStatementSetter)
  • ... multiple statements in a batch: DbOperations.statementBatch()
  • ... semicolon separated SQL script: DbOperations.executeScript(String)
• Execute queries
  • ...with generic result types: DbOperations.query(String)
  • ...with a RowMapper, returning custom result types: DbOperations.query(String, org.itsallcode.jdbc.resultset.RowMapper)
  • ...with a prepared statement and generic parameters: DbOperations.query(String, List, org.itsallcode.jdbc.resultset.RowMapper)
  • ...with a prepared statement and custom parameter setter: DbOperations.query(String, org.itsallcode.jdbc.PreparedStatementSetter, org.itsallcode.jdbc.resultset.RowMapper)
• Use transactions:
  • Start a new transaction: SimpleConnection.startTransaction()
  • Use all operations from DbOperations in a transaction
  • Rollback a transaction: Transaction.rollback()
  • Commit a transaction: Transaction.commit()
  • Automatic rollback using try-with-resources if not committed: Transaction.close()
• Batch inserts
  • ... using a Stream or Iterator of row objects: SimpleConnection.preparedStatementBatch(java.lang.Class)
  • ... directly setting values of a PreparedStatement: SimpleConnection.preparedStatementBatch()
• Simplified Exception Handling: converts checked exception SQLException to runtime exception UncheckedSQLException

Packages

Exports

Package	Description
org.itsallcode.jdbc
org.itsallcode.jdbc.batch
org.itsallcode.jdbc.dialect
org.itsallcode.jdbc.identifier
org.itsallcode.jdbc.metadata
org.itsallcode.jdbc.resultset
org.itsallcode.jdbc.resultset.generic