How to populate drop down box

[Rosy Mary]

Hi there,

I have a doubt of how to populate a list drop down box with values retrived from the data base.

Thanks,

[Swastik Dey]

 
  Connection con=//db connection code
  Statement st=con.createStatement();
  ResultSet rst=st.executeQuery("select fieldname from tablename");
   while(rst.next()){
         String fldname=rst.getString(1);
         //now add fldname to your drop down list
   } 

[Rosy Mary]

Thanks for the reply. If i need to populate a Choice list box then would it be the same query???

Since the screen might have more than 10 records to be feteched and displayed in the choice list box...

Please let me know your comments..

Thanks,

[Swastik Dey]

Yes query should be same, because in any case you have to iterate through all the records fetched from underlying table.

[Rosy Mary]

Hi,

It worked for me thanks a lot. And i too have some doubt regarding the frame created with out the maximise minimise and the close buttons. I have searched maximum posts for this question. But in most of them i found usage of the method SetDefaultLookAndFeelDecorated and iterating the method, this method is used for JFrames and my screens are designed using Frames.

Can you please let me know how i can incorporate this change in my code..

Thanks,

[Bauke Scholtz]

Which doubt? I only see a question which is not related to JDBC at all. In English, a "doubt" roughly means "I understand it, but I don´t agree with it", while you actually don´t understand it. You really have a "question" or maybe just a "problem" ;) Start a new topic at the Swing forum. This has nothing to do with JDBC.

[Jeanne Boyarsky]

In India, "doubt" means "question" or "query". In any case, I'm moving this to our GUI forum.

[Michael Dunn]

> And i too have some doubt regarding the frame created with out the maximise minimise and the close buttons.
> .... and my screens are designed using Frames.

frame.setUndecorated(true);

but you'll lose the border