论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2003-07-07 16:25 |只看该作者 |倒序浏览

我写了这样一个servlet
package com.khxt.cx;

import com.fulltop.db.*;
import com.fulltop.common.*;
import com.singlee.ebank.*;
import java.sql.*;
import java.util.*;
import javax.servlet.http.*;
/**
* 创建日期：(2003-06-14 )
* @author：gdj
*/
public class Lcyg implements ControlBean
{
private FtResultSet rs = null;
public FtResultSet getRS() {
return rs;
}

private int returnCode = -5000;
/**
* 得到机构总汇总ResultSet。
* 创建日期：(2001/11/14 20:52:2

* @return Vector
*/
public void execute(FtParams p) throws Exception
{
Hashtable hParam = p.getHashParams();
HttpSession session = p.getHttpSession();
Connection m_conn = p.getConnection();
String operCode = (String)session.getValue(ControlBean.OPERATER);
String operPass = (String)session.getValue(ControlBean.PASSWD);
String strSql = "";

strSql = "{?= call pkh_lc_qxjc ?,?}";
FtDBSybase sybase = new FtDBSybase(m_conn);
try
{
sybase.createProcedure(strSql);
      sybase.getCallableStatement().registerOutParameter(1,Types.INTEGER);
      sybase.getCallableStatement().setString(2,operCode);
      sybase.getCallableStatement().setString(3,operPass);
      sybase.excecuteProcedure();
      rs = sybase.getSimpleRS();
      returnCode = sybase.getReturnCode();
}catch(SQLException e)
{
throw new CreditException(CreditException.ABC_PROCEDURE_ERROR,e.toString());
}

p.getHttpServletRequest().setAttribute(ControlBean.LCYGCHAXUN, this);
  }
}//class

jsp是
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">;
<%@ page
language="Java"
  contentType="text/html; charset=gb2312"
errorPage="/errorPage.jsp"
import ="com.singlee.ebank.*,com.khxt.cx.*,com.fulltop.db.*,java.util.*"
%>;
<%
Lcyg lcyg  = (Lcyg)request.getAttribute(ControlBean.LCYGCHAXUN);
if (lcyg == null)
{
out.println("the bean is null!"

;
return;
}
if (true)
{ FtResultSet rs = lcyg.getRS();
int iTotalCount = rs.getTotalCount();
%>;
<HTML>;
<HEAD>;
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">;
<META http-equiv="Content-Style-Type" content="text/css">;
<META HTTP-EQUIV="

ragma" CONTENT="no-cache">;
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">;
<META HTTP-EQUIV="Expires" CONTENT="0">;
<TITLE>;
员工
</TITLE>;
<link rel="stylesheet" href="\html\global.css">;
</HEAD>;

<BODY background="\image\bk_left.gif" scroll=auto>;
<%if(iTotalCount >; 0){%>;
<a href="/html/file.html">

lease come in!</a>;
<%}else{%>;
You have not privilege to do this
<%}%>;
</body>;
</html>;
<%}%>;
上一级页面调用他的语句是：
{result_iframe.location.href="/servlet/com.singlee.ebank.CreditMain?jspname=/jsp/cx/file.jsp&beannam=com.khxt.cx.Lcyg&command=sjxz";
java.lang.NullPointerException
痛苦啊
但是却报出

文库|博客

返回列表

Chinaunix › 论坛 › 程序设计 › Java › 天哪，又错了

天哪，又错了 [复制链接]

浏览过的版块