traininfoservice/db/TestServlet.java

package dk.thoerup.traininfoservice.db;

import java.io.IOException;
import java.sql.SQLException;
import java.util.Random;
import java.util.logging.Logger;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


@WebServlet(urlPatterns={"/TestServlet"})
public class TestServlet extends HttpServlet {
        private static final long serialVersionUID = 1L;
        Logger log = Logger.getLogger(TestServlet.class.getName());
        
        Random r = new Random();

        //South-West corner= 54.5, 8.0
        //North-East corner= 57.8, 12.7
        //Latitude span=3.3
        //Longitude span=4.7
        void testFindNearest(int count) throws SQLException {           

                StationDAO db = new StationDAO();


                for (int i=0; i<count; i++) {
                        float lat = (r.nextFloat()*3.3F) + 54.5F;
                        float lng = (r.nextFloat()*4.7F) + 8.0F;
                        db.getByLocation(lat, lng);
                }
        }

        void testFindName(int count)  throws SQLException {
                
                StationDAO db = new StationDAO();
                
                for (int i=0; i<count; i++) {
                        char c1 = getRandomCharacter();
                        char c2 = getRandomCharacter();

                        String search = "" + c1 + c2;
                        log.info(search);
                        
                        db.getByName(search);
                }
        }

        private char getRandomCharacter() {
                char c1 = ((char)r.nextInt(26));
                c1 += 'a';
                return c1;
        }
        
        void testFindFavorites(int count)  throws SQLException {
                
                StationDAO db = new StationDAO();
                
                for (int i=0; i<count; i++) {
                        final int MAX = 8;
                        
                        StringBuilder sb = new StringBuilder();
                        sb.append('(');
                        for (int j=0; j<MAX;j++) {
                                if (j>0)
                                        sb.append(',');
                                sb.append(r.nextInt(400));
                        }
                        sb.append(')');


                        db.getByList(sb.toString());
                }
        }

        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
                
                
                String test = request.getParameter("test");
                String strCount = request.getParameter("count");
                int count = Integer.parseInt(strCount);
                
        
                try {                   
                        long start = System.currentTimeMillis();
                        
                        if ( test.equals("name") ) {
                                testFindName(count);
                        } else if ( test.equals("nearest") ) {
                                testFindNearest(count);
                        } else if ( test.equals("favorites") ) {
                                testFindFavorites(count);
                        } else {
                                throw new ServletException("No parameter test");
                        }
                        
                        long stop = System.currentTimeMillis();

                        long elapsed = stop-start;

                        float avg = ((float)elapsed) / count;

                        String out = "Count=" + count + "\n" +                                   
                        "Elapsed=" + elapsed + "\n" +
                        "Avg.=" +  avg;

                        response.getWriter().print( out );


                } catch (Exception e) {
                        throw new ServletException(e);
                }
        }

}
1	package dk.thoerup.traininfoservice.db;
2
3	import java.io.IOException;
4	import java.sql.SQLException;
5	import java.util.Random;
6	import java.util.logging.Logger;
7
8	import javax.servlet.ServletException;
9	import javax.servlet.annotation.WebServlet;
10	import javax.servlet.http.HttpServlet;
11	import javax.servlet.http.HttpServletRequest;
12	import javax.servlet.http.HttpServletResponse;
13
14
15	@WebServlet(urlPatterns={"/TestServlet"})
16	public class TestServlet extends HttpServlet {
17	private static final long serialVersionUID = 1L;
18	Logger log = Logger.getLogger(TestServlet.class.getName());
19
20	Random r = new Random();
21
22	//South-West corner= 54.5, 8.0
23	//North-East corner= 57.8, 12.7
24	//Latitude span=3.3
25	//Longitude span=4.7
26	void testFindNearest(int count) throws SQLException {
27
28	StationDAO db = new StationDAO();
29
30
31	for (int i=0; i<count; i++) {
32	float lat = (r.nextFloat()*3.3F) + 54.5F;
33	float lng = (r.nextFloat()*4.7F) + 8.0F;
34	db.getByLocation(lat, lng);
35	}
36	}
37
38	void testFindName(int count) throws SQLException {
39
40	StationDAO db = new StationDAO();
41
42	for (int i=0; i<count; i++) {
43	char c1 = getRandomCharacter();
44	char c2 = getRandomCharacter();
45
46	String search = "" + c1 + c2;
47	log.info(search);
48
49	db.getByName(search);
50	}
51	}
52
53	private char getRandomCharacter() {
54	char c1 = ((char)r.nextInt(26));
55	c1 += 'a';
56	return c1;
57	}
58
59	void testFindFavorites(int count) throws SQLException {
60
61	StationDAO db = new StationDAO();
62
63	for (int i=0; i<count; i++) {
64	final int MAX = 8;
65
66	StringBuilder sb = new StringBuilder();
67	sb.append('(');
68	for (int j=0; j<MAX;j++) {
69	if (j>0)
70	sb.append(',');
71	sb.append(r.nextInt(400));
72	}
73	sb.append(')');
74
75
76	db.getByList(sb.toString());
77	}
78	}
79
80	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
81
82
83	String test = request.getParameter("test");
84	String strCount = request.getParameter("count");
85	int count = Integer.parseInt(strCount);
86
87
88	try {
89	long start = System.currentTimeMillis();
90
91	if ( test.equals("name") ) {
92	testFindName(count);
93	} else if ( test.equals("nearest") ) {
94	testFindNearest(count);
95	} else if ( test.equals("favorites") ) {
96	testFindFavorites(count);
97	} else {
98	throw new ServletException("No parameter test");
99	}
100
101	long stop = System.currentTimeMillis();
102
103	long elapsed = stop-start;
104
105	float avg = ((float)elapsed) / count;
106
107	String out = "Count=" + count + "\n" +
108	"Elapsed=" + elapsed + "\n" +
109	"Avg.=" + avg;
110
111	response.getWriter().print( out );
112
113
114	} catch (Exception e) {
115	throw new ServletException(e);
116	}
117	}
118
119	}