diff options
Diffstat (limited to 'dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbRunScript.java')
-rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbRunScript.java | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbRunScript.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbRunScript.java index 2037879d..20df4299 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbRunScript.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbRunScript.java @@ -86,6 +86,19 @@ public class DbRunScript { } return list; } + + public static List<Integer> getForEdit(MysqlConnection connection, String lectureId) throws SQLException + { + MysqlStatement stmt = connection.prepareStatement("SELECT runscriptid FROM lecture_x_runscript" + + " WHERE lectureid = :lectureid"); + stmt.setString("lectureid", lectureId); + ResultSet rs = stmt.executeQuery(); + List<Integer> result = new ArrayList<>(); + while (rs.next()) { + result.add(rs.getInt("runscriptid")); + } + return result; + } private static List<Integer> splitStringToInt(String input) { if (input == null) |