public int buscarIdForma(String nome) {
Connection con;
PreparedStatement stmt;
try {
con = ConexaoMySQL.conectar();
stmt = con.prepareStatement(SQL_BUSCAR_FORMA_PAGAMENTO_DESCRICAO);
stmt.setString(1, nome);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
return rs.getInt("idforma_pagamento_compra");
}
con.close();
} catch (SQLException ex) {
}
return 0;
}
public String buscarNomeForma(int id) {
Connection con;
PreparedStatement stmt;
try {
con = ConexaoMySQL.conectar();
stmt = con.prepareStatement(SQL_BUSCAR_FORMA_PAGAMENTO_ID);
stmt.setInt(1, id);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {
return rs.getString("descricao");
}
con.close();
} catch (SQLException ex) {
}
return "Erro";
}