PreparedStatement related query

[S Majumder]

Hi every body I have a query related to PreparedStatement.

Is it necessary to explicit cast to conn.prepareStatement(sqlQuery); ?

My code is like this :

String mySql=" SELECT name FROM mytable "+
							
// prepare Statement
PreparedStatement ps1 = (PreparedStatement) conn.prepareStatement(mySql);

//or 
PreparedStatement ps2 = conn.prepareStatement(mySql);

Which one is better ?

regards,
S

[Smitesh Shinde]

You do not need to explicitly cast it as conn.prepareStatement itself returns object of type PreparedStatement