Is general SQL query in Java feasible?

If I have a method to create an SQL query, it is as follows:

public List selectTuple() {
   boolean status = true;
   String query = "SELECT ";
   query += getFields() == null ? " * " : " " + getFields() + " ";
   query += " FROM " + tables;
   if ( getSearchClause() != null ) {
       query += " " + getSearchClause();
   }
   query += ";";
   Debug("sql...........caleed selectTuple method,query is : "+ query);
   setQuery(query);
   if ( getPrepared() ) {//If this is a Prepared query,status = setPreparedStatement();
   } else {
      status = setNonPreparedStatement();
   }
   if ( ! status ) {
      Log("[CRITICAL] (.........)..........");
   }
   status = doExecuteQuery();
   if ( ! status ) {
      Log("[CRITICAL] (.........)..........");
   }
   return( getResults() );
}//method selectTuple

However, since this will be used for different tables, fields will have different data types (int, string, date, etc.) So how to iterate such a resultset?

In addition, how do I create such an insert query?

thank you.

Solution

Yes, I think it can be done... You can use GetMetadata () in the resultset to get the number and type of columns, and therefore iterate over the resultset

getMetaData()：

ResultSetMetaData class

However, I don't know how to write such a general insert query