Displaying record not exists

[Farakh khan]

Hello,

I am trying:
1) to print the cv_id that not exists in the database
2) to delete the cv_id records if exists in db

No. (2) is working but (1) not working

String  query="select cv_id from cv where cv_id=?";

	PreparedStatement ps=cnn.prepareStatement(query);
	for(i=0;i<cv_id.length;i++){
		ps.setString(1, cv_id[i]);
		rs=ps.executeQuery();
		if(rs.next()){
			String exists=rs.getString(1);		
			
		if(cv_id[i].equals("")){
			if(cv_id[i].equals(exists)){	
			
			PreparedStatement ps1=cnn.prepareStatement(query1);
			if(!cv_id[i].equals("")){
				ps1.setString(1, cv_id[i]);							
				ps1.executeUpdate();				
			}
			ps1.close();

			PreparedStatement ps2=cnn.prepareStatement(query2);
			if(!cv_id[i].equals("")){
				ps2.setString(1, cv_id[i]);							
				count+=ps2.executeUpdate();				
			}
			ps2.close();	
			
			}else{
			out.println("CV not exists "+cv_id[i]);
			}					
		}}
		
	}//for loop

	ps.close();

	cnn.commit();

Thanks & best regards>

[Bear Bibeault]

Please take the time to choose the correct forum for your posts. This forum is for questions on Servlets. For more information, please read this.

This post has been moved to a more appropriate forum.

[Jeanne Boyarsky]

That's a lot of nested if statements - you might want to extract some of them into separate methods.

In any case, check your indentations. I think the last else is mismatched. It should go with the first if logically, but in the code it does not.

[Farakh khan]

Now I consized the code but even not succeeded to run this simple code:

String  query="select cv_id from cv where cv_id=?";
PreparedStatement ps=cnn.prepareStatement(query);
	for(i=0;i<cv_id.length;i++){ 
		ps.setString(1, cv_id[i]);	
		rs=ps.executeQuery();
		if(rs.next()){
		String exists=rs.getString(1);		
		  					
			if(!cv_id[i].equals(exists)){				
			out.println(cv_id[i]+"CV not exists ");			
			}

			else if(cv_id[i].equals(exists)){				
			out.println(cv_id[i]+"CV exists ");			
			}

			else{
			out.println("Hello not working");
			}
		}	
	}

Thanks & best regards

[Jeanne Boyarsky]

String  query="select cv_id from cv where cv_id=?";
PreparedStatement ps=cnn.prepareStatement(query);
	for(i=0;i<cv_id.length;i++){ 
		ps.setString(1, cv_id[i]);	
		rs=ps.executeQuery();
		if(rs.next()){
		String exists=rs.getString(1);		
		  					
			if(!cv_id[i].equals(exists)){				
			out.println(cv_id[i]+"CV not exists ");			
			}

			else if(cv_id[i].equals(exists)){				
			out.println(cv_id[i]+"CV exists ");			
			}

		else{
		       out.println("Hello not working");
		}
	}	
}

Fixed indentation. You are correct that the else isn't the write spot now. Are you saying you don't get "Hello not working" when no results are returned from the query?