diff options
| author | Nino Breuer | 2014-11-17 19:37:42 +0100 |
|---|---|---|
| committer | Nino Breuer | 2014-11-17 19:37:42 +0100 |
| commit | 862f7f7fbea471e27375b3f8c6ccaca3b6ec8722 (patch) | |
| tree | 0c67da9fdb08b77ee5e8810c65b6cf0fd946aa6b /dozentenmodulserver/src/main/java/sql/SQL.java | |
| parent | • changed regular statements to prepared statements to prevent sql injections (diff) | |
| download | tutor-module-862f7f7fbea471e27375b3f8c6ccaca3b6ec8722.tar.gz tutor-module-862f7f7fbea471e27375b3f8c6ccaca3b6ec8722.tar.xz tutor-module-862f7f7fbea471e27375b3f8c6ccaca3b6ec8722.zip | |
• fixed bug where the os name was not set to the correct value while editing an image
Diffstat (limited to 'dozentenmodulserver/src/main/java/sql/SQL.java')
| -rw-r--r-- | dozentenmodulserver/src/main/java/sql/SQL.java | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java index cb5b84a1..2551df4c 100644 --- a/dozentenmodulserver/src/main/java/sql/SQL.java +++ b/dozentenmodulserver/src/main/java/sql/SQL.java @@ -2528,6 +2528,35 @@ public class SQL { }
+
+
+
+
+ public String getOsNameForGuestOs(String guestOS) {
+
+ Connection con = getConnection();
+ ResultSet rs = null;
+ String sql = "Select name, architecture from bwLehrpool.m_operatingSystem where guestOS = ?";
+
+ try
+ {
+
+ PreparedStatement prest = con.prepareStatement(sql);
+ prest.setString(1, guestOS);
+ rs = prest.executeQuery();
+ con.commit();
+ rs.next();
+
+ return rs.getString("name") + " " + rs.getString("architecture") + " bit";
+
+ } catch (SQLException e) {
+ // TODO Auto-generated catch block
+ e.printStackTrace();
+ }
+
+ return null;
+
+ }
}// end class
|