--- android/TrainInfoService/src/dk/thoerup/traininfoservice/StationDAO.java	2010/09/20 20:20:59	1081
+++ android/TrainInfoService/src/dk/thoerup/traininfoservice/StationDAO.java	2010/09/21 05:55:31	1082
@@ -1,5 +1,6 @@
 package dk.thoerup.traininfoservice;
 
+import java.sql.Array;
 import java.sql.Connection;
 import java.sql.PreparedStatement;
 import java.sql.ResultSet;
@@ -72,6 +73,50 @@
 
 		return result;
 	}
+	
+	public StationBean dumpAll() throws SQLException {
+		
+		String SQL = "SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog,stationcode_metro,address,0.0,aliases " +
+				"FROM trainstations WHERE enabled = true ORDER BY id";
+		
+		Connection conn = null;
+		Statement stmt = null;
+		ResultSet res = null;		
+
+		
+		try {
+			conn = DBConnection.getConnection();
+
+			stmt = conn.createStatement();
+			res = stmt.executeQuery(SQL);		
+						
+			// Does mostly the same as convertResultset()
+			StationBean stations = new StationBean();
+			while (res.next()) {
+				StationEntry entry = convertSingleRow(res);
+				
+				Array arr = res.getArray(10);
+				if (arr != null) {
+					String[] aliases = (String[]) arr.getArray();
+					entry.setAliases(aliases);
+				}
+				
+				stations.entries.add( entry );
+				
+			}
+			return stations;
+			
+
+		} finally {
+			if (res != null)
+				res.close();
+			if (stmt != null)
+				stmt.close();
+			if (conn != null)
+				conn.close();
+		}
+		
+	}
 
 	/*
 	 * this code requires theses statements are run on database in order to do ILIKE searches against aliases (which is defines as array of varchar(64) )