ResultSet转java对象的通用解决方案

最新推荐文章于 2023-08-16 14:51:20 发布

iwesley

最新推荐文章于 2023-08-16 14:51:20 发布

阅读量1k

点赞数

分类专栏： java技术文章标签： java object cache string setter exception

本文链接：https://blog.csdn.net/iwesley/article/details/6654799

版权

java技术专栏收录该内容

1 篇文章 0 订阅

订阅专栏

根据resultSet,以及给定对象的Class对象进行填充，Class需要遵循JavaBean规范。

        private Collection mergeObject(ResultSet rs, Class clazz) throws Exception {
		ResultSetMetaData rmd = (ResultSetMetaData) rs.getMetaData();
		Collection coll = new ArrayList();
		;
		while (rs.next()) {
			Object obj = clazz.newInstance();
			for (int i = 1; i <= rmd.getColumnCount(); i++) {
				beanRegister(obj, rmd.getColumnName(i), rs.getString(i));//根据列名和对应值对对象属性进行赋值
			}
			coll.add(obj);
		}
		return coll;
	}

根据get方法的返回值类型，判断当前属性的类型，调用method.invoke(Object,param);

private void beanRegister(Object object, String beanProperty, String value) {
		Object[] beanObject = beanMatch(object.getClass(), beanProperty);
		Object[] cache = new Object[1];
		Method getter = (Method) beanObject[0];
		Method setter = (Method) beanObject[1];
		try {
			// 通过get获得方法类型
			String methodType = getter.getReturnType().getName();
			if ((methodType.equalsIgnoreCase("long") || methodType.equalsIgnoreCase("java.lang.Long"))
					&& !"".equals(value) && value != null) {
				cache[0] = new Long(value);
				setter.invoke(object, cache);
			} else if ((methodType.equalsIgnoreCase("int") || methodType.equalsIgnoreCase("java.lang.Integer"))
					&& !"".equals(value) && value != null) {
				cache[0] = new Integer(value);
				setter.invoke(object, cache);
			} else if ((methodType.equalsIgnoreCase("short") || methodType.equalsIgnoreCase("java.lang.Short"))
					&& !"".equals(value) && value != null) {
				cache[0] = new Short(value);
				setter.invoke(object, cache);
			} else if ((methodType.equalsIgnoreCase("float") || methodType.equalsIgnoreCase("java.lang.Float"))
					&& !"".equals(value) && value != null) {
				cache[0] = new Float(value);
				setter.invoke(object, cache);
			} else if ((methodType.equalsIgnoreCase("double") || methodType.equalsIgnoreCase("java.lang.Double"))
					&& !"".equals(value) && value != null) {
				cache[0] = new Double(value);
				setter.invoke(object, cache);
			} else if ((methodType.equalsIgnoreCase("boolean") || methodType.equalsIgnoreCase("java.lang.Boolean"))
					&& !"".equals(value) && value != null) {
				cache[0] = new Boolean(value);
				setter.invoke(object, cache);
			} else if ((methodType.equalsIgnoreCase("java.lang.String")) && !"".equals(value) && value != null) {
				cache[0] = value;
				setter.invoke(object, cache);
			} else if (methodType.equalsIgnoreCase("java.io.InputStream")) {
			} else if (methodType.equalsIgnoreCase("char")) {
				cache[0] = (Character.valueOf(value.charAt(0)));
				setter.invoke(object, cache);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

private Object[] beanMatch(Class clazz, String beanProperty) {
		Object[] result = new Object[2];
		char beanPropertyChars[] = beanProperty.toCharArray();
		beanPropertyChars[0] = Character.toUpperCase(beanPropertyChars[0]);
		String s = new String(beanPropertyChars);
		String names[] = { ("set" + s).intern(), ("get" + s).intern(), ("is" + s).intern(), ("write" + s).intern(),
				("read" + s).intern() };
		Method getter = null;
		Method setter = null;
		Method methods[] = clazz.getMethods();
		for (int i = 0; i < methods.length; i++) {
			Method method = methods[i];
			if (!Modifier.isPublic(method.getModifiers()))
				continue;
			String methodName = method.getName().intern();
			for (int j = 0; j < names.length; j++) {
				String name = names[j];
				if (!name.equals(methodName))
					continue;
				if (methodName.startsWith("set") || methodName.startsWith("read"))
					setter = method;
				else
					getter = method;
			}
		}
		result[0] = getter;
		result[1] = setter;
		return result;
	}