- versions Community Edition - Version 8.1 (build 31237)
try {
StringBuffer sqlStmt = new StringBuffer();
sqlStmt.append("SELECT ...");
pst = cn.prepareStatement(sqlStmt.toString());
pst.setString(1, uniqueNumber);
rs = pst.executeQuery();
if (rs.next()) {
return rs.getString("VENDOR_NUMBER");
}
return null;
} catch (Exception e) {
throw e;
} finally {
if (rs != null) {
rs.close();
}
if (pst != null) {
pst.close();
}
}
Image of the SonarQube output
https://pasteboard.co/JD3kaVh.png