日期:2014-05-18  浏览次数:20701 次

jsp调用存储过程时出现的问题
存储过程:
<!--注册的存储过程,返回当前注册者ID-->
create   proc   register_uid  
@uid   int   output,
@username   varchar(20),
@password   varchar(20),
@sex   char(2),
@name   varchar(20),
@tel   varchar(20),
@description   varchar(20)
as
insert   into   userinfo   values(@username,@password,@sex,@name,@tel,@description,default)
select   @uid=@@identity
go

调用:
  CallableStatement   cstmt=con.prepareCall( "{call   register_uid(?,?,?,?,?,?,?,default)} ");
  //注册输出
  cstmt.registerOutParamet   (1,java.sql.Types.INTEGER);
  System.out.println( "username   is: "+form.getUsername());
65行: ps.setString(2,form.getUsername());
ps.setString(3,form.getPassword());
ps.setString(4,form.getSex());
ps.setString(5,form.getName());
ps.setString(6,form.getTel());
ps.setString(7,form.getDec());
  cstmt.executeUpdate();      
  uid=cstmt.getInt(1);
异常:
java.lang.NullPointerException
at   com.accp.note.user.dao.UserImp.CheckReg(UserImp.java:65)
at   com.accp.note.struts.action.RegisterAction.Register(RegisterAction.java:55)
at   sun.reflect.NativeMethodAccessorImpl.invoke0(Native   Method)
at   sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at   sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at   java.lang.reflect.Method.invoke(Method.java:585)
at   org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
at   org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
at   org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at   org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at   org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at   org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at   javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at   com.accp.note.util.MyFilter.doFilter(MyFilter.java:24)
at   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at   org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at   org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at   org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at   org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at   org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at   org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at   org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at   org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at