如何用密码连接R中的数据库MySQL？(How to connect database MySQL in R with Password?)

 解决方案是： 
 
 
 
 使用Primefaces p:poll primefaces或p:remoteCommand来调用Backing Bean action 。 
<p:poll autoStart="true" listener="#{mBeanTesteIsolado.teste}"
        oncomplete="handleComplete(xhr, status, args)" interval="3" />
 或者使用p:remoteCommand ： 
<p:remoteCommand name="atualizarUI" actionListener="#{mBeanTesteIsolado.teste}" oncomplete="handleComplete(xhr, status, args)" />
 在p:remoteCommand情况下，使用setInterval随时间调用： 
setInterval(function() { atualizarUI(); }, 3000);
 
 
 在Backing Bean中，使用RequestContext.addCallbackParam将值返回到oncomplete使用的JavaScript函数， p:poll作为p:remoteCommand 。 
 设置Backing Bean返回Javascript函数： 
 管理Bean 
public void teste() {
    // Processamento necessário

    RequestContext context = RequestContext.getInstance();

    // Adiciona as variáveis para o JS (variável args da assinatura)
    context.addCallbackParam("nomeDoAtributo", "valor");
}
 处理JavaScript中的返回： 
 JS 
function handleComplete(xhr, status, args) {
    var nomeDoAtributo = args.nomeDoAtributo;

    // Atualizar UI
    gauge.setValueAnimated(nomeDoAtributo);
}
 

The solution was:
 
 
 
Uses Primefaces p:poll primefaces or p:remoteCommand to invoke a Backing Bean action.
 
<p:poll autoStart="true" listener="#{mBeanTesteIsolado.teste}"
        oncomplete="handleComplete(xhr, status, args)" interval="3" />
 
Or with the p:remoteCommand:
 
<p:remoteCommand name="atualizarUI" actionListener="#{mBeanTesteIsolado.teste}" oncomplete="handleComplete(xhr, status, args)" />
 
In case of p:remoteCommand, using a setInterval to call with time:
 
setInterval(function() { atualizarUI(); }, 3000);
 
 
In Backing Bean, uses the RequestContext.addCallbackParam to return values to JavaScript fuction used in oncomplete, so much of p:poll as p:remoteCommand.
 
Seting Backing Bean return to Javascript function:
 
Managed Bean
 
public void teste() {
    // Processamento necessário

    RequestContext context = RequestContext.getInstance();

    // Adiciona as variáveis para o JS (variável args da assinatura)
    context.addCallbackParam("nomeDoAtributo", "valor");
}
 
Treating the return in JavaScript:
 
JS
 
function handleComplete(xhr, status, args) {
    var nomeDoAtributo = args.nomeDoAtributo;

    // Atualizar UI
    gauge.setValueAnimated(nomeDoAtributo);
}