Building Web Applications with JSP: Integrating a JSP App with a Database
Java JDK 8+
| Intermediate
- 13 videos | 1h 41m 18s
- Includes Assessment
- Earns a Badge
Discover how to connect a JSP website to a database and allow end-users to perform database operations from the web UI using this course. Learn how to set up a MySQL database, use JDBC to connect to and run queries against this database, and utilize the JSTL library in order to iterate over the data that is returned and render them on your web page. You'll also explore write operations, JSP action tags like useBean and setProperty, and implementing update and delete operations on the database. After finishing this course, you'll have the skills and knowledge to allow users of a JSP website to interact with a database.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this courseset up MySQL server on your machinecreate a database schema and table and load it with datause JDBC to connect to and query a SQL database from a JSP appdeploy and test the connectivity from your JSP app to a database and ensure that queried data is displayed correctlydefine a class representing an entity whose details are stored in the database and which an end-user of your app will work withuse JDBC objects to query for single or multiple rows in a database table
-
implement tags from the JSTL library to iterate over multiple rows of dataexecute an insert query from a Java application to add a new row of data to a SQL tableautomate the creation and population of a Java object with the useBean and setProperty tags in a JSPenable end-users to update existing rows in a database table via your JSP appallow end-users to delete rows from a database table through the UI of your JSP appsummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 27sUP NEXT
-
2.Downloading and Installing MySQL Server6m 51s
-
3.Creating and Populating a Database Table9m 4s
-
4.Connecting a JSP App to a SQL Database12m 4s
-
5.Testing a JSP App's Connectivity to the Database3m 28s
-
6.Working with a Model Class7m 18s
-
7.Retrieving Single and Multiple Rows from a Table10m 16s
-
8.Displaying Data Using JSTL11m 24s
-
9.Adding New Data to a SQL Table8m 21s
-
10.Working with jsp:useBean and jsp:setProperty Tags9m 2s
-
11.Updating a Database Table via a JSP App11m 44s
-
12.Deleting Rows from a Database Table6m 58s
-
13.Course Summary2m 21s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.