public ItemBean viewItem(String itemno) throws SQLException, ClassNotFoundException {
		ConnectionUtility chd = new ConnectionUtility();
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs=null;
		ItemBean item = new ItemBean();
		try {		    	
		     con = chd.create();	
		     ps =con.prepareStatement("select * from Items where itemno = '"+itemno+"' ");
		     rs=ps.executeQuery();	
		     while(rs.next()) {
	              item.setItemNo(rs.getString(1));
	              item.setItemName(rs.getString(2));
	              item.setDescription(rs.getString(3));
	              item.setPrice(rs.getDouble(4));
	              item.setStatus(rs.getString(5));
		     }		       
		} catch(Exception e) {
			e.printStackTrace();
		}
		finally {
			 try  {
				con.close();  
			 } catch(Exception e) {
				e.printStackTrace();
			 }
		}
	    return item; 		          
	}