Package com.commander4j.db

Examples of com.commander4j.db.JDBQuery


    JDBQuery.closeStatement(listStatement);
   
    String temp = "";

    JDBQuery query = new JDBQuery(Common.selectedHostID, Common.sessionID);
    query.clear();

    temp = "select * from {schema}SYS_LANGUAGE";
    query.addText(JUtility.substSchemaName(schemaName, temp));

    if (textFieldText.getText().equals("") == false)
    {
      query.addParamtoSQL("text like ", "%" + textFieldText.getText() + "%");
    }

    if (textFieldResourceKey.getText().equals("") == false)
    {
      query.addParamtoSQL("resource_key like ", "%" + textFieldResourceKey.getText() + "%");
    }

    if (textFieldMnemonic.getText().equals("") == false)
    {
      query.addParamtoSQL("mnemonic = ", textFieldMnemonic.getText());
    }

    query.addParamtoSQL("language_id = ", ((String) comboBoxLanguageID.getSelectedItem()).toString());

    query.appendSort("resource_key,language_id", "asc");

    query.bindParams();
    listStatement = query.getPreparedStatement();
  }
View Full Code Here


  {
    super();
    setIconifiable(true);
    initGUI();

    JDBQuery query = new JDBQuery(Common.selectedHostID, Common.sessionID);
    query.clear();
    query.addText(JUtility.substSchemaName(schemaName, "select * from {schema}SYS_INTERFACE where 1=2"));
    query.bindParams();
    listStatement = query.getPreparedStatement();
    populateList();

    final JHelp help = new JHelp();
    help.enableHelpOnButton(jButtonHelp, JUtility.getHelpSetIDforModule("FRM_ADMIN_INTERFACE"));

View Full Code Here

  private void buildSQL() {

    JDBQuery.closeStatement(listStatement);
   
    JDBQuery query = new JDBQuery(Common.selectedHostID, Common.sessionID);
    query.clear();

    query.addText(JUtility.substSchemaName(schemaName, "select * from {schema}SYS_INTERFACE"));
    query.addParamtoSQL("interface_type=", jTextFieldinterfaceType.getText());
    query.addParamtoSQL("path=", jTextFieldPath.getText());
    query.addParamtoSQL("interface_direction=", jComboBoxInterfaceDirection.getSelectedItem().toString());
   
    query.appendSort(jComboBoxSortBy.getSelectedItem().toString(), jToggleButtonSequence.isSelected());

    query.bindParams();
    listStatement = query.getPreparedStatement();
  }
View Full Code Here

  public JInternalFrameInterfaceRequestAdmin()
  {
    super();
    initGUI();

    JDBQuery query = new JDBQuery(Common.selectedHostID, Common.sessionID);
    query.clear();
    query.addText(JUtility.substSchemaName(schemaName, "select * from {schema}SYS_INTERFACE_REQUEST where 1=2"));
    query.bindParams();
    listStatement = query.getPreparedStatement();
    populateList();

    final JHelp help = new JHelp();
    help.enableHelpOnButton(jButtonHelp, JUtility.getHelpSetIDforModule("FRM_ADMIN_INTERFACE_REQUEST"));

View Full Code Here

  private void buildSQL() {
   
    JDBQuery.closeStatement(listStatement);

    JDBQuery query = new JDBQuery(Common.selectedHostID, Common.sessionID);
    query.clear();

    query.addText(JUtility.substSchemaName(schemaName, "select * from {schema}SYS_INTERFACE_REQUEST"));

    query.addParamtoSQL("interface_type=", (String) comboInterfaceType.getSelectedItem());

    query.addParamtoSQL("status=", (String) comboStatus.getSelectedItem());

    query.appendSort(jComboBoxSortBy.getSelectedItem().toString(), jToggleButtonSequence.isSelected());
    query.applyRestriction(false,"none", 0);


    query.bindParams();
    listStatement = query.getPreparedStatement();
  }
View Full Code Here

    JDBQuery.closeStatement(listStatement);
   
    String temp = "";

    JDBQuery query = new JDBQuery(Common.selectedHostID, Common.sessionID);
    query.clear();

    temp = Common.hostList.getHost(Common.selectedHostID).getSqlstatements().getSQL("JDBProcessOrder.selectWithLimit");

    query.addText(temp);

    if (lprocessOrder.equals("") == false)
    {
      query.addParamtoSQL("process_order = ", lprocessOrder);
    }
    query.applyRestriction(false, "none", 0);
    query.bindParams();
    listStatement =  query.getPreparedStatement();
 
View Full Code Here

    JDBQuery.closeStatement(listStatement);

    String temp = "";

    JDBQuery query = new JDBQuery(Common.selectedHostID, Common.sessionID);
    query.clear();

    temp = Common.hostList.getHost(Common.selectedHostID).getSqlstatements().getSQL("JDBQMSample.selectWithLimit");

    query.addText(temp);

    query.addParamtoSQL("sample_id = ", sampleID);

    query.applyRestriction(false, "none", 0);
    query.bindParams();
    listStatement = query.getPreparedStatement();
  }
View Full Code Here

  public JInternalFrameInterfaceRequestAdmin()
  {
    super();
    initGUI();

    JDBQuery query = new JDBQuery(Common.selectedHostID, Common.sessionID);
    query.clear();
    query.addText(JUtility.substSchemaName(schemaName, "select * from {schema}SYS_INTERFACE_REQUEST where 1=2"));
    query.bindParams();
    listStatement = query.getPreparedStatement();
    populateList();

    final JHelp help = new JHelp();
    help.enableHelpOnButton(jButtonHelp, JUtility.getHelpSetIDforModule("FRM_ADMIN_INTERFACE_REQUEST"));

View Full Code Here

  private void buildSQL() {
   
    JDBQuery.closeStatement(listStatement);

    JDBQuery query = new JDBQuery(Common.selectedHostID, Common.sessionID);
    query.clear();

    query.addText(JUtility.substSchemaName(schemaName, "select * from {schema}SYS_INTERFACE_REQUEST"));

    query.addParamtoSQL("interface_type=", (String) comboInterfaceType.getSelectedItem());

    query.addParamtoSQL("status=", (String) comboStatus.getSelectedItem());

    query.appendSort(jComboBoxSortBy.getSelectedItem().toString(), jToggleButtonSequence.isSelected());
    query.applyRestriction(false,"none", 0);


    query.bindParams();
    listStatement = query.getPreparedStatement();
  }
View Full Code Here

  private void buildSQL()
  {

    JDBQuery.closeStatement(listStatement);
    JDBQuery query = new JDBQuery(Common.selectedHostID, Common.sessionID);

    query.clear();
    String schemaName = Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDatabaseSchema();
    query.addText(JUtility.substSchemaName(schemaName, "select * from {schema}APP_AUTO_LABELLER order by line"));
    query.applyRestriction(false, "none", 0);
    query.bindParams();

    listStatement = query.getPreparedStatement();
  }
View Full Code Here

TOP

Related Classes of com.commander4j.db.JDBQuery

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.