Share on Google+Share on Google+

mohanapriya
how to retrieve data into combo from database in java applet?
1 Answer(s)      6 years and a month ago
Posted in : Applet

hi,. i have written applet codes for linking two frames and database connectivity but the problem is, the database is not retrieving data into the combo..please somebody help me for the right set of codes.i have attached the codes.

//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;
    gwf(){
        setLayout(new GridLayout(5,1));
        setTitle("FIRST PAGE");
        l1 = new Label("Choose Department");
        c1 = new JComboBox();
        c1.addItem("--select--");
        c1.addItem("Science");
        c1.addItem("Fashion");
        c1.addItem("IT Corporate");
        c1.addItem("Finance");
        c1.addItem("Sociology");
        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 g = 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=null; Connection con;

public void init() { try{ Class.forName("org.postgresql.Driver"); con = DriverManager.getConnection("jdbc:postgresql://localhost:5432/departments","postgres", "postgres"); Statement st= con.createStatement(); ResultSet rs=st.executeQuery("SELECT rolename from role WHERE deptid=1234"); while(rs.next()){ c1.addItem(rs.getInt("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(); }}

Ads

View Answers

March 10, 2011 at 11:18 AM


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);
    }
}









Related Tutorials/Questions & Answers:
Advertisements
Tutorials   
Java Spring Hibernate Struts Training Error in calling javascript function from java prg Creating an Applet java program Display Java in JSP Draw bufferimage in jpanel using netbeans Moving Applet Problem c programming Attendence Management system java program of different shapes help applet printing p applet dought Help please, some strange errors Write an applet to display scrolling image in an applet window using thread. Simple Java applet that need usernam, password and textfield. conversion Applet java program java program java program scrolling text in applet java java applet java applet project in java using applet and servlet...which tool i should use?eclipse or netbeans? java user input to database user input to database user input to database button to accept user input jframe what is web .config method Can any one please help me in this ,,,,,,, need java code for this ,,,,please anyone applet question Write an Applet which display current date and time on the web page?? Write an Applet which display current date and time on the web page?? Java Applet - Adding a Button to Decrease a Total Applet Application how to drag top most images which is draw on applet. convert java Application to Java Applet convert java Application to Java Applet Problem In applet Its run on browser but hang and blinking when image is draging some where. how to access database in applet How to add dropdown list in a row of a sort table applet? java project topics plz anyone can solve my Layout Manager Project Guidance applet is running but no display

Ads

 
Advertisement null

Ads