一个奇怪的问题

把完整的JSP贴出来,下面可能有无法识别解析的TAG.
呵呵，没必要处理它,HTML不是语法严格的
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%@ page import="java.lang.*"%>
<%!String n2="";%>
<%!String n3="";%>
<%!String s5="";%>
<%!String s6="";%><%!String sql="";%>
<%!String sql2="";%>
<%!String sqlnum="";%>
<%!String str="";%><html>
<head>
<body>
<div align="center"><font size=5>各问题情况查询</font>
<FORM  METHOD=POST ACTION="question.jsp">
   起始时间
  <input type="text" name="time1">
结束时间
<input type="text" name="time2">
  <p><font size=3>请选择调查问题</font>
    <select name=ques_name style="font-size:12px">
        <option>
        <jsp:useBean id="db5" scope="page" class="test.db"/>
      <%
         sqlnum="select code_name from invest_code where code_id='1' or code_id='2' or code_id='3' or code_id='4' or code_id='5' or code_id='6' or code_id='7' or code_id='8' ";
         ResultSet rs5=db5.executeQuery(sqlnum);
         while(rs5.next()){
         out.println("<option>"+db5.getStr(rs5.getString(1)));}
      %>    </select>
  </p>
<input type=submit  VALUE="查询" style="font-size: 10pt;height:20;width:60" >
</form><jsp:useBean id="db7" scope="page" class="test.db" />
<%
  String n1=request.getParameter("ques_name");
  String t1=request.getParameter("time1");
  String t2=request.getParameter("time2");//  sql="SELECT b.code_name AS Expr2, COUNT(*) AS Expr1 FROM invest_accept_ques ab INNER JOIN invest_code a ON (a.code_id='1' or a.code_id='2' or a.code_id='3' or a.code_id='4' or a.code_id='5' or a.code_id='6' or a.code_id='7' or a.code_id='8') AND a.code_name = '"+n1+"' AND a.code_id = ab.question_id INNER JOIN invest_code b ON (b.code_id='A' or b.code_id='B' or b.code_id='C' or b.code_id='D') AND b.code_id = ab.answer_id INNER JOIN invest_accept_info c ON c.invest_id = ab.invest_id GROUP BY b.code_name";
//  str=" where ";
//  boolean flag = false;
  n1=db7.getStr(n1);
  t1=db7.getStr(t1);
  t2=db7.getStr(t2);
//  out.println(t1);
//  out.println(t2);  if ((t1.length()!=0)&& (t2.length()==0))
  {sql="SELECT b.code_name AS Expr2, COUNT(*) AS Expr1 FROM invest_accept_ques ab INNER JOIN invest_code a ON (a.code_id='1' or a.code_id='2' or a.code_id='3' or a.code_id='4' or a.code_id='5' or a.code_id='6' or a.code_id='7' or a.code_id='8') AND a.code_name = '"+n1+"' AND a.code_id = ab.question_id INNER JOIN invest_code b ON (b.code_id='A' or b.code_id='B' or b.code_id='C' or b.code_id='D') AND b.code_id = ab.answer_id INNER JOIN invest_accept_info c ON c.invest_id = ab.invest_id AND c.invest_time > '"+t1+"' GROUP BY b.code_name";}
  else if ((t2.length()!=0)&& (t1.length()==0))
  {sql="SELECT b.code_name AS Expr2, COUNT(*) AS Expr1 FROM invest_accept_ques ab INNER JOIN invest_code a ON (a.code_id='1' or a.code_id='2' or a.code_id='3' or a.code_id='4' or a.code_id='5' or a.code_id='6' or a.code_id='7' or a.code_id='8') AND a.code_name = '"+n1+"' AND a.code_id = ab.question_id INNER JOIN invest_code b ON (b.code_id='A' or b.code_id='B' or b.code_id='C' or b.code_id='D') AND b.code_id = ab.answer_id INNER JOIN invest_accept_info c ON c.invest_id = ab.invest_id AND c.invest_time <= '"+t2+"'GROUP BY b.code_name";}
  else if ((t1.length()!=0)&& (t2.length()!=0))
  {sql="SELECT b.code_name AS Expr2, COUNT(*) AS Expr1 FROM invest_accept_ques ab INNER JOIN invest_code a ON (a.code_id='1' or a.code_id='2' or a.code_id='3' or a.code_id='4' or a.code_id='5' or a.code_id='6' or a.code_id='7' or a.code_id='8') AND a.code_name = '"+n1+"' AND a.code_id = ab.question_id INNER JOIN invest_code b ON (b.code_id='A' or b.code_id='B' or b.code_id='C' or b.code_id='D') AND b.code_id = ab.answer_id INNER JOIN invest_accept_info c ON c.invest_id = ab.invest_id AND c.invest_time >= '"+t1+"'AND c.invest_time <= '"+t2+"'GROUP BY b.code_name";}
//String p=n1;
//out.println(p);
//sql="klasfl;asfl;";
  if  ((t1.length()==0) && (t2.length()==0))
  {sql="SELECT b.code_name AS Expr2, COUNT(*) AS Expr1 FROM invest_accept_ques ab INNER JOIN invest_code a ON (a.code_id='1' or a.code_id='2' or a.code_id='3' or a.code_id='4' or a.code_id='5' or a.code_id='6' or a.code_id='7' or a.code_id='8') AND a.code_name = '"+n1+"' AND a.code_id = ab.question_id INNER JOIN invest_code b ON (b.code_id='A' or b.code_id='B' or b.code_id='C' or b.code_id='D') AND b.code_id = ab.answer_id INNER JOIN invest_accept_info c ON c.invest_id = ab.invest_id GROUP BY b.code_name";} //out.println(n1);
out.println(sql); sql= new String(sql.getBytes("GBK"),"ISO-8859-1");
ResultSet rs=db7.executeQuery(sql);  if (rs!=null){
out.println() ;
out.println("<div align=\"center\">") ;
out.println("<center>") ;
out.println("<p>所选问题:"+n1+"</p>");
if ((t1.length()!=0)&& (t2.length()==0))
{out.println("在"+t1+"之后的回访");}
else if ((t2.length()!=0)&& (t1.length()==0))
{out.println("在"+t2+"之后的回访");}
else if ((t1.length()!=0)&& (t2.length()!=0))
{out.println("在"+t1+"和"+t2+"之间的回访");}out.println("<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\">") ;
out.println("<tr><td width=\"100\" bgcolor=\"#D9E6F4\" align=\"center\"><font color=\"#000000\">答案</font></td>") ;
out.println("<td width=\"75\" bgcolor=\"#D9E6F4\" align=\"center\"><font color=\"#000000\">各答案数量</font></td>") ; while (rs.next()){
  out.println("<tr><td align=\"center\" bgcolor=#f4f4f4>"+db7.getStr(rs.getString(1))+"</td><td align=\"center\" bgcolor=#f4f4f4>"+rs.getObject(2)+"</td>");
   }
out.println("</table></center></div>");
//rs.close();
  }
%>
</body>
<a href="manage.jsp">返回明细查询</a><FORM  METHOD=POST ACTION="question.jsp">
   调查单编号
  <input type="text" name="invest_id">
  <input type=submit  VALUE="查询" style="font-size: 10pt;height:20;width:60" >
</form>
<jsp:useBean id="db6" scope="page" class="test.db" />
<%
String n2=request.getParameter("invest_id");
n2=db6.getStr(n2);
// if (n2.length()==0)
//{n3="";}
// else
//{ n3=n2;} sql2="SELECT bb.code_name AS question, cc.code_name AS answer FROM invest_accept_ques aa INNER JOIN invest_code bb ON aa.question_id = bb.code_id INNER JOIN invest_code cc ON aa.answer_id = cc.code_id WHERE aa.invest_id = '"+n2+"'";
// out.println(sql2); ResultSet rs6=db6.executeQuery(sql2);
if (rs6!=null){
   out.println() ;
   out.println("<div align=\"center\">") ;
   out.println("<center>") ;
   //if (n2.length()!=0)
   out.println("<p>调查单编号:"+n2+"</p>");
   out.println("<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\">") ;
   out.println("<tr><td width=\"100\" bgcolor=\"#D9E6F4\" align=\"center\"><font color=\"#000000\">问题名称</font></td>") ;
   out.println("<td width=\"75\" bgcolor=\"#D9E6F4\" align=\"center\"><font color=\"#000000\">问题答案</font></td>") ; while (rs6.next()){
  out.println("<tr><td align=\"center\" bgcolor=#f4f4f4>"+db6.getStr(rs6.getString(1))+"</td><td align=\"center\" bgcolor=#f4f4f4>"+db6.getStr(rs6.getString(2))+"</td>");
   }
out.println("</table></center></div>");
rs6.close();
}
%></head>
</html>

调试易

一个奇怪的问题

解决方案 »