Posting Query Results to a JTextArea

[MikeMoore]

Does anyone know where I can get example code on how to post jdbc query results into a JTextArea? Any help would be great.

 

[pipk]

you can use the append method. sorry no example.

 

[rdg2cig]

Here is an example snippet. This uses an Oracle database. The ResultSet.next() method iterates through the records returned.

JTextArea textArea1 = new JTextArea(10, 50);
String query = "select emp_name, emp_id from employee order by emp_name";
Connection con = null;
Statement stmnt = null;
ResultSet rs = null;
try {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection("jdbcracle:thinoraclehost:1521:sid", "username", "password"
stmnt = con.createStatement();
rs = stmnt.executeQuery(query);
while(rs.next()){
textArea1.append(rs.getString("emp_name&quot);
textArea1.append(" "
textArea1.append(rs.getString("emp_id&quot);
textArea1.append(System.line.separator);
}
if(stmnt != null){
stmnt.close();
}
if(con != null){
con.close();
}
}
catch(SQLException e){
System.out.println("Error with database retrieval"
}