select.jsp

来自「javamail发送程序」· JSP 代码 · 共 103 行

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" %>
<jsp:useBean id="JspGet" scope="page" class="myjsp.JspGetString" />
<%!
  String sNameValue=new String();
  String sEmail=new String();
  String sDanwei=new String();
  String sLeixing=new String();

  public String getStr(String str)
  {
    try
    {
        String temp1=str;
        byte[] temp2=temp1.getBytes("GBK");
        String temp=new String(temp2);
        return temp;

    }
    catch(Exception e)
    {
      return e.toString();
    }
  }
%>
<%
  boolean selno1=false;
  String sSelect="select * from xiao where";
  sNameValue=request.getParameter("name");
  sEmail=request.getParameter("email");
  sDanwei=request.getParameter("danwei");
  sLeixing=request.getParameter("leixing");
  //解码
  sNameValue=JspGet.SetString(sNameValue);
  sEmail=JspGet.SetString(sEmail);
  sDanwei=JspGet.SetString(sDanwei);
  sLeixing=JspGet.SetString(sLeixing);
  //判断查询项是否有姓名
  if(sNameValue!=null && !sNameValue.equals(""))
  {
      if (selno1==false)
      {
        sSelect=sSelect+" name like '*"+sNameValue+"*'";
        selno1=true;
      }
      else
      {
        sSelect=sSelect+" and name like '*"+sNameValue+"*'";
      }
  }
  //判断查询项是否有邮箱地址
  if(sEmail!=null && !sEmail.equals(""))
  {
      if (selno1==false)
      {
        sSelect=sSelect+" tomail like '*"+sEmail+"*'";
        selno1=true;
      }
      else
      {
        sSelect=sSelect+" and tomail like '*"+sEmail+"*'";
      }
  }
  //判断查询项是否有单位名称
  if(sDanwei!=null && !sDanwei.equals(""))
  {
      if (selno1==false)
      {
        sSelect=sSelect+" danwei like '*"+sDanwei+"*'";
        selno1=true;
      }
      else
      {
        sSelect=sSelect+" and danwei like '*"+sDanwei+"*'";
      }
  }
  //判断查询项是否有类型
  if(sLeixing!=null && !sLeixing.equals(""))
  {
      if (selno1==false)
      {
        sSelect=sSelect+" leixing like '*"+sLeixing+"*'";
        selno1=true;
      }
      else
      {
        sSelect=sSelect+" and leixing like '*"+sLeixing+"*'";
      }
  }
  //如果没有任何查询条件则无条件返回
  if(selno1==false)
    response.sendRedirect("select.jsp");
  else
  {
    sSelect=sSelect+" and not isnull(tomail) and biaozhu<9";
    out.println(sSelect);
    //编码
    sSelect=JspGet.GetString(sSelect);
    //JspSel.SqlSelect(sSelect);
    response.sendRedirect("email.jsp?jspSql="+sSelect+"&jspClass=sel");
    //sSelect="";
  }
%>