aboutsummaryrefslogtreecommitdiff
path: root/src/com.example.portfolio2/com/example/portfolio2/Database.java
diff options
context:
space:
mode:
authorJonas Smedegaard <dr@jones.dk>2025-04-29 08:09:28 +0200
committerJonas Smedegaard <dr@jones.dk>2025-04-29 08:09:28 +0200
commit3738c1fc8b2fa92b819b1ff948b3b39de60757b7 (patch)
treec5db7a878770da6c8180cc468184712d585b0d88 /src/com.example.portfolio2/com/example/portfolio2/Database.java
parent794be4694f1a1fa36d87543aab840331c6d39745 (diff)
always use brace in for- and if-construct
Diffstat (limited to 'src/com.example.portfolio2/com/example/portfolio2/Database.java')
-rw-r--r--src/com.example.portfolio2/com/example/portfolio2/Database.java9
1 files changed, 6 insertions, 3 deletions
diff --git a/src/com.example.portfolio2/com/example/portfolio2/Database.java b/src/com.example.portfolio2/com/example/portfolio2/Database.java
index a4a9271..a6a144a 100644
--- a/src/com.example.portfolio2/com/example/portfolio2/Database.java
+++ b/src/com.example.portfolio2/com/example/portfolio2/Database.java
@@ -29,8 +29,9 @@ class Database {
/// @param name activity name
/// @return index of activity as integer
int getActivityIndeks(final String name) {
- if (name == null)
+ 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());
@@ -69,11 +70,13 @@ class Database {
/// @param program programme name
/// @return ECTS points as String
String getSumEcts(final String program) {
- if (program == null)
+ 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())
+ if (result.isEmpty()) {
return "0";
+ }
return result.getFirst();
}