velosurf.sql
Class SqlUtil

java.lang.Object
  |
  +--velosurf.sql.SqlUtil

public class SqlUtil

extends java.lang.Object

various SQL-related helpers

Author:

Claude Brisson

Constructor Summary

SqlUtil()

Method Summary

static java.util.List	getColumnNames(java.sql.ResultSet inResultSet)
static long	getLastInsertId(DBConnection connection, java.sql.Statement statement)
static java.lang.String	orderQuery(java.lang.String inQuery, java.lang.String inOrder)
static java.lang.String	refineQuery(java.lang.String inQuery, java.util.List inCriteria)
private static java.lang.String	stars(int length)

Methods inherited from class java.lang.Object

, clone, equals, finalize, getClass, hashCode, notify, notifyAll, registerNatives, toString, wait, wait, wait

Constructor Detail

SqlUtil

public SqlUtil()

Method Detail

stars

private static java.lang.String stars(int length)

refineQuery

public static java.lang.String refineQuery(java.lang.String inQuery,
                                           java.util.List inCriteria)

orderQuery

public static java.lang.String orderQuery(java.lang.String inQuery,
                                          java.lang.String inOrder)

getColumnNames

public static java.util.List getColumnNames(java.sql.ResultSet inResultSet)
                                     throws java.sql.SQLException

getLastInsertId

public static long getLastInsertId(DBConnection connection,
                                   java.sql.Statement statement)