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: INTRODUCTION TO JAVA WEB SERVICES
Modify the FacultyProcess.jsp Page to Handle Faculty Data Collection and Insertion 2 – Develop Java Web Applications to Access Databases
At this point, we have finished all code development for this data manipulation or data insertion action to the Faculty Table in our sample Oracle database. Prior to building and running this Web application, make sure that the new faculty image to be selected and inserted into our database has…
Continue Reading....Modify the FacultyProcess Page to Handle Faculty Data Updating 2 – Develop Java Web Applications to Access Databases
Now we can build and run our project to test this faculty record update function. Click on the Clean and Build Main Project button to clean up and build our project. Then click on the Run button to run our project. Enter the appropriate username and password, such as jhenry…
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 – 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 – 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 – 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 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....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....