<%@ 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>
<%}%>
调用这个文件后,显示的是空白,也没有报错。
请问哪里有问题呢,谢谢。
<%@ 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>
<%}%>
调用这个文件后,显示的是空白,也没有报错。
请问哪里有问题呢,谢谢。
去了SCOPE试试.
去了SCOPE试试.”
肯定不是这个问题,scope="session"是要储存用户名密码等。
<jsp:include page="foot.jsp" flush="true" />
<%}%>
</body>
</html>不是用工具写的,是用NOTEPAD写的,谢谢指正.
哪位能帮忙看看,谢谢。
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)
java.lang.NullPointerException
at simis.User.IsGongWuYuan(User.java:112)
===================================================
找不到'localhost'
就是tomcat配置出错了
你看下这个
%tomcat_home&/conf/server.xml配置有问题吗?
是因为字段ckc015在数据库里面的值为""
在user.java里面的语句不是ckc015为1就是为0.