Steps for JDBC program:

1.Register driver:
Register a particular driver to the application by using java.lang.Class class’s forName() method.
Driver md=new oracle.jdbc.driver.OracleDriver();

2.Creating Connection:
A connection created by using getConnection() method of DriverManager class. The method needs data source name to be used as sub name in the database naming.
Connection con= java.sql.DriverManager.getConnection(url) ;
Connection con= java.sql.DriverManager.getConnection(url,uid,pwd) ;

3.Building Statement
To send SQL statements to SQL engine it is necessary create statement by using createStatement() method of Connection class.
Statement stmt= con.createStatement();

4. Getting Result set
A result set can be otained by executing executeQuery() of Statement class as
ResultSet rs=stmt.executeQuery(“sql statement”);

5.DML and DDL
The executeUpdate() of created statement to update and insert in database and returns no of rows affected.

6.Close statement,connection by using close() method of respective class.
Here we have used type-4 driver. So do not forget to give that ojdbc14.jar in classpath.
This program insert the values in emp table.
import java.sql.*;
class demo
public static void main(String[] args){
Connection con=null;
Statement stmt=null;
Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","oracle");
boolean b=stmt.execute("insert into emp values(3,'bbc','chennai')");
if(b)System.out.println("insert successful");
else System.out.println("insert not success");
}catch(Exception e){
System.out.println("the exception is::::->"+e);
catch(Exception e){
System.out.println("2nd try block exception:::->"+e);}}}};

No comments:

Post a Comment