SiLeBAT/FSK-Lab

View on GitHub

Showing 14,752 of 14,752 total issues

Define a constant instead of duplicating this literal " SET " 7 times.
Open

String sql = "UPDATE " + delimitL(tableName) + " SET " + delimitL(fieldName) + " = NULL WHERE " + delimitL("ID") + " = " + id;

Define a constant instead of duplicating this literal "Freigabe" 5 times.
Open

new LinkedHashMap[]{null,null,null,null,null,null,null,null,allHashes.get("Freigabe"),null,lt,null},

Define a constant instead of duplicating this literal "Tabelle" 9 times.
Open

String sql = "DELETE FROM " + delimitL("DateiSpeicher") + " WHERE " + delimitL("TabellenID") + "=" + id + " AND" + delimitL("Tabelle") + "='" + tableName + "' AND "

Define a constant instead of duplicating this literal "Zutat" 4 times.
Open

h1.put("Zutat", "Zutat");

Refactor this method to reduce its Cognitive Complexity from 19 to the 15 allowed.
Open

public static List<String> getUsageListOfID(final String tableName, int id) {

Define a constant instead of duplicating this literal " WHERE " 4 times.
Open

ResultSet rs = getResultSet("SELECT COUNT(*) FROM " + DBKernel.delimitL("Users") + " WHERE " + DBKernel.delimitL("Zugriffsrecht") + " = " + Users.ADMIN + " AND "

Define a constant instead of duplicating this literal "KostenEinheit" 4 times.
Open

MyTable kits = new MyTable("Kits", new String[]{"Bezeichnung","Testanbieter","ZertifikatNr","Gueltigkeit","Zertifizierungssystem","AnbieterAngebot","Kosten","KostenEinheit",

Define a constant instead of duplicating this literal " FOR EACH ROW " 6 times.
Open

DBKernel.delimitL(tableName) + " FOR EACH ROW " + " CALL " + DBKernel.delimitL(new MyTrigger().getClass().getName()), false); // (oneThread ? "QUEUE 0" : "") +

Define a constant instead of duplicating this literal "Versuchsbedingungen" 3 times.
Open

MyTable tenazity_raw_data = new MyTable("Versuchsbedingungen", new String[]{"Referenz","Agens","AgensDetail","Matrix","EAN","MatrixDetail",

Define a constant instead of duplicating this literal "Station" 3 times.
Open

MyTable Knoten = new MyTable("Station", new String[]{"Produktkatalog","Name","Strasse","Hausnummer","Postfach","PLZ","Ort","District","Bundesland","Land","Longitude","Latitude","Ansprechpartner","Telefon","Fax","EMail","Webseite","Betriebsnummer","Betriebsart","VATnumber","Code",

Define a constant instead of duplicating this literal "Produktkatalog" 3 times.
Open

MyTable Knoten = new MyTable("Station", new String[]{"Produktkatalog","Name","Strasse","Hausnummer","Postfach","PLZ","Ort","District","Bundesland","Land","Longitude","Latitude","Ansprechpartner","Telefon","Fax","EMail","Webseite","Betriebsnummer","Betriebsart","VATnumber","Code",

Define a constant instead of duplicating this literal "Gruppenschluesselnummer" 4 times.
Open

new String[]{"Gruppenschluesselnummer","Gruppentitel"},

Define a constant instead of duplicating this literal "SELECT " 56 times.
Open

String sql = "SELECT " + idConf +

Define a constant instead of duplicating this literal "Restore" 3 times.
Open

fc.setDialogTitle("Restore");

Use try-with-resources or close this "FileInputStream" in a "finally" clause.
Open

FileInputStream fis = new FileInputStream(fl);

Define a constant instead of duplicating this literal "FKCOLUMN_NAME" 6 times.
Open

String fkc = rs.getObject("FKCOLUMN_NAME") != null ? rs.getString("FKCOLUMN_NAME") : "";

Define a constant instead of duplicating this literal "Infotabelle" 3 times.
Open

ResultSet rs = getResultSet(conn, "SELECT " + delimitL("Wert") + " FROM " + delimitL("Infotabelle") + " WHERE " + delimitL("Parameter") + " = 'lastCache_" + tablename

Use static access with "java.awt.Frame" for "MAXIMIZED_BOTH".
Open

DBKernel.prefs.put("LAST_MainFrame_FULL", DBKernel.mainFrame.getExtendedState() == JFrame.MAXIMIZED_BOTH ? "TRUE" : "FALSE");

Refactor this method to reduce its Cognitive Complexity from 17 to the 15 allowed.
Open

public static Object insertDBL(final String tablename, final String fieldname, final Integer tableID, Object kzID, String kz, Object value) {

Refactor this method to reduce its Cognitive Complexity from 16 to the 15 allowed.
Open

public static File getCopyOfInternalDB() {
Severity
Category
Status
Source
Language