com.github.obase.mysql.JdbcMeta Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of obase-mysql Show documentation
A very simple/efficient Mysql Client Framework
The newest version!
package com.github.obase.mysql;

import java.io.InputStream;
import java.io.Reader;
import java.math.BigDecimal;
import java.math.BigInteger;
import java.net.URL;
import java.sql.Blob;
import java.sql.Clob;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.Ref;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLXML;
import java.sql.Time;
import java.sql.Timestamp;
import java.sql.Types;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.concurrent.ConcurrentHashMap;

import com.github.obase.MessageException;
import com.github.obase.WrappedException;
import com.github.obase.mysql.asm.AsmKit;

/**
 * 执行JDBC的元数据类
 *
 */
@SuppressWarnings({})
public abstract class JdbcMeta {

	// =============================================
	// 临时对象最大数量,默认1024
	// =============================================
	// public static final int TEMP_CACHE_MAX_SIZE = java.lang.Integer.parseInt(System.getProperty("JdbcMeta.TEMP_CACHE_MAX_SIZE", "1024"));

	// =============================================
	// 接口抽象方法
	// =============================================

	public abstract Object getValue(Object obj, String name);

	// 与V1版本相比变化在于细粒度化
	public abstract void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException;

	public abstract Object getResult(ResultSet rs, Map types) throws SQLException;

	public abstract void getResult2(ResultSet rs, Map types, Object obj) throws SQLException;

	// =============================================
	// 常用实例
	// =============================================

	@SuppressWarnings("unchecked")
	public static final JdbcMeta MAP = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, String name) {
			return ((Map) obj).get(name);
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			setParamByType(ps, pos, ((Map) obj).get(name));
		}

		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			Map map = (Map) obj;
			for (Map.Entry entry : types.entrySet()) {
				map.put(entry.getKey(), rs.getObject(entry.getValue()));
			}
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			Map map = new HashMap(types.size());
			for (Map.Entry entry : types.entrySet()) {
				map.put(entry.getKey(), rs.getObject(entry.getValue()));
			}
			return map;
		}
	};

	@SuppressWarnings({ "unchecked", "rawtypes" })
	public static final JdbcMeta LIST = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, String name) {
			throw new UnsupportedOperationException();
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			List list = (List) obj;
			if (pos <= list.size()) {
				setParamByType(ps, pos, list.get(pos - 1));
			} else {
				ps.setNull(pos, Types.OTHER);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			List list = (List) obj;
			int size = types.size();
			for (int i = 0; i < size; i++) {
				list.add(rs.getObject(i + 1));
			}
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			int size = types.size();
			List list = new ArrayList(size);
			for (int i = 0; i < size; i++) {
				list.add(rs.getObject(i + 1));
			}
			return list;
		}

	};

	public static final JdbcMeta ARRAY = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, String name) {
			throw new UnsupportedOperationException();
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Object[] array = (Object[]) obj;
			if (pos <= array.length) {
				setParamByType(ps, pos, array[pos - 1]);
			} else {
				ps.setNull(pos, Types.OTHER);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			int size = types.size();
			Object[] array = (Object[]) obj;
			for (int i = 0; i < size && i < array.length; i++) {
				array[i] = rs.getObject(i + 1);
			}
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			int size = types.size();
			Object[] array = new Object[size];
			for (int i = 0; i < size; i++) {
				array[i] = rs.getObject(i + 1);
			}
			return array;
		}

	};

	public static JdbcMeta Boolean = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Boolean val = (Boolean) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setBoolean(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			boolean ret = rs.getBoolean(1);
			return rs.wasNull() ? null : ret;
		}

	};

	public static JdbcMeta Character = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Character val = (Character) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setString(pos, val.toString());
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			String ret = rs.getString(1);
			return ret == null || ret.length() == 0 ? null : ret.charAt(0);
		}

	};

	public static JdbcMeta Byte = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Boolean val = (Boolean) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setBoolean(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			byte ret = rs.getByte(1);
			return rs.wasNull() ? null : ret;
		}

	};

	public static JdbcMeta Short = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Short val = (Short) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setShort(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			short ret = rs.getShort(1);
			return rs.wasNull() ? null : ret;
		}

	};

	public static JdbcMeta Integer = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Integer val = (Integer) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setInt(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			int ret = rs.getInt(1);
			return rs.wasNull() ? null : ret;
		}

	};

	public static JdbcMeta Long = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Long val = (Long) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setLong(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			long ret = rs.getLong(1);
			return rs.wasNull() ? null : ret;
		}

	};

	public static JdbcMeta Float = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Float val = (Float) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setFloat(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			float ret = rs.getInt(1);
			return rs.wasNull() ? null : ret;
		}

	};

	public static JdbcMeta Double = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Double val = (Double) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setDouble(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			double ret = rs.getDouble(1);
			return rs.wasNull() ? null : ret;
		}
	};

	public static JdbcMeta String = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			String val = (String) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setString(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getString(1);
		}

	};

	public static JdbcMeta BigDecimal = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			BigDecimal val = (BigDecimal) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setBigDecimal(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getBigDecimal(1);
		}

	};

	public static JdbcMeta BigInteger = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			BigInteger val = (BigInteger) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setBigDecimal(pos, new BigDecimal(val));
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			BigDecimal val = rs.getBigDecimal(1);
			return val == null ? null : val.toBigInteger();
		}

	};

	public static JdbcMeta JavaUtilDate = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			java.util.Date val = (java.util.Date) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setTimestamp(pos, new Timestamp(val.getTime()));
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			Date ret = rs.getDate(1);
			return ret == null ? null : new java.util.Date(ret.getTime());
		}

	};

	public static JdbcMeta Date = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Date val = (Date) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setDate(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getDate(1);
		}

	};

	public static JdbcMeta Time = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Time val = (Time) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setTime(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getTime(1);
		}

	};

	public static JdbcMeta Timestamp = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Timestamp val = (Timestamp) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setTimestamp(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getTimestamp(1);
		}
	};

	public static JdbcMeta Ref = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Ref val = (Ref) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setRef(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getRef(1);
		}

	};

	public static JdbcMeta URL = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			URL val = (URL) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setURL(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getURL(1);
		}

	};

	public static JdbcMeta SQLXML = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			SQLXML val = (SQLXML) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setSQLXML(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getSQLXML(1);
		}
	};

	public static JdbcMeta Blob = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Blob val = (Blob) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setBlob(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getBlob(1);
		}
	};

	public static JdbcMeta Clob = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Clob val = (Clob) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setClob(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getClob(1);
		}
	};

	public static JdbcMeta Bytes = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			byte[] val = (byte[]) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setBytes(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getBytes(1);
		}
	};

	public static JdbcMeta InputStream = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			InputStream val = (InputStream) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setBinaryStream(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getBinaryStream(1);
		}
	};

	public static JdbcMeta Reader = new JdbcMeta() {

		@Override
		public Object getValue(Object obj, java.lang.String name) {
			return obj;
		}

		@Override
		public void setParam(PreparedStatement ps, int pos, Object obj, String name) throws SQLException {
			Reader val = (Reader) obj;
			if (pos != 1 || val == null) {
				ps.setNull(pos, Types.OTHER);
			} else {
				ps.setCharacterStream(pos, val);
			}
		}

		@Override
		public void getResult2(ResultSet rs, Map types, Object obj) throws SQLException {
			// nohting
		}

		@Override
		public Object getResult(ResultSet rs, Map types) throws SQLException {
			return rs.getCharacterStream(1);
		}
	};

	// =============================================
	// 辅助方法
	// =============================================
	public static void setParamByType(PreparedStatement pstmt, int pos, Object param) throws SQLException {

		if (param == null) {
			pstmt.setNull(pos, Types.OTHER);
			return;
		}

		if (param instanceof String) {
			pstmt.setString(pos, (String) param);
		} else if (param instanceof Integer) {
			pstmt.setInt(pos, (Integer) param);
		} else if (param instanceof Long) {
			pstmt.setLong(pos, (Long) param);
		} else if (param instanceof Double) {
			pstmt.setDouble(pos, (Double) param);
		} else if (param instanceof Float) {
			pstmt.setFloat(pos, (Float) param);
		} else if (param instanceof Short) {
			pstmt.setShort(pos, (Short) param);
		} else if (param instanceof java.util.Date) {
			pstmt.setDate(pos, new Date(((java.util.Date) param).getTime()));
		} else if (param instanceof Date) {
			pstmt.setDate(pos, (Date) param);
		} else if (param instanceof Boolean) {
			pstmt.setBoolean(pos, (Boolean) param);
		} else if (param instanceof Character) {
			pstmt.setString(pos, param.toString());
		} else if (param instanceof Byte) {
			pstmt.setByte(pos, (Byte) param);
		} else if (param instanceof BigDecimal) {
			pstmt.setBigDecimal(pos, (BigDecimal) param);
		} else if (param instanceof BigInteger) {
			pstmt.setBigDecimal(pos, new BigDecimal((BigInteger) param));
		} else if (param instanceof Time) {
			pstmt.setTime(pos, (Time) param);
		} else if (param instanceof Timestamp) {
			pstmt.setTimestamp(pos, (Timestamp) param);
		} else if (param instanceof byte[]) {
			pstmt.setBytes(pos, (byte[]) param);
		} else if (param instanceof Ref) {
			pstmt.setRef(pos, (Ref) param);
		} else if (param instanceof URL) {
			pstmt.setURL(pos, (URL) param);
		} else if (param instanceof SQLXML) {
			pstmt.setSQLXML(pos, (SQLXML) param);
		} else if (param instanceof Blob) {
			pstmt.setBlob(pos, (Blob) param);
		} else if (param instanceof Clob) {
			pstmt.setClob(pos, (Clob) param);
		} else if (param instanceof InputStream) {
			pstmt.setBinaryStream(pos, (InputStream) param);
		} else if (param instanceof Reader) {
			pstmt.setCharacterStream(pos, (Reader) param);
		} else {
			JavaTypeMeta meta = JavaTypeMeta.get(param.getClass());
			if (meta != null) {
				meta.set(pstmt, pos, param);
			} else {
				pstmt.setObject(pos, param);
			}
		}
	}

	@SuppressWarnings("unchecked")
	public static  R getResultByType(ResultSet rs, int pos, Class type) throws SQLException {

		if (type == String.class) {
			return (R) rs.getString(pos);
		} else if (type == Integer.class || type == int.class) {
			int ret = rs.getInt(pos);
			return (R) (rs.wasNull() ? null : ret);
		} else if (type == Long.class || type == long.class) {
			long ret = rs.getLong(pos);
			return (R) (rs.wasNull() ? null : ret);
		} else if (type == Double.class || type == double.class) {
			double ret = rs.getDouble(pos);
			return (R) (rs.wasNull() ? null : ret);
		} else if (type == Float.class || type == float.class) {
			float ret = rs.getFloat(pos);
			return (R) (rs.wasNull() ? null : ret);
		} else if (type == Short.class || type == short.class) {
			short ret = rs.getShort(pos);
			return (R) (rs.wasNull() ? null : ret);
		} else if (type == java.util.Date.class) {
			Date ret = rs.getDate(pos);
			return (R) (ret == null ? null : new java.util.Date(ret.getTime()));
		} else if (type == Date.class) {
			return (R) rs.getDate(pos);
		} else if (type == Boolean.class || type == boolean.class) {
			boolean ret = rs.getBoolean(pos);
			return (R) (rs.wasNull() ? null : ret);
		} else if (type == Character.class || type == char.class) {
			String ret = rs.getString(pos);
			return (R) (ret == null ? null : ret.charAt(0));
		} else if (type == Byte.class || type == byte.class) {
			byte ret = rs.getByte(pos);
			return (R) (rs.wasNull() ? null : ret);
		} else if (type == BigDecimal.class) {
			return (R) rs.getBigDecimal(pos);
		} else if (type == BigInteger.class) {
			BigDecimal ret = rs.getBigDecimal(pos);
			return (R) (ret == null ? null : ret.toBigInteger());
		} else if (type == Time.class) {
			return (R) rs.getTime(pos);
		} else if (type == Timestamp.class) {
			return (R) rs.getTimestamp(pos);
		} else if (type == byte[].class) {
			return (R) rs.getBytes(pos);
		} else if (type == Ref.class) {
			return (R) rs.getRef(pos);
		} else if (type == URL.class) {
			return (R) rs.getURL(pos);
		} else if (type == SQLXML.class) {
			return (R) rs.getSQLXML(pos);
		} else if (type == Blob.class) {
			return (R) rs.getBlob(pos);
		} else if (type == Clob.class) {
			return (R) rs.getClob(pos);
		} else if (type == InputStream.class) {
			return (R) rs.getBinaryStream(pos);
		} else if (type == Reader.class) {
			return (R) rs.getCharacterStream(pos);
		} else {
			JavaTypeMeta meta = JavaTypeMeta.get(type);
			if (meta != null) {
				return meta.get(rs, pos, type);
			} else {
				return (R) rs.getObject(pos);
			}
		}
	}

	// ============================================
	// 细粒度辅助方法,减少字节码
	// ============================================
	public static final void set_boolean(PreparedStatement pstmt, int p, boolean value) throws SQLException {
		pstmt.setBoolean(p, value);
	}

	public static final void set_char(PreparedStatement pstmt, int p, char value) throws SQLException {
		pstmt.setString(p, java.lang.String.valueOf(value));
	}

	public static final void set_byte(PreparedStatement pstmt, int p, byte value) throws SQLException {
		pstmt.setByte(p, value);
	}

	public static final void set_short(PreparedStatement pstmt, int p, short value) throws SQLException {
		pstmt.setShort(p, value);
	}

	public static final void set_int(PreparedStatement pstmt, int p, int value) throws SQLException {
		pstmt.setInt(p, value);
	}

	public static final void set_long(PreparedStatement pstmt, int p, long value) throws SQLException {
		pstmt.setLong(p, value);
	}

	public static final void set_float(PreparedStatement pstmt, int p, float value) throws SQLException {
		pstmt.setFloat(p, value);
	}

	public static final void set_double(PreparedStatement pstmt, int p, double value) throws SQLException {
		pstmt.setDouble(p, value);
	}

	public static final void set_Boolean(PreparedStatement pstmt, int p, Boolean value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setBoolean(p, value);
		}
	}

	public static final void set_Character(PreparedStatement pstmt, int p, Character value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setString(p, value.toString());
		}
	}

	public static final void set_Byte(PreparedStatement pstmt, int p, Byte value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setByte(p, value);
		}
	}

	public static final void set_Short(PreparedStatement pstmt, int p, Short value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setShort(p, value);
		}
	}

	public static final void set_Integer(PreparedStatement pstmt, int p, Integer value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setInt(p, value);
		}
	}

	public static final void set_Long(PreparedStatement pstmt, int p, Long value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setLong(p, value);
		}
	}

	public static final void set_Float(PreparedStatement pstmt, int p, Float value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setFloat(p, value);
		}
	}

	public static final void set_Double(PreparedStatement pstmt, int p, Double value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setDouble(p, value);
		}
	}

	public static final void set_String(PreparedStatement pstmt, int p, String value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setString(p, value);
		}
	}

	public static final void set_BigDecimal(PreparedStatement pstmt, int p, BigDecimal value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setBigDecimal(p, value);
		}
	}

	public static final void set_BigInteger(PreparedStatement pstmt, int p, BigInteger value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setBigDecimal(p, new BigDecimal(value));
		}
	}

	public static final void set_JavaUtilDate(PreparedStatement pstmt, int p, java.util.Date value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setTimestamp(p, new Timestamp(value.getTime()));
		}
	}

	public static final void set_Date(PreparedStatement pstmt, int p, Date value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setDate(p, value);
		}
	}

	public static final void set_Time(PreparedStatement pstmt, int p, Time value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setTime(p, value);
		}
	}

	public static final void set_Timestamp(PreparedStatement pstmt, int p, Timestamp value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setTimestamp(p, value);
		}
	}

	public static final void set_bytes(PreparedStatement pstmt, int p, byte[] value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setBytes(p, value);
		}
	}

	public static final void set_InputStream(PreparedStatement pstmt, int p, InputStream value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setBinaryStream(p, value);
		}
	}

	public static final void set_Reader(PreparedStatement pstmt, int p, Reader value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setCharacterStream(p, value);
		}
	}

	public static final void set_Blob(PreparedStatement pstmt, int p, Blob value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setBlob(p, value);
		}
	}

	public static final void set_Clob(PreparedStatement pstmt, int p, Clob value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setClob(p, value);
		}
	}

	public static final void set_Ref(PreparedStatement pstmt, int p, Ref value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setRef(p, value);
		}
	}

	public static final void set_URL(PreparedStatement pstmt, int p, URL value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setURL(p, value);
		}
	}

	public static final void set_SQLXML(PreparedStatement pstmt, int p, SQLXML value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			pstmt.setSQLXML(p, value);
		}
	}

	public static final void set_Object(PreparedStatement pstmt, int p, Object value) throws SQLException {
		if (value == null) {
			pstmt.setNull(p, Types.OTHER);
		} else {
			JavaTypeMeta meta = JavaTypeMeta.get(value.getClass());
			if (meta != null) {
				meta.set(pstmt, p, value);
			} else {
				pstmt.setObject(p, value);
			}
		}
	}

	public static final boolean get_boolean(ResultSet rs, Integer pos) throws SQLException {
		return rs.getBoolean(pos);
	}

	public static final char get_char(ResultSet rs, Integer pos) throws SQLException {
		String val = rs.getString(pos);
		if (val != null && val.length() > 0) {
			return val.charAt(0);
		}
		return '\0';
	}

	public static final byte get_byte(ResultSet rs, Integer pos) throws SQLException {
		return rs.getByte(pos);
	}

	public static final short get_short(ResultSet rs, Integer pos) throws SQLException {
		return rs.getShort(pos);
	}

	public static final int get_int(ResultSet rs, Integer pos) throws SQLException {
		return rs.getInt(pos);
	}

	public static final long get_long(ResultSet rs, Integer pos) throws SQLException {
		return rs.getLong(pos);
	}

	public static final float get_float(ResultSet rs, Integer pos) throws SQLException {
		return rs.getFloat(pos);
	}

	public static final double get_double(ResultSet rs, Integer pos) throws SQLException {
		return rs.getDouble(pos);
	}

	public static final Boolean get_Boolean(ResultSet rs, Integer pos) throws SQLException {
		boolean result = rs.getBoolean(pos);
		return rs.wasNull() ? null : result;
	}

	public static final Character get_Character(ResultSet rs, Integer pos) throws SQLException {
		String val = rs.getString(pos);
		if (val != null && val.length() > 0) {
			return val.charAt(0);
		}
		return null;
	}

	public static final Byte get_Byte(ResultSet rs, Integer pos) throws SQLException {
		byte result = rs.getByte(pos);
		return rs.wasNull() ? null : result;
	}

	public static final Short get_Short(ResultSet rs, Integer pos) throws SQLException {
		short result = rs.getShort(pos);
		return rs.wasNull() ? null : result;
	}

	public static final Integer get_Integer(ResultSet rs, Integer pos) throws SQLException {
		int result = rs.getInt(pos);
		return rs.wasNull() ? null : result;
	}

	public static final Long get_Long(ResultSet rs, Integer pos) throws SQLException {
		long result = rs.getLong(pos);
		return rs.wasNull() ? null : result;
	}

	public static final Float get_Float(ResultSet rs, Integer pos) throws SQLException {
		float result = rs.getFloat(pos);
		return rs.wasNull() ? null : result;
	}

	public static final Double get_Double(ResultSet rs, Integer pos) throws SQLException {
		double result = rs.getDouble(pos);
		return rs.wasNull() ? null : result;
	}

	public static final String get_String(ResultSet rs, Integer pos) throws SQLException {
		return rs.getString(pos);
	}

	public static final BigDecimal get_BigDecimal(ResultSet rs, Integer pos) throws SQLException {
		return rs.getBigDecimal(pos);
	}

	public static final BigInteger get_BigInteger(ResultSet rs, Integer pos) throws SQLException {
		BigDecimal val = rs.getBigDecimal(pos);
		return val == null ? null : val.toBigInteger();
	}

	public static final Date get_Date(ResultSet rs, Integer pos) throws SQLException {
		return rs.getDate(pos);
	}

	public static final Time get_Time(ResultSet rs, Integer pos) throws SQLException {
		return rs.getTime(pos);
	}

	public static final Timestamp get_Timestamp(ResultSet rs, Integer pos) throws SQLException {
		return rs.getTimestamp(pos);
	}

	public static final java.util.Date get_JavaUtilDate(ResultSet rs, Integer pos) throws SQLException {
		return rs.getTimestamp(pos);
	}

	public static final byte[] get_bytes(ResultSet rs, Integer pos) throws SQLException {
		return rs.getBytes(pos);
	}

	public static final InputStream get_InputStream(ResultSet rs, Integer pos) throws SQLException {
		return rs.getBinaryStream(pos);
	}

	public static final Reader get_Reader(ResultSet rs, Integer pos) throws SQLException {
		return rs.getCharacterStream(pos);
	}

	public static final Blob get_Blob(ResultSet rs, Integer pos) throws SQLException {
		return rs.getBlob(pos);
	}

	public static final Clob get_Clob(ResultSet rs, Integer pos) throws SQLException {
		return rs.getClob(pos);
	}

	public static final Ref get_Ref(ResultSet rs, Integer pos) throws SQLException {
		return rs.getRef(pos);
	}

	public static final URL get_URL(ResultSet rs, Integer pos) throws SQLException {
		return rs.getURL(pos);
	}

	public static final SQLXML get_SQLXML(ResultSet rs, Integer pos) throws SQLException {
		return rs.getSQLXML(pos);
	}

	@SuppressWarnings("unchecked")
	public static final  T get_Object(ResultSet rs, Integer pos, Class type) throws SQLException {
		JavaTypeMeta meta = JavaTypeMeta.get(type);
		if (meta != null) {
			return meta.get(rs, pos, type);
		}
		return (T) rs.getObject(pos);
	}

	// =============================================
	// 缓存属性: JdbcMetaCache
	// =============================================
	static final Map, JdbcMeta> TEMP_CACHE = new ConcurrentHashMap, JdbcMeta>();
	static final Map, JdbcMeta> PERM_CACHE = new HashMap, JdbcMeta>(JavaType.values().length + 8);
	static {
		// scalar jdbcAction
		PERM_CACHE.put(boolean.class, Boolean);
		PERM_CACHE.put(Boolean.class, Boolean);
		PERM_CACHE.put(char.class, Character);
		PERM_CACHE.put(Character.class, Character);
		PERM_CACHE.put(byte.class, Byte);
		PERM_CACHE.put(Byte.class, Byte);
		PERM_CACHE.put(short.class, Short);
		PERM_CACHE.put(Short.class, Short);
		PERM_CACHE.put(int.class, Integer);
		PERM_CACHE.put(Integer.class, Integer);
		PERM_CACHE.put(long.class, Long);
		PERM_CACHE.put(Long.class, Long);
		PERM_CACHE.put(float.class, Float);
		PERM_CACHE.put(Float.class, Float);
		PERM_CACHE.put(double.class, Double);
		PERM_CACHE.put(String.class, String);
		PERM_CACHE.put(Double.class, Double);
		PERM_CACHE.put(BigDecimal.class, BigDecimal);
		PERM_CACHE.put(BigInteger.class, BigInteger);
		PERM_CACHE.put(java.util.Date.class, JavaUtilDate);
		PERM_CACHE.put(Date.class, Date);
		PERM_CACHE.put(Time.class, Time);
		PERM_CACHE.put(Timestamp.class, Timestamp);
		PERM_CACHE.put(Ref.class, Ref);
		PERM_CACHE.put(URL.class, URL);
		PERM_CACHE.put(SQLXML.class, SQLXML);
		PERM_CACHE.put(Blob.class, Blob);
		PERM_CACHE.put(Clob.class, Clob);
		PERM_CACHE.put(InputStream.class, InputStream);
		PERM_CACHE.put(Reader.class, Reader);
		PERM_CACHE.put(byte[].class, Bytes);
	}

	@SuppressWarnings("rawtypes")
	public static JdbcMeta getByType(Class type) {
		// 根据概率排序各段代码
		// 查非空
		if (type == null) {
			return ARRAY;
		}
		// 具体类型,大概率
		JdbcMeta meta = PERM_CACHE.get(type);
		if (meta == null) {
			meta = TEMP_CACHE.get(type);
			if (meta == null) {

				// 通用类型, 小概率
				if (Map.class.isAssignableFrom(type)) {
					return MAP;
				} else if (List.class.isAssignableFrom(type)) {
					return LIST;
				} else if (type.isArray()) {
					return ARRAY;
				} else if (type.isEnum() || type.isInterface() || type.isAnnotation()) {
					throw new MessageException(MysqlErrno.SOURCE, MysqlErrno.JDBC_META_NOT_SUPPORTED, "JdbcMeta don't support enum, interface, or annoation:" + type.getCanonicalName());
				} /*
					 * else if (TEMP_CACHE.size() > TEMP_CACHE_MAX_SIZE) { throw new MessageException(MysqlErrno.SOURCE, MysqlErrno.JDBC_META_EXCEED_MAX_SIZE, "Temp cache size exceed ubound!"); }
					 */
				try {
					meta = AsmKit.newJdbcMeta(type.getCanonicalName());
					TEMP_CACHE.put(type, meta);
				} catch (Exception e) {
					throw new WrappedException(e);
				}

			}
		}
		return meta;
	}

	public static JdbcMeta getByObj(Object obj) {
		// 使用Class reflect的API会较慢
		if (obj == null) {
			return null;
		} else if (obj instanceof Object[]) {
			return ARRAY;
		} else if (obj instanceof Map) {
			return MAP;
		} else if (obj instanceof List) {
			return LIST;
		}
		return getByType(obj.getClass());
	}

	public static void set(Class type, JdbcMeta meta, boolean override) {
		synchronized (PERM_CACHE) {
			if (!override && PERM_CACHE.containsKey(type)) {
				throw new MessageException(MysqlErrno.SOURCE, MysqlErrno.SQL_CONFIG_DUPLICATE, "Duplicate jdbc meta for class: " + type);
			}
			PERM_CACHE.put(type, meta);
		}
	}
}