To recover these deleted records, one needs to recover all of the deleted records related to the deleted faculty member in those four Tables. An easy way to do this recovery is to use Oracle SQL Developer combined with our current project. For your convenience, we show these original records…
Continue Reading....Modify the FacultyProcess Page to Handle Faculty Data Deleting 2 – Develop Java Web Applications to Access Databases
Now we can build and run our project to test this faculty record delete function. Click on the Clean and Build Main Project button to perform cleaning up and building our project. Then click on the Run button to run our project. Enter the appropriate username and password, such as…
Continue Reading....Modify the FacultyProcess Page to Handle Faculty Data Deleting – Develop Java Web Applications to Access Databases
8.5.3.4 Modify the FacultyProcess Page to Handle Faculty Data DeletingDouble-click on the FacultyProcess.jsp page in the Projects window to open this page, and perform the following modifications to this page to use the Java bean FacultyUpdateDeleteBean.java to perform the faculty record delete action: 1) Move the cursor to the else…
Continue Reading....QUERY THE COURSE TABLE USING JAVASERVER PAGES AND JSP IMPLICIT SESSION OBJECT 2 – Develop Java Web Applications to Access Databases
Two methods can be used to add the Details button; one is to use a piece of JSP code and add it directly into the Course.jsp file, and the other is to use Microsoft Office Publisher 2007 to graphically add the button to the Course.html page and then save it…
Continue Reading....QUERY THE COURSE TABLE USING JAVASERVER PAGES AND JSP IMPLICIT SESSION OBJECT – Develop Java Web Applications to Access Databases
8.6 QUERY THE COURSE TABLE USING JAVASERVER PAGES AND JSP IMPLICIT SESSION OBJECT In this section, we discuss how to perform a data query from the Course Table in our sample Oracle database, CSE _ DEPT, via the Course.jsp page we built in Section 8.4.1.4. Basically the function of this…
Continue Reading....Create the CourseProcess.jsp Page 2 – Develop Java Web Applications to Access Databases
F. Then the method getCourse() defined in the Java Bean class file CourseQuery. java is called to query all courses, that is, all course _ id values, based on the selected faculty name, fname, obtained from step E. G. If the getCourse() method is executed successfully, which means that all…
Continue Reading....Create the CourseProcess.jsp Page – Develop Java Web Applications to Access Databases
8.6.2 Create the CourseProcess.jsp Page The purpose of this page is to direct control to the different help class files based on the button clicked by the user on the Course.jsp page. The following Java Bean class files will be triggered and executed based on the button clicked by the…
Continue Reading....Create the Java Bean or Java Model File, CourseQuery.java 3 – Develop Java Web Applications to Access Databases
Now let’s take care of the second part of the code for this Java Bean class, which is shown in Figure 8.102. A. The user-defined method, QueryCourse(), is defined starting from here. The function of this method is to collect the details for each course (course _ id) selected by…
Continue Reading....Create the Java Bean or Java Model File, CourseQuery.java 2 – Develop Java Web Applications to Access Databases
H. First a local integer variable, index, is declared and initialized to zero, and it works as a key number to be inserted into our HashMap object list later to build our HashMap object. Also, an acting HashMap object, sCourse, is generated with a key and a value format; both…
Continue Reading....Add a Method to the Java Bean to Perform Faculty Data Deleting – Develop Java Web Applications to Access Databases
8.5.3.3 Add a Method to the Java Bean to Perform Faculty Data Deleting To perform a faculty record delete action, we need to perform the following operations: 1) Add a new method to the Java session bean FacultyUpdateDeleteBean to handle the faculty record delete action. 2) Modify the FacultyProcess.jsp page…
Continue Reading....