Number of database query results

============ Problem Description ============

In the database to hold the user post information, using the following program to get the number of users post. But Userutils's value has been 1, what's going on?

ResultSet res = sqlconn.executequery ("SELECT count (*) from" + username+ "_message"), while (Res.next ()) {Userutils.flag = R Es.getint (1); System.out.println ("userutils =" + Userutils.flag);}

============ Solution 1============

From the back, add a space.

============ Solution 2============

Select COUNT (*) is missing a space after the from.

Number of database query results