SiLeBAT/FSK-Lab

View on GitHub

Showing 14,752 of 14,752 total issues

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

Statement anfrage = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

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

fc.setSelectedFile(new File(DBKernel.myDBi.getDbUsername() + "_" + DBKernel.softwareVersion + "_" + sdf.format(c1.getTime()) + ".tar.gz"));

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

HSSFSheet businessSheet = wb.getSheet("Business_List");

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

Object day1 = DBKernel.getValue("Lieferungen", "ID", deliveryId1 + "", "dd_day");

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

sql = "SELECT " + DBKernel.delimitL("ID") + "," + DBKernel.delimitL("MHD") + "," + DBKernel.delimitL("Herstellungsdatum") + " FROM " + DBKernel.delimitL("Chargen");

Define a constant instead of duplicating this literal " VARCHAR(255) BEFORE " 10 times.
Open

"ALTER TABLE " + DBKernel.delimitL("Station") + " ADD COLUMN " + DBKernel.delimitL("District") + " VARCHAR(255) BEFORE " + DBKernel.delimitL("Bundesland"), false);

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

public static void check4Updates_176_177() {

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

if (!hideComment) fieldDefs += "," + DBKernel.delimitL("Kommentar");

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

String lastOutDir = DBKernel.prefs.get("LAST_OUTPUT_DIR", "");

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

if (bibitem.getField("journal") != null) psmt.setString(5, bibitem.getField("journal"));

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

sql = "SELECT " + DBKernel.delimitL("ID") + "," + DBKernel.delimitL("#Units1") + "," + DBKernel.delimitL("#Units2") + "," + DBKernel.delimitL("BezUnits2") + ","

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

if (bibitem.getField("title") != null) psmt.setString(3, bibitem.getField("title"));

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

"ALTER TABLE " + DBKernel.delimitL("Station") + " ADD COLUMN " + DBKernel.delimitL("Hausnummer") + " VARCHAR(10) BEFORE " + DBKernel.delimitL("Kontaktadresse"),

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

DBKernel.myDBi.getTable("Chargen").doMNs();

Define a constant instead of duplicating this literal "UPDATE " 18 times.
Open

String sql = "UPDATE " + DBKernel.delimitL("Chargen") + " SET " + DBKernel.delimitL("OriginCountry") + "=LEFT(" + DBKernel.delimitL("Kommentar") + ",CASEWHEN(INSTR("

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

DBKernel.sendRequest("DROP VIEW IF EXISTS " + DBKernel.delimitL("EstModelSecView") + ";", false);

Define a constant instead of duplicating this literal " VARCHAR(100) BEFORE " 3 times.
Open

"ALTER TABLE " + DBKernel.delimitL("Station") + " ADD COLUMN " + DBKernel.delimitL("Land") + " VARCHAR(100) BEFORE " + DBKernel.delimitL("Kontaktadresse"), false);

Define a constant instead of duplicating this literal " VARCHAR(30) BEFORE " 3 times.
Open

"ALTER TABLE " + DBKernel.delimitL("Station") + " ADD COLUMN " + DBKernel.delimitL("Bundesland") + " VARCHAR(30) BEFORE " + DBKernel.delimitL("Kontaktadresse"),

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

DBKernel.sendRequest("ALTER TABLE " + DBKernel.delimitL("Modellkatalog") + " ALTER COLUMN " + DBKernel.delimitL("Formel") + " VARCHAR(1023)", false);

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

"ALTER TABLE " + DBKernel.delimitL("Produktkatalog") + " ADD COLUMN " + DBKernel.delimitL("Serial") + " VARCHAR(16383) BEFORE " + DBKernel.delimitL("Kommentar"),
Severity
Category
Status
Source
Language