From 037e904354b540c9d242f64f46df94842d5d41d2 Mon Sep 17 00:00:00 2001
From: unknown
Date: Thu, 10 Apr 2014 09:39:26 +0200
Subject: test

---
 Dozentenmodulserver/src/sql/SQL.java | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)

(limited to 'Dozentenmodulserver/src/sql')

diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java
index f28fdd67..ca3f0f8e 100644
--- a/Dozentenmodulserver/src/sql/SQL.java
+++ b/Dozentenmodulserver/src/sql/SQL.java
@@ -326,4 +326,36 @@ public class SQL {
 		}
 		return -1;
 	}
+	
+
+	/**
+	 * 
+	 * @param id
+	 * @param version
+	 * @return
+	 */
+	
+	 public boolean deleteImage(String id, String version) {
+
+		try {
+			
+			Connection con=DriverManager.getConnection
+					("jdbc:mysql://127.0.0.1/bwLehrpool?user=root&password=slx-ng-open");
+			Statement stm=con.createStatement();
+			
+			System.out.println("delete image");
+			
+			stm.executeUpdate("DELETE * FROM bwLehrpool.m_VLData_imageInfo where GUID_imageID = '"+id+"' " +
+					"and imageVersion = '"+version+"' ;");
+			
+			return true;
+			
+		} catch (SQLException e) {
+			// TODO Auto-generated catch block
+			e.printStackTrace();
+		}
+		
+		return false;
+	}
+
 }
-- 
cgit v1.2.3-55-g7522