tailieunhanh - Working with Database and Security in Java - JDBC-I

Question Kidszone School wants to store the information of students and their parents in their database. This will help them to better administer and control the new student registration process as well as manage already existing records of enrolled students. The School Management Board has chosen your company to provide a solution for the same. Consider yourself to be a part of the team that implements the solution for designing the application. | Working with Database and Security in Java Assignments JDBC-I Sr. No. Assignment Question 1 Kidszone School wants to store the information of students and their parents in their database. This will help them to better administer and control the new student registration process as well as manage already existing records of enrolled students. The School Management Board has chosen your company to provide a solution for the same. Consider yourself to be a part of the team that implements the solution for designing the application. Create a GUI based application that will allow the school staff to enter student details using Java Swing controls. The form should allow entering student details such as name address phone number parents name standard in which to be enrolled and fees to be paid. Information of fees and standard should be loaded from tables in database. All the information should be stored in database tables when OK button is clicked. The button Reset will blank out all text entry fields. The button Cancel will abort any entry in the fields and the table. Apply field level validations and display appropriate message while the staff enters data to prevent entry of junk data. When the staff enters all the relevant data and clicks on OK button the system generates unique Registration ID and Registration Date not shown in the form . These are used by the school staff for future reference. The interface of the student registration should resemble the following 2007 Aptech Ltd Version Page 1 of