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
documentation.
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://127.0.0.1:3306/student


Oracle - jdbc:oracle:thin:@127.0.0.1:1521:student

SqlServer –

jdbc:microsoft:sqlserver://127.0.0.1:1433;SelectMethod=Cursor;DatabaseName=student


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

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


PreparedStatement

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



CallableStatement

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

Step 4 – loop the ResultSet for your results

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

Step 5 – free the resources

rs.close();
st.close();
con.close();

Keywords: jdbc steps, jdbc drivers
                                                             

COMMENTS

Name

advance-java,2,advancejava,1,aktu entrance exam,1,aktu exam schedule,1,ASP,1,bare machine,1,base register and limit register,1,Basic Computer network questions,1,C Programming,15,C Plus Plus,1,C Programming,2,C Programming MCQ,2,C Programming Questions,2,C programming study material for gate exam,13,CBNST Program,1,Childcare,1,CJ,2,Cloud Computing,1,components of use case diagram,1,Computer architecture based questions for gate exam,11,Computer Network,3,Computer Network Study Material,4,Computer network study material for gate,2,Computer Networks,7,Computer Science Study Material for Gate,20,computer science study material for gate exam,37,content based image retrieval content based image retrieval system,1,contiguous memory allocation,2,Core Java,8,COre Java Interview Questions,1,core java interviews questions,1,cyber crime report,1,Cyber crime status,1,cybercrime and security,1,cybercrime examples,1,Data link Layer Questions,1,Data Mining,1,Data Structure Questions,1,Data Transmission Architecture,1,Data Transmission in wsn,1,DBMS,4,dbms question paper,1,DE,1,Different types of addressing modes,1,Digital Electronics,1,DS,1,dynamic linking,1,dynamic linking in memory management,1,Electroencephalogram,1,file concept in os,1,File Handling,1,file management in operating system,1,FOC,1,Fundamenatl of Computer,1,Gate 2017,5,Gate 2017 Admit card,1,Gate 2017 Exam Schedule,1,Gate 2017 Syllabus,1,gate 2018,1,gate cse study material,1,gate practice set,10,gate study material for computer science,19,Gate study material for computer science 2017,1,GatePreviousYear,1,General,3,HCL Aptitude Test,1,HR Interview Questions,1,HTML,1,Image Processing,1,Important Date of Gate 2017 Exam,1,Information Security Policy,1,internal and external fragmentation,1,JS,1,lagrange's interpolation formula,1,lagrange's interpolation formula examples,1,Looping in C,1,MComputing,1,memory fragmentation,1,memory management,1,Motivational,4,NCER,2,Numerical Techniques Lab,1,OOT,1,Operating System,8,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,17,Operating system tutorial,3,ORACLE,1,page swapping,1,paged memory allocation,1,paged memory allocation in operating system,1,paging technique of memory management .paging technique,1,paging technique of memory management program in c,1,Pointer in C,5,Process based question for gate,1,Quiz on non conventional energy resources,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,segmentation in memory management,1,segmentation in memory management in operating system,1,Servlet,1,session tracking,1,session tracking in java,1,session tracking in servlet,1,Software Engineering,7,Software Engineering baes study material for gate,1,software engineering interview questions,1,Software Quality Assurance,3,SPM,1,SQL,1,Structure in C,1,Study Material for gate Computer Science,11,swapping in memory management,1,swapping in operating system,1,TCS Code Vita,1,Technical Questions from DBMS,1,Threads concept in operating system,1,Tips to Learn Coding,1,Top 30 Core Java Interview Questions with Answer,2,top down approach,1,top down approach in programming,1,Types of operating system,1,UML,1,use case diagram explanation,1,website uses cookies,1,what is cookies website,1,What is process control block ?,1,Wireless Sensor Network,4,worst fit algorithm for memory allocation,1,XML,1,
ltr
item
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
https://2.bp.blogspot.com/-33klA0CHGgM/WlrJLFAhqRI/AAAAAAAAAls/7j7brZ-xosMzaregN0cd-N00E_TKh658ACK4BGAYYCw/s640/jdbc1.png
https://2.bp.blogspot.com/-33klA0CHGgM/WlrJLFAhqRI/AAAAAAAAAls/7j7brZ-xosMzaregN0cd-N00E_TKh658ACK4BGAYYCw/s72-c/jdbc1.png
Computer Science Junction
https://www.computersciencejunction.in/2018/03/java-database-connectivity-introduction-and-steps.html
https://www.computersciencejunction.in/
https://www.computersciencejunction.in/
https://www.computersciencejunction.in/2018/03/java-database-connectivity-introduction-and-steps.html
true
425357657003182083
UTF-8
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