22 |
|
|
23 |
public class DatabaseLayer { |
public class DatabaseLayer { |
24 |
|
|
25 |
static boolean DEBUG = true; |
static boolean DEBUG = false; |
26 |
|
|
27 |
public static List<Address> getAllAdresses() throws SQLException { |
public static List<Address> getAllAdresses() throws SQLException { |
28 |
String debugFilter = DatabaseLayer.DEBUG ? " AND postnr = 8700 " : ""; |
String debugFilter = DatabaseLayer.DEBUG ? " AND postnr = 8700 " : ""; |
108 |
while (res.next()) { |
while (res.next()) { |
109 |
|
|
110 |
AliasBean ab = new AliasBean(); |
AliasBean ab = new AliasBean(); |
111 |
ab.postnr = res.getInt(1); |
ab.postnr = res.getShort(1); |
112 |
ab.vejnavn = vejCache.getInstance( res.getString(2) ); |
ab.vejnavn = vejCache.getInstance( res.getString(2) ); |
113 |
ab.aliasVejnavn = vejCache.getInstance( res.getString(3) ); |
ab.aliasVejnavn = vejCache.getInstance( res.getString(3) ); |
114 |
|
|