retrieving data in to the dropdown box from postgresql database in core java
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();
}
}
View Answers
March 14, 2011 at 11:57 AM
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);
}
}
Ads
Related Tutorials/Questions & Answers:
Retrieving Data from Database to fill Combo Box
Retrieving Data from Database to fill Combo Box Sir,
I have a JSP Page with a combo
box and a label. I have a
database that has two fields id and an image. Now I want to fill the combo
box with image and on selecting
Advertisements
Retrieving data from data base using jsp combo box
Retrieving data from data base using jsp combo box Hi guys please... of the server it has to display the process name
from database into the process name... combo
box is there and another filed is version of the server(like 1.0,2.0) like
retrieving from oracle database using jsp combo box
retrieving from oracle
database using jsp combo box hi this is my... name of the server has to display in the process name field
from the oracle
database please help on this i need code using servlets please help me .
<
how to check dates while retrieving data from database
how to check dates while
retrieving data from database i want to update
database record based on delivery date i have tried this query but it wont work
b="update deliveryorder set prtnm='"+arr[1]+"',stn='"+arr[0]+"',sbston
Populate a combo box using data from a database
Populate a combo
box using
data from a database Hi Guys, In need... combo
box which will then load the
next combo
box values,
now i know how to populate the first one, and then how to send the
data off to a servlet and preform
retrieving xml document from database
retrieving xml document
from database Hi Guys,
I want to retrieve the xml document stored in the
database on to a jsp page using jdbc/odbc connnection.Please help me in implementing this feature.
Thank You
Madhu
JSP Get Data Into Dropdown list From Database
JSP Get
Data Into
Dropdown list
From Database
In this section we will discuss...
data from the
database and set
it into the
dropdown list in JSP using MySQL....
This tutorial explains you that how to fetch
data from database and set
Use of Select Box to show the data from database
Use of Select
Box to show the
data from database
 ...
from database
This example will describe you the use of Select
Box in a JSP page to show
the
data fetched
from the
database. We are using Servlet to get
data
Retrieving the Image from a database Table
Retrieving the Image
from a
database Table
Consider a case where we want...
from the
database table our
java program need to make a connection... to retrieve the
image
from the
database table. You can do it very easily after
Retrieving JTree structure from database
the steps required to create tree
retrieving the
data from the
database.
Here...
Retrieving JTree structure
from database
This example shows how to
retrieving data from
check radio button on retrieving the value from database.
check radio button on
retrieving the value
from database. HI
i am new to jsp.In my applcation i having a problem. I am
retrieving
user payment
from... information
from database the i want to show
cash radio button checked.How can i do
dropdown box
dropdown box i need to have country,state and city in drop down
box using ajax and use db2
database
Have a look at the following link:
JSP dependent
dropdown
Retrieving specific data from excel
Retrieving specific
data from excel Hello everyone, i have written a simple code to retrieve
data from excel sheet and working fine, the excel file... first sheet
from the workbook
HSSFSheet sheet = workbook.getSheetAt(0
populate dropdown box
populate
dropdown box hi,
Is there any ways in which i can populate my
dropdown menu with values
from 1 to n (n = the value stored in
database... item in
dropdown menu is 10 then the second
dropdown box should contain values
Retrieving value from multiple table in database
Retrieving value
from multiple table in database Hi fnds, I want to maintain the financial
database of 20 users for 1 year and update the details... contains the
data like name,amount,paiddate and balance of individual users... i