X-Git-Url: http://secure.phpeclipse.com diff --git a/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/PHPEclipseSQLPlugin.java b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/PHPEclipseSQLPlugin.java index 7d3cbec..5926e37 100644 --- a/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/PHPEclipseSQLPlugin.java +++ b/archive/net.sourceforge.phpeclipse.sql/src/net/sourceforge/phpdt/sql/PHPEclipseSQLPlugin.java @@ -41,280 +41,232 @@ import net.sourceforge.phpdt.sql.view.bookmark.SubsetContentProvider; /** * @author */ -public class PHPEclipseSQLPlugin -extends AbstractUIPlugin -implements IConstants { +public class PHPEclipseSQLPlugin extends AbstractUIPlugin implements IConstants { - private static PHPEclipseSQLPlugin plugin; - public final static String PLUGIN_ID = "net.sourceforge.phpeclipse.sql"; + private static PHPEclipseSQLPlugin plugin; + public final static String PLUGIN_ID = "net.sourceforge.phpeclipse.sql"; - public PHPEclipseSQLPlugin(IPluginDescriptor descriptor) { - super(descriptor); - plugin = this; - } + public PHPEclipseSQLPlugin(IPluginDescriptor descriptor) { + super(descriptor); + plugin = this; + } - public static PHPEclipseSQLPlugin getDefault() { - return plugin; - } - /** - * Reads the PHPEclipseSQL Plugin state from a file. The file has been created with writeImportantState - * @param target - */ - protected void readStateFrom(File target) { - String fileName = target.getName(); - if (!fileName.endsWith("ext")) { //$NON-NLS-1$ - // It's the 2.0 format for preferences - BookmarkContentProvider.getInstance().load(target); - } else { - //It's the 2.1 format for preferences and subsets - XmlDocument doc = new XmlDocument(); - FileInputStream source = null; - try { - source = new FileInputStream(target); - } catch (FileNotFoundException e1) { - e1.printStackTrace(); - return; - } - DocumentBuilderFactory factory = - DocumentBuilderFactory.newInstance(); - DocumentBuilder parser; - try { - parser = factory.newDocumentBuilder(); - doc = (XmlDocument) parser.parse(source); - } catch (ParserConfigurationException e) { - e.printStackTrace(); - return; - } catch (SAXException e) { - e.printStackTrace(); - return; - } catch (IOException e) { - e.printStackTrace(); - return; - } - Element root = doc.getDocumentElement(); - BookmarkContentProvider.getInstance().importXML(root); - SubsetContentProvider.getInstance().importXML(root); - } - } + public static PHPEclipseSQLPlugin getDefault() { + return plugin; + } + /** + * Reads the PHPEclipseSQL Plugin state from a file. The file has been created with writeImportantState + * @param target + */ + protected void readStateFrom(File target) { + String fileName = target.getName(); + // if (!fileName.endsWith("ext")) { //$NON-NLS-1$ + // // It's the 2.0 format for preferences + // BookmarkContentProvider.getInstance().load(target); + // } else { + //It's the 2.1 format for preferences and subsets + XmlDocument doc = new XmlDocument(); + FileInputStream source = null; + try { + source = new FileInputStream(target); + } catch (FileNotFoundException e1) { + e1.printStackTrace(); + return; + } + DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance(); + DocumentBuilder parser; + try { + parser = factory.newDocumentBuilder(); + doc = (XmlDocument) parser.parse(source); + } catch (ParserConfigurationException e) { + e.printStackTrace(); + return; + } catch (SAXException e) { + e.printStackTrace(); + return; + } catch (IOException e) { + e.printStackTrace(); + return; + } + Element root = doc.getDocumentElement(); + BookmarkContentProvider.getInstance().importXML(root); + SubsetContentProvider.getInstance().importXML(root); + // } + } - public void startup() throws CoreException { - super.startup(); - ISaveParticipant saveParticipant = new PHPSQLSaveParticipant(); - ISavedState lastState = - ResourcesPlugin.getWorkspace().addSaveParticipant( - this, - saveParticipant); - if (lastState == null) - return; - IPath location = lastState.lookup(new Path("save")); - if (location == null) - return; - // the plugin instance should read any important state from the file. - File f = getStateLocation().append(location).toFile(); - readStateFrom(f); - } + public void startup() throws CoreException { + super.startup(); + ISaveParticipant saveParticipant = new PHPSQLSaveParticipant(); + ISavedState lastState = ResourcesPlugin.getWorkspace().addSaveParticipant(this, saveParticipant); + if (lastState == null) + return; + IPath location = lastState.lookup(new Path("save")); + if (location == null) + return; + // the plugin instance should read any important state from the file. + File f = getStateLocation().append(location).toFile(); + readStateFrom(f); + } - protected void writeImportantState(File target) { - XmlDocument doc = new XmlDocument(); - FileOutputStream out = null; - try { - out = new FileOutputStream(target); - } catch (FileNotFoundException e1) { - e1.printStackTrace(); - return; - } - Element root = (Element) doc.appendChild(doc.createElement(Messages.getString("ExportXMLAction.SavedData"))); //$NON-NLS-1$ + protected void writeImportantState(File target) { + XmlDocument doc = new XmlDocument(); + FileOutputStream out = null; + try { + out = new FileOutputStream(target); + } catch (FileNotFoundException e1) { + e1.printStackTrace(); + return; + } + Element root = (Element) doc.appendChild(doc.createElement(Messages.getString("ExportXMLAction.SavedData"))); //$NON-NLS-1$ - BookmarkContentProvider.getInstance().exportXML(root); - SubsetContentProvider.getInstance().exportXML(root); + BookmarkContentProvider.getInstance().exportXML(root); + SubsetContentProvider.getInstance().exportXML(root); - try { - doc.write(out); - out.close(); - } catch (IOException e) { - e.printStackTrace(); - } + try { + doc.write(out); + out.close(); + } catch (IOException e) { + e.printStackTrace(); + } - } + } - /** - * Gets an image descriptof from a file in the icons directory - * @param name of the file to get - * @return ImageDescriptor or null if not found - */ - public static ImageDescriptor getImageDescriptor(String name) { - ImageDescriptor descriptor = null; - try { - URL installURL = - PHPEclipseSQLPlugin - .getDefault() - .getDescriptor() - .getInstallURL(); - URL url = new URL(installURL, "icons/" + name); - descriptor = ImageDescriptor.createFromURL(url); - } catch (Exception e) { - e.printStackTrace(); - } - return descriptor; - } - public static Image getImage(String name) { - return getImageDescriptor(name).createImage(); - } + /** + * Gets an image descriptof from a file in the icons directory + * @param name of the file to get + * @return ImageDescriptor or null if not found + */ + public static ImageDescriptor getImageDescriptor(String name) { + ImageDescriptor descriptor = null; + try { + URL installURL = PHPEclipseSQLPlugin.getDefault().getDescriptor().getInstallURL(); + URL url = new URL(installURL, "icons/" + name); + descriptor = ImageDescriptor.createFromURL(url); + } catch (Exception e) { + e.printStackTrace(); + } + return descriptor; + } + public static Image getImage(String name) { + return getImageDescriptor(name).createImage(); + } - public void dispose() throws CoreException { - } + public void dispose() throws CoreException { + } - protected void initializeDefaultPluginPreferences() { - RGB BACKGROUND = new RGB(255, 255, 255); - RGB COMMENT = new RGB(88, 148, 64); - RGB KEYWORD = new RGB(126, 0, 75); - RGB STRING = new RGB(0, 0, 255); - RGB NUMERIC = new RGB(255, 0, 0); - RGB DEFAULT = new RGB(0, 0, 0); - IPreferenceStore store = getPreferenceStore(); - PreferenceConverter.setDefault( - store, - "phpeclipse.sql.background.color", - BACKGROUND); - PreferenceConverter.setDefault( - store, - "phpeclipse.sql.text.color", - DEFAULT); - PreferenceConverter.setDefault( - store, - "phpeclipse.sql.keyword.color", - KEYWORD); - PreferenceConverter.setDefault( - store, - "phpeclipse.sql.comment.color", - COMMENT); - PreferenceConverter.setDefault( - store, - "phpeclipse.sql.string.color", - STRING); - PreferenceConverter.setDefault( - store, - "phpeclipse.sql.numeric.color", - NUMERIC); - getPreferenceStore().setDefault("phpeclipse.sql.text.bold", false); - getPreferenceStore().setDefault("phpeclipse.sql.keyword.bold", true); - getPreferenceStore().setDefault("phpeclipse.sql.string.bold", false); - getPreferenceStore().setDefault("phpeclipse.sql.comment.bold", false); - getPreferenceStore().setDefault("phpeclipse.sql.numeric.bold", false); - PreferenceConverter.setDefault(getPreferenceStore(), "phpeclipsesql.font", (FontData) null); //$NON-NLS-1$ - } + protected void initializeDefaultPluginPreferences() { + RGB BACKGROUND = new RGB(255, 255, 255); + RGB COMMENT = new RGB(88, 148, 64); + RGB KEYWORD = new RGB(126, 0, 75); + RGB STRING = new RGB(0, 0, 255); + RGB NUMERIC = new RGB(255, 0, 0); + RGB DEFAULT = new RGB(0, 0, 0); + IPreferenceStore store = getPreferenceStore(); + PreferenceConverter.setDefault(store, "phpeclipse.sql.background.color", BACKGROUND); + PreferenceConverter.setDefault(store, "phpeclipse.sql.text.color", DEFAULT); + PreferenceConverter.setDefault(store, "phpeclipse.sql.keyword.color", KEYWORD); + PreferenceConverter.setDefault(store, "phpeclipse.sql.comment.color", COMMENT); + PreferenceConverter.setDefault(store, "phpeclipse.sql.string.color", STRING); + PreferenceConverter.setDefault(store, "phpeclipse.sql.numeric.color", NUMERIC); + getPreferenceStore().setDefault("phpeclipse.sql.text.bold", false); + getPreferenceStore().setDefault("phpeclipse.sql.keyword.bold", true); + getPreferenceStore().setDefault("phpeclipse.sql.string.bold", false); + getPreferenceStore().setDefault("phpeclipse.sql.comment.bold", false); + getPreferenceStore().setDefault("phpeclipse.sql.numeric.bold", false); + PreferenceConverter.setDefault(getPreferenceStore(), "phpeclipsesql.font", (FontData) null); //$NON-NLS-1$ + getPreferenceStore().setDefault( + "phpeclipse.sql.select.template", + "$results = mysql_query(\"SELECT {0} FROM {1} WHERE {2} \");"); - public boolean showView(String view) { - IWorkbench workbench = getWorkbench(); - IWorkbenchWindow window = workbench.getActiveWorkbenchWindow(); - IWorkbenchPage page = window.getActivePage(); - IViewPart viewPart = null; - try { - viewPart = page.showView(view); - } catch (PartInitException e) { - e.printStackTrace(); - return false; - } + getPreferenceStore().setDefault( + "phpeclipse.sql.insert.template", + "$results = mysql_query(\"INSERT INTO {0} ({1}) VALUES {2} \");"); - getPreferenceStore().setDefault( - "phpeclipse.sql.select.template", - "$results = mysql_query(\"SELECT {0} FROM {1} WHERE {2} \");"); + getPreferenceStore().setDefault("phpeclipse.sql.update.template", "$results = mysql_query(\"UPDATE {0} SET {1} WHERE {2} \");"); - getPreferenceStore().setDefault( - "phpeclipse.sql.insert.template", - "$results = mysql_query(\"INSERT INTO {0} ({1}) VALUES {2} \");"); + getPreferenceStore().setDefault("phpeclipse.sql.delete.template", "$results = mysql_query(\"DELETE FROM {0} WHERE {1} \");"); - getPreferenceStore().setDefault( - "phpeclipse.sql.update.template", - "$results = mysql_query(\"UPDATE {0} SET {1} WHERE {2} \");"); + getPreferenceStore().setDefault("phpeclipse.sql.username.connect", "root"); - getPreferenceStore().setDefault( - "phpeclipse.sql.delete.template", - "$results = mysql_query(\"DELETE FROM {0} WHERE {1} \");"); + getPreferenceStore().setDefault("phpeclipse.sql.connect.connect", "jdbc:mysql://localhost/mysql"); - getPreferenceStore().setDefault( - "phpeclipse.sql.username.connect", - "root"); + getPreferenceStore().setDefault("phpeclipse.sql.driver.connect", "com.mysql.jdbc.Driver"); - getPreferenceStore().setDefault( - "phpeclipse.sql.connect.connect", - "jdbc:mysql://localhost/test"); + getPreferenceStore().setDefault("phpeclipse.sql.type.connect", "MySQL"); - getPreferenceStore().setDefault( - "phpeclipse.sql.driver.connect", - "com.mysql.jdbc.Driver"); + getPreferenceStore().setDefault( + "phpeclipse.sql.filename.connect", + "C:\\wampp2\\mysql\\lib\\mysql-connector.jar"); + } - getPreferenceStore().setDefault("phpeclipse.sql.type.connect", "MySQL"); + public boolean showView(String view) { + IWorkbench workbench = getWorkbench(); + IWorkbenchWindow window = workbench.getActiveWorkbenchWindow(); + IWorkbenchPage page = window.getActivePage(); + IViewPart viewPart = null; + try { + viewPart = page.showView(view); + } catch (PartInitException e) { + e.printStackTrace(); + return false; + } - getPreferenceStore().setDefault( - "phpeclipse.sql.filename.connect", - "C:\\apache\\mysql\\lib\\mysql-connector-java-2.0.14-bin.jar"); - - PreferenceConverter.setDefault( - getPreferenceStore(), - "phpeclipse.sql.font", - (FontData) null); - return(viewPart != null); - } + PreferenceConverter.setDefault(getPreferenceStore(), "phpeclipse.sql.font", (FontData) null); + return (viewPart != null); + } } class PHPSQLSaveParticipant implements ISaveParticipant, IConstants { - /** - * @see org.eclipse.core.resources.ISaveParticipant#doneSaving(ISaveContext) - */ - public void doneSaving(ISaveContext context) { - } + /** + * @see org.eclipse.core.resources.ISaveParticipant#doneSaving(ISaveContext) + */ + public void doneSaving(ISaveContext context) { + } - /** - * @see org.eclipse.core.resources.ISaveParticipant#prepareToSave(ISaveContext) - */ - public void prepareToSave(ISaveContext context) throws CoreException { - } + /** + * @see org.eclipse.core.resources.ISaveParticipant#prepareToSave(ISaveContext) + */ + public void prepareToSave(ISaveContext context) throws CoreException { + } - /** - * @see org.eclipse.core.resources.ISaveParticipant#rollback(ISaveContext) - */ - public void rollback(ISaveContext context) { - } + /** + * @see org.eclipse.core.resources.ISaveParticipant#rollback(ISaveContext) + */ + public void rollback(ISaveContext context) { + } - /** - * @see org.eclipse.core.resources.ISaveParticipant#saving(ISaveContext) - */ - public void saving(ISaveContext context) throws CoreException { - switch (context.getKind()) { - case ISaveContext.FULL_SAVE : - PHPEclipseSQLPlugin sqlPluginInstance = - PHPEclipseSQLPlugin.getDefault(); - // save the plug in state - if (BookmarkContentProvider.getInstance().hasChanged()) { - int saveNumber = context.getSaveNumber(); - String saveFileName = - "save " + Integer.toString(saveNumber); - File f = - sqlPluginInstance - .getStateLocation() - .append(saveFileName) - .toFile(); - // if we fail to write, an exception is thrown and we do not update the path - sqlPluginInstance.writeImportantState(f); - context.map(new Path("save"), new Path(saveFileName)); - context.needSaveNumber(); - } else { - if (DEBUG) { - System.out.println("Not saving unchanged bookmarks"); - } - } - break; - case ISaveContext.PROJECT_SAVE : - // get the project related to this save operation - //IProject project = context.getProject(); - // save its information, if necessary - break; - case ISaveContext.SNAPSHOT : - // This operation needs to be really fast because - // snapshots can be requested frequently by the - // workspace. - break; - } - } + /** + * @see org.eclipse.core.resources.ISaveParticipant#saving(ISaveContext) + */ + public void saving(ISaveContext context) throws CoreException { + switch (context.getKind()) { + case ISaveContext.FULL_SAVE : + PHPEclipseSQLPlugin sqlPluginInstance = PHPEclipseSQLPlugin.getDefault(); + // save the plug in state + if (BookmarkContentProvider.getInstance().hasChanged()) { + int saveNumber = context.getSaveNumber(); + String saveFileName = "save " + Integer.toString(saveNumber); + File f = sqlPluginInstance.getStateLocation().append(saveFileName).toFile(); + // if we fail to write, an exception is thrown and we do not update the path + sqlPluginInstance.writeImportantState(f); + context.map(new Path("save"), new Path(saveFileName)); + context.needSaveNumber(); + } else { + if (DEBUG) { + System.out.println("Not saving unchanged bookmarks"); + } + } + break; + case ISaveContext.PROJECT_SAVE : + // get the project related to this save operation + //IProject project = context.getProject(); + // save its information, if necessary + break; + case ISaveContext.SNAPSHOT : + // This operation needs to be really fast because + // snapshots can be requested frequently by the + // workspace. + break; + } + } }