Debugging: Jeder Fehler poppt auf in einem Textfenster und kann analysiert werden

1 files changed, 24 insertions, 13 deletions

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;

+	}

 }