Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. var result = 'string for now';
  2. function populateDB(tx) {
  3. tx.executeSql('DROP TABLE IF EXISTS DEMO');
  4. tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)');
  5. tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "'+ result +'")');
  6. tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")');
  7. }
  8.  
  9. function errorCB(err) {
  10. alert("Error processing SQL: "+err.code);
  11. }
  12.  
  13. function successCB() {
  14. alert("success!");
  15. db.transaction(queryDB, errorCB);
  16. }
  17.  
  18. function queryDB(tx) {
  19. tx.executeSql('SELECT * FROM DEMO', [], querySuccess, errorCB);
  20. }
  21.  
  22. function querySuccess(tx, results) {
  23. console.log("Returned rows = " + results.rows.length);
  24. // this will be true since it was a select statement and so rowsAffected was 0
  25. if (!results.rowsAffected) {
  26. console.log('No rows affected!');
  27. return false;
  28. }
  29. // for an insert statement, this property will return the ID of the last inserted row
  30. console.log("Last inserted row ID = " + results.insertId);
  31. }
  32.  
  33.  
  34. var db = window.openDatabase("Database", "1.0", "Cordova Demo", 200000);
  35. db.transaction(populateDB, errorCB, successCB);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement