mysql - sql查询在slite +phonegap中不起作用(计算给定名称表中的元素数量)

Question

我计算了该表中元素退出的数量，但它不起作用？我就这样尝试

alert($('.caseName_h').val());

我收到此值的警报；代码被破坏后

var tt  =tx.executeSql('SELECT 1 FROM CaseTable WHERE CaseName ='+"'+ $('.caseName_h').val()+'");

我也是这样打电话的 var tt =tx.executeSql('SELECT 1 FROM CaseTable WHERE CaseName ='+ $(".caseName_h").val()); 警报(tt)

未定义来

Answer 1

尝试这样的事情......

db.transaction(function (tx) {
            var caseName_h = $('.caseName_h').val();
            $yoursql = 'SELECT 1 FROM CaseTable WHERE CaseName = "'+caseName_h+'"';
            tx.executeSql($yoursql, [], function (tx, results) {
                if ( results.rows.length == 0 ) {
                    console.log(results.rows);
                }
            });
});