軟體印象

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

          2012年6月7日

           

          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) | 評(píng)論 (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) | 評(píng)論 (0)編輯 收藏

          主站蜘蛛池模板: 崇明县| 鱼台县| 兴安盟| 金昌市| 武川县| 阿城市| 柞水县| 南宫市| 徐闻县| 宜川县| 河津市| 绩溪县| 宣威市| 哈巴河县| 安图县| 扎鲁特旗| 奈曼旗| 玉屏| 库尔勒市| 托克托县| 凤翔县| 屏山县| 光泽县| 都昌县| 鄂温| 博白县| 洞头县| 察雅县| 安阳县| 崇文区| 马山县| 彰化市| 垦利县| 新源县| 荔波县| 霸州市| 都昌县| 湖口县| 宁阳县| 曲阜市| 资溪县|