import java.text.MessageFormat;
-import net.sourceforge.phpdt.sql.PHPEclipseSQLPlugin;
-import net.sourceforge.phpdt.sql.sql.TableRow;
-import net.sourceforge.phpdt.sql.view.PHPSourceConsole;
-import net.sourceforge.phpdt.sql.view.tableview.TableAdapter;
-
import org.eclipse.jface.preference.IPreferenceStore;
import org.eclipse.jface.wizard.WizardPage;
import org.eclipse.swt.SWT;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.widgets.Text;
+import net.sourceforge.phpdt.sql.PHPEclipseSQLPlugin;
+import net.sourceforge.phpdt.sql.sql.TableRow;
+import net.sourceforge.phpdt.sql.view.PHPSourceConsole;
+import net.sourceforge.phpdt.sql.view.tableview.TableAdapter;
+
public class PHPInsertRowPage extends WizardPage implements SQLPage {
TableRow row;
String[] columnNames;
Text[] values;
Label query;
private IPreferenceStore fStore;
-
+
public PHPInsertRowPage(String pageName) {
super(pageName);
}
System.out.println("Data is null");
}
}
+
columnNames = row.getColumnNames();
String[] data = row.getTableData();
if (DEBUG) {
boolean first = false;
for (int i = 0; i < columnNames.length; i++) {
text = values[i].getText();
- if (! text.equals("")) {
+ if (!text.equals("")) {
if (first) {
valuesClause.append(", ");
fieldClause.append(", ");
}
- valuesClause.append("'"+values[i].getText()+"'");
+ valuesClause.append("'" + values[i].getText() + "'");
fieldClause.append(columnNames[i]);
first = true;
}
}
-// if (valuesClause.length() > 1) {
-// valuesClause.deleteCharAt(valuesClause.length() - 1);
-// valuesClause.deleteCharAt(valuesClause.length() - 1);
-// }
- String[] arguments = { row.getTable(), fieldClause.toString(), valuesClause.toString() };
+ // if (valuesClause.length() > 1) {
+ // valuesClause.deleteCharAt(valuesClause.length() - 1);
+ // valuesClause.deleteCharAt(valuesClause.length() - 1);
+ // }
+ String[] arguments = { row.getTable(), fieldClause.toString(), valuesClause.toString()};
MessageFormat form = new MessageFormat(fStore.getString("phpeclipse.sql.insert.template"));
String query = form.format(arguments);
-// String query = "$results = mysql_query(\"INSERT INTO " + row.getTable() + " (";
-// query += fieldClause.toString() + ") ";
-// query += " VALUES (" + valuesClause.toString();
-// query += ")\");";
+ // String query = "$results = mysql_query(\"INSERT INTO " + row.getTable() + " (";
+ // query += fieldClause.toString() + ") ";
+ // query += " VALUES (" + valuesClause.toString();
+ // query += ")\");";
this.query.setText(query);
}
public boolean performFinish() {