private void search() {
try {
//*****************************************************************
System.err.println("Connection à la base ");
connexion = IndependanteInstance.getInstance();
query = "SELECT REG_COD_PC,"+
"REG_COD_IMP,"+
"REG_COD_COM,"+
"REG_CONT_NCC,"+
"REG_NUM_ART,"+
"REG_DAT_REC,"+
"REG_MONT_REG "+
"FROM T_REGLEMENTS ";
connexion.open("TRESOR2",
"sdirecp",
"svr_rec",
"1521",
"RECP",
"oracle.jdbc.driver.OracleDriver",
"jdbc:oracle:thin:@"
);
// test des JTextField
System.err.println("Formation requete: clause where ");
where_clause = "WHERE REG_STAT_REG != 'A'"+
" AND REG_COD_PC = '" + (String)(Pcfield.getText()) +"'" +
" AND REG_CONT_NCC = '" + (String)(NccField.getText())+"'" +
" AND REG_COD_IMP = '" + (String)(ImpField.getText())+"'" +
" AND TO_CHAR(REG_DAT_REC,'dd/mm/yyyy') = '"+ (java.lang.String)(DateField.getText())+"'";
System.err.println("Pcfield: "+ Pcfield.getText());
System.err.println("ImpField: "+ ImpField.getText());
System.err.println("NccField: "+ NccField.getText());
System.err.println("DateField: "+ DateField.getText());
System.err.println("Fin Formation requete ");
query = query + where_clause;
System.err.println("Execution requete ");
ResultSet resultset =this.connexion.ExecuteQuery(query);
boolean hasData = false;
try {
System.err.println("Parcours resultat requete ");
while (resultset.next()) {
if (!hasData) {
vector = new Vector();
hasData = true;
}
String pc = resultset.getString(1);
String imp = resultset.getString(2);
String com = resultset.getString(3);
String ncc = resultset.getString(4);
String article = resultset.getString(5);
java.util.Date date = resultset.getDate(6);
long montant = resultset.getLong(7);
System.err.println("Constitution vecteur ");
vector.addElement(new StockData(pc, imp, com,ncc, article, date, montant));
}
System.err.println("Fermeture resulset ");
resultset.close();
if (!hasData) // We've got nothing
m_result = 1;
}
catch (Exception e) {
e.printStackTrace();
System.err.println("Load data error: "+e.toString());
m_result = -1;
}
System.err.println("Mise à jour model ");
} catch (InterruptedException e) {
e.printStackTrace();
}
catch (Exception E) {
System.out.println("LException: " + E.getMessage());
}
displaySuccess("You've successfully waited
![:)](https://www.developpez.net/forums/images/smilies/icon_smile.gif)
");
searchButton.setEnabled(true);
carder.show(cardPane, "form");
connectionAnimation.stop();
}
Partager