Using POI, JAVA & MySQL to Compile an Excel Document

Question

I am trying to gather information from a MySQL database and then exporting that information to a Excel document using POI and JAVA.

The only problem I am experiencing is increasing the number after data.put, each time if(rs.next()) is executed, for example:

Map<String, Object[]> data = new HashMap<>();
            data.put("1", new Object[] {"Emp No.", "Name", "Salary"});

            if(rs.next()) {
                data.put("2", new Object[] {1d, "John", 1500000d, "Test"});
            }

The 2 should increase to 3 then to 4 then to 5, depending on the rows in the MySQL database.

Any help is appreciated.

SatyaTNV · Accepted Answer · 2015-07-20 11:27:05Z

1

int cnt=2;

while(rs.next()) 
{
    data.put(""+cnt, new Object[] {1d, "John", 1500000d, "Test"});
    cnt++;//increment to 3, 4, etc
}

try like this

edited Jul 20, 2015 at 11:27

answered Jul 20, 2015 at 11:05

SatyaTNV

4,1473 gold badges17 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Hrach Ghapantsyan Over a year ago

For some reason, this is only writing one line.

SatyaTNV Over a year ago

use while not if. if is going to check the condition only on time.

Collectives™ on Stack Overflow

Using POI, JAVA & MySQL to Compile an Excel Document

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related