title: java.sql import not working
body: <p>My <code>.getTables</code> and <code>.prepareStatement</code> are not working.  I thought I only had to import the <code>java.sql.*</code> for these to work.  Please let me know what else I need to do.  Thank you for your time.  It says "cannot find symbol" next to both lines and will not compile.</p>
  
  <pre><code>import edu.lcc.citp.inventory.Product;
  import java.sql.DriverManager;
  import javax.jms.Connection;
  import java.sql.*;
  import java.util.ArrayList;
  import java.util.List;
  import javax.jms.JMSException;
  
  public class DatabaseProductDao implements DataAccessObject&lt;Product&gt; {
  
  Connection con;
  
  public DatabaseProductDao() throws SQLException, JMSException, ClassNotFoundException {
  
      Class.forName("cockeb.org.apache.derby.jdbc.ClientDriver");
  
      try (Connection con = (Connection) DriverManager.getConnection("jdbc:derby://localhost:1527/store;create=true")) {
          boolean exists = con.getMetaData().getTables(null, null, "PRODUCT", null).next();
          if (exists) {
              System.out.println("Table Exists");
          } else {
              String createDml = "CREATE TABLE PRODUCT (UPC VARCHAR(25), SHORT_DETAILS VARCHAR(50), LONG_DETAILS VARCHAR(5000), PRICE DECIMAL(10,2), STOCK INTEGER, PRIMARY KEY (UPC))";
              PreparedStatement createStatement =     con.prepareStatement(createDml);
              createStatement.execute();
          }
      } catch (SQLException e) {
          System.out.println("Can Not Connect At This Time");
      }
  }
  </code></pre>