Microsoft Word - Programming 632 AssignmentDevelop a JFrame program that will be connected with MySQL database named richfield and allows a user to register his/her personal details that will be...

Microsoft Word - Programming 632 Assignment Develop a JFrame program that will be connected with MySQL database named richfield and allows a user to register his/her personal details that will be stored in a table named registration. Table fields (Name, Surname, DOB, Address, Gender, Username, Password, Security_Question, Security_Answer) Use appropriate data type for given fields names. Login form The user will be able to register first, before he/she can be able to login. See screenshot below. Use two labels for “Forgotten password” and “New user Signup”. When the user clicks any of the two labels, a form must pop-up to allow the user to either reset the password or enter signup details depending on the label clicked. Your login form must be connected to a database that has the users table. When the user clicks the Login button, the program must verify user username & password to check if they match with those in the users table. If so, a message must pop-up displaying “Welcome with [your name]” . For example, “Welcome Samuel Rametse.” New user Signup form Please note that you have to validate all form fields when the user click submit button to ensure that there are no missing values in all the fields. The message notifying the users about these missing values must be displayed in a dialog box. Use the following security questions: 1. What's your mother’s middle name? 2. Which primary school did you attend? 3. Which year did you finish high school? 4. What is your favourite colour? Once the user is done completing the form correctly, data must be stored inside database table “registration” Clear button will reset all the fields in the form to blank. Exit button will terminate the form Forgotten password form The user is required to provide registered username, security question and security answer which were used the time he/she signed up. The program will compare the supplied information with the one in the database. If the information is correct the pop-up message will appear in the form of a dialog box with user password; otherwise it will show dialog message with “user information not found”. or [35]