<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>创建数据库</title>
<script type="text/javascript" src="js/phonegap-1.1.0.js" ></script>
<script type="text/javascript" charset="UTF-8">
document.addEventListener("deviceready",onDeviceReady,false);
function populateDB(tx){
tx.executeSql('drop table if exists test1');
tx.executeSql('create table if not exists test1(id unique,name)');
tx.executeSql('insert into test1(id,name) values(1,"Tony")');
tx.executeSql('insert into test1(id,name) value(2,"Till")');
tx.executeSql('insert into test1(id,name) value(3,"Tomas")');
}
function queryDB(tx){
tx.executeSql('select * from test1',[],querySuccess,errorDB);
}
function querySuccess(tx,results){
var len=results.rows.length;
var status=document.getElementById("status");
var strings="rows:"+len+"</br>";
for (var i=0;i<len;i++) {
string +=results.rows.item(i).name+"<br/>";
}
status.innerHTML=strings;
}
function errorDB(err){
alert("error processing sql:"+err.code);
}
function successDB(){
var db=window.openDatabase("Test","1.0","Test",200000);
db.transaction(queryDB,errorDB);
}
function onDeviceReady(){
var db=window.openDatabase("Test","1.0","Test",200000);
db.transaction(populateDB,errorDB,successDB);
}
</script>
</head>
<body>
<h1>名称:</h1>
<div ID="status"></div>
</body>
</html>
<html>
<head>
<meta charset="utf-8">
<title>创建数据库</title>
<script type="text/javascript" src="js/phonegap-1.1.0.js" ></script>
<script type="text/javascript" charset="UTF-8">
document.addEventListener("deviceready",onDeviceReady,false);
function populateDB(tx){
tx.executeSql('drop table if exists test1');
tx.executeSql('create table if not exists test1(id unique,name)');
tx.executeSql('insert into test1(id,name) values(1,"Tony")');
tx.executeSql('insert into test1(id,name) value(2,"Till")');
tx.executeSql('insert into test1(id,name) value(3,"Tomas")');
}
function queryDB(tx){
tx.executeSql('select * from test1',[],querySuccess,errorDB);
}
function querySuccess(tx,results){
var len=results.rows.length;
var status=document.getElementById("status");
var strings="rows:"+len+"</br>";
for (var i=0;i<len;i++) {
string +=results.rows.item(i).name+"<br/>";
}
status.innerHTML=strings;
}
function errorDB(err){
alert("error processing sql:"+err.code);
}
function successDB(){
var db=window.openDatabase("Test","1.0","Test",200000);
db.transaction(queryDB,errorDB);
}
function onDeviceReady(){
var db=window.openDatabase("Test","1.0","Test",200000);
db.transaction(populateDB,errorDB,successDB);
}
</script>
</head>
<body>
<h1>名称:</h1>
<div ID="status"></div>
</body>
</html>