· 8 years ago · May 19, 2018, 04:38 AM
1<html>
2<head>
3 <script>
4 window.onload = function() {
5 var db = Titanium.Database.open('mydb');
6
7 //Create an populate database
8 db.execute('CREATE TABLE IF NOT EXISTS DATABASETEST (ID INTEGER, NAME TEXT)');
9 db.execute('DELETE FROM DATABASETEST');
10
11 db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',1,'Name 1');
12 db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',2,'Name 2');
13 db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',3,'Name 3');
14 db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',4,'Name 4');
15
16 //Fetch Database rows and put them into a picker data set
17 var rows = db.execute('SELECT * FROM DATABASETEST');
18 var col1 = {
19 width:120,
20 data:[]
21 };
22 var col2 = {
23 width:120,
24 data:[]
25 };
26 while (rows.isValidRow()) {
27 col1.data.push({
28 title: rows.fieldByName('id'),
29 fontSize:20
30 });
31 col2.data.push({
32 title: rows.fieldByName('name'),
33 fontSize:20
34 });
35 rows.next();
36 }
37 // close database
38 rows.close();
39
40 //Create picker
41 var picker = Titanium.UI.createPicker({id:'picker',data:[col1,col2],selectionIndicator:true});
42
43 //Show current picker values
44 picker.addEventListener('change', function(e) {
45 document.getElementById('value').innerHTML = 'column ' + e.column + '<br/> row ' + e.row + ' value[1] ' + e.selectedValue[0] + ' value[2] ' + e.selectedValue[1];
46 });
47
48 };
49
50 </script>
51
52</head>
53<body style="margin:0;padding:0;font-family:Helvetica Neue;background-color:#fff">
54 <h2>Picker/DB Demo</h2>
55 <div>
56 Value: <span id="value"></span>
57 </div>
58 <div id="picker" style="position:absolute;bottom:0;height:217px;"></div>
59</body>
60</html>