How can you create JDBC statements and what are they?

  • A Statement object is what sends your SQL statement to the DBMS. 
  • You simply create a Statement object and then execute it, supplying the appropriate execute method with the SQL statement you want to send. 
  • For a SELECT statement, the method to use is executeQuery. 
  • For statements that create or modify tables, the method to use is executeUpdate. 
  • It takes an instance of an active connection to create a Statement object. 
  • In the following example, we use our Connection object con to create the Statement object
Statement stmt = con.createStatement();

Enter your email address to get our daily JOBS & INTERVIEW FAQ's Straight to your Inbox.

Make sure to activate your subscription by clicking on the activation link sent to your email