Java: How to extract a Count from ResultSet Select query

Question

This question has been answered before here but the solutions that were posted are not working for me. Following is my code:

Statement query = this.conn.createStatement();
            ResultSet resultSet = query.executeQuery("Select COUNT(*) FROM Questions AS total");
            resultSet.next();
            int totalQuestions = resultSet.getInt("total");
            System.out.println(totalQuestions);
            System.exit(1);
            resultSet.close();

It just keeps on saying column total not found. I have tried it without "resultSet.next()" as well but same issue. I have also tried resultSet.getInt(1) but that doesn't work either.

ResultSet resultSet = query.executeQuery("Select COUNT(*) AS total FROM Questions"); and you are done.... — SaviNuclear
– SaviNuclear, Commented Sep 13, 2015 at 4:15

Dawood ibn Kareem · Accepted Answer · 2015-09-13 04:09:56Z

1

The SQL syntax you want is

Select COUNT(*) AS total FROM Questions

or alternatively, you could just write Select COUNT(*) FROM Questions and use resultSet.getInt(1)

answered Sep 13, 2015 at 4:09

Dawood ibn Kareem

80.2k15 gold badges103 silver badges112 bronze badges

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

Comments

Nir Alfasi · Accepted Answer · 2015-09-13 04:09:57Z

1

Change:

Select COUNT(*) FROM Questions AS total

to:

Select COUNT(*) AS total FROM Questions

answered Sep 13, 2015 at 4:09

Nir Alfasi

53.6k12 gold badges94 silver badges138 bronze badges

Comments

user4695271 · Accepted Answer · 2015-09-13 04:10:06Z

0

Your SQL query is a little bit wrong. Try:

ResultSet resultSet = query.executeQuery("Select COUNT(*) AS total FROM Questions");

answered Sep 13, 2015 at 4:10

user4695271

Comments

Vignesh Shiv · Accepted Answer · 2015-09-13 04:11:43Z

0

Change your query like this,

The SQL syntax is

Select COUNT(*) AS total FROM Questions

answered Sep 13, 2015 at 4:11

Vignesh Shiv

1,1579 silver badges23 bronze badges

Collectives™ on Stack Overflow

Java: How to extract a Count from ResultSet Select query

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related