int No = Integer.parseInt(jTextField1.getText());
 try{
 Class.forName("java.sql.DriverManager");
 Connection con = (Connection)
 DriverManager.getConnection("jdbc:mysql://localhost:3306/schoolz","root", "tiger");
 Statement stmt = (Statement) con.createStatement();
 String query="Delete from student where admission_number = ('"+No+"');";
 stmt.executeUpdate(query);
 }
catch(Exception e)

{

 JOptionPane.showMessageDialog (this, e.getMessage());
 }


############



int No = Integer.parseInt(jTextField1.getText());
String Name=jTextField2.getText();
String Stream=jTextField3.getText();
 try{
 Class.forName("java.sql.DriverManager");
 Connection con = (Connection)
 DriverManager.getConnection("jdbc:mysql://localhost:3306/schoolz","root", "tiger");
 Statement stmt = (Statement) con.createStatement();
 String query="INSERT INTO student VALUES ('"+No+"','"+Name+"','"+Stream+"');";
 stmt.executeUpdate(query);
 }
catch(Exception e)

{

 JOptionPane.showMessageDialog (this, e.getMessage());
 }