try {
stmt = conn.createStatement();
stmt.execute("use " + database);
ResultSet rs = stmt.executeQuery("desc " + table);
while (rs.next()) {
TableSchemaBo tsb = new TableSchemaBo();
tsb.setFieldName(rs.getString(1));
tsb.setFieldType(rs.getString(2));
tsb.setFieldComment(rs.getString(3));
if (logger.isDebugEnabled()) {
logger.debug("getTableSchema " + tsb);
}
tsbs.add(tsb);