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;
}
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;
}
