function show() {
dataBase.transaction(function (tx) {
tx.executeSql(
"select * from user",
[],
function (tx, result) {
//执行成功的回调函数
//在这里对result 做你想要做的事情吧.
var content = document.getElementById('content');//获取显示结果的div
var len = result.rows.length;
var recordset = result.rows.item;
console.log(len)
console.log(recordset);
var msg='<table border="1" cellpadding="10" cellspacing="0"><tr><td>用户名</td><td>密码</td><td>电子邮箱</td><td>兴趣爱好</td><td>删除 | 修改</td></tr>';
if(len > 0){
for(var i = 0; i < len; i++){
msg +='<tr><td>'+ result.rows.item(i)["username"] +'</td>';
msg+= '<td>'+result.rows.item(i)["password"] + '</td>';
msg += '<td>'+result.rows.item(i)["email"] + '</td>';
msg+= '<td>'+result.rows.item(i).hobby + '</td</tr>';
}
msg+="</table>";
alert(msg);
}
content.innerHTML=msg;
},
function (tx, error) {
alert('查询失败: ' + error.message);
});
});
}
result.rows.item(i).hobby要使用这种方方法才能正常显示
解决