public boolean changeItemStatus(String itemNo) throws SQLException, ClassNotFoundException {
			ConnectionUtility chd = new ConnectionUtility();
			Connection con = null;
			Statement st = null;
			PreparedStatement ps = null;
			ResultSet rs=null;
			boolean b = false;
			String defStatus = "available";
			try  {
		        con = chd.create();	
		        st = con.createStatement();
		        rs = st.executeQuery("select status from Items where itemno = '"+itemNo+"' ");
		        rs.next();
		        String status = rs.getString(1);
                if(defStatus.equals(status)) {
                	status = "unavailable";
                } else {
                	status = defStatus;
                }
		    	ps =con.prepareStatement("update items set status ='"+status+"' where itemno = '"+itemNo+"' ");
		    	int result = ps.executeUpdate();
		    	if(result>0) {
	              b= true;
		    	}
			} catch(Exception e) {
				e.printStackTrace();
			}
			finally {
				 try  {
					 con.commit(); 
					 con.close();   
				 } catch(Exception e) {
					e.printStackTrace();
				 }
			}
			return b;      
		}