try {

            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=db_user_info1;username=sa;password=p@ssw0rd");
            String sql = "delete tbl_user_info where number = '" + txt_number.getText() + "'";
            PreparedStatement pst = con.prepareStatement(sql);
            int rs = pst.executeUpdate();

            JOptionPane.showMessageDialog(null, "Successfully deleted!");
            loaddata();
            con.close();
       txt_lname.setText("");
       txt_fname.setText("");
       txt_mname.setText("");
       txt_add.setText("");
       txt_cell.setText("");
       txt_citi.setText("");
       txt_pla.setText("");
       txt_occ.setText("");
       txt_inc.setText("");
       txt_gua.setText("");
       txt_number.setText("");
      cbox_rela.setSelectedItem("Single");
      cboxmonth.setSelectedItem("Jan");
      cboxdate.setSelectedItem("1");
      cboxyear.setSelectedItem("2020");
      cbox_sex.setSelectedItem("Male");
      cboxage.setSelectedItem("1");

             } catch(Exception e)
        {
               JOptionPane.showMessageDialog(null, e);
        }
    }