diff options
author | Jonas Smedegaard <dr@jones.dk> | 2025-04-29 06:03:56 +0200 |
---|---|---|
committer | Jonas Smedegaard <dr@jones.dk> | 2025-04-29 06:11:41 +0200 |
commit | a5c3599d7bc7a9ef5583ad2d50a55975f030fbea (patch) | |
tree | db4ed74e48997d4b4450148116a9c990978a1641 /src/com.example.portfolio2/com/example/portfolio2/Database.java | |
parent | 03d2d06e8f5bfadd79912efb94e8931e54296735 (diff) |
declare variables final when possible
Diffstat (limited to 'src/com.example.portfolio2/com/example/portfolio2/Database.java')
-rw-r--r-- | src/com.example.portfolio2/com/example/portfolio2/Database.java | 10 |
1 files changed, 5 insertions, 5 deletions
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<String> 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<String> getParticipation(String program) { + ArrayList<String> 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<String> selectProgram(String program) { + ArrayList<String> 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<String> 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"; |