From a5c3599d7bc7a9ef5583ad2d50a55975f030fbea Mon Sep 17 00:00:00 2001 From: Jonas Smedegaard Date: Tue, 29 Apr 2025 06:03:56 +0200 Subject: declare variables final when possible --- .../com/example/portfolio2/Database.java | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'src/com.example.portfolio2/com/example/portfolio2/Database.java') diff --git a/src/com.example.portfolio2/com/example/portfolio2/Database.java b/src/com.example.portfolio2/com/example/portfolio2/Database.java index 2712e3d..059bb3e 100644 --- a/src/com.example.portfolio2/com/example/portfolio2/Database.java +++ b/src/com.example.portfolio2/com/example/portfolio2/Database.java @@ -28,7 +28,7 @@ class Database { /// /// @param name activity name /// @return index of activity as integer - int getActivityIndeks(String name) { + int getActivityIndeks(final String name) { if(name ==null) return -1; ArrayList result = db.query("select indeks from activity a where name is '"+name+"';", "indeks"); return Integer.parseInt(result.getFirst()); @@ -38,7 +38,7 @@ class Database { /// insert activity into participation /// /// @param activityIndex index of activity - void addParticipation(int activityIndex) { + void addParticipation(final int activityIndex) { db.cmd("insert into participation values(123, "+activityIndex+");"); } @@ -46,7 +46,7 @@ class Database { /// /// @param program programme name /// @return names of participating activities - ArrayList getParticipation(String program) { + ArrayList getParticipation(final String program) { return db.query("select name from participation p inner join activity a on p.indeks = a.indeks where program is '" + program + "';", "name"); } @@ -59,7 +59,7 @@ class Database { /// /// @param program programme name /// @return names of contained activities - ArrayList selectProgram(String program) { + ArrayList selectProgram(final String program) { return db.query("select name from activity where program is '" + program + "';", "name"); } @@ -67,7 +67,7 @@ class Database { /// /// @param program programme name /// @return ECTS points as String - String getSumEcts(String program){ + String getSumEcts(final String program){ if(program==null)return "0"; ArrayList result = db.query("select sum(activity.ects) as total_ects,student.name from student left outer join participation on student.studid = participation.studid inner join activity on participation.indeks = activity.indeks where program is '"+program+"' group by student.studid ;", "total_ects"); if (result.isEmpty()) return "0"; -- cgit v1.2.3