-1
modelo.setNumRows(0);
Class.forName(Auxiliar.AcessoBanco.getDriver());
Connection con = DriverManager.getConnection(Auxiliar.AcessoBanco.getUrl(), Auxiliar.AcessoBanco.getUser(), Auxiliar.AcessoBanco.getPass());
String query1 = "Select id_ct, ORDEM ,CDLINHA, TIPOL,SETOR ,TCPERFIL,BPCS,DPERFIL ,PROJETO ,OEM,N_DESENHO ,N_PLANO,OPERACAO,EQUIPAMENTO, DESCTESTE,COMPLEMENTO, TCTESTE ,"
+ "ESPEC_MIN,ESPEC_MAX, ESPEC_UNID,ESPEC_TEXTO,REFERENCIA,"
+ "FREQUENCIA,FREQ_UNID,PRODUTO,ORIGEM,TIPO,ESPECTEXTO,"
+ "FREQTEXTO,LAB from QRY_RESULT where TCPERFIL = " + txt_perfil.getText() + "ORDER BY ORDEM asc";
As you can see.. i do a search for a "Profile" that contains several tests registered in it, but now I need to filter the tests that are related to "LAB" column and that are "Yes" so that the person in the lab only put the values in the laboratory test. Can anyone tell me how I add this search in this query?
Information is missing there. Do you have this table QRY_RESULT and are you trying to filter the records that contain the value "LAB" in a specific column? Try to explain better!
– Henrique Santiago
Next. i have a Defaulttablemodel where I bring several tests related to a "profile" q is specified "TCPERFIL = " + txt_perfil.gettext() +", only that now I need to bring only some tests related to "LAB" column that contains the value "Yes". and bring to registered person
– Rafaaw
"LAB" column is a column in the database?
– Henrique Santiago
That and it has values "Yes, No"
– Rafaaw
I answered there. pass the feedback
– Henrique Santiago