偶做的动态查询,给点意见

eyusir 2003-10-30 08:22:48

有几个bug没有修正,请帮助
1.查询后没有刷新表格,应该第二次查询时是原始的空值
2.没有把查询结果赋给jsp
3.只有一条记录时,有时查不出结果

<%@ page contentType="text/html; " language="java" import="java.sql.*" %>
<html>
<link href="text.css" rel="stylesheet" type="text/css">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
</head>
<body onLoad="javascript:addRow()">
<table width="99%" border="0" align="center" cellpadding="1" cellspacing="0">
<tr>
<td><input type="image" name="obj" id="obj" src="2b.gif" onClick="v()">
<textarea name="textarea" cols="50" rows="3" class="bt2"></textarea>
</td>
</tr>
<tr>
<td>
<div id="ffind" style="position:absolute; z-index:999; visibility: hidden; left: 200px; width :400px;">
<table width="100%" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#006666" style="FILTER: progid:DXImageTransform.Microsoft.Shadow(color=#9DA069,direction=135,strength=3)">
<tr>
<td height="51" bgcolor="#FFFFFF">
<table width="100%" 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>
<td><div align="center">刪除</div></td>
</tr>
</table>
<p align ="center">
<input type="image" src="c.gif" onClick="javascript:hidden()">
<input type="image" src="f.gif" onClick="javascript:lookdata()">
</p>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
<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='field' id=point><option value=''></><option value='name'>名稱 </><option value='sex'>性別</><option value='address'>地址</></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='fh' ><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='z' ondblclick='addRow()' 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 value=''></><option value='and'>並且</><option value='or'>或者</></select></div>";
}
else if (i == 4) {
document.all.myTable.rows(point).insertCell();
document.all.myTable.rows(point).cells(i).innerHTML = "<div align=center><a href='javascript:delRow("+point+")'>刪除</a></div>";
}
}
}
if(lenRow == 1)
{
for(i = 0; i < 4; i++)
{
document.all.myTable.rows(0).insertCell();
document.all.myTable.rows(0).cells(i).innerHTML = " ";
}
}
}
</script>
<script>
function delRow(i)
{
var lenRow1 = document.all.myTable.rows.length;
if (lenRow1 > 2) {
document.all.myTable.deleteRow(i);

for (i=1;i<lenRow1-1;i++){ //重新分配id
document.all.myTable.rows(i).cells(4).innerHTML = "<div align=center><a href='javascript:delRow("+i+")'>刪除</a></div>";
}
}
}
function hidden()
{
var lenRow3 = document.all.myTable.rows.length;
document.all.ffind.style.visibility='hidden';
// for (i<lenRow3;i>0;i--){ //隱藏層後刪除查詢過的記錄
// document.all.myTable.deleteRow(i);
// }
// addRow();
}

function lookdata()
{
var lenRow2 = document.all.myTable.rows.length;
var sql;
document.all.textarea.value=''
for (i=0;i < lenRow2-1; i++)
{
if (document.all.field[i].value!=""&&document.all.z[i].value!="")
{
if (i==0)
{
document.all.textarea.value =(document.all.field[0].value +' '+ document.all.fh[0].value +' '+"\'"+ document.all.z[0].value+ "\'");
}
if (i>0)
{
document.all.textarea.value +=' '+(document.all.lj[i-1].value+' '+document.all.field[i].value +' '+ document.all.fh[i].value +' '+"\'"+ document.all.z[i].value+ "\'");
}
// }
}
hidden();
// location.reload();
}
function v()
{
var ttop = document.all.obj.offsetTop;
sObj=document.all.ffind;
if (ttop >90){
sObj.style.top=ttop-90;
sObj.style.left=200;
}
if (ttop <90){
sObj.style.top=ttop;
sObj.style.left=200;
}
sObj.style.visibility='visible';
}
</script>
</body>
</html>

...全文