Package com.commander4j.db

Examples of com.commander4j.db.JDBTable

52
53
54
55
56
57
58
59
60
61
62
   *
   * @return boolean
   */
  public static boolean qmInspections() {
    String schemaName = Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDatabaseSchema();
    JDialogLookup.dlg_table = new JDBTable(Common.selectedHostID, Common.sessionID, JUtility.substSchemaName(schemaName, "{schema}APP_QM_INSPECTION"));
    JDialogLookup.dlg_title = "Inspections";

    JDialogLookup.dlg_key_field_name = "inspection_id";
    JDialogLookup.dlg_criteria_field_name_default = "description";
    JDialogLookup.dlg_orderBy_name_default = "inspection_id";
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
   *
   * @return boolean
   */
  public static boolean processOrders() {
    String schemaName = Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDatabaseSchema();
    JDialogLookup.dlg_table = new JDBTable(Common.selectedHostID, Common.sessionID, JUtility.substSchemaName(schemaName, "{schema}APP_PROCESS_ORDER"));
    JDialogLookup.dlg_title = "Process Orders";

    JDialogLookup.dlg_key_field_name = "process_order";
    JDialogLookup.dlg_criteria_field_name_default = "status";
    JDialogLookup.dlg_orderBy_name_default = "due_date";
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
  }

 
  public static boolean users() {
    String schemaName = Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDatabaseSchema();
    JDialogLookup.dlg_table = new JDBTable(Common.selectedHostID, Common.sessionID, JUtility.substSchemaName(schemaName, "{schema}SYS_USERS"));
    JDialogLookup.dlg_title = "Users";

    JDialogLookup.dlg_key_field_name = "user_id";
    JDialogLookup.dlg_criteria_field_name_default = "USER_COMMENT";
    JDialogLookup.dlg_orderBy_name_default = "USER_COMMENT";
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
  }
 

  public static boolean groups() {
    String schemaName = Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDatabaseSchema();
    JDialogLookup.dlg_table = new JDBTable(Common.selectedHostID, Common.sessionID, JUtility.substSchemaName(schemaName, "{schema}SYS_GROUPS"));
    JDialogLookup.dlg_title = "Groups";

    JDialogLookup.dlg_key_field_name = "group_id";
    JDialogLookup.dlg_criteria_field_name_default = "description";
    JDialogLookup.dlg_orderBy_name_default = "description";
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
   *
   * @return boolean
   */
  public static boolean locations() {
    String schemaName = Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDatabaseSchema();
    JDialogLookup.dlg_table = new JDBTable(Common.selectedHostID, Common.sessionID, JUtility.substSchemaName(schemaName, "{schema}APP_LOCATION"));
    JDialogLookup.dlg_title = "Locations";

    JDialogLookup.dlg_key_field_name = "location_id";
    JDialogLookup.dlg_criteria_field_name_default = "enabled";
    JDialogLookup.dlg_orderBy_name_default = "description";
View Full Code Here
174
175
176
177
178
179
180
181
182
183
184
    return JDialogLookup.dlg_selected;
  }

  public static boolean modules() {
    String schemaName = Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDatabaseSchema();
    JDialogLookup.dlg_table = new JDBTable(Common.selectedHostID, Common.sessionID, JUtility.substSchemaName(schemaName, "{schema}SYS_MODULES"));
    JDialogLookup.dlg_title = "Modules";

    JDialogLookup.dlg_key_field_name = "MODULE_ID";
    JDialogLookup.dlg_criteria_field_name_default = "MODULE_TYPE";
    JDialogLookup.dlg_orderBy_name_default = "MODULE_ID";
View Full Code Here
196
197
198
199
200
201
202
203
204
205
206
    return JDialogLookup.dlg_selected;
  } 
 
  public static boolean reasons() {
    String schemaName = Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDatabaseSchema();
    JDialogLookup.dlg_table = new JDBTable(Common.selectedHostID, Common.sessionID, JUtility.substSchemaName(schemaName, "{schema}APP_MHN_REASONS"));
    JDialogLookup.dlg_title = "Reasons";

    JDialogLookup.dlg_key_field_name = "reason";
    JDialogLookup.dlg_criteria_field_name_default = "DESCRIPTION";
    JDialogLookup.dlg_orderBy_name_default = "REASON";
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
    return JDialogLookup.dlg_selected;
  }
 
  public static boolean customers() {
    String schemaName = Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDatabaseSchema();
    JDialogLookup.dlg_table = new JDBTable(Common.selectedHostID, Common.sessionID, JUtility.substSchemaName(schemaName, "{schema}APP_CUSTOMER"));
    JDialogLookup.dlg_title = "Customers";

    JDialogLookup.dlg_key_field_name = "customer_id";
    JDialogLookup.dlg_criteria_field_name_default = "customer_id";
    JDialogLookup.dlg_orderBy_name_default = "customer_name";
View Full Code Here
245
246
247
248
249
250
251
252
253
254
255
   *
   * @return boolean
   */
  public static boolean materials() {
    String schemaName = Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDatabaseSchema();
    JDialogLookup.dlg_table = new JDBTable(Common.selectedHostID, Common.sessionID, JUtility.substSchemaName(schemaName, "{schema}APP_MATERIAL"));
    JDialogLookup.dlg_title = "Materials";

    JDialogLookup.dlg_key_field_name = "material";
    JDialogLookup.dlg_criteria_field_name_default = "description";
    JDialogLookup.dlg_orderBy_name_default = "material_type";
View Full Code Here
271
272
273
274
275
276
277
278
279
280
281
   *
   * @return boolean
   */
  public static boolean materialBatches() {
    String schemaName = Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDatabaseSchema();
    JDialogLookup.dlg_table = new JDBTable(Common.selectedHostID, Common.sessionID, JUtility.substSchemaName(schemaName, "{schema}APP_MATERIAL_BATCH"));
    JDialogLookup.dlg_title = "Material Batches";

    JDialogLookup.dlg_key_field_name = "batch_number";
    JDialogLookup.dlg_criteria_field_name_default = "material";
    JDialogLookup.dlg_orderBy_name_default = "expiry_date";
View Full Code Here
TOP

Related Classes of com.commander4j.db.JDBTable

  • com.commander4j.sys.JLaunchLookup
  • java.sql.ResultSetMetaData
  • java.sql.ResultSet
  • java.sql.PreparedStatement
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.