sqlserverinnullobjectconvertutil.java

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

package org.speedframework.convert;

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

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

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

    /**
     * 方法描述信息，
     * 描述方法是做什么的，
     * 如何调用，最好给出调用代码示例。
     *
     * @param ps
     * @param index
     * @param sourceType
     *
     * @throws SQLException
     */
    public static void importData(PreparedStatement ps, int index, String sourceType) throws SQLException {
        if (sourceType.equals("bit") || sourceType.equals("BIT")) {
            ps.setNull(index, Types.BIT);
        }

        if (sourceType.equals("int") || sourceType.equals("INT")) {
            ps.setNull(index, Types.INTEGER);
        }

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

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

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

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

        if (sourceType.equals("money") || sourceType.equals("MONEY")) {
            ps.setNull(index, Types.DOUBLE);
        }

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

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

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

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

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

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

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

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

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

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

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

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

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

        if (sourceType.equals("varbinary") || sourceType.equals("VARBINARY")) {
            ps.setNull(index, Types.BINARY);
        }

        if (sourceType.equals("image") || sourceType.equals("IMAGE")) {
            ps.setNull(index, Types.BINARY);
        }
    }
}