Each card will use different attributes from different tables.
Each SQL string will select these attributes specific to the card.
When a new card is created, a new select statement will be created to identify which attributes this card will use.
That string will tell the jsp which fields to display on the page when the user selects a specific type of card. Then the user can add data, edit data, delete data, search through the data using drop down lists or print the data for a particular combination specific to that kind of card.
The reason I need to use these strings (I think) is that they are going to be different for every kind of card, and there is an infinite (within reason) number of card possibilities, and therefore an infinite number of attribute combinations.
So the sql strings themselves will be static but linked to a card type in the database, either as a very long string stored in the database, or as a path to a text file that holds the string, or possibly, as a callableStatement or stored procedure.
Does that explain?