X-Git-Url: http://secure.phpeclipse.com diff --git a/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/wizards/PHPInsertRowPage.java b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/wizards/PHPInsertRowPage.java index 74aac22..0e31aa6 100644 --- a/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/wizards/PHPInsertRowPage.java +++ b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/wizards/PHPInsertRowPage.java @@ -2,11 +2,6 @@ package net.sourceforge.phpdt.sql.wizards; 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; @@ -18,13 +13,18 @@ import org.eclipse.swt.widgets.Composite; 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); } @@ -55,6 +55,7 @@ public class PHPInsertRowPage extends WizardPage implements SQLPage { System.out.println("Data is null"); } } + columnNames = row.getColumnNames(); String[] data = row.getTableData(); if (DEBUG) { @@ -108,29 +109,29 @@ public class PHPInsertRowPage extends WizardPage implements SQLPage { 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() {