From 862f7f7fbea471e27375b3f8c6ccaca3b6ec8722 Mon Sep 17 00:00:00 2001
From: Nino Breuer
Date: Mon, 17 Nov 2014 19:37:42 +0100
Subject: • fixed bug where the os name was not set to the correct value while
 editing an image

---
 dozentenmodulserver/src/main/java/sql/SQL.java | 29 ++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)

(limited to 'dozentenmodulserver/src/main/java/sql/SQL.java')

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
-- 
cgit v1.2.3-55-g7522