Author: Shahrzad Jahangirian
Language: Java (using Java 6) Download Java 6 and Download Java Runtime 6(JRE)
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"