如何在数据库HTML5中实现通用功能? [英] How to make generic function in database HTML5?

问题描述

能否请您告诉我如何在数据库HTML5中创建通用函数.这意味着我将传递"Table"的名称.或者，如果可能的话，我们可以传递数据类型为table的列名称?

can you please tell me how to make generic function in database HTML5.It mean I will pass name of "Table" .Or If possible we can pass column names of table with data type ?

您能举个例子吗?

使用时出现错误 http://jsfiddle.net/RnheY/1/

var html5rocks = {};
html5rocks.webdb = {};
html5rocks.webdb.db = null;
html5rocks.webdb.open = function() {
 var dbSize = 5 * 1024 * 1024; // 5MB
  html5rocks.webdb.db = openDatabase("DataBaseName", "1.0", "Todo manager", dbSize);
}


html5rocks.webdb.createTable = function(tableName) {
  var db = html5rocks.webdb.db;

  db.transaction(function(tx) {
    tx.executeSql("CREATE TABLE IF NOT EXISTS "+tableName+"(ID INTEGER PRIMARY KEY ASC, todo TEXT, added_on DATETIME)", []);
  });
}
$(document).ready(function(){
$( "#test" ).click(function() {
  alert( "Handler for .click() called." );
      html5rocks.webdb.open();
  html5rocks.webdb.createTable("Student");
});
                            });

推荐答案

您可以通过创建一个数组并在全局级别上对其进行定义来做到这一点. 请找到有效的 DEMO

You can do this by creating an array and defining it on global level. Please find the working DEMO

<input type="text" id="UserName" name="UserName" placeholder="Username" value="Rohit">
<input type="password" id="Password" name="Password" placeholder="Password" value="Password">
<input type="submit" id="submit" value="Log in" data-mini="true">

JQUERY脚本

var arrcolumnName = ['UserName', 'Password'];
var tablename = 'tbl_Login'


$('#submit').click(function () {
    submitForm();
});

function submitForm() {
    var _UserName = $('#UserName').val();
    var _Password = $('#Password').val();
    var arrValue = _UserName + '|' + _Password;
    var arr = arrValue.split("|");
    InsertIntoTable(tablename, arrcolumnName, arr);
 }

function InsertQuery(tablename, arrColumn, arrValues) {
    var query = "";
    query += "INSERT INTO " + tablename + " (";
    for (i = 0; i < arrColumn.length; i++)
    query += arrColumn[i] + ",";

    query = query.substring(0, query.length - 1);
    query += ") VALUES ("
    for (i = 0; i < arrValues.length; i++)
    query += "'" + arrValues[i] + "',";
    query = query.substring(0, query.length - 1);
    query += ")"
    return query;
}


function InsertIntoTable(tablename, arrColumn, arrValue) {
    var db = CreateDB();
    var Query = InsertQuery(tablename, arrColumn, arrValue)
    db.transaction(populateDB, errorDB, successDB);

function populateDB(tx) {
    CreateTable(tablename, arrcolumnName, tx);
    tx.executeSql(Query);
}

function errorDB(err) {
    alert(err.message);
}

function successDB() {
    alert('Insert Success!!!');
}
}


function CreateDB() {
    var db = window.openDatabase('TrialDB1', '', 'my first database', 5 * 1024 * 1024);
    return db;
}

function CreateTable(tablename, arrColumn, tx) {
    var Query = CreateTableQuery(tablename, arrColumn);
    tx.executeSql(Query);
}

function CreateTableQuery(tablename, arrColumn) {
    var query = "";
    query += "CREATE TABLE IF NOT EXISTS " + tablename + " (";
    for (i = 0; i < arrColumn.length; i++)
    query += arrColumn[i] + ",";

    query = query.substring(0, query.length - 1);
    query += ")"
    return query;
}

这篇关于如何在数据库HTML5中实现通用功能?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！