Java Doc for SQLUtil.java in  » EJB-Server-JBoss-4.2.1 » server » org » jboss » ejb » plugins » cmp » jdbc » 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 » EJB Server JBoss 4.2.1 » server » org.jboss.ejb.plugins.cmp.jdbc   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.jboss.ejb.plugins.cmp.jdbc.SQLUtil SQLUtil final public class SQLUtil (Code) SQLUtil helps with building sql statements. author:    Dain Sundstrom author:    Alex Loubyansky author:    Joachim Van der Auwera version:    $Revision: 63348 $ Inner Class :public static class OldColumns Inner Class :public static class OldIndexes Field Summary final public static  String ABS      final public static  String AND      final public static  String ASC      final public static  String AVG      final public static  String BETWEEN      final public static  String COMMA      final public static  String CONCAT      final public static  String COUNT      final public static  String CREATE_INDEX      final public static  String CREATE_TABLE      final public static  String DELETE_FROM      final public static  String DESC      final public static  String DISTINCT      final public static  String DROP_TABLE      final public static  String EMPTY      final public static  String EMPTY_STRING      final public static  String EXISTS      final public static  String FROM      final public static  String IN      final public static  String INSERT_INTO      final public static  String IS      final public static  String LCASE      final public static  String LEFT_JOIN      final public static  String LEFT_OUTER_JOIN      final public static  String LENGTH      final public static  String LIKE      final public static  String LIMIT      final public static  String LOCATE      final public static  String MAX      final public static  String MEMBER_OF      final public static  String MIN      final public static  String MOD      final public static  String NOT      final public static  String NOT_EQUAL      final public static  String NULL      final public static  String OFFSET      final public static  String ON      final public static  String OR      final public static  String ORDERBY      final public static  String SELECT      final public static  String SET      final public static  String SQRT      final public static  String SUBSTRING      final public static  String SUM      final public static  String TYPE      final public static  String UCASE      final public static  String UPDATE      final public static  String VALUES      final public static  String WHERE      Method Summary public static  void addToRwords(String word)      public static  StringBuffer appendColumnNamesClause(JDBCAbstractEntityBridge entity, String eagerLoadGroup, StringBuffer sb)      public static  StringBuffer appendColumnNamesClause(JDBCAbstractEntityBridge entity, String eagerLoadGroup, String alias, StringBuffer sb)      public static  StringBuffer appendColumnNamesClause(JDBCFieldBridge[] fields, boolean[] mask, String identifier, StringBuffer buf)      public static  StringBuffer appendColumnNamesClause(JDBCFieldBridge[] fields, String identifier, StringBuffer buf)      public static  void dropTable(DataSource dataSource, String tableName)      public static  String fixConstraintName(String name, DataSource dataSource)      public static  String fixTableName(String tableName, DataSource dataSource)      public static  StringBuffer getColumnNamesClause(JDBCFieldBridge[] fields, StringBuffer sb)      public static  StringBuffer getColumnNamesClause(JDBCFieldBridge[] fields, String identifier, StringBuffer buf)      public static  StringBuffer getColumnNamesClause(JDBCEntityBridge.FieldIterator loadIter, StringBuffer sb)      public static  StringBuffer getColumnNamesClause(JDBCFieldBridge field, StringBuffer sb)      public static  StringBuffer getColumnNamesClause(JDBCFieldBridge field, String identifier, StringBuffer sb)      public static  String getCreateTableColumnsClause(JDBCFieldBridge[] fields)      public static  String getCreateTableColumnsClause(JDBCType type)      public static  StringBuffer getIsNullClause(boolean not, JDBCFieldBridge[] fields, String identifier, StringBuffer buf)      public static  StringBuffer getIsNullClause(boolean not, JDBCFieldBridge field, String identifier, StringBuffer buf)      public static  StringBuffer getJoinClause(JDBCAbstractCMRFieldBridge cmrField, String parentAlias, String childAlias, StringBuffer buf)      public static  StringBuffer getJoinClause(JDBCFieldBridge[] pkFields, String parent, JDBCFieldBridge[] fkFields, String child, StringBuffer buf)      public static  OldColumns getOldColumns(String tableName, DataSource dataSource)      public static  OldIndexes getOldIndexes(String tableName, DataSource dataSource)      public static  StringBuffer getRelationTableJoinClause(JDBCAbstractCMRFieldBridge cmrField, String parentAlias, String relationTableAlias, StringBuffer buf)      public static  String getSchema(String tableName)      public static  StringBuffer getSearchableColumnNamesClause(JDBCFieldBridge[] fields, String identifier, StringBuffer buf)      public static  StringBuffer getSelfCompareWhereClause(JDBCFieldBridge[] fields, String fromIdentifier, String toIdentifier, StringBuffer buf)      public static  StringBuffer getSelfCompareWhereClause(JDBCFieldBridge fromField, JDBCFieldBridge toField, String fromIdentifier, String toIdentifier, String comparison, StringBuffer buf)      public static  StringBuffer getSetClause(JDBCEntityBridge.FieldIterator fieldsIter, StringBuffer buf)      public static  String getTableNameWithoutSchema(String tableName)      public static  StringBuffer getValuesClause(JDBCFieldBridge[] fields, StringBuffer buf)      public static  StringBuffer getWhereClause(JDBCFieldBridge[] fields, StringBuffer buf)      public static  StringBuffer getWhereClause(JDBCFieldBridge[] fields, String identifier, StringBuffer buf)      public static  StringBuffer getWhereClause(JDBCFieldBridge[] fields, long mask, StringBuffer buf)      public static  StringBuffer getWhereClause(JDBCFieldBridge field, StringBuffer buf)      public static  StringBuffer getWhereClause(JDBCType type, String identifier, StringBuffer buf)      public static  StringBuffer getWhereClause(JDBCType type, String identifier, String comparison, StringBuffer buf)      public static  boolean tableExists(String tableName, DataSource dataSource)      public static  String unquote(String tableName, DataSource ds)      Field Detail ABS final public static String ABS(Code) AND final public static String AND(Code) ASC final public static String ASC(Code) AVG final public static String AVG(Code) BETWEEN final public static String BETWEEN(Code) COMMA final public static String COMMA(Code) CONCAT final public static String CONCAT(Code) COUNT final public static String COUNT(Code) CREATE_INDEX final public static String CREATE_INDEX(Code) CREATE_TABLE final public static String CREATE_TABLE(Code) DELETE_FROM final public static String DELETE_FROM(Code) DESC final public static String DESC(Code) DISTINCT final public static String DISTINCT(Code) DROP_TABLE final public static String DROP_TABLE(Code) EMPTY final public static String EMPTY(Code) EMPTY_STRING final public static String EMPTY_STRING(Code) EXISTS final public static String EXISTS(Code) FROM final public static String FROM(Code) IN final public static String IN(Code) INSERT_INTO final public static String INSERT_INTO(Code) IS final public static String IS(Code) LCASE final public static String LCASE(Code) LEFT_JOIN final public static String LEFT_JOIN(Code) LEFT_OUTER_JOIN final public static String LEFT_OUTER_JOIN(Code) LENGTH final public static String LENGTH(Code) LIKE final public static String LIKE(Code) LIMIT final public static String LIMIT(Code) LOCATE final public static String LOCATE(Code) MAX final public static String MAX(Code) MEMBER_OF final public static String MEMBER_OF(Code) MIN final public static String MIN(Code) MOD final public static String MOD(Code) NOT final public static String NOT(Code) NOT_EQUAL final public static String NOT_EQUAL(Code) NULL final public static String NULL(Code) OFFSET final public static String OFFSET(Code) ON final public static String ON(Code) OR final public static String OR(Code) ORDERBY final public static String ORDERBY(Code) SELECT final public static String SELECT(Code) SET final public static String SET(Code) SQRT final public static String SQRT(Code) SUBSTRING final public static String SUBSTRING(Code) SUM final public static String SUM(Code) TYPE final public static String TYPE(Code) UCASE final public static String UCASE(Code) UPDATE final public static String UPDATE(Code) VALUES final public static String VALUES(Code) WHERE final public static String WHERE(Code) Method Detail addToRwords public static void addToRwords(String word)(Code) appendColumnNamesClause public static StringBuffer appendColumnNamesClause(JDBCAbstractEntityBridge entity, String eagerLoadGroup, StringBuffer sb)(Code) Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]' appendColumnNamesClause public static StringBuffer appendColumnNamesClause(JDBCAbstractEntityBridge entity, String eagerLoadGroup, String alias, StringBuffer sb)(Code) Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]' appendColumnNamesClause public static StringBuffer appendColumnNamesClause(JDBCFieldBridge[] fields, boolean[] mask, String identifier, StringBuffer buf)(Code) Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]' appendColumnNamesClause public static StringBuffer appendColumnNamesClause(JDBCFieldBridge[] fields, String identifier, StringBuffer buf)(Code) Returns ', columnName0 [, columnName1 [AND columnName2 [...]]]' dropTable public static void dropTable(DataSource dataSource, String tableName) throws DeploymentException(Code) fixConstraintName public static String fixConstraintName(String name, DataSource dataSource) throws DeploymentException(Code) fixTableName public static String fixTableName(String tableName, DataSource dataSource) throws DeploymentException(Code) getColumnNamesClause public static StringBuffer getColumnNamesClause(JDBCFieldBridge[] fields, StringBuffer sb)(Code) Returns columnName0 [, columnName1 [AND columnName2 [...]]] getColumnNamesClause public static StringBuffer getColumnNamesClause(JDBCFieldBridge[] fields, String identifier, StringBuffer buf)(Code) Returns columnName0 [, columnName1 [AND columnName2 [...]]] getColumnNamesClause public static StringBuffer getColumnNamesClause(JDBCEntityBridge.FieldIterator loadIter, StringBuffer sb)(Code) Returns columnName0 [, columnName1 [AND columnName2 [...]]] getColumnNamesClause public static StringBuffer getColumnNamesClause(JDBCFieldBridge field, StringBuffer sb)(Code) Returns columnName0 [, columnName1 [, columnName2 [...]]] getColumnNamesClause public static StringBuffer getColumnNamesClause(JDBCFieldBridge field, String identifier, StringBuffer sb)(Code) Returns identifier.columnName0 [, identifier.columnName1 [, identifier.columnName2 [...]]] getCreateTableColumnsClause public static String getCreateTableColumnsClause(JDBCFieldBridge[] fields)(Code) getCreateTableColumnsClause public static String getCreateTableColumnsClause(JDBCType type)(Code) Returns columnName0 sqlType0 [, columnName1 sqlType0 [, columnName2 sqlType0 [...]]] getIsNullClause public static StringBuffer getIsNullClause(boolean not, JDBCFieldBridge[] fields, String identifier, StringBuffer buf)(Code) Returns identifier.columnName0 IS [NOT] NULL [AND identifier.columnName1 IS [NOT] NULL [AND identifier.columnName2 IS [NOT] NULL [...]]] getIsNullClause public static StringBuffer getIsNullClause(boolean not, JDBCFieldBridge field, String identifier, StringBuffer buf)(Code) Returns identifier.columnName0 IS [NOT] NULL [AND identifier.columnName1 IS [NOT] NULL [AND identifier.columnName2 IS [NOT] NULL [...]]] getJoinClause public static StringBuffer getJoinClause(JDBCAbstractCMRFieldBridge cmrField, String parentAlias, String childAlias, StringBuffer buf)(Code) getJoinClause public static StringBuffer getJoinClause(JDBCFieldBridge[] pkFields, String parent, JDBCFieldBridge[] fkFields, String child, StringBuffer buf)(Code) getOldColumns public static OldColumns getOldColumns(String tableName, DataSource dataSource) throws DeploymentException(Code) getOldIndexes public static OldIndexes getOldIndexes(String tableName, DataSource dataSource) throws DeploymentException(Code) getRelationTableJoinClause public static StringBuffer getRelationTableJoinClause(JDBCAbstractCMRFieldBridge cmrField, String parentAlias, String relationTableAlias, StringBuffer buf)(Code) getSchema public static String getSchema(String tableName)(Code) getSearchableColumnNamesClause public static StringBuffer getSearchableColumnNamesClause(JDBCFieldBridge[] fields, String identifier, StringBuffer buf)(Code) Returns columnName0 [, columnName1 [AND columnName2 [...]]] getSelfCompareWhereClause public static StringBuffer getSelfCompareWhereClause(JDBCFieldBridge[] fields, String fromIdentifier, String toIdentifier, StringBuffer buf)(Code) getSelfCompareWhereClause public static StringBuffer getSelfCompareWhereClause(JDBCFieldBridge fromField, JDBCFieldBridge toField, String fromIdentifier, String toIdentifier, String comparison, StringBuffer buf)(Code) getSetClause public static StringBuffer getSetClause(JDBCEntityBridge.FieldIterator fieldsIter, StringBuffer buf)(Code) Returns columnName0=? [, columnName1=? [, columnName2=? [...]]] getTableNameWithoutSchema public static String getTableNameWithoutSchema(String tableName)(Code) getValuesClause public static StringBuffer getValuesClause(JDBCFieldBridge[] fields, StringBuffer buf)(Code) Returns ? [, ? [, ? [...]]] getWhereClause public static StringBuffer getWhereClause(JDBCFieldBridge[] fields, StringBuffer buf)(Code) Returns columnName0=? [AND columnName1=? [AND columnName2=? [...]]] getWhereClause public static StringBuffer getWhereClause(JDBCFieldBridge[] fields, String identifier, StringBuffer buf)(Code) Returns identifier.columnName0=? [AND identifier.columnName1=? [AND identifier.columnName2=? [...]]] getWhereClause public static StringBuffer getWhereClause(JDBCFieldBridge[] fields, long mask, StringBuffer buf)(Code) Returns columnName0=? [AND columnName1=? [AND columnName2=? [...]]] getWhereClause public static StringBuffer getWhereClause(JDBCFieldBridge field, StringBuffer buf)(Code) Returns columnName0=? [AND columnName1=? [AND columnName2=? [...]]] getWhereClause public static StringBuffer getWhereClause(JDBCType type, String identifier, StringBuffer buf)(Code) Returns identifier.columnName0=? [AND identifier.columnName1=? [AND identifier.columnName2=? [...]]] getWhereClause public static StringBuffer getWhereClause(JDBCType type, String identifier, String comparison, StringBuffer buf)(Code) Returns identifier.columnName0{comparison}? [AND identifier.columnName1{comparison}? [AND identifier.columnName2{comparison}? [...]]] tableExists public static boolean tableExists(String tableName, DataSource dataSource) throws DeploymentException(Code) unquote public static String unquote(String tableName, DataSource ds) throws DeploymentException(Code) 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)