oracleinnullobjectconvertutil.java

来自「羽量级数据持久层开发框架」· Java 代码 · 共 64 行

package org.speedframework.convert.oracle;

//~--- JDK imports ------------------------------------------------------------

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Types;

/**
 * @author victorching
 */
public class OracleInNullObjectConvertUtil
 {

    /**
     * ����������Ϣ��
     * ���������ʲô�ģ�
     * ��ε��ã���ø����ô���ʾ��
     *
     * @param ps
     * @param index
     * @param sourceType
     *
     * @throws SQLException
     */
    public static void importData(PreparedStatement ps, int index, String sourceType) throws SQLException {
        if (sourceType.equals("varchar2") || sourceType.equals("VARCHAR2")) {
            ps.setNull(index, Types.VARCHAR);
        }

        if (sourceType.equals("number") || sourceType.equals("NUMBER")) {
            ps.setNull(index, Types.NUMERIC);
        }

        if (sourceType.equals("date") || sourceType.equals("DATE")) {
            ps.setNull(index, Types.DATE);
        }

        if (sourceType.equals("long") || sourceType.equals("LONG")) {
            ps.setNull(index, Types.VARCHAR);
        }

        if (sourceType.equals("raw") || sourceType.equals("RAW")) {
            ps.setNull(index, Types.LONGVARCHAR);
        }

        if (sourceType.equals("char") || sourceType.equals("CHAR")) {
            ps.setNull(index, Types.CHAR);
        }

        if (sourceType.equals("long raw") || sourceType.equals("LONG RAW")) {
            ps.setNull(index, Types.LONGVARBINARY);
        }

        if (sourceType.equals("blob") || sourceType.equals("BLOB")) {
            ps.setNull(index, Types.BLOB);
        }

        if (sourceType.equals("clob") || sourceType.equals("CLOB")) {
            ps.setNull(index, Types.CLOB);
        }
    }
}