Java Doc for MySQLDBQueryEngine.java in  » Database-Client » DBBrowser » org » dbbrowser » db » engine » queryengine » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database Client » DBBrowser » org.dbbrowser.db.engine.queryengine   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.dbbrowser.db.engine.queryengine.AbstractDBQueryEngine       org.dbbrowser.db.engine.queryengine.MySQLDBQueryEngine MySQLDBQueryEngine public class MySQLDBQueryEngine extends AbstractDBQueryEngine implements DBQueryEngine(Code) DBQuery Engine which gets data from a MySQL DBMS Constructor Summary public   MySQLDBQueryEngine(Statement statement)      Method Summary public  DBTable getAllDataInATable(String schemaName, String tableName, Integer offset, Integer numberOfRowsToReturn)      public  List getPrimaryKeyColumnNames(String schemaName, String tableName)      public  String getSQLForView(View view)      public  List listColumnsInATable(String databaseInstanceName, String tableName)      public  DBTable listConstraints()      public  DBTable listIndexes()      public  List listSchemas()      Returns a list of schemas in the Database. - a list of Strings. public  List listTablesInSchema(String databaseInstanceName)      public  List listViews()      MySQL 5 does not support views. Constructor Detail MySQLDBQueryEngine public MySQLDBQueryEngine(Statement statement)(Code) Constructer Parameters:   statement - Method Detail getAllDataInATable public DBTable getAllDataInATable(String schemaName, String tableName, Integer offset, Integer numberOfRowsToReturn) throws DBEngineException(Code) Get all the data in a table Parameters:   schemaName - Parameters:   tableName - throws:   DBEngineException - getPrimaryKeyColumnNames public List getPrimaryKeyColumnNames(String schemaName, String tableName) throws DBEngineException(Code) Returns the list of column names which are primary keys for the table Parameters:   schemaName - Parameters:   tableName - a list of strings - names of primary key columns throws:   DBEngineException - getSQLForView public String getSQLForView(View view) throws DBEngineException(Code) Returns the SQL used to create a view - a String throws:   DBEngineException - listColumnsInATable public List listColumnsInATable(String databaseInstanceName, String tableName) throws DBEngineException(Code) Returns a list of columns in the table Parameters:   databaseInstanceName - Parameters:   tableName - - a list of ColumnInfo objects throws:   DBEngineException - listConstraints public DBTable listConstraints() throws DBEngineException(Code) Lists the constraints throws:   DBEngineException - listIndexes public DBTable listIndexes() throws DBEngineException(Code) Lists the indexes throws:   DBEngineException - listSchemas public List listSchemas() throws DBEngineException(Code) Returns a list of schemas in the Database. - a list of Strings. It is empty if there are no table spaces for the database. throws:   DBEngineException - listTablesInSchema public List listTablesInSchema(String databaseInstanceName) throws DBEngineException(Code) Returns a list of tables in the schema Parameters:   schemaName - - a list of Strings throws:   DBEngineException - listViews public List listViews() throws DBEngineException(Code) MySQL 5 does not support views. Views are same as tables - a list of View objects throws:   DBEngineException - Methods inherited from org.dbbrowser.db.engine.queryengine.AbstractDBQueryEngine abstract public DBTable getAllDataInATable(String schemaName, String tableName, Integer offset, Integer numberOfRowsToReturn) throws DBEngineException(Code)(Java Doc) public DBTable getFilteredDataInATable(String schemaName, String tableName, Filter filter) throws DBEngineException(Code)(Java Doc) public List getPrimaryKeyColumnNames(String schemaName, String tableName) throws DBEngineException(Code)(Java Doc) public Integer getRowCount(String schemaName, String tableName) throws DBEngineException(Code)(Java Doc) public Statement getStatement()(Code)(Java Doc) abstract public List listColumnsInATable(String schemaName, String tableName) throws DBEngineException(Code)(Java Doc) abstract public DBTable listConstraints() throws DBEngineException(Code)(Java Doc) abstract public DBTable listIndexes() throws DBEngineException(Code)(Java Doc) abstract public List listSchemas() throws DBEngineException(Code)(Java Doc) abstract public List listTablesInSchema(String schemaName) throws DBEngineException(Code)(Java Doc) abstract public List listViews() throws DBEngineException(Code)(Java Doc) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)