com.screenscraper.datamanager.sql.util

Class QueryUtils

java.lang.Object

com.screenscraper.datamanager.sql.util.QueryUtils

public class QueryUtils
extends java.lang.Object

Collection of static methods useful when writing/retrieving data from an sql database

Constructor Summary

Constructors

Constructor and Description
QueryUtils()

Method Summary

Modifier and Type	Method and Description
static boolean	isApproximatelyNull(java.lang.String value)
static boolean	isValidSqlName(java.lang.String name)
static java.lang.String	prepForDB(java.lang.Object value, java.lang.String prependValue)
static java.util.Map<java.lang.String,DataObject>	saveRowAsMap(java.sql.ResultSet rs)
static java.lang.String	tidy(java.lang.Object o)

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryUtils

public QueryUtils()

Method Detail

isApproximatelyNull

public static boolean isApproximatelyNull(@Nullable
                                          java.lang.String value)

tidy

public static java.lang.String tidy(@NotNull
                                    java.lang.Object o)

prepForDB

public static java.lang.String prepForDB(@Nullable
                                         java.lang.Object value,
                                         @NotNull
                                         java.lang.String prependValue)

saveRowAsMap

@NotNull
public static java.util.Map<java.lang.String,DataObject> saveRowAsMap(@NotNull
                                                                                java.sql.ResultSet rs)
                                                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

isValidSqlName

public static boolean isValidSqlName(@NotNull
                                     java.lang.String name)