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;
}
} |
Récupérer la ligne sélectionnée dans ScrollableDataTable
Répondre avec citation
Partager