title: How to use dynamic table name in SELECT query using JDBC
body: <p>I have 5 or table table to query from \</p>
  
  <p>my syntax i like this</p>
  
  <pre><code>String sql2 = "SELECT * FROM ? WHERE Patient_ID = ?";
  
  pst = conn.prepareStatement(sql2);
  
          System.out.println("SQL before values are set "+sql2);
          System.out.println("The values of table/test name recieved in TestPrint stage 1 "+tblName);
          System.out.println("The values of test name recieved in TestPrint stage 1 "+key);
          // values are outputted correctly but are not getting set in the query
  
          pst.setString(1, tblName);
          pst.setLong(2, key);
  ResultSet rs2 = pst.executeQuery(sql2);
  
          while(rs2.next()){
  
              String ID = rs2.getString("ID");
  
              jLabel35.setText(ID);
              jLabel37.setText(ID);
              jLabel38.setText(ID);
         // them print command is initiated to print the panel
  }
  </code></pre>
  
  <p>The problem is when i run this i get an error saying ".....you have and error in SQL syntax near ? WHERE Patient_ID = ?"</p>
  
  <p>When i output the sql using system.out.println(sql2);</p>
  
  <p>values are not set in sql2 </p>