分类导航

jQuery 发布时间：2022-03-30 发布网站：大佬教程 code.js-code.com

大佬教程收集整理的这篇文章主要介绍了jquery – executeSql查询出错，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

我正在开发一个cordova应用程序,我需要创建一个登录名和一个register.but我在运行应用程序时收到一个名为“Error processing sql：undefined”的错误.我明白我因为executesql而收到此错误在insertUSERREG中.但我不知道为什么我得到这个错误.请帮助.

html文件：

<form method="get" action="" onsubmit="return RegisteringUsers()">
        <fieldset class="ui-field-contain">
        <label for="name">Name:</label>
        <input type="text" name="name" id="name" value="" placeholder="Name"/>
        <label for="username">Account User Name:</label>
        <input type="text" name="username" id="username" value="" placeholder="User Name"/>
        <label for="email">Email: </label>
        <input type="email" name="email" id="email" value="" placeholder="Email"/>
        <label for="password">password: </label>
         <input type="password" name="password" id="password" value="" placeholder="Your password" autocomplete="off"/>
         <input type="Submit" name="submit" id="submit" value="Register" />
      </fieldset>
    </form>

javascrpit文件：

document.addEventListener("deviceready",onDeviceReady,false);
var db ;
function onDeviceReady() {
     db = window.openDatabase("Database","1.0","Cordova Demo",2000000000);
    db.transaction(createdb,error1,successCB);
    window.localStorage.setItem("user","Not Logged In");
}

function createdb(tX) {
    tx.executesql('create table IF NOT EXISTS USERSREG (db_name,db_una,db_email,db_password)');
    tx.executesql('drop table IF EXISTS CARTORDER ');
    tx.executesql('create table IF NOT EXISTS CARTORDER (db_una,db_itemname,db_itemPrice,db_qty)');
}
function errorCB(err) {
    alert("Error processing sql: "+err.codE);
}

function successCB() {

}  



 function RegisteringUsers(){   
 db.transaction(insertUSERREG,error2); 

 return false;
}  
 function insertUSERREG(tX){   
    var insertname = $('[name="name"]').val();
    var insertuna= $('[name="username"]').val();
    var insertemail= $('[name="email"]').val();
    var insertpassword= $('[name="password"]').val();           
    var sql='INSERT INTO USERSREG (db_name,db_password) VALUES (?,?,?)';



     tx.executesql(sql,[insertname,insertuna,insertemail,insertpassword],successqueryDB,errorCB);

 }
 function successqueryDB(tX) {
    alert("Registered Sucessfully");
        $.mobile.changePage ("Home.html",{reverse: false,transition :"pop"});
} 
 function error2 () {
  alert("error2");
  }