count every 45 records and prfix the count number

[dkr786]

Hi,

I have 5000 records in a database, I would like to loop through them and every 45 records I have to append a prefix .

so first 45 records I append prefix as 1, second 45 records I append prefix as 2 , like that end of 5000 records.

Please can you help me how to code this requirement in Java.

Thanks

Raj.

[Fubarable]

I have 5000 records in a database, I would like to loop through them and every 45 records I have to append a prefix .

so first 45 records I append prefix as 1, second 45 records I append prefix as 2 , like that end of 5000 records.

Please can you help me how to code this requirement in Java.

What do you have so far, and where are you stuck?

[dkr786]

I have some thing like this, but not getting thought how to implement complete logic:

int count=0;
for (int i=0;, i<args.length; i++) {
count+=args[i];
}
System.out.println("The total of arguments is: " + count);

if (count <= 46){
System.out.println(????)
}

Thanks

Raj

[dkr786]

What do you have so far, and where are you stuck?

int count=0;
for (int i=0;, i<args.length; i++) {
count+=args[i];
}
System.out.println("The total of arguments is: " + count);

if (count <= 46){
System.out.println()
}

I got up to here so far, need some help on how to build the rest of the logic...thanks in advance.

Thanks
Raj

[DarrylBurke]

Guide For New Members
BB Code List - Java Programming Forum - Learn Java Programming

db

[dkr786]

Hi Friends,

Any update ? Please could you give me some guidance...

Thanks
Raj

[Tolls]

You have been.
Darryl has posted the guide, which includes things like posting code inside [code] tags [/code], and giving us code along with errors/exceptions.

[dkr786]

Hi , the below is the code I have and got stuck need some input here:

		public static void main(String[] args) {
		// TODO Auto-generated method stub
		
		int[] anArray = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };
        int toCheck = 3;
        int counter =0;
        
		for (int i=0; i<anArray.length; i++) {
		
			if (i == 3) {counter++;}
			System.out.println("Value: " + anArray[i] +"-"+ counter );
		}
		
	}
}

When i run the above code , I am getting the output as :
Value: 7-1
Value: 8-1
Value: 9-1
Value: 10-1

But I need as below

1-1
2-1
3-1
4-2
5-2
6-2
7-3
8-3
9-3
10-4

Thanks
Raj

[jhuber151]

The reason this isn't working is because of your if statement

if (i == 3) {counter++;}

You would have to use a module(%) to get the correct results

if (i%3 == 0) {counter++;}

You would have to edit the module i provided above to get the exact output you would want.