diff options
| author | Simon Rettberg | 2015-07-20 12:20:16 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2015-07-20 12:20:16 +0200 |
| commit | 61a268d086d2e3fc7e5902cb6083ca5360dd870f (patch) | |
| tree | 19cd048b1bfdc32729aded64062bb9fecc852905 /dozentenmodulserver/src/main/java | |
| parent | [client] *Listener -> *Adapter (where applicable) (diff) | |
| download | tutor-module-61a268d086d2e3fc7e5902cb6083ca5360dd870f.tar.gz tutor-module-61a268d086d2e3fc7e5902cb6083ca5360dd870f.tar.xz tutor-module-61a268d086d2e3fc7e5902cb6083ca5360dd870f.zip | |
[server] Simplified db schema a bit
Diffstat (limited to 'dozentenmodulserver/src/main/java')
| -rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbSoftwareTag.java | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbSoftwareTag.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbSoftwareTag.java index 6cabd021..44e50090 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbSoftwareTag.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbSoftwareTag.java @@ -54,8 +54,7 @@ public class DbSoftwareTag { } public static List<String> getImageTags(MysqlConnection connection, String imageBaseId) throws SQLException { - MysqlStatement stmt = connection.prepareStatement("SELECT displayname FROM tag" - + " INNER JOIN imagebase_x_tag USING (tagid)" + MysqlStatement stmt = connection.prepareStatement("SELECT tagname FROM imagetag" + " WHERE imagebaseid = :imagebaseid"); stmt.setString("imagebaseid", imageBaseId); ResultSet rs = stmt.executeQuery(); |