Extracting a column value from a row

[Varnam Aayiram]

Hi Folks...

I need to execute the following sql query and printout the resulting value to the stack trace. The query is as follows:

"SELECT hoursused FROM sysuser WHERE iduser = 'p0248448'";

iduser is a primary key and therefore hoursused is a value from a column in that same row as 'iduser = p0248448'

This is what I did within the doPost method of the servlet:

 @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {

String sql = "SELECT hoursused FROM sysuser WHERE iduser = 'p0248448'";

try
    {
      Connection connection = dataSource.getConnection();
      PreparedStatement preparedStatement = connection.prepareStatement(sql);
      ResultSet executeUpdate = preparedStatement.executeQuery();
      System.out.println(executeUpdate );
      }

catch (SQLException e)
    {

e.printStackTrace();

 }

}

I am getting this in my stack tace:

com.mysql.jdbc.JDBC4ResultSet@5d1175

the vaue I am expecting is actually the number 6. I suspect it's cos I am printing the object itself, how do I actually print the value? Hope someone can advise. Thanks

[Jijesh T Das]

executeUpdate .getString(hoursused ) willl extract the required value.

[Jan Cumps]

Welcome to JavaRanch, Jijesh.

Jijesh T Das wrote:executeUpdate .getString(hoursused ) willl extract the required value.

But don't forget to navigate to the first record in the resultset before calling ResultSet.get...()

regards, Jan

[Jijesh T Das]

Thanks Jan

[Varnam Aayiram]

Hi Guys...

Thanks for the replies....I am just curious...shouldn't it be executeQuery instead of executeUpdate??. Anyway based on the advise given, I have managed to get it to work. For the benefit of those caught in a simillar predicament as me, I am posting the code below:

ResultSet srs = preparedStatement.executeQuery(sql);
            while(srs.next()) {
                String hoursused = srs.getString("hoursused");
                System.out.println("The hours used are " + hoursused);
            }

Thanks once again guys...

[Jan Cumps]

Varnam Aayiram wrote:..shouldn't it be executeQuery instead of executeUpdate...

True. executeUpdate has some additional functionality that you don't need in a select statement (see javadoc for more info, it's related to auto generated keys). It is a proper approach to use executeQuery for select statements.

and thank you for sharing the solution.

Jan

[Varnam Aayiram]

most welcome Jan