public ArrayList<OrderBean> viewAllOrders() throws SQLException, ClassNotFoundException {
			ConnectionUtility chd = new ConnectionUtility();
			Connection con = null;
			PreparedStatement ps = null;
			ResultSet rs=null;
			ArrayList<OrderBean> orderList = new ArrayList<OrderBean>();
			try  {
		        con = chd.create();	
		    	ps =con.prepareStatement("select * from OrderDetails");
		    	rs =ps.executeQuery();
		    	while(rs.next()) {
		    		OrderBean orderItem = new OrderBean();
		    		orderItem.setOrderNo(rs.getString(1));
		    		orderItem.setOrderdate(rs.getDate(2));
		    		orderItem.setTotalAmount(rs.getDouble(4));
		    		orderItem.setStatus(rs.getString(5));
		    		orderList.add(orderItem);
		    		orderItem =null;
		    	}
			} catch(Exception e) {
				e.printStackTrace();
			}
			finally {
				 try  {
					con.close();   
				 } catch(Exception e) {
					e.printStackTrace();
				 }
			}
			return orderList;      
		}