Java Doc for DBUtils.java in  » J2EE » panther » org » lateralnz » c3d » util » 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 » J2EE » panther » org.lateralnz.c3d.util   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.lateralnz.c3d.util.DBUtils DBUtils public class DBUtils implements Constants(Code) general utilities Field Summary final public static  int CLEAR_CACHE_STATEMENT      final public static  int DELETE_STATEMENT      final public static  int INSERT_STATEMENT      final public static  int QUERY_CACHE_DUMP_STATEMENT      final public static  int QUERY_CACHE_STATEMENT      final public static  int QUERY_STATS_STATEMENT      final public static  int SELECT_STATEMENT      final public static  String SEP      final public static  int UPDATE_STATEMENT      Method Summary final public static  int countSelects(List l)      final public static  Column createColumn(ResultSet rs, int[] types, int idx)      final public static  Column createColumn(String value)      final public static  Column[] createRow(String[] values)      final public static  String flatten(Column[] cols, String delim)      final public static  String getCacheNameFromKey(String key)      final public static  String getInsertTableName(String sql)      final public static  String[] getKeyColumnData(int[] keyColumns, ResultSet rs)      return the column data based on an array of primary key columns. final public static  Object getObjectFromMap(Object key, Map m, Class newObjClass)      final public static  String getResultSetDataKey(String cache, String[] keyColumns)      final public static  String getTargetName(String sql, int type)      final public static  String getWhereClause(String sql)      final public static  boolean isStatementType(String s, int type)      final public static  void setParams(PreparedStatement ps, Column[] cols, int offset, int length)      final public static  List splitSQL(String s)      final public static  Map splitSet(String setSQL)      Field Detail CLEAR_CACHE_STATEMENT final public static int CLEAR_CACHE_STATEMENT(Code) DELETE_STATEMENT final public static int DELETE_STATEMENT(Code) INSERT_STATEMENT final public static int INSERT_STATEMENT(Code) QUERY_CACHE_DUMP_STATEMENT final public static int QUERY_CACHE_DUMP_STATEMENT(Code) QUERY_CACHE_STATEMENT final public static int QUERY_CACHE_STATEMENT(Code) QUERY_STATS_STATEMENT final public static int QUERY_STATS_STATEMENT(Code) SELECT_STATEMENT final public static int SELECT_STATEMENT(Code) SEP final public static String SEP(Code) UPDATE_STATEMENT final public static int UPDATE_STATEMENT(Code) Method Detail countSelects final public static int countSelects(List l)(Code) count the selects that appear in a list of SQL statements createColumn final public static Column createColumn(ResultSet rs, int[] types, int idx) throws SQLException(Code) create a column object from the resultset using an array of db types and the index of the column we're creating createColumn final public static Column createColumn(String value)(Code) createRow final public static Column[] createRow(String[] values)(Code) flatten final public static String flatten(Column[] cols, String delim)(Code) flatten an array of columns into a string getCacheNameFromKey final public static String getCacheNameFromKey(String key)(Code) getInsertTableName final public static String getInsertTableName(String sql)(Code) getKeyColumnData final public static String[] getKeyColumnData(int[] keyColumns, ResultSet rs) throws SQLException(Code) return the column data based on an array of primary key columns. For example, if the primary keys are in columns 1, 5 and 6 of the resultset, this will return the data in those columns as a 3 element array. getObjectFromMap final public static Object getObjectFromMap(Object key, Map m, Class newObjClass) throws SQLException(Code) getResultSetDataKey final public static String getResultSetDataKey(String cache, String[] keyColumns)(Code) getTargetName final public static String getTargetName(String sql, int type)(Code) getWhereClause final public static String getWhereClause(String sql)(Code) get the where clause of an SQL statement isStatementType final public static boolean isStatementType(String s, int type)(Code) setParams final public static void setParams(PreparedStatement ps, Column[] cols, int offset, int length) throws SQLException(Code) given an array of Column objects set the values of those columns as parameters in a prepared statement splitSQL final public static List splitSQL(String s)(Code) split an SQL statement into SQL fragments separated by ; for example, select * from table1;insert into table2 should result in 2 separate statements splitSet final public static Map splitSet(String setSQL) throws SQLException(Code) split a SQL set clause into a map of column=value 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)