--- android/TrainInfoService/src/dk/thoerup/traininfoservice/StationDAO.java	2010/04/19 12:49:31	649
+++ android/TrainInfoService/src/dk/thoerup/traininfoservice/StationDAO.java	2010/04/19 19:04:34	650
@@ -155,5 +155,26 @@
 			return result;
 			
 	 }
-	 
+	 public static String getStationName(int stationID) {
+		 String station = "";
+
+		 Connection conn = null;
+		 try {
+			 conn = DBConnection.getConnection();
+			 Statement stmt = conn.createStatement();
+			 ResultSet rs = stmt.executeQuery("SELECT name FROM trainstations WHERE id=" + stationID);
+			 if (rs.next()) {
+				 station = rs.getString(1);
+			 }
+
+		 } catch (Exception e) {	
+		 } finally {
+			 try {
+				 if (conn != null && !conn.isClosed())
+					 conn.close();
+			 } catch (Exception e) {}
+		 }
+
+		 return station;
+	 }
 }