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
Likes 10 Likes 10
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 course
    set up MySQL server on your machine
    create a database schema and table and load it with data
    use JDBC to connect to and query a SQL database from a JSP app
    deploy and test the connectivity from your JSP app to a database and ensure that queried data is displayed correctly
    define a class representing an entity whose details are stored in the database and which an end-user of your app will work with
    use 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 data
    execute an insert query from a Java application to add a new row of data to a SQL table
    automate the creation and population of a Java object with the useBean and setProperty tags in a JSP
    enable end-users to update existing rows in a database table via your JSP app
    allow end-users to delete rows from a database table through the UI of your JSP app
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 27s
    UP NEXT
  • Playable
    2. 
    Downloading and Installing MySQL Server
    6m 51s
  • Locked
    3. 
    Creating and Populating a Database Table
    9m 4s
    FREE ACCESS
  • Locked
    4. 
    Connecting a JSP App to a SQL Database
    12m 4s
    FREE ACCESS
  • Locked
    5. 
    Testing a JSP App's Connectivity to the Database
    3m 28s
    FREE ACCESS
  • Locked
    6. 
    Working with a Model Class
    7m 18s
    FREE ACCESS
  • Locked
    7. 
    Retrieving Single and Multiple Rows from a Table
    10m 16s
    FREE ACCESS
  • Locked
    8. 
    Displaying Data Using JSTL
    11m 24s
    FREE ACCESS
  • Locked
    9. 
    Adding New Data to a SQL Table
    8m 21s
    FREE ACCESS
  • Locked
    10. 
    Working with jsp:useBean and jsp:setProperty Tags
    9m 2s
    FREE ACCESS
  • Locked
    11. 
    Updating a Database Table via a JSP App
    11m 44s
    FREE ACCESS
  • Locked
    12. 
    Deleting Rows from a Database Table
    6m 58s
    FREE ACCESS
  • Locked
    13. 
    Course Summary
    2m 21s
    FREE ACCESS

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.

YOU MIGHT ALSO LIKE

Course Working with Spring Data JPA: The Fundamentals of Spring Data JPA
Likes 2 Likes 2  
Course Database Integration: Modeling Data Using JPA & Hibernate
Likes 3 Likes 3  
Course Working with Spring Data JPA: Custom Queries
Likes 3 Likes 3