public OrderBean viewOrder(String orderNo) throws SQLException, ClassNotFoundException {
			ConnectionUtility chd = new ConnectionUtility();
			Connection con = null;
			PreparedStatement ps = null,ps1 = null;
			ResultSet rs=null,rs1 = null;
			OrderBean orderItem = new OrderBean();
			ArrayList<ItemBean> itemList = new ArrayList<ItemBean>();
			try  {
		        con = chd.create();	
		    	ps =con.prepareStatement("select itemname,qty,price from Orderlist where orderno = '"+orderNo+"' ");
		    	rs=ps.executeQuery();	
		    	while(rs.next())
		    	{
					ItemBean item = new ItemBean();
	                item.setItemName(rs.getString(1));
                    item.setQty(rs.getInt(2));
	                item.setPrice(rs.getDouble(3));
	        	    itemList.add(item);
		   	  	    item = null;
		    	}
		    	orderItem.setItemList(itemList);
		    	ps1 =con.prepareStatement("select * from OrderDetails where orderno = '"+orderNo+"' ");
		    	rs1 =ps1.executeQuery();
		    	while(rs1.next()) {
		    		orderItem.setOrderNo(rs1.getString(1));
		    		orderItem.setOrderdate(rs1.getDate(2));
		    		orderItem.setTotalAmount(rs1.getDouble(4));
		    		orderItem.setStatus(rs1.getString(5));
		    	}
			} catch(Exception e) {
				e.printStackTrace();
			}
			finally {
				 try  {
					con.close();   
				 } catch(Exception e) {
					e.printStackTrace();
				 }
			}
			return orderItem;      
		}