import java.awt.*;
import java.sql.*;
import java.applet.*;
import java.awt.event.*;

class RegistrationApplet extends Applet implements ActionListener{
TextField text1,text2,text3,text4;
Label label1,label2,label3,label4;
Button button;
public void init() {
text1=new TextField(15);
text2=new TextField(15);
text3=new TextField(15);
text4=new TextField(15);
label1=new Label("First Name");
label2=new Label("Last Name");
label3=new Label("Address");
label4=new Label("Phone No");
button=new Button("Save");

label1.setBounds(10,10,100,20);
text1.setBounds(120,10,100,20);

label2.setBounds(10,40,100,20);
text2.setBounds(120,40,100,20);

label3.setBounds(10,70,100,20);
text3.setBounds(120,70,100,20);

label4.setBounds(10,100,100,20);
text4.setBounds(120,100,100,20);

button.setBounds(120,130,100,20);

add(label1);
add(text1);
add(label2);
add(text2);
add(label3);
add(text3);
add(label4);
add(text4);
  button.addActionListener(this);
}
public void actionPerformed(ActionEvent ae){
String value1=text1.getText();
String value2=text2.getText();
String value3=text3.getText();
String value4=text4.getText();
System.out.println(value1);
Connection con = null;
String url = "jdbc:mysql://localhost:3306/";;
String db = "test";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
Statement st = con.createStatement();

int k=st.executeUpdate("insert into data(firstname,lastnameaddress,contactno) values('"+value1+"','"+value2+"','"+value3+"','"+value4+"')");
JOptionPane.showMessageDialog(null,"Data is successfully saved");
}
catch(Exception e){}
}

}