Foros del Web - Ver Mensaje Individual

emprear · #2 (**permalink**) 12/02/2013, 13:29

http://dev.w3.org/html5/webdatabase/
Por el momento, solo he visto resultados conectando a Sqlite, en bases de datos que se almacenan en el cliente, y funciona en Opera(12.14) Chrome y Safari

Código HTML:

Ver original<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SQL Storage</title>
</head>
<body>
<br />
<br />
<div align="center"><input type="hidden" id="id" /> First name:<input type="text" id="firstName" /><br />
Last name:<input type="text" id="lastName" /><br />
Phone: <input type="text" id="phone" /><br />
<button onclick="resetForm()">Reset Form</button> <button onclick="updateRecord()">Update</button> <button onclick="insertRecord()">Insert</button> <button onclick="dropTable()">Drop Table</button>
<div id="results"></div>
</div>
<script type="text/javascript">
//<![CDATA[
 
 var results = document.getElementById('results'); 
 var id = document.getElementById('id');
 var firstName = document.getElementById('firstName');  
 var lastName = document.getElementById('lastName');  
 var phone = document.getElementById('phone');
   
 var createStatement = "CREATE TABLE IF NOT EXISTS Contacts (id INTEGER PRIMARY KEY AUTOINCREMENT, firstName TEXT, lastName TEXT, phone TEXT)";
 var selectAllStatement = "SELECT * FROM Contacts";
 var insertStatement = "INSERT INTO Contacts (firstName, lastName, phone) VALUES (?, ?, ?)";
 var updateStatement = "UPDATE Contacts SET firstName = ?, lastName = ?, phone = ? WHERE id = ?";
 var deleteStatement = "DELETE FROM Contacts WHERE id=?";
 var dropStatement = "DROP TABLE Contacts";
 
 var db = openDatabase("AddressBook", "1.0", "Address Book", 200000);
 var dataset;
 createTable();
 
      function onError(tx, error) {
        alert(error.message);
      }
      
      function showRecords() {
        results.innerHTML = '';
        db.transaction(function(tx) {
          tx.executeSql(selectAllStatement, [], function(tx, result) {
dataset = result.rows;
            for (var i = 0, item = null; i < dataset.length; i++) {
              item = dataset.item(i);
              results.innerHTML += 
                  '<li>' + item['lastName'] + ' , ' + item['firstName'] + ' <a href="#" onclick="loadRecord('+i+')">edit<\/a>  ' +  
 '<a href="#" onclick="deleteRecord('+item['id']+')">delete<\/a><\/li>';
}
          });
        });
      }
      
      function createTable() { 
        db.transaction(function(tx) {
          tx.executeSql(createStatement, [], showRecords, onError);
        });
      }
      
      function insertRecord() {
        db.transaction(function(tx) {
          tx.executeSql(insertStatement, [firstName.value, lastName.value, phone.value], loadAndReset, onError);
        });
      }
      
 function loadRecord(i) {
var item = dataset.item(i); 
        firstName.value = item['firstName'];
lastName.value = item['lastName'];
phone.value = item['phone'];
id.value = item['id']; 
      }
 
      function updateRecord() {
        db.transaction(function(tx) {
          tx.executeSql(updateStatement, [firstName.value, lastName.value, phone.value, id.value], loadAndReset, onError);
        }); 
      }
      
      function deleteRecord(id) {
        db.transaction(function(tx) {
          tx.executeSql(deleteStatement, [id], showRecords, onError);
        });
resetForm();
      }
       
      function dropTable() {
        db.transaction(function(tx) {
          tx.executeSql(dropStatement, [], showRecords, onError);
        });
resetForm();
      }
 
 function loadAndReset(){
 resetForm();
 showRecords();
 }
 
 function resetForm(){
firstName.value = '';
lastName.value = '';
phone.value = '';
id.value = ''; 
 }
//]]>
</script>
</body>
</html>

código extraido de
http://cookbooks.adobe.com/post_Stor...ase-19115.html

También he visto cosas como esta
http://www.sequelsphere.com/
Pero nunca lo probé

Saludos