JDBC: Executing Statements
Java JDBC
| Beginner
- 14 videos | 1h 24m 16s
- Includes Assessment
- Earns a Badge
Java Database Connectivity (JDBC) offers a number of ways in which SQL queries can be executed using a number of built-in objects. This demo-based course covers the use of the fundamental JDBC objects required to set up and manage database connections from a Java app and to execute queries. You will cover the use of Properties objects to load connection details, and then the use of the Statement and PreparedStatement instances to run SELECT, INSERT, DELETE and UPDATE queries against a database from a Java app.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this courseidentify the different ways to specify connection details when connecting to a database using JDBCuse database connection details in a properties file to set up a connection to a database using JDBCadopt a DataSource object to create a Connection with a databaseexecute a SQL query to create a database table from a Java apprun a SELECT query against a database and access the returned tabular data in a JDBC ResultSet objectadd rows to a database table by running an INSERT query from a Java app
-
modify the contents of a database table from a Java app by executing UPDATE and DELETE queriesdrop a table and database from a Java apprecognize the limitations of the Statement object when several executions of similar queries are involvedoptimize the execution of similar queries by parametrizing them with PreparedStatementsrecall the types of exceptions that could occur when passing incorrect parameters to a PreparedStatementidentify some of the exceptions that could be thrown when using JDBC to work with databasessummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 19sUP NEXT
-
2.Different Ways to Connect to a Database6m 16s
-
3.Loading Connection Details from a Properties File7m 52s
-
4.Connecting to a Database with a DataSource5m 57s
-
5.Running a Query from Java8m 42s
-
6.Retrieving Query Results in a ResultSet7m 19s
-
7.Running Insert Queries from Java4m 37s
-
8.Running Update and Delete Queries6m 37s
-
9.Running Drop Queries6m 36s
-
10.Potential Inefficiencies in Statement Executions6m 58s
-
11.Using Prepared Statements7m 51s
-
12.Setting Incorrect Parameters in Statements2m 37s
-
13.Handling SQL Exceptions9m 9s
-
14.Course Summary1m 28s
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.