private static boolean deleteDrug(Drug bean, PreparedStatement stmt) throws SQLException{
		
		stmt.setInt(1, bean.getDrugId());
		int affected=stmt.executeUpdate();	
		
		if(affected==1){
			System.out.println("Drug with ID "+bean.getDrugId()+" has been Removed from database.");
		} else {
			System.out.println("unable to remove Drug from database");
			return false;
		}	
		return true;
	}