28)Write a java program to display the selected employee details in JTable. (use database, combo box for employee selection ) Employee having fields eno, ename, sal, desg.
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Vector;
class Slip28_2 implements ItemListener
{
JFrame f;
JComboBox cb;
JPanel p;
JLabel l,l1,l2,l3;
Connection conn = null;
Statement stmt = null;
PreparedStatement ps = null;
ResultSet rs,rs1 = null;
Slip28_2()
{
f = new JFrame("Employee Information");
p = new JPanel();
l = new JLabel("Select emp No : ");
l1 = new JLabel();
l2 = new JLabel();
l3 = new JLabel();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:dsn11");
stmt = conn.createStatement();
Vector v = new Vector();
rs = stmt.executeQuery("select eno from employee");
while(rs.next())
{
v.add(rs.getInt(1));
}
cb = new JComboBox(v);
cb.addItemListener(this);
}
catch(Exception e)
{
e.printStackTrace();
}
p.add(l);
p.add(cb);
p.add(l1);
p.add(l2);
p.add(l3);
f.add(p);
f.setSize(400, 400);
f.setVisible(true);
}
public void itemStateChanged(ItemEvent e)
{
JComboBox source = (JComboBox)e.getSource();
Integer emp_no = (Integer)source.getSelectedItem();
try
{
rs1 = stmt.executeQuery("select * from employee where eno ="+emp_no);
if(rs1.next())
{
l1.setText("\nEmp No : "+rs1.getInt(1));
l2.setText("\nName : "+rs1.getString(2));
l3.setText("\nSalary : "+rs1.getInt(3));
}
}
catch(Exception ex)
{
System.out.println(ex);
}
}
public static void main(String args[])
{
Slip28_2 obj = new Slip28_2();
}
}
Search
Recent Posts
Mail Management System
Posted on 2019-07-18Online food ordering system
Posted on 2019-07-18Library Management System
Posted on 2019-07-17Health center system project
Posted on 2019-07-17Gym Management System
Posted on 2019-07-17furniture management system
Posted on 2019-07-17Electronic shop management system
Posted on 2019-07-17Automobile Workshop Management
Posted on 2019-07-17Online Visa Processing System
Posted on 2019-07-17Inventory management System
Posted on 2019-07-17petrol-management system
Posted on 2019-07-17Cloths management system
Posted on 2019-07-17Society Management system
Posted on 2019-07-17Mall management system
Posted on 2019-07-17school management system
Posted on 2019-07-17Sales Order Processing System
Posted on 2019-07-17Retail sales management
Posted on 2019-07-17Raw Materials Management
Posted on 2019-07-17railway reservation system
Posted on 2019-07-17purchase and sales management system
Posted on 2019-07-17Placement Management System
Posted on 2019-07-17Pet Shop Management System
Posted on 2019-07-17petrol pump management system
Posted on 2019-07-17Patient Information System
Posted on 2019-07-17news agency system
Posted on 2019-07-17Cinema Booking System
Posted on 2019-07-17Medical Store System
Posted on 2019-07-17leave management System
Posted on 2019-07-17Laboratory Information Management System
Posted on 2019-07-17content management system
Posted on 2019-07-17Inventory management System
Posted on 2019-07-17Institute Management System
Posted on 2019-07-17Hotel management System
Posted on 2019-07-17Gym Management System
Posted on 2019-07-17Garage Management System
Posted on 2019-07-17Furniture shop management system
Posted on 2019-07-17Fisheries management System
Posted on 2019-07-17Fertilizer scheduling system
Posted on 2019-07-17online eye care system
Posted on 2019-07-17Dental Clinic Management System
Posted on 2019-07-17Cyber Café Management
Posted on 2019-07-17Milk Billing System
Posted on 2019-07-17Colddrink management system
Posted on 2019-07-17Cable management System
Posted on 2019-07-17Beauty parlor management system
Posted on 2019-07-17Facebook Clone
Posted on 2019-05-28Dance Class Management System
Posted on 2019-05-24Library Management System
Posted on 2019-05-24Cab Management System
Posted on 2019-05-23Blood Bank Management system
Posted on 2019-05-23Beauty Parlour Management System
Posted on 2019-05-23vissa proccesing system
Posted on 2019-05-23Toll Plazza
Posted on 2019-05-23BILLING APPLICATION
Posted on 2019-05-23FLORICULTURE MANAGEMENT SYSTEM
Posted on 2019-05-23Car On Rent
Posted on 2019-05-23E-commers Shop
Posted on 2019-05-23