1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
public class InsertionPositionsLimitesBean extends InsertDataBean {
protected int id_gda_positions_limites;
protected String id_da;
protected String raf_groupe;
protected String groupe_prod;
protected String contrat_compte;
protected String devise;
protected double limite;
protected double en_cours;
protected String risque;
protected String ufo;
protected String dep;
protected void initializeMetaData(StatementMetaData aMetaData) throws DataException {
// requête SQL
aMetaData.setSQL(getSQLString());
// on ajoute la table sur laquelle on va faire la requête au metadata
aMetaData.addTable(Constants.TABLE_GDA_POSITIONS_LIMITES);
// définir les emplacements des paramètres
aMetaData.addParameter("id_gda_positions_limites", Integer.class, 1);
aMetaData.addParameter("id_da", String.class, 1);
aMetaData.addParameter("raf_groupe", String.class, 1);
aMetaData.addParameter("groupe_prod", String.class, 1);
aMetaData.addParameter("contrat_compte", String.class, 1);
aMetaData.addParameter("devise", String.class, 1);
aMetaData.addParameter("limite", Double.class, 1);
aMetaData.addParameter("en_cours", Double.class, 1);
aMetaData.addParameter("risque", String.class, 1);
aMetaData.addParameter("ufo", String.class, 1);
aMetaData.addParameter("dep", String.class, 1);
}
public String getSQLString() {
String requete = "INSERT INTO GDA_POSITIONS_LIMITES (ID_GDA_POSITIONS_LIMITES, ID_DA, RAF_GROUPE, GROUPE_PROD, CONTRAT_COMPTE, DEVISE, LIMITE, EN_COURS, RISQUE, UFO, DEP) "
+ "VALUES (?,?,?,?,?,?,?,?,?,?,?) ";
return requete;
}
public void initializeParameters() throws DataException {
sqlStatement.setParameter("id_gda_positions_limites", new Integer (getId_gda_positions_limites()));
sqlStatement.setParameter("id_da", getId_da());
sqlStatement.setParameter("raf_groupe", getRaf_groupe());
sqlStatement.setParameter("groupe_prod", getGroupe_prod());
sqlStatement.setParameter("contrat_compte", getContrat_compte());
sqlStatement.setParameter("devise", getDevise());
sqlStatement.setParameter("limite", new Double (getLimite()));
sqlStatement.setParameter("en_cours", new Double (getEn_cours()));
sqlStatement.setParameter("risque", getRisque());
sqlStatement.setParameter("ufo", getUfo());
sqlStatement.setParameter("dep", getDep());
} |
Partager