JDBC Tutorial : JDBC Drivers and Steps for Java Database Connectivity

Makar Sankranti. Lohri, Makar Sankranti Puja,Wi-Fi Alliance,difference between jdbc and odbc,jdbc steps

JDBC ( Java Database Connectivity) Tutorial

JDBC is known as java database connectivity. To connect java with any database we require a jdbc driver which implements all the interfaces provided in sql package. Java provides jdbc-odbc bridge driver.

what is jdbc
Figure 1: Java Application Interaction with Database

JDBC uses ODBC drivers available on your machine. DB Vendor provides its own driver. To use them set driver (.jar) into class path/install them into your machine.
Package required - java.sql. In this package most of them are interfaces.

Types of Driver

Different types of drivers are as shown in figure 2.

learn jdbc

Figure 2: Driver types

 Driver Type 1:

what are jdbc drivers

Figure 3: Type 1 Driver

In type 1 driver JDBC ODBC Bridge Translates all JDBC calls into ODBC calls and send them to ODBC Driver.

 Driver Type 2:

learn jdbc driver

Figure 4: Type 2 Driver

The Native API or Partially java driver converts jdbc calls into database specific calls for databases such as SQL server, Oracle and Sybase. Type 2 Driver communicate directly with database server.

 Driver Type 3:

                                                            learn jdbc steps 

Figure 5: Type 3 Driver

 Driver Type 4: 

steps for jdbc

Figure 6: Type 4 Driver

The native-protocol/all-Java driver converts JDBC calls into the vendor specific database management system (DBMS) protocol so that client applications can communicate directly with the database server. Level 4 drivers are completely implemented in Java to achieve platform independence and eliminate deployment administration issues.

Steps for java database connectivity:

Following steps are used to connect a java application with database.

Step 0 – Create an ODBC DSN (Data Source Name)

Step 1 – load the driver

Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); //for JDBC-ODBC Bridge
Note: - if not using odbc then you will load vendor specific driver class. Check driver
MySql - Class.forName ("org.gjt.mm.mysql.Driver");
Oracle - Class.forName ("oracle.jdbc.driver.OracleDriver");
SqlServer - Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver");

Step 2 – create a connection

Connection conn = DriverManager.getConnection(“jdbcURL”,”username”,”password”);
jdbcURL - jdbc::
E.g. – jdbc:odbc:dsnName

Where dsnName is the data source name that you have created earlier.

Note :- If you are not going through odbc then you have to provide the host string.

E.g. –

MySql - jdbc:mysql://

Oracle - jdbc:oracle:thin:@

SqlServer –


Step 3 – create a statement for executing your database transactions.

Three types of statement can be used  Statement, PreparedStatement and CallableStatement. Here we are explaining syntax for each type.


Statement st = con.createStatement();
ResultSet rs = st.executeQuery(“select * from emp”);
int i = st.executeUpdate(“insert into college(name) values(‘ITS’)”);


PreparedStatement pst = con.preapareStatement(“select * from emp where name = ? and dept = ?”);
ResultSet rs = st.executeQuery();


CallableStatement cstmt = con.prepareCall ("{call getDailyTotal (?, ?)}");
cstmt.setString (1, "Mon");
cstmt.registerOutParameter (2, java.sql.Types.INTEGER);
System.out.println ("Total is " + cstmt.getInt (2));

Step 4 – loop the ResultSet for your results

System.out.println(“Emp Name is : ”+rs.getString(“name”));

Step 5 – free the resources


Keywords: jdbc steps, jdbc drivers



addressing modes types,1,advance-java,2,aktu entrance exam,1,aktu exam schedule,1,ASP,1,bare machine,1,base register and limit register,1,C Programming,12,C Plus Plus,1,C Programming,5,C Programming Questions,1,C programming study material for gate exam,7,Cache Memory,1,CBNST Program,1,Childcare,1,CJ,1,Cloud Computing,1,CN,2,Computer Architecture,2,Computer architecture based questions for gate exam,11,Computer Network,8,Computer Network Study Material,2,Computer network study material for gate,1,Computer Networks,8,Computer networks GATE Questions,1,Computer Science Study Material for Gate,14,computer science study material for gate exam,28,contiguous memory allocation,2,Core Java,3,cyber crime report,1,Cyber crime status,1,cybercrime and security,1,cybercrime examples,1,Data Structure,2,Data Structure Questions,1,Data Transmission Architecture,1,Data Transmission in wsn,1,DBMS,5,dbms question paper,1,DE,1,Digital Electronics,1,DS,4,Dynamic memory allocation in c,1,Electroencephalogram,1,file management in operating system notes,1,Gate 2017,5,Gate 2017 Admit card,1,Gate 2017 Exam Schedule,1,Gate 2017 Syllabus,1,gate cse study material,1,gate practice set,7,gate study material for computer science,12,Gate study material for computer science 2017,1,General,3,HCL Aptitude Test,1,HR Interview Questions,1,HTML,4,Important Date of Gate 2017 Exam,1,Information Security Policy,1,internal and external fragmentation,1,JDBC,2,JS,1,lagrange's interpolation formula,1,lagrange's interpolation formula examples,1,memory fragmentation,1,memory management,1,memory management questions and answer in os,1,Motivational,4,NCER,1,Numerical Techniques Lab,1,OOT,1,Operating System,10,Operating System Gate Questions,1,Operating System Objective Questions,4,Operating System Questions Bank,1,Operating system questions for gate,1,Operating System Study material,2,operating system study material for gate exam,13,Operating system tutorial,2,page swapping,1,paged memory allocation,1,paged memory allocation in operating system,1,Pointer in C,4,Process based question for gate,1,Regression testing,1,relocation in memory management,1,relocation registe,1,relocation register,1,resident monitor,1,resident monitor in operating system,1,routing table,1,Software Engineering,10,Software Engineering baes study material for gate,1,Software Quality Assurance,3,software verification methods,1,Stack,1,Structure in C,1,Study Material for gate Computer Science,7,swapping in memory management,1,swapping in operating system,1,TCS Code Vita,1,TCS Interview Questions,1,Technical Interview,1,Technical Questions from DBMS,1,Thrashing in Operating System,1,Threads concept in operating system,1,Tips to Learn Coding,1,Types of operating system,1,UML,1,What is process control block ?,1,what is software testing?,1,Wireless Sensor Network,3,worst fit algorithm for memory allocation,1,XML,2,
Computer Science Junction: JDBC Tutorial : JDBC Drivers and Steps for Java Database Connectivity
JDBC Tutorial : JDBC Drivers and Steps for Java Database Connectivity
Makar Sankranti. Lohri, Makar Sankranti Puja,Wi-Fi Alliance,difference between jdbc and odbc,jdbc steps
Computer Science Junction
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share. STEP 2: Click the link you shared to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy