private void insertData(SymptomsData data) {
    Connection connection = null;
    Statement statement = null;
    try {
      connection = DatabaseHelper.getConnection();
      statement = connection.createStatement();

      String query =
          "Insert into medicine_table values("
              + data.getId()
              + ", '"
              + data.getSymptoms()
              + "', '"
              + data.getMedicines()
              + "')";
      statement.executeUpdate(query);

    } catch (SQLException e) {
      e.printStackTrace();
    } finally {
      if (connection != null) {
        try {
          connection.close();
        } catch (SQLException e) {
          e.printStackTrace();
          System.out.println(e);
        }
      }
    }
  }
  private void jButton1ActionPerformed(
      java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton1ActionPerformed
    // TODO add your handling code here:
    dispose();
    success_patdiagnose sp = new success_patdiagnose();
    sp.setVisible(true);

    SymptomsData data = new SymptomsData();
    data.setId(Integer.parseInt(id.getText()));
    data.setSymptoms(symptoms.getText());
    data.setMedicines(medicine.getText());
    insertData(data);
  } // GEN-LAST:event_jButton1ActionPerformed