package util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import model.Cliente;


public abstract class BancoDados {

    private static Connection con = null;

    public static Connection conectar(){

        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/sistema";
        String usuario = "root";
        String senha = "mysqlfatec";

        //Carrega, inde inicializa o driver do banco MYSQL
        try{
          Class.forName(driver);
        }catch(ClassNotFoundException ex){
             ex.printStackTrace();
        }

        //Conecta com o MySQL
        try{
        con = DriverManager.getConnection(url, usuario, senha);
           // JOptionPane.showMessageDialog(null, "Conectou com sucesso!");
        return con;
        }catch (SQLException ex) {
            ex.printStackTrace();
            return null;
        }


        }
    /*teste
    public static void main(String[] args) {
       conectar();
        }

    */

    public abstract boolean inserir(Cliente cliente);

    public abstract boolean excluir();

    public abstract boolean alterar();

    public abstract boolean pesquisar();

    public abstract boolean listar();

    }