I want to not allow to insert more than 4 records

[Farakh khan]

Hello,

I am inserting records with the following method but I want to not allow to insert more than 4 records. Any suggestion please?

String  query=	
				" merge "+
       	 			" into StaticPages t1 "+
           			" using (select ? "+id+",? buttonHeading from dual) t2 "+
           			" on (t1."+id+" = t2."+id+" and t1.buttonHeading = t2.buttonHeading) "+
        			" when not matched then "+
           			" insert("+id+",buttonHeading) values(t2."+id+",t2.buttonHeading) ";

			PreparedStatement ps=cnn.prepareStatement(query);

			for (int i=0;i<buttonHeading.length;i++){
  				if(!buttonHeading[i].equals("")){
					ps.setString(1, userId);
					ps.setString(2, buttonHeading[i]);					
					ps.addBatch();    

				}//ifCondition				
				ps.executeBatch();
			}//forLoop
			ps.close();		

		cnn.commit();

Thanks & best regards>

[Jeanne Boyarsky]

What do you want to happen if there are more than four? It seems like you could add a counter variable that you increment in the if statement and then take the appropriate action when it becomes five.

[Farakh khan]

You are right. Thanks a lot. Appreciated