Example #1
0
 public ArrayList<MenuData> getItems(String start, String limit) {
   ArrayList<MenuData> menuDataList = new ArrayList<MenuData>();
   try {
     Class.forName(JDBC_DRIVER);
     // STEP 3: Open a connection
     System.out.println("Connecting to database...");
     conn = DriverManager.getConnection(DB_URL, USER, PASS);
     stmt = conn.createStatement();
     sql = "Select * from menuitem where menu_id is null";
     ResultSet rs = stmt.executeQuery(sql);
     while (rs.next()) {
       MenuData menuData = new MenuData();
       menuData.setLeaf(false);
       menuData.setId(rs.getInt("id"));
       menuData.setText(rs.getString("text"));
       menuData.setIconCls(rs.getString("iconCls"));
       menuDataList.add(menuData);
     }
     rs.close();
     stmt.close();
     stmt = null;
     conn.close();
     conn = null;
   } catch (Exception e) {
     System.out.println(e);
   } finally {
     if (stmt != null) {
       try {
         stmt.close();
       } catch (SQLException sqlex) {
         // ignore -- as we can't do anything about it here
       }
       stmt = null;
     }
     if (conn != null) {
       try {
         conn.close();
       } catch (SQLException sqlex) {
         // ignore -- as we can't do anything about it here
       }
       conn = null;
     }
   }
   return menuDataList;
 }
Example #2
0
 @Override
 public void setMenuData(MenuData<T> menuData) {
   this.menuData = menuData;
   jDotlan.setEnabled(
       !menuData.getStations().isEmpty()
           || !menuData.getSystems().isEmpty()
           || !menuData.getRegions().isEmpty());
   jDotlanStation.setEnabled(!menuData.getStations().isEmpty());
   jDotlanSystem.setEnabled(!menuData.getSystems().isEmpty());
   jDotlanRegion.setEnabled(!menuData.getRegions().isEmpty());
   jEveCentral.setEnabled(!menuData.getMarketTypeIDs().isEmpty());
   jEveMarketdata.setEnabled(!menuData.getMarketTypeIDs().isEmpty());
   // Dead
   // jEveMarketeer.setEnabled(!menuData.getMarketTypeIDs().isEmpty());
   jEveMarkets.setEnabled(!menuData.getMarketTypeIDs().isEmpty());
   // Dead
   // jEveAddicts.setEnabled(!menuData.getMarketTypeIDs().isEmpty());
   jChruker.setEnabled(!menuData.getTypeIDs().isEmpty());
   jEveOnline.setEnabled(!menuData.getTypeNames().isEmpty());
 }
Example #3
0
  public static ArrayList<MenuData> getItems() {
    // bypassing data fetch from DB for testing purpose
    ArrayList<MenuData> menuDataList = new ArrayList<MenuData>();
    MenuData menuData = new MenuData();
    menuData.setLeaf(false);
    menuData.setId(10023);
    menuData.setText("This is a sample text.");
    menuData.setIconCls("testIconCls");
    menuDataList.add(menuData);
    menuData.setLeaf(false);
    menuData.setId(10083);
    menuData.setText("This is a sample text2.");
    menuData.setIconCls("testIconCls2");
    menuDataList.add(menuData);
    menuData.setLeaf(false);
    menuData.setId(10073);
    menuData.setText("This is a sample text3.");
    menuData.setIconCls("testIconCls3");
    menuDataList.add(menuData);

    return menuDataList;
  }