HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.lang.NullPointerException
org.apache.jsp.TMP1icqpeyzi0_jsp._jspService(TMP1icqpeyzi0_jsp.java:75)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
--------------------------------------------------------------------------------Apache Tomcat/5.0.19
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.lang.NullPointerException
org.apache.jsp.TMP1icqpeyzi0_jsp._jspService(TMP1icqpeyzi0_jsp.java:75)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
--------------------------------------------------------------------------------Apache Tomcat/5.0.19
<body>
<p>
<%
String GuanLiNo = request.getParameter("GuanLiNo");
String Projectname = request.getParameter("Projectname");
String PartNo = request.getParameter("PartNo");
session.getAttribute("GuanLiNo");
session.getAttribute("Projectname");
session.getAttribute("PartNo");
String sql ;
sql="select TOP 5* from PartPress where 1=1";
if (GuanLiNo!= null & GuanLiNo.equals(""))
sql = sql + "and GuanLiNo = '" + GuanLiNo+"'";
if (Projectname != null & Projectname.equals(""))
sql += sql + "and Projectname = '" + Projectname +"'"; if (PartNo != null & PartNo.equals(""))
sql += sql + "and PartNo = '" + PartNo +"'";
ResultSet rs = jb.query(sql);
%>
</p>
<p> </p>
<p> </p>
<p> </p>
<p align="center"><font color="#000000" size="+2" face="華康相撲體">零件加工進度查詢</font></p>
<div align="right"></div>
<form name="form1">
<div align="left">
<table width="104%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="4%" nowrap><div align="center"><font color="#0000FF">工程名</font></div></td>
<td width="4%" nowrap> <div align="center"> <font color="#0000FF">
<select name="Projectname">
<option></option>
<option>MM</option>
<option>MC</option>
<option>MC3</option>
<option>EDM</option>
<option>WE</option>
<option>WH</option>
<option>MM2</option>
<option>MF</option>
<option>HT</option>
</select>
</font></div></td>
<td width="5%" nowrap><div align="center"><font color="#0000FF">管理番號</font></div></td>
<td width="13%" nowrap> <div align="center"> <font color="#0000FF">
<input name="GuanLiNo" type="text">
</font></div></td>
<td width="4%" nowrap><div align="center"><font color="#0000FF">零件號</font></div></td>
<td width="13%" nowrap> <div align="center"> <font color="#0000FF">
<input type="text" name="PartNo">
</font></div></td>
<td width="0%" nowrap> <div align="center"> <font color="#0000FF">
<input type="Submit" name="Submit" onClick="check();" value="確定" >
</font></div></td>
<td width="48%" nowrap> <div align="left"></div>
<div align="center"></div>
<div align="center"></div>
<div align="center">
<table width="0%" border="2" cellpadding="0" cellspacing="1" bordercolor="#7188e0">
<tr>
<td nowrap><font color="#0000FF" size="2">您查找的信息是</font></td>
<td nowrap bgcolor="#CCCCFF"><font color="#FF00FF" size="3"><%= Projectname %></font></td>
<td nowrap bgcolor="#CCCCFF"><font color="#FF00FF" size="3"><%= GuanLiNo %></font></td>
<td nowrap bgcolor="#CCCCFF"><font color="#FF00FF" size="3"><%= PartNo %></font></td>
</tr>
</table>
</div></td>
<td width="9%" nowrap><a href="top-4.jsp"><font size="2">返回</font></a></td>
</tr>
</table>
</div>
</form>代碼已經貼出來了 請大家幫忙看看多謝
<body>
<p>
<%
String GuanLiNo = request.getParameter("GuanLiNo");
String Projectname = request.getParameter("Projectname");
String PartNo = request.getParameter("PartNo");
session.getAttribute("GuanLiNo");
session.getAttribute("Projectname");
session.getAttribute("PartNo");
String sql ;
sql="select TOP 5* from PartPress where 1=1";
if (GuanLiNo!= null & GuanLiNo.equals(""))
sql = sql + "and GuanLiNo = '" + GuanLiNo+"'";
if (Projectname != null & Projectname.equals(""))
sql += sql + "and Projectname = '" + Projectname +"'"; if (PartNo != null & PartNo.equals(""))
sql += sql + "and PartNo = '" + PartNo +"'";
ResultSet rs = jb.query(sql);
%>
</p>
<p> </p>
<p> </p>
<p> </p>
<p align="center"><font color="#000000" size="+2" face="華康相撲體">零件加工進度查詢</font></p>
<div align="right"></div>
<form name="form1">
<div align="left">
<table width="104%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="4%" nowrap><div align="center"><font color="#0000FF">工程名</font></div></td>
<td width="4%" nowrap> <div align="center"> <font color="#0000FF">
<select name="Projectname">
<option></option>
<option>MM</option>
<option>MC</option>
<option>MC3</option>
<option>EDM</option>
<option>WE</option>
<option>WH</option>
<option>MM2</option>
<option>MF</option>
<option>HT</option>
</select>
</font></div></td>
<td width="5%" nowrap><div align="center"><font color="#0000FF">管理番號</font></div></td>
<td width="13%" nowrap> <div align="center"> <font color="#0000FF">
<input name="GuanLiNo" type="text">
</font></div></td>
<td width="4%" nowrap><div align="center"><font color="#0000FF">零件號</font></div></td>
<td width="13%" nowrap> <div align="center"> <font color="#0000FF">
<input type="text" name="PartNo">
</font></div></td>
<td width="0%" nowrap> <div align="center"> <font color="#0000FF">
<input type="Submit" name="Submit" onClick="check();" value="確定" >
</font></div></td>
<td width="48%" nowrap> <div align="left"></div>
<div align="center"></div>
<div align="center"></div>
<div align="center">
<table width="0%" border="2" cellpadding="0" cellspacing="1" bordercolor="#7188e0">
<tr>
<td nowrap><font color="#0000FF" size="2">您查找的信息是</font></td>
<td nowrap bgcolor="#CCCCFF"><font color="#FF00FF" size="3"><%= Projectname %></font></td>
<td nowrap bgcolor="#CCCCFF"><font color="#FF00FF" size="3"><%= GuanLiNo %></font></td>
<td nowrap bgcolor="#CCCCFF"><font color="#FF00FF" size="3"><%= PartNo %></font></td>
</tr>
</table>
</div></td>
<td width="9%" nowrap><a href="top-4.jsp"><font size="2">返回</font></a></td>
</tr>
</table>
</div>
</form>代碼已經貼出來了 請大家幫忙看看 指點多謝
String GuanLiNo = request.getParameter("GuanLiNo");
String Projectname = request.getParameter("Projectname");
String PartNo = request.getParameter("PartNo");你做一个
if(GuanLiNo == null)
{
GuanLiNo ="";
}
那两个你自己做