Bonjour,
J'ai un soucis dans l'importation de donnée dans une Jcombobox.
J'ai 3 combobox en cascade, l'une affiche une table définie et les autres font des recherches dans mon fichier sql en fonction de la première.
Le problème est que j'obtiens que le premier résultat de la recherche.

Voici mon code:
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
 
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
 
 
public class Fenetre extends JFrame {
 
	JPanel container, contenu;
	JComboBox jdept, jcommune, jnra;
	JLabel ldept;
 
	String[] bloc = {"","01","02","03","04","05","06","07","08","09","10","11","12","13","14","15","16","17","18","19","2A","2B","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59","60","61","62","63","64","65","66","67","68","69","70","71","72","73","74","75","76","77","78","79","80","81","82","83","84","85","86","87","88","89","90","91","92","93","94","95","97","98"};
 
	public static SQLExecuteQuery connexion;
 
	public Fenetre(){	
		connexion = new SQLExecuteQuery("org.sqlite.JDBC","jdbc:sqlite:nra.db");
		this.setTitle("FreeDegroupADSL");
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		this.setSize(800,200);
		this.setAlwaysOnTop(true);
		this.setResizable(false);
 
		container = new JPanel();
		container.setBackground(Color.white);
                container.setLayout(new BorderLayout());
 
                ldept = new JLabel("Département");
 
		jdept = new JComboBox(bloc);
		jdept.setPreferredSize(new Dimension(50,20));
 
		jcommune = new JComboBox();
		jcommune.setPreferredSize(new Dimension(500,20));
 
		jnra = new JComboBox();
		jnra.setPreferredSize(new Dimension(100,20));
 
		contenu = new JPanel();
		contenu.add(ldept);
		contenu.add(jdept);
		contenu.add(jcommune);
		contenu.add(jnra);
		container.add(contenu, BorderLayout.NORTH);
 
                this.setContentPane(container);
                jdept.addActionListener(new Communes());
                jcommune.addActionListener(new Nra());
                this.setVisible(true);
	}
	public class Communes implements ActionListener {
		public void actionPerformed (ActionEvent arg0){
			jcommune.removeAllItems();
			try {
				SQLExecuteQuery.setString(1,(String) jdept.getSelectedItem());
				while(SQLExecuteQuery.rs.next()) {
					jcommune.addItem(SQLExecuteQuery.rs.getString("COMMUNE"));
				}
			}
			catch(Exception e1) {
				System.out.println("Select Error:"+e1);
			}
		}	
	}
	public class Nra implements ActionListener {
		public void actionPerformed (ActionEvent arg0){
			jnra.removeAllItems();
			try {
				SQLExecuteQuery.setString(1,(String) jcommune.getSelectedItem());
				while(SQLExecuteQuery.rs2.next()) {
					jnra.addItem(SQLExecuteQuery.rs2.getString("NRA"));
				}
			}
			catch(Exception e1) {
				System.out.println("Select Error:"+e1);
			}
		}
	}
}
Si vous avez des suggestions sur ce code je suis très preneur car le monde du java est nouveau pour moi.
Merci et bonne journée.