return output from a non select query (java/access)

[kitiaradl]

I'm trying to return my entire database as a result of the following..but i'm not getting any results back..I also want to clear the text area/field once result are returned..

I have attached my java and database files.

Here is the code below where I am having the challenge. If enter "select * from students" then it will return something, but if i do anything else, it wont return anything.


public String query(String query){
String output = "";

String[] temp = query.split(" ");
try{
if(!temp[0].equalsIgnoreCase("select")){
statement.executeUpdate(query);
//query("SELECT * FROM students");

return output;


}
else{
resultSet = statement.executeQuery(query);
output = formatResult();
return output;


}
}
catch(SQLException sqle){

JOptionPane.showMessageDialog(null, sqle);

}

return output;
}

private String formatResult(){
String output = "";



try{
while(resultSet.next()){
output += resultSet.getString("Fname") + " " +
resultSet.getString("Lname") + " " +
resultSet.getInt("Age") + "\n";




}
}
catch(SQLException sqle){

System.err.print(sqle);

}
return output;
}

[iluxa]

non-select queries have no output... not sure what you're trying to accomplish

[kitiaradl]

right, so how do i get it to return all of the information in the database? And clear the field once any statement is executed? I assume it has to be coded for when someone click the execute query button.