db2innullobjectconvertutil.java

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

// $Id: DB2InNullObjectConvertUtil.java $Date: 2007-10-31 上午02:35:27 $ 
// $Id: DB2InNullObjectConvertUtil.java $Date: 2007-10-31 上午02:35:27 $ 
package org.speedframework.convert.db2;

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

/**
 * Class DB2InNullObjectConvertUtil
 * 
 * @author <a href="mailto:[e-mail]"> lizf </a>
 * @version $Revision:1.0.0, $Date: 2007-10-31 上午02:35:27 $
 */
public class DB2InNullObjectConvertUtil {
	public static void importData(PreparedStatement ps, int index,
			String sourceType) throws SQLException {
		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("float") || sourceType.equals("FLOAT")) {
			ps.setNull(index, Types.FLOAT);
		}

		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("char") || sourceType.equals("CHAR")) {
			ps.setNull(index, Types.CHAR);
		}

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

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

		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("datetime") || sourceType.equals("DATETIME")) {
			ps.setNull(index, Types.TIMESTAMP);
		}

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