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
| public class main extends ListActivity {
private static final int ACTIVITY_PAGE_1_1=0;
private static final int ACTIVITY_PAGE_1_2=1;
private static final int ACTIVITY_PAGE_2_1=2;
private static final int ACTIVITY_PAGE_2_2=3;
private static final int ACTIVITY_PAGE_3_1=4;
private static final int ACTIVITY_PAGE_3_2=5;
private static final int ACTIVITY_PAGE_3_3=5;
private static final int VOIR_PAGE_1_1 = Menu.FIRST ;
private static final int VOIR_PAGE_1_2 = Menu.FIRST + 1;
private static final int VOIR_PAGE_2_1 = Menu.FIRST + 2;
private static final int VOIR_PAGE_2_2 = Menu.FIRST + 3;
private static final int VOIR_PAGE_3_1 = Menu.FIRST + 4;
private static final int VOIR_PAGE_3_2 = Menu.FIRST + 5;
private static final int VOIR_PAGE_3_3 = Menu.FIRST + 6;
private DBAdapter mDbHelper;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.inscrits_list);
mDbHelper = new DBAdapter(this);
mDbHelper.open();
fillData();
registerForContextMenu(getListView());
}
private void fillData() {
Cursor InscritsCursor = mDbHelper.fetchAllInscrits();
startManagingCursor(InscritsCursor);
// Create an array to specify the fields we want to display in the list (only TITLE)
String[] from = new String[]{DBAdapter.KEY_NOM};
// and an array of the fields we want to bind those fields to (in this case just text1)
int[] to = new int[]{R.id.lenom};
// Now create a simple cursor adapter and set it to display
SimpleCursorAdapter inscrits =
new SimpleCursorAdapter(this, R.layout.inscrits_row, InscritsCursor, from, to);
setListAdapter(inscrits);
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
super.onCreateOptionsMenu(menu);
SubMenu m1 = menu.addSubMenu(0,1000,0,"Page 3");
m1.add(0, VOIR_PAGE_3_1, 0, R.string.menu_3_1);
m1.add(0, VOIR_PAGE_3_2, 0, R.string.menu_3_2);
m1.add(0, VOIR_PAGE_3_3, 0, R.string.menu_3_3);
SubMenu m2 = menu.addSubMenu(0,2000,0,"Page 2");
m2.add(0, VOIR_PAGE_2_1, 0, R.string.menu_2_1);
m2.add(0, VOIR_PAGE_2_2, 0, R.string.menu_2_2);
SubMenu m3 = menu.addSubMenu(0,3000,0,"Page 1");
m3.add(0, VOIR_PAGE_1_1, 0, R.string.menu_1_1);
m3.add(0, VOIR_PAGE_1_2, 0, R.string.menu_1_2);
return true;
}
@Override
public boolean onMenuItemSelected(int featureId, MenuItem item) {
switch(item.getItemId()) {
case VOIR_PAGE_1_1:
Page_1_1();
return true;
case VOIR_PAGE_1_2:
Page_1_2();
return true;
case VOIR_PAGE_2_1:
Page_2_1();
return true;
case VOIR_PAGE_2_2:
Page_2_2();
return true;
case VOIR_PAGE_3_1:
Page_3_1();
return true;
case VOIR_PAGE_3_2:
Page_3_2();
return true;
case VOIR_PAGE_3_3:
Page_3_3();
return true;
}
return super.onMenuItemSelected(featureId, item);
}
private void Page_1_1() {
Intent i = new Intent(this, page_1_1.class);
startActivityForResult(i, ACTIVITY_PAGE_1_1);
}
private void Page_1_2() {
Intent i = new Intent(this, page_1_2.class);
startActivityForResult(i, ACTIVITY_PAGE_1_2);
}
private void Page_2_1() {
Intent i = new Intent(this, page_2_1.class);
startActivityForResult(i, ACTIVITY_PAGE_2_1);
}
private void Page_2_2() {
Intent i = new Intent(this, page_2_2.class);
startActivityForResult(i, ACTIVITY_PAGE_2_2);
}
private void Page_3_1() {
Intent i = new Intent(this, page_3_1.class);
startActivityForResult(i, ACTIVITY_PAGE_3_1);
}
private void Page_3_2() {
Intent i = new Intent(this, page_3_2.class);
startActivityForResult(i, ACTIVITY_PAGE_3_2);
}
private void Page_3_3() {
Intent i = new Intent(this, page_3_3.class);
startActivityForResult(i, ACTIVITY_PAGE_3_3);
}
protected void onListItemClick(ListView l, View v, int position, long id) {
super.onListItemClick(l, v, position, id);
Intent i = new Intent(this, page_1_1.class);
i.putExtra(DBAdapter.KEY_ROWID, id);
startActivityForResult(i, ACTIVITY_PAGE_1_1);
}
@Override
protected void onActivityResult(int requestCode, int resultCode, Intent intent) {
super.onActivityResult(requestCode, resultCode, intent);
fillData();
}
} |
Affichage dans TextView avec SQLITE
Répondre avec citation
Partager