Inserting records in SQL Database using JAVA Applets




import java.sql.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

public class InsertRecord extends JFrame implements ActionListener

{

JPanel panel;

JLabel lName, lPhone;

JTextField tName, tPhone;

JButton btnInsert;

public InsertRecord()

{

panel=new JPanel();

getContentPane().add(panel);

lName=new JLabel(“Name”);

lPhone=new JLabel(“Phone”);

tName=new JTextField(10);

tPhone=new JTextField(10);

btnInsert=new JButton(“Insert”);

panel.add(lName);panel.add(tName);

panel.add(lPhone);panel.add(tPhone);

panel.add(btnInsert);

btnInsert.addActionListener(this);

setSize(300,300); setVisible(true);}

public void actionPerformed(ActionEvent evt)

{

if(evt.getSource()==btnInsert)

{

try{

Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

Connection conn=DriverManager.getConnection(“jdbc:odbc:MyDSN”);

PreparedStatement stat=conn.prepareStatement(“insert into

registration (name, phone) values(?,?)”);

String name=tName.getText();

String phone=tPhone.getText();

stat.setString(1,name);

stat.setString(2,phone);

int val=stat.executeUpdate();

if(val>=1)

JOptionPane.showMessageDialog(null,”1 record inserted”);

else

JOptionPane.showMessageDialog(null,”record inserted”);

}

catch(ClassNotFoundException ex)

{

JOptionPane.showMessageDialog(null,”driver” +ex);

}

catch (SQLException ex)

{

JOptionPane.showMessageDialog(null,”SQL” + ex);

}

catch(Exception ex)

{

JOptionPane.showMessageDialog(null,”ERROR ” + ex);

}

}}

public static void main(String []args)

{

new InsertRecord();

}

}

Inheritance in JAVA

class applicant
{
String name;
int appno;
String address;
public applicant()
{
appno=1;
name=”ram”;
address=”Ktm”;

}
public void displayDetails()
{
System.out.println (“App Number : ” + appno);
System.out.println (“Name : ” + name);

System.out.println (“Address : ” + address);

}
}

public class candidate extends applicant
{
String date;
public candidate()
{
date=”8/9/2000″;
}
public void displayDetails()
{
super.displayDetails();
System.out.println(“Date of Interview : ” + date);
}
public static void main (String args[])
{
candidate obj=new candidate();
obj.displayDetails();
}
}

Please save this file as candidate.java