JDBC FAQ part5

10:  What are the differences between executeQuery(…), executeUpdate(…) and execute(…) 
      methods?
Ans:    where executeQuery() can be used to execute selection group sql queries to fetch the data from database.
When we use selection group sql query with executeQuery() then JVM will send that sql query to the database engine, database engine will execute it, by this database engine(DBE) will fetch the data from database and send back to the java application.
Java is a purely object oriented technology. That’s why the jdbc application will maintain the fetched data from database, in the form of an object at heap memory, called as ResultSet object.

            public  ResultSet executeQuery(String sqlquery)

            where executeUpdate() can be used to execute updation group sql query to update the database. When we provide updation group sql query as a parameter to executeUpdate(), then JVM will send that sql query to DBE, here DBE will execute it and perform updations on the database, by this DBE will identify the number of records got updated value called as “records updated count” and return back to the java application.

            public int executeUpdate(String sqlquery)

            where execute() can be used to execute either selection group sql queries or updation group queries.
            When we use selection group sql query with the execute() then we will get ResultSet object at heap memory with the fetched data. But execute() will return “true” as a Boolean value.
            When we use updation group sql query with execute() then we will get “ records updated count value” at jdbc application. But execute() will return “false” as a Boolean value.

            public  boolean execute(String sqlquery)

11: How to create a table dynamically from a jdbc application?.

      //import section
       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 = DriverMadoeer.getConnection(“jdbc:odbc:doe”,”system”,”jhon”);

                  //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();
      }
}