动态Ibatis中parameterClass参数

 在项目中采用Ibatis作为访问持久层框架时，有时我们又需要启用JDBC连接来完成某种意义上的操作，而把Ibatis的开发模式更改了又不是我们的初衷，因此我们只能在已经用sqlMap.xml配置好的基础上进行参数封装。

具体参数方法如下：

/** *  预编译封装对象 * @param sqlmap * @param ps * @param sqlId * @param params * @return 绘制PreparedStatement */public static PreparedStatement getSqlParameterMap(SqlMapClientImpl sqlmap,PreparedStatement ps,String sqlId,Object params) {/**获取ibatis参数*/ParameterMapping[]paramMappSet = getParameterMapp( sqlmap, sqlId);/**反射来装配参数*/try {int index=0;for(ParameterMapping paramMapp : paramMappSet){index++;String methodName = "get"+toFirstLetterUpperCase(paramMapp.getPropertyName());Method method = params.getClass().getDeclaredMethod(methodName);Object obj = null; obj = method.invoke(params, null);putPreparedStatement(ps,index,obj ,method.getGenericReturnType());}} catch (Exception e) {new Result(Const.RS_ERROR,"","反射装配ibatais参数异常，系统错误！",(Params)params,e,log);} return ps;}/** * 获取ibatis预编译参数 * */private static ParameterMapping[] getParameterMapp(SqlMapClientImpl sqlmap,String sqlId){/**获取sqlMap.xml映射*/MappedStatement stmt = sqlmap.getMappedStatement(sqlId);/**获取指定ID的parameterClass参数*/ParameterMapping[] paramMappSet = stmt.getParameterMap().getParameterMappings();return paramMappSet;}private static void putPreparedStatement(PreparedStatement ps,int index,Object obj ,Object type) throws SQLException{/*String*/if(obj instanceof String){ps.setString(index, obj.toString());}/*Integer*/if(obj instanceof Integer){ps.setInt(index, Integer.valueOf(obj.toString()));}/*Long*/if(obj instanceof Long){ps.setLong(index, Long.valueOf(obj.toString()));}/*Double*/if(obj instanceof Double){ps.setDouble(index, Double.valueOf(obj.toString()));}/*Date*/if(obj instanceof Date){}if(obj instanceof BigDecimal){ps.setBigDecimal(index, BigDecimal.valueOf(Long.valueOf(obj.toString())));}}//**  * 将手字母大写**/public static String toFirstLetterUpperCase(String strName) {if (strName == null || strName.length() < 2) {return strName;}String firstLetter = strName.substring(0, 1).toUpperCase();return firstLetter + strName.substring(1, strName.length());}