If you are not sure if the website you would like to visit is secure, you can verify it here. Enter the website address of the page and see parts of its content and the thumbnail images on this site. None (if any) dangerous scripts on the referenced page will be executed. Additionally, if the selected site contains subpages, you can verify it (review) in batches containing 5 pages.
favicon.ico: dineshonjava.com/java-database-connectivityjdbc-tutorial - Java Database Connectivity(JDB.

site address: dineshonjava.com/java-database-connectivityjdbc-tutorial redirected to: dineshonjava.com/java-database-connectivityjdbc-tutorial

site title: Java Database Connectivity(JDBC) Tutorial - Dinesh on Java

Our opinion (on Thursday 19 November 2026 11:45:38 UTC):

GREEN status (no comments) - no comments
After content analysis of this website we propose the following hashtags:


page from cache: 8 hours ago
Meta tags:
author=;

Headings (most frequently used words):

driver, advantages, disadvantages, java, database, jdbc, connectivity, protocol, tutorial, drivers, native, api, network, middleware, pure, basics, steps, types, share, this, about, the, author, comments, dinesh, rajput,

Text of the page (most frequently used words):
the (60), spring (44), database (37), java (35), jdbc (35), #driver (34), and (33), tutorial (21), interview (20), odbc (16), connection (12), for (11), new (10), sql (10), statement (10), dinesh (9), that (9), client (9), boot (8), design (8), native (8), class (8), can (8), drivers (8), protocol (8), web (7), microservices (7), api (7), core (7), are (7), share (7), connectivity (7), into (7), calls (7), bridge (7), jax (6), with (6), 2015 (6), opens (6), window (6), string (6), type (6), middleware (6), security (5), aop (5), hibernate (5), system (5), this (5), you (5), object (5), implementation (5), mvc (4), cloud (4), soap (4), services (4), patterns (4), use (4), february (4), rajput (4), from (4), has (4), different (4), technology (4), sun (4), result1 (4), out (4), println (4), step (4), execute (4), disadvantages (4), advantages (4), also (4), known (4), converts (4), vendor (4), pure (4), struts (3), rest (3), batch (3), development (3), application (3), architecture (3), model (3), registration (3), example (3), which (3), user (3), developer (3), working (3), these (3), when (3), then (3), technologies (3), since (3), than (3), jdbcodbcdriver (3), drivermanager (3), createstatement (3), close (3), method (3), callablestatement (3), statements (3), preparedstatement (3), need (3), network (3), may (3), server (3), there (3), not (3), installed (3), types (3), data (3), privacy (2), policy (2), who (2), training (2), service (2), linux (2), git (2), thymeleaf (2), mongo (2), ant (2), gradle (2), maven (2), build (2), tools (2), ajax (2), hadoop (2), mail (2), jstl (2), jsp (2), servlet (2), j2ee (2), computing (2), wsdl (2), questions (2), tutorials (2), search (2), hateoas (2), mobile (2), certification (2), monitoring (2), testing (2), performance (2), react (2), learn (2), solve (2), common (2), problems (2), thanks (2), surjeet (2), where (2), want (2), action (2), dao (2), exist (2), plz (2), send (2), simple (2), some (2), email (2), used (2), help (2), how (2), january (2), comments (2), technical (2), related (2), author (2), pattern (2), his (2), latest (2), framework (2), creating (2), company (2), first (2), about (2), pinterest (2), telegram (2), whatsapp (2), linkedin (2), facebook (2), forname (2), getconnection (2), getstring (2), catch (2), once (2), done (2), using (2), calling (2), call (2), stored (2), procedure (2), returns (2), objects (2), precompiled (2), queries (2), without (2), parameters (2), url (2), password (2), open (2), requests (2), platform (2), directly (2), specific (2), between (2), library (2), middle (2), tier (2), machine (2), side (2), oracle (2), overhead (2), any (2), provides (2), source (2), one (2), relational (2), copyright, 2026, hands, engineer, guide, continuous, let, full, stack, designing, applications, various, them, best, practices, learning, alot, contents, here, loose, coupling, must, separetly, vikas, good, hello, project, voice, based, codes, perfectly, bec, hava, problm, attachment, show, file, frame, downloaded, recieve, uzma, chief, editor, website, dineshonjava, blog, dedicated, series, articles, been, enthusiast, 2008, pivotal, certified, professional, book, blogger, more, years, experience, aspects, expertise, lies, version, apis, microservice, reactive, cassandra, mongodb, currently, manager, leading, product, worked, tech, lead, bennett, coleman, ltd, was, previous, paytm, passionate, loves, write, blogs, very, active, member, community, forums, comes, tops, list, import, testretrieve, public, static, void, main, args, try, mydsn, resultset, executequery, select, emp, while, next, sqlexception, exception, should, like, closing, preparecall, callable, preparestatement, prepared, creates, obtained, interact, test, opening, thing, before, load, loading, basics, steps, dependent, vendors, widely, usually, proprietary, protocols, don, translate, intermediary, format, such, completely, implemented, achieve, independence, schematic, direct, layer, added, result, additional, latency, but, typically, overcome, better, communication, independent, changed, makes, program, indirectly, needs, its, considerably, faster, uses, libraries, oci, have, through, interface, thus, slower, other, almost, accessed, retrieved, code, closed, employs, connect, function, fit, four, categories, commercial, free, available, most, servers, fall, following, adapters, convert, programs, dbms, understand, standard, edition, corporation, programming, language, defines, access, methods, querying, updating, oriented, towards, databases, enables, connections, accessible, jvm, host, environment, home,


Text of the page (random words):
java database connectivity jdbc tutorial dinesh on java core java core java java 8 certification interview q a spring boot spring spring core spring aop spring mvc spring security microservices spring 4 spring 5 spring batch spring mobile spring hateoas hibernate hibernate search tutorials design patterns web services ws interview questions jax ws soap jax rs rest wsdl soap cloud computing struts 2 tutorial j2ee tutorial servlet tutorial jsp tutorial jstl tutorial jdbc tutorial jax b tutorial java mail api hadoop tutorial ajax tutorial build tools maven gradle ant mongo db thymeleaf git linux interview q a spring interview aop interview mvc interview spring boot interview microservices interview spring security interview web service interview training who i am privacy policy home jdbc java database connectivity jdbc tutorial january 27 2015 5 comments java database connectivity jdbc tutorial java database connectivity jdbc is a java database connectivity technology java standard edition platform from oracle corporation this technology is an api for the java programming language that defines how a client may access a database it provides methods for querying and updating data in a database jdbc is oriented towards relational databases a jdbc to odbc bridge enables connections to any odbc accessible data source in the jvm host environment jdbc drivers jdbc drivers are client side adapters installed on the client machine not on the server that convert requests from java programs to a protocol that the dbms can understand types there are commercial and free drivers available for most relational database servers these drivers fall into one of the following types jdbc technology drivers fit into one of four categories 1 jdbc odbc bridge 2 native api driver 3 network protocol driver middleware driver 4 database protocol driver pure java driver 1 jdbc odbc bridge the jdbc type 1 driver also known as the jdbc odbc bridge is a database driver implementation that employs the odbc driver to connect to the database the driver converts jdbc method calls into odbc function calls sun provides a jdbc odbc bridge driver sun jdbc odbc jdbcodbcdriver this driver is native code and not java and is closed source advantages almost any database for which an odbc driver is installed can be accessed and data can be retrieved disadvantages performance overhead since the calls have to go through the jdbc overhead bridge to the odbc driver then to the native db connectivity interface thus may be slower than other types of drivers 2 native api driver the jdbc type 2 driver also known as the native api driver is a database driver implementation that uses the client side libraries of the database the driver converts jdbc method calls into native calls of the database api for example oracle oci driver is a type 2 driver advantages as there is no implementation of jdbc odbc bridge its considerably faster than a type 1 driver disadvantages the vendor client library needs to be installed on the client machine 3 network protocol driver middleware driver the jdbc type 3 driver also known as the pure java driver for database middleware is a database driver implementation which makes use of a middle tier between the calling program and the database the middle tier application server converts jdbc calls directly or indirectly into the vendor specific database protocol advantages since the communication between client and the middleware server is database independent there is no need for the database vendor library on the client the client need not be changed for a new database disadvantages the middleware layer added may result in additional latency but is typically overcome by using better middleware services 4 database protocol driver pure java driver schematic of the native protocol driver the jdbc type 4 driver also known as the direct to database pure java driver is a database driver implementation that converts jdbc calls directly into a vendor specific database protocol advantages completely implemented in java to achieve platform independence these drivers don t translate the requests into an intermediary format such as odbc disadvantages drivers are database dependent as different database vendors use widely different and usually proprietary network protocols jdbc basics java database connectivity steps step 1 loading a database driver the first thing you need to do before you can open a database connection is to load the jdbc driver for the database class forname sun jdbc odbc jdbcodbcdriver step 2 opening the connection to open a database connection you use the java sql drivermanager class string url jdbc h2 test string user sa string password connection connection drivermanager getconnection url user password step 3 creating a jdbc statement object once a connection is obtained we can interact with the database statement statement connection createstatement a statement object is used to send and execute sql statements to a database statement execute simple sql queries without parameters statement createstatement creates an sql statement object prepared statement execute precompiled sql queries with or without parameters preparedstatement preparestatement string sql returns a new preparedstatement object preparedstatement objects are precompiled sql statements callable statement execute a call to a database stored procedure callablestatement preparecall string sql returns a new callablestatement object callablestatement objects are sql stored procedure call statements step 4 closing the connection once you are done using the database connection you should close it this is done by calling the connection close method like this connection close example import java sql class testretrieve public static void main string args try class forname sun jdbc odbc jdbcodbcdriver connection c drivermanager getconnection jdbc odbc mydsn statement s c createstatement resultset result1 s executequery select from emp while result1 next system out println result1 getstring 1 system out println result1 getstring 2 catch sqlexception e system out println e catch exception i system out println i share this share on facebook opens in new window facebook share on x opens in new window x share on linkedin opens in new window linkedin share on whatsapp opens in new window whatsapp share on telegram opens in new window telegram share on pinterest opens in new window pinterest jdbc about the author dinesh rajput dinesh rajput is the chief editor of a website dineshonjava a technical blog dedicated to the spring and java technologies it has a series of articles related to java technologies dinesh has been a spring enthusiast since 2008 and is a pivotal certified spring professional an author of a book spring 5 design pattern and a blogger he has more than 10 years of experience with different aspects of spring and java design and development his core expertise lies in the latest version of spring framework spring boot spring security creating rest apis microservice architecture reactive pattern spring aop design patterns struts hibernate web services spring batch cassandra mongodb and web application design and architecture he is currently working as a technology manager at a leading product and web development company he worked as a developer and tech lead at the bennett coleman co ltd and was the first developer in his previous company paytm dinesh is passionate about the latest java technologies and loves to write technical blogs related to it he is a very active member of the java and spring community on different forums when it comes to the spring framework and java dinesh tops the list 5 comments uzma january 28 2015 hello dinesh i m new in java and i m working on project that is voice based email system in java i used ur codes these are perfectly working i want some help from u bec i hava a problm that is when an email has an attachment then how can show file on the frame that can be downloaded when we recieve it if u can help then plz do some developer february 3 2015 simple and good vikas february 5 2015 where is model here and where is loose coupling i want registration example in which action class dao class and model class must exist separetly i e registration action registration dao user model class exist plz send surjeet rajput february 12 2015 thanks alot for contents dinesh rajput february 12 2015 thanks surjeet for learning with us learn various design patterns and best practices and use them to solve common design problems learn spring boot 2 0 and spring cloud application microservices architecture to solve common cloud native problems designing applications with spring boot 2 2 and react js let us full stack development with spring boot and react js hands on microservices monitoring and testing a performance engineer s guide to the continuous testing and monitoring of microservices dinesh on java copyright 2026 core java core java java 8 certification interview q a spring boot spring spring core spring aop spring mvc spring security microservices spring 4 spring 5 spring batch spring mobile spring hateoas hibernate hibernate search tutorials design patterns web services ws interview questions jax ws soap jax rs rest wsdl soap cloud computing struts 2 tutorial j2ee tutorial servlet tutorial jsp tutorial jstl tutorial jdbc tutorial jax b tutorial java mail api hadoop tutorial ajax tutorial build tools maven gradle ant mongo db thymeleaf git linux interview q a spring interview aop interview mvc interview spring boot interview microservices interview spring security interview web service interview training who i am privacy policy
Images from subpage: "dineshonjava.com/java-database-connectivityjdbc-tutorial/?sh... " Verify
Images from subpage: "dineshonjava.com/author/dinesh-mca-jssgmail-com/" Verify

Verified site has: 57 subpage(s). Do you want to verify them? Verify pages:

1-5 6-10 11-15 16-20 21-25 26-30 31-35 36-40 41-45 46-50
51-55 56-57


The site also has 2 references to external domain(s).

 dineshrajput.com  Verify  amazon.in  Verify


Top 50 hastags from of all verified websites.

Supplementary Information (add-on for SEO geeks)*- See more on header.verify-www.com

Header

HTTP/1.1 301 Moved Permanently
Date Thu, 19 Nov 2026 03:01:42 GMT
Content-Type text/html
Content-Length 795
Connection close
location htt????/dineshonjava.com/java-database-connectivityjdbc-tutorial
platform hostinger
panel hpanel
content-security-policy upgrade-insecure-requests
Server hcdn
alt-svc h3= :443 ; ma=86400
x-hcdn-request-id f28b9e2f8593df465160d32831c4af9b-int-edge10
x-hcdn-cache-status MISS
x-hcdn-upstream-rt 0.134
HTTP/2 301
date Thu, 19 Nov 2026 03:01:42 GMT
content-type text/html; charset=UTF-8
content-length 0
location htt????/dineshonjava.com/java-database-connectivityjdbc-tutorial/
x-powered-by PHP/8.3.36
expires Sun, 15 Nov 2026 00:38:34 GMT
cache-control max-age=3600
x-redirect-by WordPress
x-litespeed-cache hit
platform hostinger
panel hpanel
content-security-policy upgrade-insecure-requests
x-endurance-cache-level 2
x-nginx-cache WordPress
server hcdn
alt-svc h3= :443 ; ma=86400
x-hcdn-request-id 62a2ec6be990e9a59c5b6cdf923c4400-int-edge7
x-hcdn-cache-status MISS
x-hcdn-upstream-rt 0.153
HTTP/2 200
date Thu, 19 Nov 2026 03:01:42 GMT
content-type text/html; charset=UTF-8
vary Accept-Encoding
x-powered-by PHP/8.3.36
link <htt????/dineshonjava.com/wp-json/>; rel= htt????/api.w.org/
link <htt????/dineshonjava.com/wp-json/wp/v2/posts/166>; rel= alternate ; title= JSON ; type= application/json
link <htt????/wp.me/p94H1c-2G>; rel=shortlink
etag 94-1794699517;gz
x-litespeed-cache hit
content-encoding gzip
platform hostinger
panel hpanel
content-security-policy upgrade-insecure-requests
x-endurance-cache-level 2
x-nginx-cache WordPress
age 1737
server hcdn
alt-svc h3= :443 ; ma=86400
x-hcdn-request-id 0471db55a07f6bbc5d3eb2593c8bb825-int-edge7
x-hcdn-cache-status HIT

Meta Tags

title="Java Database Connectivity(JDBC) Tutorial - Dinesh on Java"
charset="UTF-8"
name="msapplication-TileImage" content="htt????/i0.wp.com/dineshonjava.com/wp-content/uploads/2017/08/favicon.png?fit=177%2C106&ssl=1"
name="viewport" content="width=device-width, initial-scale=1"
name="apple-mobile-web-app-capable" content="yes"
name="apple-mobile-web-app-status-bar-style" content="black"
itemprop="name" content="Dinesh on Java"
itemprop="url" content="htt????/dineshonjava.com"
itemprop="creator accountablePerson" content="Dinesh Rajput"
name="robots" content="index, follow, max-image-preview:large, max-snippet:-1, max-video-preview:-1"
property="og:locale" content="en_US"
property="og:type" content="article"
property="og:title" content="Java Database Connectivity(JDBC) Tutorial - Dinesh on Java"
property="og:description" content="Java Database Connectivity JDBC is a Java database connectivity technology (Java Standard Edition platform) from Oracle Corporation. This technology is an API for the Java programming language that defines how a client may access a database. It provides methods for querying and updating data in a database. JDBC is oriented towards relational databases. A JDBC-to-ODBC bridge enables connections to any ODBC-accessible data source in the JVM host environment. JDBC drivers: JDBC drivers are client-side adapters (installed on the client machine, not on the server) that convert requests from Java programs to a protocol that the DBMS can understand. Types: There are"
property="og:url" content="htt????/dineshonjava.com/java-database-connectivityjdbc-tutorial/"
property="og:site_name" content="Dinesh on Java"
property="article:publisher" content="htt????/www.facebook.com/thedineshonjava/"
property="article:author" content="htt????/www.facebook.com/thedineshonjava/"
property="article:published_time" content="2015-01-27T13:22:00+00:00"
property="article:modified_time" content="2018-01-07T19:41:57+00:00"
property="og:image" content="htt????/i1.wp.com/dineshonjava.com/wp-content/uploads/2015/01/jdbc-tutorial.jpg?fit=315%2C456&ssl=1"
property="og:image:width" content="315"
property="og:image:height" content="456"
property="og:image:type" content="image/jpeg"
name="author" content="Dinesh Rajput"
name="twitter:card" content="summary_large_image"
name="twitter:creator" content="@dineshonjava"
name="twitter:site" content="@dineshonjava"
name="twitter:label1" content="Written by"
name="twitter:data1" content="Dinesh Rajput"
name="twitter:label2" content="Est. reading time"
name="twitter:data2" content="4 minutes"
name="generator" content="AMP for WP 1.1.20"
name="generator" content="WordPress 7.1.4"
name="msapplication-TileImage" content="htt????/i0.wp.com/dineshonjava.com/wp-content/uploads/2017/08/favicon.png?fit=177%2C106&ssl=1"

Load Info

page size101573
load time (s)1.367473
redirect count2
speed download17346
server IP 147.79.119.202
* all occurrences of the string "http://" have been changed to "htt???/"