Package com.commander4j.db

Examples of com.commander4j.db.JDBQMSelectList

67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
 
  private void populateList(String defaultid,String defaultval) {

    DefaultComboBoxModel DefComboBoxMod = new DefaultComboBoxModel();

    JDBQMSelectList tempSelectList = new JDBQMSelectList(Common.selectedHostID, Common.sessionID);

    tempSelectList.setDisplayModeLong(true);
    LinkedList<JDBQMSelectList> tempList = tempSelectList.getSelectLists();
    int sel = -1;
    for (int j = 0; j < tempList.size(); j++)
    {
      JDBQMSelectList t = (JDBQMSelectList) tempList.get(j);
      DefComboBoxMod.addElement(t);
      if (t.getSelectListID().equals(defaultid) & (t.getSelectListID().equals(defaultval)))
      {
        sel = j;
      }
    }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
108
109
      llistid = ((JDBQMSelectList) jListSelectLists.getSelectedValue()).getSelectListID();
      llistval = ((JDBQMSelectList) jListSelectLists.getSelectedValue()).getValue();
      int question = JOptionPane.showConfirmDialog(Common.mainForm, lang.get("dlg_SelectList_Delete") + " " + llistid + "/" + llistval +" ?", lang.get("dlg_Confirm"), JOptionPane.YES_NO_OPTION);
      if (question == 0)
      {
        JDBQMSelectList u = new JDBQMSelectList(Common.selectedHostID, Common.sessionID);
        u.setSelectListID(llistid);
        u.setValue(llistval);
        u.delete();
        populateList("","");
      }
    }
  }
View Full Code Here
280
281
282
283
284
285
286
287
288
289
290
291
292
293
    }
  }
 
  private void excel()
  {
    JDBQMSelectList slist = new JDBQMSelectList(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    PreparedStatement ps = slist.getSelectListPreparedStatement();
    export.saveAs("qm_selectlist.xls", slist.getQMSelectListResultSet(ps), Common.mainForm);
    try
    {
      ps.close();
    } catch (SQLException e)
    {
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
 
  private void populateList(String defaultid,String defaultval) {

    DefaultComboBoxModel<JDBQMSelectList> DefComboBoxMod = new DefaultComboBoxModel<JDBQMSelectList>();

    JDBQMSelectList tempSelectList = new JDBQMSelectList(Common.selectedHostID, Common.sessionID);

    tempSelectList.setDisplayModeLong(true);
    LinkedList<JDBQMSelectList> tempList = tempSelectList.getSelectLists();
    int sel = -1;
    for (int j = 0; j < tempList.size(); j++)
    {
      JDBQMSelectList t = (JDBQMSelectList) tempList.get(j);
      DefComboBoxMod.addElement(t);
      if (t.getSelectListID().equals(defaultid) & (t.getSelectListID().equals(defaultval)))
      {
        sel = j;
      }
    }
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
107
108
      llistid = ((JDBQMSelectList) jListSelectLists.getSelectedValue()).getSelectListID();
      llistval = ((JDBQMSelectList) jListSelectLists.getSelectedValue()).getValue();
      int question = JOptionPane.showConfirmDialog(Common.mainForm, lang.get("dlg_SelectList_Delete") + " " + llistid + "/" + llistval +" ?", lang.get("dlg_Confirm"), JOptionPane.YES_NO_OPTION, 0, Common.icon_confirm);
      if (question == 0)
      {
        JDBQMSelectList u = new JDBQMSelectList(Common.selectedHostID, Common.sessionID);
        u.setSelectListID(llistid);
        u.setValue(llistval);
        u.delete();
        populateList("","");
      }
    }
  }
View Full Code Here
279
280
281
282
283
284
285
286
287
288
289
290
291
292
    }
  }
 
  private void excel()
  {
    JDBQMSelectList slist = new JDBQMSelectList(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    PreparedStatement ps = slist.getSelectListPreparedStatement();
    export.saveAs("qm_selectlist.xls", slist.getQMSelectListResultSet(ps), Common.mainForm);
    try
    {
      ps.close();
    } catch (SQLException e)
    {
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
    setSession(sessionid);

    tableMode = mode;
    test = new JDBQMTest(getHost(), getSession());
    new JDBQMDictionary(getHost(), getSession());
    selectlist = new JDBQMSelectList(getHost(), getSession());

    testPropertiesList = test.getTestsPropertiesList(inspectionid, activityid);

    getTableHeader().setFont(Common.font_table_header);
    getTableHeader().setForeground(Common.color_tableHeaderFont);
View Full Code Here
222
223
224
225
226
227
228
229
230
231
232
      if (tempDict.getDataType().equals("list"))
      {

        LinkedList<JDBQMSelectList> listValues = new LinkedList<JDBQMSelectList>();
        listValues = selectlist.getSelectList(tempDict.getSelectListID());
        JDBQMSelectList blank = new JDBQMSelectList();
        JComboBox comboBox = new JComboBox();
        comboBox.addItem(blank);

        for (int y = 0; y < listValues.size(); y++)
        {
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
    JDBQMDictionary tempDict;
    sample = new JDBQMSample(hostid, sessionid);
    test = new JDBQMTest(hostid, sessionid);

    res = new JDBQMResult(hostid, sessionid);
    select = new JDBQMSelectList(hostid, sessionid);
    testPropertiesList = test.getTestsPropertiesList(inspectionid, activityid);

    sampleList = sample.getSamples(processOrder, inspectionid, activityid);
    testList = test.getTests(inspectionid, activityid);
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
      if (testPropertiesList.get(col).getDataType().equals("list"))
      {
        try
        {
          JDBQMSelectList sl = new JDBQMSelectList();
          sl.setSelectListID(listID.get(col));
          sl.setValue(res.getValue());
          select.setSelectListID(listID.get(col));
          select.setValue(res.getValue());
          select.getProperties();
          sl.setDescription(select.getDescription());
          result = sl;
        } catch (Exception ex)
        {
          result = null;
        }
View Full Code Here
TOP

Related Classes of com.commander4j.db.JDBQMSelectList

  • com.commander4j.app.JInternalFrameQMSelectListAdmin
  • com.commander4j.table.JDBQMResultTable
  • com.commander4j.tablemodel.JDBQMResultTableModelData
  • 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.