remplir un Array Gridà partir d'une base de données

**ASPAK** · 17/03/2009, 10h30

Bonjour tout le monde,

j'aimerais bien remplir mon grid dynamiquement à partir d'une base de données mais je trouve quelques difficultés en se basant sur l'exemple du site officiel, la fonction getCompanyData retourne une matrice des objets, pour mon cas j'essaie de recuperer une liste, bon voici le code qui est utilisé sur le site, et je veux bien savoir comment interroger ma base de données :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
# public class BasicArrayGridSample implements EntryPoint {  
#   
#     public void onModuleLoad() {  
#         Panel panel = new Panel();  
#         panel.setBorder(false);  
#         panel.setPaddings(15);  
#   
#         RecordDef recordDef = new RecordDef(  
#                 new FieldDef[]{  
#                         new StringFieldDef("company"),  
#                         new FloatFieldDef("price"),  
#                         new FloatFieldDef("change"),  
#                         new FloatFieldDef("pctChange"),  
#                         new DateFieldDef("lastChanged", "n/j h:ia"),  
#                         new StringFieldDef("symbol"),  
#                         new StringFieldDef("industry")  
#                 }  
#         );  
#   
#         GridPanel grid = new GridPanel();  
#   
#         Object[][] data = getCompanyData();  
#         MemoryProxy proxy = new MemoryProxy(data);  
#   
#         ArrayReader reader = new ArrayReader(recordDef);  
#         Store store = new Store(proxy, reader);  
#         store.load();  
#         grid.setStore(store);  
#   
#   
#         ColumnConfig[] columns = new ColumnConfig[]{  
#                 //column ID is company which is later used in setAutoExpandColumn  
#                 new ColumnConfig("Company", "company", 160, true, null, "company"),  
#                 new ColumnConfig("Price", "price", 35),  
#                 new ColumnConfig("Change", "change", 45),  
#                 new ColumnConfig("% Change", "pctChange", 65),  
#                 new ColumnConfig("Last Updated", "lastChanged", 65),  
#                 new ColumnConfig("Industry", "industry", 60, true)  
#         };  
#   
#         ColumnModel columnModel = new ColumnModel(columns);  
#         grid.setColumnModel(columnModel);  
#   
#         grid.setFrame(true);  
#         grid.setStripeRows(true);  
#         grid.setAutoExpandColumn("company");  
#   
#         grid.setHeight(350);  
#         grid.setWidth(600);  
#         grid.setTitle("Array Grid");  
#   
#         Toolbar bottomToolbar = new Toolbar();  
#         bottomToolbar.addFill();  
#         bottomToolbar.addButton(new ToolbarButton("Clear Sort", new ButtonListenerAdapter() {  
#             public void onClick(Button button, EventObject e) {  
#                 grid.clearSortState(true);  
#             }  
#         }));  
#         grid.setBottomToolbar(bottomToolbar);  
#   
#         panel.add(grid);  
#   
#         RootPanel.get().add(panel);  
#     }  
#   
#     private Object[][] getCompanyData() {  
#         return new Object[][]{  
#                 new Object[]{"3m Co", new Double(71.72), new Double(0.02),  
#                         new Double(0.03), "9/1 12:00am", "MMM", "Manufacturing"},  
#                 new Object[]{"Alcoa Inc", new Double(29.01), new Double(0.42),  
#                         new Double(1.47), "9/1 12:00am", "AA", "Manufacturing"},  
#                 new Object[]{"Altria Group Inc", new Double(83.81), new Double(0.28),  
#                         new Double(0.34), "9/1 12:00am", "MO", "Manufacturing"},  
#                 new Object[]{"American Express Company", new Double(52.55), new Double(0.01),  
#                         new Double(0.02), "9/1 12:00am", "AXP", "Finance"},  
#                 new Object[]{"American International Group, Inc.", new Double(64.13), new Double(0.31),  
#                         new Double(0.49), "9/1 12:00am", "AIG", "Services"},  
#                 new Object[]{"AT&T Inc.", new Double(31.61), new Double(-0.48),  
#                         new Double(-1.54), "9/1 12:00am", "T", "Services"},  
#                 new Object[]{"Boeing Co.", new Double(75.43), new Double(0.53),  
#                         new Double(0.71), "9/1 12:00am", "BA", "Manufacturing"},  
#                 new Object[]{"Caterpillar Inc.", new Double(67.27), new Double(0.92),  
#                         new Double(1.39), "9/1 12:00am", "CAT", "Services"},  
#                 new Object[]{"Citigroup, Inc.", new Double(49.37), new Double(0.02),  
#                         new Double(0.04), "9/1 12:00am", "C", "Finance"},  
#                 new Object[]{"E.I. du Pont de Nemours and Company", new Double(40.48), new Double(0.51),  
#                         new Double(1.28), "9/1 12:00am", "DD", "Manufacturing"}  
#         };  
#     }  
# }