尝试着研究了下Html5访问本地数据库,感觉还不错,用的是chome浏览器,sqlite数据库。
xp系统默认的数据库存放路径C:\Documents and Settings\Administrator\Local Settings\Application Data\Google\Chrome\User Data\Default\databases\
具体的数据库文件要动手找,用SQLitespy可以打开数据库
示例代码:
<html manifest="mymanifest.manifest">
<head>
<meta http-equiv="Content-Type" content="text/html; content="no-cache" charset=utf-8" />
<script type="text/javascript" src="jquery-1.7.2.min.js"></script>
<script>
$(document).ready(function(){
databaseTest();
});
function databaseTest(){
//open database
var db = openDatabase('mydb', '1.0', 'Test DB', 2 * 1024 * 1024);
db.transaction(function (tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS testHtml (id unique, contentText)');
tx.executeSql('INSERT INTO testHtml (contentText) VALUES ("insert data test1!")');
// tx.executeSql('delete from testHtml');
});
db.transaction(function(tx){
tx.executeSql('SELECT * FROM testHtml',[],function(tx,result){
var len=result.rows.length;
var msg = "<p>Found rows: " + len + "</p>";
$("#testinfo").append(msg);
for(var i = 0; i < len ; i++){
var str=result.rows.item(i);
$("#testvalue").append(str.contentText);
}
},null);
});
}
</script>
</head>
<body>
<div>here is test info:</div>
<div id="testinfo"></div>
<div>here is test value:</div>
<div id="testvalue"></div>
</body>