Class SqlRunner


  • public class SqlRunner
    extends java.lang.Object
    Author:
    Clinton Begin
    • Field Summary

      Fields 
      Modifier and Type Field Description
      static int NO_GENERATED_KEY  
    • Constructor Summary

      Constructors 
      Constructor Description
      SqlRunner​(java.sql.Connection connection)  
    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      void closeConnection()  
      int delete​(java.lang.String sql, java.lang.Object... args)
      Executes a DELETE statement.
      int insert​(java.lang.String sql, java.lang.Object... args)
      Executes an INSERT statement.
      void run​(java.lang.String sql)
      Executes any string as a JDBC Statement.
      java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> selectAll​(java.lang.String sql, java.lang.Object... args)
      Executes a SELECT statement that returns multiple rows.
      java.util.Map<java.lang.String,​java.lang.Object> selectOne​(java.lang.String sql, java.lang.Object... args)
      Executes a SELECT statement that returns one row.
      void setUseGeneratedKeySupport​(boolean useGeneratedKeySupport)  
      int update​(java.lang.String sql, java.lang.Object... args)
      Executes an UPDATE statement.
      • Methods inherited from class java.lang.Object

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

      • SqlRunner

        public SqlRunner​(java.sql.Connection connection)
    • Method Detail

      • setUseGeneratedKeySupport

        public void setUseGeneratedKeySupport​(boolean useGeneratedKeySupport)
      • selectOne

        public java.util.Map<java.lang.String,​java.lang.Object> selectOne​(java.lang.String sql,
                                                                                java.lang.Object... args)
                                                                         throws java.sql.SQLException
        Executes a SELECT statement that returns one row.
        Parameters:
        sql - The SQL
        args - The arguments to be set on the statement.
        Returns:
        The row expected.
        Throws:
        java.sql.SQLException - If less or more than one row is returned
      • selectAll

        public java.util.List<java.util.Map<java.lang.String,​java.lang.Object>> selectAll​(java.lang.String sql,
                                                                                                java.lang.Object... args)
                                                                                         throws java.sql.SQLException
        Executes a SELECT statement that returns multiple rows.
        Parameters:
        sql - The SQL
        args - The arguments to be set on the statement.
        Returns:
        The list of rows expected.
        Throws:
        java.sql.SQLException - If statement preparation or execution fails
      • insert

        public int insert​(java.lang.String sql,
                          java.lang.Object... args)
                   throws java.sql.SQLException
        Executes an INSERT statement.
        Parameters:
        sql - The SQL
        args - The arguments to be set on the statement.
        Returns:
        The number of rows impacted or BATCHED_RESULTS if the statements are being batched.
        Throws:
        java.sql.SQLException - If statement preparation or execution fails
      • update

        public int update​(java.lang.String sql,
                          java.lang.Object... args)
                   throws java.sql.SQLException
        Executes an UPDATE statement.
        Parameters:
        sql - The SQL
        args - The arguments to be set on the statement.
        Returns:
        The number of rows impacted or BATCHED_RESULTS if the statements are being batched.
        Throws:
        java.sql.SQLException - If statement preparation or execution fails
      • delete

        public int delete​(java.lang.String sql,
                          java.lang.Object... args)
                   throws java.sql.SQLException
        Executes a DELETE statement.
        Parameters:
        sql - The SQL
        args - The arguments to be set on the statement.
        Returns:
        The number of rows impacted or BATCHED_RESULTS if the statements are being batched.
        Throws:
        java.sql.SQLException - If statement preparation or execution fails
      • run

        public void run​(java.lang.String sql)
                 throws java.sql.SQLException
        Executes any string as a JDBC Statement. Good for DDL
        Parameters:
        sql - The SQL
        Throws:
        java.sql.SQLException - If statement preparation or execution fails
      • closeConnection

        public void closeConnection()