aspose file tools*
The moose likes JDBC and the fly likes help with getting the table name from the user input Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "help with getting the table name from the user input" Watch "help with getting the table name from the user input" New topic
Author

help with getting the table name from the user input

ben riches
Ranch Hand

Joined: Nov 08, 2002
Posts: 126
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
Ranch Hand

Joined: Sep 23, 2001
Posts: 72
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.

-Pat
[ December 05, 2002: Message edited by: Pat Wallwork ]
ben riches
Ranch Hand

Joined: Nov 08, 2002
Posts: 126
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
Greenhorn

Joined: Nov 22, 2002
Posts: 3
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: help with getting the table name from the user input