javascript写的万能查询,请问怎么读出值

eyusir 2003-10-25 03:03:28

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<link href="text.css" rel="stylesheet" type="text/css">
</head>
<body onLoad="javascript:addRow()">
<p> </p>
<p> </p>
<script>
function addRow()
{
myNewRow = document.all.myTable.insertRow();
var lenRow = document.all.myTable.rows.length;

if(lenRow > 1)
{
var point = myNewRow.rowIndex;
var lenCol = document.all.myTable.rows(0).cells.length;
for (i=0; i < lenCol; i++)
{
if (i == 0) {
document.all.myTable.rows(point).insertCell();
document.all.myTable.rows(point).cells(i).innerHTML = "<div align=center><select name='select'><option value=''></><option value='name'>名稱 </><option value='sex'>性別</><option value='add'>地址</></select></div>";
}
else if (i == 1) {
document.all.myTable.rows(point).insertCell();
document.all.myTable.rows(point).cells(i).innerHTML = "<div align=center><select name='select'><option value=''></><option value='>'>></><option value='<'><</><option value='='>=</><option value='like'>包含</></select></div>";
}
else if (i == 2) {
document.all.myTable.rows(point).insertCell();
document.all.myTable.rows(point).cells(i).innerHTML = "<div align=center><input type='text' name='value' class=bt2></div>";
}
else if (i == 3) {
document.all.myTable.rows(point).insertCell();
document.all.myTable.rows(point).cells(i).innerHTML = "<div align=center><select name='lj' onChange='javascript: addRow()'><option ></><option value='and'>並且</><option value='or'>或者</></select></div>";
}
}
}
if(lenRow == 1)
{
for(i = 0; i < 4; i++)
{
document.all.myTable.rows(0).insertCell();
document.all.myTable.rows(0).cells(i).innerHTML = " ";
}
}
}
function delRow()
{
var lenRow1 = document.all.myTable.rows.length;
if (lenRow1 > 2) {
document.all.myTable.deleteRow();
}
}
</script>
<script>
function lookdate()
{
var Rows = document.all.myTable.rows.length;
}
</script>
<table width="90%" border=1 align="center" cellpadding="0" cellspacing="0" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF" id=myTable name=myTable>
<tr bgcolor="#DBDBDB">
<td><div align="center">字段名</div></td>
<td><div align="center">比較符</div></td>
<td><div align="center">查詢值</div></td>
<td><div align="center">關連符</div></td>
</tr>
</table>
<p align ="center"><a href="javascript: delRow()">刪除條件</a>　　
<a href="javascript: lookdate()">查詢</a></p>
</body>
</html>

sql ="select * from username"
请问怎样点查询得到sql的查询条件语句?

...全文