Creating a Java Gui Application with DataBase (Sql) Using Netbeans IDE 8.2 -- 2
Budget: $10 – $30 USD
You need to create a Java GUI Application and connect it to the database I have attached. When the user runs the program, gui should show tree table. It should have a purchase button that allows the user to purchase one of the available courses. It should ask the user to enter Gmail, phone, and username. Then the should add those records to the database. It should have an update button that allows the user to update their email or phone. It should have a remove account button that allows the user to delete their account.
Also, I need something unique for this application. A pie chart that the courses and how many people are taking each course would be perfect.
It should handle the errors. For example, It should follow the primary and foreign key violations when entering the data. When purchasing the course, the user has to enter their gmail and username. Gmail and username can not be null. If the user enters their phone number, the phone number needs to be in the correct format. every gmail needs to end as gmail.com and username can have only letters numbers and underscore. But It can not start with a number.
Please remember, you need to use NetBeans IDE 8.2.
Also, I need something unique for this application. A pie chart that the courses and how many people are taking each course would be perfect.
It should handle the errors. For example, It should follow the primary and foreign key violations when entering the data. When purchasing the course, the user has to enter their gmail and username. Gmail and username can not be null. If the user enters their phone number, the phone number needs to be in the correct format. every gmail needs to end as gmail.com and username can have only letters numbers and underscore. But It can not start with a number.
Please remember, you need to use NetBeans IDE 8.2.