Class DatabaseAccessExample

java.lang.Object

DatabaseAccessExample

public class DatabaseAccessExample
extends Object

An example that shows the main JDBC operations, including creation of a connection, use of transactions, and the following database operations: insert, update, delete and select.

Constructor Summary

Constructors

Constructor	Description
DatabaseAccessExample()

Method Summary

Modifier and Type	Method	Description
List<Book>	doTransaction()	Performs a database transaction which includes clearing the book table, reseting the auto-increment primary key sequence of the book table, inserting some books, updating the author of a book, and retrieving the resulting list of books.
private List<Book>	getBooks(Connection connection)	Retrieves all books from the database.
private List<Book>	getBooksToInsert()	Generates a list of books to be inserted in the database.
private void	insertBooks(Connection connection, List<Book> books)	Inserts the specified books into the database.
static void	main(String[] args)	Runs the example.
private void	printBooks(String prefix, List<Book> books)	Prints a list of books by calling Book.toString() on each book and pre-pending the resulting string with the specified prefix.
private void	removeBooks(Connection connection)	Removes all books from the database and resets the auto-increment primary key sequence.
private void	updateBook(Connection connection, Book book)	Updates the book with the ID of the specified book, setting all values to the current values of the specified book.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DatabaseAccessExample

public DatabaseAccessExample()

Method Detail

main

public static void main(String[] args)

Runs the example.

Parameters:

args - not used.

doTransaction

public List<Book> doTransaction()
                         throws SQLException

Performs a database transaction which includes clearing the book table, reseting the auto-increment primary key sequence of the book table, inserting some books, updating the author of a book, and retrieving the resulting list of books.

Returns:

the resulting list of books.

Throws:

SQLException - if an SQL error occurs.

getBooksToInsert

private List<Book> getBooksToInsert()

Generates a list of books to be inserted in the database.

Returns:

the books.

printBooks

private void printBooks(String prefix,
                        List<Book> books)

Prints a list of books by calling Book.toString() on each book and pre-pending the resulting string with the specified prefix. The prefix is useful for indenting the printout of books.

Parameters:

prefix - the prefix inserted before each book in the printout.

books - the books to be printed.

removeBooks

private void removeBooks(Connection connection)
                  throws SQLException

Removes all books from the database and resets the auto-increment primary key sequence.

Parameters:

connection - the connection to be used for this database operation.

Throws:

SQLException - if an SQL error occurs.

insertBooks

private void insertBooks(Connection connection,
                         List<Book> books)
                  throws SQLException

Inserts the specified books into the database.

Parameters:

connection - the connection to be used for this database operation.

books - the books to be inserted.

Throws:

SQLException - if an SQL error occurs.

getBooks

private List<Book> getBooks(Connection connection)
                     throws SQLException

Retrieves all books from the database.

Parameters:

connection - the connection to be used for the database operation.

Returns:

the books.

Throws:

SQLException - if an SQL error occurs.

updateBook

private void updateBook(Connection connection,
                        Book book)
                 throws SQLException

Updates the book with the ID of the specified book, setting all values to the current values of the specified book.

Parameters:

connection - the connection to be used for the database operation.

book - the book to be updated.

Throws:

SQLException - if an SQL error occurs.