diff options
Diffstat (limited to 'dozentenmodulserver/src/main/java/sql/SQL.java')
| -rw-r--r-- | dozentenmodulserver/src/main/java/sql/SQL.java | 26 |
1 files changed, 5 insertions, 21 deletions
diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java index 2551df4c..10afee96 100644 --- a/dozentenmodulserver/src/main/java/sql/SQL.java +++ b/dozentenmodulserver/src/main/java/sql/SQL.java @@ -1713,33 +1713,17 @@ public class SQL { try {
Connection con = getConnection();
Statement stm = con.createStatement();
- String image_path = "prod/" + name;
- /*
- log.info(new Date()
- + " - Updating ImagePath with: UPDATE `bwLehrpool`.`m_VLData_imageInfo` SET `image_path` = '"
- + image_path + "' WHERE `image_path` = '" + "temp/" + name
- + "';");
- */
- /*
- stm.executeUpdate("UPDATE `bwLehrpool`.`m_VLData_imageInfo` SET `image_path` = '"
- + image_path
- + "' WHERE `image_path` = '"
- + "temp/"
- + name
- + "';");
- */
String sql = "UPDATE bwLehrpool.m_VLData_imageInfo SET image_path = "
- + "?"
- + " WHERE image_path = '"
- + "temp/"
- + "'?"
+ + "?" //prod/+name
+ + " WHERE image_path = "
+ + "?" //temp/+name
+ ";";
PreparedStatement prest = con.prepareStatement(sql);
- prest.setString(1, image_path);
- prest.setString(2, name);
+ prest.setString(1, "prod/"+name);
+ prest.setString(2, "temp/"+name);
prest.executeUpdate();
|