JSP向MSSQL中写入数据时报错Invalid parameter binding(s).

[newchenj]

JSP向MSSQL中写入数据时报错
系统错误：[Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).
环境：tomcat4.1+jdk
由此页面传参数给存储过程然后写入数据库中，数据可以写入，但出现以上错误信息。

请各位大侠指点一下，小弟感激不尽啊。


<%@include file="/check.jsp"%>
<%@page contentType="text/html;charset=gb2312"%>
<%@page language="java" import="java.*,java.sql.*,java.io.*,org.*"%>
%>
<jsp:useBean id="connsqldbnew" scope="page" class="bqs.DataPool" />
<%
System.out.println(session.getId()+" ruku_gaojia_finish.jsp");
String userid,pallet,operator,addre,ordno,banci,batch,matno,quant,factory,palletno,munit,stano,stage,id,Sectn="",port="",demo1="",demo2="",taihao="",works="",Store,demo4="",quant2="",quant3="",demo5,demo6,demo7;
String in1="",in2="",in3="",in4="",in5="",in6="",in7="",in8="",in9="",in10="",in11="",in12="",in13="",in14="",in15="",in16="",in17="",in18,in19,in20="",data="",data1="",lotno="",line="",addre_in="",demo3="",cflag="",lingbao="";
try
{
userid = (String)session.getAttribute("_Sname");
operator = (String)session.getAttribute("_Sname");
palletno =(String)session.getAttribute("_ruku_gaojia_pallet");
banci= (String)session.getAttribute("banci");
batch =request.getParameter("batch");
ordno =request.getParameter("ordno");
munit = request.getParameter("munit");
quant =request.getParameter("quant");
data =request.getParameter("data");
data1 =request.getParameter("data1");
lotno =request.getParameter("lotno");
line =request.getParameter("line");
demo4 =request.getParameter("demo4");
id=request.getParameter("id");
demo1=request.getParameter("demo1");
demo2=request.getParameter("demo2");
demo3=request.getParameter("demo3");
taihao=request.getParameter("taihao");
cflag=request.getParameter("cflag");
works=request.getParameter("works");
Store=request.getParameter("Store");
matno=request.getParameter("matno");
quant2=request.getParameter("quant2");
quant3=request.getParameter("quant3");
demo5=request.getParameter("demo5");
demo6=request.getParameter("demo6");
demo7=request.getParameter("demo7");
lingbao=request.getParameter("lingbao");

//stano=new String(stano.getBytes("ISO8859_1"));
//Sectn=new String(Sectn.getBytes("ISO8859_1"));
//stage=new String(stage.getBytes("ISO8859_1"));
//port=new String(port.getBytes("ISO8859_1"));
//System.out.println(addre_in);
//System.out.println(port);
//System.out.println(Sectn);
cflag=new String(cflag.getBytes("ISO8859_1"));
works=new String(works.getBytes("ISO8859_1"));
Store=new String(Store.getBytes("ISO8859_1"));

in1=userid;
in2=id;
in3=palletno;
in4=quant;
in5=cflag;
in6=taihao;
in7=demo1;
in8=demo2;
in9=demo3;
in10=ordno;
in11=works;
in12=Store;
in13=demo4;
in14=banci;
in15=lotno;
in16=batch;
in17=demo5;
in18=demo6;
in19=demo7;
in20=lingbao;
System.out.println(in1);
System.out.println(in2);
System.out.println(in3);
System.out.println(in4);
System.out.println(in5);
System.out.println("流水号"+in6);
System.out.println(in7);
System.out.println(in8);
System.out.println("编号"+in9);
System.out.println(in10);
System.out.println(in11);
System.out.println(in12);
System.out.println(in13);
System.out.println(in14);
System.out.println(in15);
System.out.println(in16);
System.out.println("入库数量"+quant);
System.out.println("使用次数"+in17);
System.out.println("机号"+in18);
System.out.println("代号"+in19);
System.out.println("是否单件"+in20);
String strsql;
int intReturn=-1;

strsql = "{? = call sp_rf_over(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}";

connsqldbnew.getStmt(strsql);

connsqldbnew.procstmt.registerOutParameter(1,java.sql.Types.INTEGER);
connsqldbnew.procstmt.setString(2,in1);
connsqldbnew.procstmt.setString(3,in2);
connsqldbnew.procstmt.setString(4,in3);
connsqldbnew.procstmt.setString(5,in4);
connsqldbnew.procstmt.setString(6,in5);
connsqldbnew.procstmt.setString(7,in6);
connsqldbnew.procstmt.setString(8,in7);
connsqldbnew.procstmt.setString(9,in8);
connsqldbnew.procstmt.setString(10,in9);
connsqldbnew.procstmt.setString(11,in10);
connsqldbnew.procstmt.setString(12,in11);
connsqldbnew.procstmt.setString(13,in12);
connsqldbnew.procstmt.setString(14,in13);
connsqldbnew.procstmt.setString(15,in14);
connsqldbnew.procstmt.setString(16,in15);
connsqldbnew.procstmt.setString(17,in16);
connsqldbnew.procstmt.setString(18,in17);
connsqldbnew.procstmt.setString(19,in18);
connsqldbnew.procstmt.setString(20,in19);
connsqldbnew.procstmt.setString(21,in20);




connsqldbnew.procstmt.registerOutParameter(22,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(23,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(24,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(25,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(26,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(27,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(28,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(29,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(30,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(31,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(32,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(33,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(34,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(35,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(36,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(37,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(38,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(39,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(40,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(41,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.registerOutParameter(42,java.sql.Types.VARCHAR);
connsqldbnew.procstmt.executeQuery();


intReturn = connsqldbnew.procstmt.getInt(1);
quant3=connsqldbnew.procstmt.getString(21);
String reason = connsqldbnew.procstmt.getString(42);
try
{
connsqldbnew.closePool();
if(intReturn == 0 )
{
System.out.println(quant3);
session.setAttribute("_ruku_gaojia_ordno",ordno);
session.setAttribute("_ruku_gaojia_pallet",palletno);
session.setAttribute("_ruku_gaojia_matno",matno);
session.setAttribute("_ruku_gaojia_quant0","");
session.setAttribute("_ruku_gaojia_quant2",quant2);
session.setAttribute("_ruku_gaojia_quant3",quant3);
session.setAttribute("_ruku_gaojia_batch",batch);
session.setAttribute("_ruku_gaojia_data","");
session.setAttribute("_ruku_gaojia_data1","");
session.setAttribute("_ruku_gaojia_stano","");
session.setAttribute("_ruku_gaojia_stage","");
session.setAttribute("_ruku_gaojia_line","");
session.setAttribute("_ruku_gaojia_lotno",lotno);
session.setAttribute("_ruku_gaojia_id",id);
//session.setAttribute("_ruku_gaojia_ordno","");
session.setAttribute("lingbao","");
response.sendRedirect(response.encodeURL("/ruku/gaojia/ruku_gaojia_pallet.jsp"));
}
else
{
session.setAttribute("_reason",String.valueOf(reason));
response.sendRedirect(response.encodeURL("/error.jsp"));
}
}
catch(Exception Exception_jsp)
{
try
{
session.setAttribute( "_reason", String.valueOf(Exception_jsp.getMessage())+"adsfsadf" );
response.sendRedirect(response.encodeURL("/shibengmj/syserror.jsp"));
}
catch(Exception Exception_jsp_e)
{
response.sendRedirect(response.encodeURL("/shibengmj/sysfailed404.html"));
}
}
}
catch(Exception Exception_jsp)
{
try
{ connsqldbnew.closePool();
session.setAttribute( "_reason", String.valueOf(Exception_jsp.getMessage()) );
response.sendRedirect(response.encodeURL("/syserror.jsp"));
}
catch(Exception Exception_jsp_e)
{
response.sendRedirect(response.encodeURL("/sysfailed404.html"));
}
}
%>

[希望对你有帮助]

给你几个方法吧，别人也遇到过。

http://zhidao.baidu.com/question/32163253.html

http://tieba.baidu.com/f?kz=558827810

http://www.17ext.com/answer/31504.aspx



希望对你有帮助

[newchenj]

自己顶一下。

[newchenj]

补充说明一下，在tomcat中无报错，是在浏览器中出现报错，系统错误：[Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s).