From 83faaa19a0ea1d8622a3e27a250fb6f0a5c5bc5a Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 15 Apr 2014 13:33:31 +0200 Subject: b --- Dozentenmodulserver/src/sql/SQL.java | 15 ++++++--------- 1 file changed, 6 insertions(+), 9 deletions(-) (limited to 'Dozentenmodulserver/src/sql') diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java index a68e20a2..f03e2c84 100644 --- a/Dozentenmodulserver/src/sql/SQL.java +++ b/Dozentenmodulserver/src/sql/SQL.java @@ -507,22 +507,19 @@ public class SQL { } - public boolean connectedToEvents(Connection con, String id, String version) { + public boolean connectedToLecture(Connection con, String id, String version) { try { Statement stm = con.createStatement(); ResultSet rs = stm - .executeQuery("SELECT ...VERANSTALTUNG_VERKNÜPFUNG... FROM " - + "bwLehrpool.m_VLData_imageInfo where GUID_imageID = '" - + id - + "' " - + "AND imageVersion = '" - + version - + "';"); + .executeQuery("SELECT lectureID FROM " + + "bwLehrpool.m_VLDatalecture where imageID = '" + + id + "' " + "AND imageVersion = '" + + version + "';"); - return !rs.wasNull(); + return rs.first(); } catch (SQLException e) { // TODO Auto-generated catch block -- cgit v1.2.3-55-g7522