读书人

jsp调用存储过程时出现的有关问题

发布时间: 2012-01-11 22:28:46 作者: rapoo

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 org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)


at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
请问这个是什么问题?

[解决办法]
空指针异常,可能是你传值的时候有问题,有的值是空值
[解决办法]
又见空指针,println那些form.get***()吧。

读书人网 >Java Web开发

热点推荐