JDBC: Executing Statements

Java JDBC    |    Beginner
  • 14 videos | 1h 24m 16s
  • Includes Assessment
  • Earns a Badge
Likes 10 Likes 10
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 course
    identify the different ways to specify connection details when connecting to a database using JDBC
    use database connection details in a properties file to set up a connection to a database using JDBC
    adopt a DataSource object to create a Connection with a database
    execute a SQL query to create a database table from a Java app
    run a SELECT query against a database and access the returned tabular data in a JDBC ResultSet object
    add 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 queries
    drop a table and database from a Java app
    recognize the limitations of the Statement object when several executions of similar queries are involved
    optimize the execution of similar queries by parametrizing them with PreparedStatements
    recall the types of exceptions that could occur when passing incorrect parameters to a PreparedStatement
    identify some of the exceptions that could be thrown when using JDBC to work with databases
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 19s
    UP NEXT
  • Playable
    2. 
    Different Ways to Connect to a Database
    6m 16s
  • Locked
    3. 
    Loading Connection Details from a Properties File
    7m 52s
    FREE ACCESS
  • Locked
    4. 
    Connecting to a Database with a DataSource
    5m 57s
    FREE ACCESS
  • Locked
    5. 
    Running a Query from Java
    8m 42s
    FREE ACCESS
  • Locked
    6. 
    Retrieving Query Results in a ResultSet
    7m 19s
    FREE ACCESS
  • Locked
    7. 
    Running Insert Queries from Java
    4m 37s
    FREE ACCESS
  • Locked
    8. 
    Running Update and Delete Queries
    6m 37s
    FREE ACCESS
  • Locked
    9. 
    Running Drop Queries
    6m 36s
    FREE ACCESS
  • Locked
    10. 
    Potential Inefficiencies in Statement Executions
    6m 58s
    FREE ACCESS
  • Locked
    11. 
    Using Prepared Statements
    7m 51s
    FREE ACCESS
  • Locked
    12. 
    Setting Incorrect Parameters in Statements
    2m 37s
    FREE ACCESS
  • Locked
    13. 
    Handling SQL Exceptions
    9m 9s
    FREE ACCESS
  • Locked
    14. 
    Course Summary
    1m 28s
    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

Journey Javanista to Java Master
Likes 109 Likes 109  
Book Mastering Java Persistence API (JPA): Realize Java's Capabilities Spanning RDBMS, ORM, JDBC, Caching, Locking, Transaction Management, and JPQL
Course Java Database Connectivity (JDBC): Interacting with Databases using RowSets
Likes 10 Likes 10  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course FSD Development: Java Spring Framework
Likes 109 Likes 109  
Course The Spring Web MVC Framework: Getting Started
Likes 81 Likes 81  
Course Contributing as a Virtual Team Member
Likes 2832 Likes 2832