aboutsummaryrefslogtreecommitdiff
path: root/src/com.example.portfolio2/com/example/portfolio2/Database.java
diff options
context:
space:
mode:
Diffstat (limited to 'src/com.example.portfolio2/com/example/portfolio2/Database.java')
-rw-r--r--src/com.example.portfolio2/com/example/portfolio2/Database.java10
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";