telefonearduinoejavafx

/*
 * aplicativo criado por knb mabson neves
mais contatos em bem10jfx.blogspot.com
 */
package agenda_inofx;


import com.mysql.jdbc.PreparedStatement;
import java.awt.Choice;
import java.io.File;
import java.net.InetAddress;
import java.net.NetworkInterface;
import java.net.SocketException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Enumeration;
import java.util.logging.Level;
import java.util.logging.Logger;
import javafx.application.Application;
import javafx.beans.value.ChangeListener;
import javafx.beans.value.ObservableValue;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.event.Event;
import javafx.event.EventHandler;
import javafx.geometry.Orientation;
import javafx.geometry.Pos;
import javafx.scene.Group;
import javafx.scene.Scene;
import javafx.scene.control.Alert;
import javafx.scene.control.Button;
import javafx.scene.control.ChoiceBox;
import javafx.scene.control.Label;
import javafx.scene.control.ListView;
import javafx.scene.control.Menu;
import javafx.scene.control.MenuBar;
import javafx.scene.control.MenuItem;
import javafx.scene.control.Separator;
import javafx.scene.control.TextArea;
import javafx.scene.control.TextField;
import javafx.scene.image.Image;
import javafx.scene.image.ImageView;
import javafx.scene.input.KeyEvent;
import javafx.scene.input.MouseEvent;
import javafx.scene.layout.HBox;
import javafx.scene.layout.StackPane;
import javafx.scene.layout.VBox;
import javafx.scene.paint.Color;
import javafx.scene.shape.Line;
import javafx.scene.text.Text;
import javafx.stage.FileChooser;
import javafx.stage.FileChooser.ExtensionFilter;
import javafx.stage.Stage;
import jssc.SerialPort;
import jssc.SerialPortEvent;
import jssc.SerialPortEventListener;
import jssc.SerialPortException;
import jssc.SerialPortList;
import org.apache.commons.mail.DefaultAuthenticator;
import org.apache.commons.mail.Email;
import org.apache.commons.mail.EmailAttachment;
import org.apache.commons.mail.EmailException;
import org.apache.commons.mail.MultiPartEmail;
import org.apache.commons.mail.SimpleEmail;

/*
 */
public class Agenda_InoFX extends Application {
 Stage stagemail=new Stage();
    Label txNome = new Label("Nome");
    TextField tfnome = new TextField();
    Label txtelefone = new Label("Telefone");
    TextField tftelefone = new TextField();
    Label txemail = new Label("Email");
    TextField tfemail = new TextField();

    Label txInfo = new Label("Informaçoes");
    TextField tfinfo = new TextField();
    ObservableList<String> names = FXCollections.observableArrayList();
    ListView<String> listView = new ListView<String>(names);

    String url = "jdbc:mysql://localhost/agenda1";
    String strlerbd = "SELECT * FROM contatos";
    Connection conection;
    String Executebd;
    String strDeletebd;
    String strSavebd;
    String vllist;
    String informes;
     Label lbdadosnome;
        Label lbdadostelefone;
        Label lbdadosemail;
        Label lbdadosinformer;
        String vldadostenefone="",vldadosnome="",vldadosinformer="",vldadosemail="";
        String strpesquisalista="";
         SerialPort serialport;
    String input;
        //vbmil1
        Label lbmaildestino=new Label("email dsetino");
         TextField tfmail_destino=new TextField();
         Label lbmailsubject=new Label("titulo");
         TextField tfmail_subject=new TextField();
         Label lbmail_area=new Label("mensagens a enviar");
         TextArea tareamail=new TextArea();
          File selectFile ;
          FileChooser fc;
          TextField tfDial=new TextField();
          ObservableList<String> namesDial = FXCollections.observableArrayList( );
        ListView<String> listViewDial = new ListView<String>(namesDial);
         String vlkeyrelase;
         TextArea tadial=new TextArea();
         Button btportas = new Button("conectar");
                         int  i=0;
      String axp="";
      String strvlDigitos="";

    void mysqlsddlol(){

         try {


             conection=DriverManager.getConnection(url,"root","");
            PreparedStatement pesquisa=(PreparedStatement) conection.prepareStatement(""+Executebd);

             if(Executebd==strlerbd) {
           names.clear();
            pesquisa.executeQuery();

            ResultSet resultado=pesquisa.executeQuery();
            while (resultado.next()) {
                String nome=resultado.getString("nome");
                String telefone=resultado.getString("telefone");
                String email=resultado.getString("email");
                String informes=resultado.getString("informe");
                 System.out.println("nome="+nome+

                        "telefone="+telefone
                        +"email="+email+
                         "informe="+informes
                                               );

              names.add(nome);

           }
             }else if(Executebd==strDeletebd) {
                  pesquisa.executeUpdate();

           }else if(Executebd==strSavebd){
                pesquisa.executeUpdate();
            }
             else if(Executebd==strpesquisalista){
                pesquisa.executeQuery();


                 ResultSet resultado=pesquisa.executeQuery();
            while (resultado.next()) {
                String nome=resultado.getString("nome");
                String telefone=resultado.getString("telefone");
                String email=resultado.getString("email");
                String informes=resultado.getString("informe");
                 System.out.println("nome="+nome+

                        "telefone="+telefone
                        +"emamil="+email+
                         "informe="+informes);
               vldadosnome=nome;
               vldadostenefone=telefone;
               vldadosemail=email;
               vldadosinformer=informes;
               lbdadosnome.setText("Nome:"+vldadosnome);
        lbdadostelefone.setText("Telefone:"+vldadostenefone);
         lbdadosemail.setText("Email:"+vldadosemail);
        lbdadosinformer.setText("Informer:\n"+vldadosinformer);

           }

            }
    } catch (SQLException ex) {
            Logger.getLogger(Agenda_InoFX.class.getName()).log(Level.SEVERE, null, ex);
        }
     }



//comunicaçao jssc


    public void stageconfigport(){
    Stage stageportas=new Stage();
    Group gpportas=new Group();
    Scene sceneportas=new Scene(gpportas,350,250,Color.SILVER);
    stageportas.setScene(sceneportas);

       VBox vbportas = new VBox();
        HBox hb1portas = new HBox(10);
        Label lbportas = new Label("portas");

        hb1portas.getChildren().addAll(lbportas, cbportas1);
        HBox hb2portas = new HBox(10);
        Label lbvelocidade = new Label("velocidade");

        hb2portas.getChildren().addAll(lbvelocidade, cbbauds);


        vbportas.getChildren().addAll(hb1portas, hb2portas, btportas);

       vbportas.prefHeightProperty().bind(stageportas.heightProperty().divide(3).subtract(25));
       vbportas.prefWidthProperty().bind(stageportas.widthProperty().divide(3).subtract(10));

       vbportas.layoutYProperty().bind(stageportas.heightProperty().divide(3).subtract(25));
       vbportas.layoutXProperty().bind(stageportas.widthProperty().divide(3).subtract(10));


        gpportas.getChildren().addAll(vbportas);


   btportas.setOnMouseClicked(new EventHandler<MouseEvent>() {
        @Override
        public void handle(MouseEvent event) {
        sconections();

        }
    });


    stageportas.show();


    }
    //arequisiçoes de de conexao com jssc serao confirmadas aprtir destas instancia
    ChoiceBox cbportas1 = new ChoiceBox();
         ChoiceBox cbbauds = new ChoiceBox();
    public void seachlistports(){



             cbbauds.getItems().clear();
        final String[] serialPortasNomes = SerialPortList.getPortNames();
        for (String nomeportas : serialPortasNomes) {
            cbportas1.getItems().addAll("" + nomeportas);
            System.out.println(" porta" + nomeportas);
        }


    }


    public void sconections(){

                                System.out.println("POrta escolhida " + cbportas1.getValue().toString());
                                serialport = new SerialPort(cbportas1.getValue().toString());
                                try {
                                    serialport.openPort();
                                    serialport.setParams(9600, 8, 1, 0);
                                    serialport.setEventsMask(SerialPort.MASK_RXCHAR);
                                    System.out.println("conectado");
                                } catch (SerialPortException ex) {
                                    //Logger.getLogger(ControlePCVolumeGTAFXIINO2.class.getName()).log(Level.SEVERE, null, ex);
                                }

                                if (serialport.isOpened() == true) {
                                   btportas.setText("Desconectar");
                                } else {
                                        btportas.setText("Conectar");

                                }



                                try {
                                    serialport.addEventListener(new SerialPortEventListener() {
                                        @Override
                                        public void serialEvent(SerialPortEvent serialPortEvent) {


                                            try {
                                                input = serialport.readString(serialPortEvent.getEventValue());
                                                if (serialPortEvent.isRXCHAR()) {
                                                    if (input.endsWith("\r\n")) {

                                                        String vlx = input.substring(0, input.indexOf("\r\n"));
                                                        System.out.println("dados recebidos" + vlx);
                                                        tadial.appendText("recebido="+ vlx+"\n");

                                                    }}
                                            } catch (SerialPortException ex) {
                                                Logger.getLogger(Agenda_InoFX.class.getName()).log(Level.SEVERE, null, ex);
                                            }


                                        }});
                                } catch (SerialPortException ex) {
                                    Logger.getLogger(Agenda_InoFX.class.getName()).log(Level.SEVERE, null, ex);
                                }
     }


    public void discador(){

    Stage stageDial=new Stage();
        Group gpDial=new Group();
        Scene sceneDial=new Scene(gpDial,400, 600, Color.SILVER);
        sceneDial.getStylesheets().addAll("" + getClass().getResource("DarkTheme.css"));

        stageDial.setScene(sceneDial);
      HBox hbdial1=new HBox();
    VBox vbdial1=new VBox();

    hbdial1.setLayoutX(10);
    hbdial1.setLayoutY(10);

    hbdial1.prefHeightProperty().bind(stageDial.heightProperty().subtract(50));
    hbdial1.prefWidthProperty().bind(stageDial.widthProperty().subtract(30));
     vbdial1.prefHeightProperty().bind(hbdial1.prefHeightProperty().subtract(30));
    vbdial1.prefWidthProperty().bind(hbdial1.prefWidthProperty().subtract(30));
     hbdial1.setStyle("-fx-background-color:#000000;\n"
                + "    -fx-border-radius: 10;\n"
                + "    -fx-background-radius: 15;\n"
                + "    -fx-padding: 5;");
    vbdial1.setStyle("-fx-background-color:#696969;\n"
                + "    -fx-border-radius: 10;\n"
                + "    -fx-background-radius: 15;\n"
                + "    -fx-padding: 5;");

    gpDial.getChildren().add(hbdial1);
    hbdial1.getChildren().add(vbdial1);
    Separator sp=new Separator(Orientation.HORIZONTAL);

            listViewDial.prefHeightProperty().bind(stageDial.heightProperty().divide(4));
        listViewDial.prefWidthProperty().bind(stageDial.widthProperty().subtract(15));
         namesDial.addAll(names);


        tfDial.setPromptText("digite");
        vbdial1.getChildren().addAll(listViewDial,sp,tfDial,new Separator(Orientation.HORIZONTAL));




        //1 hbox 2 vbox
                   //vb1 hb1 bt1 bt2 bt3

               //*vb1 quatro conjuntos de hbbox e conjunto de 3 butoes em cada hbox
               //vb22 botoes ligar e desligar
    HBox hbdialx1=new HBox();
     vbdial1.getChildren().addAll(hbdialx1);

     VBox vbdialx1=new VBox();
    VBox vbdialx2=new VBox();
      hbdialx1.getChildren().addAll(vbdialx1,vbdialx2);

      vbdialx2.getChildren().addAll(tadial);
      tadial.setPrefWidth(250);
      tadial.setPrefHeight(130);


 final HBox hbbt[] =new HBox[6];
     final Button btcp[]=new Button[13];

      hbbt[1]=new HBox();
      hbbt[2]=new HBox();
      hbbt[3]=new HBox();
      hbbt[4]=new HBox();
      hbbt[5]=new HBox();
       btcp[1]=new Button(""+1);
      btcp[2]=new Button(""+2);
      btcp[3]=new Button(""+3);
      btcp[4]=new Button(""+4);
      btcp[5]=new Button(""+5);
      btcp[6]=new Button(""+6);
      btcp[7]=new Button(""+7);
      btcp[8]=new Button(""+8);
      btcp[9]=new Button(""+9);
      btcp[10]=new Button("#");
      btcp[11]=new Button(""+0);
      btcp[12]=new Button("*");

      for ( i=1 ;i>13;i++){

      btcp[i].setAlignment(Pos.CENTER);
      btcp[i].setPrefSize(75,60);

      }

      btcp[1].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {
          strvlDigitos+=""+btcp[1].getText();
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });
      btcp[2].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {

      strvlDigitos+=""+btcp[2].getText();
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });
      //
      btcp[3].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {
          strvlDigitos+=""+btcp[3].getText();
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });
      btcp[4].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {

      strvlDigitos+=""+btcp[4].getText();
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });
      //
      btcp[5].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {
          strvlDigitos+=""+btcp[5].getText();
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });
      btcp[6].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {
      strvlDigitos+=""+btcp[6].getText();
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });

      btcp[7].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {
          strvlDigitos+=""+btcp[7].getText();
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });
      btcp[8].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {

      strvlDigitos+=""+btcp[8].getText();
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });

      btcp[9].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {

      strvlDigitos+=""+btcp[9].getText();
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });

      btcp[10].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {

      strvlDigitos+="#";
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });

      btcp[11].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {

      strvlDigitos+="0";
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });

      btcp[12].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {

      strvlDigitos+="*";
              System.out.println(" valor "+strvlDigitos);
              tfDial.setText(""+strvlDigitos);
          }
      });
      //buttons
      tfDial.setOnKeyReleased(new EventHandler<KeyEvent>() {
        @Override
        public void handle(KeyEvent event) {

            System.out.println(" valor "+strvlDigitos);
           // fazer pesquisa e adcionar no listview dial
          vlkeyrelase=strvlDigitos;
                        strpesquisalista="select * from contatos where nome=\""+ vlkeyrelase+"\"";
                         Executebd=strpesquisalista;
//pesquisa por listview
PreparedStatement pesquisalista;
            try {
                pesquisalista = (PreparedStatement) conection.prepareStatement(""+strpesquisalista);


                   ResultSet rpesquisalistacall=pesquisalista.executeQuery();




            while (rpesquisalistacall.next()) {
                String nome=rpesquisalistacall.getString("nome");
                String telefone=rpesquisalistacall.getString("telefone");
                String email=rpesquisalistacall.getString("email");
                String informes=rpesquisalistacall.getString("informe");
                 System.out.println("nome="+nome+

                        "telefone="+telefone
                        +"emamil="+email+
                         "informe="+informes);
               String vldadosnomelista=nome;
               String vldadostenefonelista=telefone;
                listViewDial.getItems().addAll(""+vldadosnomelista);

           }
           } catch (SQLException ex) {
                Logger.getLogger(Agenda_InoFX.class.getName()).log(Level.SEVERE, null, ex);
            }

        }
    });
      vbdialx1.getChildren().addAll(hbbt[1],hbbt[2],hbbt[3],hbbt[4],hbbt[5]);
      hbbt[1].getChildren().addAll(btcp[1],btcp[2],btcp[3]);
      hbbt[2].getChildren().addAll(btcp[4],btcp[5],btcp[6]);
      hbbt[3].getChildren().addAll(btcp[7],btcp[8],btcp[9]);
      hbbt[4].getChildren().addAll(btcp[10],btcp[11],btcp[12]);

      Button btsends[]=new Button[3];

      btsends[1]=new Button("send");
      btsends[2]=new Button("not");
      btsends[1].setAlignment(Pos.CENTER);
      btsends[2].setAlignment(Pos.CENTER);
      btsends[1].prefWidth(60+30);
      btsends[2].prefWidth(60+30);
      hbbt[5].getChildren().addAll(btsends[1],btsends[2]);





      //ligar
       btsends[1].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {
          axp="atd"+strvlDigitos+";\r";
          // axp="at;";
           // axp="123;";
         // byte byteEv=Byte.parseByte((String) axp );
              try {
                  serialport.writeBytes(axp.getBytes());
              } catch (SerialPortException ex) {
                  //Logger.getLogger(Agenda_InoFX.class.getName()).log(Level.SEVERE, null, ex);
                  System.out.println("nao conectado ou nao trasmitindo dados");
              }
              System.out.println(" valor "+strvlDigitos);

                tadial.appendText("enviado="+ axp);
          }
      });
       //desligar
      btsends[2].setOnMouseClicked(new EventHandler<Event>() {
          @Override
          public void handle(Event event) {
           try {
                  serialport.writeBytes("ATH0;\r".getBytes());
              } catch (SerialPortException ex) {
                  Logger.getLogger(Agenda_InoFX.class.getName()).log(Level.SEVERE, null, ex);
              }

              System.out.println(" \"ATH0\" " );
              tadial.appendText("enviado=ATH0;" );
              strvlDigitos="";
              axp="";
              tfDial.setText("");
          }
      });















    stageDial.show();







    }



    @Override
    public void start(Stage stage) {
        MenuItem menuitem1=new MenuItem("");
       final Menu menu1 = new Menu("comunicação");
       menu1.getItems().add(menuitem1);
        MenuBar menuBar = new MenuBar();
 menuBar.getMenus().addAll(menu1 );
  seachlistports();
 Executebd=strlerbd;
        Group gp = new Group();
        Scene scene = new Scene(gp, 750, 450, Color.ALICEBLUE);
        stage.setScene(scene);
        scene.getStylesheets().addAll("" + getClass().getResource("DarkTheme.css"));

        menuBar.prefWidthProperty().bind(stage.widthProperty());
        menuitem1.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
            stageconfigport();
            }
        });


        Image image = new Image("" + Agenda_InoFX.class.getResource("pexels.png"));

        // simple displays ImageView the image as is
        ImageView iv1 = new ImageView();
        iv1.setImage(image);
        gp.getChildren().addAll(iv1,menuBar);

        VBox vboxPrimeiro = new VBox(10);
        vboxPrimeiro.setStyle("-fx-background-color:#000000;\n"
                + "    -fx-border-radius: 10;\n"
                + "    -fx-background-radius: 15;\n"
                + "    -fx-padding: 5;");

        gp.getChildren().add(vboxPrimeiro);

        HBox hb1 = new HBox(5);
        vboxPrimeiro.layoutXProperty().bind(scene.widthProperty().divide(6).subtract(20));
        vboxPrimeiro.layoutYProperty().bind(scene.heightProperty().divide(6).subtract(15));
        VBox vb1 = new VBox();

        Label txTitle = new Label("Agenda telefonica JFX");

        tfnome.setPromptText("nome");
        tftelefone.setPromptText("Telefone");
        tfemail.setPromptText("Email");

        tfinfo.setPromptText("Informaçoes");
        HBox hbbt_info = new HBox(5);
        vb1.setStyle("-fx-background-color:#696969;\n"
                + "    -fx-border-radius: 10;\n"
                + "    -fx-background-radius: 15;\n"
                + "    -fx-padding: 5;");
        vb1.getChildren().addAll(
                txTitle, txNome, tfnome,
                txtelefone, tftelefone,
                txemail, tfemail, txInfo, tfinfo, hbbt_info
        );
        Button btSave = new Button("salvar");
        Button btEditar = new Button("Editar");
        hbbt_info.getChildren().addAll(btSave, btEditar);
        hbbt_info.setStyle("-fx-background-color:#000000;\n"
                + "    -fx-background-radius: 3;\n"
                + "    -fx-padding: 5;");
        VBox vb2 = new VBox();

        vb2.setStyle("-fx-background-color:#696969;\n"
                + "    -fx-border-radius: 0px 20px 0px 20px;\n"
                + "    -fx-background-radius: 15;\n"
                + "    -fx-padding: 5;");
        //funçoes so serao validaas se um contato for adcionado no button
        listView.setPrefSize(100, 180);
        HBox hbinfbutns = new HBox(5);

        Button btDel = new Button("DEL");
        Button btemail = new Button("Email");
        Button Btsms = new Button("SMS");
        Button Btligar = new Button("Ligar");
        hbinfbutns.getChildren().addAll(btDel, btemail, Btsms, Btligar);


        HBox hbdados1=new HBox(20);
         HBox hbdados2=new HBox(20);
         lbdadosnome=new Label("Nome:"+vldadosnome);
        lbdadostelefone=new Label("Telefone:"+vldadostenefone);
         lbdadosemail=new Label("Email:"+vldadosemail);
        lbdadosinformer=new Label("Informer:"+vldadosinformer);

        hbdados1.getChildren().addAll(lbdadosnome,lbdadostelefone);
        hbdados2.getChildren().addAll(lbdadosemail,lbdadosinformer);





        vb2.getChildren().addAll(listView, hbinfbutns,hbdados1,hbdados2);
        hb1.getChildren().addAll(vb1, vb2);

        HBox hb2 = new HBox(10);

        Button btAtende = new Button("Atender");
        Button btDisca = new Button("Discar");
        Button Btdesligar = new Button("Finalizar");
        hb2.getChildren().addAll(btAtende, btDisca, Btdesligar);

        vboxPrimeiro.getChildren().addAll(hb1, hb2);


        //mysql
       mysqlsddlol();
        Btligar.setOnMouseClicked(new EventHandler<MouseEvent>() {
            @Override
            public void handle(MouseEvent event) {
           axp="atd"+vldadostenefone+";\r";
          // axp="at;";
           // axp="123;";
         // byte byteEv=Byte.parseByte((String) axp );
              try {
                  serialport.writeBytes(axp.getBytes());
              } catch (SerialPortException ex) {
                  //Logger.getLogger(Agenda_InoFX.class.getName()).log(Level.SEVERE, null, ex);
                  System.out.println("nao conectado ou nao trasmitindo dados");
              }
              System.out.println(" valor "+vldadostenefone);

                tfDial.setText(vldadostenefone);
          discador();




            }
        });
       Btdesligar.setOnMouseClicked(new EventHandler<MouseEvent>() {
            @Override
            public void handle(MouseEvent event) {
        try {
                  serialport.writeBytes("ATH0;\r".getBytes());
              } catch (SerialPortException ex) {
                  Logger.getLogger(Agenda_InoFX.class.getName()).log(Level.SEVERE, null, ex);
              }

              System.out.println(" \"ATH0\"LIGAÇAO RECEBIDA FINALIZADA " );
              tadial.appendText("enviado=ATH0;" );


            }
        });
       btAtende.setOnMouseClicked(new EventHandler<MouseEvent>() {
            @Override
            public void handle(MouseEvent event) {

                try {

                     System.out.println("ATENDENDO ALIGAÇAO");
                    serialport.writeBytes("ATH1;\r".getBytes());
              tadial.appendText("enviado=ATH1;" );

                } catch (SerialPortException ex) {
                     System.out.println("porta nao conectada");
                 Alert al=new Alert(Alert.AlertType.ERROR);
                al.setContentText("O telefone nao esta\n"
                        + " conectado na porta de coneao\n"
                        + " no momento ou outro error");
                al.show(); }

            }
        });
       listView.getSelectionModel().selectedItemProperty().addListener(
            new ChangeListener<String>() {
                public void changed(ObservableValue<? extends String> ov,
                    String old_val, String new_val) {
                      System.out.println("informe "+new_val);

                       vllist=new_val;
                        strpesquisalista="select * from contatos where nome=\""+vllist+"\"";
                         Executebd=strpesquisalista;
//pesquisa por listview

                   mysqlsddlol();
                }
        });
       btDisca.setOnMouseClicked(new EventHandler<MouseEvent>() {
            @Override
            public void handle(MouseEvent event) {

            discador();




            }
        });


       btSave.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                String ipAddress = null;
        Enumeration<NetworkInterface> net = null;
        try {
            net = NetworkInterface.getNetworkInterfaces();
        } catch (SocketException e) {
            throw new RuntimeException(e);
        }

        while (net.hasMoreElements()) {
            NetworkInterface element = net.nextElement();
            Enumeration<InetAddress> addresses = element.getInetAddresses();
            while (addresses.hasMoreElements()) {
                InetAddress ip = addresses.nextElement();

                if (ip.isSiteLocalAddress()) {
                    ipAddress = ip.getHostAddress();
                    System.out.println(".handle()"+ipAddress.toString());
                    informes=tfinfo+"=+="+ipAddress;
                }
            }
        }

                if (tfnome.getText().length()>1&&tftelefone.getText().length()>1) {

                    strSavebd="insert into Contatos(nome,telefone,email,informe )"+
                            "values(\""+tfnome.getText()+"\",\""+tftelefone.getText()+
                            "\",\""+tfemail.getText()+"\",\""+tfinfo.getText()+"\");";
                     Executebd=strSavebd;
                     mysqlsddlol();
                      Executebd=strlerbd;
                     mysqlsddlol();
                }
            }
        });
       btemail.setOnAction(new EventHandler<ActionEvent>() {
     @Override
     public void handle(ActionEvent event) {
          stagemail.setTitle("Email para :"+vldadosemail);
        Group gpmail=new Group();
        Scene scenemail=new Scene(gpmail,400,400,Color.SILVER);
         stagemail.setScene(scenemail);

          scenemail.getStylesheets().addAll("" + getClass().getResource("DarkTheme.css"));
         VBox vbomil1=new VBox();
         //vbmail1
         Button btenviarmail=new Button("enviar email");

         Button btchoise=new Button("anexos");
         vbomil1.getChildren().addAll(lbmaildestino,tfmail_destino,
                 lbmailsubject,tfmail_subject,lbmail_area,tareamail,new HBox(btenviarmail,btchoise));
           tfmail_destino.setPromptText(""+vldadosemail);
         gpmail.getChildren().add(vbomil1);
            btchoise.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
             fc=new FileChooser();
             fc.setTitle("Open Resource File");

        selectFile = fc.showOpenDialog(null);
                if (selectFile != null) {
                    System.out.println("ARQUIVO ESCOLHIDO"+selectFile+
                            "\n"+selectFile.getName()+
                            "\n"+selectFile.toURI());
                }
            }

         });
         btenviarmail.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
        // EmailAttachment attachment = new EmailAttachment();


//attachment.setPath(""+selectFile.getAbsoluteFile() ); //caminho da imagem
//attachment.setDisposition(EmailAttachment.ATTACHMENT);
//attachment.setDescription("anexo");
//attachment.setName("APL Agenda");

   MultiPartEmail email = new MultiPartEmail();
      try {
              stagemail.setTitle(" AGUARDE ! ENVIANDO EMAIL PARA:"+vldadosemail);
   email.setHostName("smtp.googlemail.com");
email.setSmtpPort(465);
email.setAuthentication("appagendainofx", "xxxxxxxxxxxxx");
email.setSSLOnConnect(true);

             email.setFrom("xxxxxxx");
             email.setSubject("Subject: "+tfmail_subject.getText());
email.setMsg(":)"+tareamail.getText());
email.addTo(""+vldadosemail);
//email.attach(attachment);
email.send();
          System.out.println("email enviado");
           stagemail.setTitle("Email enviado para :"+vldadosemail);
         } catch (EmailException ex) {

          System.out.println("Email Nao Enviado");
           stagemail.setTitle("Email nao enviado para :"+vldadosemail);
             Logger.getLogger(Agenda_InoFX.class.getName()).log(Level.SEVERE, null, ex);
         }

            }
        });


         stagemail.show();




}
 });

          btDel.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                System.out.println("valox"+vllist);
                    strDeletebd="delete from Contatos where nome=\""+vllist+"\";";
                    //"+ vllista+"
                    Executebd=strDeletebd;
                     mysqlsddlol();
                      Executebd=strlerbd;
                     mysqlsddlol();
                }

        });

        stage.show();
    }

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        launch(args);
    }

}