Package com.github.ddth.dao.utils

Class JdbcHelper

  • public class JdbcHelper
extends java.lang.Object
    Jdbc Helper class.
    Since:
    0.8.2
    Author:
    Thanh Nguyen

    • Constructor Summary

      Constructors 
      Constructor Description
      JdbcHelper()  

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static java.sql.PreparedStatement bindParams​(java.sql.CallableStatement cstm, java.lang.Object... bindValues)
      Bind parameter values to a CallableStatement.
      static java.sql.PreparedStatement bindParams​(java.sql.PreparedStatement pstm, java.lang.Object... bindValues)
      Bind parameter values to a PreparedStatement.
      static java.lang.String[] extractColumnLabels​(java.sql.ResultSet rs)
      Extract column label/name from a ResultSet.
      static java.sql.PreparedStatement prepareAndBindNamedParamsStatement​(java.sql.Connection conn, java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability, java.util.Map<java.lang.String,​?> bindValues)
      Prepare and bind parameter values a named-parameter statement.
      static java.sql.PreparedStatement prepareAndBindNamedParamsStatement​(java.sql.Connection conn, java.lang.String sql, int resultSetType, int resultSetConcurrency, java.util.Map<java.lang.String,​?> bindValues)
      Prepare and bind parameter values a named-parameter statement.
      static java.sql.PreparedStatement prepareAndBindNamedParamsStatement​(java.sql.Connection conn, java.lang.String sql, java.util.Map<java.lang.String,​?> bindValues)
      Prepare and bind parameter values a named-parameter statement.

      • Methods inherited from class java.lang.Object

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

    • Constructor Detail

      • JdbcHelper

        public JdbcHelper()

    • Method Detail

      • extractColumnLabels

        public static java.lang.String[] extractColumnLabels​(java.sql.ResultSet rs)
                                              throws java.sql.SQLException
        Extract column label/name from a ResultSet.
        Parameters:
        rs -
        Returns:
        Throws:
        java.sql.SQLException

      • bindParams

        public static java.sql.PreparedStatement bindParams​(java.sql.PreparedStatement pstm,
                                                    java.lang.Object... bindValues)
                                             throws java.sql.SQLException
        Bind parameter values to a PreparedStatement.
        Parameters:
        pstm -
        bindValues -
        Returns:
        Throws:
        java.sql.SQLException
        Since:
        0.8.0

      • bindParams

        public static java.sql.PreparedStatement bindParams​(java.sql.CallableStatement cstm,
                                                    java.lang.Object... bindValues)
                                             throws java.sql.SQLException
        Bind parameter values to a CallableStatement.
        Parameters:
        cstm -
        bindValues -
        Returns:
        Throws:
        java.sql.SQLException
        Since:
        0.8.2

      • prepareAndBindNamedParamsStatement

        public static java.sql.PreparedStatement prepareAndBindNamedParamsStatement​(java.sql.Connection conn,
                                                                            java.lang.String sql,
                                                                            java.util.Map<java.lang.String,​?> bindValues)
                                                                     throws java.sql.SQLException
        Prepare and bind parameter values a named-parameter statement.
        Parameters:
        conn -
        sql -
        bindValues - name-based bind values
        Returns:
        Throws:
        java.sql.SQLException
        Since:
        0.8.2

      • prepareAndBindNamedParamsStatement

        public static java.sql.PreparedStatement prepareAndBindNamedParamsStatement​(java.sql.Connection conn,
                                                                            java.lang.String sql,
                                                                            int resultSetType,
                                                                            int resultSetConcurrency,
                                                                            java.util.Map<java.lang.String,​?> bindValues)
                                                                     throws java.sql.SQLException
        Prepare and bind parameter values a named-parameter statement.
        Parameters:
        conn -
        sql -
        resultSetType -
        resultSetConcurrency -
        bindValues - name-based bind values
        Returns:
        Throws:
        java.sql.SQLException
        Since:
        0.8.2

      • prepareAndBindNamedParamsStatement

        public static java.sql.PreparedStatement prepareAndBindNamedParamsStatement​(java.sql.Connection conn,
                                                                            java.lang.String sql,
                                                                            int resultSetType,
                                                                            int resultSetConcurrency,
                                                                            int resultSetHoldability,
                                                                            java.util.Map<java.lang.String,​?> bindValues)
                                                                     throws java.sql.SQLException
        Prepare and bind parameter values a named-parameter statement.
        Parameters:
        conn -
        sql -
        resultSetType -
        resultSetConcurrency -
        resultSetHoldability -
        bindValues - name-based bind values
        Returns:
        Throws:
        java.sql.SQLException
        Since:
        0.8.2