public void conector_passwd(string VarAux1, string VarAux2, string VarAux3, string VarAux5, string VarAux6, string passwd, string newpasswd) { int temp = 0; string select = ""; select = "replace INTO `conector`.`licenca_adm`"; select += " ( "; select += " `cnpj`, "; select += " `aquisicao`, "; select += " `periodoUso`, "; select += " `password`, "; select += " `statusPgto`, "; select += " `idloja` "; select += " ) "; select += " VALUES "; select += "( "; select += " ?VarAux1, "; select += " ?VarAux2, "; select += " ?VarAux3, "; select += " AES_ENCRYPT(?Passwd,?newPasswd), "; select += " ?VarAux5, "; select += " ?VarAux6 "; select += ")"; try { banco.abreConexao(); banco.iniciarTransacao(); banco.singleTransaction(select); banco.addParametro("?VarAux1", VarAux1); banco.addParametro("?VarAux2", VarAux2); banco.addParametro("?VarAux3", VarAux3); banco.addParametro("?passwd", passwd); banco.addParametro("?newpasswd", newpasswd); banco.addParametro("?VarAux5", VarAux5); banco.addParametro("?VarAux6", VarAux6); banco.procedimentoText(); banco.commit(); } catch (Exception erro) { banco.rollback(); temp = 1; } finally { banco.fechaConexao(); if (temp == 0) { } } }