public class Table
extends Object
| Constructor and Description |
|---|
Table(String tableName) |
Table(String tableName,
Object[][] columns) |
| Modifier and Type | Method and Description |
|---|---|
void |
appendColumn(StringBuilder sb,
Object value,
boolean last) |
void |
appendColumn(StringBuilder sb,
ResultSet rs,
String name,
Integer type,
boolean last) |
void |
generateTempFile() |
void |
generateTempFile(Connection con) |
Object[][] |
getColumns() |
String |
getCreateSQL() |
String |
getDeleteSQL() |
String |
getExportedData(ResultSet rs) |
String |
getInsertSQL() |
String |
getInsertTableName() |
int[] |
getOrder() |
PreparedStatement |
getSelectPreparedStatement(Connection con) |
String |
getSelectSQL() |
String |
getTableName() |
String |
getTempFileName() |
long |
getTotalRows() |
Object |
getValue(ResultSet rs,
String name,
Integer type) |
void |
populateTable() |
void |
populateTable(Connection con) |
void |
populateTableRows(PreparedStatement ps,
boolean batch) |
void |
setColumn(PreparedStatement ps,
int index,
Integer type,
String value) |
void |
setColumns(Object[][] columns) |
void |
setCreateSQL(String createSQL) |
void |
setSelectSQL(String selectSQL) |
void |
updateColumnValue(String columnName,
String oldValue,
String newValue) |
public Table(String tableName)
public Table(String tableName,
Object[][] columns)
public void appendColumn(StringBuilder sb,
Object value,
boolean last)
throws Exception
Exceptionpublic void appendColumn(StringBuilder sb,
ResultSet rs,
String name,
Integer type,
boolean last)
throws Exception
Exceptionpublic void generateTempFile()
throws Exception
Exceptionpublic void generateTempFile(Connection con)
throws Exception
Exceptionpublic Object[][] getColumns()
public String getCreateSQL()
throws Exception
Exceptionpublic String getDeleteSQL()
throws Exception
Exceptionpublic String getExportedData(ResultSet rs)
throws Exception
Exceptionpublic String getInsertSQL()
throws Exception
Exceptionpublic String getInsertTableName()
throws Exception
Exceptionpublic int[] getOrder()
public PreparedStatement getSelectPreparedStatement(Connection con)
throws Exception
Exceptionpublic String getSelectSQL()
throws Exception
Exceptionpublic String getTableName()
public String getTempFileName()
public long getTotalRows()
public Object getValue(ResultSet rs,
String name,
Integer type)
throws Exception
Exceptionpublic void populateTable()
throws Exception
Exceptionpublic void populateTable(Connection con)
throws Exception
Exceptionpublic void populateTableRows(PreparedStatement ps,
boolean batch)
throws Exception
Exceptionpublic void setColumn(PreparedStatement ps,
int index,
Integer type,
String value)
throws Exception
Exceptionpublic void setColumns(Object[][] columns)
public void setCreateSQL(String createSQL)
throws Exception
Exceptionpublic void setSelectSQL(String selectSQL)
throws Exception
Exceptionpublic void updateColumnValue(String columnName,
String oldValue,
String newValue)