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; }
@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()); }
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; }