From a3c0327dbd49efc29ede542f7093638941a7ae13 Mon Sep 17 00:00:00 2001
From: unknown
Date: Wed, 16 Apr 2014 10:48:10 +0200
Subject: Debugging: Jeder Fehler poppt auf in einem Textfenster und kann
 analysiert werden

---
 Dozentenmodulserver/src/sql/SQL.java | 37 +++++++++++++++++++++++-------------
 1 file changed, 24 insertions(+), 13 deletions(-)

(limited to 'Dozentenmodulserver/src/sql')

diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java
index 485d51fd..5c5b0ec6 100644
--- a/Dozentenmodulserver/src/sql/SQL.java
+++ b/Dozentenmodulserver/src/sql/SQL.java
@@ -3,15 +3,11 @@ package sql;
 import java.sql.*;
 
 import java.text.DateFormat;
-import java.text.ParseException;
 import java.text.SimpleDateFormat;
 import java.util.Date;
 import java.util.Random;
-
 import org.apache.log4j.Logger;
-
 import server.BinaryListener;
-import server.ServerHandler;
 
 public class SQL {
 
@@ -444,14 +440,14 @@ public class SQL {
 	public boolean deleteImage(Connection con, String id, String version) {
 
 		try {
-			
-			Statement stm = con.createStatement();
+
+			Statement stm = con.createStatement();
 
 			stm.executeUpdate("DELETE FROM bwLehrpool.m_VLData_imageInfo where GUID_imageID = '"
 					+ id + "' " + "AND imageVersion = '" + version + "';");
-			
+
 			con.commit();
-			
+
 			return true;
 
 		} catch (SQLException e) {
@@ -509,11 +505,9 @@ public class SQL {
 
 			Statement stm = con.createStatement();
 
-			ResultSet rs = stm
-					.executeQuery("SELECT lectureID FROM "
-							+ "bwLehrpool.m_VLData_lecture WHERE imageID = '"
-							+ id + "' AND imageVersion = '"
-							+ version + "';");
+			ResultSet rs = stm.executeQuery("SELECT lectureID FROM "
+					+ "bwLehrpool.m_VLData_lecture WHERE imageID = '" + id
+					+ "' AND imageVersion = '" + version + "';");
 
 			return rs.first();
 
@@ -525,4 +519,21 @@ public class SQL {
 		return false;
 
 	}
+
+	public boolean deleteLecture(Connection con, String id) {
+		
+		try {
+			Statement stm = con.createStatement();
+			stm.executeUpdate("DELETE FROM bwLehrpool.m_VLData_lecture WHERE lectureID = '"+ id + "';");
+
+			con.commit();
+
+			return true;
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		
+		return false;
+	}
 }
-- 
cgit v1.2.3-55-g7522