I have a table in my database which I displayed in my GUI program using a JTable. The JTable contains driver, database URL, username, password, table name, and field name / Fields columns respectively. I want to loop through this JTable rows, get their values and pass it this sql statements.
E.g: if the first row have
com.mysql.jdbc.Driver,
jdbc:mysql://localhost:3306/DBname, root, pass, TableName, FieldName
as the values of each field And the second row have the following as the values of each field.
com.mysql.jdbc.Driver, jdbc:mysql://localhost:3306/DBname3, root, pass3, TableName3, FieldName3