title: java.sql.sqlException:no such column: employID
body: <p>Here is my code I am getting the following error"<code>java.sql.sqlException</code>:no such column: employID" and I have rechecked my db table column name is correct <code>employID</code> nothing wrong with that but still getting the same error please help I am trying to load the table data based on the first column into a textboxes using netbeans IDE and sqlite database.</p>
  
  <pre><code>private void tableEmployeeMouseClicked(java.awt.event.MouseEvent evt) {                                           
      try{ 
      int row=tableEmployee.getSelectedRow();
       String tableClick=(tableEmployee.getModel().getValueAt(row, 0).toString());
       String sql="SELECT * FROM employeeInfo WHERE employID=' "+tableClick+" ' ";
  
       pst=conn.prepareStatement(sql);
       rs=pst.executeQuery();
       if(rs.next()){
           String add1=rs.getString("employID");
           empid.setText(add1);
           String bdd=rs.getString("name");
           name.setText(bdd);
           String cdd=rs.getString("surname");
           surname.setText(cdd);
           String ddd=rs.getString("age");
           age.setText(ddd);     
       }         
       }
      catch(Exception e){
          JOptionPane.showMessageDialog(null,e);
      }
  </code></pre>
  
  <p>n.b. the <code>employID</code> column in my database is set 
  to <code>INTEGER</code> can that or my query inside my code have any connection with the error type..
  Thanks.</p>
  
  <p>EDIT: The DDL sentence</p>
  
  <pre><code>CREATE TABLE "employeeInfo" (
  "employID " INTEGER PRIMARY KEY NOT NULL , 
  "name" CHAR, "surname" CHAR, 
  "age" INTEGER, "username" VARCHAR, "password" VARCHAR)
  </code></pre>