import java.sql.DriverManager;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
import java.sql.ResultSet;
import javax.swing.JOptionPane;

Coding for ADD button:
int Admission_Number=0;
   Admission_Number=Integer.parseInt(jTextField1.getText());
   String Student_Name=jTextField2.getText();
   String Stream= jTextField3.getText();

   try{
   Class.forName("java.sql.DriverManager");
   Connection con = (Connection)
   DriverManager.getConnection ("jdbc:mysql://localhost:3306/School","root", "tiger");
   Statement stmt = (Statement) con.createStatement();
   String query="INSERT INTO Ind_Donations VALUES ('"+Admission_Number+"','"+Student_Name+"','"+Stream+"');";
   stmt.executeUpdate(query);
       }
   catch(Exception e){
           JOptionPane.showMessageDialog(rootPane, e.getMessage());
   }
Coding for MODIFY button:

    int Admission_Number= Integer.parseInt(jTextField1.getText());
       try{
       Class.forName("java.sql.DriverManager");
       Connection con=(Connection)
       DriverManager.getConnection("jdbc:mysql://localhost:3306/STUDENT","root","tiger");
       Statement stmt=(Statement) con.createStatement();
       String query="SELECT*FROM STUDENT WHERE Admission_Number=”+Admission_Number+”;";
       ResultSet rs= stmt.executeQuery(query);

       if(rs.next())
       {
         Admission_Number= rs.getInt("Admission_Number");
         String STUDENT_NAME= rs.getString("STUDENT_NAME");
         String STREAM= rs.getString("STREAM");
         jTextField1.setText(Integer.toString(Admission_Number));
         jTextField2.setText(STUDENT_NAME);
         jTextField3.setText(STREAM);
       }
       }
       catch(Exception e){
               JOptionPane.showMessageDialog(this, e.getMessage());
   }


Coding for “Clear” button:
jTextField1.setText(“”);
jTextField2.setText(“”);
jTextField3.setText(“”);

Coding for “Exit” button:
System.exit(0);