Shaz Software Solutions

User Interface for Personal Finance Application inspired by a Bank Statement with all its codes included below

Personal Finance Application written in Java Language and MySql Database

Class: MetaData.java
Class: Transaction.java
Class: FinanceDB.java
Class: Finance.java
Class: FormatUI.java
Class: FinanceUI.java
Class: FinanceMain.java
Author: Shahrzad Jahangirian
Language: Java (using Java 6) Download Java 6 and Download Java Runtime 6(JRE)
Database: MySql
Date Added: Feb 1st, 2014
Licence: All source codes are for showing my skills in Software Development to get me a Job as an Application Developer. You are not allowed to sell this Application or use my codes to develop an application for Sale or apply my codes to develop software for commercial use and profit. You can offer me a price to buy the Application for mass production or buy my codes to develop your application for profit. Also you may offer me a price to buy this Application for your Business and ask me to update the codes to match your Business Requirements.

Description: This is a Java MySql Personal Finance Software. The idea for developing this MySql Database Application was my Commonwealth Bank Statement as a money management software. User enters income and expense records and this Java Application Software saves the record into the Transaction Table of Finance Database. This personal budget software calculates the current balance and displays it at the top and also in a report with each Transaction record. Obviously for an experience developer this application is very small thinking the real world software is large with many user interface screens and very complex logic. But my main goal is to get Employment offers for writing this type of Application and put its codes on my website. So hopefully a Developer or a Recruiter with Java programming knowledge could see my Analysis, Logic, Design and Implementation styles and finally I win a Software Developing Position.

How to Run: I tested all codes on Windows 7 Command Prompt with Java(TM) SE Runtime Environment 6 on my computer.
( you may download Java Virtual Machine by visiting this link )
Also to run this application you have to have MySql installed in your computer and know what is your MySql Username and Password. I used MySql 5.6.15 for this Application. In the time of writing of this page you may download MySql Database "MySQL Installer 5.6.15 (234.8M)" from http://dev.mysql.com/downloads/windows/installer/ page URL.
Then you need to create all files and save it in a folder in your computer such as C:\javacodes and compile and run at command prompt as follows. I assumed you saved all files at C:\javacodes
For this Application first you need to run MetaData.java class and access database successfully with your MySql username and password placed at jdbc:mysql://localhost?user=YourMysqlUsername&password=YourMysqlPassword for creating FINANCE Database and TRANSACTION Table as follows:
C:\javacodes> javac MetaData.java "This is to compile"
C:\javacodes> Java MetaData "This is to run"
Obviousley you should not have any error messages and also make sure Database and Table have been created by visiting your own MySql Database in your computer.
Then use a .bat file or compile following files on command prompt in its exact orders
C:\javacodes> javac Transaction.java -d c:\javacodes
C:\javacodes> javac FinanceDB.java -d c:\javacodes
C:\javacodes> javac Finance.java -d c:\javacodes
C:\javacodes> javac FormatUI.java -d c:\javacodes
C:\javacodes> javac FinanceUI.java -d c:\javacodes
C:\javacodes> javac FinanceMain.java "compiles the LoginMain class"
C:\javacodes> Java FinanceMain "and finally with this statement runs this Application"

Class: MetaData.java to access Database and create MySql Database and Table or Database Schema.

/*
 Class: MetaData
 Author: Shahrzad Jahangirian
 Date: Jan 25, 2014

This class establish a connection to MySql database using JDBC and then create 
 database schema for FINANCE Database and TRANSACTION Table. It needs to be run only once to
 connect to MySql database using username and password at
 jdbc:mysql://localhost?user=YourMysqlUsername&password=YourMysqlPassword
 then it creates the Database, and the Table with six fields of 
 transactionId, transactionDate, description, expense, income, balance 
 with transactionid as primary key.
 */

import java.sql.*;

public class MetaData {

public static void main(String args[]) {

String url =
        "jdbc:mysql://localhost?user=YourMysqlUsername&password=YourMysqlPassword";
    Connection con;
    String createDatabase = new String("create database FINANCE");
    String useDatabase = new String("use FINANCE");
    String transactionTable = new String();
    Statement stmt;

transactionTable = "create table TRANSACTION" +
        "(transactionId INTEGER not null unique, " +
        "transactionDate VARCHAR(25), " +
        "description VARCHAR(150), " +
        "expense DECIMAL(38,2), " +
        "income DECIMAL(38,2), " +
        "balance DECIMAL(38,2), " +
        "primary key(transactionId))";

try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (java.lang.ClassNotFoundException e) {
      System.err.println("ClassNotFoundException: " + e.getMessage());
    }

try {
      con = DriverManager.getConnection(url);
      stmt = con.createStatement();
      stmt.execute(createDatabase);
      stmt.execute(useDatabase);
      stmt.execute(transactionTable);
      stmt.close();
      con.close();
    }
    catch (SQLException ex) {
      System.err.println("SQLException: " + ex.getMessage());
    }
  }
}

Class: Transaction.java

/*
 Class: Transaction
 Author: Shahrzad Jahangirian
 Date: Jan 25, 2014
 Description: A class to be used for Transaction 
 */
package financePKG;

public class Transaction {

private int transactionId;
  private String transactionDate = new String();
  private String description = new String();
  private double expense;
  private double income;
  private double balance;

public Transaction() {

}

public int getTransactionId() {
    return transactionId;
  }

public String getTransactionDate() {
    return transactionDate;
  }

public String getDescription() {
    return description;
  }

public double getExpense() {
    return expense;
  }

public double getIncome() {
    return income;
  }

public double getBalance() {
    return balance;
  }

public void setTransactionId(int transactionId) {
    this.transactionId = transactionId;
  }

public void setTransactionDate(String transactionDate) {
    this.transactionDate = transactionDate;
  }

public void setDescription(String description) {
    this.description = description;
  }

public void setExpense(double expense) {
    this.expense = expense;
  }

public void setIncome(double income) {
    this.income = income;
  }

public void setBalance(double balance) {
    this.balance = balance;
  }

}

Class: FinanceDB.java for Mysql connect to Database

/*
 Class: FinanceDB
 Author: Shahrzad Jahangirian
 Date: Jan 25, 2014
 Description: This class connect to Mysql Database and it does all Database process methods for Personal Finance Application.   
 Replace your MySql usename and Password at
 String url = "jdbc:mysql://localhost?user=YourMysqlUsername&password=YourMysqlPassword" for database access;
 */
package financeDBPKG;

import java.sql.*;
import java.util.*;
import java.lang.*;
import java.text.*;

import financePKG.Transaction;

public class FinanceDB {
  private Connection con;
  private Statement stmt;
  private PreparedStatement query;
  private ResultSet rs;

public FinanceDB() {
    dbConnect();
  }

public void dbConnect() {
    String url = "jdbc:mysql://localhost?user=YourMysqlUsername&password=YourMysqlPassword";
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (java.lang.ClassNotFoundException e) {
      System.err.print("ClassNotFoundException: ");
      System.err.println(e.getMessage());
    }
    try {
      con = DriverManager.getConnection(url);
      stmt = con.createStatement();
      stmt.execute("use FINANCE");
    }
    catch (SQLException ex) {
      System.err.println("SQLException dbConnect: " + ex.getMessage());
    }
  }

public void dbClose() {
    try {
      stmt.close();
      con.close();
    }
    catch (SQLException ex) {
      System.err.println("SQLException dbClose: " + ex.getMessage());
    }
  }

public int getNextId() {
    int nextId = 0;
    try {
      query = con.prepareStatement(
          "select * from TRANSACTION");
      rs = query.executeQuery();
      if (!rs.next()) {
        nextId = 0;
      }
      else {
        rs.last();
        nextId = rs.getInt(1) + 1;
      }
    }
    catch (SQLException ex) {
      System.err.println("SQLException getNextId: " + ex.getMessage());
    }
    return nextId;
  }

public double getClosingBalance() {
    double closingBalance = 0.0;
    try {
      query = con.prepareStatement(
          "select * from TRANSACTION");
      rs = query.executeQuery();
      if (!rs.next()) {
        closingBalance = 0.0;
      }
      else {
        rs.last();
        closingBalance = rs.getDouble(6);
      }
    }
    catch (SQLException ex) {
      System.err.println("SQLException getClosingBalance: " + ex.getMessage());
    }
    return closingBalance;
  }

public boolean saveRecord(Transaction record) {
    boolean ok = true;
    try {
      query = con.prepareStatement(
          "insert into TRANSACTION values" +
          "(?, ?, ?, ?, ?, ?)");
      query.setDouble(1, record.getTransactionId());
      query.setString(2, record.getTransactionDate());
      query.setString(3, record.getDescription());
      query.setDouble(4, record.getExpense());
      query.setDouble(5, record.getIncome());
      query.setDouble(6, record.getBalance());
      query.executeUpdate();
    }
    catch (SQLException ex) {
      ok = false;
      System.err.println("SQLException saveRecord: " + ex.getMessage());
    }
    return ok;
  }

public Vector < Transaction > getAllTransaction() {

Vector < Transaction > list = new Vector < Transaction > ();
    Transaction record = new Transaction();
    try {
      PreparedStatement query =
          con.prepareStatement(
          "select * from TRANSACTION");
      rs = query.executeQuery();
      while (rs.next()) {
        record.setTransactionId(rs.getInt(1));
        record.setTransactionDate(rs.getString(2));
        record.setDescription(rs.getString(3));
        record.setExpense(rs.getDouble(4));
        record.setIncome(rs.getDouble(5));
        record.setBalance(rs.getDouble(6));
        list.add(record);
        record = new Transaction();
      }
    }
    catch (SQLException ex) {
      System.err.println("SQLException getAllTransaction: " + ex.getMessage());
    }
    return list;
  }

}

Class: Finance.java

/*
 Class: Finance
 Author: Shahrzad Jahangirian
 Date: Jan 24, 2014
 Description: A problem Domain class with methods to be used in FinanceUI
 */
package financePKG;

import java.util.*;
import java.text.*;
import financeDBPKG.FinanceDB;
import financePKG.Transaction;

public class Finance {

private FinanceDB db = new FinanceDB();
  private boolean confirmed = true;

public Finance() {

}

public boolean validateDouble(String number) {
    boolean valid = true;
    double d = 0.0;
    try {
      d = Double.parseDouble(number);
    }
    catch (Exception ex) {
      valid = false;
    }
    return valid;
  }

public double getCurrentBalance() {
    return db.getClosingBalance();
  }

public boolean processTransaction(Transaction transaction) {
    int id = db.getNextId();
    double closingBalance = db.getClosingBalance();
    transaction.setTransactionId(id);
    if (transaction.getExpense() != 0.0) {
      closingBalance = closingBalance - transaction.getExpense();
    }
    else {
      closingBalance = closingBalance + transaction.getIncome();
    }
    transaction.setBalance(closingBalance);
    confirmed = db.saveRecord(transaction);
    return confirmed;
  }

public Vector getTransactions(){
    return db.getAllTransaction();
  }
}

Class: FormatUI.java

/*
Class: FormatUI
Author: Shahrzad Jahangirian
Date: Jan 24, 2014
Description: A helper class that has been used to format different
Swing components.
*/
package commonPKG;

import javax.swing.*;
import java.awt.*;
import java.awt.*;
import javax.swing.*;
import java.lang.Exception;
import java.lang.*;

public class FormatUI {

public FormatUI() {

}

public void centerFrame(JFrame anObject) {
   Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
   int screenWidth = screenSize.width;
   int screenHeight = screenSize.height;
   Dimension frameSize = anObject.getSize();
   int x = (screenWidth - frameSize.width) / 2;
   int y = (screenHeight - frameSize.height) / 2;
   anObject.setLocation(x, y);
 }

/* A method to return a formatted JLabel
   formatLabel(variable name,text,x-cordinate,y-cordinate,
     width,height,background Red RGB color,background Green RGB color,
   background Blue RGB color, foreground Red RGB color, foreground Green RGB color,
   foreground Blue RGB color, font face string,
   font style number(PLAIN, BOLD, ITALIC, or BOLD+ITALIC), font size.
   */
  public JLabel formatLabel(JLabel aLabel, String txt, int x, int y, int width,
                            int height, int Bred, int Bgreen, int Bblue,
                            int Fred, int Fgreen, int Fblue, String fontFace,
                            int fontStyle, int fontSize, int vert, int horz) {
    aLabel.setOpaque(true);
    aLabel.setText(txt);
    aLabel.setBounds(new Rectangle(x, y, width, height));
    aLabel.setBackground(new Color(Bred, Bgreen, Bblue));
    aLabel.setForeground(new Color(Fred, Fgreen, Fblue));
    aLabel.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aLabel.setVerticalAlignment(vert);
    aLabel.setHorizontalAlignment(horz);

return aLabel;
  }

public JLabel formatLabel(JLabel aLabel, int x, int y, int width,
                            int height, int Bred, int Bgreen, int Bblue,
                            int Fred, int Fgreen, int Fblue, String fontFace,
                            int fontStyle, int fontSize, int vert, int horz) {
    aLabel.setOpaque(true);
    aLabel.setBounds(new Rectangle(x, y, width, height));
    aLabel.setBackground(new Color(Bred, Bgreen, Bblue));
    aLabel.setForeground(new Color(Fred, Fgreen, Fblue));
    aLabel.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aLabel.setVerticalAlignment(vert);
    aLabel.setHorizontalAlignment(horz);

return aLabel;
  }

public JRadioButton formatRadioButton(JRadioButton aRadioButton, String txt, int x, int y, int width,
                           int height, int Bred, int Bgreen, int Bblue,
                           int Fred, int Fgreen, int Fblue, String fontFace,
                           int fontStyle, int fontSize) {
   aRadioButton.setOpaque(true);
   aRadioButton.setText(txt);
   aRadioButton.setBounds(new Rectangle(x, y, width, height));
   aRadioButton.setBackground(new Color(Bred, Bgreen, Bblue));
   aRadioButton.setForeground(new Color(Fred, Fgreen, Fblue));
   aRadioButton.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
   return aRadioButton;
 }

public JTextField formatTextField(JTextField aTextField, String txt, int x,
                                    int y, int width, int height, int Bred,
                                    int Bgreen,
                                    int Bblue, int Fred, int Fgreen, int Fblue,
                                    String fontFace, int fontStyle,
                                    int fontSize
                                    ) {
    aTextField.setBorder(BorderFactory.createCompoundBorder());
    aTextField.setOpaque(true);
    aTextField.setText(txt);
    aTextField.setBounds(new Rectangle(x, y, width, height));
    aTextField.setBackground(new Color(Bred, Bgreen, Bblue));
    aTextField.setForeground(new Color(Fred, Fgreen, Fblue));
    aTextField.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    return aTextField;
  }

public JPasswordField formatPasswordField(JPasswordField aPasswordField, String txt, int x,
                                   int y, int width, int height, int Bred,
                                   int Bgreen,
                                   int Bblue, int Fred, int Fgreen, int Fblue,
                                   String fontFace, int fontStyle,
                                   int fontSize
                                   ) {
   aPasswordField.setBorder(BorderFactory.createCompoundBorder());
   aPasswordField.setOpaque(true);
   aPasswordField.setText(txt);
   aPasswordField.setBounds(new Rectangle(x, y, width, height));
   aPasswordField.setBackground(new Color(Bred, Bgreen, Bblue));
   aPasswordField.setForeground(new Color(Fred, Fgreen, Fblue));
   aPasswordField.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
   return aPasswordField;
 }

public JFormattedTextField formatFormattedTextField(JFormattedTextField
      aFormattedTextField, int x, int y, int width, int height, String option,
      int Bred, int Bgreen,
      int Bblue, int Fred, int Fgreen, int Fblue, String fontFace,
      int fontStyle, int fontSize
      ) throws
      Exception {
    aFormattedTextField.setBorder(BorderFactory.createLoweredBevelBorder());
    aFormattedTextField.setOpaque(true);
    aFormattedTextField.setBounds(new Rectangle(x, y, width, height));
    aFormattedTextField.setBackground(new Color(Bred, Bgreen, Bblue));
    aFormattedTextField.setForeground(new Color(Fred, Fgreen, Fblue));
    aFormattedTextField.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    return aFormattedTextField;
  }

public JComboBox formatComboBox(JComboBox aComboBox, int x, int y, int width,
                                  int height, boolean editable,
                                  boolean selected,
                                  int index, int Bred, int Bgreen,
                                  int Bblue, int Fred, int Fgreen, int Fblue,
                                  String fontFace,
                                  int fontStyle, int fontSize
                                  ) {
    aComboBox.setBorder(BorderFactory.createCompoundBorder());
    aComboBox.setBounds(new Rectangle(x, y, width, height));
    aComboBox.setOpaque(true);
    aComboBox.setBackground(new Color(Bred, Bgreen, Bblue));
    aComboBox.setForeground(new Color(Fred, Fgreen, Fblue));
    aComboBox.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aComboBox.setEditable(editable);
    if (selected == true) {
      aComboBox.setSelectedIndex(index);
    }
    return aComboBox;
  }

public JScrollPane formatScrollPane(JScrollPane aScrollpane, int x, int y,
                                      int width,
                                      int height, int Bred, int Bgreen,
                                      int Bblue, int Fred, int Fgreen,
                                      int Fblue, String fontFace,
                                      int fontStyle, int fontSize
                                      ) {
    aScrollpane.setBorder(BorderFactory.createLoweredBevelBorder());
    aScrollpane.setBounds(new Rectangle(x, y, width, height));
    aScrollpane.setBackground(new Color(Bred, Bgreen, Bblue));
    aScrollpane.setForeground(new Color(Fred, Fgreen, Fblue));
    aScrollpane.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    aScrollpane.setOpaque(true);

return aScrollpane;
  }

public JTable formatTable(JTable aTable, int x, int y,
                                    int width,
                                    int height, int Bred, int Bgreen,
                                    int Bblue, int Fred, int Fgreen,
                                    int Fblue, String fontFace,
                                    int fontStyle, int fontSize
                                    ) {
  aTable.setBorder(BorderFactory.createLoweredBevelBorder());
  aTable.setBounds(new Rectangle(x, y, width, height));
  aTable.setBackground(new Color(Bred, Bgreen, Bblue));
  aTable.setForeground(new Color(Fred, Fgreen, Fblue));
  aTable.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
  aTable.setOpaque(true);

return aTable;
}

public JTextArea formatTextArea(JTextArea aTextArea, String txt, int x, int y,
                                  int width, int height, int Bred, int Bgreen,
                                  int Bblue, int Fred, int Fgreen,
                                  int Fblue, String fontFace, int fontStyle,
                                  int fontSize, int border
                                  ) {
    aTextArea.setLineWrap(true);
    aTextArea.setWrapStyleWord(true);
    aTextArea.setEditable(true);
    aTextArea.setBounds(new Rectangle(x, y, width, height));
    aTextArea.setBackground(new Color(Bred, Bgreen, Bblue));
    aTextArea.setForeground(new Color(Fred, Fgreen, Fblue));
    aTextArea.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    switch (border) {
     case 0:
       aTextArea.setBorder(BorderFactory.createLoweredBevelBorder());
       break;
     case 1:
       aTextArea.setBorder(BorderFactory.createEmptyBorder());
       break;
     case 2:
       aTextArea.setBorder(BorderFactory.createEtchedBorder());
       break;
     case 4:
       aTextArea.setBorder(BorderFactory.createRaisedBevelBorder());
       break;
   }
    return aTextArea;
  }

public TextArea formatTextArea(TextArea aTextArea, String txt, int x, int y,
                                 int width, int height, int Bred, int Bgreen,
                                 int Bblue, int Fred, int Fgreen,
                                 int Fblue, String fontFace, int fontStyle,
                                 int fontSize
                                 ) {
   aTextArea.setEditable(true);
   aTextArea.setBounds(new Rectangle(x, y, width, height));
   aTextArea.setBackground(new Color(Bred, Bgreen, Bblue));
   aTextArea.setForeground(new Color(Fred, Fgreen, Fblue));
   aTextArea.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
   return aTextArea;
 }

public JTextPane formatTextPane(JTextPane aTextPane, String txt, int x, int y,
                                 int width, int height, int Bred, int Bgreen,
                                 int Bblue, int Fred, int Fgreen,
                                 int Fblue, String fontFace, int fontStyle,
                                 int fontSize, int border
                                 ) {
   aTextPane.setEditable(true);
   aTextPane.setBounds(new Rectangle(x, y, width, height));
   aTextPane.setBackground(new Color(Bred, Bgreen, Bblue));
   aTextPane.setForeground(new Color(Fred, Fgreen, Fblue));
   aTextPane.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
   switch (border) {
    case 0:
      aTextPane.setBorder(BorderFactory.createLoweredBevelBorder());
      break;
    case 1:
      aTextPane.setBorder(BorderFactory.createEmptyBorder());
      break;
    case 2:
      aTextPane.setBorder(BorderFactory.createEtchedBorder());
      break;
    case 4:
      aTextPane.setBorder(BorderFactory.createRaisedBevelBorder());
      break;
  }
   return aTextPane;
 }

public JButton formatButton(JButton aButton, String txt, int x, int y,
                              int width,
                              int height, int Bred, int Bgreen,
                              int Bblue, int Fred, int Fgreen, int Fblue,
                              String fontFace,
                              int fontStyle, int fontSize
                              ) {
    aButton.setOpaque(true);
    aButton.setText(txt);
    aButton.setBounds(new Rectangle(x, y, width, height));
    aButton.setBackground(new Color(Bred, Bgreen, Bblue));
    aButton.setForeground(new Color(Fred, Fgreen, Fblue));
    aButton.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));

return aButton;
  }

public JButton formatButton(JButton aButton, String txt, int x, int y,
                              int width,
                              int height,  int Fred, int Fgreen, int Fblue,
                              String fontFace,
                              int fontStyle, int fontSize
                              ) {
    aButton.setOpaque(true);
    aButton.setText(txt);
    aButton.setBounds(new Rectangle(x, y, width, height));
    aButton.setForeground(new Color(Fred, Fgreen, Fblue));
    aButton.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));

return aButton;
  }

public JCheckBox formatCheckBox(JCheckBox aButton, String txt, int x, int y,
                              int width,
                              int height, int Bred, int Bgreen,
                              int Bblue, int Fred, int Fgreen, int Fblue,
                              String fontFace,
                              int fontStyle, int fontSize
                              ) {
    aButton.setOpaque(true);
    aButton.setText(txt);
    aButton.setBounds(new Rectangle(x, y, width, height));
    aButton.setBackground(new Color(Bred, Bgreen, Bblue));
    aButton.setForeground(new Color(Fred, Fgreen, Fblue));
    aButton.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));

return aButton;
  }

public JPanel formatPanel(JPanel aPanel, int border, Color lineColor,
                            int lineThick,
                            String borderTitle, int x, int y, int width,
                            int height, int Bred, int Bgreen, int Bblue,
                            int Fred, int Fgreen, int Fblue, String fontFace,
                            int fontStyle, int fontSize) {
    aPanel.setOpaque(true);
    aPanel.setBounds(new Rectangle(x, y, width, height));
    aPanel.setBackground(new Color(Bred, Bgreen, Bblue));
    aPanel.setForeground(new Color(Fred, Fgreen, Fblue));
    aPanel.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
    switch (border) {
      case 0:
        aPanel.setBorder(BorderFactory.createLoweredBevelBorder());
        break;
      case 1:
        aPanel.setBorder(BorderFactory.createEmptyBorder());
        break;
      case 2:
        aPanel.setBorder(BorderFactory.createEtchedBorder());
        break;
      case 3:
        aPanel.setBorder(BorderFactory.createLineBorder(lineColor, lineThick));
        break;
      case 4:
        aPanel.setBorder(BorderFactory.createRaisedBevelBorder());
        break;
      case 5:
        aPanel.setBorder(BorderFactory.createTitledBorder(borderTitle));
        break;
    }
    return aPanel;
  }

public JPanel formatPanel(JPanel aPanel, int border, int x, int y, int width,
                           int height, int Bred, int Bgreen, int Bblue,
                           int Fred, int Fgreen, int Fblue, String fontFace,
                           int fontStyle, int fontSize) {
   aPanel.setOpaque(true);
   aPanel.setBounds(new Rectangle(x, y, width, height));
   aPanel.setBackground(new Color(Bred, Bgreen, Bblue));
   aPanel.setForeground(new Color(Fred, Fgreen, Fblue));
   aPanel.setFont(new java.awt.Font(fontFace, fontStyle, fontSize));
   switch (border) {
     case 0:
       aPanel.setBorder(BorderFactory.createLoweredBevelBorder());
       break;
     case 1:
       aPanel.setBorder(BorderFactory.createEmptyBorder());
       break;
     case 2:
       aPanel.setBorder(BorderFactory.createEtchedBorder());
       break;
     case 4:
       aPanel.setBorder(BorderFactory.createRaisedBevelBorder());
       break;
   }
   return aPanel;
 }

}

Class: FinanceUI.java

/*
 Class: FinanceUI
 Author: Shahrzad Jahangirian
 Date: Jan 22, 2014
 Description: FinanceUI is the User Interface for this Application. User need to input 
 a record of expense or income details at top of Application using Date, Description, 
 Expense or Income Text boxes. It displays User Current Balance and all already saved
 transactions records that have been saved on Database. 
 */
package financePKG;

import javax.swing.*;
import java.awt.*;
import java.util.*;
import java.awt.event.*;
import java.text.*;
import javax.swing.text.*;
import javax.swing.table.*;

import commonPKG.FormatUI;
import financePKG.Finance;
import financePKG.Transaction;
import javax.swing.text.BadLocationException;

public class FinanceUI
    extends JFrame {
  private JLabel statusBarLabel = new JLabel();
  private JLabel balanceTitleLabel = new JLabel();
  private JLabel balanceValueLabel = new JLabel();
  private JLabel dateLabel = new JLabel();
  private JLabel descriptionLabel = new JLabel();
  private JLabel expensesLabel = new JLabel();
  private JLabel incomeLabel = new JLabel();
  private JTextField dateTextField = new JTextField();
  private JTextField descriptionTextField = new JTextField();
  private JTextField expensesTextField = new JTextField();
  private JTextField incomeTextField = new JTextField();
  private JButton addButton = new JButton();
  private Object columnNames[] = {
      "Date", "Description", "Expense", "Income", "Balance"};
  private DefaultTableModel tableModel = new DefaultTableModel();
  private JTable financeTable = new JTable(tableModel);
  private JScrollPane financeScrollPane = new JScrollPane(financeTable);
  private static final long serialVersionUID = 12345678L;
  private FormatUI format = new FormatUI();
  private Transaction transaction = new Transaction();
  private Finance finance = new Finance();
  private boolean once = false;
  private DecimalFormat twoDecimal = new DecimalFormat("#.##");

public FinanceUI() {
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

private void jbInit() throws Exception {
    addButton.addActionListener(new FinanceUI_addButton_actionAdapter(this));

formatUserInterfaces();
    displayTransaction();
    balanceValueLabel.setText("$" + twoDecimal.format(finance.getCurrentBalance()));
    customizingTable();
    this.getContentPane().setBackground(new Color(236, 233, 231));
    this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
    addToContentPane();
    this.setSize(850, 600);
    this.setResizable(false);
    this.getContentPane().setLayout(new BorderLayout());
    this.setTitle("Personal Finance");
  }

public void formatUserInterfaces() {

balanceTitleLabel = format.formatLabel(balanceTitleLabel, "Current Balance: ",
                                           15, 20,
                                           115, 25, 236, 233, 231, 100, 100,
                                           100,
                                           "Arial", 0, 14,
                                           SwingConstants.CENTER,
                                           SwingConstants.LEFT);

balanceValueLabel = format.formatLabel(balanceValueLabel, "",
                                           130, 20,
                                           700, 25, 236, 233, 231, 100, 100,
                                           100,
                                           "Arial", 1, 18,
                                           SwingConstants.CENTER,
                                           SwingConstants.LEFT);
    dateLabel = format.formatLabel(dateLabel, "Date",
                                   15, 65,
                                   75, 25, 236, 233, 231, 100, 100, 100,
                                   "Arial", 0, 14,
                                   SwingConstants.CENTER,
                                   SwingConstants.LEFT);
    dateTextField = format.formatTextField(dateTextField, "",
                                           14, 90,
                                           150, 25, 255, 255, 255, 100, 100,
                                           100,
                                           "Arial", 0, 14);
    descriptionLabel = format.formatLabel(descriptionLabel, "Description",
                                          175, 65,
                                          125, 25, 236, 233, 231, 100, 100, 100,
                                          "Arial", 0, 14,
                                          SwingConstants.CENTER,
                                          SwingConstants.LEFT);
    descriptionTextField = format.formatTextField(descriptionTextField, "",
                                                  174, 90,
                                                  330, 25, 255, 255, 255, 100,
                                                  100, 100,
                                                  "Arial", 0, 14);
    expensesLabel = format.formatLabel(expensesLabel, "Expenses",
                                       515, 65,
                                       125, 25, 236, 233, 231, 100, 100, 100,
                                       "Arial", 0, 14,
                                       SwingConstants.CENTER,
                                       SwingConstants.LEFT);
    expensesTextField = format.formatTextField(expensesTextField, "",
                                               514, 90,
                                               150, 25, 255, 255, 255, 100, 100,
                                               100,
                                               "Arial", 0, 14);
    incomeLabel = format.formatLabel(incomeLabel, "Income",
                                     675, 65,
                                     125, 25, 236, 233, 231, 100, 100, 100,
                                     "Arial", 0, 14,
                                     SwingConstants.CENTER,
                                     SwingConstants.LEFT);
    incomeTextField = format.formatTextField(incomeTextField, "",
                                             674, 90,
                                             150, 25, 255, 255, 255, 100, 100,
                                             100,
                                             "Arial", 0, 14);
    addButton = format.formatButton(addButton, "Add", 714, 135, 110, 25, 100,
                                    100, 100, "Arial", Font.BOLD, 14);

statusBarLabel = format.formatLabel(statusBarLabel, "",
                                        -3, 540,
                                        854, 25, 236, 233, 231, 100, 100, 100,
                                        "Arial", 0, 14,
                                        SwingConstants.CENTER,
                                        SwingConstants.LEFT);
    statusBarLabel.setBorder(BorderFactory.createLoweredBevelBorder());

financeTable = format.formatTable(financeTable, 0, 200, 840,
                                      340, 255, 255, 255, 100, 100, 100,
                                      "Arial", 0, 16);

financeScrollPane = format.formatScrollPane(financeScrollPane, 0, 200, 840,
                                                340, 255, 255, 255, 100, 100,
                                                100, "Arial", 0, 12);
    financeScrollPane.setPreferredSize(new Dimension(840, 340));

}

public void addToContentPane() {
    this.getContentPane().add(balanceTitleLabel, null);
    this.getContentPane().add(balanceValueLabel, null);
    this.getContentPane().add(dateLabel, null);
    this.getContentPane().add(dateTextField, null);
    this.getContentPane().add(descriptionLabel, null);
    this.getContentPane().add(descriptionTextField, null);
    this.getContentPane().add(expensesLabel, null);
    this.getContentPane().add(expensesTextField, null);
    this.getContentPane().add(incomeLabel, null);
    this.getContentPane().add(incomeTextField, null);
    this.getContentPane().add(addButton, null);
    this.getContentPane().add(statusBarLabel, null);
    this.getContentPane().add(financeScrollPane);
  }

public boolean validateEntries() {
    boolean valid = true;

if ( (dateTextField.getText().trim().length() > 25) ||
        (dateTextField.getText().trim().equals("") == true)) {
      valid = false;
      statusBarLabel.setText(
          " Error: Date needs value up to 25 Characters");
    }
    else if ( (descriptionTextField.getText().trim().length() > 150) ||
             (descriptionTextField.getText().trim().equals("") == true)) {
      valid = false;
      statusBarLabel.setText(
          " Error: Description needs value up to 150 Characters");
    }
    else if ( (expensesTextField.getText().trim().equals("") == false) &&
             (incomeTextField.getText().trim().equals("") == false)) {
      valid = false;
      statusBarLabel.setText(
          " Error: Only one field must have value (Expense or Income)");
    }
    else if ( (expensesTextField.getText().trim().equals("") == true) &&
             (incomeTextField.getText().trim().equals("") == true)) {
      valid = false;
      statusBarLabel.setText(
          " Error: Expense and Income are empty, one field must have value.");
    }
    return valid;
  }

public boolean validateExpenseIncome() {
    boolean valid = false;
    if ( ( (finance.validateDouble(expensesTextField.getText().trim()) == true) &&
          (incomeTextField.getText().trim().equals("") == true)) ||
        ( (finance.validateDouble(incomeTextField.getText().trim()) == true) &&
         (expensesTextField.getText().trim().equals("") == true))
        ) {
      valid = true;
    }
    else {
      valid = false;
      statusBarLabel.setText(
          " Error: Either Expense or Income must have a Number value and other None");
    }
    return valid;
  }

public void assign() {
    transaction = new Transaction();
    transaction.setTransactionDate(dateTextField.getText().trim());
    transaction.setDescription(descriptionTextField.getText().trim());
    if ( (expensesTextField.getText().trim().equals("") == false) &&
        (incomeTextField.getText().trim().equals("") == true)) {
      transaction.setExpense(Double.parseDouble(expensesTextField.getText().
                                                trim()));
      statusBarLabel.setText("");
    }
    else if ( (incomeTextField.getText().trim().equals("") == false) &&
             (expensesTextField.getText().trim().equals("") == true)) {
      transaction.setIncome(Double.parseDouble(incomeTextField.getText().trim()));
      statusBarLabel.setText("");
    }
  }

public void clearScreen() {
    dateTextField.setText("");
    descriptionTextField.setText("");
    expensesTextField.setText("");
    incomeTextField.setText("");
  }

void addButton_actionPerformed(ActionEvent e) {
    boolean confirmation = false;

if (validateEntries() == true) {
      if (validateExpenseIncome() == true) {
        assign();
        confirmation = finance.processTransaction(transaction);
        if (confirmation == true) {
          balanceValueLabel.setText("$" +
                                    twoDecimal.format(finance.getCurrentBalance()));

displayTransaction();
          statusBarLabel.setText(
              "Transaction has been saved successfully into the Database");
          clearScreen();
        }
        else {
          statusBarLabel.setText(
              "ERROR: Transaction has not been saved into the Database");
        }
      }
    }
  }

public void displayVectorContents(Vector list) {
    Transaction t = new Transaction();
    for (int i = 0; i < list.size(); i++) {
      t = (Transaction) list.get(i);
      System.out.println(t.getTransactionId() + "  " + t.getTransactionDate() +
                         "  " + t.getDescription() + "  " + t.getExpense() +
                         "  " + t.getIncome() + "  " + t.getBalance());
      t = new Transaction();
    }
  }

public void customizingTable() {
    financeTable.setRowHeight(35);
    financeTable.setShowGrid(true);
    financeTable.getTableHeader().setFont(new Font("Arial", 0, 18));
    financeTable.getTableHeader().setForeground(new Color(100, 100, 100));
  }

public void displayTransaction() {
    Vector list = new Vector();
    list = finance.getTransactions();
    transaction = new Transaction();
    Vector < String > row = new Vector < String > ();
    tableModel.setColumnIdentifiers(columnNames);
    int index = list.size() - 2;
    int counter = list.size() - 1;
    if (once == true) {
      for (int i = index; i >= 0; i--) {
        tableModel.removeRow(i);
      }
    }
    for (int i = counter; i >= 0; i--) {
      transaction = (Transaction) list.get(i);
      row.add(" " + transaction.getTransactionDate());
      row.add(" " + transaction.getDescription());
      if (String.valueOf(transaction.getExpense()).equals("0.0") == true) {
        row.add("");
      }
      else {
        row.add(" $" + twoDecimal.format(transaction.getExpense()));
      }

if (String.valueOf(transaction.getIncome()).equals("0.0") == true) {
        row.add("");
      }
      else {
        row.add(" $" + twoDecimal.format(transaction.getIncome()));
      }
      row.add(" $" + twoDecimal.format(transaction.getBalance()));
      tableModel.addRow(row);
      transaction = new Transaction();
      row = new Vector < String > ();
      once = true;
    }
  } 
}

class FinanceUI_addButton_actionAdapter
    implements java.awt.event.ActionListener {
  FinanceUI adaptee;

FinanceUI_addButton_actionAdapter(FinanceUI adaptee) {
    this.adaptee = adaptee;
  }

public void actionPerformed(ActionEvent e) {
    adaptee.addButton_actionPerformed(e);
  }
}

Class:FinanceMain.java