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 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138
|
package Test;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Vector;
import javax.faces.component.UIComponent;
import javax.faces.component.UIData;
import javax.faces.context.FacesContext;
import javax.faces.event.AbortProcessingException;
import javax.faces.event.ActionEvent;
import javax.faces.model.SelectItem;
import org.richfaces.component.UIScrollableDataTable;
import org.richfaces.model.ScrollableTableDataModel.SimpleRowKey;
import org.richfaces.model.selection.Selection;
import org.richfaces.model.selection.SimpleSelection;
import Test.BDD;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.sql.Connection;
public class Recherche {
private SimpleSelection selection = new SimpleSelection();
private static List<EMPLOYES> list = null;
private ArrayList<EMPLOYES> SelectedEM= new ArrayList<EMPLOYES>();
private ResultSet RS;
private UIScrollableDataTable table;
private int Selected;
@SuppressWarnings("unchecked")
public List<EMPLOYES> getlist() {
if (list == null) {
Connection con = new BDD().getCon();
try {
list = new ArrayList<EMPLOYES>();
String SqlStr = " select CODE_SOC, MATRI, NOM, PRENOM, FONCTION as LIBEL,'EXTERNE' as TYPE from DC_DEMANDEUREX";// UNION" ;
// SqlStr =SqlStr+ " select CODE_SOC, MATRI, NOM, PRENOM, LIBEL,'INTERNE' as INTERNE from DC_EMPLOYES ORDER BY TYPE DESC, CODE_SOC, MATRI, NOM, PRENOM ";
Statement stmt= con.createStatement();
RS = stmt.executeQuery(SqlStr);
while(RS.next())
{
list.add( new EMPLOYES(RS.getString("CODE_SOC"),RS.getInt("MATRI"),RS.getString("NOM"),RS.getString("PRENOM"),RS.getString("LIBEL"),RS.getString("TYPE") ));
}
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
public SimpleSelection getSelection()
{
return selection;
}
public void setSelection(SimpleSelection selection)
{
this .selection = selection;
}
//********************************************
public int getSelected()
{
if (SelectedEM != null)
{
//Affecter la valeur de la première cellule
}
return Selected;
}
public String takeSelection() {
getSelectedEM().clear();
if (getSelection().isSelectAll()){
getSelectedEM().addAll(list);
}else{
Iterator<Object> iterator = getSelection().getKeys();
while (iterator.hasNext()){
Object key = iterator.next();
table.setRowKey(key);
getSelectedEM().add((EMPLOYES)table.getRowData());
}
}
return null;
}
//******************************************
public ArrayList<EMPLOYES> getSelectedEM() {
return SelectedEM;
}
public void setSelectedEM( ArrayList<EMPLOYES> SelectedEM)
{
this.SelectedEM = SelectedEM;
}
} |
Partager