@Override
public void run() {
StringBuffer sbSQL = new StringBuffer();
try {
TableDAO tableDAO = (TableDAO) sel.getFirstElement();
Map<String, String> parameter = new HashMap<String, String>();
parameter.put("db", userDB.getDb());
parameter.put("table", tableDAO.getName());
SqlMapClient sqlClient = TadpoleSQLManager.getInstance(userDB);
List<TableColumnDAO> showTableColumns =
sqlClient.queryForList("tableColumnList", parameter); // $NON-NLS-1$
sbSQL.append(" DELETE FROM " + tableDAO.getName() + " "); // $NON-NLS-1$ //$NON-NLS-2$
sbSQL.append("\r\n WHERE \r\n "); // $NON-NLS-1$
int cnt = 0;
for (int i = 0; i < showTableColumns.size(); i++) {
TableColumnDAO dao = showTableColumns.get(i);
if (Define.isKEY(dao.getKey())) {
if (cnt == 0)
sbSQL.append("\t" + dao.getField() + " = ? \r\n"); // $NON-NLS-1$ //$NON-NLS-2$
else sbSQL.append("\tAND " + dao.getField() + " = ?"); // $NON-NLS-1$ //$NON-NLS-2$
cnt++;
}
}
sbSQL.append(Define.SQL_DILIMITER); // $NON-NLS-1$
//
// QueryEditorAction qea = new QueryEditorAction();
FindEditorAndWriteQueryUtil.run(userDB, sbSQL.toString());
} catch (Exception e) {
logger.error(Messages.GenerateSQLDeleteAction_10, e);
Status errStatus =
new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); // $NON-NLS-1$
ExceptionDetailsErrorDialog.openError(
null, "Error", Messages.GenerateSQLDeleteAction_0, errStatus); // $NON-NLS-1$
}
}
