Initial commit of code.

1 files changed, 457 insertions, 0 deletions

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