<%@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>
<%@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>
解决方案 »
- 求高手帮忙看看下面这个代码!!!!
- Lucene
- doubleselect怎么查不到东西
- 拿位大大能帮帮我
- 求够jsp分页.要源代码...
- java 1.6 import javax.servlet.*;错误
- jsp页面的传值问题
- Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: Array index
- 如何判断一个CachedRowSet对象里是否有纪录
- 一张JSP去刷新另外一张JSP的问题!
- 在哪里可以下载Tomcat和WebLogic?? thanks!
- 在resin环境下怎样运行servlet???急!!!
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
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)