Creating a java bean to execute an sql query.

[Dillinger4]

Try this.

private Connection dbconn = null;
public questionaalt(){
  try{
   Class.forName(driver);
   dbconn = DriverManager.getConnection(url, uname, dpass);
   /*Create an SQL statement*/
   Statement statement = dbconn.createStatement();
   
   if (statement.execute(query)){
   ResultSet           results = statement.getResultSet();
   ResultSetMetaData   metadata = results.getMetaData();
   /*Validate result.  Note switch to while loop if we plan on multiple results from query*/
   if(results != null){
    /*Use results setmetadata object to determine the columns*/
    int li_columns = metadata.getColumnCount();
 
   result = "<tr>";
   for(int i = 1; i <= li_columns;i++){
     result+="<td>" + metadata.getColumnLabel(i) + "</td>";
   }
    result += "</tr>";
    while (results.next()){
     result +="<tr>";
     for (int i=1; i <= li_columns; i++){
       result += "<td>" + results.getObject(i).toString()+ "</td>";
      }
       result += "</tr>";
      }
     }
    }
   } 
  }