Problem with JDBC setResult on JTextarea

[Behrouz Hosseini]

Hi guys,
I am trying to display a simple sql query result on a JTextArea.When I use a simple print line command I can get all data in console but when I replace the print command with append() I get these address instead of my data
com.mysql.jdbc.JDBC4ResultSet@1a16869
com.mysql.jdbc.JDBC4ResultSet@1a16869
com.mysql.jdbc.JDBC4ResultSet@1a16869
com.mysql.jdbc.JDBC4ResultSet@1a16869
com.mysql.jdbc.JDBC4ResultSet@1a16869

 
 public class DBTest {

    public static void main(String[] args) {
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost/MyDatabase";
        String username = "root";
        String password  = "root";
        JTextArea txtResult = new JTextArea();
        JScrollPane scrollPane = new JScrollPane(txtResult);
        JFrame frame = new JFrame();
        frame.getContentPane().add(scrollPane, "Center");
        frame.setSize(400, 400);
        frame.setVisible(true);

        try {

            Class.forName(driver);
            Connection connection = DriverManager.getConnection(url, username, password);
            Statement statement = connection.createStatement();
            ResultSet resultset = statement.executeQuery("SELECT * FROM java");
            while (resultset.next()) {
                txtResult.append(resultset + "\n");
            }
            connection.close();

        } catch (ClassNotFoundException cnfe) {

            cnfe.printStackTrace();
        } catch (SQLException sqle) {

            sqle.printStackTrace();
        }

    }
} 
 

Could you please let me know what's wrong?
Best Regards

[Darya Akbari]

Salam Behrouz,

shouldn't you append resultset.next() instead of resultset?

[Bear Bibeault]

Please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place. Please read this for more information.