8.5 BUILD A JAVA WEB PROJECT TO MANIPULATE DATA IN THE ORACLE DATABASE Now let’s take care of manipulating data against our Oracle 18c XE database by using different methodologies, which include inserting, updating and deleting records from our sample database, CSE _ DEPT, via our Web application project. FIGURE…
Continue Reading....Category: Create the CourseProcess.jsp Page
Create the Java Bean or Java Model File, CourseQuery.java – Develop Java Web Applications to Access Databases
8.6.3 Create the Java Bean or Java Model File, CourseQuery.java To create our Java help class file, CourseQuery.java, to handle the course record query, right-click on our project, JavaWebOracleCourse, in the Projects window and select the New > Java Class item from the popup menu to open the New Java…
Continue Reading....Update and Delete Data from the Faculty Table Using JSP and Java Beans Techniques 2 – Develop Java Web Applications to Access Databases
G. A FileInputStream object, fis, is created and works as a handler of the InputStream for the updated faculty image later. H. A new File object, fimage, is also generated to convert the updated faculty image that is stored in a string variable, upFaculty[6], to a file object, and it…
Continue Reading....Modify the FacultyProcess Page to Handle Faculty Data Deleting 3 – Develop Java Web Applications to Access Databases
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....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....CHAPTER SUMMARY – Develop Java Web Applications to Access Databases
8.7 CHAPTER SUMMARY Most key techniques and knowledge in Java Web database programming are fully discussed and analyzed in this chapter with real project examples. The most popular and important techniques in Java Web database programming, such as JavaServer Pages (JSP), JavaServer Faces (JSF) and Enterprise Java Beans (EJB), are…
Continue Reading....INTRODUCTION TO JAVA WEB SERVICES – Develop Java Web Services to Access Databases
9.1 INTRODUCTION TO JAVA WEB SERVICES Web services are distributed application components that are externally useful and available. You can use them to integrate computer applications that are written in different languages and run on different platforms. Web services are language and platform independent because vendors have agreed on common…
Continue Reading....