Advertisement
Guest User

Untitled

a guest
Jun 1st, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.94 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3.  
  4. <head>
  5. <meta charset="utf-8">
  6. <title></title>
  7. <meta name="viewport" content="user-scalable=no, width=device-width, initial-scale=1">
  8. <meta name="apple-mobile-web-app-capable" content="yes">
  9. <meta name="apple-mobile-web-app-status-bar-style" content="black">
  10.  
  11. <script type="text/javascript" src="tds.sqlitebridge.js"></script>
  12.  
  13. </head>
  14.  
  15. <body id="app">
  16. <a href="index.html">Zurück</a>
  17. <br>
  18. <br>
  19.  
  20. <h1>SQLite Test</h1>
  21. <p>Diese HTML-Seite sendet per Javascript eine SQL-Anfrage an die SQLite-Datenbank der iOS App.</p>
  22.  
  23. <button id="startButton">Eintrag hinzufügen</button>
  24.  
  25. <h2>Ergebnis</h2>
  26. <p id="result"></p>
  27.  
  28. <script>
  29. // example for usage of TDS_JS_SQLite_Bridge
  30.  
  31. // create the bridge object
  32. var jsSQLiteBridge = new JSSQLiteBridge();
  33. var lastRequestID;
  34.  
  35. document.getElementById("startButton").addEventListener("click", function (event) {
  36.  
  37. selectTestItems();
  38.  
  39. }, false);
  40.  
  41.  
  42. function selectTestItems() {
  43.  
  44. console.log("selectTestItems");
  45.  
  46. // specify the dbName
  47. var dbName = "default.db";
  48.  
  49. // specify the table name
  50. var tableName = "LOCALSTORAGE";
  51.  
  52. lastRequestID = jsSQLiteBridge.selectInSQLiteDatabase(["VALUE"], "LOCALSTORAGE", "default.db", "KEY='mechanicConfig'");
  53. }
  54.  
  55. function handleSQLiteSelectResponse(requestID, retVal) {
  56.  
  57. console.log(decodeURIComponent(retVal));
  58.  
  59. // Response identifizieren
  60. if (requestID == lastRequestID) {
  61.  
  62. }
  63.  
  64. var resultDiv = document.getElementById('result');
  65. resultDiv.innerHTML = retVal;
  66.  
  67. var deleteButton = document.getElementById('deleteButton');
  68. deleteButton.style.visibility = 'visible';
  69. }
  70.  
  71. </script>
  72. </body>
  73.  
  74. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement