<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page language="java" %>
<%@ page import="java.util.Date" %>
<%@ page import="common.*" %>
<%@ page import="java.text.*" %><jsp:useBean id="user" class="simis.User" scope="session" />
<%if (!user.isLogin()) {%>
    <jsp:include page="loginFail.jsp" flush="true" />
<%} else {%>
<%!
String strSQL =null;//查询语句
String strIDCard=null; //身份证号String strAac001=null;
String strAac003=null;
String strAac002=null;
String strAac004=null;
String strAac008=null;ResultSet rs = null;
DBSQL db = new DBSQL();
CodeTable codeTable = null;
%><%
  String strAac001 = user.getAac001();
strSQL="SELECT aac001,aab001,aac002,aac003,aac004,aac006,aac007,aac008,ckc015,aae036 FROM ac01_table WHERE aac001='"+strAac001+"'";
  System.out.print(strSQL);
%>
<%
       try{
       db.openQueryDB();
               rs = db.executeQuery(strSQL);
               codeTable = db.getCodeTable("soft");
   }
   catch(Exception ex)
   {
       System.out.println(ex.toString());}%>
<html>
<jsp:include page="head.jsp" flush="true" />
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
<jsp:include page="title.jsp" flush="true" />
<div align="center" ><td width="736" bgcolor="#DFDFDF" height="22"><p align="center"><font face="楷体_GB2312" size="4" color="#000000"><strong>个人基本信息查询</strong></font></p></td>
<%
if(rs.next())
{
%>
      <table width="100%" border="1" class="font10" cellspacing="1" cellpadding="1" bgcolor="#FFFFFF" bordercolor="#999999">
         <TR>
              <TD bgcolor="#DFDFDF" width= 100>
           <B>个人编号</B>
              </TD>
              <TD width= 100><%= rs.getString("AAC001") %>
              </TD>
              <TD bgcolor="#DFDFDF" width= 100>
           <B>身份证号</B>
              </TD>
              <TD width= 100><%= rs.getString("AAC002") %>
              </TD>
              <TD bgcolor="#DFDFDF" width= 100>
           <B>姓 名</B>
              </TD>
              <TD width= 100><%
               if(rs.getString("AAC003")==null)
                   out.print("无");
               else
                   out.print(rs.getString("AAC003"));     %>
              </TD>
        </TR>
        <TR>
              <TD bgcolor="#DFDFDF" width= 100>
           <B>性 别</B>
              </TD>
              <TD width= 100><%
              if(rs.getString("AAC004")==null)
                   out.print("无");
              else
                   out.print(codeTable.getCodeName("AAC004",rs.getString("AAC004")));
                          %>
              </TD>
              <TD bgcolor="#DFDFDF" width= 100>
           <B>单位编号</B>
              </TD>
              <TD width= 100><%
               if(rs.getString("AAB001")==null)
                   out.print("无");
               else
                   out.print(rs.getString("AAB001"));  %>
              </TD>
              <TD bgcolor="#DFDFDF" width= 100>
           <B>出生日期</B></TD>
              <TD width= 100>
               <%
               if(DateTool.dateToString(rs.getDate("AAC006"),"YYYYMMDD")==null)
                   out.print("无");
               else
                   out.print(ToStrDateFormat.toStrDateFormat(DateTool.dateToString(rs.getDate("AAC006"),"YYYYMMDD")));
               %>
              </TD>
       </TR>
       <TR>
              <TD bgcolor="#DFDFDF" width= 100>
           <B>参加工作日期</B>
              </TD>
              <TD width= 100>
              <%
                if(DateTool.dateToString(rs.getDate("AAC007"),"YYYYMMDD")==null)
                     out.print("无");
                else
                     out.print(ToStrDateFormat.toStrDateFormat(DateTool.dateToString(rs.getDate("AAC007"),"YYYYMMDD")));
              %>
              </TD>
              <TD bgcolor="#DFDFDF" width= 100>
           <B>人员状态</B>
              </TD>
              <TD width= 100><%
               if(rs.getString("AAC008")==null)
                   out.print("无");
               else
                   out.print(codeTable.getCodeName("AAC008",rs.getString("AAC008")));
                   %>
              </TD>
              <TD bgcolor="#DFDFDF" width= 100>
          <B>公务员标志</B></TD>
              <TD width= 100><%= user.IsGongWuYuan(rs.getString("CKC015"))%>
              </TD>
       </TR>
       <TR>
              <TD bgcolor="#DFDFDF" width= 100>
          <B>经办日期</B>
              </TD>
              <TD width= 100>
               <%
                if(DateTool.dateToString(rs.getDate("AAE036"),"YYYYMMDD")==null)
                      out.print("无");
                else
                      out.print(ToStrDateFormat.toStrDateFormat(DateTool.dateToString(rs.getDate("AAE036"),"YYYYMMDD")));
               %>
              </TD>
       </TR>
   </table>
<%} else {%>
   <table width="100%" border="1" class="font10" cellspacing="1" cellpadding="1" bgcolor="#FFFFFF" bordercolor="#999999">
     <tr>
       <td width="300"  height="26" align="left"><font face="楷体_GB2312" size="3"><B><%=user.getAac003()+":"%></B></font><font face="楷体_GB2312"  color="red" size="3" color="#000000"><B>没有您查询的记录!</B></font></td>
     </tr>
   </table>
<%}
          rs.close();
          db.closeDB();
%></div>
<jsp:include page="foot.jsp" flush="true" />
</body>
</html>
<%}%>
调用这个文件后,显示的是空白,也没有报错。
请问哪里有问题呢,谢谢。

解决方案 »

  1.   

    <jsp:useBean id="user" class="simis.User" />
    去了SCOPE试试.
      

  2.   

    “<jsp:useBean id="user" class="simis.User" />
    去了SCOPE试试.”
    肯定不是这个问题,scope="session"是要储存用户名密码等。
      

  3.   

    好像最后一个引号不对,位置应该在上面,而不是在body之下.
      

  4.   

    如果你用jbuilder之类的工具开发,应该会报错的,因为你最后一个引号好像是多余的,上面找不到与之匹配的引号,而且引在</body>之下,更是错误.
      

  5.   

    应该是这样的嘛
    <jsp:include page="foot.jsp" flush="true" />
    <%}%>
    </body>
    </html>不是用工具写的,是用NOTEPAD写的,谢谢指正.
      

  6.   

    有些错误不会在浏览器中显示时会在logs日志中记录的.看看操作时间附近的日志就OK了.
      

  7.   

    看了LOGS日志,可是没看明白。
    哪位能帮忙看看,谢谢。
    2007-05-19 19:36:56 StandardContext[/manager]HTMLManager: list: Listing contexts for virtual host 'localhost'
    2007-05-19 20:00:45 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
    java.lang.NullPointerException
    at simis.User.IsGongWuYuan(User.java:112)
    at org.apache.jsp.PHiNetQuery.personbaseinfo_jsp._jspService(personbaseinfo_jsp.java:224)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
    at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
    at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
    at java.lang.Thread.run(Unknown Source)
      

  8.   

    检查你的类simis.User的IsGongWuYuan(...)方法,在这个方法的处理中出现了变量为空但是你还是对它进行引用操作,所以有异常.
    java.lang.NullPointerException
    at simis.User.IsGongWuYuan(User.java:112)
    ===================================================
      

  9.   

    这下麻烦了,用EDITPLUS2打开类文件,出来的都是乱码,这玩意不是我写的,中途接手。
      

  10.   

    什么都没有就肯定是配置有问题
    找不到'localhost'
    就是tomcat配置出错了
    你看下这个
    %tomcat_home&/conf/server.xml配置有问题吗?
      

  11.   

    可是,在相同配制下,打开其他JSP文件是正常的,就是打开这个文件就是什么都没有显示.
      

  12.   

    问题已经解决.
    是因为字段ckc015在数据库里面的值为""
    在user.java里面的语句不是ckc015为1就是为0.