<%@page contentType="text/html;charset=GB2312"%>
<%@page language="java" import ="java.sql.*" %><jsp:useBean id="dbBean" scope="page" class="SQLBean.ConnMSSQL">
</jsp:useBean><%String unit_licenceno = (String)request.getParameter("unit_licenceno");
System.out.println("unit_licenceno = " + unit_licenceno); %><%// 判断该企业许可证号在company表中是否存在,若不存在,弹出出错页面,不能进入!
int company_num = 0;
String v_company_name = "";
String sql1 = "select * from company where number='" + unit_licenceno + "'";
System.out.println("sql1 = " + sql1);
ResultSet RS1 = dbBean.executeQuery(sql1);try
{
    while(RS1.next())
    {
        company_num++;
        v_company_name = RS1.getString("unit");
    }
    RS1.close();
}
catch(Exception e)
{
    System.err.println(e);
}// company表中不存在该单位许可证号
if(company_num == 0)
{
    String err_info = "您输入的企业许可证号不存在,请重新输入!多次核对但验证失败,请跟管理员联系!";
    session.setAttribute("err_info", err_info);
    // 设置发生错误时,点击“返回”按钮跳转向的页面
    String ret_url = "audit_login21.jsp";
    response.sendRedirect("g_err_info.jsp?ret_url=" + ret_url);
}System.out.println("v_company_name=" + v_company_name);
System.out.println("company_name=" + session.getAttribute("company_name"));if(!v_company_name.equals(session.getAttribute("company_name")))
{
    String err_info = "您输入的企业许可证号不是贵单位的企业号,请重新输入!多次核对但验证失败,请跟管理员联系!";
    session.setAttribute("err_info", err_info);
    // 设置发生错误时,点击“返回”按钮跳转向的页面
    String ret_url = "audit_login21.jsp";
    response.sendRedirect("g_err_info.jsp?ret_url=" + ret_url);
}%><%
// 校验单位许可证号在t_ExamBase表中是否存在:
//  如果不存在, 将company表中对应的信息拷贝到t_ExamBase表中
//  如果存在则跳到主页面
int company_num2 = 0;
String sql2 = "select count(*) as c from t_ExamBase where Number='" + unit_licenceno + "'";
System.out.println("sql2 = " + sql2);
ResultSet RS2 = dbBean.executeQuery(sql2);try
{
    while(RS2.next())
    {
        company_num2 = RS2.getInt("c");
    }
    RS2.close();
}
catch(Exception e)
{
    System.err.println(e);
}%><%
/*
if(company_num2 == 0) // 在t_ExamBase表中不存在
{
    // 跳向主页面
    response.sendRedirect("wmain2.jsp?new=1");
}
else
{
    // 跳向主页面
    response.sendRedirect("wmain2.jsp");
}response.sendRedirect("wmain2.jsp");
*/
%><html><head>
<title>欢迎访问浙江省物价局--用户登陆</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
</head><body></body></html>

解决方案 »

  1.   

    HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception java.lang.IllegalStateException
    org.apache.coyote.tomcat5.CoyoteResponseFacade.sendRedirect(CoyoteResponseFacade.java:379)
    org.apache.jsp.audit_005flogin22_jsp._jspService(audit_005flogin22_jsp.java:113)
    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.16
      

  2.   

    2004-02-01 19:59:58 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
    java.lang.IllegalStateException
    at org.apache.coyote.tomcat5.CoyoteResponseFacade.sendRedirect(CoyoteResponseFacade.java:379)
    at org.apache.jsp.audit_005flogin22_jsp._jspService(audit_005flogin22_jsp.java:113)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
    at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
    at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
    at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:211)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:805)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:696)
    at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677)
    at java.lang.Thread.run(Thread.java:534)