mysqlinnullobjectconvertutil.java

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

package org.speedframework.convert.mysql;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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