軟體印象

          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 閱讀(243) | 評論 (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 閱讀(308) | 評論 (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 閱讀(252) | 評論 (0)編輯 收藏

          主站蜘蛛池模板: 龙陵县| 泉州市| 兴文县| 勐海县| 赤峰市| 尼玛县| 樟树市| 陇南市| 新宁县| 独山县| 高平市| 光泽县| 淮安市| 邵武市| 文成县| 康保县| 都安| 于田县| 云林县| 长宁区| 芮城县| 塔城市| 武穴市| 嘉善县| 瓮安县| 海宁市| 和静县| 庆云县| 丰宁| 桑植县| 青河县| 呼和浩特市| 桦川县| 宜宾市| 察隅县| 宽甸| 苗栗县| 原平市| 保定市| 丹阳市| 承德县|