PreparedStatement is called pre compiled statement but Statement is not why?
How PreparedStatement is pre compiled?

Hi Sirje,

In case of PreparedStatement, the skeleton of an SQL statement is prepared/compiled during it's creation/instantiation.
For e.g.

PreparedStatement ps = con.prepareStatement ("insert into EmpTable values(?,?,?)");

place holders (? marks) are used instead of actual values, this skeleton is compiled before going to execute with the actual values, as follows:

ps.setString(1,"1001");
ps.setString(2,"Sirje");
ps.setString(3,"B.Tech");
ps.executeUpdate(); // here, the SQL statement doesn't require any comiplation, becuase its already compiled before

But in case of Statement, no SQL statement is prepared/compiled during creation/instantiation.
For e.g

Statement st=con.createStatement();

Later, the SQL statement with values together executed as follows:

st.executeUpdate("insert into EmpTable values('1001','Sirje','B.Tech')");

I hope I tried to cleare the concept.

Thanks & Regards,
Abhijit

Mean no need to compile every time.