Package samuelal.squelized

Class QueryBuilder

  • public class QueryBuilder
extends java.lang.Object
    Helper class to support CRUD database operations using SqlQueryBuilder library
    Author:
    Samuel Alarco Cantos

    • Field Summary

      Fields 
      Modifier and Type Field Description
      (package private) static com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema dbSchema  
      (package private) static com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec dbSpecs  

    • Constructor Summary

      Constructors 
      Constructor Description
      QueryBuilder()  

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static java.lang.String createTable​(java.lang.String tableName, java.lang.String[] columnNames, int[] columnTypes, java.lang.Integer[] columnLength)
      Generates query to create new table in database
      static java.lang.String displayAllTableRecords​(java.lang.String tableName)
      Generates query to display all records in a specified table.
      static java.lang.String displayRecords​(java.lang.String tableName, java.lang.String[] columns)
      Generates query to display records from specific columns in specified table.
      static java.lang.String displayRecords​(java.lang.String tableName, java.lang.String[] columns, java.lang.String orderColumn, boolean ascending)
      Generates query to display records from specific columns in specifed table, ordering results according to contents of specific column
      static java.lang.String insertData​(java.lang.String tableName, java.lang.String[] columns, java.lang.Object[] data)
      Generates query to insert a single row of data into specified columns.

      • Methods inherited from class java.lang.Object

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

    • Field Detail

      • dbSchema

        static com.healthmarketscience.sqlbuilder.dbspec.basic.DbSchema dbSchema

      • dbSpecs

        static com.healthmarketscience.sqlbuilder.dbspec.basic.DbSpec dbSpecs

    • Constructor Detail

      • QueryBuilder

        public QueryBuilder()

    • Method Detail

      • createTable

        public static java.lang.String createTable​(java.lang.String tableName,
                                           java.lang.String[] columnNames,
                                           int[] columnTypes,
                                           java.lang.Integer[] columnLength)
        Generates query to create new table in database
        Parameters:
        tableName -
        columnNames -
        columnTypes -
        columnLength -
        Returns:
        query string

      • insertData

        public static java.lang.String insertData​(java.lang.String tableName,
                                          java.lang.String[] columns,
                                          java.lang.Object[] data)
        Generates query to insert a single row of data into specified columns.
        Parameters:
        tableName -
        columns -
        data -
        Returns:
        query string

      • displayAllTableRecords

        public static java.lang.String displayAllTableRecords​(java.lang.String tableName)
        Generates query to display all records in a specified table.
        Parameters:
        tableName -
        Returns:
        query string

      • displayRecords

        public static java.lang.String displayRecords​(java.lang.String tableName,
                                              java.lang.String[] columns)
        Generates query to display records from specific columns in specified table.
        Parameters:
        tableName -
        columns -
        Returns:
        query string

      • displayRecords

        public static java.lang.String displayRecords​(java.lang.String tableName,
                                              java.lang.String[] columns,
                                              java.lang.String orderColumn,
                                              boolean ascending)
        Generates query to display records from specific columns in specifed table, ordering results according to contents of specific column
        Parameters:
        tableName -
        columns -
        orderColumn -
        ascending -
        Returns:
        query string