日本在线观看一区二区三区,伊人久久大香线蕉av一区二区,成人国产精品av

Oracle

Kavin — Mon, 04 Feb 2013 08:47:00 GMT

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') );

Kavin 2013-02-04 16:47 发表评论

Auto complete with Jquery

Kavin — Thu, 07 Jun 2012 14:39:00 GMT

1. config servlet in web.xml

    addressData
    com.xxx.webapp.AddressDataAutoCompleteServlet
    1


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();
});

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");

}
}

Kavin 2012-06-07 22:39 发表评论

Security Test: Unauthorized access to users data via Browser’s Cach

Kavin — Thu, 09 Jun 2011 09:53:00 GMT

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

Kavin 2011-06-09 17:53 发表评论

SSH2中，直接获取SEQUENCE的NEXTVAL �Q��用OracleSequenceMaxValueIncrementer

Kavin — Fri, 06 May 2011 06:24:00 GMT

SSH2中，直接获取SEQUENCE的NEXTVAL

使用Spring�?�c?org.springframework.jdbc.support.incrementer.OracleSequenceMaxValueIncrementer

Spring配置文�g�Q?br />

1     <bean id="userDao" class="com.xx.dao.impl.UserDAOImpl">
2         <property name="sessionFactory" ref="sessionFactory" />
3         <property name="seqGenerator" ref="seqDispGenerator">property>
5     bean>
6
7     <bean id="seqDispGenerator" class="org.springframework.jdbc.support.incrementer.OracleSequenceMaxValueIncrementer">
8         <property name="dataSource" ref="dataSource">property>
9         <property name="incrementerName" ><value>SEQ_DISP_IDvalue>property>
10     bean>

UserDAOImpl.java中引用：

private OracleSequenceMaxValueIncrementer seqGenerator;



    /**
     * @return the seqGenerator
     */
    public OracleSequenceMaxValueIncrementer getSeqGenerator() {
        return seqGenerator;
    }

    /**
     * @param seqGenerator the seqGenerator to set
     */
    public void setSeqGenerator(OracleSequenceMaxValueIncrementer seqGenerator) {
        this.seqGenerator = seqGenerator;
    }

UserDAOImpl.java中调用：

1 System.out.println("---------------------- this.seqGenerator().nextIntValue="+this.seqGenerator.nextIntValue());

Kavin 2011-05-06 14:24 发表评论

Hibernate ID generator 自定义主键生成器

Kavin — Fri, 06 May 2011 05:42:00 GMT

Hibernate ID generator 自定义主键生成器

/**
*
*/
package com.ge.hc.eapp.generator;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import org.hibernate.HibernateException;
import org.hibernate.MappingException;

import org.hibernate.dialect.Dialect;

import org.hibernate.engine.SessionImplementor;

import org.hibernate.id.Configurable;
import org.hibernate.id.IdentifierGenerator;
import org.hibernate.id.PersistentIdentifierGenerator;

import org.hibernate.type.Type;

import java.io.Serializable;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import java.util.Properties;
import java.util.Properties;

/**
* @author Kavin
*
*/
public class DispNoGenerator implements IdentifierGenerator, Configurable {
    private static final Log log = LogFactory.getLog(DispNoGenerator.class);

    //存储最大值的数组的容�?/span>
    private static final int MAX_CAPACITY = 2000;

    /* 同步�?nbsp;*/
    private static final Object lock = new Object();

    //存储表存储在数组中的索引�?/span>
    private static Map map = new HashMap();

    //最大值数�l?/span>
    private static long[] seqs = new long[MAX_CAPACITY];

    //最大值数�l�已�l��用的定w��
    private static int lastIndex;

    //递增步长�Q�默认加1
    private int step = 1;
    private String key;
    private String sql;
    private Connection connection;
    private Class returnClass;

    public Serializable generate(SessionImplementor session, Object object)
        throws HibernateException {
        // TODO Auto-generated method stub
        connection = session.connection();

//        long seq = -1;

        //扑ֈ�索引�?br /> //        int index = findIndex();

//        //把最大值加1
//        seqs[index] = seqs[index] + step;
//
//        seq = seqs[index];

        String strGenerateId = null;
        System.out.println("this.sql="+this.sql);
        try {
            long t_SeqNo = this.getSeqValue();

        System.out.println("t_SeqNo="+t_SeqNo);

        //得到��水�?是自己写的工��L��生成�?形式�?00x
        String seqStr = String.valueOf(t_SeqNo);
        //JspFormate.currentFormateORM(seq);
        //得到yymmdd,是自己写的方法工��L��生成的yymmdd
        String preDate = "20110506";
        //得到hhmmss,是自己写的工��L��获取的hhmmss
        //String preHour = JspFormate.dateFormateOnlyHHMMSSORM(new Date());
        String preHour = "1035";
        strGenerateId = preDate + preHour + seqStr;
        } catch (SQLException e) {
            log.error(e);
            e.printStackTrace();
        }

        return strGenerateId;
    }

    /**
     * 扑ֈ�表中自动增长字段存储在数�l�中的烦引�?br />      * @return 索引�?br />      */
    private int findIndex() {
        int index = 0;

        //首先中缓存中取出索引�?/span>
        Integer integer = (Integer) map.get(key);

        //如果没有扑ֈ��׃��数据库中��d��最大值�ƈ�q�行cache
        if (null == integer) {
            //double check lock
            synchronized (lock) {
                integer = (Integer) map.get(key);

                if (null == integer) {
                    long maxvalue = 1;

                    try {
                        maxvalue = this.getSeqValue();
                    } catch (SQLException e) {
                        log.error(e);
                    }
                    maxvalue = new Long(0).longValue();

                    integer = new Integer(lastIndex++);
                    seqs[integer.intValue()] = maxvalue;
                    map.put(key, integer);
                }
            }
        }

        index = integer.intValue();

        return index;
    }

    public void configure(Type type, Properties params, Dialect d)
        throws MappingException {
        //     取出table参数
        String table = params.getProperty("table");

        if (table == null) {
            table = params.getProperty(PersistentIdentifierGenerator.TABLE);
        }

        //取出column参数
        String column = params.getProperty("column");

        if (column == null) {
            column = params.getProperty(PersistentIdentifierGenerator.PK);
        }

        //表的sehcma参数
        String schema = params.getProperty(PersistentIdentifierGenerator.SCHEMA);

        returnClass = type.getReturnedClass();

        //取出step参数
        String stepvalue = params.getProperty("step");

        if ((null != stepvalue) && !"".equals(stepvalue.trim())) {
            try {
                step = Integer.parseInt(stepvalue);
            } catch (Exception e) {
                log.error(e);
            }
        }

        //构造存储在Map中的索引值的key name
        key = table + "_$_" + column;

        //�Ҏ��参数构造取最大值的SQL
        sql = "select SEQ_COMPANY_ID.nextval from dual";


    }

    /**
     * 取指定SEQUENCE的��|��不存在记录返�?
     * @return Sequence最大�?br />      * @throws SQLException if sql error occurs.
     */
    private long getSeqValue() throws SQLException {
        long maxvalue = 0;

        PreparedStatement st = connection.prepareStatement(sql);
        System.out.println("============================================" + sql);
        ResultSet rs = null;

        try {
            rs = st.executeQuery();

            if (rs.next()) {
                maxvalue = rs.getLong(1);
            }

            sql = null;
        } finally {
            if (rs != null) {
                rs.close();
            }

            st.close();
        }

        return maxvalue;
    }

    /**
     * 取指定表中id字段的最大��|��不存在记录返�?
     * @return 最大�?br />      * @throws SQLException if sql error occurs.
     */
    private long getMaxvalue() throws SQLException {
        long maxvalue = 0;

        PreparedStatement st = connection.prepareStatement(sql);
        System.out.println("============================================" + sql);
        ResultSet rs = null;

        try {
            rs = st.executeQuery();

            if (rs.next()) {
                maxvalue = rs.getLong(1);
            }

            sql = null;
        } finally {
            if (rs != null) {
                rs.close();
            }

            st.close();
        }

        return maxvalue;
    }
}

Hibernate 配置文�g

Kavin 2011-05-06 13:42 发表评论

Struts2里面 s:textfield标签 Date�c�d��的格式化

Kavin — Thu, 05 May 2011 04:33:00 GMT

摘要: Normal 0 7.8 pt 0 2 false false false EN-US ZH-CN X-NONE ... 阅读全文

Kavin 2011-05-05 12:33 发表评论

Kavin — Tue, 19 Apr 2011 03:40:00 GMT

Description:.

To bring up System Properties:

1. Click Start and then Control Panel. From the Control Panel, double click System.

2. Another way to bring up this box is to right click the My Computer on your desktop. From the menu, select Properties.

Solution:

1. 参�?/span>http://www.passcape.com/windows_run_commands

除了�q�两�U�方式外�Q�还有一�U�直接运�?/span>system32下面的命令文件方�?/span>

�q�行C:"WINDOWS"system32 下面�?/span>sysdm.cpl�?/span>

Kavin 2011-04-19 11:40 发表评论

注解@Override 报错

Kavin — Mon, 18 Apr 2011 09:32:00 GMT

Description: @Override该标记是��Z��增强�E�序在编译时候的��查，JDK1.5下，如果该方法�ƈ不是一个覆盖父�cȝ��Ҏ��Q�在�~�译时编译器��׃��报告错误�?/span>

Analisys:

1public class A {
2 public void method(int i) {
3 }
4}
5
6public class B extends A {
7 @Override
8 public void method(int i) {
9 }
10
11//如果如下定义�Q�就会在�~�译时出��C��个错误，因�ؓ不是覆盖父类的方�?/span>
12@Override
13 public void method(int i, String p_Str) {
14 }
15
16}
17

JDK1.6正常�Q�支持对接口的实现的@Override

1public interface iA {
2
3 public void method(int i) {
4
5 }
6
7}
8
9public class B implements iA {
10
11 //JDK1.5下会报错�Q�JDK1.6下可�?/span>
12
13 @Override
14
15 public void method(int i, int j) {
16
17 }
18
19}
20

Kavin 2011-04-18 17:32 发表评论

安装Oracle Client 9/10�?Eclipse 启动时的JDK/JVM问题

Kavin — Fri, 15 Apr 2011 01:53:00 GMT

Description:
Incompatible JVM- Version 1.4.2_03 of the JVM is not suitable for th is product. Version:1.5 or greater is required.

Analisys:

安装Oracle Client 9/10�?/span>, Path 被设�|��ؓOracle自带�?/span>JDK 1.4, 启动高版�?/span>Eclipse(eclipse-jee-helios-SR1-win32.exe)�?/span>,　��默认用Oracle自带�?/span>JDK 1.4�Q�这样就会有问题�?/span>

Solution:

多种解决�Ҏ��

1. 修改环境变量�Q�　Path = %JAVA_HOME%"bin;%PATH%
权限的问题，我没有选择�q�个解决�Ҏ��?br />

2. 修改Eclipse启动��：修改Eclipse快捷方式的属性里面的目标�Q�　
D:"tool"eclipse-jee-helios-SR1-win32"eclipse"eclipse.exe　-vm "C:"Program Files"Java"jdk1.5.0_05"bin"javaw.exe"

Kavin 2011-04-15 09:53 发表评论

Eclipse 报错: class Implement Interface-> @Override function -> must override a superclass

Kavin — Thu, 07 Apr 2011 06:30:00 GMT

代码:
Class XX implements InterfaceYY{
    @override
    function funcXX(){
    }
}

Eclipse报错: must override a superclass implements

Analisys:
1. @override 可以针对 Interface; 不过最好用另外一个annotation: @implement
2. java5 java6 支持泛型
3. eclipse 里面的compile版本是JDK 5

Solution:
eclipse 里面的compile版本是JDK 5 -> �Ҏ�� JDK6

Kavin 2011-04-07 14:30 发表评论

日本在线观看一区二区三区,伊人久久大香线蕉av一区二区,成人国产精品av

Oracle

Auto complete with Jquery

Security Test: Unauthorized access to users data via Browser’s Cach

SSH2中，直接获取SEQUENCE的NEXTVAL �Q���用OracleSequenceMaxValueIncrementer

Hibernate ID generator 自定义主键生成器

Struts2里面 s:textfield标签 Date�c�d��的格式化

注解@Override 报错

安装Oracle Client 9/10�?Eclipse 启动时的JDK/JVM问题

Eclipse 报错: class Implement Interface-> @Override function -> must override a superclass

SSH2中，直接获取SEQUENCE的NEXTVAL �Q��用OracleSequenceMaxValueIncrementer