急。在线等呀
我定义了存储过程如下.
CREATE PROCEDURE longdandan
@choose varchar(20),@outch varchar(20) output
AS
select * from tour_resource_distribution_map where trdm_name=@choose
set @outch=@choose
return
GO
在JSP中是这样调用的。
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:longdandan");
String sSql="{call longdandan(?)}";
CallableStatement stmt=con.prepareCall(sSql);
String ss="longdandan";
stmt.setString(1,ss);
stmt.registerOutParameter(2,java.sql.Types.VARCHAR);
ResultSet Rs;
Rs=stmt.executeQuery();
String ss1=stmt.getString(2);
%>
<TD><B><%=ss%></TD></B>
<TD><B><%=ss1%></td></b>
...........
为什么会出错。提示是:
java.lang.ArrayIndexOutOfBoundsException