SQL Server: Displaying result in Java Textfield [duplicate]

Question

I use MS SQL Server and Java with JDBC to connect. I don't know how to display the result of my simple SQL queries in a Java Texfield. Displaying my data in a JTable is no problem with the external JAR rs2xml.

That works and prints my table in the panel.

String MaxQuery = "SELECT * FROM Employees";
PreparedStatement pst=con.prepareStatement(MaxQuery);
ResultSet rs=pst.executeQuery();
table.setModel(DbUtils.resultSetToTableModel(rs));

But when i want to display a simple query like "SELECT AVG(budget) FROM Employees" with 1 result, i want to print this in a textfield.

The method setModel doesn't work with Textfields. So i have tried something like that:

String AVGQuery = "SELECT AVG(budget) FROM Employees";
PreparedStatement pst=con.prepareStatement(AVGQuery);
ResultSet rs=pst.executeQuery();
textFieldAns.setText(rs.toString());

But that prints me "SQLServerResultSet:1". I want the result, and not the number of results. Hope u can help me by my little problem :).

In the future, consider searching a little on this. A simple look at the ResultSet API would answer this quickly for you. — Hovercraft Full Of Eels
– Hovercraft Full Of Eels, Commented Jan 10, 2016 at 20:01

BradStell · Accepted Answer · 2016-01-10 20:01:21Z

1

I believe you need to use code similar to

if (rs.next()) {
    textFieldAns.setText(rs.getString("column name you want to print");
}

Here is s good example https://docs.oracle.com/javase/tutorial/jdbc/basics/retrieving.html

answered Jan 10, 2016 at 20:01

BradStell

5104 silver badges19 bronze badges

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

3 Comments

whyper Over a year ago

The problem is, there is no column name for this result. When i say "SELECT AVG(budget) FROM Employees" the column name is not defined.

MadProgrammer Over a year ago

You can specify the column by index, getString(int); just remember, in JDBC it's 1 indexed, not 0 indexed like the rest of the Java API

whyper Over a year ago

Thanks a lot! That was my problem. I do that hours ago, but i ever used 0...

Collectives™ on Stack Overflow

SQL Server: Displaying result in Java Textfield [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related