How can I get data in a combo box from a database in Java | Load data from database to Combo box in Java:
In this we will see how to load data from database table into combo box component of swings in java.
package demo;
import java.awt.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.Vector;
import javax.swing.*;
public class RuntimeComboBoxDemo {
public static void main(String[] args) {
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe","system","system");
System.out.println("Connected to database...");
Statement pstmt=con.createStatement();
ResultSet rs=pstmt.executeQuery("select distinct ename from emp");
JFrame f=new JFrame();
Vector<String> v=new Vector<String>();
while(rs.next()){
v.add(rs.getString(1));
}
JComboBox jcb = new JComboBox(v);
f.setLayout(new FlowLayout());
f.add(jcb);
f.setSize(300, 250);
f.setLocationRelativeTo(null);
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
f.setVisible(true);
}
catch(Exception e){
System.out.println(e);
}
}
}