function websqlCreateTable(tablename){
var creatTableSQL = 'CREATE TABLE IF NOT EXISTS '+ tablename + ' (rowid INTEGER PRIMARY KEY AUTOINCREMENT,NAME,AGE,HEIGHT,WGHT)';
dataBase.transaction(function(ctx,result){
ctx.executeSql(creatTableSQL,[],function(ctx,result){
alert("表创建成功:"+tablename);
},function(tx,error){
alert("表创建失败:"+tablename+" " +error.message);
});
});
}
function websqlInsertDataToTable(tablename,NAME,AGE,HEIGHT,WGHT){
var insertTableSQL='INSERT INTO ' + tablename + ' (NAME,AGE,HEIGHT,WGHT) VALUES (?,?,?,?)';
var ret = 0;
dataBase.transaction(function(ctx){
ctx.executeSql(insertTableSQL,[NAME,AGE,HEIGHT,WGHT],function (ctx,result){
console.log("插入" + tablename + NAME + "成功");
//alert("插入成功");
},
function (tx, error) {
alert('插入失败: ' + error.message);
ret = 1;
});
});
return ret;
}
插入失败,1table websqlTable has no column named WGHT
是语句有问题吗?
1 个回复
1***@qq.com (作者) - 火箭冲上天
将WGHT改为 WEIGTH,就能插入成功,这个字段是有什么要求吗?求解答