Initial commit of code.

15 files changed, 2083 insertions, 0 deletions

diff --git a/src/com/joshwalters/bookcatalog/AddBook.java b/src/com/joshwalters/bookcatalog/AddBook.java
new file mode 100644
index 0000000..05b227c
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/AddBook.java
@@ -0,0 +1,123 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog;
+
+import java.awt.event.ActionEvent;
+import java.awt.event.ActionListener;
+import java.sql.SQLException;
+
+import javax.swing.JTable;
+import javax.swing.JTextField;
+
+import com.joshwalters.bookcatalog.bookdatabase.BookAlreadyInDatabase;
+import com.joshwalters.bookcatalog.bookdatabase.BookDatabase;
+import com.joshwalters.bookcatalog.bookdatabase.EmptyDatabase;
+import com.joshwalters.bookcatalog.isbnlookup.ISBNLookup;
+import com.joshwalters.bookcatalog.isbnlookup.InvalidSearchTerms;
+import com.joshwalters.bookcatalog.isbnlookup.NoBookFound;
+import com.joshwalters.bookcatalog.sound.PlayWavSoundFile;
+import com.joshwalters.bookcatalog.table.BookCatalogTableModel;
+
+/**
+ * Adds a book to the book database using an ISBN number.
+ * 
+ * @author Josh Walters
+ */
+class AddBook implements ActionListener {
+
+	private ISBNLookup bookLookup = null;
+	private BookDatabase bookDatabase = null;
+	private JTable bookCatalogTable = null;
+
+	/**
+	 * Get the different objects needed for the class to function.
+	 * 
+	 * @param bookDatabase
+	 * @param bookLookup
+	 * @param bookCatalogTable
+	 */
+	public AddBook(BookDatabase bookDatabase, ISBNLookup bookLookup,
+			JTable bookCatalogTable) {
+		this.bookDatabase = bookDatabase;
+		this.bookLookup = bookLookup;
+		this.bookCatalogTable = bookCatalogTable;
+	}
+
+	/**
+	 * Add the book to the database using its ISBN number.
+	 */
+	public void actionPerformed(ActionEvent arg) {
+		try {
+			String barcode = null;
+			JTextField addBookField = (JTextField) arg.getSource();
+			barcode = addBookField.getText();
+			addBookField.setText("");
+			// Search for the book using its barcode.
+			bookLookup.searchBooks(barcode);
+			// Insert the book into the database.
+			bookDatabase.insertBook(bookLookup.getTitle(), bookLookup
+					.getAuthor(), bookLookup.getDate(), bookLookup
+					.getDescription(), bookLookup.getISBN(), bookLookup
+					.getPrice(), bookLookup.getPublisher(), bookLookup
+					.getSubject());
+			// Play the beep sound to alert the user that the book was added to
+			// the database.
+			new PlayWavSoundFile("data/sounds/beep.wav").start();
+			try {
+				// Get the table model of the table.
+				BookCatalogTableModel bookCatalogTableModel = (BookCatalogTableModel) bookCatalogTable
+						.getModel();
+				// Update the data in the table with the new book.
+				bookCatalogTableModel.setData(bookDatabase
+						.getDatabaseForTable());
+				// Refresh the table to draw the new info.
+				bookCatalogTableModel.fireTableDataChanged();
+			} catch (EmptyDatabase e) {
+				// The database was empty, print an error message.
+				System.err.println(e.getLocalizedMessage());
+			}
+			// The following code selects the newly added row.
+			int row = bookCatalogTable.getRowCount() - 1;
+			int col = 4;
+			// Search for the row, and then select it.
+			for (int i = 0; i <= row; i++) {
+				String value = (String) bookCatalogTable.getValueAt(i, col);
+				if (value.equalsIgnoreCase(bookLookup.getISBN())) {
+					bookCatalogTable.setRowSelectionInterval(i, i);
+				}
+			}
+		} catch (SQLException e) {
+			// There was an SQL error of some sort.
+			System.err.println(e.getLocalizedMessage());
+		} catch (NoBookFound e) {
+			// The book data was not found online, play the error sound.
+			new PlayWavSoundFile("data/sounds/error.wav").start();
+		} catch (BookAlreadyInDatabase e) {
+			// The book was already in the error database, play the error sound.
+			new PlayWavSoundFile("data/sounds/beep.wav").start();
+		} catch (InvalidSearchTerms e) {
+			// Invalid search terms, play the error sound.
+			new PlayWavSoundFile("data/sounds/error.wav").start();
+		}
+	}
+}
diff --git a/src/com/joshwalters/bookcatalog/ApplyChanges.java b/src/com/joshwalters/bookcatalog/ApplyChanges.java
new file mode 100644
index 0000000..445d89c
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/ApplyChanges.java
@@ -0,0 +1,116 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog;
+
+import java.awt.event.ActionEvent;
+import java.awt.event.ActionListener;
+import java.sql.SQLException;
+
+import javax.swing.JTable;
+import javax.swing.JTextArea;
+import javax.swing.JTextField;
+
+import com.joshwalters.bookcatalog.bookdatabase.BookDatabase;
+import com.joshwalters.bookcatalog.bookdatabase.EmptyDatabase;
+import com.joshwalters.bookcatalog.table.BookCatalogTableModel;
+
+/**
+ * Updates a book's entry in the database.
+ * 
+ * @author Josh Walters
+ */
+class ApplyChanges implements ActionListener {
+
+	private JTable bookCatalogTable;
+	private BookDatabase bookDatabase;
+	private JTextField titleField;
+	private JTextField authorField;
+	private JTextField dateField;
+	private JTextArea descriptionArea;
+	private JTextField ISBNField;
+	private JTextField priceField;
+	private JTextField publisherField;
+	private JTextField subjectField;
+	private JTextArea notesArea;
+
+	/**
+	 * Get the different objects needed for the class to function.
+	 * 
+	 * @param bookCatalogTable
+	 * @param bookDatabase
+	 * @param titleField
+	 * @param authorField
+	 * @param dateField
+	 * @param descriptionArea
+	 * @param ISBNField
+	 * @param priceField
+	 * @param publisherField
+	 * @param subjectField
+	 * @param notesArea
+	 */
+	ApplyChanges(JTable bookCatalogTable, BookDatabase bookDatabase,
+			JTextField titleField, JTextField authorField,
+			JTextField dateField, JTextArea descriptionArea,
+			JTextField ISBNField, JTextField priceField,
+			JTextField publisherField, JTextField subjectField,
+			JTextArea notesArea) {
+		this.bookCatalogTable = bookCatalogTable;
+		this.bookDatabase = bookDatabase;
+		this.titleField = titleField;
+		this.authorField = authorField;
+		this.dateField = dateField;
+		this.descriptionArea = descriptionArea;
+		this.ISBNField = ISBNField;
+		this.priceField = priceField;
+		this.publisherField = publisherField;
+		this.subjectField = subjectField;
+		this.notesArea = notesArea;
+	}
+
+	/**
+	 * The user hit the "Apply Changes" button, update the book entry.
+	 */
+	public void actionPerformed(ActionEvent arg) {
+		try {
+			// Update the book entry.
+			bookDatabase.updateBook(titleField.getText(),
+					authorField.getText(), dateField.getText(), descriptionArea
+							.getText(), ISBNField.getText(), priceField
+							.getText(), publisherField.getText(), subjectField
+							.getText(), notesArea.getText());
+			// Get the table model.
+			BookCatalogTableModel bookCatalogTableModel = (BookCatalogTableModel) bookCatalogTable
+					.getModel();
+			// Update the table's data.
+			bookCatalogTableModel.setData(bookDatabase.getDatabaseForTable());
+			// Refresh the table.
+			bookCatalogTableModel.fireTableDataChanged();
+		} catch (SQLException e) {
+			// There was an SQL error.
+			System.err.println(e.getLocalizedMessage());
+		} catch (EmptyDatabase e) {
+			// The database was empty.
+			System.err.println(e.getLocalizedMessage());
+		}
+	}
+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/BookCatalog.java b/src/com/joshwalters/bookcatalog/BookCatalog.java
new file mode 100644
index 0000000..17aed55
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/BookCatalog.java
@@ -0,0 +1,457 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog;
+
+import java.awt.Dimension;
+import java.awt.GridBagConstraints;
+import java.awt.GridBagLayout;
+import java.awt.Insets;
+import java.awt.Rectangle;
+import java.sql.SQLException;
+import java.util.Comparator;
+
+import javax.swing.JButton;
+import javax.swing.JFrame;
+import javax.swing.JLabel;
+import javax.swing.JScrollPane;
+import javax.swing.JTable;
+import javax.swing.JTextArea;
+import javax.swing.JTextField;
+import javax.swing.ListSelectionModel;
+import javax.swing.UIManager;
+import javax.swing.event.ListSelectionEvent;
+import javax.swing.event.ListSelectionListener;
+import javax.swing.table.TableModel;
+import javax.swing.table.TableRowSorter;
+
+import com.joshwalters.bookcatalog.bookdatabase.BookDatabase;
+import com.joshwalters.bookcatalog.isbnlookup.GDataISBNLookup;
+import com.joshwalters.bookcatalog.isbnlookup.ISBNLookup;
+import com.joshwalters.bookcatalog.table.BookCatalogTableModel;
+
+/**
+ * Catalogs and organizes your book collection.
+ * 
+ * @author Josh Walters
+ */
+public class BookCatalog {
+
+	/**
+	 * Performs book lookups using ISBN numbers.
+	 */
+	private ISBNLookup bookLookup = null;
+	/**
+	 * Stores the users book catalog.
+	 */
+	private BookDatabase bookDatabase = null;
+	/**
+	 * Allows user to search book catalog.
+	 */
+	private JTextField searchField;
+	/**
+	 * Allows user to add book to catalog.
+	 */
+	private JTextField addBookField;
+	/**
+	 * Displays the book catalog.
+	 */
+	// private JTable bookCatalogTable;
+	private JTable bookCatalogTable;
+	/**
+	 * Used for managing the book catalog table.
+	 */
+	private BookCatalogTableModel bookCatalogTableModel;
+	/**
+	 * Displays the title of a book.
+	 */
+	private JTextField titleField;
+	/**
+	 * Displays the author of a book.
+	 */
+	private JTextField authorField;
+	/**
+	 * Displays the publish date of a book.
+	 */
+	private JTextField dateField;
+	/**
+	 * Displays the description of a book.
+	 */
+	private JTextArea descriptionArea;
+	/**
+	 * Displays the ISBN number of a book.
+	 */
+	private JTextField ISBNField;
+	/**
+	 * Displays the price of a book.
+	 */
+	private JTextField priceField;
+	/**
+	 * Displays the publisher of a book.
+	 */
+	private JTextField publisherField;
+	/**
+	 * Displays the subject of a book.
+	 */
+	private JTextField subjectField;
+	/**
+	 * Displays the notes on a book.
+	 */
+	private JTextArea notesArea;
+	/**
+	 * Stores the width of the different text fields/areas.
+	 */
+	private static final int FIELD_WIDTH = 20;
+	/**
+	 * Stores the height of the text areas.
+	 */
+	private static final int FIELD_HEIGHT = 5;
+
+	/**
+	 * Sets up all the GUI components of the program.
+	 */
+	BookCatalog() {
+		// Setup the book lookup.
+		bookLookup = new GDataISBNLookup();
+		// Setup the book database.
+		bookDatabase = new BookDatabase();
+		try {
+			// Connect to the book database.
+			bookDatabase.connectToDatabase();
+		} catch (SQLException e) {
+			// There was an SQL error of some sort.
+			System.err.println(e.getLocalizedMessage());
+		} catch (ClassNotFoundException e) {
+			System.err.println(e.getLocalizedMessage());
+		}
+		// Create the window and its label.
+		JFrame frame = new JFrame("Book Catalog");
+		// Exit the window on close.
+		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
+		// Set the L&F to Nimbus if possible.
+		SetLookAndFeel();
+		// Set the layout.
+		frame.setLayout(new GridBagLayout());
+		// The constraints.
+		GridBagConstraints gridConstraints = new GridBagConstraints();
+		// The search label.
+		JLabel searchLabel = new JLabel("Search");
+		gridConstraints.gridx = 0;
+		gridConstraints.gridy = 0;
+		gridConstraints.insets.top = 10;
+		gridConstraints.insets.left = 20;
+		frame.add(searchLabel, gridConstraints);
+		// The search text field
+		searchField = new JTextField(FIELD_WIDTH);
+		gridConstraints.gridx = 1;
+		gridConstraints.gridy = 0;
+		gridConstraints.insets.top = 10;
+		gridConstraints.insets.left = 10;
+		frame.add(searchField, gridConstraints);
+		// The add book label
+		JLabel addBookLabel = new JLabel("Add Book");
+		gridConstraints.gridx = 2;
+		gridConstraints.gridy = 0;
+		gridConstraints.insets.top = 10;
+		gridConstraints.insets.left = 60;
+		frame.add(addBookLabel, gridConstraints);
+		// The add book field
+		addBookField = new JTextField(FIELD_WIDTH);
+		gridConstraints.gridx = 3;
+		gridConstraints.gridy = 0;
+		gridConstraints.insets.top = 10;
+		gridConstraints.insets.left = 10;
+		gridConstraints.fill = GridBagConstraints.REMAINDER;
+		gridConstraints.anchor = GridBagConstraints.WEST;
+		frame.add(addBookField, gridConstraints);
+		// Change the grid constraints back to their the normal state.
+		gridConstraints.fill = GridBagConstraints.NONE;
+		gridConstraints.anchor = GridBagConstraints.CENTER;
+		gridConstraints.insets = new Insets(10, 10, 10, 10);
+		// The book catalog table.
+		bookCatalogTableModel = new BookCatalogTableModel(bookDatabase);
+		bookCatalogTable = new JTable(bookCatalogTableModel);
+		setupTable();
+		gridConstraints.gridx = 0;
+		gridConstraints.gridy = 1;
+		gridConstraints.gridwidth = 4;
+		gridConstraints.gridheight = 10;
+		gridConstraints.weightx = 1;
+		gridConstraints.weighty = 1;
+		gridConstraints.fill = GridBagConstraints.BOTH;
+		// The scroll panel will store the book catalog table.
+		JScrollPane scrollPaneForCatalog = new JScrollPane(bookCatalogTable);
+		// Add the scroll panel with the table to the frame.
+		frame.add(scrollPaneForCatalog, gridConstraints);
+		// Change the grid constraints back to their the normal state.
+		gridConstraints.gridwidth = 1;
+		gridConstraints.gridheight = 1;
+		gridConstraints.weightx = 0;
+		gridConstraints.weighty = 0;
+		gridConstraints.fill = GridBagConstraints.NONE;
+		// The title label
+		JLabel titleLabel = new JLabel("Title");
+		gridConstraints.gridx = 5;
+		gridConstraints.gridy = 1;
+		frame.add(titleLabel, gridConstraints);
+		// The title field
+		titleField = new JTextField(FIELD_WIDTH);
+		gridConstraints.gridx = 6;
+		gridConstraints.gridy = 1;
+		frame.add(titleField, gridConstraints);
+		// The author label
+		JLabel authorLabel = new JLabel("Author");
+		gridConstraints.gridx = 5;
+		gridConstraints.gridy = 2;
+		frame.add(authorLabel, gridConstraints);
+		// The author field
+		authorField = new JTextField(FIELD_WIDTH);
+		gridConstraints.gridx = 6;
+		gridConstraints.gridy = 2;
+		frame.add(authorField, gridConstraints);
+		// The date label
+		JLabel dateLabel = new JLabel("Date");
+		gridConstraints.gridx = 5;
+		gridConstraints.gridy = 3;
+		frame.add(dateLabel, gridConstraints);
+		// The date field
+		dateField = new JTextField(FIELD_WIDTH);
+		gridConstraints.gridx = 6;
+		gridConstraints.gridy = 3;
+		frame.add(dateField, gridConstraints);
+		// The description label
+		JLabel descriptionLabel = new JLabel("Description");
+		gridConstraints.gridx = 5;
+		gridConstraints.gridy = 4;
+		frame.add(descriptionLabel, gridConstraints);
+		// The date field
+		descriptionArea = new JTextArea(FIELD_HEIGHT, FIELD_WIDTH);
+		descriptionArea.setLineWrap(true);
+		descriptionArea.setWrapStyleWord(true);
+		gridConstraints.gridx = 6;
+		gridConstraints.gridy = 4;
+		JScrollPane scrollPaneForDescriptionArea = new JScrollPane(
+				descriptionArea);
+		frame.add(scrollPaneForDescriptionArea, gridConstraints);
+		// The ISBN label
+		JLabel ISBNLabel = new JLabel("ISBN");
+		gridConstraints.gridx = 5;
+		gridConstraints.gridy = 5;
+		frame.add(ISBNLabel, gridConstraints);
+		// The ISBN field
+		ISBNField = new JTextField(FIELD_WIDTH);
+		ISBNField.setEnabled(false);
+		gridConstraints.gridx = 6;
+		gridConstraints.gridy = 5;
+		frame.add(ISBNField, gridConstraints);
+		// The price label
+		JLabel priceLabel = new JLabel("Price");
+		gridConstraints.gridx = 5;
+		gridConstraints.gridy = 6;
+		frame.add(priceLabel, gridConstraints);
+		// The price field
+		priceField = new JTextField(FIELD_WIDTH);
+		gridConstraints.gridx = 6;
+		gridConstraints.gridy = 6;
+		frame.add(priceField, gridConstraints);
+		// The publisher label
+		JLabel publisherLabel = new JLabel("Publisher");
+		gridConstraints.gridx = 5;
+		gridConstraints.gridy = 7;
+		frame.add(publisherLabel, gridConstraints);
+		// The publisher field
+		publisherField = new JTextField(FIELD_WIDTH);
+		gridConstraints.gridx = 6;
+		gridConstraints.gridy = 7;
+		frame.add(publisherField, gridConstraints);
+		// The subject label
+		JLabel subjectLabel = new JLabel("Subject");
+		gridConstraints.gridx = 5;
+		gridConstraints.gridy = 8;
+		frame.add(subjectLabel, gridConstraints);
+		// The subject field
+		subjectField = new JTextField(FIELD_WIDTH);
+		gridConstraints.gridx = 6;
+		gridConstraints.gridy = 8;
+		frame.add(subjectField, gridConstraints);
+		// The notes label
+		JLabel ratingLabel = new JLabel("Notes");
+		gridConstraints.gridx = 5;
+		gridConstraints.gridy = 9;
+		frame.add(ratingLabel, gridConstraints);
+		// The notes field
+		notesArea = new JTextArea(FIELD_HEIGHT, FIELD_WIDTH);
+		gridConstraints.gridx = 6;
+		gridConstraints.gridy = 9;
+		JScrollPane scrollPaneForNotesArea = new JScrollPane(notesArea);
+		frame.add(scrollPaneForNotesArea, gridConstraints);
+		// Listens for search database input.
+		SearchDatabase searchDatabase = new SearchDatabase(bookCatalogTable,
+				bookDatabase, searchField);
+		searchField.getDocument().addDocumentListener(searchDatabase);
+		// The apply changes button
+		JButton applyChangesButton = new JButton("Apply Changes");
+		gridConstraints.gridx = 5;
+		gridConstraints.gridy = 10;
+		gridConstraints.anchor = GridBagConstraints.NORTH;
+		frame.add(applyChangesButton, gridConstraints);
+		// The delete book button
+		JButton deleteBookButton = new JButton("Delete Book");
+		gridConstraints.gridx = 6;
+		gridConstraints.gridy = 10;
+		gridConstraints.anchor = GridBagConstraints.NORTH;
+		frame.add(deleteBookButton, gridConstraints);
+		// Listens for add book input.
+		addBookField.addActionListener(new AddBook(bookDatabase, bookLookup,
+				bookCatalogTable));
+		// Listens for delete book button press.
+		deleteBookButton.addActionListener(new DeleteBook(bookDatabase,
+				titleField, authorField, dateField, descriptionArea, ISBNField,
+				priceField, publisherField, subjectField, notesArea,
+				searchDatabase));
+		// Listens for apply changes button press.
+		applyChangesButton.addActionListener(new ApplyChanges(bookCatalogTable,
+				bookDatabase, titleField, authorField, dateField,
+				descriptionArea, ISBNField, priceField, publisherField,
+				subjectField, notesArea));
+		// Set the frame size.
+		frame.pack();
+		// Set minimum size for the frame.
+		Rectangle rect = frame.getBounds();
+		frame.setMinimumSize(new Dimension(rect.width, rect.height));
+		// Center the frame.
+		frame.setLocationRelativeTo(null);
+		// Show the frame.
+		frame.setVisible(true);
+	}
+
+	/**
+	 * Sets up the table.
+	 */
+	private void setupTable() {
+		// Make the table fill the scroll pane.
+		bookCatalogTable.setFillsViewportHeight(true);
+		// Don't show the grid.
+		bookCatalogTable.setShowGrid(false);
+		// Disable focus so that there wont be cell selection box highlights.
+		bookCatalogTable.setFocusable(false);
+		// Only allow one row at a time to be selected.
+		bookCatalogTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
+		// Prevent reordering of the table headers.
+		bookCatalogTable.getTableHeader().setReorderingAllowed(false);
+		// Auto sort the rows if the user clicks on the headers.
+		bookCatalogTable.setAutoCreateRowSorter(true);
+		// Create a new table sorter object.
+		TableRowSorter<TableModel> sorter = new TableRowSorter<TableModel>(
+				bookCatalogTable.getModel());
+		// Set the table to use this new sorter object.
+		bookCatalogTable.setRowSorter(sorter);
+		/*
+		 * Set the comparator for the 5th column (the price column) to handle
+		 * money correctly.
+		 */
+		sorter.setComparator(5, new Comparator<String>() {
+
+			public int compare(String s1, String s2) {
+				// Strip the '$' from both of the strings.
+				s1 = s1.replaceFirst("\\$", "");
+				s2 = s2.replaceFirst("\\$", "");
+				Double one = new Double(s1);
+				Double two = new Double(s2);
+				return one.compareTo(two);
+			}
+		});
+		// Listens for table row selections.
+		ListSelectionModel listSelection = bookCatalogTable.getSelectionModel();
+		// Add the new listener.
+		listSelection.addListSelectionListener(new ListSelectionListener() {
+
+			public void valueChanged(ListSelectionEvent arg0) {
+				int selectedRow = bookCatalogTable.getSelectedRow();
+				if (selectedRow != -1) {
+					/*
+					 * Place the data in the selected row to the corresponding
+					 * text area/field. Also move the caret to the front of the
+					 * text element.
+					 */
+					titleField.setText((String) bookCatalogTable.getValueAt(
+							selectedRow, 0));
+					titleField.setCaretPosition(0);
+					;
+					authorField.setText((String) bookCatalogTable.getValueAt(
+							selectedRow, 1));
+					authorField.setCaretPosition(0);
+					dateField.setText((String) bookCatalogTable.getValueAt(
+							selectedRow, 2));
+					dateField.setCaretPosition(0);
+					descriptionArea.setText((String) bookCatalogTable
+							.getValueAt(selectedRow, 3));
+					descriptionArea.setCaretPosition(0);
+					ISBNField.setText((String) bookCatalogTable.getValueAt(
+							selectedRow, 4));
+					ISBNField.setCaretPosition(0);
+					priceField.setText((String) bookCatalogTable.getValueAt(
+							selectedRow, 5));
+					priceField.setCaretPosition(0);
+					publisherField.setText((String) bookCatalogTable
+							.getValueAt(selectedRow, 6));
+					publisherField.setCaretPosition(0);
+					subjectField.setText((String) bookCatalogTable.getValueAt(
+							selectedRow, 7));
+					subjectField.setCaretPosition(0);
+					notesArea.setText((String) bookCatalogTable.getValueAt(
+							selectedRow, 8));
+					notesArea.setCaretPosition(0);
+				}
+			}
+		});
+	}
+
+	/**
+	 * Disconnect from the database upon GC.
+	 */
+	protected void finalize() {
+		bookDatabase.disconnectFromDatabase();
+	}
+
+	/**
+	 * Set the look and feel of the Swing GUI to Nimbus if possible.
+	 */
+	private void SetLookAndFeel() {
+		try {
+			// UIManager.getSystemLookAndFeelClassName()
+			UIManager
+					.setLookAndFeel("com.sun.java.swing.plaf.nimbus.NimbusLookAndFeel");
+		} catch (Exception e) {
+			// Do nothing. Just use the standard L&F.
+		}
+	}
+
+	/**
+	 * Run the program.
+	 * 
+	 * @param args
+	 */
+	public static void main(String args[]) {
+		new BookCatalog();
+	}
+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/DeleteBook.java b/src/com/joshwalters/bookcatalog/DeleteBook.java
new file mode 100644
index 0000000..7f0bffc
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/DeleteBook.java
@@ -0,0 +1,120 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog;
+
+import java.awt.event.ActionEvent;
+import java.awt.event.ActionListener;
+import java.sql.SQLException;
+
+import javax.swing.JOptionPane;
+import javax.swing.JTextArea;
+import javax.swing.JTextField;
+
+import com.joshwalters.bookcatalog.bookdatabase.BookDatabase;
+
+/**
+ * Deletes a book from the database.
+ * 
+ * @author Josh Walters
+ */
+public class DeleteBook implements ActionListener {
+
+	private BookDatabase bookDatabase;
+	private JTextField titleField;
+	private JTextField authorField;
+	private JTextField dateField;
+	private JTextArea descriptionArea;
+	private JTextField ISBNField;
+	private JTextField priceField;
+	private JTextField publisherField;
+	private JTextField subjectField;
+	private JTextArea notesArea;
+	private SearchDatabase searchDatabase;
+
+	/**
+	 * Get the different objects needed for the class to function.
+	 * 
+	 * @param bookDatabase
+	 * @param titleField
+	 * @param authorField
+	 * @param dateField
+	 * @param descriptionArea
+	 * @param ISBNField
+	 * @param priceField
+	 * @param publisherField
+	 * @param subjectField
+	 * @param notesArea
+	 * @param searchDatabase
+	 */
+	public DeleteBook(BookDatabase bookDatabase, JTextField titleField,
+			JTextField authorField, JTextField dateField,
+			JTextArea descriptionArea, JTextField ISBNField,
+			JTextField priceField, JTextField publisherField,
+			JTextField subjectField, JTextArea notesArea,
+			SearchDatabase searchDatabase) {
+		this.bookDatabase = bookDatabase;
+		this.titleField = titleField;
+		this.authorField = authorField;
+		this.dateField = dateField;
+		this.descriptionArea = descriptionArea;
+		this.ISBNField = ISBNField;
+		this.priceField = priceField;
+		this.publisherField = publisherField;
+		this.subjectField = subjectField;
+		this.notesArea = notesArea;
+		this.searchDatabase = searchDatabase;
+	}
+
+	/**
+	 * The user clicked on the "Delete Book" button. Remove the book from the
+	 * database.
+	 */
+	public void actionPerformed(ActionEvent arg) {
+		try {
+			// Check if the user really wants to delete the book.
+			int result = JOptionPane.showConfirmDialog(null,
+					"Do you really want to delete \"" + titleField.getText()
+							+ "\" from your catalog?", "Warning",
+					JOptionPane.YES_NO_OPTION);
+			if (result == JOptionPane.YES_OPTION) {
+				// Delete the book using its ISBN number.
+				bookDatabase.deleteBook(ISBNField.getText());
+				// Update the table.
+				searchDatabase.updateTableWithSearchString();
+				// Clear all the text fields/areas.
+				titleField.setText("");
+				authorField.setText("");
+				dateField.setText("");
+				descriptionArea.setText("");
+				ISBNField.setText("");
+				priceField.setText("");
+				publisherField.setText("");
+				subjectField.setText("");
+				notesArea.setText("");
+			}
+		} catch (SQLException e) {
+			// There was an SQL exception.
+			System.err.println(e.getLocalizedMessage());
+		}
+	}
+}
diff --git a/src/com/joshwalters/bookcatalog/SearchDatabase.java b/src/com/joshwalters/bookcatalog/SearchDatabase.java
new file mode 100644
index 0000000..ffe68f0
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/SearchDatabase.java
@@ -0,0 +1,112 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog;
+
+import java.sql.SQLException;
+
+import javax.swing.JTable;
+import javax.swing.JTextField;
+import javax.swing.event.DocumentEvent;
+import javax.swing.event.DocumentListener;
+
+import com.joshwalters.bookcatalog.bookdatabase.BookDatabase;
+import com.joshwalters.bookcatalog.bookdatabase.EmptyDatabase;
+import com.joshwalters.bookcatalog.table.BookCatalogTableModel;
+
+/**
+ * Searches the database for books. s
+ * 
+ * @author Josh Walters
+ */
+class SearchDatabase implements DocumentListener {
+
+	private JTable bookCatalogTable;
+	private BookDatabase bookDatabase;
+	private JTextField searchField;
+
+	/**
+	 * Get the different objects needed for the class to function.
+	 * 
+	 * @param bookCatalogTable
+	 * @param bookDatabase
+	 * @param searchField
+	 */
+	public SearchDatabase(JTable bookCatalogTable, BookDatabase bookDatabase,
+			JTextField searchField) {
+		this.bookCatalogTable = bookCatalogTable;
+		this.bookDatabase = bookDatabase;
+		this.searchField = searchField;
+	}
+
+	/**
+	 * Updates the table with the search string given by the user.
+	 */
+	public void updateTableWithSearchString() {
+		try {
+			// Get the table model.
+			BookCatalogTableModel bookCatalogTableModel = (BookCatalogTableModel) bookCatalogTable
+					.getModel();
+			// If the search field is empty, display all books in the database
+			// in the table.
+			if (searchField.getText().length() == 0) {
+				String[][] data = bookDatabase.getDatabaseForTable();
+				bookCatalogTableModel.setData(data);
+				bookCatalogTableModel.fireTableDataChanged();
+			} else {
+				// Search for matches to the search string.
+				String[][] data = bookDatabase
+						.searchDatabaseForTable(searchField.getText());
+				// Update the table.
+				bookCatalogTableModel.setData(data);
+				// Refresh the table.
+				bookCatalogTableModel.fireTableDataChanged();
+			}
+		} catch (SQLException e) {
+			// There was an SQL error of some sort.
+			System.err.println(e.getLocalizedMessage());
+		} catch (EmptyDatabase e) {
+			// The database was empty.
+			System.err.println(e.getLocalizedMessage());
+		}
+	}
+
+	/**
+	 * Nothing to do here.
+	 */
+	public void changedUpdate(DocumentEvent arg0) {
+	}
+
+	/**
+	 * Update the table with the search string.
+	 */
+	public void insertUpdate(DocumentEvent arg0) {
+		updateTableWithSearchString();
+	}
+
+	/**
+	 * Update the table with the search string.
+	 */
+	public void removeUpdate(DocumentEvent arg0) {
+		updateTableWithSearchString();
+	}
+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/bookdatabase/BookAlreadyInDatabase.java b/src/com/joshwalters/bookcatalog/bookdatabase/BookAlreadyInDatabase.java
new file mode 100644
index 0000000..b6428ef
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/bookdatabase/BookAlreadyInDatabase.java
@@ -0,0 +1,34 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog.bookdatabase;
+
+/**
+ * Thrown if the book is already in the database.
+ * 
+ * @author Josh Walters
+ */
+public class BookAlreadyInDatabase extends Exception {
+
+	/** The serial ID */
+	private static final long serialVersionUID = -433273330040981967L;
+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/bookdatabase/BookDatabase.java b/src/com/joshwalters/bookcatalog/bookdatabase/BookDatabase.java
new file mode 100644
index 0000000..9f06aba
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/bookdatabase/BookDatabase.java
@@ -0,0 +1,360 @@
+/*

+ *      Book Catalog - Catalog your book collection.

+ *      

+ *      Copyright (C) 2009 Joshua Walters

+ *      URL: http://joshwalters.com

+ *      

+ *      This file is part of Book Catalog.

+ *      

+ *      Book Catalog is free software: you can redistribute it and/or modify

+ *      it under the terms of the GNU General Public License as published by

+ *      the Free Software Foundation, either version 3 of the License, or

+ *      (at your option) any later version.

+ *      

+ *      Book Catalog is distributed in the hope that it will be useful,

+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of

+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

+ *      GNU General Public License for more details.

+ *      

+ *      You should have received a copy of the GNU General Public License

+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.

+ */

+

+package com.joshwalters.bookcatalog.bookdatabase;

+

+import java.sql.Connection;

+import java.sql.DriverManager;

+import java.sql.PreparedStatement;

+import java.sql.ResultSet;

+import java.sql.SQLException;

+import java.sql.Statement;

+import java.util.Vector;

+

+/**

+ * Manages the database of books.

+ * 

+ * @author Josh Walters

+ */

+public class BookDatabase {

+

+	/** The SQL statement. */

+	private Statement statement;

+	/** The SQL result set. */

+	private ResultSet resultSet;

+	/** The connection to the SQL database. */

+	private Connection connection;

+

+	/**

+	 * Automatically disconnect from the database.

+	 */

+	protected void finalize() {

+		disconnectFromDatabase();

+	}

+

+	/**

+	 * Connects to the database. If the table for the record of books does not

+	 * exist yet, then it will be created.

+	 * 

+	 * @throws SQLException

+	 * @throws ClassNotFoundException

+	 */

+	public void connectToDatabase() throws SQLException, ClassNotFoundException {

+		try {

+			// Connect to the database.

+			Class.forName("org.sqlite.JDBC");

+			// Create the database file.

+			connection = DriverManager

+					.getConnection("jdbc:sqlite:bookcatalog.db");

+			statement = connection.createStatement();

+		} catch (SQLException e) {

+			throw e;

+		} catch (ClassNotFoundException e) {

+			throw e;

+		}

+		// Set the timeout to unlimited.

+		statement.setQueryTimeout(0);

+		// Create the table if it does not exist.

+		statement.executeUpdate("create table if not exists bookcatalog("

+				+ "Title text, Author text, Date text,"

+				+ "Description text, ISBN text, Price text,"

+				+ "Publisher text, Subject text, Notes text)");

+	}

+

+	/**

+	 * Check to see if a book is in the database.

+	 * 

+	 * @param ISBN

+	 * @return True if book is in database, false if not.

+	 * @throws SQLException

+	 */

+	public boolean isBookInDatabase(String ISBN) throws SQLException {

+		// The SQL statement.

+		PreparedStatement preparedStatement = connection

+				.prepareStatement("select * from bookcatalog where ISBN = ?");

+		preparedStatement.setString(1, ISBN);

+		resultSet = preparedStatement.executeQuery();

+		boolean doesBookExist = resultSet.next();

+		resultSet.close();

+		return doesBookExist;

+	}

+

+	/**

+	 * Check if a book in the database has a price assigned to it.

+	 * 

+	 * @param ISBN

+	 * @return True if the book has price associated with it. False if not.

+	 * @throws SQLException

+	 */

+	boolean bookHasPrice(String ISBN) throws SQLException {

+		// The SQL statement

+		PreparedStatement preparedStatement = connection

+				.prepareStatement("select Price from bookcatalog where ISBN = ?");

+		preparedStatement.setString(1, ISBN);

+		resultSet = preparedStatement.executeQuery();

+		resultSet.next();

+		// Get the price value

+		String bookPriceInCatalog = resultSet.getString(1);

+		resultSet.close();

+		if (bookPriceInCatalog == null) {

+			return false;

+		} else {

+			return true;

+		}

+	}

+

+	/**

+	 * Sets the price for a book.

+	 * 

+	 * @param ISBN

+	 * @param Price

+	 * @throws SQLException

+	 */

+	void setBookPrice(String ISBN, String Price) throws SQLException {

+		// The SQL statement

+		PreparedStatement preparedStatement = connection

+				.prepareStatement("update bookcatalog set Price = ? where ISBN = ?");

+		preparedStatement.setString(1, Price);

+		preparedStatement.setString(2, ISBN);

+		if (preparedStatement.execute()) {

+			resultSet = statement.getResultSet();

+			if (resultSet != null) {

+				resultSet.close();

+			}

+		}

+	}

+

+	/**

+	 * Delete a book from the database.

+	 * 

+	 * @param ISBN

+	 *            Used to identify the book to delete.

+	 * @throws SQLException

+	 */

+	public void deleteBook(String ISBN) throws SQLException {

+		// The SQL statement

+		PreparedStatement preparedStatement = connection

+				.prepareStatement("delete from bookcatalog where ISBN = ?");

+		preparedStatement.setString(1, ISBN);

+		if (preparedStatement.execute()) {

+			resultSet = statement.getResultSet();

+			if (resultSet != null) {

+				resultSet.close();

+			}

+		}

+	}

+

+	/**

+	 * Updates a book entry with new information.

+	 * 

+	 * @param Title

+	 * @param Author

+	 * @param Date

+	 * @param Description

+	 * @param ISBN

+	 * @param Price

+	 * @param Publisher

+	 * @param Subject

+	 * @param Notes

+	 * @throws SQLException

+	 */

+	public void updateBook(String Title, String Author, String Date,

+			String Description, String ISBN, String Price, String Publisher,

+			String Subject, String Notes) throws SQLException {

+		// The SQL statement

+		PreparedStatement preparedStatement = connection

+				.prepareStatement("update bookcatalog set Title = ?, Author = ?, Date = ?, Description = ?, Price = ?, Publisher = ?, Subject = ?, Notes = ? where ISBN = ?");

+		preparedStatement.setString(1, Title);

+		preparedStatement.setString(2, Author);

+		preparedStatement.setString(3, Date);

+		preparedStatement.setString(4, Description);

+		preparedStatement.setString(5, Price);

+		preparedStatement.setString(6, Publisher);

+		preparedStatement.setString(7, Subject);

+		preparedStatement.setString(8, Notes);

+		preparedStatement.setString(9, ISBN);

+		if (preparedStatement.execute()) {

+			resultSet = statement.getResultSet();

+			if (resultSet != null) {

+				resultSet.close();

+			}

+		}

+	}

+

+	/**

+	 * Inserts a book into the database.

+	 * 

+	 * @param Title

+	 * @param Author

+	 * @param Date

+	 * @param Description

+	 * @param ISBN

+	 * @param Price

+	 * @param Publisher

+	 * @param Subject

+	 * @throws SQLException

+	 * @throws BookAlreadyInDatabase

+	 */

+	public void insertBook(String Title, String Author, String Date,

+			String Description, String ISBN, String Price, String Publisher,

+			String Subject) throws SQLException, BookAlreadyInDatabase {

+		// Check to see if the book is in the database

+		if (!isBookInDatabase(ISBN)) {

+			// The SQL statement

+			PreparedStatement preparedStatement = connection

+					.prepareStatement("insert into bookcatalog values(?,?,?,?,?,?,?,?,?);");

+			// Set the values for the prepared statement

+			preparedStatement.setString(1, Title);

+			preparedStatement.setString(2, Author);

+			preparedStatement.setString(3, Date);

+			preparedStatement.setString(4, Description);

+			preparedStatement.setString(5, ISBN);

+			preparedStatement.setString(6, Price);

+			preparedStatement.setString(7, Publisher);

+			preparedStatement.setString(8, Subject);

+			// Set the notes for the book blank by default.

+			preparedStatement.setString(9, "");

+			if (preparedStatement.execute()) {

+				resultSet = statement.getResultSet();

+				if (resultSet != null) {

+					resultSet.close();

+				}

+			}

+		} else {

+			// If the book exists in the database check to see if it has a price

+			// assigned to it

+			if (!bookHasPrice(ISBN) && Price != null) {

+				// If the book doesn't have a price associated with it, give it

+				// one.

+				setBookPrice(ISBN, Price);

+			} else {

+				// The book is already in the database and we don't have/need

+				// the price.

+				throw new BookAlreadyInDatabase();

+			}

+		}

+	}

+

+	/**

+	 * Get the database in a multidimensional string for use with a Swing table.

+	 * 

+	 * @return The database in a multidimensional string.

+	 * @throws SQLException

+	 * @throws EmptyDatabase

+	 */

+	public String[][] getDatabaseForTable() throws SQLException, EmptyDatabase {

+		// Get the number of books in the database.

+		resultSet = statement

+				.executeQuery("select count(ISBN) from bookcatalog");

+		if (resultSet.next()) {

+			int rows = resultSet.getInt(1);

+			resultSet.close();

+			// Select all the data in the database.

+			resultSet = statement.executeQuery("select * from bookcatalog");

+			// Create a new multidimensional string that will store the

+			// database.

+			String data[][] = new String[rows][9];

+			resultSet.next();

+			// Iterate over the database and store the data in the string.

+			for (int i = 0; i < rows; i++) {

+				for (int j = 1; j <= 9; j++) {

+					data[i][j - 1] = resultSet.getString(j);

+				}

+				resultSet.next();

+			}

+			resultSet.close();

+			// Return the database in string format.

+			return data;

+		}

+		throw new EmptyDatabase();

+	}

+

+	/**

+	 * This gets the database for a Swing table, but limits the results to

+	 * entries that match the search string.

+	 * 

+	 * @param searchString

+	 * @return

+	 * @throws SQLException

+	 * @throws EmptyDatabase

+	 */

+	public String[][] searchDatabaseForTable(String searchString)

+			throws SQLException, EmptyDatabase {

+		String[][] data = null;

+		Vector<String> cells = new Vector<String>();

+		// Remove all percent signs from the string.

+		searchString = searchString.replace("\\%", "");

+		// Add percent signs at beginning and end of string.

+		searchString = "%" + searchString + "%";

+		// Replace space characters with percent signs.

+		searchString = searchString.replace(" ", "%");

+		/*

+		 * Look for entries in the database that are similar to the search

+		 * string.

+		 */

+		PreparedStatement preparedStatement = connection

+				.prepareStatement("select * from bookcatalog where Title like ? or Author like ? or Date like ? or Description like ? or ISBN like ? or Price like ? or Publisher like ? or Subject like ? or Notes like ?");

+		preparedStatement.setString(1, searchString);

+		preparedStatement.setString(2, searchString);

+		preparedStatement.setString(3, searchString);

+		preparedStatement.setString(4, searchString);

+		preparedStatement.setString(5, searchString);

+		preparedStatement.setString(6, searchString);

+		preparedStatement.setString(7, searchString);

+		preparedStatement.setString(8, searchString);

+		preparedStatement.setString(9, searchString);

+		resultSet = preparedStatement.executeQuery();

+		// Store the result data in a vector.

+		while (resultSet.next()) {

+			for (int i = 1; i <= 9; i++) {

+				cells.add(resultSet.getString(i));

+			}

+		}

+		// Create a new multidimensional string to store the database search

+		// result.

+		data = new String[cells.size() / 9][9];

+		// Store the results in the string.

+		for (int i = 0; i < cells.size() / 9; i++) {

+			for (int j = 0; j < 9; j++) {

+				data[i][j] = (String) cells.get((i * 9) + j);

+			}

+		}

+		// Return the data in string format.

+		return data;

+	}

+

+	/**

+	 * Disconnect from the database. This will be called upon GC, but is best to

+	 * call it manually.

+	 * 

+	 * @throws SQLException

+	 */

+	public void disconnectFromDatabase() {

+		try {

+			if (connection.isClosed() != true) {

+				connection.close();

+			}

+		} catch (SQLException e) {

+			// Do nothing

+		}

+	}

+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/bookdatabase/EmptyDatabase.java b/src/com/joshwalters/bookcatalog/bookdatabase/EmptyDatabase.java
new file mode 100644
index 0000000..1ee98bf
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/bookdatabase/EmptyDatabase.java
@@ -0,0 +1,34 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog.bookdatabase;
+
+/**
+ * Thrown if the database is empty.
+ * 
+ * @author Josh Walters
+ */
+public class EmptyDatabase extends Exception {
+
+	/** The serial ID */
+	private static final long serialVersionUID = 7140054511201111418L;
+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/isbnlookup/GDataISBNLookup.java b/src/com/joshwalters/bookcatalog/isbnlookup/GDataISBNLookup.java
new file mode 100644
index 0000000..dc670b3
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/isbnlookup/GDataISBNLookup.java
@@ -0,0 +1,158 @@
+/*

+ *      Book Catalog - Catalog your book collection.

+ *      

+ *      Copyright (C) 2009 Joshua Walters

+ *      URL: http://joshwalters.com

+ *      

+ *      This file is part of Book Catalog.

+ *      

+ *      Book Catalog is free software: you can redistribute it and/or modify

+ *      it under the terms of the GNU General Public License as published by

+ *      the Free Software Foundation, either version 3 of the License, or

+ *      (at your option) any later version.

+ *      

+ *      Book Catalog is distributed in the hope that it will be useful,

+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of

+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

+ *      GNU General Public License for more details.

+ *      

+ *      You should have received a copy of the GNU General Public License

+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.

+ */

+

+package com.joshwalters.bookcatalog.isbnlookup;

+

+import java.io.IOException;

+import java.net.MalformedURLException;

+import java.net.URL;

+import java.util.List;

+

+import com.google.gdata.client.books.BooksService;

+import com.google.gdata.client.books.VolumeQuery;

+import com.google.gdata.data.books.VolumeEntry;

+import com.google.gdata.data.books.VolumeFeed;

+import com.google.gdata.data.dublincore.Creator;

+import com.google.gdata.data.dublincore.Subject;

+import com.google.gdata.data.dublincore.Title;

+import com.google.gdata.util.ServiceException;

+

+/**

+ * Performs book lookup with GData.

+ * 

+ * @author Josh Walters

+ */

+public class GDataISBNLookup extends ISBNLookup {

+

+	/**

+	 * Used for looking up the book.

+	 */

+	private BooksService service;

+	/**

+	 * The URL for the Google volumes feed.

+	 */

+	public final String FEED_URL = "http://books.google.com/books/feeds/volumes";

+

+	/**

+	 * Sets up the book service.

+	 */

+	public GDataISBNLookup() {

+		service = new BooksService("BookCatalog-1.0");

+	}

+

+	/**

+	 * Searches for a book.

+	 */

+	public void searchBooks(String barcode) throws NoBookFound,

+			InvalidSearchTerms {

+		// Clear all the book data fields

+		emptyDataFields();

+		// Purify the barcode, get the price if possible, and return just the

+		// ISBN

+		ISBN = purifyBarcode(barcode);

+		// Perform the query

+		VolumeQuery query;

+		try {

+			query = new VolumeQuery(new URL(FEED_URL));

+			query.setFullTextQuery(ISBN);

+			// Only return one result

+			query.setMaxResults(1);

+			VolumeFeed volumeFeed = service.query(query, VolumeFeed.class);

+			// Process the result

+			processVolumeFeed(volumeFeed);

+		} catch (MalformedURLException e) {

+			// Print the error to the error stream

+			System.err.println(e.getMessage());

+		} catch (IOException e) {

+			// Print the error to the error stream

+			System.err.println(e.getMessage());

+		} catch (ServiceException e) {

+			// Print the error to the error stream

+			System.err.println(e.getMessage());

+		}

+	}

+

+	/**

+	 * Processes the result feed to get the book data.

+	 * 

+	 * @param volumeFeed

+	 * @throws IOException

+	 * @throws ServiceException

+	 * @throws NoBookFound

+	 */

+	private void processVolumeFeed(VolumeFeed volumeFeed) throws IOException,

+			ServiceException, NoBookFound {

+		List<VolumeEntry> volumeEntries = volumeFeed.getEntries();

+		if (volumeEntries.size() == 0) {

+			throw new NoBookFound();

+		}

+		// Send the data to be stored in the class

+		storeVolumeEntry(volumeEntries.get(0));

+	}

+

+	/**

+	 * Store the data in the class variables.

+	 * 

+	 * @param entry

+	 * @throws IOException

+	 * @throws ServiceException

+	 */

+	private void storeVolumeEntry(VolumeEntry entry) throws IOException,

+			ServiceException {

+		// Get the book title(s).

+		for (Title t : entry.getTitles()) {

+			if (title == null) {

+				title = t.getValue();

+			} else {

+				title += ", " + t.getValue();

+			}

+		}

+		// Get the book creator(s).

+		for (Creator c : entry.getCreators()) {

+			if (author == null) {

+				author = c.getValue();

+			} else {

+				author += ", " + c.getValue();

+			}

+		}

+		// Get the book date.

+		if (entry.getDates().size() > 0) {

+			date = entry.getDates().get(0).getValue();

+		}

+		// Get the book description.

+		if (entry.getDescriptions().size() > 0) {

+			description = entry.getDescriptions().get(0).getValue();

+		}

+		// Get the book subject(s).

+		for (Subject s : entry.getSubjects()) {

+			if (subject == null) {

+				subject = s.getValue();

+			} else {

+				subject += ", " + s.getValue();

+			}

+		}

+		// Get the book publisher.

+		if (entry.getPublishers().size() > 0) {

+			publisher = entry.getPublishers().get(0).getValue();

+		}

+	}

+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/isbnlookup/ISBNLookup.java b/src/com/joshwalters/bookcatalog/isbnlookup/ISBNLookup.java
new file mode 100644
index 0000000..92d31ff
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/isbnlookup/ISBNLookup.java
@@ -0,0 +1,286 @@
+/*

+ *      Book Catalog - Catalog your book collection.

+ *      

+ *      Copyright (C) 2009 Joshua Walters

+ *      URL: http://joshwalters.com

+ *      

+ *      This file is part of Book Catalog.

+ *      

+ *      Book Catalog is free software: you can redistribute it and/or modify

+ *      it under the terms of the GNU General Public License as published by

+ *      the Free Software Foundation, either version 3 of the License, or

+ *      (at your option) any later version.

+ *      

+ *      Book Catalog is distributed in the hope that it will be useful,

+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of

+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

+ *      GNU General Public License for more details.

+ *      

+ *      You should have received a copy of the GNU General Public License

+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.

+ */

+

+package com.joshwalters.bookcatalog.isbnlookup;

+

+import java.util.regex.Pattern;

+

+/**

+ * Abstract class for performing an ISBN lookup for a book.

+ * 

+ * @author Josh Walters

+ */

+public abstract class ISBNLookup {

+

+	/**

+	 * The title of the book.

+	 */

+	protected String title;

+	/**

+	 * The author of the book.

+	 */

+	protected String author;

+	/**

+	 * The publisher of the book.

+	 */

+	protected String publisher;

+	/**

+	 * The date the book was published.

+	 */

+	protected String date;

+	/**

+	 * The description of the book.

+	 */

+	protected String description;

+	/**

+	 * The subject of the book.

+	 */

+	protected String subject;

+	/**

+	 * The books ISBN number.

+	 */

+	protected String ISBN;

+	/**

+	 * The price of the book.

+	 */

+	protected String price;

+

+	/**

+	 * Purifies the input barcode to make it suitable for use in lookup. Also

+	 * grabs the price from the barcode if it is present.

+	 * 

+	 * @param barcode

+	 * @return A purified barcode.

+	 * @throws InvalidSearchTerms

+	 */

+	protected String purifyBarcode(String barcode) throws InvalidSearchTerms {

+		// Remove the extra characters that some scanners include

+		barcode = removeCharInString(barcode, ' ');

+		barcode = removeCharInString(barcode, '-');

+		// Check to see if the barcode is made up of numbers.

+		if (!Pattern.matches("^\\d*$", barcode)) {

+			throw new InvalidSearchTerms();

+		}

+		// Check to see that the barcode is at least 4 digits long.

+		if (barcode.length() < 4) {

+			throw new InvalidSearchTerms();

+		}

+		// ISBN-13

+		if (barcode.substring(0, 3).compareTo("978") == 0

+				|| barcode.substring(0, 3).compareTo("979") == 0) {

+			if (barcode.length() == 15) {

+				barcode = barcode.substring(0, 13);

+			}

+			if (barcode.length() == 18) {

+				price = barcode.substring(13);

+				barcode = barcode.substring(0, 13);

+			}

+		}

+		// ISBN-10

+		else {

+			if (barcode.length() == 12) {

+				barcode = barcode.substring(0, 10);

+			}

+			if (barcode.length() == 15) {

+				price = barcode.substring(10);

+				barcode = barcode.substring(0, 10);

+			}

+		}

+		if (price != null) {

+			// Format price information

+			if (price.charAt(1) == '0') {

+				price = price.substring(2);

+				price = "$" + price.substring(0, 1) + "." + price.substring(1);

+			} else {

+				price = price.substring(1);

+				price = "$" + price.substring(0, 2) + "." + price.substring(2);

+			}

+		}

+		// Check to make sure that this is the proper length for an ISBN number.

+		if (barcode.length() != 10 & barcode.length() != 13) {

+			throw new InvalidSearchTerms();

+		}

+		return barcode;

+	}

+

+	/**

+	 * Clear out all the data fields.

+	 */

+	protected void emptyDataFields() {

+		title = null;

+		author = null;

+		publisher = null;

+		date = null;

+		description = null;

+		subject = null;

+		ISBN = null;

+		price = null;

+		return;

+	}

+

+	/**

+	 * Removes character from string.

+	 * 

+	 * @param s

+	 * @param c

+	 * @return The new string.

+	 */

+	private String removeCharInString(String s, char c) {

+		String result = "";

+		for (int i = 0; i < s.length(); i++) {

+			if (s.charAt(i) != c) {

+				result += s.charAt(i);

+			}

+		}

+		return result;

+	}

+

+	/**

+	 * Searches for a book.

+	 * 

+	 * @param barcode

+	 * @throws NoBookFound

+	 * @throws InvalidSearchTerms

+	 */

+	public abstract void searchBooks(String barcode) throws NoBookFound,

+			InvalidSearchTerms;

+

+	/**

+	 * @return the title

+	 */

+	public String getTitle() {

+		return title;

+	}

+

+	/**

+	 * @param title

+	 *            the title to set

+	 */

+	public void setTitle(String title) {

+		this.title = title;

+	}

+

+	/**

+	 * @return the author

+	 */

+	public String getAuthor() {

+		return author;

+	}

+

+	/**

+	 * @param author

+	 *            the author to set

+	 */

+	public void setAuthor(String author) {

+		this.author = author;

+	}

+

+	/**

+	 * @return the publisher

+	 */

+	public String getPublisher() {

+		return publisher;

+	}

+

+	/**

+	 * @param publisher

+	 *            the publisher to set

+	 */

+	public void setPublisher(String publisher) {

+		this.publisher = publisher;

+	}

+

+	/**

+	 * @return the date

+	 */

+	public String getDate() {

+		return date;

+	}

+

+	/**

+	 * @param date

+	 *            the date to set

+	 */

+	public void setDate(String date) {

+		this.date = date;

+	}

+

+	/**

+	 * @return the description

+	 */

+	public String getDescription() {

+		return description;

+	}

+

+	/**

+	 * @param description

+	 *            the description to set

+	 */

+	public void setDescription(String description) {

+		this.description = description;

+	}

+

+	/**

+	 * @return the subject

+	 */

+	public String getSubject() {

+		return subject;

+	}

+

+	/**

+	 * @param subject

+	 *            the subject to set

+	 */

+	public void setSubject(String subject) {

+		this.subject = subject;

+	}

+

+	/**

+	 * @return the ISBN

+	 */

+	public String getISBN() {

+		return ISBN;

+	}

+

+	/**

+	 * @param ISBN

+	 *            the ISBN to set

+	 */

+	public void setISBN(String ISBN) {

+		this.ISBN = ISBN;

+	}

+

+	/**

+	 * @return the price

+	 */

+	public String getPrice() {

+		return price;

+	}

+

+	/**

+	 * @param price

+	 *            the price to set

+	 */

+	public void setPrice(String price) {

+		this.price = price;

+	}

+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/isbnlookup/InvalidSearchTerms.java b/src/com/joshwalters/bookcatalog/isbnlookup/InvalidSearchTerms.java
new file mode 100644
index 0000000..558cde1
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/isbnlookup/InvalidSearchTerms.java
@@ -0,0 +1,34 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog.isbnlookup;
+
+/**
+ * Thrown if the search terms are invalid.
+ * 
+ * @author Josh Walters
+ */
+public class InvalidSearchTerms extends Exception {
+
+	/** The serial ID */
+	private static final long serialVersionUID = 8598966809541800761L;
+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/isbnlookup/NoBookFound.java b/src/com/joshwalters/bookcatalog/isbnlookup/NoBookFound.java
new file mode 100644
index 0000000..1c909e0
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/isbnlookup/NoBookFound.java
@@ -0,0 +1,34 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog.isbnlookup;
+
+/**
+ * Thrown if the book is not found.
+ * 
+ * @author Josh Walters
+ */
+public class NoBookFound extends Exception {
+
+	/** The serial ID */
+	private static final long serialVersionUID = -7276230896519983235L;
+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/sound/ErrorPlayingSound.java b/src/com/joshwalters/bookcatalog/sound/ErrorPlayingSound.java
new file mode 100644
index 0000000..313de47
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/sound/ErrorPlayingSound.java
@@ -0,0 +1,34 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog.sound;
+
+/**
+ * Thrown if there was an error playing the sound.
+ * 
+ * @author Josh Walters
+ */
+class ErrorPlayingSound extends Exception {
+
+	/** The serial ID */
+	private static final long serialVersionUID = 7400904062337176243L;
+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/sound/PlayWavSoundFile.java b/src/com/joshwalters/bookcatalog/sound/PlayWavSoundFile.java
new file mode 100644
index 0000000..23d6a6f
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/sound/PlayWavSoundFile.java
@@ -0,0 +1,78 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog.sound;
+
+import java.io.FileInputStream;
+import java.io.IOException;
+import java.io.InputStream;
+
+import sun.audio.AudioPlayer;
+import sun.audio.AudioStream;
+
+/**
+ * Plays a WAV file in a separate thread. This allows for very simple
+ * asynchronous WAV playback.
+ * 
+ * @author Josh Walters
+ */
+public class PlayWavSoundFile extends Thread {
+
+	/**
+	 * The WAV file to be played.
+	 */
+	private String filename;
+
+	/**
+	 * Takes the file name of the WAV file to be played.
+	 * 
+	 * @param wavfile
+	 *            The WAV file to be played.
+	 */
+	public PlayWavSoundFile(String wavfile) {
+		filename = wavfile;
+	}
+
+	/**
+	 * Plays the WAV file. First checks to see if the file is in a JAR with the
+	 * program, then checks to see if it is present in a regular folder/file.
+	 * Playback is asynchronous.
+	 */
+	public void run() {
+		try {
+			// Look for the WAV in a JAR
+			InputStream in = getClass().getClassLoader().getResourceAsStream(
+					filename);
+			// If not in JAR, check for regular file/folder
+			if (in == null) {
+				in = new FileInputStream(filename);
+			}
+			// Get the audio, and play it
+			AudioStream as = new AudioStream(in);
+			AudioPlayer.player.start(as);
+		} catch (IOException e) {
+			// Print the error to error output
+			System.err.println("Error loading and playing sound file: "
+					+ filename);
+		}
+	}
+}
\ No newline at end of file
diff --git a/src/com/joshwalters/bookcatalog/table/BookCatalogTableModel.java b/src/com/joshwalters/bookcatalog/table/BookCatalogTableModel.java
new file mode 100644
index 0000000..8fe69ba
--- /dev/null
+++ b/src/com/joshwalters/bookcatalog/table/BookCatalogTableModel.java
@@ -0,0 +1,103 @@
+/*
+ *      Book Catalog - Catalog your book collection.
+ *      
+ *      Copyright (C) 2009 Joshua Walters
+ *      URL: http://joshwalters.com
+ *      
+ *      This file is part of Book Catalog.
+ *      
+ *      Book Catalog is free software: you can redistribute it and/or modify
+ *      it under the terms of the GNU General Public License as published by
+ *      the Free Software Foundation, either version 3 of the License, or
+ *      (at your option) any later version.
+ *      
+ *      Book Catalog is distributed in the hope that it will be useful,
+ *      but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ *      GNU General Public License for more details.
+ *      
+ *      You should have received a copy of the GNU General Public License
+ *      along with Book Catalog.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+package com.joshwalters.bookcatalog.table;
+
+import java.sql.SQLException;
+
+import javax.swing.table.AbstractTableModel;
+
+import com.joshwalters.bookcatalog.bookdatabase.BookDatabase;
+import com.joshwalters.bookcatalog.bookdatabase.EmptyDatabase;
+
+/**
+ * The custom table model for the table that will display the book database.
+ * 
+ * @author Josh Walters
+ */
+public class BookCatalogTableModel extends AbstractTableModel {
+
+	/** The serial ID */
+	private static final long serialVersionUID = -3321121530039301264L;
+	/** The column names. */
+	private String[] columnNames = { "Title", "Author", "Date", "Description",
+			"ISBN", "Price", "Publisher", "Subject", "Notes" };
+	/** Stores the data that is displayed in the table */
+	private String[][] data;
+	/** The SQL database that stores the book collection records. */
+	BookDatabase bookDatabase;
+
+	/**
+	 * Populates the table with the info in the book database.
+	 * 
+	 * @param bookDatabase
+	 */
+	public BookCatalogTableModel(BookDatabase bookDatabase) {
+		this.bookDatabase = bookDatabase;
+		try {
+			data = bookDatabase.getDatabaseForTable();
+		} catch (SQLException e) {
+			// SQL error.
+			System.err.println(e.getLocalizedMessage());
+		} catch (EmptyDatabase e) {
+			// Database was empty.
+			System.err.println(e.getLocalizedMessage());
+		}
+	}
+
+	/**
+	 * Sets the data to be displayed.
+	 * 
+	 * @param data
+	 */
+	public void setData(String[][] data) {
+		this.data = data;
+	}
+
+	/**
+	 * Return the number of columns.
+	 */
+	public int getColumnCount() {
+		return columnNames.length;
+	}
+
+	/**
+	 * Get the number of rows.
+	 */
+	public int getRowCount() {
+		return data.length;
+	}
+
+	/**
+	 * Get the name of a column.
+	 */
+	public String getColumnName(int col) {
+		return columnNames[col];
+	}
+
+	/**
+	 * Get the value at a column.
+	 */
+	public String getValueAt(int row, int col) {
+		return data[row][col];
+	}
+}
\ No newline at end of file