Class DBUtilities


  • public class DBUtilities
    extends java.lang.Object
    Static utility functions pertaining to the database.
    • Constructor Summary

      Constructors 
      Constructor Description
      DBUtilities()  
    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static void close​(java.sql.Connection conn)  
      static void close​(java.sql.Connection conn, java.sql.Statement stmt)
      Silently close the given connection and statement.
      static void close​(java.sql.ResultSet rs)  
      static void close​(java.sql.Statement stmt)  
      static int getJdbcType​(DataType type)  
      static java.lang.Object getParameterValue​(java.sql.CallableStatement stmt, int index, int dbType)  
      static java.lang.Object getParameterValue​(java.sql.CallableStatement stmt, java.lang.String paramName, int dbType)
      This class is necessary because some db connectors don't correctly support CallableStatement.getObject(string) [MYSQL is one, which always returns byte[2]]
      static DataType getTypeForJDBC​(int jdbcType)  
      static boolean isDataManipulationQuery​(java.lang.String query)
      Returns false if query is SELECT, otherwise true.
      static void rollback​(java.sql.Connection conn)  
      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • Constructor Detail

      • DBUtilities

        public DBUtilities()
    • Method Detail

      • getParameterValue

        public static java.lang.Object getParameterValue​(java.sql.CallableStatement stmt,
                                                         java.lang.String paramName,
                                                         int dbType)
                                                  throws java.sql.SQLException
        This class is necessary because some db connectors don't correctly support CallableStatement.getObject(string) [MYSQL is one, which always returns byte[2]]
        Throws:
        java.sql.SQLException
      • getParameterValue

        public static java.lang.Object getParameterValue​(java.sql.CallableStatement stmt,
                                                         int index,
                                                         int dbType)
                                                  throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • close

        public static void close​(java.sql.Connection conn,
                                 java.sql.Statement stmt)
        Silently close the given connection and statement.
      • rollback

        public static void rollback​(java.sql.Connection conn)
      • close

        public static void close​(java.sql.Connection conn)
      • close

        public static void close​(java.sql.Statement stmt)
      • close

        public static void close​(java.sql.ResultSet rs)
      • isDataManipulationQuery

        public static boolean isDataManipulationQuery​(java.lang.String query)
        Returns false if query is SELECT, otherwise true.
      • getJdbcType

        public static int getJdbcType​(DataType type)
      • getTypeForJDBC

        public static DataType getTypeForJDBC​(int jdbcType)