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