sf.database.jdbc.result

Class ResultSets

java.lang.Object

sf.database.jdbc.result.ResultSets

public class ResultSets
extends Object

Method Summary

Modifier and Type	Method and Description
static void	showResult(ResultSet rs, int limit) 显示sql的resultset
static void	showResult(ResultSet rs, int limit, boolean closeIt) 以文本显示SQL结果
static List<Map<String,Object>>	toMap(ResultSet rs)
static List<Object>	toObject(ResultSet rs, int column)
static List<Object>	toObjectList(ResultSet wrapper, int column, int maxReturn)
static List<String>	toStringList(ResultSet rs, String column, int maxReturn) 获取指定列的String数据，整体返回一个List

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

showResult

public static void showResult(ResultSet rs,
                              int limit)

显示sql的resultset

Parameters:

rs - 结果集

limit - 限制

showResult

public static void showResult(ResultSet rs,
                              int limit,
                              boolean closeIt)

以文本显示SQL结果

Parameters:

rs - 结果集

limit - 限制

closeIt - 是否关闭

toMap

public static List<Map<String,Object>> toMap(ResultSet rs)
                                      throws SQLException

Throws:

SQLException

toObject

public static List<Object> toObject(ResultSet rs,
                                    int column)
                             throws SQLException

Throws:

SQLException

toObjectList

public static List<Object> toObjectList(ResultSet wrapper,
                                        int column,
                                        int maxReturn)
                                 throws SQLException

Throws:

SQLException

toStringList

public static List<String> toStringList(ResultSet rs,
                                        String column,
                                        int maxReturn)
                                 throws SQLException

获取指定列的String数据，整体返回一个List

Parameters:

rs -

column -

maxReturn -

Returns:

List 返回类型

Throws:

SQLException