1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| public static ArrayList<ArticleFourAS400> getListArticleFourAS400(String nomFour){
connexion = new BDConnectAS400();
reception = new AddReception();
nomFour = (String) reception.getComboFournisseur().getSelectedItem();//Un des critère de requette
String requette = "SELECT DISTINCT B33STFC.FTEFAL01.NARTEF, B33STFC.FTEFAL01.MDIREF, B33STFC.FTEFAL01.LARFEF, B33STFC.FTTBAL01.PXACTF"+""+
" FROM B33STFC.FTEFAL01, B33STFC.FTTBAL01 WHERE B33STFC.FTTBAL01.NARTTF = B33STFC.FTEFAL01.NARTEF AND CRAYEF in ('205','208')"+""+
" AND NFOUEF = (SELECT B33STFC.FTFOUL01.NFOUFO FROM B33STFC.FTFOUL01 WHERE B33STFC.FTFOUL01.RSOCFO = "+"'"+nomFour+"'"+")";
Statement state;
ResultSet res;
ArrayList<ArticleFourAS400> list = new ArrayList<ArticleFourAS400>();
try{state = connexion.getInstance().createStatement();
res = state.executeQuery(requette);
while(res.next()){
ArticleFourAS400 artFourAS400 = new ArticleFourAS400();
artFourAS400.setNARTEF(res.getString(1));
artFourAS400.setLARFEF(res.getString(3));
artFourAS400.setPXACTF(res.getString(4));
list.add(artFourAS400); }
res.close();
return list;}
catch(SQLException e){e.printStackTrace();}
return null;
} |
Partager