diff options
Diffstat (limited to 'Dozentenmodulserver/src/sql/SQL.java')
| -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;
+ }
+
}
|