Package com.zfabrik.util.jdbc

Class TableAccessor

java.lang.Object

com.zfabrik.util.jdbc.TableAccessor

public class TableAccessor
extends Object

Constructor Summary

Constructors

Constructor	Description
TableAccessor(Connection conn, String tableName)
TableAccessor(DataSource ds, String tableName)

Method Summary

Modifier and Type	Method	Description
int	delete(String where, Object... whereParams)
String	dumpTable()
int	insert(Object bean)
int	insert(Map<String,Object> data)
void	resetConnection()
int	rowsCount()
List<Map<String,Object>>	select(String[] fields)
List<Map<String,Object>>	select(String[] fields, String where, Object... whereParams)
int	update(Object bean, String where, Object... whereParams)
int	update(Map<String,Object> data, String where, Object... whereParams)

Methods inherited from class java.lang.Object

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

Constructor Details

TableAccessor

public TableAccessor(DataSource ds,
 String tableName)

TableAccessor

public TableAccessor(Connection conn,
 String tableName)

Method Details

insert

public int insert(Object bean)

insert

public int insert(Map<String,Object> data)

update

public int update(Object bean,
 String where,
 Object... whereParams)

update

public int update(Map<String,Object> data,
 String where,
 Object... whereParams)

delete

public int delete(String where,
 Object... whereParams)

select

public List<Map<String,Object>> select(String[] fields,
 String where,
 Object... whereParams)

select

public List<Map<String,Object>> select(String[] fields)

rowsCount

public int rowsCount()

resetConnection

public void resetConnection()

dumpTable

public String dumpTable()