import javax.swing.*; import java.awt.*; import java.sql.*; class Comboo extends JFrame { JComboBox jcb; Connection con; Statement stat; ResultSet res; public Comboo() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:trrl"); JOptionPane.showMessageDialog(null,"connected to database");
// JOptionPane.showMessageDialog(null,"iam here"); stat=con.createStatement(); String ss="select name from sorab"; res=stat.executeQuery(ss); while(res.next()) { jcb.addItem(res.getString("name")); } } catch(Exception f) { System.out.println(f); } setSize(400,500); setLayout(null); setVisible(true); Color d=Color.white; getContentPane().setBackground(d); setDefaultCloseOperation(JFrame.EXITONCLOSE); jcb=new JComboBox(); jcb.setBounds(200,200,150,30); add(jcb);
} public static void main(String[] args) { new Comboo(); } }
You didn't create an instance of jcombobox class therefore error occurs. Anyways, we have modified your code.
import javax.swing.*;
import java.awt.*;
import java.sql.*;
class Comboo extends JFrame {
JComboBox jcb;
Connection con;
Statement stat;
ResultSet res;
public Comboo() {
jcb=new JComboBox();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:trrl");
JOptionPane.showMessageDialog(null,"connected to database");
stat=con.createStatement();
String ss="select name from data";
res=stat.executeQuery(ss);
while(res.next()) {
jcb.addItem(res.getString("name"));
}
}
catch(Exception f) {
System.out.println(f);
}
setSize(400,500);
setLayout(null);
setVisible(true);
Color d=Color.white;
getContentPane().setBackground(d);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
jcb.setBounds(200,200,150,30);
add(jcb);
}
public static void main(String[] args) {
new Comboo();
}
}