
fetching the value of any form into the database??

Fetching the value of any form into the database
import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;
class FormData{
public static void main(String[] args){
Frame f=new Frame();
Label label1=new Label("Emp No: ");
Label label2=new Label("Emp Name: ");
Label label3=new Label("Salary: ");
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("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
int i=st.executeUpdate("insert into data(eno,ename,sal) values("+v1+",'"+v2+"',"+v3+")");
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();
}
}