Aspire     Java Novice to Javanista     Java Novice to Javanista Track 3: Javanista

---

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.

---

---

Objectives

Building Web Applications with JSP: Integrating a JSP App with a Database 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