jsp调用sql server 存储过程的问题（有源码)(50分）
存储过程：
CREATE PROCEDURE getCount
@id varchar(20),@year int,@month int,@state int,@count int output
AS
begin
select @count=COUNT(*) from kaoqin where [ID]='@id' and TheYear=@year and TheMonth=@month and State=@state
end
jsp:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:intranet");
CallableStatement stmt=conn.prepareCall("{call getCount(?,?,?,?,?)}");
Integer[] countArrey=new Integer[6];
ResultSet rs=null;
for(int c=0;c<6;c++)
{
stmt.setString(1,"wqs");
stmt.setInt(2,2001);
stmt.setInt(3,1);
stmt.setInt(4,c);
stmt.registerOutParameter(5,java.sql.Types.INTEGER);
try
{
rs=stmt.executeQuery();
}
catch(Exception e)
{
}
while(rs.next())
{
countArrey[c]=new Integer(rs.getInt(1));
}
}
rs.close();
出现错误：
java.lang.NullPointerException
at _jsp._office._attendance._temp__jsp._jspService(/office/attendance/temp.jsp:43)
at com.caucho.jsp.JavaPage.service(JavaPage.java:87)
at com.caucho.jsp.JavaPage.subservice(JavaPage.java:81)
at com.caucho.jsp.Page.service(Page.java:407)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:136)
at com.caucho.server.http.Invocation.service(Invocation.java:268)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:128)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:238)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:157)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)
应该是下面几行出错:
countArrey[c]=new Integer(rs.getInt(1));
怎么解决呀。。？？谢谢大家！！！！
问题点数：20、回复次数：2Top
1 楼whywhywhy（问个不休）回复于 2002-01-21 23:19:55 得分 20
不是说50分吗？怎么只有20分啊，这都骗我，叫我怎么教你？
Top
2 楼wqs0006（顺子）回复于 2002-01-22 08:51:53 得分 0
只要解决了问题，给100分都可以。。。我可以加分的呀。。。Top
