package agenda;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;

class MyConnection {

     private Connection con;
    Statement stmt;
    String url = "jdbc:mysql://127.0.0.1:3306/agenda";
    String user = "root";
    String password = "aluno@etep";

    public MyConnection() throws ClassNotFoundException {

        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection(url, user, password);
            stmt = con.createStatement();
            System.out.println("Conectado com sucesso!");

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

        try{
        stmt.execute("INSERT INTO contato VALUES (NULL,'Evandro','12','3211-9640');");
        }catch(SQLException e){
            System.out.println("Error: "+ e.getMessage());
        }
    }

}