private void jTextField1KeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jTextField1KeyTyped
        // TODO add your handling code here:
        try {
            clearPedidos();
            clearPedHas();
            String sql = "SELECT t2.idpedidos AS id_pedido , t1.nombres AS clientes, t3.nombre AS empleado, t2.precio_total "
                    + "FROM clientes AS t1, pedidos AS t2, empleados AS t3 "
                    + "WHERE t1.idclientes = t2.clientes_idclientes "
                    + "AND t3.idempleados = t2.empleados_idempleados "
                    + "AND t1.nombres LIKE ? "
                    + "ORDER BY t2.id_pedido";

            Connection connPed = Conexion.GetConnection();
            connPed.setAutoCommit(false);
            PreparedStatement ps = connPed.prepareStatement(sql);
            System.out.println("lol");
            ps.setString(1, "%"+jTextField1.getText()+"%");
            System.out.println("lel");
            
            Pedidos = ps.executeQuery();

            while (Pedidos.next()) {
                String[] row = {Pedidos.getString(1), Pedidos.getString(2), Pedidos.getString(3), Pedidos.getString(4)};
                tmPed.addRow(row);
            }
            
            jTablePedidos.setModel(tmPed);
            
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
    }//GEN-LAST:event_jTextField1KeyTyped