generate_borrow_condition.jsp

来自「非常完整的Java开发的网络办公系统」· JSP 代码 · 共 69 行

JSP
69 行
字号 

<%@ page import="java.util.*" %>
<%@ page import="com.vnex.intranet.util.*" %>
<%@ page import="com.vnex.intranet.archives.value.ConditionBean" %>

<%
    session.removeAttribute("condition");
    String borrowDate = request.getParameter("borrowDate");
    String displayId = request.getParameter("displayId");
    String archiveTitle = request.getParameter("archiveTitle");
    String borrower = request.getParameter("borrower");
    String returnDate = request.getParameter("returnDate");
    
    ConditionBean bean = new ConditionBean();
    bean.setBorrowDate(borrowDate);
    bean.setDisplayId(displayId);
    bean.setArchiveTitle(archiveTitle);
    bean.setBorrower(borrower);
    bean.setReturnDate(returnDate);
    
    String condition = "";
    
    CommonDBOperation cdb = new CommonDBOperation();
    String DBProductName = cdb.getDBProduct();
    if(DBProductName.startsWith("Oracle")) 
    {
      if(borrowDate != null && !borrowDate.equals(""))
         condition += " and to_char(borrow_date, 'yyyy-mm-dd') = '"+borrowDate+"' ";
      if(displayId != null && !displayId.equals(""))
         condition += " and archive_id in (select archive_id from t_archive where archive_display_id like '%"+displayId+"%') ";
      if(archiveTitle != null && !archiveTitle.equals(""))
         condition += " and archive_id in (select archive_id from t_archive where archive_title like '%"+archiveTitle+"%') ";
      if(borrower != null && !borrower.equals(""))
         condition += " and borrower_id in (select emp_id from t_emp where name like '%"+borrower+"%') ";
      if(returnDate !=  null && !returnDate.equals(""))
         condition += " and to_char(return_date, 'yyyy-mm-dd') = '"+returnDate+"' ";
    }
    else if(DBProductName.startsWith("Microsoft SQL Server"))
    {
      if(borrowDate != null && !borrowDate.equals(""))
         condition += " and CONVERT(char(10),borrow_date,20) = '"+borrowDate+"' ";
      if(displayId != null && !displayId.equals(""))
         condition += " and archive_id in (select archive_id from t_archive where archive_display_id like '%"+cdb.changeCode(displayId)+"%') ";
      if(archiveTitle != null && !archiveTitle.equals(""))
         condition += " and archive_id in (select archive_id from t_archive where archive_title like '%"+cdb.changeCode(archiveTitle)+"%') ";
      if(borrower != null && !borrower.equals(""))
         condition += " and borrower_id in (select emp_id from t_emp where name like '%"+cdb.changeCode(borrower)+"%') ";
      if(returnDate !=  null && !returnDate.equals(""))
         condition += " and CONVERT(char(10),return_date,20) = '"+returnDate+"' ";
    }
       
    session.setAttribute("condition", condition);
    session.setAttribute("conditionBean", bean);
%> 

<html>
<head>
<script language=javascript>
function forward()
{
	document.location = "/mainctrl/archive/borrowArchiveList?search";
}
</script>
</head>
<body onload="javascript:forward()">
</body>
<html>

generate_borrow_condition.jsp - 源码说明

本页面展示了「非常完整的Java开发的网络办公系统」中的 generate_borrow_condition.jsp 源码文件，采用 JSP 编程语言编写，共 69 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与Java相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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