Collecting ResultSet data and Comparing

[casid]

Hi everyone,

I have problem with Collecting data from sql query into Array or ArrayList and comparing them with outside values.

public void roomCheck()throws SQLException,ClassNotFoundException{
	
	
    String roo = jTextField11.getText();
   
	   
    try {
    	
    
		databaseConnection();
		
		stm=con.createStatement();
		rs=stm.executeQuery("select * from reservation");
		
        int room = Integer.parseInt(roo);
        
		while(rs.next()){
  
			ArrayList roomNumbers= new ArrayList();
			roomNumbers.add(rs.getInt("odano"));
             Iterator it=roomNumbers.iterator();
             
             while(it.hasNext()){
            	 
             if(it.next().equals(room)){
            	 
             JOptionPane.showMessageDialog(null,"Warning !!!! The room is full");
             }
             else{
            	 reservationAdd();
             }
             }
             }
	
		}
		catch(SQLException e){
			
			e.getCause();
		}
		stm.close();
		con.close();
		
	}

here my problem is ArrayList gets only one data, when I sort them with
System.out.println(it.next()) ;
I can see the datas without problem however when I compare them in if else condition, it compares only one data and pass directly reservationAdd() method.
even if condition is wrong else statements (reservationAdd()) running, how do you think I should go here ?

[Fubarable]

As noted in your previous thread, please don't cross-post the same question in multiple fora without providing links from one to the other. This goes against forum etiquette and may upset some forum members (many who would otherwise help you). Best of luck.

[mtyoung]

you have to consider data type
"1", 1 are different

[RamyaSivakanth]

Hi,
There are major logical loopholes in your code.
These things u need to do.
1.First,you catch everything into ArrayList.
ArrayList roomNumbers=null;
while(rs.next())
{
roomNumbers= new ArrayList();
roomNumbers.add(rs.getInt("odano"));
}
2.Then using for loop u check like this below

for(int i=0;i<roomNumbers.size();i++)
{
//check for roo not equal to null and check for integer then
if satisfied then typecast to int and retreive the arraylist value using rooNumbers.get(i) and convert to int and compare.
}

[casid]

Sorry at first I didint understand, for now I wont create two thread at the same topic
so Sorry, if you have chance to remove one ,go ahead, no problem I couldnt realize it.


thank you RamyaSivakanth, I will try it and tell the result.