表单查询显示翻页等不可用,提示对象不支持此属性或方法，切记查询按钮的name值不能为submit

切记查询按钮的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>