diff options
Diffstat (limited to 'dozentenmodulserver/src/main/java/sql')
| -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
|