Java RSS Java RSS

Filling a ComboBox....

Reply

•
•
Join Date: May 2003
Posts: 2
Reputation: Fyrelion is an unknown quantity at this point 
Solved Threads: 0
Fyrelion Fyrelion is offline Offline
Newbie Poster

Filling a ComboBox....

 
0
  #1
Jun 2nd, 2003
Hi,
I'm in a IntrotoOOP class at my school, and my instructor asked me to look up how to fill a Java Swing Class ComboBox with data from a MySql Database. Does anyone know? This question has been quite hard to find any answers on and I have been really bugged by it recently.
Thanks!
Fyrelion
P.S.Any help at all would be really appreciated!!
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2009
Posts: 19
Reputation: oliver_lundag has a little shameless behaviour in the past 
Solved Threads: 0
oliver_lundag oliver_lundag is offline Offline
Newbie Poster

Re: Filling a ComboBox....

 
-1
  #2
Jul 17th, 2009
JAVA Syntax (Toggle Plain Text) 
  1. 	private static void queryCountry(){
  2. 		JC_country.addItem("(Choose)");	
  3. 		try {
  4. 			String query  = DBConnect.Select("addr_ref", "country, description",
  5. 																	"region = ''", "country");
  6. 			Statement stmt = DBConnect.getConnection().createStatement();
  7. 			ResultSet rs = stmt.executeQuery(query);
  8. 			while	(rs.next()){
  9. 				 JC_country.addItem(rs.getString(1)+"-"+rs.getString(2));
  10. 			}
  11. 			rs.close();
  12. 			stmt.close();
  13. 		} catch (SQLException e) {
  14. 			e.printStackTrace();
  15. 		}
  16. 	}
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2009
Posts: 19
Reputation: oliver_lundag has a little shameless behaviour in the past 
Solved Threads: 0
oliver_lundag oliver_lundag is offline Offline
Newbie Poster

Re: Filling a ComboBox....

 
0
  #3
Jul 17th, 2009
[code = JAVA]
private JComboBox getJC_country(){
if(JC_country== null){
JC_country = new JComboBox();
JC_country.setSize(new Dimension(260, 20));
JC_country.setLocation(new Point(80, 230));
JC_country.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0) {
try{
if (JC_country.getSelectedItem().toString().equalsIgnoreCase("(Choose)") == true){
JC_country.removeAllItems();
queryCountry();
}//end of if
if (JC_country.getSelectedItem().toString().equalsIgnoreCase("(Choose)") == true){
Country_Code = "Nothing";
JC_region.removeAllItems();
queryRegion();
JC_region.setSelectedIndex(0);
JC_province.setSelectedIndex(0);
}//end of if
Country_Code = JC_country.getSelectedItem().toString().substring(0, JC_country.getSelectedItem().toString().indexOf("-"));
String Filter_By_Code = "select city_municipality,description from addr_ref " +
"where country = '"+Country_Code +"'" +
"and"+
" region != '' " +
"and"+
" province != '' " +
"and"+
" city_municipality != '' "+
"and"+
" brgy_village = '' " +
"and"+
" street = '' ";
try{
tableMain.setQuery(Filter_By_Code);
}catch(Exception exp){
}//end of try catch
JC_region.removeAllItems();
queryRegion();
JC_region.setSelectedIndex(0);
JC_province.setSelectedIndex(0);
}catch(Exception e){
}//end of try catch
}// end of actionPerformed
});
}//end of JC_country.addActionListener(new ActionListener(){
return JC_country;
}//end of method getJC_country()
[/code]
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2009
Posts: 19
Reputation: oliver_lundag has a little shameless behaviour in the past 
Solved Threads: 0
oliver_lundag oliver_lundag is offline Offline
Newbie Poster

Re: Filling a ComboBox....

 
0
  #4
Jul 17th, 2009
[code = JAVA]

private JComboBox getJC_country(){
if(JC_country== null){
JC_country = new JComboBox();
JC_country.setSize(new Dimension(260, 20));
JC_country.setLocation(new Point(80, 230));
JC_country.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0) {
try{
if (JC_country.getSelectedItem().toString().equalsIgnoreCase("(Choose)") == true){
JC_country.removeAllItems();
queryCountry();
}//end of if
if (JC_country.getSelectedItem().toString().equalsIgnoreCase("(Choose)") == true){
Country_Code = "Nothing";
JC_region.removeAllItems();
queryRegion();
JC_region.setSelectedIndex(0);
JC_province.setSelectedIndex(0);
}//end of if
Country_Code = JC_country.getSelectedItem().toString().substring(0, JC_country.getSelectedItem().toString().indexOf("-"));
String Filter_By_Code = "select city_municipality,description from addr_ref " +
"where country = '"+Country_Code +"'" +
"and"+
" region != '' " +
"and"+
" province != '' " +
"and"+
" city_municipality != '' "+
"and"+
" brgy_village = '' " +
"and"+
" street = '' ";
try{
tableMain.setQuery(Filter_By_Code);
}catch(Exception exp){
}//end of try catch
JC_region.removeAllItems();
queryRegion();
JC_region.setSelectedIndex(0);
JC_province.setSelectedIndex(0);
}catch(Exception e){
}//end of try catch
}// end of actionPerformed
});
}//end of JC_country.addActionListener(new ActionListener(){
return JC_country;
}//end of method getJC_country()
[/code]
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Java Forum
Thread Tools Search this Thread



-xlint actionlistener add android applet application array automation bank bi binary blackberry block bluetooth character class client code compile compiler component consumer database desktop developmenthelp eclipse equation error event fractal ftp functiontesting game gameprogramming givemetehcodez graphics gui health html hyper idea image infinite int j2me j2seprojects java javac javaee javame javaprojects jetbrains jni jpanel jtable julia learningresources lego linked linux mac main method mobile myregfun netbeans notdisplaying number online pearl printf problem program qt researchinmotion rotatetext rsa scanner screen server set singleton sms sort spamblocker sql string swing system textfields thread threads time title tree tutorial-sample update variablebinding windows xor
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC