Jdbc Interview Questions and Answers

Ans:   

 import java.sql.*;

import java.io.*;

public class CreateTableEx

{

public static void main(String[] args)throws Exception

{

//create buffered reader object

BufferedReader br = new BufferedReader(new       InputStreamReader(System.in));

//load and register the driver

Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

//establish connection

Connection con = DriverManager.getConnection(“jdbc:odbc:nag”,”system”,”durga”);

//create statement object

Statement st = con.createStatement();

//take table name as dynamic input

System.out.println(“Enter table name”);

String tname = br.readLine();

//execute sql query

St.executeUpdate(“create table”+tname+”(eno number,ename varchar2(10),esal number,eaddr varchar2(10))”);

System.out.println(“table created successfully”);

//closing the connection

con.close();

}

}

//import section

Ans:

import java.io.*;

public class InsertTableEx

{

public static void main(String[] args) throws Exception

{

BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

Class.forName(“oracle.jdbc.driver.OracleDriver”);

Connection con  =               DriverManager.getConnection(“jdbc:oracle:thin:@localhost:1521:xe”,”system”,”durga”);

Statement st = con.createStatement();

while(true)

{

System.out.println(“Enter emp number”);

Int eno = Integer.parseInt(br.readLine());

System.out.println(“Enter emp name”);

String ename = br.readLine();

System.out.println(“Enter emp sal”);

Float esal = Float.parseFloat(br.readLine());

System.out.println(“Enter emp address”);

String eaddr = br.readLine();

st.executeUpdate(“insert into emp1 values(“+eno+”,’”+ename+”’,”+esal+”,’”+eaddr+”’)”);

System.out.println(“read successfully inserted”);

System.out.println(“one more record[y/n]);

String option = br.readLine();

If(option.equals(“n”))

break;

}

}

}

import java.sql.*;

Ans:

import java.sql.*;

public class UpdateTableEx

{

public static void main(String[] args)throws Exception

{

//load n register the driver in alternative way to Class.forName

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

Connection con = DriverManager.getConnection(“jdbc:oracle:thin:@localhost:1521:xee”,”system”,”durga”);

Statement st = con.createStatement();

int updateCount = st.executeUpdate(“update emp1 set esal = esal+500 where esal<9000”);

System.out.println(“records updated……..”+updateCount);

con.close();

}

}