public void insertMedicineData(Medicine medicine) throws SQLException {
        try {
            databaseConnector = medicineConnector.getConnection();

            SQLQuery = "INSERT INTO familydoctor.medicine " + "VALUES(?,?,?,?,?,?,?)";
            PreparedStatement preparedStatement = databaseConnector.prepareStatement(SQLQuery);

            preparedStatement.setLong(1, 0);
            preparedStatement.setLong(2, medicine.getBarcodeNumber());
            preparedStatement.setString(3, medicine.getMedicineName());
            preparedStatement.setString(4, medicine.getMedicineBrand());
            preparedStatement.setDouble(5, medicine.getPrice());
            preparedStatement.setInt(6, medicine.getQuantity());
            preparedStatement.setString(7, medicine.getSupplier());
            preparedStatement.executeUpdate();

        } catch (SQLException e) {
            System.out.println(e.getMessage() + " error");
        } finally {
            if (stmnt != null) {
                stmnt.close();
            }
            if (databaseConnector != null) {
                databaseConnector.close();
            }
        }
    }