All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • org.yx.db.visit.ResultSetUtils Maven / Gradle / Ivy

    There is a newer version: 4.0.2
    Show newest version
    /**
 * Copyright (C) 2016 - 2030 youtongluan.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * 		http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.yx.db.visit;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Objects;

import org.yx.db.sql.ColumnMeta;
import org.yx.db.sql.PojoMeta;
import org.yx.util.Asserts;

public class ResultSetUtils {
	public static List> toMapList(ResultSet rs) throws java.sql.SQLException {
		List> list = new ArrayList<>(10);
		if (rs == null) {
			return list;
		}
		ResultSetMetaData md = rs.getMetaData();
		int columnCount = md.getColumnCount();
		Map rowData;
		while (rs.next()) {
			rowData = new HashMap<>();
			for (int i = 1; i <= columnCount; i++) {
				rowData.put(md.getColumnName(i), rs.getObject(i));
			}
			list.add(rowData);
		}
		return list;
	}

	public static List> toMapList(ResultSet rs, PojoMeta pm) throws java.sql.SQLException {
		List> list = new ArrayList<>(10);
		if (rs == null) {
			return list;
		}
		ResultSetMetaData md = rs.getMetaData();
		int columnCount = md.getColumnCount();
		Map rowData;
		while (rs.next()) {
			rowData = new HashMap<>(columnCount * 2);
			for (int i = 1; i <= columnCount; i++) {
				ColumnMeta cm = pm.getByColumnDBName(md.getColumnName(i));
				Objects.requireNonNull(cm, md.getColumnName(i) + " has no mapper");
				rowData.put(cm.getFieldName(), rs.getObject(i));
			}
			list.add(rowData);
		}
		rs.close();
		return list;
	}

	public static List toList(ResultSet rs) throws java.sql.SQLException {
		List list = new ArrayList<>(10);
		if (rs == null) {
			return list;
		}
		ResultSetMetaData md = rs.getMetaData();
		Asserts.isTrue(md.getColumnCount() == 1, "result data column is " + md.getColumnCount() + ", not 1");
		while (rs.next()) {
			list.add(rs.getObject(1));
		}
		rs.close();
		return list;
	}

	public static List toObjectArrayList(ResultSet rs) throws java.sql.SQLException {
		List list = new ArrayList<>(10);
		if (rs == null) {
			return list;
		}
		ResultSetMetaData md = rs.getMetaData();
		final int len = md.getColumnCount();
		Object[] data;
		while (rs.next()) {
			data = new Object[len];
			for (int i = 0; i < len; i++) {
				data[i] = rs.getObject(i + 1);
			}
			list.add(data);
		}
		rs.close();
		return list;
	}
}
    
    
    
    

    




    
    
    © 2015 - 2024 Weber Informatics LLC | Privacy Policy