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 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
| import java.util.ArrayList;
import javax.faces.event.ValueChangeEvent;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import javax.faces.model.SelectItem;
import DBmanager.DataBaseConnection;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
public class ExperimentBean {
/**
*
* Creates a new instance of ChangeListenerBean
*/
private String maValeur;
private List<SelectItem> mesElements;
public String getMaValeur() {
return maValeur;
}
public void setMaValeur(String maValeur) {
this.maValeur = maValeur;
}
public List getMaliste() {
ArrayList unelist = new ArrayList();
try {
String sql = " select * from experimentation ";
ResultSet resultat = DataBaseConnection.statement.executeQuery(sql);
while (resultat.next()) {
String num = resultat.getString("experimentid").toString();
unelist.add(num);
}
// session.close();
} catch (Exception e) {
e.printStackTrace();
}
return (List) unelist;
}
public List<SelectItem> getMesElements() {
if (mesElements == null) {
mesElements = new ArrayList<SelectItem>();
mesElements.add(new SelectItem(null, "-- Choisissez --"));
for (String val : getMaliste()) {
mesElements.add(new SelectItem(val));
}
}
return mesElements;
}
} |
Partager