9.14.4.4 Create and Build the Web Operation InsertCourse() One issue to be noted to perform the new course insert action against our sample database is that we need to perform two queries for this operation, 1) query the Faculty Table to get the desired fac-ulty _ id based on the input faculty _ name, and […]
Posts
Create and Build the Web Operation UpdateCourse() 2 – Develop Java Web Services to Access Databases
A. Some local variables, such as an instance of ResultSet, rs; a blank string, fid; and an inte-ger variable, numUpdate, are declared since we need to use them to hold our query results. B. A try-catch block is used to do our first query for the Faculty Table to get a desired faculty _ id […]
Create and Build the Web Operation UpdateCourse() – Develop Java Web Services to Access Databases
9.14.4.5 Create and Build the Web Operation UpdateCourse() Perform the following operations to add a new operation, UpdateCourse(), into our Web service project to perform a course update query: 1) Double-click on our Web service main class file, WebServiceCourse.java, from the Projects window to open it.2) Click on the Design button at the top of […]
Create and Build the Web Operation DeleteCourse() – Develop Java Web Services to Access Databases
9.14.4.6 Create and Build the Web Operation DeleteCourse()Perform the following operations to add a new operation, DeleteCourse(), into our Web service project to perform the course delete query: 1) Double-click on our Web service main class file, WebServiceCourse.java, from the Projects window to open it.2) Click on the Design button at the top of the […]
BUILD WINDOWS-BASED PROJECT TO CONSUME THE WEB SERVICE PROJECT – Develop Java Web Services to Access Databases
9.15 BUILD WINDOWS-BASED PROJECT TO CONSUME THE WEB SERVICE PROJECT To consume our Web Service project, we need to build some Windows-based projects to call differ-ent operations to perform related actions to our database. To save time and space, we can use two of our projects, WinClientFaculty _ Select, which was built in Section 9.6, […]
Update the Web Service Reference for Our Window-Based Client Project – Develop Java Web Services to Access Databases
9.15.1 Update the Web Service Reference for Our Window-Based Client Project Prior to any code development, we need first to update our Web Service Reference to enable our cli-ent project to use the correct Web Service. Perform the following operations to set up a Web service reference for our client project: 1) Build and deploy […]
Build Code for the Select Button Event Handler to Query CourseIDs – Develop Java Web Services to Access Databases
9.15.3 Build Code for the Select Button Event Handler to Query CourseIDs The function of this method is to query all course _ id taught by the selected faculty member when the Select button is clicked by the user. The queried result will be added and displayed in the Course ID List box in this […]
Build Code for the CourseListValueChanged() Method to Get Course Details 2 – Develop Java Web Services to Access Databases
E. Before we can proceed to the course query operation, first we need to confirm that the selected courseid is not a null value. A null value would be returned if the user did not select any course _ id from the CourseList box but just clicked on the Select button to try to find […]
Build Code for the CourseListValueChanged() Method to Get Course Details – Develop Java Web Services to Access Databases
9.15.4 Build Code for the CourseListValueChanged() Method to Get Course Details The function of this method is that when users click a course _ id from the Course ID List box, the detailed course information, including the course title, credit, classroom, schedule and enrollment for the selected course _ id, will be retrieved and displayed […]