?? ??????

HTML5? ?? ??? localStorage? sessionStorage? ????? ? ? ??? ??? ??? ???? ?? ???? ??? ? ??? ??? ? ?????? ????? ?????. ??? ?? HTML5? ???? ? ?????? ??? ???? JS API? ?? ?? ???? ?? ?? ??????? ??? ? ?? ?? ?? SQL CRUD ??? ???? ???? ? ??????? ???? ???? ?? ???? ??? ? ?? ???? ????. ???? ?? API? ?? ???? ???? ???????.

?? ??????? ???? ?? ???? ??? ??? ????.

1??: openDatabase ???: ??????? ????? ?? ??? ????.

2??: ? ?? ???? ??? ?????? ??? ??? ???? ???? ???? ?????. ? ???? ?? ??? ?? ???? ???? ????? ????? ??? ? ????.

3??: ExecutionSql ???? ?? ??? ?????. ?? ??? CRUD? ? ????.

???? ?? ???? ????? ???? ???????.

1. openDatabase ???

//Demo: ??????? ????? ?????. ??????? ??? ?????.

var dataBase = openDatabase("student", "1.0", "學生表", 1024 * 1024, function () { });

openDatabase ???? ?? ??????? ???. ??????? ???? ?? ?? ??????? ??? ?? ????. ?? ????? ??? ??? ????.

?????? ??.
?? ?????? ??? 1.0?? ?????. ?? ??? ??? ????.
??????? ?? ?????.
??? ??????? ??? ?????(??? kb).
?? ??(????).

?? ?? ? ??????? ??? ? ?????.

2. db.transaction ???

? ?? ??? ??? ? ????. ? ??? ??? ??? ????? ??? ????? ??? ? ????. ?? ?? ? ??? ?? SQL ????? ??? ? ????.

3.executeSql ????

ts.executeSql(sqlQuery,[value1,value2..],dataHandler,errorHandler)

???? ??:

qlQuery: ??, ??, ????, ?? ? ????? ???? ?? SQL ?;
[value1, value2..]: sql ?? ???? ?? ?? ??? ?????.executeSql ????? s> ?? ??? ?? ??? "?"? ?? ? ??? ?? ??? ??? ???? ? ?? ????
dataHandler: ???? ??? ?? ?? ??? ?? ? ?? ?? ?????.
errorHandler: ?? ?? ? ???? ?? ??

???? ??

??? ??

<!DOCTYPE HTML> <html> <head> <script type="text/javascript"> var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024); var msg; db.transaction(function (tx) { tx.executeSql('CREATE TABLE IF NOT EXISTS LOGS (id unique, log)'); tx.executeSql('INSERT INTO LOGS (id, log) VALUES (1, "php中文網(wǎng)")'); tx.executeSql('INSERT INTO LOGS (id, log) VALUES (2, "ask.php.cn")'); msg = '<p>數(shù)據(jù)表已創(chuàng)建，且插入了兩條數(shù)據(jù)。</p>'; document.querySelector('#status').innerHTML = msg; }); db.transaction(function (tx) { tx.executeSql('SELECT * FROM LOGS', [], function (tx, results) { var len = results.rows.length, i; msg = "<p>查詢記錄條數(shù): " + len + "</p>"; document.querySelector('#status').innerHTML += msg; for (i = 0; i < len; i++){ msg = "<p><b>" + results.rows.item(i).log + "</b></p>"; document.querySelector('#status').innerHTML += msg; } }, null); }); </script> </head> <body> <div id="status" name="status">狀態(tài)信息</div> </body> </html>

?????? ???

????