39 |
|
|
40 |
|
|
41 |
try ( Connection conn = DBConnection.getConnection(); |
try ( Connection conn = DBConnection.getConnection(); |
42 |
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); |
Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); |
43 |
) { |
) { |
44 |
stmt.setFetchSize(Integer.MIN_VALUE); |
stmt.setFetchSize(Integer.MIN_VALUE); |
45 |
ResultSet res = stmt.executeQuery(sql); |
ResultSet res = stmt.executeQuery(sql); |
68 |
a.latitude = (float) res.getDouble(11); |
a.latitude = (float) res.getDouble(11); |
69 |
a.longitude = (float) res.getDouble(12); |
a.longitude = (float) res.getDouble(12); |
70 |
|
|
71 |
a.ruteMandag = dirigeringsCache.getInstance( res.getString(13) ); |
a.routingMandag.rute = dirigeringsCache.getInstance( res.getString(13) ); |
72 |
a.korelisteMandag = dirigeringsCache.getInstance( res.getString(14) ); |
a.routingMandag.koreliste = dirigeringsCache.getInstance( res.getString(14) ); |
73 |
|
|
74 |
a.ruteTirsdag = dirigeringsCache.getInstance( res.getString(15) ); |
a.routingTirsdag.rute = dirigeringsCache.getInstance( res.getString(15) ); |
75 |
a.korelisteTirsdag = dirigeringsCache.getInstance( res.getString(16) ); |
a.routingTirsdag.koreliste = dirigeringsCache.getInstance( res.getString(16) ); |
76 |
|
|
77 |
a.ruteOnsdag = dirigeringsCache.getInstance( res.getString(17) ); |
a.routingOnsdag.rute = dirigeringsCache.getInstance( res.getString(17) ); |
78 |
a.korelisteOnsdag = dirigeringsCache.getInstance( res.getString(18) ); |
a.routingOnsdag.koreliste = dirigeringsCache.getInstance( res.getString(18) ); |
79 |
|
|
80 |
a.ruteTorsdag = dirigeringsCache.getInstance( res.getString(19) ); |
a.routingTorsdag.rute = dirigeringsCache.getInstance( res.getString(19) ); |
81 |
a.korelisteTorsdag = dirigeringsCache.getInstance( res.getString(20) ); |
a.routingTorsdag.koreliste = dirigeringsCache.getInstance( res.getString(20) ); |
82 |
|
|
83 |
a.ruteFredag = dirigeringsCache.getInstance( res.getString(21) ); |
a.routingFredag.rute = dirigeringsCache.getInstance( res.getString(21) ); |
84 |
a.korelisteFredag = dirigeringsCache.getInstance( res.getString(22) ); |
a.routingFredag.koreliste = dirigeringsCache.getInstance( res.getString(22) ); |
85 |
|
|
86 |
a.ruteLordag = dirigeringsCache.getInstance( res.getString(23) ); |
a.routingLordag.rute = dirigeringsCache.getInstance( res.getString(23) ); |
87 |
a.korelisteLordag = dirigeringsCache.getInstance( res.getString(24) ); |
a.routingLordag.koreliste = dirigeringsCache.getInstance( res.getString(24) ); |
88 |
|
|
89 |
a.ruteSondag = dirigeringsCache.getInstance( res.getString(25) ); |
a.routingSondag.rute = dirigeringsCache.getInstance( res.getString(25) ); |
90 |
a.korelisteSondag = dirigeringsCache.getInstance( res.getString(16) ); |
a.routingSondag.koreliste = dirigeringsCache.getInstance( res.getString(26) ); |
91 |
|
|
92 |
|
|
93 |
//Ajourfør adresse objectets dækningstype |
//Ajourfør adresse objectets dækningstype |
114 |
; |
; |
115 |
|
|
116 |
try ( Connection conn = DBConnection.getConnection(); |
try ( Connection conn = DBConnection.getConnection(); |
117 |
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); |
Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); |
118 |
) { |
) { |
119 |
|
|
120 |
stmt.setFetchSize(Integer.MIN_VALUE); |
stmt.setFetchSize(Integer.MIN_VALUE); |
166 |
; |
; |
167 |
|
|
168 |
try ( Connection conn = DBConnection.getConnection(); |
try ( Connection conn = DBConnection.getConnection(); |
169 |
Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); |
Statement stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY); |
170 |
) { |
) { |
171 |
|
|
172 |
|
|