<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    軟體印象

    Kavin
    posts - 13, comments - 0, trackbacks - 0, articles - 0

    2011年6月9日

     

    DECLARE
      v_test_varray VARCHAR_VARRAY_TYPE := VARCHAR_VARRAY_TYPE('57610',
                                                               '61368',
                                                               '73111',
                                                               '37208',
                                                               '57639');
                                                               
    V_SQL        VARCHAR2(32767);
        V_SQL_IN     VARCHAR2(32767);
        V_SQL_ROWNUM VARCHAR2(32767);
        V_ORDER      VARCHAR2(32767);
        TYPE number_index_by_string IS TABLE OF NUMBER INDEX BY VARCHAR2(10);
        v_evt_id_list  NUMBER_INDEX_BY_STRING;
        
    Begin
      --orderArray VARCHAR_VARRAY_TYPE%type := VARCHAR_VARRAY_TYPE('11','22','33','44','55');

    /*  
      FOR i IN v_test_varray.FIRST .. v_test_varray.LAST LOOP
        IF v_test_varray.EXISTS(i) THEN
          DBMS_OUTPUT.put_line(i);
        END IF;
      END LOOP;
      
    */
      
      V_ORDER := Func_LIST_TO_ORDER(v_test_varray, 'A.COL_NAME');
      DBMS_OUTPUT.put_line('V_ORDER='||V_ORDER);
      
      V_SQL := 'SELECT * FROM TABLEA A'
               || ' WHERE '
               || ''
               || ''
               || ''
               || ''
               ;
      V_SQL := V_SQL || ' ( ' ||
                   FUNC_LIST_TO_IN_SQL(v_test_varray,
                                        'COL_NAME',
                                        ''''|| ')';
        V_SQL := V_SQL  ||
                 ' ORDER by ( ' || V_ORDER || ')';
                 
      DBMS_OUTPUT.put_line('V_SQL='||V_SQL);

    --- SET v_evt_id_list number_index_by_string

    FOR i IN v_test_varray.FIRST .. v_test_varray.LAST
      LOOP
         IF v_test_varray.EXISTS (i)
         THEN
            DBMS_OUTPUT.put_line (i);
            v_evt_id_list(v_test_varray(i)) := i;
         END IF;
      END LOOP;
      
    --- TEST v_evt_id_list number_index_by_string
      FOR i IN v_evt_id_list.FIRST .. v_evt_id_list.LAST
      LOOP
         IF v_evt_id_list.EXISTS (i)
         THEN
            DBMS_OUTPUT.put_line (i||' = '||v_evt_id_list(i) );
         END IF;
      END LOOP;
      
    -- GET v_evt_id_list number_index_by_string
      DBMS_OUTPUT.put_line (v_evt_id_list('73111') );

    posted @ 2013-02-04 16:47 Kavin 閱讀(246) | 評論 (0)編輯 收藏

    1. config servlet in web.xml
     <servlet>
         <servlet-name>addressData</servlet-name>
         <servlet-class>com.xxx.webapp.AddressDataAutoCompleteServlet</servlet-class>
         <load-on-startup>1</load-on-startup>
        </servlet>
       
    2. set autocomplete in JSP
    $().ready(function() {
     
     $("#addressLine1").autocomplete("<%=StrUtils.filterStr(request.getContextPath())%>/servlet/addressData?paramName=addressLine");
     $("#addressLine2").autocomplete("<%=StrUtils.filterStr(request.getContextPath())%>/servlet/addressData?paramName=addressLine2");
     $("#addressLine3").autocomplete("<%=StrUtils.filterStr(request.getContextPath())%>/servlet/addressData?paramName=addressLine3");
     $("#addressCity").autocomplete("<%=StrUtils.filterStr(request.getContextPath())%>/servlet/addressData?paramName=addressCity");
     $("#addressPostCode").autocomplete("<%=StrUtils.filterStr(request.getContextPath())%>/servlet/addressData?paramName=addressPostCode");
     $("#firstFocusObj").focus();
    });

    <html:text name="" tabindex="9" style="color: grey;" onclick="clearAddressValue(this)" styleId="addressLine1" value='<%=request.getAttribute("postalAddress1") == null ? defalutAddressValue : (String)request.getAttribute("postalAddress1")%>' property="TLContactDetailForm.postalAddress1" size="50" maxlength="50" styleClass="inputText2"></html:text>

    <input type="text" name="TLContactDetailForm.postalAddress1" maxlength="50" size="50" tabindex="9" value="Start typing your address and we will finish it for you" onclick="clearAddressValue(this)" id="addressLine1" style="color: grey;" class="inputText2">

    3. return addresses in java class: AddressDataAutoCompleteServlet.java

     

    package com.xxxxxx.webapp;

    import com.xxxxxx.exception.ServiceException;
    import com.xxxxxx.util.StrUtils;
    import com.xxxxxx.webapp.context.ServiceLocator;
    import com.xxxxxx.util.AddressShow;

    import java.io.IOException;
    import java.io.PrintWriter;

    import java.util.ArrayList;
    import java.util.List;

    import javax.servlet.ServletException;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;

    import org.apache.log4j.Logger;


    /**
     * Servlet implementation class AddressDataAutoCompleteServlet
     */
    public class AddressDataAutoCompleteServlet extends HttpServlet {
        private static final long serialVersionUID = 1L;
        public Logger LOG = Logger.getLogger(this.getClass().getName());

        /**
         * @see HttpServlet#HttpServlet()
         */
        public AddressDataAutoCompleteServlet() {
            super();
        }
       
        /**
         * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
         *      response)
         */
        protected void doGet(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
            String paramName = request.getParameter("paramName");
            String paramValue = request.getParameter("q");
            LOG.info(paramName);
            LOG.info(paramValue);

            List list = new ArrayList();

            try {
                list = ServiceLocator.getAddressService()
                                     .searchAddressList(paramName, paramValue);
            } catch (ServiceException e) {
             LOG.error(e.getMessage(),e);
            }

            PrintWriter t_PW = response.getWriter();
           
            for (int i = 0; i < list.size(); i++) {
                String address = StrUtils.toTitleCase((String) list.get(i));

                if (paramName.equals("addressLine")) {
                 AddressShow.showAddress(t_PW,address);
                } else if (paramName.equals("addressLine1")) {
                 AddressShow.showAddress(t_PW,address);
                } else if (paramName.equals("addressLine2")) {
                 AddressShow.showAddress(t_PW,address);
                } else if (paramName.equals("addressLine3")) {
                 AddressShow.showAddress(t_PW,address);
                } else if (paramName.equals("addressCity")) {
                 AddressShow.showAddress(t_PW,address);
                } else if (paramName.equals("addressPostCode")) {
                 AddressShow.showAddress(t_PW,address);
                }
            }
        }

        /**
         * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
         *      response)
         */
        protected void doPost(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
            this.doGet(request, response);
        }
    }

     

     


    ------
    AddressShow.java

    package com.intl.cigna.util;

    import java.io.PrintWriter;

    public class AddressShow
    {
      public static void showAddress(PrintWriter pw, String input)
      {
        pw.write(input + "\n");

      }
    }

    posted @ 2012-06-07 22:39 Kavin 閱讀(310) | 評論 (0)編輯 收藏

    Unauthorized access to users data via Browser’s Cach

    Solution:


    1 <%  response.setHeader("Pragma""no-cache"); 
    2                 response.setHeader("Cache-Control""no-store"); 
    3                 response.setHeader("Expires""0"); 
    4                 response.setDateHeader("Expires"-1); 
    5 %>
    6 

    posted @ 2011-06-09 17:53 Kavin 閱讀(255) | 評論 (0)編輯 收藏

    主站蜘蛛池模板: 九九精品成人免费国产片| 亚洲欧美熟妇综合久久久久| 免费大片av手机看片| 嘿嘿嘿视频免费网站在线观看| 国产AV无码专区亚洲AV男同| 免费人成大片在线观看播放电影 | 亚洲春色在线观看| 免费成人在线电影| 亚洲AV无码一区二区二三区软件| 久久国产美女免费观看精品 | 国产精品色午夜视频免费看| 亚洲av无码专区在线| 日韩精品成人无码专区免费| 亚洲日韩国产二区无码| 国产h视频在线观看免费| 亚洲av永久无码精品三区在线4 | 亚洲无码一区二区三区| 成年人网站在线免费观看| 亚洲欧洲国产综合AV无码久久| 日韩电影免费在线| 特级做a爰片毛片免费看| 亚洲乱码国产乱码精品精| 久久久久久久岛国免费播放 | 久久精品九九亚洲精品| 国产99视频精品免费观看7| 自拍偷自拍亚洲精品播放| 国产黄色一级毛片亚洲黄片大全| 99久久免费国产精精品| 亚洲精品视频在线观看视频| 成年女人视频网站免费m| 手机永久免费的AV在线电影网| 亚洲欧洲久久av| 99免费在线观看视频| 亚洲伊人久久大香线蕉AV| 青青青国产色视频在线观看国产亚洲欧洲国产综合 | 四虎影院在线免费播放| 亚洲精品国产日韩无码AV永久免费网| 亚洲国产精品国自产拍AV| 最近最新MV在线观看免费高清| 视频一区在线免费观看| 亚洲日本一区二区三区|