310 likes | 327 Views
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>
E N D
Agenda What is JDBC? Need of JDBC Datatypes in JDBC JDBC Architecture JDBC Environment Setup Steps to Connect JDBC JDBC Example
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
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
Need for JDBC Establishing database connectivity. To Execute MySQL queries and DDL/DML commands. View and Modify data records.
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.
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
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
JDBC Architecture Application JDBC API JDBC Manager JDBC Drivers Source SQL Server Oracle DB
JDBC Architecture Application JDBC API JDBC Manager JDBC Drivers Source SQL Server Oracle DB
JDBC Environment Setup Setting up Java Environment: Download the Latest JDK Set Java_Home Set Java Path Java Environment Setup
JDBC Environment Setup Setting up MySQL Environment: Download the Latest MySQL Workbench Extract the file Run the Setup file. MySQL Environment Setup
JDBC Environment Setup Setting up MySQL Environment: Download the Latest MySQL Workbench Extract the file Run the Setup file. MySQL Environment Setup
Steps to Connect JDBC This procedure is followed to make sure the relevant packages are readily available for the API Step 1 Import Packages
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
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
Steps to Connect JDBC Here, we write in the SQL command or Query that we need to execute. Step 4 Writing a Query
Steps to Connect JDBC Now the Query from the API is executed using executeQuery() Step 5 Executing Query
Steps to Connect JDBC After step five, the system basically does two things: Process Output Retrieve values Step 6 Processing Result
Steps to Connect JDBC The resultSet and statement needs to be closed explicitly. Step 7 Closing Statement
Steps to Connect JDBC The last stage is to disconnect ourselves or the API from the Database Step 8 Closing Connection
JDBC Example University Database