diff options
| author | unknown | 2014-04-10 09:39:26 +0200 |
|---|---|---|
| committer | unknown | 2014-04-10 09:39:26 +0200 |
| commit | 037e904354b540c9d242f64f46df94842d5d41d2 (patch) | |
| tree | bf4a967e49ecfaf040f9aaac2a1242b3033b65a3 /Dozentenmodulserver/src/sql | |
| parent | Diverse Bugfixes und neue Grafik (diff) | |
| download | tutor-module-037e904354b540c9d242f64f46df94842d5d41d2.tar.gz tutor-module-037e904354b540c9d242f64f46df94842d5d41d2.tar.xz tutor-module-037e904354b540c9d242f64f46df94842d5d41d2.zip | |
test
Diffstat (limited to 'Dozentenmodulserver/src/sql')
| -rw-r--r-- | Dozentenmodulserver/src/sql/SQL.java | 32 |
1 files changed, 32 insertions, 0 deletions
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;
+ }
+
}
|