¡¡¡¡
html5Ôö¼ÓеÄÌØÐÔ£¬ÄǾÍÊÇÔö¼ÓÁ˱¾µØ´æ´¢£¡¸ÄÉÆÓû§ÌåÑ飬»òÐíhtml5»á´ø×ÅÎÒÃÇ×ß½øÐµĻ¥ÁªÍøÊ±´ú¡£
ÏÂÃæ¿´¿´ÔõÑù²Ù×÷web Êý¾Ý¿â°É£¡£¡Ê×ÏÈн¨Êý¾Ý¿â£¡
var db = window.openDatabase("mydata", "1.0","Êý¾Ý¿âÃèÊö",20000);
//window.openDatabase("Êý¾Ý¿âÃû×Ö", "°æ±¾","Êý¾Ý¿âÃèÊö",Êý¾Ý¿â´óС);
if(db)
alert("н¨Êý¾Ý¿â³É¹¦£¡");
ÕâÀïÖ»ÊÇ´ÖÂԵĽ²Ò»½²£¬Èç¹ûÏë¿´ÏêϸµÄ˵Ã÷¿ÉÒԲο¼ÆäËûµÄ½Ì³Ì£¬Ò²Çë¼ûÁÂÁË£¡
ÔõÑù²Ù×÷Êý¾Ý¿âÄØ£¿
db.transaction(function(tx) {
tx.executeSql("CREATE TABLE test (id int UNIQUE, mytitle TEXT, timestamp REAL)");
});
ÉÏÃæÊÇн¨Êý¾Ý±í£¡±¾µØÊý¾Ý¿âÊÇͨ¹ýdb.transaction()º¯ÊýÀ´ÊµÏֵģ¬ÔÙ¿´ÏÂÃæµÄ´úÂë°É£¡
²åÈë¼Ç¼£º
db.transaction(function(tx) {
tx.executeSql("INSERT INTO test (mytitle, timestamp) values(?, ?)", ["WEB Database", new Date().getTime()], null, null);
});
¸üмǼ£º
db.transaction(function(tx) {
tx.executeSql("update test set mytitle=? where mytitle = 'fsafdsaf'",['xp'],null,null);
});
²éѯ¼Ç¼£º
db.transaction(function(tx) {
tx.executeSql("SELECT * FROM test", [],
function(tx, result) {
for(var i = 0; i < result.rows.length; i++){
document.write('' + result.rows.item(i)['mytitle'] + '
');
}
}, function(){
alert("error");
});
});
ɾ³ý±í£º
db.transaction(function(tx) {
tx.executeSql("DROP TABLE test");
})
Æäʵ±¾µØÊý¾Ý¿âÎ޷ǾÍÊǼ¸¸ö½è¿Ú¶øÒÑ£¬Èç¹û²»Á˽âsqlÓï¾äµÄ£¬¿ÉÒԲο¼ÆäËûÍøÕ¾µÄ½Ì³Ì£¡
ÔõÑù²é¿´Êý¾Ý¿âÊÇ·ñ´´½¨³É¹¦ÄØ£¿googleä¯ÀÀÀïÌṩÁ˺ÜÈËÐÔ»¯µÄ¹¤¾ß£¬¿´Í¼Æ¬À²
±¾µØÊý¾Ý¿â¾Í½éÉܵ½ÕâÀï°É