Spring JDBCTemplet通用RowMapper帮助类

import java.lang.reflect.Method;
import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;

import org.springframework.jdbc.core.RowMapper;

public class SpringJdbcTempletHelper {

    public static <T> RowMapper<T> getRowMapper(Class<T> clazz) {
        if (clazz == null) {
            return null;
        }

        return new RowMapper<T>() {
            @Override
            public T mapRow(ResultSet rs, int rowNum) throws SQLException {
                try {

                    T bean = clazz.newInstance();

                    Method[] mds = clazz.getDeclaredMethods();
                    ResultSetMetaData metaData = rs.getMetaData();
                    for (int i = 1; i < metaData.getColumnCount(); i++) {
                        // resultSet数据下标从1开始
                        String columnName = metaData.getColumnName(i).replace("f_", "").replace("tb_", "")
                                .replace("_", "").toLowerCase();

                        Object val = null;
                        for (Method method : mds) {
                            String methodName = method.getName().replace("_", "").toLowerCase();
                            if (methodName.startsWith("set") && methodName.substring(3).equals(columnName)) {
                                Class<?> type = method.getParameterTypes()[0];
                                if (type == Integer.class) {
                                    val = rs.getInt(i);
                                } else if (type == Long.class || type == BigInteger.class) {
                                    val = rs.getLong(i);
                                } else if (type == BigDecimal.class) {
                                    val = rs.getBigDecimal(i);
                                } else if (type == Double.class) {
                                    val = rs.getDouble(i);
                                } else if (type == Float.class) {
                                    val = rs.getFloat(i);
                                } else if (type == Boolean.class) {
                                    val = rs.getBoolean(i);
                                } else if (type == Byte.class) {
                                    val = rs.getByte(i);
                                } else if (type == Short.class) {
                                    val = rs.getShort(i);
                                } else if (type == String.class) {
                                    val = rs.getString(i);
                                } else if (type == Date.class) {
                                    val = rs.getTimestamp(i);
                                } else {
                                    val = rs.getShort(i);
                                }
                                if (val == null) {
                                    break;
                                } else {
                                    method.invoke(bean, val);
                                }
                            }
                        }
                    }
                    return bean;
                } catch (Exception e) {
                    e.printStackTrace();
                }
                return null;
            }
        };
    }

    public static <T> List<T> converMapListToBeanList(List<Map<String, Object>> dataList, Class<T> clazz) {
        List<T> lst = new ArrayList<>();

        if (dataList == null || dataList.size() < 1 || clazz == null) {
            return lst;
        }

        try {
            // 获取实体bean所有声明的方法
            Method[] mds = clazz.getDeclaredMethods();

            for (Map<String, Object> data : dataList) {

                // 迭代遍历map
                Iterator<Entry<String, Object>> iterator = data.entrySet().iterator();
                T obj = clazz.newInstance();

                // 根据map的键去找以set开头包含map的键的set方法，过程中下划线不影响查找方法，大小写不影响查找
                while (iterator.hasNext()) {
                    Map.Entry<java.lang.String, java.lang.Object> entry = (Map.Entry<java.lang.String, java.lang.Object>) iterator
                            .next();
                    String key = entry.getKey();
                    Object val = entry.getValue();

                    if (key == null || val == null) {
                        continue;
                    }

                    Method method = findSetMethod(key, mds);
                    if (method == null) {
                        continue;
                    }
                    // 反射调用字段的set方法

                    Class<?> t = method.getParameterTypes()[0];
                    if (t == val.getClass()) {
                        method.invoke(obj, val);
                    } else if (Number.class.isAssignableFrom(t)) {
                        if (t == Integer.class) {
                            val = Integer.valueOf(val.toString());
                        } else if (t == Long.class) {
                            val = Long.valueOf(val.toString());
                        } else if (t == Double.class) {
                            val = Double.valueOf(val.toString());
                        } else if (t == Float.class) {
                            val = Float.valueOf(val.toString());
                        } else {
                            val = Integer.valueOf(val.toString());
                            val = t.cast(val);
                        }
                    } else if (Date.class.isAssignableFrom(t)) {
                        SimpleDateFormat[] sdf = new SimpleDateFormat[] { new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"),
                                new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS"),
                                new SimpleDateFormat("yyyy/MM/dd HH:mm:ss.SSS"), new SimpleDateFormat("yyyy-MM-dd"),
                                new SimpleDateFormat("yyyy/MM/dd"), new SimpleDateFormat("HH:mm:ss"),
                                new SimpleDateFormat("HH:mm:ss.SSS"), };
                        for (SimpleDateFormat simpleDateFormat : sdf) {
                            try {
                                val = simpleDateFormat.format(val.toString());
                            } catch (Exception e) {
                                continue;
                            }
                        }
                    } else if (Boolean.class.isAssignableFrom(t)) {
                        if (val.toString().equals("0") || val.toString().equalsIgnoreCase("false")) {
                            val = false;
                        } else {
                            val = true;
                        }
                    }
                }
                lst.add(obj);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return lst;
    }

    private static Method findSetMethod(String key, Method[] methods) {

        String methodName = "";
        String tmpKey = "";

        for (Method method : methods) {
            methodName = method.getName().replace("_", "").toLowerCase().substring(3);
            tmpKey = key.toLowerCase().replace("_", "");

            if (methodName.startsWith("set") && tmpKey.indexOf(methodName) > -1) {
                return method;
            }
        }
        return null;
    }
}