Java JDBC: how to get int size of table, by exectuning SQL query

Question

Part of my code looks like this:

int size = 0;

        try {

            String query = "SELECT count(*) FROM users";

            statement = connection.prepareStatement(query);
            statement.execute(query);

I don't know what to do to set size of table to my int size.

BDRSuite · Accepted Answer · 2014-11-27 15:45:59Z

2

The result set will contain the value of numner of rows. get the value into your size variable.

  ResultSet result = statement.executeQuery(query);
  while (result.next()){
  size= result.getInt(1);
  }
  System.out.println("Number of row:"+size);

edited Nov 27, 2014 at 15:45

answered Nov 27, 2014 at 15:39

BDRSuite

1,6671 gold badge11 silver badges16 bronze badges

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

3 Comments

RichardK Over a year ago

Thank you, it's Type mismatch: cannot convert from boolean to ResultSet

user330315 Over a year ago

@RichardK: then you are not running the code in vembutech's answer.

RichardK Over a year ago

I see it, preparedStatement = connection.prepareStatement(query); resultset = preparedStatement.executeQuery();

kmandov · Accepted Answer · 2014-11-27 15:41:24Z

0

int size = 0;

    try {

        String query = "SELECT count(*) FROM users";

        statement = connection.prepareStatement(query);
        ResultSet rs = statement.execute(query);
        size = rs.getInt(1);

rs.getInt(1) will return the first row from the query as int

answered Nov 27, 2014 at 15:41

kmandov

3,20919 silver badges16 bronze badges

1 Comment

user330315 Over a year ago

"rs.getInt(1) will return the first row" no it will not. It will return the first column from the result set. An you have to call rs.next() before you can call any getXXX() method.

Collectives™ on Stack Overflow

Java JDBC: how to get int size of table, by exectuning SQL query

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related