當前位置: 王朝網路 >> other >> 表單查詢顯示翻頁等不可用,提示對象不支持此屬性或方法，切記查詢按鈕的name值不能爲submit

表單查詢顯示翻頁等不可用,提示對象不支持此屬性或方法，切記查詢按鈕的name值不能爲submit

2007-03-16 11:15:36 編輯來源:互聯網简体版手機版移動版評論字體: 小|中|大

切記查詢按鈕的name值不能爲submit。其中原代碼如下：

我們應當改爲：

<input name="submit1" type="submit" class="button" style="WIDTH: 80px" value="查詢">，不然會出現表單查詢顯示是點下一步，將繼續向下一頁翻頁，但是點上一頁，下一頁，等都不可用。

原代碼如下：

<%@ page contentType="text/html; charset=gbk" language="java" import="java.sql.*" errorPage="" %>

<%@ page import ="pub.*" %>

<%@ page import="leader.*"%>

int x=Check.CheckPage(request,"leader_employee_search");

String userid=(String)session.getAttribute("userid");

LeaderBean leader=new LeaderBean();

String Error="";

if (x==1){

Error="<script>alert('你已掉線，需要重新登陸!');top.location.href='../login.jsp'</script>";

}else{

if (x==2){

Error="<script>alert('你無權進入該頁面!');history.back();</script>";

}

if(leader.checkCompetenceCorp(userid)==0){

Error="<script>alert('你無權進入該頁面!');history.back();</script>";

}

<%=Error%>

if (x!=0){

return;

}

<html>

<head>

<title>查詢其管屬員工信息</title>

var req;

var number='all'; //外,下拉框可顯示全部部門&處

window.onload=function()

{

}

function Change_Select(flag)

{

var flag1=flag;//是爲了解決onchange()後值要改變＆onload()(查詢提交)後值要保存的問題

//alert(flag1);

var zhi = document.getElementById('Corp').value;

var hidden_depart=document.all.HiddenKeyDepart.value;

var hidden_UserID=document.all.HiddenUserId.value;

var url = "../selectCropDepartLeader?state="+number+"&keyDepart="+hidden_depart+"&id=" + escape(zhi)+"&flag="+flag1+"&leaderid="+hidden_UserID;

//alert(url);

if (window.XMLHttpRequest) {

req = new XMLHttpRequest();

}else if (window.ActiveXObject) {

req = new ActiveXObject("Microsoft.XMLHTTP");

}

if(req){

req.open("GET", url, true);

req.onreadystatechange = callback;

req.send(null);

}

function callback() {

if (req.readyState == 4) {

if (req.status == 200) {

parseMessage();

// update the HTML DOM based on whether or not message is valid

}else{

alert ("Not able to retrieve description" +req.status+req.statusText);

}

function parseMessage() {

var xmlDoc = req.responseXML.documentElement;

var xSel = xmlDoc.getElementsByTagName('select');

var select_root = document.getElementById('Depart');

select_root.options.length=0;

for(var i=0;i<xSel.length;i++)

{

var xValue = xSel[i].childNodes[0].firstChild.nodeValue;

var xText = xSel[i].childNodes[1].firstChild.nodeValue;

var option = new Option(xText,xValue);

try

{

select_root.add(option);

}

catch(e)

{

}

function chan(){

document.formlist.submit();

}

</script>

</head>

String strCorp=request.getParameter("Corp");

String strDepart=request.getParameter("Depart");

//String strPositionName=request.getParameter("PositionName") ;

//String strLeaderName=request.getParameter("LeaderName");

if(strCorp==null) strCorp="";

if(strDepart==null) strDepart="";

//if(strChu==null) strChu="";

//if(strPositionName == null) strPositionName="0";

//if(strLeaderName==null) strLeaderName="";

String strCropID1=(String)session.getAttribute("cropid");

//判斷如果登陸員工是總公司之外的就只顯示此員工所在的公司

//if(strCropID1.equals("1")==false) strCorp=strCropID1;

Conn conn=new Conn();

DataTable dtChuName=new DataTable();

//String SqlChuName="";

<tr>

<DIV align="left"><FONT face="宋體" color="#ffffff">  當前位置：領導查詢>>查詢其管屬員工信息 </FONT>

</DIV>

</FONT>

</td>

</tr>

</table>

<tr>

類型： </td>

</select></td>

</tr>

</table>

DataGrid dg=new DataGrid("1",request,"formlist",15,"");

DataGridColumnItem dgci=new DataGridColumnItem();

dgci.ColType=ColumnItemType.BindDataColumn;

dgci.HeadText="人員編號";

dgci.BindField="UserCode";

dgci.Width="10%";

dg.addColumn(dgci);

dgci=new DataGridColumnItem();

dgci.ColType=ColumnItemType.BindDataColumn;

dgci.HeadText="人員姓名";

dgci.BindField="UserName";

dgci.Width="15%";

dg.addColumn(dgci);

dgci=new DataGridColumnItem();

dgci.ColType=ColumnItemType.BindDataColumn;

dgci.HeadText="公司";

dgci.BindField="CropName";

dgci.Width="10%";

dg.addColumn(dgci);

dgci=new DataGridColumnItem();

dgci.ColType=ColumnItemType.BindDataColumn;

dgci.HeadText="部門";

dgci.BindField="DepartName";

dgci.Width="15%";

dg.addColumn(dgci);

dgci=new DataGridColumnItem();

dgci.ColType=ColumnItemType.BindDataColumn;

dgci.HeadText="性別";

dgci.BindField="Sex";

dgci.Width="10%";

dg.addColumn(dgci);

dgci=new DataGridColumnItem();

dgci.ColType=ColumnItemType.BindDataColumn;

dgci.HeadText="職務";

dgci.BindField="RankName";

dgci.Width="20%";

dg.addColumn(dgci);

dgci=new DataGridColumnItem();

dgci.ColType=ColumnItemType.LinkButtonColumn;

//dgci.HeadText="編輯";

dgci.BindField="詳細信息";

dgci.Script="../employee/employee_all_info_detail.jsp?Key=[UserID]";

dgci.Width="20%";

dg.addColumn(dgci);

String cropid=(String)session.getAttribute("cropid");

String roleid=(String)session.getAttribute("roleid");

//System.out.println("userid:"+userid);

String Sql="";

//int a[]=new int[20];

String strCropID[]=new String[100];

String strDepartID[]=new String[100];

DataTable dt =new DataTable();

//String departid=(String)session.getAttribute("departid");

String mSql_competence="Select CropID,DepartID from leadquery02_competence c where c.UserID="+userid+" ";

//System.out.println("testme");

//System.out.println("mSql_competence:"+mSql_competence);

Sql="select DISTINCT a.UserID,UserCode,UserName,b.sex,";

Sql+=" CropName=(Select MachName from sys04_Machine c where a.CropID=c.MachID),";

Sql+=" DepartName=(select MachName from sys04_Machine d where a.DepartID=d.MachID ),";

Sql+=" RankName=(select RankName from Basic02_Rank where Rankid=rank)";

//Sql+=" from employee01_Basic a , employee02_info b ";

//Sql+=" where a.UserID=b.UserID ";

Sql+=" FROM employee01_Basic a LEFT OUTER JOIN employee02_info b ON a.UserID = b.UserID ";

if(conn.querySql(mSql_competence,dt)){

if(dt.getRowCount()>0){

Sql+=" Where ( ";

for(int i=0;i<dt.getRowCount();i++){

strCropID[i] = dt.getItemForName(i,"CropID");

strDepartID[i] = dt.getItemForName(i,"DepartID");

//System.out.println("strCropID:"+strCropID[i]);

//System.out.println("strDepartID:"+strDepartID[i]);

if(i>0 ){

Sql+=" OR ";

}

if(strDepartID[i] != null && strDepartID[i].equals("")==false ){

Sql+=" ( a.CropID="+strCropID[i]+" ";

Sql+=" AND a.DepartID="+strDepartID[i]+" )";

}

else{

Sql+=" ( a.CropID="+strCropID[i]+" )";

}

Sql+=" ) ";

//System.out.println("Sqlleader1:"+Sql);

}

//System.out.println("Sqlleader:"+Sql);

String userstate=request.getParameter("userstate");

if (userstate!=null){

Sql+=" AND a.UserState='"+userstate+"' ";

out.println("<script>document.all.userstate.value='"+userstate+"';</script>");

}else{

Sql+=" AND a.UserState='0' ";

}

String hiddensql=request.getParameter("hiddensql");

if (hiddensql!=null && hiddensql.length()>0){

Sql+=" and "+hiddensql;

out.println("<script>document.all.hiddensql.value='"+hiddensql+"';</script>");

}

if(strCorp.length()>0)

Sql+=" AND a.CropID = "+PubClass.getString(strCorp)+" ";

if (strDepart.length()>0 && strDepart.equals("Pselect")==false )

Sql+= " AND a.DepartID = "+PubClass.getString(strDepart)+" ";

System.out.println("Sql:"+Sql);

if (conn.execSql(Sql)){

}

else{

response.setCharacterEncoding("GBK");

String LastOperMsg="不能讀取權限數據!";

out.println("<script>alert('"+LastOperMsg+"');window.returnValue=0;window.close();</script>");

}

dg.bindSql(Sql);

out.print(dg.ShowGrid());

String m1Script="";

m1Script=PubClass.BindAllCorp_Leader_List("document.all.Corp",userid);

//m1Script=PubClass.BindAllCorpList2("document.all.Corp");

<%= m1Script%>

String sLeaderList="";

//System.out.println("strDepart2:"+PubClass.getString(strDepart));

sLeaderList+="<script>document.all.Corp.value='"+PubClass.getString(strCorp)+"';</script>";

sLeaderList+="<script>document.all.Depart.value='"+PubClass.getString(strDepart)+"';</script>";

<%=sLeaderList%>

</form>

</body>

</html>

頁面錯誤如圖所示：

注意這裏的錯誤和order by的提示是一樣的，但問題不一樣。

爲了解決這個問題：

我們首先跟蹤程序：dg.ShowGrid()：

發現要執行：String num=conn.lookupfirst("select count(*) as cnum from ("+mSql+") as awqertc1q ","cnum");

我們將上面打印的sql語句帶入這裏：

SQl：select DISTINCT a.UserID,UserCode,UserName,b.sex, CropName=(Select MachName from sys04_Machine c where a.CropID=c.MachID), DepartName=(select MachName from sys04_Machine d where a.DepartID=d.MachID ), RankName=(select RankName from Basic02_Rank where Rankid=rank) FROM employee01_Basic a LEFT OUTER JOIN employee02_info b ON a.UserID = b.UserID Where ( ( a.CropID=1 ) OR ( a.CropID=202 AND a.DepartID=207 ) OR ( a.CropID=1 ) OR ( a.CropID=1 ) OR ( a.CropID=202 ) OR ( a.CropID=253 ) OR ( a.CropID=202 AND a.DepartID=207 ) OR ( a.CropID=202 AND a.DepartID=207 ) OR ( a.CropID=202 AND a.DepartID=209 ) OR ( a.CropID=202 ) OR ( a.CropID=204 ) OR ( a.CropID=204 ) ) AND a.UserState='0'

我們將它在sqlserver中執行，發現沒有問題：

我們再將它傳入到上面的lookupfirst函數當中，mSql爲上面打印的sql語句：

select count(*) as cnum from ("+mSql+") as awqertc1q

結果顯示沒有問題（注意的是如果帶入排序，就會出現問題，這個問題比較深奧，我們以後再說。）

那麽這是什麽問題呢？難道真的是和排序一樣出現的實現小數據量和海量數據的通用分頁顯示存儲過程出現的問題一樣嗎？于是我也仿照對排序的解決方法一樣，在select前加入top 100 percent 但是卻不能顯示！！！！如此難道這又是實現小數據量和海量數據的通用分頁顯示存儲過程出現的問題，而且是不同形式，連top 100 percen都不能用？我們再繼續跟蹤代碼，看看基礎代碼是怎麽實現的，如果要改動基礎代碼，將對整個系統産生巨大的影響。但出現問題我們必須解決，只好硬著頭皮看下去，爲了，跟蹤系統代碼：

public String ShowGrid(){

try{

String Table="";

Conn conn=new Conn();

String num=conn.lookupfirst("select count(*) as cnum from ("+mSql+") as awqertc1q ","cnum");

if (num.trim().length()<1) num="0";

int CountNum=Integer.parseInt(num);

int CurrentNum=1;

if (mRequest.getParameter(getHiddenContolID())!=null){

String m=mRequest.getParameter(getHiddenContolID());

if (m.trim().length()<1) m="0";

CurrentNum=Integer.parseInt(m);

}

//if (mRequest.getParameter(getChangePageContolID())!=null){

// String m=mRequest.getParameter(getChangePageContolID());

// if (m.trim().equals("0")){

// CurrentNum=1;

// }

//}

//Table+="select count(*) as cnum from ("+mSql+") as a ";

int Pagecount= (CountNum+mRowInPage-1)/mRowInPage;

Table+=getGridJavascriptFun(CurrentNum,CountNum,Pagecount);

Table+=getGridTable(CurrentNum,CountNum,Pagecount);

//System.out.println("Table:"+Table);

return Table;

}catch(Exception e){

return e.getMessage();

}

我們將Table 打印出來：

function LastPage1Fun()

{

document.all.datagrid1_pageno.value='31';

document.all.datagrid1_changepage.value='1';

window.document.formlist.submit();

}

function JumpPage1Fun(){

document.all.datagrid1_pageno.value=document.all.datagrid1_ump.value;

document.all.datagrid1_changepage.value='1';

window.document.formlist.submit();

}

function NextPage1Fun()

{

document.all.datagrid1_pageno.value='2';

document.all.datagrid1_changepage.value='1';

window.document.formlist.submit();

}

function prePage1Fun()

{

document.all.datagrid1_pageno.value='1';

document.all.datagrid1_changepage.value='1';

window.document.formlist.submit();

}

function FirstPage1Fun()

{

document.all.datagrid1_pageno.value='1';

document.all.datagrid1_changepage.value='1';

window.document.formlist.submit();

}

function page1chk(id,trueOrFalse){

if(trueOrFalse==null) trueOrFalse=true;

var chks=document.getElementsByName(id);

for (var i=0;i<chks.length;i++)

chks[i].checked=trueOrFalse;

page1chkdata(id);

}

function page1chkdata(id){

document.all.datagrid1_checkvalue.value='';

var chks=document.getElementsByName(id);

for (var i=0;i<chks.length;i++){

if (chks[i].checked){

document.all.datagrid1_checkvalue.value+=chks[i].value+',';

}

var a=document.all.datagrid1_checkvalue.value.length ;

if (a>0){

document.all.datagrid1_checkvalue.value=document.all.datagrid1_checkvalue.value.substr(0,a-1);

}

}</script>

<body>

<form>