Package stanford.netdb.middleware
Class DB_TXTrecord
- java.lang.Object
-
- stanford.netdb.logging.NetDB_Logger
-
- stanford.netdb.middleware.DB_Statement
-
- stanford.netdb.middleware.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
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class stanford.netdb.middleware.DB_Statement
DB_Statement.STATEMENT_TYPE
-
-
Field Summary
Fields Modifier and Type Field Description static longserialVersionUID-
Fields inherited from class stanford.netdb.middleware.DB_Statement
ORA_FUN_CALL, ORA_PROC_CALL, SELECT
-
-
Constructor Summary
Constructors Constructor Description DB_TXTrecord()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description DB_Statementadmin(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_Statementadmin(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_Statementadmin(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_Statementadmin(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_Statementadmin(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_Statementadmin(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_Statementadmin(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_Statementadmin(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_Statementadmin(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_Statementadmin(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_Statementadmin(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_Statementadmin(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_Statementdelete(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.Stringget_SQL(java.lang.String schema)Generate a SQL string with the appropriate values set for each argument.DB_Statementhandle(java.lang.Long p_txt_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinfo(java.lang.Long p_txt_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinsert(java.lang.Long p_op_uid, java.lang.String p_txt_name)Generate the arguments for the corresponding stored procedure in the database.DB_Statementinsert(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_Statementlock_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_Statementlocked_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_Statementunlock_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_Statementupdate(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_Statementupdate(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_Statementverify_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_Statementverify_or_die()Generate the arguments for the corresponding stored procedure in the database.DB_Statementverify_or_die(java.lang.Long p_txt_id)Generate the arguments for the corresponding stored procedure in the database.DB_Statementverify_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_Statementverify_or_die(java.lang.String p_txt_name)Generate the arguments for the corresponding stored procedure in the database.-
Methods inherited from class stanford.netdb.middleware.DB_Statement
get_first_out_param, get_next_out_param, get_parameter_name, get_type, get_values, statement_max_tries, statement_max_tries, statement_timeout, statement_timeout, toString
-
Methods inherited from class stanford.netdb.logging.NetDB_Logger
default_logger, default_logger, logger, logger
-
-
-
-
Field Detail
-
serialVersionUID
public static final long serialVersionUID
- See Also:
- Constant Field Values
-
-
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.
-
-