+ tableName.trim() + "' AND "
+ "TABLE_SCHEMA = '" + dbCfg.getDb() + "'";
Statement smt = conn.createStatement();
ResultSet rs = smt.executeQuery(sql);
while(rs.next()){
FieldDm field = new FieldDm();
field.setName(rs.getString("COLUMN_NAME"));
field.setDataType(rs.getString("DATA_TYPE"));
field.setNn((rs.getString("IS_NULLABLE").equals("YES")? true: false));
field.setAi((rs.getString("EXTRA").equals("auto_increment")?true:false));
field.setNote(rs.getString("COLUMN_COMMENT"));
fields.add(field);
if(rs.getString("COLUMN_KEY").equals("PRI")){
pks.add(field);
}