26. Write a java program to accept details of employee(Eno,Ename,Sal)from the user And insert into database using AWT




import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;

class slip1
    {
     public static void main(String []args)
    {
     Frame f=new Frame();
     Label label1=new Label("Eno: ");
     Label label2=new Label("Ename: ");
     Label label3=new Label("sal: ");

     final TextField text1=new TextField(20);
      final TextField text2=new TextField(20);
     final TextField text3=new TextField(20);

     Button b=new Button("Save");
     b.addActionListener(new ActionListener()
    {
     public void actionPerformed(ActionEvent e)
    {
     int v1=Integer.parseInt(text1.getText());
     String v2=text2.getText();
     int v3=Integer.parseInt(text3.getText());
     try
    {
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection con=DriverManager.getConnection("jdbc:odbc:my1dsn.dsn");
     String sql="insert into employee(eno,ename,sal) values(?,?,?)";
     PreparedStatement pst=con.prepareStatement(sql);
     pst.setInt(1,v1);
     pst.setString(2,v2);
     pst.setInt(3,v3);
     pst.executeUpdate();

     JOptionPane.showMessageDialog(null,"Data is inserted successfully");
    }
    catch(Exception ex)
    {
     System.out.println(ex);
    }}});
    Panel p=new Panel(new GridLayout(5,2));
    p.add(label1);
    p.add(text1);
    p.add(label2);
    p.add(text2);
    p.add(label3);
    p.add(text3);
    p.add(b);
    f.add(p);
    f.setVisible(true);
   
    f.pack();
    }}
26. Write a java program to accept details of employee(Eno,Ename,Sal)from the user And insert into database using AWT 26. Write a java program to accept details of employee(Eno,Ename,Sal)from the user  And insert into database using AWT Reviewed by on April 27, 2015 Rating: 5
Powered by Blogger.