<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 閱讀(236) | 評論 (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 閱讀(302) | 評論 (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 閱讀(247) | 評論 (0)編輯 收藏

    主站蜘蛛池模板: 131美女爱做免费毛片| 你懂得的在线观看免费视频| 免费黄色网址网站| 亚洲精品永久www忘忧草| 久久国产乱子免费精品| 亚洲日本va午夜中文字幕一区| 中文字幕无码日韩专区免费| 中文字幕一精品亚洲无线一区| 成人无码区免费A∨直播| 亚洲午夜无码久久久久| 波多野结衣免费一区视频| 久久久久亚洲AV成人无码网站| 免费人成黄页在线观看日本| 亚洲avav天堂av在线不卡| 18成禁人视频免费网站| 亚洲av乱码一区二区三区 | 亚洲电影免费在线观看| 99爱视频99爱在线观看免费| 亚洲综合免费视频| 久久久www成人免费毛片| 亚洲人成网站在线在线观看 | 亚洲人成网站色在线入口| 成人福利在线观看免费视频| 国产午夜亚洲精品午夜鲁丝片| 国产一区二区免费| 亚洲最新黄色网址| 日韩高清在线免费观看| 狠狠躁狠狠爱免费视频无码| 久久久久无码精品亚洲日韩 | 亚洲avav天堂av在线网毛片| 亚洲麻豆精品国偷自产在线91| 国产中文字幕在线免费观看 | 国产福利免费在线观看| 丰满人妻一区二区三区免费视频| 亚洲AV无码一区东京热久久| ww4545四虎永久免费地址| 午夜亚洲乱码伦小说区69堂| 亚洲AV无码成人精品区在线观看| 国语成本人片免费av无码| A级毛片成人网站免费看| 亚洲国产美女精品久久久久|