title: select subquery in insert query for PreparedStatement
body: <p>I want to use a SELECT subquery into a INSERT query as PreparedStatement...
  I am trying to fill 2 columns with custom value and the 3rd one with subquery... </p>
  
  <pre><code>query = "insert into invoiceOrders (productCode,quantity,amount) values (?,?,select price from priceTable where proCode=pCode)";
  PreparedStatement stmt = conn.prepareStatement(query);
  stmt.setString(0,"productCode");
  stmt.setString(1,"qty");
  /*3rd column will be filled be subquery*/
  n = stmt.executeUpdate();
  </code></pre>