Thread: passing jtable row values to an sql statement while looping through it

I have a jtable which has database information. Each row of the database would have different databases like the first one could be for mysql, the second for ms access, the third for sqlite, the fourth for hsqldb, etc. So i want a code that will loop through this jtable of different databases, then get each row values(which is database and its information like the driver, table name, Field name, database address) and pass it to the sql statement. Why I am trying to do this is that I created an application that would allow a user to add a database/ databases to this application. So the application which has to do with searching a database should be able to look at any database added and search through it.

This is an algorithm of what I want to do:

for(iterate through the jtable and pass each row values to the sql statement)
{
try
{
Class.forName(getDriver rows here);
Connection con = DriverManager.getConnection(getDatabase url here, getUsername, getPassword);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from getTableName where field = getFieldName");
while(rs.next())
{
System.out.println(rs.getString());
}
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
The Question is can I achieve this? and Can someone give a clue to do this (codes will be welcome), or any other method to achieve this.

Originally Posted by greeninho

The Question is can I achieve this?

What happened when you tried?

I ASKED IF IT IS FEASIBLE , THEN IF IT IS NOT BASED ON MY OWN ALGORITHM, CAN YOU PROFER ANY METHOD TO ACHIEVE SOMETHING LIKE THAT.

We live in a world where new things happen all of the time, why don't you give it a shot and see what you come up with?
Or some research and see what you find?

Please check that your shift key is not stuck when you post to the forum