1 |
package dk.thoerup.traininfoservice; |
package dk.thoerup.traininfoservice.db; |
2 |
|
|
3 |
import java.io.IOException; |
import java.io.IOException; |
4 |
import java.sql.SQLException; |
import java.sql.SQLException; |
5 |
import java.util.Random; |
import java.util.Random; |
6 |
|
|
7 |
import javax.servlet.ServletException; |
import javax.servlet.ServletException; |
8 |
|
import javax.servlet.annotation.WebServlet; |
9 |
import javax.servlet.http.HttpServlet; |
import javax.servlet.http.HttpServlet; |
10 |
import javax.servlet.http.HttpServletRequest; |
import javax.servlet.http.HttpServletRequest; |
11 |
import javax.servlet.http.HttpServletResponse; |
import javax.servlet.http.HttpServletResponse; |
12 |
|
|
13 |
|
|
14 |
|
@WebServlet(urlPatterns={"/TestServlet"}) |
15 |
public class TestServlet extends HttpServlet { |
public class TestServlet extends HttpServlet { |
16 |
private static final long serialVersionUID = 1L; |
private static final long serialVersionUID = 1L; |
17 |
|
|
18 |
|
Random r = new Random(); |
19 |
|
|
20 |
//South-West corner= 54.0, 7.0 |
//South-West corner= 54.5, 8.0 |
21 |
//North-East corner= 58.0, 13.0 |
//North-East corner= 57.8, 12.7 |
22 |
//Latitude span=4.0 |
//Latitude span=3.3 |
23 |
//Longitude span=6.0 |
//Longitude span=4.7 |
24 |
void testFindNearest(int count) throws SQLException { |
void testFindNearest(int count) throws SQLException { |
|
Random r = new Random(); |
|
25 |
|
|
26 |
StationDAO db = new StationDAO(); |
StationDAO db = new StationDAO(); |
27 |
|
|
28 |
|
|
29 |
for (int i=0; i<count; i++) { |
for (int i=0; i<count; i++) { |
30 |
float lat = (r.nextFloat()*4.0F) + 54.0F; |
float lat = (r.nextFloat()*3.3F) + 54.5F; |
31 |
float lng = (r.nextFloat()*6.0F) + 7.0F; |
float lng = (r.nextFloat()*4.7F) + 8.0F; |
32 |
db.getByLocation(lat, lng); |
db.getByLocation(lat, lng); |
33 |
} |
} |
34 |
|
|
37 |
} |
} |
38 |
|
|
39 |
void testFindName(int count) throws SQLException { |
void testFindName(int count) throws SQLException { |
|
Random r = new Random(); |
|
40 |
|
|
41 |
StationDAO db = new StationDAO(); |
StationDAO db = new StationDAO(); |
42 |
|
|
54 |
} |
} |
55 |
|
|
56 |
void testFindFavorites(int count) throws SQLException { |
void testFindFavorites(int count) throws SQLException { |
|
Random r = new Random(); |
|
57 |
|
|
58 |
StationDAO db = new StationDAO(); |
StationDAO db = new StationDAO(); |
59 |
|
|