title: Getting Unexpected token: where error, while trying to output a column value
body: <pre><code>try {
      Connection conn=DriverManager.getConnection("jdbc:ucanaccess://E:\\testing.accdb");
  
      String var="Select Location where Book_Name= '"+textField.getText()+"'";
      PreparedStatement pst=conn.prepareStatement(var);
      ResultSet rs=pst.executeQuery();
      if(rs.next()) {
           filename=rs.getString("Location");
      }
  }catch (Exception e) {
      e.printStackTrace();
  }
  try {
      Runtime.getRuntime().exec("rundll32 url.dll,FileProtocolHandler " + filename );
  }
  catch (Exception e ) {
      JOptionPane.showMessageDialog(null, "Check Your File Details");
  }
  </code></pre>
  
  <p>So I am trying to get the value of column location where Book_Name is what the user enters through textField. However I'm getting the error of unepexted token. </p>