Class SQLServerSystem

java.lang.Object
generalDatabase.DBSystem
generalDatabase.sqlServerExpress.SQLServerSystem

public class SQLServerSystem extends DBSystem
  • Constructor Details Link icon

    • SQLServerSystem Link icon

      public SQLServerSystem()
  • Method Details Link icon

    • getSystemName Link icon

      public String getSystemName()
      Specified by:
      getSystemName in class DBSystem
      Returns:
      The name of the database system
    • canCreate Link icon

      public boolean canCreate()
      Specified by:
      canCreate in class DBSystem
      Returns:
      true if the system can create new databases.
    • getDatabaseName Link icon

      public String getDatabaseName()
      Specified by:
      getDatabaseName in class DBSystem
      Returns:
      the name of the currently open database.
    • getSqlTypes Link icon

      public SQLTypes getSqlTypes()
      Description copied from class: DBSystem
      Get the SQLTypes object which can be used to preform system specific formatting of SQL strings.
      Specified by:
      getSqlTypes in class DBSystem
      Returns:
    • exists Link icon

      public boolean exists()
      Specified by:
      exists in class DBSystem
      Returns:
      true if the database exists
    • create Link icon

      public boolean create()
      Description copied from class: DBSystem
      Create a new database

      The underlying DBSystem will be responsible for any dialogs to chose database names, etc.

      Specified by:
      create in class DBSystem
      Returns:
      true if successful.
    • getConnection Link icon

      public PamConnection getConnection(String name)
      Description copied from class: DBSystem
      Open new database connection with a specific name
      Specified by:
      getConnection in class DBSystem
      Parameters:
      name -
      Returns:
    • browseDatabases Link icon

      public String browseDatabases(Component parent)
      Specified by:
      browseDatabases in class DBSystem
    • getDialogPanel Link icon

      public SystemDialogPanel getDialogPanel(Component parent)
      Description copied from class: DBSystem
      Get a database specific dialog panel to include in the database select dialog.
      Specified by:
      getDialogPanel in class DBSystem
      Parameters:
      parent - parent component
      Returns:
      dialog panel
    • createPamCursor Link icon

      public PamCursor createPamCursor(EmptyTableDefinition tableDefinition)
      Specified by:
      createPamCursor in class DBSystem
    • hasDriver Link icon

      public boolean hasDriver()
      Specified by:
      hasDriver in class DBSystem
      Returns:
      true if the driver for this database system is available on this computer. the availability of database system will depend both on the OS and whether software are installed.
    • getDialogPaneFX Link icon

      public SystemDialogPaneFX getDialogPaneFX()
      Description copied from class: DBSystem
      Get the FX pane for the database system
      Specified by:
      getDialogPaneFX in class DBSystem
      Returns:
      the FX settings pane for the database system.
    • browseDatabasesFX Link icon

      public String browseDatabasesFX(int type)
      Description copied from class: DBSystem
      Browse for databases using an FX dialog.
      Specified by:
      browseDatabasesFX in class DBSystem
      Parameters:
      type -
      Returns:
    • createNewDatabase Link icon

      protected boolean createNewDatabase(String forcedName)
      Specified by:
      createNewDatabase in class DBSystem