Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Java
Expertise: Intermediate
Aug 19, 2002

Creating a Parameterized SQL Query Using PreparementStatement

 
// conn - having a database connection already

PreparedStatement stmnt = null;
ResultSet rs = null;

try
{
  // '?' indicates placement of a parameter.
  stmnt = conn.prepareStatement("SELECT firstName FROM
employees WHERE salary > ?");


  // Complete the query statement.
  // Note that start with "1" for the first parameter.
  // Resulting query statement "SELECT firstName FROM employees 
WHERE salary > 300"
  stmnt.setInt(1, 300);


  // Returning ResultSet from executing query.
  rs = stmnt.executeQuery();
}
  catch(Exception ex)
{
  System.err.println("Database exception: " + ex);
}
Van C.
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date