help with getting the table name from the user input

[ben riches]

hello everyone i hope someone can help me.
i have this code which is below.
i have a GUI where the user puts in his table names and the columns to be inserted into. for example he would enter 10 diffrent table and column names to insert his text to. but if the user put in the same table name in the GUI.
for example he would type in TextField1 Customers
and in TextField2 he also Typed in customers.
how would i be able test if the table name is the same table name in another prepared statement and if it is use only 1 INSERT statement to insert the text to the 2 columns?

String id = "hello";
String firstname = "james";
String stmp = JTextField1.getText();
PreparedStatement pstmt = conn.prepareStatement("INSERT INTO "+stmp+ "([FirstName]) VALUES (?, ?)");

pstmt.setString(1, id);
pstmt.setString(2, firstname);

[Pat Wallwork]

I'd suggest that you add the names your user enters to an ArrayList. Then all you have to do with the next values is use the ArrayList's contains() method to see if it's already in there...if it's true then you know it's been used.

ArrayList al = new ArrayList();
String id = "hello";
String firstname = "james";
String stmp = JTextField1.getText();
if (al.contains(stmp)) {
  // Handle name collision errors here...
} else {
  // This name is not in the ArrayList...it's ok to use
  al.add(stmp); // Add it to the ArrayList to prevent it from being used again.
  PreparedStatement pstmt = conn.prepareStatement("INSERT INTO "+stmp+ "([FirstName]) VALUES (?, ?)");
}

-Pat
[ December 05, 2002: Message edited by: Pat Wallwork ]

[ben riches]

hello pat
thanks for the idea.
but what can i do if the user types in the same table name, but names a diffrent column name. for example first of all he names table customers, then names column firstname. then he names table customers again but names a diffrent column name.
how could i get both to work in one INSERT statement. but also he might not name the same table name

[Balky BB]

are you sure you can supply a tablename in a prepared statement like that?
I thought Java PreparedStatements (static sql) requires the table name so the db can cache the query plan.
The Java Statement (dynamic sql) can supply the tablename like you suggested.