import java.io.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class Sample2 extends JFrame 
{
	JPanel jp;
	JLabel l,l1,l2,l3;
	JTextField jt,jt1,jt2,jt3;
	JButton jb,jb1,jb2;
	public Sample2()
	{

	    jp=new JPanel();
		getContentPane().add(jp);
		jp.setLayout(null);
	    l=new JLabel("Sno");
		jp.add(l);
		l.setBounds(25,20,60,60);
		l1=new JLabel("Sname");
		jp.add(l1);
		l1.setBounds(25,50,80,80);
		l2=new JLabel("Address");
		jp.add(l2);
		l2.setBounds(25,90,80,80);
		l3=new JLabel("Email");
		jp.add(l3);
		l3.setBounds(25,130,80,80);
		jt=new JTextField();
		jp.add(jt);
		jt.setBounds(90,40,100,20);
		jt1=new JTextField();
		jp.add(jt1);
		jt1.setBounds(90,80,100,20);
		jt2=new JTextField();
		jp.add(jt2);
		jt2.setBounds(90,120,100,20);
		jt3=new JTextField();
		jp.add(jt3);
		jt3.setBounds(90,160,100,20);
        jb=new JButton("Insert");
		jp.add(jb);
		jb.setBounds(50,200,70,20);
		jb1=new JButton("Clear");
		jp.add(jb1);
		jb1.setBounds(130,200,70,20);
		jb2=new JButton("Exit");
		jp.add(jb2);
		jb2.setBounds(220,200,70,20);
		setSize(500,500);
		setTitle("Insert the data");
	    setVisible(true);
		//setEnabled(true);
		setDefaultCloseOperation(EXIT_ON_CLOSE);
		
	
	jb.addActionListener(new ActionListener() {
	public void actionPerformed(ActionEvent ae)
	{
		
		//String str=jt.getText();
		int s=Integer.parseInt(jt.getText());
		String s1=jt1.getText();
		String s2=jt2.getText();
		String s3=jt3.getText();
		
		
		try
		{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con=DriverManager.getConnection("jdbc:odbc:sample");
		String vsql="insert into stable values(?,?,?,?)";
		PreparedStatement pstmt=con.prepareStatement(vsql);
        pstmt.setInt(1,s);
		pstmt.setString(2,s1);
		pstmt.setString(3,s2);
		pstmt.setString(4,s3);
		pstmt.executeUpdate();
		
		JOptionPane.showMessageDialog(null,"Data INSERTED");
		System.out.println("data inserted");
		}catch(Exception e)
		{
			System.out.println(e);
		}
		

		
	}
	
	
	});
		jb1.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent e)
		{
			jt.setText("");
			jt1.setText("");
			jt2.setText("");
			jt3.setText("");
			
		}
		});
		jb2.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent ae)
		{
			System.exit(0);
		}
		});

	}
	


	
	

	public static void main(String[] args) 
	{
	 new Sample2();

	}
}