| Author |
help with a statement
|
ben riches
Ranch Hand
Joined: Nov 08, 2002
Posts: 126
|
|
hello i hope someone can help me please i have this statement below. PreparedStatement pstmt = conn.prepareStatement("INSERT INTO Cust VALUES (?, ?)"); what i want to do is get the name of the table from JTextField 1 how would i do this?
|
 |
Braj Prasad
Greenhorn
Joined: Apr 08, 2002
Posts: 16
|
|
Use the following :- String lStrTableName = JTextField.getText(); PreparedStatement pstmt = conn.prepareStatement("INSERT INTO " + lStrTableName + " VALUES (?, ?)"); pstmt.setString(1, Str1);//assuming a varchar column pStmt.setString(2, Str2);
|
 |
 |
|
|
subject: help with a statement
|
|
|