结果集的通用模式-对表的字段名和相应值的封装

结果集的通用方式--对表的字段名和相应值的封装

	public OrderedMap findById(String mainIdField,String id) {
		PreparedStatement ps = null;
		ResultSet rs = null;
		OrderedMap row = null;
		String sql = "select * from "+tableName + " where "+mainIdField+"='"+id+"'";
		try {
			if (debug)
				log.debug(sql);
			ps = connection.prepareStatement(sql);
			rs = ps.executeQuery();
			ResultSetMetaData rsmd = rs.getMetaData();
			int columnCount = rsmd.getColumnCount();

			if (rs.next()) {
				row = new LinkedMap();
				for (int i = 1; i <= columnCount; i++) {
					String columnName = rsmd.getColumnName(i).toUpperCase();
					row.put(columnName, rs.getObject(i));
				}
			}

		} catch (Exception e) {
			throw new RuntimeException(e);
		} finally {
			try {
				if (rs != null)
					rs.close();
				if (ps != null)
					ps.close();
			} catch (SQLException e1) {
				throw new RuntimeException(e1);
			}
		}
		return row;
	}