asked on

Seeing textfields

following is my code to populate some textfields. The textfields are defined in the main program so I get errors saying can't find the textfields. How do I let this class know about the textfields. Thanks

public class populateInvName {
ConnectDatabase connectDatabase = new ConnectDatabase();
public Connection con;

public void populateInvName() {

try {

con = connectDatabase.getConnection();
Statement st = (Statement) con.createStatement();
String command = "SELECT * FROM seller WHERE name = " + "'" + entry +"'";
ResultSet rec = st.executeQuery ( command );

rec.next();

jTextField_dailySellerNumber.setText(rec.getString("number"));
jTextField_dailySellerName.setText(rec.getString("name"));
jTextField_dailySellerAddress1.setText(rec.getString("address1"));
jTextField_dailySellerAddress2.setText(rec.getString("address2"));
jTextField_dailySellerCity.setText(rec.getString("city"));
jTextField_dailySellerState.setText(rec.getString("state"));
jTextField_dailySellerZip.setText(rec.getString("zip"));
jTextField_dailySellerMortgage.setText(rec.getString("mortgage"));
jTextField_dailySellerComment.setText(rec.getString("comment"));
jTextField_dailySellerHeadIn.setText(rec.getString("head"));

} catch (SQLException ex) {
JOptionPane.showMessageDialog(null,
"SQLException Reading Daily Seller: " + ex.getMessage());
}
}

}

Manish

First set the value in some object like Person.
put it in list.

Call this class from main class and get the list.
Iterate that list in main class and set it in jTextField.

ASKER CERTIFIED SOLUTION

CEHJ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sargent240

ASKER

Thanks CEHJ! One question, What do I send to the method when I call it for Map<String and JTextComponent>fieldsMap.

Thanks, Cheers.

CEHJ

Well you need to create a Map of course with all your fields keyed by column name

sargent240

ASKER

I have been looking around at how to set up the map and am not grasping what I need to do. Could you show me what the code should be as you did above? THANKS!

CEHJ

fieldsMap = new HashMap<String, JTextComponent>();
fieldsMap.put("number", tfNumber);
fieldsMap.put("name", tfName);
...

Open in new window

sargent240

ASKER

I used the code from your last post and got a:

cannot find symbol var variable

on fieldsMap, tfNumber, and tfName.

I am struggling with the syntax, continuing to search through info on the web without much success. Besides the code I could use a little elementary discussion as to the parts involved. That would help a lot as to future use of the idea. Again Thank you very much.

CEHJ

I used the code from your last post and got a:

cannot find symbol var variable

Please post, verbatim, the error you got. Of course, you would have to define your Map variable as an instance variable

sargent240

ASKER

I got it figured out. Thanks!

CEHJ