resultsetutil.java

来自「JDBC连数据库,这是一门很基初的技术,一定要好好研究」· Java 代码 · 共 27 行

package com.allanlxf.jdbc.util;

import java.sql.*;

public class ResultSetUtil
{
    public static void printResult(ResultSet rs) throws SQLException
    {
        ResultSetMetaData rsmd = rs.getMetaData();
        int columnCount = rsmd.getColumnCount();
        while(rs.next())
        {
            for(int i = 1; i <= columnCount; i++)
            {
                if(i != 1)
                {
                    System.out.print(",");
                }
                String name = rsmd.getColumnName(i);
                String value = rs.getString(i);
                System.out.print(name + "=" + value);
            }
            
            System.out.println();
        }
    }
}