derbyinnullobjectconvertutil.java

羽量级数据持久层开发框架

package org.speedframework.convert;

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

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

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

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

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

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

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

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

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

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

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

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