Getting Incorrect return in java accessing sql database

Question

This is the code im using in java to query the database

                connect = DriverManager.getConnection (url, "user", "pass");
                state = connect.createStatement();
                String meetID = "SELECT GamerTag FROM backup";
                ResultSet rs = state.executeQuery(meetID);

                   while(rs.next()){
                        System.out.println(rs.toString());
                   }

Im not getting the values of the row in the database im getting this instead

com.mysql.jdbc.JDBC4ResultSet@108137c9

You might want to go through the JDBC tutorial before continuing: docs.oracle.com/javase/tutorial/jdbc/index.html — user330315
– user330315, Commented Aug 30, 2014 at 14:34

Andomar · Accepted Answer · 2014-08-30 14:28:18Z

1

You're printing the result of the toString method of the Recordset object, which appears to print out the object's name and hashcode.

Instead, try to print the value of a column. Perhaps using getString:

System.out.println(rs.getString("GamerTag"));

The documentation for Java's recordset looks confusing, you might be better off searching for examples.

answered Aug 30, 2014 at 14:28

Andomar

239k55 gold badges387 silver badges412 bronze badges

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

2 Comments

user3991643 Over a year ago

Thanks im adding it to an arrayList so do i add rs.getString("GamerTag") or rs.toString()? Your way printed the right result

Andomar Over a year ago

rs.toString() returns a string that contains the name of the recordset class and the hashtag of the object. It's only useful for debugging.

SparkOn · Accepted Answer · 2014-08-30 14:43:13Z

What do you expect rs.toString() should do it will just print the hash of the resultsetObject if you want to get the column values you should do this way

while(rs.next()){
System.out.println(rs.getString("yourFirstColumnName")+"  "+
                           rs.getString("yourSecondColumnName")+"  "+
                          rs.getString("yourThirdColumnName"));
}

Really you should use PreparedStatement. In your case though you are not using any parameterizedQuery but One of the major benefits of using PreparedStatement is better performance. PreparedStatement gets pre compiled.

In database and there access plan is also cached in database, which allows database to execute parametric query written using prepared statement much faster than normal query because it has less work to do. You should always try to use PreparedStatement.

So you can do something like this

String query = "SELECT GamerTag FROM backup"
PreparedStatement st =connect.prepareStatement("query");
ResultSet rs = st.executeQuery();

Collectives™ on Stack Overflow

Getting Incorrect return in java accessing sql database

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related