Java Mysql sample program

Not the best deign of GUI or Database but it shows how Mysql can be connected with java.

Please get the mysql-connector-java-5.1.17 and the sql file used here

The links the documents show are the same

Import the sql file downloaded from the link to the mysql server

in CMD

write: mysqldump -u [uname] -p StudentDb > [backupfile.sql]

sample: mysqldump -u root -p StudentDb > F:\INtrodb\Student_data.sql

Then Enter the password of your mysql server

Make sure that the source code is connected to the library downloaded from the mysql java connector so the application will work with mysql properly.

The LogIn class


The CoursePane class


The StudentPane class


The Main class is Obj.java


The Application looks like the images in the pdf below. You can download the pdf from the File Menu.

Use of Mutual fund expert system

The Expert System aims to help anyone to choose which kind of mutual fund investment would work best for his/her circumstances in the Philippine setting. The system makes a conclusion that it evaluated to be the best among the options available base on the investor's circumstances but it does not force the investor to pick that option, but it just advises him/her so that the investor can get an expert opinion. The conclusion may also serve as something like a back-up plan for investors since investing is risky no matter what form of investment it is.

Anyone investor can benefit from the system as a guide or a provider of a back-up investment. The system is recommended by young and employed people who are new in investing since they would need an expert opinion on choosing a mutual fund, and being young allows them to take risk unlike older individuals who may not have enough time to recover from loss. Advising the neophyte investors reduces the risk they will get from investing and it also gives them confidence with their investment. Another reason why neophyte investors benefit from this is that mutual funds provides one of the lowest initial capital among investment options, and this system focuses on that topic. Other investors can also benefit from the system since it gives a conclusion that is not baseless and it is applicable, though it would probably serve as plan B to some of them.