Jdbc connectivity in java

how to connect to db using jdbc

1. JDBC

2. SYNOPSIS
•What is JDBC?
•Architecture of JDBC
•Types of JDBC drivers
•Steps to connect database

3. What is JDBC
•JDBC – Java Database Connectivity
•JDBC is a standard java API for independent database
connection between a java program and wide range of
relational database
•It is present in the “java.sql” package

4. Architecture of JDBC

5. Types of JDBC driver
•Type 1: jdbc-odbc bridge driver
•Type 2: net protocols all java driver
•Type 3: native API partly java driver
•Type 4: native protocols all java driver

6. How to connect ?
•Define the connection URL
•Established the connection
•Create the statement object
•Execute a query
•Process the results
•Close the connection

7. Connection URL
•The connection URL is Class.forName();
•For jdbc-odbc bridge driver:
class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
•For oracle driver
class.forName(“oracle.jdbc.driver.OracleDriver”);
•For MySql driver
class.forName(“com.mysql.jdbc.Driver”);

8. Establishing the connection
•Connection con =
Driver.Manager.getConnection(“url”,”user_name”,”pass
word”);
•Statement stmt = con.createStatement();

9. Executing queries
•For select queries
Stmt.executeQuery(select * from tab_name);
•For insert queries
Stmt.executeQuery(insert into tab_name
values(1,”hello”));

10. Process results
ResultSet rs = stmt.executeQuery(some query);
While(rs.next())
{
System.out.println(rs.getInt(id));
System.out.println(rs.getString(name));
}

11. Close connection
•Close the connection using
Stmt.close();
Con.close();

12. Sample program