ClienteDAO

package controle;

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.List;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import modelo.Cliente;
import modelo.DadosCliente;

public class ClienteDAO {
    public static Connection connection = null;
    Statement statement = null;
    public static ResultSet resultset = null;
    private Object bDOB;
    Cliente cliente=new Cliente();

    private static final String SQL_UPDATE="UPDATE cliente SET "+
    "nome= ?,dataNsc= ?,horaContato= ?,contato= ?,credito= ?,"
    +"WHERE ID= ?";
     private static final String SQL_INSERT= "INSERT INTO cliente (nome, data_nsc, hora_contato, contato, credito) "+
    " VALUES"+"(?,?,?,?,?)";

     //conectar
    public void conectar() throws java.sql.SQLException {
    String servidor ="jdbc:mysql://127.0.0.1/projeto?autoReconnect=true&useSSL=false";
    String usuario = "root";
    String senha = "a4s4t2a4*@";
    String driver = "com.mysql.jdbc.Driver";
    try {

        Class.forName(driver);
        ClienteDAO.connection = DriverManager.getConnection(servidor,usuario,senha);
        connection.setAutoCommit(true);
        this.statement = ClienteDAO.connection.createStatement();
            }
    catch(Exception e){
        JOptionPane.showMessageDialog(null,"Erro ao conectar "+ e.getMessage());
        }
    }

    public boolean estaConectado() {

    if(ClienteDAO.connection != null) {
        return true;
    }
    else {
        return false;
        }
    }

        //desconectar
        public void desconectar() {
        try {
            ClienteDAO.connection.close();
        }
        catch(Exception e) {
            JOptionPane.showMessageDialog(null,"Erro ao desconectar "+ e.getMessage());
        }
    }

        //Salvar
        public static void Salvar(Cliente cliente) throws SQLException {
        ((ClienteDAO) ClienteDAO.connection).conectar();
         try {
        PreparedStatement ps= ClienteDAO.connection.prepareStatement("INSERT INTO cliente (nome, data_nsc, hora_contato, contato, credito) "+
                " VALUES"+"(?,?,?,?,?)");
        Date data = new Date(0);
        SimpleDateFormat formatar= new SimpleDateFormat("yyyy-MM-dd");
        String dataformatada= formatar.format(data);
        System.out.println(dataformatada);

        Date hora = new Date(0);
        SimpleDateFormat formatarH= new SimpleDateFormat("HH:mm:ss");
        String horaformatada= formatarH.format(hora);
        System.out.println(horaformatada);

        ps.setString(1,cliente.getNome());
        ps.setString(2, dataformatada);
        ps.setString(3,horaformatada);
        ps.setInt(4,cliente.getContato());
        ps.setDouble(5,cliente.getCredito());
        ps.execute();
        JOptionPane.showMessageDialog(null,"Dados inseridos com sucesso!");
        }
         catch(Exception e) {
             JOptionPane.showMessageDialog(null,"Erro ao salvar dados "+ e);
         }
         ((ClienteDAO) ClienteDAO.connection).desconectar();
        }


        //Excluir
        public static void Excluir(Cliente cliente) throws SQLException {
         ((ClienteDAO) ClienteDAO.connection).conectar();
         try {
         PreparedStatement ps= ClienteDAO.connection.prepareStatement("DELETE from cliente where id=?");
         ps.setInt(1,cliente.getId());
         }
         catch(Exception e) {
             JOptionPane.showMessageDialog(null,"Erro ao excluir dados "+ e.getMessage());
         }
         ((ClienteDAO) ClienteDAO.connection).desconectar();
        }


        //Pesquisar
        public static Cliente Pesquisar(Cliente cliente) throws SQLException{
             ((ClienteDAO) ClienteDAO.connection).conectar();
             ((ClienteDAO) ClienteDAO.connection).executaSQL("SELECT * from cliente where nome like'%"+cliente.getPesquisa()+"%'");
             try {
             ClienteDAO.resultset.first();
             cliente.setId(ClienteDAO.resultset.getInt("id"));
             cliente.setNome(ClienteDAO.resultset.getString("nome"));
             cliente.setDataNsc(ClienteDAO.resultset.getDate("data_nsc"));
             cliente.setHoraContato(ClienteDAO.resultset.getDate("hora_contato"));
             cliente.setContato(ClienteDAO.resultset.getInt("contato"));
             cliente.setCredito(ClienteDAO.resultset.getDouble("credito"));
             }
             catch(Exception e) {
                 JOptionPane.showMessageDialog(null,"Erro ao buscar dados "+ e.getMessage());
             }
             ((ClienteDAO) ClienteDAO.connection).desconectar();
            return cliente;
        }

        public void executaSQL(String sql) {
            try {
                statement= connection.createStatement(resultset.TYPE_SCROLL_INSENSITIVE,resultset.CONCUR_READ_ONLY);
                resultset= statement.executeQuery(sql);
            } catch (SQLException e) {
                JOptionPane.showMessageDialog(null,"Erro ao executar SQL "+ e.getMessage());
            }


        }

}