Class DB_TXTrecord

  • All Implemented Interfaces:
    java.io.Serializable

    public class DB_TXTrecord
    extends DB_Statement
    This class generates the SQL that is called in the database. Each method sets up the necessary variables containing the argument names and types, in the format that NetDB_Connection expects.
    See Also:
    NetDB_Connection, Serialized Form
    • Constructor Summary

      Constructors 
      Constructor Description
      DB_TXTrecord()  
    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.Long p_person_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.Long p_ateam_id, java.lang.Long p_person_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.Long p_ateam_id, java.lang.Long p_person_id, java.lang.String p_regid)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.Long p_person_id, java.lang.String p_regid)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.Long p_ateam_id, java.lang.String p_ateam, java.lang.Long p_person_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.Long p_ateam_id, java.lang.String p_ateam, java.lang.Long p_person_id, java.lang.String p_regid)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.Long p_ateam_id, java.lang.String p_ateam, java.lang.String p_regid)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.String p_regid)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.String p_ateam, java.lang.Long p_person_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.String p_ateam, java.lang.Long p_person_id, java.lang.String p_regid)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement admin​(java.lang.String p_action, java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.String p_ateam, java.lang.String p_regid)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement delete​(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id)
      Generate the arguments for the corresponding stored procedure in the database.
      java.lang.String get_SQL​(java.lang.String schema)
      Generate a SQL string with the appropriate values set for each argument.
      DB_Statement handle​(java.lang.Long p_txt_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement info​(java.lang.Long p_txt_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement insert​(java.lang.Long p_op_uid, java.lang.String p_txt_name)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement insert​(java.lang.Long p_op_uid, java.lang.String p_txt_name, java.lang.String p_comment)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement lock_record​(java.lang.Long p_op_uid, java.lang.Long p_txt_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement locked_or_die​(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement unlock_record​(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement update​(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement update​(java.lang.Long p_op_uid, java.sql.Timestamp p_lock, java.lang.Long p_txt_id, java.lang.String p_comment)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement verify_and_log​(java.lang.Long p_op_uid, java.lang.Long p_txt_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement verify_or_die()
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement verify_or_die​(java.lang.Long p_txt_id)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement verify_or_die​(java.lang.Long p_txt_id, java.lang.String p_txt_name)
      Generate the arguments for the corresponding stored procedure in the database.
      DB_Statement verify_or_die​(java.lang.String p_txt_name)
      Generate the arguments for the corresponding stored procedure in the database.
      • Methods inherited from class java.lang.Object

        equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
    • Constructor Detail

      • DB_TXTrecord

        public DB_TXTrecord()
    • Method Detail

      • get_SQL

        public java.lang.String get_SQL​(java.lang.String schema)
        Generate a SQL string with the appropriate values set for each argument.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id,
                                  java.lang.Long p_ateam_id,
                                  java.lang.String p_ateam,
                                  java.lang.Long p_person_id,
                                  java.lang.String p_regid)
        Generate the arguments for the corresponding stored procedure in the database.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id,
                                  java.lang.String p_ateam,
                                  java.lang.Long p_person_id,
                                  java.lang.String p_regid)
        Generate the arguments for the corresponding stored procedure in the database.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id,
                                  java.lang.Long p_person_id,
                                  java.lang.String p_regid)
        Generate the arguments for the corresponding stored procedure in the database.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id,
                                  java.lang.String p_regid)
        Generate the arguments for the corresponding stored procedure in the database.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id,
                                  java.lang.Long p_person_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id,
                                  java.lang.String p_ateam,
                                  java.lang.String p_regid)
        Generate the arguments for the corresponding stored procedure in the database.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id,
                                  java.lang.String p_ateam,
                                  java.lang.Long p_person_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id,
                                  java.lang.Long p_ateam_id,
                                  java.lang.Long p_person_id,
                                  java.lang.String p_regid)
        Generate the arguments for the corresponding stored procedure in the database.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id,
                                  java.lang.Long p_ateam_id,
                                  java.lang.Long p_person_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id,
                                  java.lang.Long p_ateam_id,
                                  java.lang.String p_ateam,
                                  java.lang.String p_regid)
        Generate the arguments for the corresponding stored procedure in the database.
      • admin

        public DB_Statement admin​(java.lang.String p_action,
                                  java.lang.Long p_op_uid,
                                  java.sql.Timestamp p_lock,
                                  java.lang.Long p_txt_id,
                                  java.lang.Long p_ateam_id,
                                  java.lang.String p_ateam,
                                  java.lang.Long p_person_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • delete

        public DB_Statement delete​(java.lang.Long p_op_uid,
                                   java.sql.Timestamp p_lock,
                                   java.lang.Long p_txt_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • handle

        public DB_Statement handle​(java.lang.Long p_txt_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • info

        public DB_Statement info​(java.lang.Long p_txt_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • insert

        public DB_Statement insert​(java.lang.Long p_op_uid,
                                   java.lang.String p_txt_name,
                                   java.lang.String p_comment)
        Generate the arguments for the corresponding stored procedure in the database.
      • insert

        public DB_Statement insert​(java.lang.Long p_op_uid,
                                   java.lang.String p_txt_name)
        Generate the arguments for the corresponding stored procedure in the database.
      • lock_record

        public DB_Statement lock_record​(java.lang.Long p_op_uid,
                                        java.lang.Long p_txt_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • locked_or_die

        public DB_Statement locked_or_die​(java.lang.Long p_op_uid,
                                          java.sql.Timestamp p_lock,
                                          java.lang.Long p_txt_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • unlock_record

        public DB_Statement unlock_record​(java.lang.Long p_op_uid,
                                          java.sql.Timestamp p_lock,
                                          java.lang.Long p_txt_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • update

        public DB_Statement update​(java.lang.Long p_op_uid,
                                   java.sql.Timestamp p_lock,
                                   java.lang.Long p_txt_id,
                                   java.lang.String p_comment)
        Generate the arguments for the corresponding stored procedure in the database.
      • update

        public DB_Statement update​(java.lang.Long p_op_uid,
                                   java.sql.Timestamp p_lock,
                                   java.lang.Long p_txt_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • verify_and_log

        public DB_Statement verify_and_log​(java.lang.Long p_op_uid,
                                           java.lang.Long p_txt_id)
        Generate the arguments for the corresponding stored procedure in the database.
      • verify_or_die

        public DB_Statement verify_or_die​(java.lang.Long p_txt_id,
                                          java.lang.String p_txt_name)
        Generate the arguments for the corresponding stored procedure in the database.
      • verify_or_die

        public DB_Statement verify_or_die​(java.lang.String p_txt_name)
        Generate the arguments for the corresponding stored procedure in the database.
      • verify_or_die

        public DB_Statement verify_or_die()
        Generate the arguments for the corresponding stored procedure in the database.
      • verify_or_die

        public DB_Statement verify_or_die​(java.lang.Long p_txt_id)
        Generate the arguments for the corresponding stored procedure in the database.