1 / 31

Java JDBC tutorial - Java Database Connectivity | Java Tutorial For Beginners | Simplilearn

This JDBC presentation will help you understand the fundamentals of JDBC and provide you with a practical explanation for a better understanding of this Connector. In the current IT world, there is a never-ending process of information exchange between the data sources and applications. JDBC acts as the most reliable, stable, and strong Connecting Driver currently available. Having a better understanding of JDBC would be an added advantage.<br><br>About Simplilearn Java certification training course:<br>If youu2019re looking to master web application development for virtually any computing platform, this Java Certification Training course is for you. This all-in-one Java training will give you a firm foundation in Java, the most commonly used programming language in software development.<br><br>This advanced Java Certification Training course is designed to guide you through the concepts of Java from introductory techniques to advanced programming skills. The course will provide you with the knowledge of Core Java 8, operators, arrays, loops, methods, and constructors while giving you hands-on experience in JDBC and JUnit framework.<br><br>Java Certification Course Key Features:<br>1. 70 hours of blended training<br>2. Hands-on coding and implementation of two web-based projects<br>3. Includes Hibernate and Spring frameworks<br>4. 35 coding-related exercises on Core Java 8<br>5. Lifetime access to self-paced learning<br>6. Flexibility to choose classes<br><br>Eligibility:<br>Simplilearnu2019s Java Certification Training course is ideal for software developers, web designers, programming enthusiasts, engineering graduates, and students or professionals who wish to become Java developers.<br><br>Pre-requisites:<br>Prior knowledge of Core Java is a prerequisite to taking this advanced Java Certification training course. Our Core Java online self-paced course is available for free to become familiar with the basics of Java programming.<br><br>ud83dudc49Learn more at: https://bit.ly/3b6SCvp<br>

Simplilearn
Download Presentation

Java JDBC tutorial - Java Database Connectivity | Java Tutorial For Beginners | Simplilearn

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Agenda What is JDBC? Need of JDBC Datatypes in JDBC JDBC Architecture JDBC Environment Setup Steps to Connect JDBC JDBC Example

  2. What is JDBC?

  3. Click here to watch the video

  4. What is JDBC? JDBC is a tool or an application programming interface that establishes a connection between a standard Database and Java application that intends to use that database

  5. What is JDBC? JDBC is a tool or an application programming interface that establishes a connection between a standard Database and Java application that intends to use that database

  6. Need for JDBC

  7. Need for JDBC Establishing database connectivity. To Execute MySQL queries and DDL/DML commands. View and Modify data records.

  8. Need for JDBC Establishing database connectivity. To write MySQL statements. To write DDL and DML commands  To Execute MySQL queries and DDL/DML commands. View and Modify data records.

  9. Datatypes in JDBC

  10. Datatypes in JDBC Java SQL java.lang.String VARCHAR boolean BIT NUMERIC Java.math.BigDecimal int INTEGER float REAL float FLOAT double DOUBLE byte[] BINARY java.sql.Date DATE

  11. Datatypes in JDBC Java/JDBC SQL java.sql.Timestamp TIMESTAMP java.sql.Array ARRAY java.sql.Ref REF java.sql.Struct STRUCT java.lang.String CHAR long BIGINT byte[] VARBINARY java.sql.Clob CLOB java.sql.Blob BLOB

  12. JDBC Architecture

  13. JDBC Architecture Application JDBC API JDBC Manager JDBC Drivers Source SQL Server Oracle DB

  14. JDBC Architecture Application JDBC API JDBC Manager JDBC Drivers Source SQL Server Oracle DB

  15. JDBC Environment Setup

  16. JDBC Environment Setup Setting up Java Environment: Download the Latest JDK Set Java_Home Set Java Path Java Environment Setup

  17. JDBC Environment Setup Setting up MySQL Environment: Download the Latest MySQL Workbench Extract the file Run the Setup file. MySQL Environment Setup

  18. JDBC Environment Setup Setting up MySQL Environment: Download the Latest MySQL Workbench Extract the file Run the Setup file. MySQL Environment Setup

  19. Steps to Connect JDBC

  20. Steps to Connect JDBC This procedure is followed to make sure the relevant packages are readily available for the API Step 1 Import Packages

  21. Steps to Connect JDBC The imported drivers needs to be loaded and registered for establishing a connection between application and Database Step 2 Load and Register Driver

  22. Steps to Connect JDBC After the first two steps, the next stage is to connect the data base. This can be done by getConnection(). Step 3 Connecting Database

  23. Steps to Connect JDBC Here, we write in the SQL command or Query that we need to execute. Step 4 Writing a Query

  24. Steps to Connect JDBC Now the Query from the API is executed using executeQuery() Step 5 Executing Query

  25. Steps to Connect JDBC After step five, the system basically does two things: Process Output Retrieve values Step 6 Processing Result

  26. Steps to Connect JDBC The resultSet and statement needs to be closed explicitly. Step 7 Closing Statement

  27. Steps to Connect JDBC The last stage is to disconnect ourselves or the API from the Database Step 8 Closing Connection

  28. JDBC Example

  29. JDBC Example University Database

More Related