Advertisement
Guest User

Untitled

a guest
Jul 24th, 2014
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.03 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>Página de teste</title>
  4. <link rel="stylesheet" href="css/jquery.mobile.icons.min.css" />
  5. <link rel="stylesheet" href="css/jquery.mobile.structure-1.4.2.min.css" />
  6. <script type="text/javascript" src="js/jquery-1.11.1.min.js"></script>
  7. <script type="text/javascript" src="js/jquery.mobile-1.4.2.min.js"></script>
  8. <script type="text/javascript" src="js/functions.js"></script>
  9.  
  10. <script type="text/javascript">
  11. $(document).ready(function () {
  12. event.preventDefault();
  13.  
  14. var db;
  15.  
  16. db = openDatabase(
  17. 'BASE',
  18. '1.0',
  19. 'BASE Teste',
  20. 1 * 1024 * 1024
  21. );
  22.  
  23. db.readTransaction(
  24. function(transaction) {
  25. transaction.executeSql("SELECT COUNT(1) as total, codigo FROM table1;", [], OkRetorno1, ErroRetorno);
  26. }
  27. );
  28.  
  29. db.readTransaction(
  30. function(transaction) {
  31. transaction.executeSql("SELECT estado,nome FROM table1 ORDER BY voto;", [], OkRetorno, ErroRetorno);
  32. }
  33. );
  34.  
  35. function OkRetorno1(transaction, results) {
  36. $("#total").css("display", "inline");
  37. var row = results.rows.item(0);
  38.  
  39. total1.innerHTML = row['total'];
  40. }
  41.  
  42. function OkRetorno(tx,results) {
  43. if (results.rows.length) {
  44. for (i=0;i<results.rows.length;i++) {
  45. var row = results.rows.item(i);
  46.  
  47. console.log(i + ' - ' + row['nome']);
  48. resultado1.innerhtml = row + 1;
  49.  
  50. dataString = 'estado=' + row['estado'] + '&nome=' + row['nome'];
  51.  
  52. $.ajax({
  53. url : 'http://url_do_webservice/webservice.php',
  54. type : 'POST',
  55. async: false,
  56. data: dataString ,
  57. sucess: function () {
  58. resultado1.innerhtml = row + 1; },
  59. error: function(xhr, ajaxOptions, thrownError){
  60. alert('AJAX = ' + xhr.status + ' - ' + thrownError);
  61. }
  62. });
  63. }
  64. }
  65. carregar.innerHTML = 'Conclu&iacute;do.' ;
  66. $("#finalizar").css("display", "inline");
  67. }
  68. });
  69.  
  70. </script>
  71. </head>
  72.  
  73. <body>
  74. <div data-role="page" data-theme="a">
  75. <div data-role="content" style="text-align:center">
  76. <div id="carregar" style="font-size:22px;font-weight:bold;color:#f1fe01">
  77. Aguarde !!! Carregando Nomes ...
  78. </div>
  79.  
  80. <br />
  81. <br />
  82.  
  83. <div id="total" style="font-size:18px;font-weight:bold;color:ffffff">
  84. Nomes do Estado: <span id="resultado1">0</span> / <span id="total1">0</span>
  85. </div>
  86.  
  87. <br />
  88. <br />
  89.  
  90. <div id="finalizar" style="display:none;margin-top:35px">
  91. <a href="comeco.html" data-ajax="false" data-role="button" data-icon="check" data-inline="true">OK</a>
  92. </div>
  93. </div>
  94. </div>
  95. </body>
  96. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement