⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 fct.jsp

📁 办公系统的设计与实现。该系统是基于web的开发项目
💻 JSP
字号:
🔍 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="refresh" content="1; url=testPage.jsp">
<title>无标题文档</title>
</head>

<body>
<% boolean hasParam=false;  
   String sWhere=""; 


  //文件标题
  String sql=request.getParameter("title");
  byte[] tmpbyte=sql.getBytes("iso_8859_1");
  sql=new String(tmpbyte);
  if (sql != null && ! sql.equals("")) {
            
        hasParam = true;
        sWhere += "title like '%" +sql+ "%'";
    }

    //文件关键字
   String pkeyword=request.getParameter("keyword");
   tmpbyte=pkeyword.getBytes("iso_8859_1");
  pkeyword=new String(tmpbyte);

    if (pkeyword != null && ! pkeyword.equals("")) {
            
      if (! sWhere.equals("")) sWhere += " and ";
        hasParam = true;
        sWhere += "keyword like '%" +pkeyword+  "%'";
    }
   //文件类别
   String pkind= request.getParameter("kind");
   tmpbyte=pkind.getBytes("iso_8859_1");
   pkind=new String(tmpbyte);

    if (pkind != null && ! pkind.equals("")) {
            
      if (! sWhere.equals("")) sWhere += " and ";
        hasParam = true;
        sWhere += "kind like '%" +pkind+ "%'";
    }
//文件来源
   String porigin= request.getParameter("origin");
   tmpbyte=porigin.getBytes("iso_8859_1");
   porigin=new String(tmpbyte);

    if (porigin != null && ! porigin.equals("")) {
            
      if (! sWhere.equals("")) sWhere += " and ";
        hasParam = true;
        sWhere += "origin like '%" +porigin+ "%'";
    }
//上传时间
  String pdate= request.getParameter("ddate");
   tmpbyte=pdate.getBytes("iso_8859_1");
   pdate=new String(tmpbyte);

    if (pdate!= null && ! pdate.equals("")) {
            
      if (! sWhere.equals("")) sWhere += " and ";
        hasParam = true;
        sWhere += "ddate like '%"  +pdate+ "%'";
    } 
  if (hasParam) sWhere = "select * from file_upload_info where "+sWhere; 
  

session.setAttribute("whr",sWhere);
%>














<%! 
String getPram(javax.servlet.http.HttpServletRequest req,String name){
  String title=req.getParameter(name);

  if(title==null||title.equals("")) return "";
  title=replace(title,"&amp;","&");
  title=replace(title,"&lt;","<");
  title=replace(title,"&gt;",">");
  title=replace(title,"&amp;lt;","<");
  title=replace(title,"&amp;gt;",">");

  return  title;
}
 private String replace(String str, String pattern, String replace) {
    if (replace == null) {
      replace = "";
    }
    int s = 0, e = 0;
    StringBuffer result = new StringBuffer((int) str.length()*2);
    while ((e = str.indexOf(pattern, s)) >= 0) {
      result.append(str.substring(s, e));
      result.append(replace);
      s = e + pattern.length();
    }
    result.append(str.substring(s));
    return result.toString();
  }
  boolean isNumber (String param) {
    boolean result;
    if ( param == null || param.equals("")) return true;
    param=param.replace('d','_').replace('f','_');
    try {
      Double dbl = new Double(param);
      result = true;
    }
    catch (NumberFormatException nfe) {
      result = false;
    }
    return result;
  }

%>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -