Oracle ·ÖÒ³

<!-- 
@Name£º·ÖÀàͳ¼ÆÃ÷ϸ
@Time£º2010.01.05
@author JZP
--->
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page language="java" import="wfc.service.database.DB"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.Statement"%>
<%@ include file="./../include/stat_common_head.inc"%>
<% 
 //·ÖÒ³¿ªÊ¼
 String strKey=session.getId();
 
 String beginTime=(String)session.getAttribute(strKey+"beginTime");
 String endTime=(String)session.getAttribute(strKey+"endTime");
  
 String staType = request.getParameter("staType");//ͳ¼ÆÀàÐÍ£º°ä·¢¡¢×¢Ïú¡¢×÷·Ï¡¢»Ö¸´×¢Ïú¡¢ÒÅʧ
 String passTarget = request.getParameter("passTarget");//Ö¤¼þÀàÐÍ
 
 String selectSql="select P.ST_PASS_CODE gb1,P.ST_NAME gb2,(select ST_NAME_SHORT from T_PASS_ISSUE_DEPT where ST_PASS_ISSUE_DEPT_CODE = P.ST_ISSUE_DEPT_ID) gb3,to_char(P.DT_ISSUE,'yyyy-MM-dd') gb4,to_char(P.DT_EXPIRE,'yyyy-MM-dd') gb5,to_char(P.DT_NULLIFY,'yyyy-MM-dd') gb6,p.ST_COMMENT gb7";
 String fromSql=" from T_PASS P";
 
 String whereSql=" where P.DT_ISSUE >= to_date('" + beginTime + "', 'yyyy-MM-dd') and P.DT_ISSUE <= to_date('" + endTime + "', 'yyyy-MM-dd') and P.ST_ISSUE_DEPT_ID = '24'";
 
 if(staType.equals("°ä·¢")){
   whereSql += " and P.ST_PASS_TYPE='" + passTarget + "'";
 }else if(staType.equals("×¢Ïú")){
   whereSql=" where P.DT_NULLIFY >= to_date('" + beginTime + "', 'yyyy-MM-dd') and P.DT_NULLIFY <= to_date('" + endTime + "', 'yyyy-MM-dd') and P.ST_ISSUE_DEPT_ID = '24'";
   whereSql += " and P.ST_PASS_TYPE='" + passTarget + "' and P.ST_STATE ='×¢Ïú'";
 }else{
  whereSql=" where P.DT_NULLIFY >= to_date('" + beginTime + "', 'yyyy-MM-dd') and P.DT_NULLIFY <= to_date('" + endTime + "', 'yyyy-MM-dd') and P.ST_I