fr.ifremer.adagio.core.dao.technical

Class DaoUtils

Object

DaoUtils

public class DaoUtils
extends Object

Usefull method around DAO and entities.

Since:

3.5

Author:

tchemit , Benoit Lavenier

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	DaoUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static void	closeSilently(Connection connection)
static void	closeSilently(ResultSet statement)
static void	closeSilently(Session session)
static void	closeSilently(Statement statement)
static int	compareWeights(float v0, float v1) Compare two weights with rounding them to kilograms.
static int	computeDistanceInMeters(Float startLatitude, Float startLongitude, Float endLatitude, Float endLongitude)
static Double	convertToDouble(Float floatValue)
static Float	convertToFloat(Double doubleValue)
static Connection	createConnection(Properties connectionProperties)
static Connection	createConnection(String jdbcUrl, String user, String password)
static void	fillConnectionProperties(Properties p, String url, String username, String password)
static Properties	getConnectionProperties(String jdbcUrl, String username, String password, String schema, String dialect, String driver) Create a new hibernate configuration, with all hbm.xml files for the schema need for app
static DecimalFormat	getDecimalFormat(int minDecimal, int maxDecimal)
static DecimalFormatSymbols	getDecimalFormatSymbols()
static String	getDistanceInMilles(Float distance)
static String	getJdbcUrl(File directory, String dbName)
static float	getRoundedLengthStep(float lengthStep, boolean aroundUp)
static String	getUrl(Properties connectionProperties)
static <N extends Number> N	getValueOrComputedValue(N value, N computedValue)
static <N extends Number> Boolean	getValueOrComputedValueComputed(N value, N computedValue)
static String	getWeightStringValue(Float weight)
static boolean	isEqualWeight(float v0, float v1)
static boolean	isFileDatabase(String jdbcUrl)
static boolean	isGreaterWeight(float v0, float v1)
static boolean	isNotEqualWeight(float v0, float v1)
static boolean	isSmallerWeight(float v0, float v1)
static boolean	isValidConnectionProperties(String jdbcDriver, String jdbcUrl, String user, String password) Check if connection properties are valid.
static float	roundKiloGram(float value) Round the given value to max 4 digits.
static void	shutdownDatabase(Connection connection)
static void	shutdownDatabase(Properties connectionProperties)
static Object	sqlUnique(Connection connection, String sql)
static Object	sqlUnique(DataSource dataSource, String sql)
static <T> T	sqlUniqueTyped(Connection connection, String sql)
static <T> T	sqlUniqueTyped(DataSource dataSource, String sql)
static int	sqlUpdate(Connection connection, String sql)
static int	sqlUpdate(DataSource dataSource, String sql)
static Query	withStatus(Query query) set parameter values for a query: 'statusValidCode' and 'statusTemporaryCode'

Methods inherited from class Object

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

Constructor Detail

DaoUtils

protected DaoUtils()

Method Detail

getConnectionProperties

public static Properties getConnectionProperties(String jdbcUrl,
                                 String username,
                                 String password,
                                 String schema,
                                 String dialect,
                                 String driver)

Create a new hibernate configuration, with all hbm.xml files for the schema need for app

Returns:

the hibernate Configuration

closeSilently

public static void closeSilently(Statement statement)

closeSilently

public static void closeSilently(Connection connection)

closeSilently

public static void closeSilently(ResultSet statement)

closeSilently

public static void closeSilently(Session session)

createConnection

public static Connection createConnection(Properties connectionProperties)
                                   throws SQLException

Throws:

SQLException

getUrl

public static String getUrl(Properties connectionProperties)

createConnection

public static Connection createConnection(String jdbcUrl,
                          String user,
                          String password)
                                   throws SQLException

Throws:

SQLException

fillConnectionProperties

public static void fillConnectionProperties(Properties p,
                            String url,
                            String username,
                            String password)

getJdbcUrl

public static String getJdbcUrl(File directory,
                String dbName)

isFileDatabase

public static boolean isFileDatabase(String jdbcUrl)

isValidConnectionProperties

public static boolean isValidConnectionProperties(String jdbcDriver,
                                  String jdbcUrl,
                                  String user,
                                  String password)

Check if connection properties are valid. Try to open a SQL connection, then close it. If no error occur, the connection is valid.

Parameters:

jdbcDriver -

jdbcUrl -

user -

password -

Returns:

computeDistanceInMeters

public static int computeDistanceInMeters(Float startLatitude,
                          Float startLongitude,
                          Float endLatitude,
                          Float endLongitude)

getDistanceInMilles

public static String getDistanceInMilles(Float distance)

getRoundedLengthStep

public static float getRoundedLengthStep(float lengthStep,
                         boolean aroundUp)

getDecimalFormatSymbols

public static DecimalFormatSymbols getDecimalFormatSymbols()

getDecimalFormat

public static DecimalFormat getDecimalFormat(int minDecimal,
                             int maxDecimal)

getWeightStringValue

public static String getWeightStringValue(Float weight)

getValueOrComputedValue

public static <N extends Number> N getValueOrComputedValue(N value,
                                           N computedValue)

getValueOrComputedValueComputed

public static <N extends Number> Boolean getValueOrComputedValueComputed(N value,
                                                         N computedValue)

roundKiloGram

public static float roundKiloGram(float value)

Round the given value to max 4 digits.

Parameters:

value - the float to round.

Returns:

the rounded value

Since:

1.0.1

compareWeights

public static int compareWeights(float v0,
                 float v1)

Compare two weights with rounding them to kilograms.

Parameters:

v0 - first weight to compare

v1 - second weight to compare

Returns:

1 if v0 > v1, -1 if v0 < v1, 0 if v0 == v1

isSmallerWeight

public static boolean isSmallerWeight(float v0,
                      float v1)

isGreaterWeight

public static boolean isGreaterWeight(float v0,
                      float v1)

isEqualWeight

public static boolean isEqualWeight(float v0,
                    float v1)

isNotEqualWeight

public static boolean isNotEqualWeight(float v0,
                       float v1)

withStatus

public static Query withStatus(Query query)

set parameter values for a query: 'statusValidCode' and 'statusTemporaryCode'

Parameters:

query - a query with this parameters inside

Returns:

the given query object

convertToDouble

public static Double convertToDouble(Float floatValue)

convertToFloat

public static Float convertToFloat(Double doubleValue)

sqlUpdate

public static int sqlUpdate(DataSource dataSource,
            String sql)

sqlUpdate

public static int sqlUpdate(Connection connection,
            String sql)

sqlUnique

public static Object sqlUnique(DataSource dataSource,
               String sql)

sqlUniqueTyped

public static <T> T sqlUniqueTyped(DataSource dataSource,
                   String sql)

sqlUnique

public static Object sqlUnique(Connection connection,
               String sql)

sqlUniqueTyped

public static <T> T sqlUniqueTyped(Connection connection,
                   String sql)

shutdownDatabase

public static void shutdownDatabase(Connection connection)

shutdownDatabase

public static void shutdownDatabase(Properties connectionProperties)
                             throws SQLException

Throws:

SQLException