不想写了,直接上代码,给需要的人
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
<script type="text/javascript" src="js/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="js/yz.sql.js"></script>
</head>
<body>
<div id="main"></div>
</body>
<script>
var xhr = new XMLHttpRequest();
xhr.open('GET', 'movieapp.db', true);
xhr.responseType = 'arraybuffer';
xhr.onload = function(e) {
var uInt8Array = new Uint8Array(this.response);
var db = new SQL.Database(uInt8Array);
var contents = db.exec("SELECT * FROM movie_tb");
console.log(contents)
var cvalue = contents[0].values;
var html = "";
for(var i = 0;i<cvalue.length;i++){
var name = cvalue[i][0];
var username = cvalue[i][1];
var id = cvalue[i][2];
html += name + "|" + username + "|" + id +"<br/>"
}
$("#main").html(html)
};
xhr.send();
</script>
</html>
以上代码中有一个JS库,留言留下邮箱哈,我单独发