hi., i just need to correct my codes.somebody help me to clear the error to bring a right of codes to execute.Thanks in advance. //first page import java.awt.*; import java.sql.SQLException; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.*; class gwf extends Frame implements ActionListener { public Label l1,l2,l3; public TextField tf1,tf2,tf3; public JComboBox c1,c2; public Button b1,b2; public Panel p1,p2; String s1,s2; gwf() { setLayout(new GridLayout(5,1)); setTitle("FIRST PAGE"); l1 = new Label("Choose Department"); c1 = new JComboBox(); c1.addItem("--select--"); c1.addItem("Welfare"); c1.addItem("Revenue"); c1.addItem("State office"); c1.addItem("Public"); c1.addItem("Corporation"); p1 = new Panel(); p2 = new Panel(); b1 = new Button("SUBMIT"); p1.add(l1); p1.add(c1); p2.add(b1); add(p1, "Center"); add(p2, "South"); b1.addActionListener(this); setSize(500, 500); setVisible(true); } public void actionPerformed(ActionEvent e) { gwf1 gw = new gwf1(s1); dispose(); } public static void main(String[] args) throws SQLException { gwf g = new gwf(); } //second page import javax.swing.*; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; class gwf1 extends Frame implements ActionListener { private static final String String =null; Label l1; TextField t1; JComboBox c1,c2; Panel p1,p2; Button b1; String s1, s2; Statement st; ResultSet rs; Connection con; public void apply() { try { Class.forName("org.postgresqlANSI.Driver"); con = DriverManager.getConnection("jdbc:postgresqlANSI://localhost:5432/departments","postgres", "postgres"); ResultSet rs=st.executeQuery("SELECT role_name from role WHERE dept_id=1234"); if(rs!=null) {while(rs.next()) { c1.addItem(rs.getString("role_name")); } } } catch(Exception e) { e.printStackTrace(); } } public gwf1(String s1) { this.s1 = s1; setLayout(new GridLayout(5, 1)); setTitle("Second Page"); l1 = new Label("Enter Role"); c1 = new JComboBox(); c1.addItem("--select--"); b1 = new Button("SUBMIT"); p1 = new Panel(); p2 = new Panel(); p1.add(l1); p1.add(c1); p2.add(b1); add(p1, "Center"); add(p2, "South"); b1.addActionListener(this); setSize(400, 500); setVisible(true); } public void actionPerformed(ActionEvent e1) { JOptionPane.showMessageDialog(this, "The generated Id is:"); dispose(); gwf2 gp = new gwf2(); } }
We have used Mysql database:
import java.sql.*; import java.awt.*; import javax.swing.*; import java.awt.event.*; class JComboBoxExample{ public static void main(String[] args){ JFrame f=new JFrame(); f.setLayout(null); JLabel lab=new JLabel("Course Items:"); final JComboBox combo=new JComboBox(); combo.addItem("--Select--"); try{ Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from student"); while(rs.next()){ combo.addItem(rs.getInt("id")); } } catch(Exception e){} JButton b=new JButton("Get"); lab.setBounds(20,20,100,20); combo.setBounds(120,20,150,20); b.setBounds(120,50,80,20); b.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent e){ String value = combo.getSelectedItem().toString(); JOptionPane.showMessageDialog(null,"You have selected '"+value+"' from ComboBox"); } }); f.add(lab); f.add(combo); f.add(b); f.setVisible(true); f.setSize(300,120); } }