--- dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java	2015/02/27 08:24:56	2394
+++ dao/DaoAdresseService/src/dk/daoas/daoadresseservice/db/DatabaseLayer.java	2015/02/27 09:39:05	2395
@@ -13,6 +13,7 @@
 
 import dk.daoas.daoadresseservice.DaekningsType;
 import dk.daoas.daoadresseservice.beans.Address;
+import dk.daoas.daoadresseservice.beans.AliasBean;
 import dk.daoas.daoadresseservice.beans.ExtendedBean;
 import dk.daoas.daoadresseservice.beans.HundredePctBean;
 import dk.daoas.daoadresseservice.beans.LoggedAddress;
@@ -83,6 +84,43 @@
 		}
 	}
 	
+	public static List<AliasBean> getAliasList() throws SQLException {
+		
+
+		String sql = "SELECT postnr,vejnavn,aliasvejnavn " +
+					"FROM bogleveringer.vejtabelprod " 
+					;
+		
+		try ( Connection conn = DBConnection.getConnection();		
+				Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);
+				) {
+					
+			stmt.setFetchSize(Integer.MIN_VALUE);
+			
+			ResultSet res = stmt.executeQuery(sql);
+			
+			DeduplicateHelper<String> vejCache = new DeduplicateHelper<String>();
+			
+			List<AliasBean> list = new ArrayList<AliasBean>( 5000); 
+			while (res.next()) {		
+				
+				AliasBean ab = new AliasBean();
+				ab.postnr = res.getInt(1);
+				ab.vejnavn = vejCache.getInstance( res.getString(2) );
+				ab.aliasVejnavn = vejCache.getInstance( res.getString(3) );
+							
+				list.add(ab);
+			}
+		
+			res.close();
+			
+			System.out.println("Loaded " + list.size() + " aliase beans");
+			
+			return list;
+		}
+
+	}
+	
 	public static List<ExtendedBean> getExtendedAdresslist() throws SQLException {
 		String debugFilter1 = DatabaseLayer.DEBUG ? " WHERE orgPostnr = 8700 " : "";
 		String debugFilter2 = DatabaseLayer.DEBUG ? " AND orgPostnr = 8700 " : "";