agendanaopronta

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package agenda_inofx;


import com.mysql.jdbc.PreparedStatement;
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.scene.Group;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.Label;
import javafx.scene.control.ListView;
import javafx.scene.control.TextArea;
import javafx.scene.control.TextField;
import javafx.scene.image.Image;
import javafx.scene.image.ImageView;
import javafx.scene.layout.HBox;
import javafx.scene.layout.StackPane;
import javafx.scene.layout.VBox;
import javafx.scene.paint.Color;
import javafx.scene.text.Text;
import javafx.stage.Stage;
import org.apache.commons.mail.DefaultAuthenticator;
import org.apache.commons.mail.Email;
import org.apache.commons.mail.EmailException;
import org.apache.commons.mail.SimpleEmail;

/*
 *
 * @author tina
 */
public class Agenda_InoFX extends Application {

    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/agenda";
    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="";
   //vbmil1
        Label lbmaildestino=new Label("email destino");
         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();


    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
                        +"emamil="+email+
                         "informe="+informes
                                               );

              names.add(nome);

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

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

                 String  strpesquisalista2=strpesquisalista;
                 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);
        }




    }
    @Override
    public void start(Stage stage) {
 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"));

        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().add(iv1);

        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 BtListSms = new Button("SMS's");
        hb2.getChildren().addAll(btAtende, btDisca, BtListSms);

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


        //mysql
       mysqlsddlol();

       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();
                }
        });
       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) {



        Stage stagemail=new Stage();
        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");
         vbomil1.getChildren().addAll(lbmaildestino,tfmail_destino,
                 lbmailsubject,tfmail_subject,lbmail_area,tareamail,btenviarmail);

         tfmail_destino.setPromptText(""+vldadosemail);
         gpmail.getChildren().add(vbomil1);




         btenviarmail.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {

     Email email = new SimpleEmail();
      try {
   email.setHostName("smtp.googlemail.com");
email.setSmtpPort(465);
email.setAuthentication("xxxxx", "xxxxx");
email.setSSLOnConnect(true);

             email.setFrom("mabsonsktasd@gmail.com");
             email.setSubject("Subject: "+tfmail_subject.getText());
email.setMsg(":)"+tareamail.getText());
email.addTo(""+vldadosemail);
email.send();
          System.out.println("email enviado");
         } catch (EmailException ex) {
             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);
    }

}
bem10jfx.blogspot.com