com.jeesuite.common.util

类 JDBCUtils

java.lang.Object

com.jeesuite.common.util.JDBCUtils

public class JDBCUtils
extends Object

字段概要

字段

限定符和类型	字段和说明
static String	driverClass
static String	password
static String	url
static String	userName

方法概要

限定符和类型	方法和说明
static void	close(ResultSet rs) Close connection
static void	close(ResultSet rs, Statement st, Connection con) Close connection
static void	close(Statement st, Connection con) Close connection
static Connection	getconnnection() Get connection
static ResultSet	query(String sql, Object... args) 已过时。
static <T> List<T>	queryForList(String sql, Class<T> clz, Object... args) Query a single record
static List<Map<String,Object>>	queryForList(String sql, Object... args) Query a single record
static Map<String,Object>	queryForMap(String sql, Object... args) Query a single record
static <T> T	queryForObject(String sql, Class<T> clz, Object... args) Query a single record
static int	update(String sql, Object... args) insert/update/delete

从类继承的方法 java.lang.Object

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

字段详细资料

driverClass

public static String driverClass

url

public static String url

userName

public static String userName

password

public static String password

方法详细资料

getconnnection

public static Connection getconnnection()

Get connection

返回:

close

public static void close(ResultSet rs,
                         Statement st,
                         Connection con)

Close connection

参数:

rs -

st -

con -

close

public static void close(ResultSet rs)

Close connection

参数:

rs -

close

public static void close(Statement st,
                         Connection con)

Close connection

参数:

st -

con -

update

public static int update(String sql,
                         Object... args)

insert/update/delete

参数:

sql -

args -

返回:

query

@Deprecated
public static ResultSet query(String sql,
                                          Object... args)

已过时。

query, because need to manually close the resource, so not recommended for use it

参数:

sql -

args -

返回:

ResultSet

queryForMap

public static Map<String,Object> queryForMap(String sql,
                                             Object... args)

Query a single record

参数:

sql -

args -

返回:

Map

queryForObject

public static <T> T queryForObject(String sql,
                                   Class<T> clz,
                                   Object... args)

Query a single record

参数:

sql -

args -

返回:

queryForList

public static List<Map<String,Object>> queryForList(String sql,
                                                    Object... args)

Query a single record

参数:

sql -

args -

返回:

List>

queryForList

public static <T> List<T> queryForList(String sql,
                                       Class<T> clz,
                                       Object... args)

Query a single record

参数:

sql -

args -

返回:

List