Sreekanth

• Jun 2nd, 2005

 

try 
{ 
 
Connection conn = DriverManager.getConnection("URL",'USER"."PWD"); 
 
//For Simple statement used for static query. 
Statement stmt = conn.createStatement();  
 
//For a runtime / dynamic query .Where String is a dynamic query you want to execute 
 
PreparedStatement pstmt = conn.prepareStatement(String sql); 
 
 
//For Stored procedure Callable statement, where sql is stored procedure. 
 
CallableStatement cstmt = conn.prepareCall(String sql); 
} 
catch (SQLException ee) 
{ 
ee.printStackTrace(); 
} 
 
Don't forget all the above statements will throw the SQLException, so we need to use try catch for the same to handle the exception.