Python genRow示例，genJS.genRow Python示例

示例#1

0

显示文件

colListStr = ','.join(colList)
emptyLst = []
for i in range(countRows[0]):
    emptyLst.append("")
print("<script type=\"text/javascript\">\n")
print("var count = %d;var table = %s;function getValues(event, n) {if(event.which == \"9\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));var val = focusedElement.attr(\"value\");var temp = ele/n;var tempDiff = temp%%1;temp = temp - tempDiff;var temp1 = ele%%n;table[temp][temp1] = val;}else if(event.which == \"13\") {var value = \"\";var i;var rowEntry = [];for(i = (count * n); i < ((count + 1) * n); i++) {var temp;temp = document.getElementById(\"attr\" + i);if(temp != null) {value = temp.value;if(value == \'\') {alert(\"enter attribute \" + (i + 1));break;}else {rowEntry.push(value);}}}table.push(rowEntry);count++;var newTableRow = $(document.createElement(\'tr\')).attr(\"id\", \'TableRow\' + count);newTableRow.after().html("%(int(countRows[0]), str(emptyLst)))
genJS.genColumnTag(int(countRows[0]), len(colList))
print(");newTableRow.appendTo(\"#idTable\");document.getElementById(\"attr\" + (count * n)).focus();}else if(event.which == \"37\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele > 0) {var input = document.getElementById(\"attr\" + (ele - 1));input.focus();var val = input.value;input.value = \'\';input.value = val;}else {var input = document.getElementById(\"attr\" + ele);input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == \"38\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele >= n) {var input = document.getElementById(\"attr\" + (ele - n));input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == \"39\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele < (count * n) + %d) {var input = document.getElementById(\"attr\" + (ele + 1));input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == \"40\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele < (count * n)) {var input = document.getElementById(\"attr\" + (ele + n));input.focus();var val = input.value;input.value = \'\';input.value = val;}}}function submitTable(n) {var i;var rowEntry = [];for(i = 0; i < n; i++)rowEntry.push(document.getElementById(\"attr\" + ((count * n) + i)).value);console.log(count);table.push(rowEntry);for(i = 0; i <= count; i++)console.log(table[i]);}</script>"%(len(colList)-1))

print("\n<body>\n<table id=\"idTable\" border=\"1\" style=\"width:100%\">\n<tr id=\"tableHead\">\n")
genJS.genAttrNames(colList)
print("</tr>")
tableDataQuery = "select %s from %s;"%(colListStr, sTablename)
tableData = []
for i in colList:
    tableData.append([])
try:
    cursor.execute(tableDataQuery)
    results = cursor.fetchall()
    for row in results:
        for i in range(len(row)):
            tableData[i].append(row[i])
    #print "tableData"
    #print tableData

except:
    print "Error: unable to fecth data"
conn.close()
genJS.genRow( tableData)
print("</table><input type = \"button\" value = \"Submit\" onkeydown=\"submitTable(%d)\" onclick=\"submitTable(%d)\"></body></html>"%(int(countRows[0]), int(countRows[0])))

示例#2

0

显示文件

文件： genTable.py 项目： pratik-pato/SE01_UI_Database-Programming

colListStr = ','.join(colList)
emptyLst = []
for i in range(countRows[0]):
    emptyLst.append("")
jsFile.write("<script type=\"text/javascript\">\n")
jsFile.write("var count = %d;var table = %s;function getValues(event, n) {if(event.which == \"9\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));var val = focusedElement.attr(\"value\");var temp = ele/n;var tempDiff = temp%%1;temp = temp - tempDiff;var temp1 = ele%%n;table[temp][temp1] = val;}else if(event.which == \"13\") {var value = \"\";var i;var rowEntry = [];for(i = (count * n); i < ((count + 1) * n); i++) {var temp;temp = document.getElementById(\"attr\" + i);if(temp != null) {value = temp.value;if(value == \'\') {alert(\"enter attribute \" + (i + 1));break;}else {rowEntry.push(value);}}}table.push(rowEntry);count++;var newTableRow = $(document.createElement(\'tr\')).attr(\"id\", \'TableRow\' + count);newTableRow.after().html("%(int(countRows[0]), str(emptyLst)))
genJS.genColumnTag(jsFile, int(countRows[0]), len(colList))
jsFile.write(");newTableRow.appendTo(\"#idTable\");document.getElementById(\"attr\" + (count * n)).focus();}else if(event.which == \"37\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele > 0) {var input = document.getElementById(\"attr\" + (ele - 1));input.focus();var val = input.value;input.value = \'\';input.value = val;}else {var input = document.getElementById(\"attr\" + ele);input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == \"38\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele >= n) {var input = document.getElementById(\"attr\" + (ele - n));input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == \"39\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele < (count * n) + %d) {var input = document.getElementById(\"attr\" + (ele + 1));input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == \"40\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele < (count * n)) {var input = document.getElementById(\"attr\" + (ele + n));input.focus();var val = input.value;input.value = \'\';input.value = val;}}}function submitTable(n) {var i;var rowEntry = [];for(i = 0; i < n; i++)rowEntry.push(document.getElementById(\"attr\" + ((count * n) + i)).value);console.log(count);table.push(rowEntry);for(i = 0; i <= count; i++)console.log(table[i]);}</script>"%(len(colList)-1))

jsFile.write("\n<body>\n<table id=\"idTable\" border=\"1\" style=\"width:100%\">\n<tr id=\"tableHead\">\n")
genJS.genAttrNames(jsFile, colList)
jsFile.write("</tr>")
tableDataQuery = "select %s from %s;"%(colListStr, sys.argv[2])
tableData = []
for i in colList:
    tableData.append([])
try:
    cursor.execute(tableDataQuery)
    results = cursor.fetchall()
    for row in results:
        for i in range(len(row)):
            tableData[i].append(row[i])
    print "tableData"
    print tableData

except:
    print "Error: unable to fecth data"
db.close()
genJS.genRow(jsFile, tableData)
jsFile.write("</table><input type = \"button\" value = \"Submit\" onkeydown=\"submitTable(%d)\" onclick=\"submitTable(%d)\"></body></html>"%(int(countRows[0]), int(countRows[0])))

示例#3

0

显示文件

genJS.genColumnTag(jsFile, int(countRows[0]), len(colList))
jsFile.write(
    ");newTableRow.appendTo(\"#idTable\");document.getElementById(\"attr\" + (count * n)).focus();}else if(event.which == \"37\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele > 0) {var input = document.getElementById(\"attr\" + (ele - 1));input.focus();var val = input.value;input.value = \'\';input.value = val;}else {var input = document.getElementById(\"attr\" + ele);input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == \"38\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele >= n) {var input = document.getElementById(\"attr\" + (ele - n));input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == \"39\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele < (count * n) + %d) {var input = document.getElementById(\"attr\" + (ele + 1));input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == \"40\") {var focusedElement = $(\":focus\");var ele = Number(focusedElement.attr(\"id\").slice(4));if(ele < (count * n)) {var input = document.getElementById(\"attr\" + (ele + n));input.focus();var val = input.value;input.value = \'\';input.value = val;}}}function submitTable(n) {var i;var rowEntry = [];for(i = 0; i < n; i++)rowEntry.push(document.getElementById(\"attr\" + ((count * n) + i)).value);console.log(count);table.push(rowEntry);for(i = 0; i <= count; i++)console.log(table[i]);}</script>"
    % (len(colList) - 1))

jsFile.write(
    "\n<body>\n<table id=\"idTable\" border=\"1\" style=\"width:100%\">\n<tr id=\"tableHead\">\n"
)
genJS.genAttrNames(jsFile, colList)
jsFile.write("</tr>")
tableDataQuery = "select %s from %s;" % (colListStr, sys.argv[1])
tableData = []
for i in colList:
    tableData.append([])
try:
    cursor.execute(tableDataQuery)
    results = cursor.fetchall()
    for row in results:
        for i in range(len(row)):
            tableData[i].append(row[i])
    print "tableData"
    print tableData

except:
    print "Error: unable to fecth data"
db.close()
genJS.genRow(jsFile, tableData)
jsFile.write(
    "</table><input type = \"button\" value = \"Submit\" onkeydown=\"submitTable(%d)\" onclick=\"submitTable(%d)\"></body></html>"
    % (int(countRows[0]), int(countRows[0])))

示例#4

0

显示文件

文件： genTable_F.py 项目： pratik-pato/SE01_UI_Database-Programming

genJS.genColumnTag(int(countRows[0]), len(colList))
print (
    ');newTableRow.appendTo("#idTable");document.getElementById("attr" + (count * n)).focus();}else if(event.which == "37") {var focusedElement = $(":focus");var ele = Number(focusedElement.attr("id").slice(4));if(ele > 0) {var input = document.getElementById("attr" + (ele - 1));input.focus();var val = input.value;input.value = \'\';input.value = val;}else {var input = document.getElementById("attr" + ele);input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == "38") {var focusedElement = $(":focus");var ele = Number(focusedElement.attr("id").slice(4));if(ele >= n) {var input = document.getElementById("attr" + (ele - n));input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == "39") {var focusedElement = $(":focus");var ele = Number(focusedElement.attr("id").slice(4));if(ele < (count * n) + %d) {var input = document.getElementById("attr" + (ele + 1));input.focus();var val = input.value;input.value = \'\';input.value = val;}}else if(event.which == "40") {var focusedElement = $(":focus");var ele = Number(focusedElement.attr("id").slice(4));if(ele < (count * n)) {var input = document.getElementById("attr" + (ele + n));input.focus();var val = input.value;input.value = \'\';input.value = val;}}}function submitTable(n) {var i;var rowEntry = [];for(i = 0; i < n; i++)rowEntry.push(document.getElementById("attr" + ((count * n) + i)).value);console.log(count);table.push(rowEntry);for(i = 0; i <= count; i++)console.log(table[i]);}</script>'
    % (len(colList) - 1)
)

print ('\n<body>\n<table id="idTable" border="1" style="width:100%">\n<tr id="tableHead">\n')
genJS.genAttrNames(colList)
print ("</tr>")
tableDataQuery = "select %s from %s;" % (colListStr, sTablename)
tableData = []
for i in colList:
    tableData.append([])
try:
    cursor.execute(tableDataQuery)
    results = cursor.fetchall()
    for row in results:
        for i in range(len(row)):
            tableData[i].append(row[i])
    # print "tableData"
    # print tableData

except:
    print "Error: unable to fecth data"
conn.close()
genJS.genRow(tableData)
print (
    '</table><input type = "button" value = "Submit" onkeydown="submitTable(%d)" onclick="submitTable(%d)"></body></html>'
    % (int(countRows[0]), int(countRows[0]))
)