Shaz Software Solutions

Login or new Signup Screen of Jan 2014 to be used for Multi User Password Protected Personal Finance Application or a Petty Cash Book

Application Screen of Feb 2014 that will display Transactions for each valid registered user, if to be used as a Petty Cash Management Software

Password Protected Multi User Cash Handling Application

Class: MetaData.java
Class: User.java
Class: Transaction.java
Class: ConnectionDB.java
Class: Login.java
Class: FinanceDB.java
Class: Finance.java
Class: FormatUI.java
Class: FinanceUI.java
Class: LoginUI.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 25, 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: Previously I developed two modules of this Application as "Jan 2014 Login and Signup" and "Feb 2014 Personal Finance" and published them on http://www.shazsoftware.com/java_library.php. Now I connected these two modules to create a password protected Application, so only the logged person can access all his/her own transaction details. Also I modified codes to make it a Multi User Application, so now many user can signup and use this Program. Every valid registered user only can access his/her own entries not any one else. In fact this is a very good Application to be used as a Petty Cash Management Software for many Businesses and their employees for their Office Petty Cash handling payments records.
Obviously this application needs more improvement to be commercialized from User Interface and probably more Functionality such as creating an Administrator User that can access everyone transactions, that I am happy to implement if a company or a business in Melbourne and its Suburbs is going to employee me to update this application to be theirs Petty Cash Manager System or to design and develop a new Database Business Application in regards to their requirements.

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 it 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 writting of this page you can download MySQL Installer 5.6.16 (250.8M) from http://dev.mysql.com/downloads/windows/installer/
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 successfuly with your MySql usename and password placed at jdbc:mysql://localhost?user=YourMysqlUsername&password=YourMysqlPassword for creating SFINANCE Database, PERSON and TRANSACTION Tables 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 Tables have been created by visiting your own MySql Database in your computer. (as above image)
Then use a .bat file or compile following files on command prompt in exact following orders
C:\javacodes> javac User.java -d c:\javacodes
C:\javacodes> javac Transaction.java -d c:\javacodes
C:\javacodes> javac ConnectionDB.java -d c:\javacodes
C:\javacodes> javac Login.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 LoginUI.java -d c:\javacodes
C:\javacodes> javac FinanceMain.java "compiles the FinanceMain class"
C:\javacodes> Java FinanceMain "and finally with this statement runs this Application"

Class: MetaData.java

/*
 Class: MetaData
 Author: Shahrzad Jahangirian
 update Date: Feb 17, 2014

This class establish a connection to MySql Database Managment System on your Computer
 using JDBC and then create the Secure Finace database named as
 SFINANCE and then create PERSON and TRANSACTION Tables. 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 its Tables.
 */

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 SFINANCE");
    String useDatabase = new String("use SFINANCE");
    String transactionTable = new String();
    String personTable = new String();
    Statement stmt;

personTable = "CREATE TABLE PERSON" +
        "(personid INTEGER NOT NULL UNIQUE, " +
        "username VARCHAR(50), " +
        "passwd VARCHAR(20), " +
        "PRIMARY KEY(personid))";

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), " +
        "personid INTEGER NOT NULL, " +
        "PRIMARY KEY(transactionId)," +
        "FOREIGN KEY(personid) references PERSON(personid))";

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(personTable);
      stmt.execute(transactionTable);
      stmt.close();
      con.close();
    }
    catch (SQLException ex) {
      System.err.println("SQLException: " + ex.getMessage());
    }
  }
}

Class: User.java

/*
 Class: User
 Author: Shahrzad Jahangirian
 Update Date: Feb 17, 2014
 Description: A class for a User information.
 */

package financePKG;

public class User {

private int userId;
  private String userName = new String();
  private String password = new String();
  private String repeatPassword = new String();
  private boolean newUser = false;

public User() {

}

public boolean isPasswordSame(String password, String repeatPassword) {
    boolean valid = false;

if (password.equals(repeatPassword) == true) {
      valid = true;
    }
    return valid;
  }

public boolean isValidLength(String item, int minSize, int maxSize) {
    boolean valid = true;
    if ( (item.length() < minSize) || (item.length() > maxSize)) {
      valid = false;
    }
    return valid;
  }

public void setUserId(int userId) {
    this.userId = userId;
  }

public void setUserName(String userName) {
    this.userName = userName;
  }

public void setPassword(String password) {
    this.password = password;
  }

public void setRepeatPassword(String repeatPassword) {
    this.repeatPassword = repeatPassword;
  }

public void setNewUser(boolean newUser) {
    this.newUser = newUser;
  }

public int getUserId() {
    return userId;
  }

public String getUserName() {
    return userName;
  }

public String getPassword() {
    return password;
  }

public String getRepeatPassword() {
    return repeatPassword;
  }

public boolean getNewUser() {
    return newUser;
  }

}

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;
  private int personId;

public Transaction() {

}

public int getTransactionId() {
    return transactionId;
  }

public int getPersonId() {
    return personId;
  }

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 setPersonId(int personId) {
    this.personId = personId;
  }

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: ConnectionDB.java

/*
 Class: ConnectionDB
 Author: Shahrzad Jahangirian
 Update Date: Feb 18, 2014
 Description: This is a class for Database Conncetion.
 Replace your MySql usename and Password at
 String url = "jdbc:mysql://localhost?user=YourMysqlUsername&password=YourMysqlPassword";
 */
package financeDBPKG;

import java.sql.*;
import java.lang.*;

public class ConnectionDB {
  protected Connection con;
  protected Statement stmt;
  protected PreparedStatement query;
  protected ResultSet rs;

public ConnectionDB() {
    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 SFINANCE");
    }
    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());
    }
  }
}

Class: Login.java

/*
 Class: Login
 Author: Shahrzad Jahangirian
 Update Date: Feb 18, 2014
 Description: This class has all database methods to be used for Login and signup.
  It is a child class of ConnectionDB cllass.
 */

package financeDBPKG;

import java.sql.*;
import java.lang.*;

import financePKG.User;

public class Login
    extends ConnectionDB {
  private int loggedUserId;

public Login() {
    super();
  }

public int getNextId() {
    int nextId = 0;
    try {
      query = con.prepareStatement(
          "select personid from person");
      rs = query.executeQuery();
      if (rs.first() == false) {
        nextId = 1;
      }
      while (rs.next()) {
        if (rs.last() == true) {
          nextId = rs.getInt(1) + 1;
        }
      }
    }
    catch (SQLException ex) {
      System.err.println("SQLException getNextId: " + ex.getMessage());
    }
    return nextId;
  }

public void saveUser(User user) {
    int nextId = getNextId();
    try {
      query = con.prepareStatement(
          "insert into person values" +
          "(?, ?, ?)");
      query.setInt(1, nextId);
      query.setString(2, user.getUserName());
      query.setString(3, user.getPassword());
      query.executeUpdate();
    }
    catch (SQLException ex) {
      System.err.println("SQLException saveNewRecord: " + ex.getMessage());
    }
  }

public boolean findUser(User user) {
    ResultSet rs;
    boolean found = false;
    try {
      query = con.prepareStatement(
          "select * from person where username like ? and passwd like ?");
      query.setString(1, user.getUserName());
      query.setString(2, user.getPassword());
      rs = query.executeQuery();
      if (rs.first() == true) {
        found = true;
        loggedUserId = rs.getInt(1);
      }
    }
    catch (SQLException ex) {
      System.err.println("SQLException saveNewRecord: " + ex.getMessage());
    }
    return found;
  }

public int getLoggedUserId() {
    return loggedUserId;
  }

public boolean findUsername(User user) {
    ResultSet rs;
    boolean found = false;
    try {
      query = con.prepareStatement(
          "select * from person where username like ?");
      query.setString(1, user.getUserName());
      rs = query.executeQuery();
      if (rs.first() == true) {
        found = true;
      }
    }
    catch (SQLException ex) {
      System.err.println("SQLException saveNewRecord: " + ex.getMessage());
    }
    return found;
  }

}

Class: FinanceDB.java

/*
 Class: FinanceDB
 Author: Shahrzad Jahangirian
 Update Date: Feb 17, 2014
 Description: This class does all database manipulation for Transaction table of SFinance Database.
 It is a child class of ConnectionDB cllass.
 */
package financeDBPKG;

import java.sql.*;
import java.util.*;
import java.lang.*;
import financePKG.Transaction;

public class FinanceDB extends ConnectionDB {

public FinanceDB() {
    super();
  }

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(int loggedUser) {
    double closingBalance = 0.0;
    try {
      query = con.prepareStatement(
          "select * from TRANSACTION where personid = ?");
      query.setInt(1, loggedUser);
      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.setInt(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.setInt(7, record.getPersonId());
      query.executeUpdate();
    }
    catch (SQLException ex) {
      ok = false;
      System.err.println("SQLException saveRecord: " + ex.getMessage());
    }
    return ok;
  }

public Vector < Transaction > getAllTransaction(int loggedUserId) {
    Vector < Transaction > list = new Vector < Transaction > ();
    Transaction record = new Transaction();
    try {
      PreparedStatement query =
          con.prepareStatement(
          "select * from TRANSACTION where personid = ?");
      query.setInt(1, loggedUserId);
      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));
        record.setTransactionId(rs.getInt(7));
        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 that process methods used in FinanceUI
 */
package financePKG;

import java.util.*;
import financeDBPKG.FinanceDB;

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(int loggedUserId) {
    return db.getClosingBalance(loggedUserId);
  }

public boolean processTransaction(Transaction transaction) {
    int id = db.getNextId();
    double closingBalance = db.getClosingBalance(transaction.getPersonId());
    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(int loggedUserId){
    return db.getAllTransaction(loggedUserId);
  }
}

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 financeUIPKG;

import javax.swing.*;
import java.awt.*;
import java.util.*;
import java.awt.event.*;
import java.text.*;
import javax.swing.table.*;
import financePKG.Finance;
import commonPKG.FormatUI;
import financePKG.Transaction;

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("#.##");
  private int loggedUserId;

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

public FinanceUI(int loggedUserId) {
    try {
      this.loggedUserId = loggedUserId;
      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(loggedUserId)));
    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 setLoggedUserId(int loggedUserId){
    this.loggedUserId = loggedUserId;
  }

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("");
    }
    transaction.setPersonId(loggedUserId);
  }

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(loggedUserId)));

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(loggedUserId);
    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: LoginUI.java

/*
 Class: LoginUI
 Author: Shahrzad Jahangirian
 Update Date: Feb 18, 2014
 Description: Login and Signup Gui to allow access to the Finance Application to a valid user.
 A valid user could be a previous registered Person with Username and Password that exist in
 Database or a New User that just Signed up.
 */

package financeUIPKG;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;

import financePKG.User;
import financeDBPKG.Login;
import financeUIPKG.FinanceUI;
import commonPKG.FormatUI;

public class LoginUI
    extends JFrame implements Serializable {

public static final long serialVersionUID = 12345678L;
  private JPanel loginPanel = new JPanel();
  private JLabel loginLabel = new JLabel();
  private JLabel userNameLabel = new JLabel();
  private JLabel passwordLabel = new JLabel();
  private JLabel signUpLabel = new JLabel();
  private JLabel repeatPassLabel = new JLabel();
  private JLabel statusBarLabel = new JLabel();
  private JTextField userNameTextField = new JTextField();
  private JPasswordField passwordTextField = new JPasswordField(8);
  private JPasswordField repeatPassTextField = new JPasswordField(8);
  private JButton loginButton = new JButton();
  private JRadioButton loginRadioButton = new JRadioButton();
  private JRadioButton signUpRadioButton = new JRadioButton();
  private ButtonGroup group = new ButtonGroup();
  private FormatUI format = new FormatUI();
  private User user = new User();
  private Login login = new Login();

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

private void jbInit() throws Exception {
    formatUserInterfaces();
    loginPanel.setBackground(new Color(244, 232, 213));
    loginPanel.setLayout(null);
    addToPanel();
    addListeners();
    group.add(loginRadioButton);
    group.add(signUpRadioButton);
    loginRadioButton.setSelected(true);
    loginButton.setText("LOGIN");
    repeatPassLabel.setVisible(false);
    repeatPassTextField.setVisible(false);
    this.getContentPane().setBackground(new Color(244, 232, 213));
    this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
    this.setResizable(true);
    this.setSize(290, 230);
    this.setResizable(false);
    this.getContentPane().setLayout(new BorderLayout());
    this.getContentPane().add(loginPanel, null);
    this.setTitle("Login/ Sign up");
    format.centerFrame(this);
  }

public void addToPanel() {
    loginPanel.add(loginLabel);
    loginPanel.add(userNameLabel);
    loginPanel.add(passwordLabel);
    loginPanel.add(signUpLabel);
    loginPanel.add(repeatPassLabel);
    loginPanel.add(statusBarLabel);
    loginPanel.add(userNameTextField);
    loginPanel.add(passwordTextField);
    loginPanel.add(repeatPassTextField);
    loginPanel.add(loginButton);
    loginPanel.add(loginRadioButton);
    loginPanel.add(signUpRadioButton);

}

public void addListeners() {
    userNameTextField.addMouseListener(new
                                       LoginUI_userNameTextField_mouseAdapter(this));
    passwordTextField.addMouseListener(new
                                       LoginUI_passwordTextField_mouseAdapter(this));
    repeatPassTextField.addMouseListener(new
                                         LoginUI_repeatPassTextField_mouseAdapter(this));
    loginRadioButton.addActionListener(new
                                       LoginUI_loginRadioButton_actionAdapter(this));
    signUpRadioButton.addActionListener(new
                                        LoginUI_signUpRadioButton_actionAdapter(this));
    loginButton.addActionListener(new
                                        LoginUI_loginButton_actionAdapter(this));

}

public void formatUserInterfaces() {
    loginRadioButton = format.formatRadioButton(loginRadioButton, "Login", 15,
                                                15, 75,
                                                25, 244, 232, 213, 153, 135,
                                                109, "Arial",
                                                1, 14);
    signUpRadioButton = format.formatRadioButton(signUpRadioButton, "Sign Up",
                                                 130, 15, 150,
                                                 25, 244, 232, 213, 153, 135,
                                                 109, "Arial",
                                                 1, 14);

userNameTextField = format.formatTextField(userNameTextField, "", 135,
                                               50, 125, 20, 255, 255, 255, 153,
                                               135, 109, "Arial", 1, 14);
    userNameLabel = format.formatLabel(userNameLabel, "User Name", 20, 50,
                                       100, 25, 244, 232, 213, 153, 135, 109,
                                       "Arial", 1, 12, SwingConstants.CENTER,
                                       SwingConstants.LEFT);

passwordTextField = format.formatPasswordField(passwordTextField, "",
        135, 75, 125, 20, 255, 255, 255,
        153, 135, 109, "Arial", 1, 30);

repeatPassTextField = format.formatPasswordField(repeatPassTextField, "",
        135, 100, 125, 20, 255, 255,
        255, 153, 135, 109, "Arial", 1,
        30);
    passwordLabel = format.formatLabel(passwordLabel, "Password", 20, 75,
                                       100, 25, 244, 232, 213, 153, 135, 109,
                                       "Arial", 1, 12,
                                       SwingConstants.CENTER,
                                       SwingConstants.LEFT);
    repeatPassLabel = format.formatLabel(repeatPassLabel, "Repeat Password",
                                         20, 100,
                                         105, 25, 244, 232, 213, 153, 135, 109,
                                         "Arial", 1, 12,
                                         SwingConstants.CENTER,
                                         SwingConstants.LEFT);
    statusBarLabel = format.formatLabel(statusBarLabel, " ", -3, 170,
                                        310, 25, 244, 232, 213, 153, 135, 109,
                                        "Arial", 1, 12, SwingConstants.CENTER,
                                        SwingConstants.LEFT);
    statusBarLabel.setBorder(BorderFactory.createLoweredBevelBorder());

loginButton = format.formatButton(loginButton, "LOGIN", 170, 130, 90, 25,
                                      164, 86,
                                      84, 244, 232, 213, "Arial", 1, 12);
  }

public boolean validateEntries() {
    boolean valid = true;

if ((userNameTextField.getText().trim().equals("") == true) ||
        (String.valueOf(passwordTextField.getPassword()).trim().equals("") == true) ){
      valid = false;
      statusBarLabel.setText(
          " ERROR: User Name & Password needs values");
    }
    else if ((user.isValidLength(userNameTextField.getText().trim(), 8, 50)) == false) {
      valid = false;
      statusBarLabel.setText(
          " ERROR: User Name needs 8 to 50 characters");
    }
    else if ((user.isValidLength(String.valueOf(passwordTextField.getPassword()).trim(), 4, 8)) == false) {
      valid = false;
      statusBarLabel.setText(" ERROR: Password needs 4 to 8 characters");
    }
    else if (signUpRadioButton.isSelected() == true) {
      if (String.valueOf(repeatPassTextField.getPassword()).trim().equals("") == true) {
       valid = false;
       statusBarLabel.setText(" ERROR: Repeat your Password");
     }
     else if (user.isPasswordSame(String.valueOf(passwordTextField.getPassword()).trim(),
                         String.valueOf(repeatPassTextField.getPassword()).trim()) == false) {
        valid = false;
        statusBarLabel.setText(" ERROR: Passwords are not the same");
      }
    }

return valid;
  }

public void assign() {
    user.setUserName(userNameTextField.getText().trim());
    user.setPassword(String.valueOf(passwordTextField.getPassword()).trim());
    if (signUpRadioButton.isSelected() == true) {
      user.setNewUser(true);
    }
    else {
      user.setNewUser(false);
    }
  }

public void loginButton_actionPerformed(ActionEvent e) {
    boolean found = false;
    int loggedUser=0;
    if (validateEntries() == true) {
      assign();
      if (loginRadioButton.isSelected() == true){
       found = login.findUser(user);
       if(found == true){
          loggedUser = login.getLoggedUserId();
          FinanceUI financeui = new FinanceUI(loggedUser);
          financeui.setVisible(true);
          userNameTextField.setText("");
          passwordTextField.setText("");
       }
       else{
         statusBarLabel.setText(" Your Username or Password is Wrong, Try Again");
       }
      }
      else if (signUpRadioButton.isSelected() == true){
        found = login.findUsername(user);
        if(found == true){
         statusBarLabel.setText(" This Username is already Exist, Please Try Again");
        }
        else{
          login.saveUser(user);
          statusBarLabel.setText(user.getUserName() +
                                 " has been successfully signed up.");
          userNameTextField.setText("");
          passwordTextField.setText("");
          repeatPassTextField.setText("");
        }
      }
    }
  }

void userNameTextField_mouseExited(MouseEvent e) {
    statusBarLabel.setText(" ");
  }

void userNameTextField_mouseEntered(MouseEvent e) {
    statusBarLabel.setText(" Enter User Name (8 to 50 characters)");
  }

void passwordTextField_mouseEntered(MouseEvent e) {
    statusBarLabel.setText(" Enter Password (4 to 8 characters)");
  }

void passwordTextField_mouseExited(MouseEvent e) {
    statusBarLabel.setText(" ");
  }

void repeatPassTextField_mouseEntered(MouseEvent e) {
    statusBarLabel.setText(" Repeat Password");
  }

void repeatPassTextField_mouseExited(MouseEvent e) {
    statusBarLabel.setText(" ");
  }

void loginRadioButton_actionPerformed(ActionEvent e) {
    loginButton.setText("LOGIN");
    repeatPassLabel.setVisible(false);
    repeatPassTextField.setVisible(false);
  }

void signUpRadioButton_actionPerformed(ActionEvent e) {
    loginButton.setText("SIGN UP");
    repeatPassLabel.setVisible(true);
    repeatPassTextField.setVisible(true);

}
}

class LoginUI_loginButton_actionAdapter
    implements java.awt.event.ActionListener {
  LoginUI adaptee;

LoginUI_loginButton_actionAdapter(LoginUI adaptee) {
    this.adaptee = adaptee;
  }

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

class LoginUI_userNameTextField_mouseAdapter
    extends java.awt.event.MouseAdapter {
  LoginUI adaptee;

LoginUI_userNameTextField_mouseAdapter(LoginUI adaptee) {
    this.adaptee = adaptee;
  }

public void mouseEntered(MouseEvent e) {
    adaptee.userNameTextField_mouseEntered(e);
  }

public void mouseExited(MouseEvent e) {
    adaptee.userNameTextField_mouseExited(e);
  }
}

class LoginUI_passwordTextField_mouseAdapter
    extends java.awt.event.MouseAdapter {
  LoginUI adaptee;

LoginUI_passwordTextField_mouseAdapter(LoginUI adaptee) {
    this.adaptee = adaptee;
  }

public void mouseExited(MouseEvent e) {
    adaptee.passwordTextField_mouseExited(e);
  }

public void mouseEntered(MouseEvent e) {
    adaptee.passwordTextField_mouseEntered(e);
  }
}

class LoginUI_repeatPassTextField_mouseAdapter
    extends java.awt.event.MouseAdapter {
  LoginUI adaptee;

LoginUI_repeatPassTextField_mouseAdapter(LoginUI adaptee) {
    this.adaptee = adaptee;
  }

public void mouseEntered(MouseEvent e) {
    adaptee.repeatPassTextField_mouseEntered(e);
  }

public void mouseExited(MouseEvent e) {
    adaptee.repeatPassTextField_mouseExited(e);
  }
}

class LoginUI_loginRadioButton_actionAdapter
    implements java.awt.event.ActionListener {
  LoginUI adaptee;

LoginUI_loginRadioButton_actionAdapter(LoginUI adaptee) {
    this.adaptee = adaptee;
  }

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

class LoginUI_signUpRadioButton_actionAdapter
    implements java.awt.event.ActionListener {
  LoginUI adaptee;

LoginUI_signUpRadioButton_actionAdapter(LoginUI adaptee) {
    this.adaptee = adaptee;
  }

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

Class:FinanceMain.java