SiLeBAT/FSK-Lab

View on GitHub

Showing 14,752 of 14,752 total issues

Use indentation to denote the code conditionally executed by this "if".
Open

if (transformFormat)

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

HSSFSheet transactionSheet = wb.getSheet("Transactions");

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

sql = "SELECT " + DBKernel.delimitL("ID") + "," + DBKernel.delimitL("Lieferdatum") + " FROM " + DBKernel.delimitL("Lieferungen");

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

"ALTER TABLE " + DBKernel.delimitL("Chargen") + " ADD COLUMN " + DBKernel.delimitL("Serial") + " VARCHAR(16383) BEFORE " + DBKernel.delimitL("Kommentar"), false);

Define a constant instead of duplicating this literal "Einheit" 14 times.
Open

+ DBKernel.delimitL("Einheit"), false);

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

stmt.execute("CREATE TRIGGER " + DBKernel.delimitL("A_" + tableName + "_U") + " AFTER UPDATE ON " + DBKernel.delimitL(tableName) + " FOR EACH ROW " + " CALL "

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

private void getDblVal(MyDBTable myDBTable, int row, int col, HSSFRow row0, HSSFRow rowi) {

Don't try to be smarter than the JVM, remove this call to run the garbage collector.
Open

System.gc();

Don't try to be smarter than the JVM, remove this call to run the garbage collector.
Open

System.gc();

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

sql = "UPDATE " + DBKernel.delimitL(tableName) + " SET " + sql3.substring(0, sql3.length() - 1) + " WHERE " + DBKernel.delimitL("ID") + "=?";

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

if (bibitem.getField("fulltext") != null || bibitem.getField("pdf") != null) {

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

String sql = "INSERT INTO " + DBKernel.delimitL("Literatur") +

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

Object year1 = DBKernel.getValue("Lieferungen", "ID", deliveryId1 + "", "dd_year");

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

"ALTER TABLE " + DBKernel.delimitL("Station") + " ADD COLUMN " + DBKernel.delimitL("Serial") + " VARCHAR(16383) BEFORE " + DBKernel.delimitL("Kommentar"), false);

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

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

Rename method "getInsertSql2" to prevent any misunderstanding/clash with method "getInsertSQL2" defined on line 443.
Open

private String getInsertSql2() {

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

else if (fieldTypes[j].equals("INTEGER")) manageInteger(ps, psUpdate, lfdCol, row.getCell(j));

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

sql = "UPDATE " + DBKernel.delimitL(tableName) + " SET " + sql3.substring(0, sql3.length() - 1) + " WHERE " + DBKernel.delimitL("ID") + "=?";

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

" WHERE \"Messwerte\".\"Versuchsbedingungen\" = " + rs.getString("Versuchsbedingung");

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

public static void check4Updates_183_184() {
Severity
Category
Status
Source
Language