Answer / harish

When you execute a SQL query with Statement. It parses and
executes in the database each time. Where as in
PreparedStatement, first time it parses and executes and
subsequent times, it directly substitute the values in the
query and executes. It is faster than Statement

Answer / kalyan

As harish, said prepared statement is pre-complied so it
will be very fast when compared to normal statement.when we
execute same query again and again for different set of
input data.

code snippet for this is :--


for normal statement :

Statement st = conn.createStatement();

for prepared statement :

PreparedStatement prSt = conn.prepareStatement
("query") ;

// set values for input paramenters and execute as usual.

How to check jdbc driver version in sql server?

0 Answers  

---

What does executeupdate return in java?

0 Answers  

---

Prepared statements are faster. Why?

0 Answers  

---

What does Class.forName return?

8 Answers   IBM,

---

In which ways is driver class is registered with drive manager?

0 Answers  

---

How to set NULL values in JDBC PreparedStatement?

0 Answers  

---

Is jdbc a framework?

0 Answers  

---

Why is odbc needed?

0 Answers  

---

Explain different types of locks in jdbc?

0 Answers  

---

please tell me the name and url path for type-4 driver ?

1 Answers  

---

how do we get the connection from connection pool

1 Answers  

---

java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }

6 Answers   CTS,

---