1 |
package dk.thoerup.traininfoservice.banedk; |
package dk.thoerup.traininfoservice.banedk; |
2 |
|
|
3 |
|
import java.io.ByteArrayOutputStream; |
4 |
import java.io.IOException; |
import java.io.IOException; |
|
import java.sql.Connection; |
|
|
import java.sql.ResultSet; |
|
|
import java.sql.Statement; |
|
|
import java.util.List; |
|
5 |
import java.util.logging.Level; |
import java.util.logging.Level; |
6 |
import java.util.logging.Logger; |
import java.util.logging.Logger; |
7 |
|
|
8 |
import javax.servlet.ServletException; |
import javax.servlet.ServletException; |
9 |
|
import javax.servlet.annotation.WebServlet; |
10 |
import javax.servlet.http.HttpServlet; |
import javax.servlet.http.HttpServlet; |
11 |
import javax.servlet.http.HttpServletRequest; |
import javax.servlet.http.HttpServletRequest; |
12 |
import javax.servlet.http.HttpServletResponse; |
import javax.servlet.http.HttpServletResponse; |
|
import javax.xml.parsers.DocumentBuilder; |
|
13 |
import javax.xml.parsers.DocumentBuilderFactory; |
import javax.xml.parsers.DocumentBuilderFactory; |
|
import javax.xml.transform.OutputKeys; |
|
|
import javax.xml.transform.Transformer; |
|
14 |
import javax.xml.transform.TransformerFactory; |
import javax.xml.transform.TransformerFactory; |
|
import javax.xml.transform.dom.DOMSource; |
|
|
import javax.xml.transform.stream.StreamResult; |
|
15 |
|
|
16 |
import org.w3c.dom.DOMImplementation; |
import org.simpleframework.xml.Serializer; |
17 |
import org.w3c.dom.Document; |
import org.simpleframework.xml.core.Persister; |
|
import org.w3c.dom.Element; |
|
18 |
|
|
19 |
import dk.thoerup.curcuitbreaker.CircuitBreakerException; |
import dk.thoerup.android.traininfo.common.DepartureBean; |
20 |
import dk.thoerup.traininfoservice.DBConnection; |
import dk.thoerup.circuitbreaker.CircuitBreakerException; |
21 |
|
import dk.thoerup.traininfoservice.Statistics; |
22 |
|
|
23 |
/** |
/** |
24 |
* Servlet implementation class DepartureServlet |
* Servlet implementation class DepartureServlet |
25 |
*/ |
*/ |
26 |
|
@WebServlet(urlPatterns={"/DepartureServlet"}) |
27 |
public class DepartureServlet extends HttpServlet { |
public class DepartureServlet extends HttpServlet { |
28 |
private static final long serialVersionUID = 1L; |
private static final long serialVersionUID = 1L; |
29 |
|
|
30 |
Logger logger = Logger.getLogger( DepartureServlet.class.getName() ); |
Logger logger = Logger.getLogger( DepartureServlet.class.getName() ); |
31 |
|
|
32 |
DepartureFetcher fetcher = new DepartureFetcher(); |
DepartureFetcher fetcher; |
33 |
TransformerFactory transformerFactory = TransformerFactory.newInstance(); |
TransformerFactory transformerFactory = TransformerFactory.newInstance(); |
34 |
DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory.newInstance(); |
DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory.newInstance(); |
35 |
|
|
36 |
|
|
37 |
@Override |
@Override |
38 |
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { |
public void init() throws ServletException { |
39 |
|
super.init(); |
40 |
|
|
41 |
|
boolean useAzureSite = Boolean.parseBoolean( getServletContext().getInitParameter("useazuresite") ); |
42 |
|
int cacheTimeout = Integer.parseInt( getServletContext().getInitParameter("cache_timeout") ); |
43 |
|
int replyTimeout = Integer.parseInt( getServletContext().getInitParameter("reply_timeout") ); |
44 |
|
logger.info( "DepartureServlet, use azure site=" + useAzureSite + ", cache=" + cacheTimeout); |
45 |
|
fetcher = new DepartureFetcher(useAzureSite, cacheTimeout, replyTimeout); |
46 |
|
} |
47 |
|
|
48 |
|
@Override |
49 |
|
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { |
50 |
if (req.getParameter("station") == null) { |
if (req.getParameter("station") == null) { |
51 |
resp.sendError(400, "not enough parameters"); |
resp.sendError(400, "not enough parameters"); |
52 |
return; |
return; |
53 |
} |
} |
54 |
|
|
55 |
|
boolean arrival = false; |
56 |
|
try { |
57 |
|
arrival = Integer.parseInt( req.getParameter("arrival")) != 0; |
58 |
|
} catch (Exception e) {} |
59 |
|
|
60 |
|
Statistics.getInstance().incrementDepartureLookups(); |
61 |
|
|
62 |
int station = Integer.parseInt( req.getParameter("station") ); |
int station = Integer.parseInt( req.getParameter("station") ); |
63 |
String format = req.getParameter("format"); |
String format = req.getParameter("format"); |
64 |
|
|
65 |
List<DepartureBean> beans; |
DepartureBean beans; |
|
|
|
|
String stationName = getStationName(station); |
|
66 |
|
|
67 |
try { |
try { |
68 |
beans = fetcher.cachedLookupDepartures(station); |
beans = fetcher.cachedLookupDepartures(station, arrival); |
69 |
} catch (java.net.SocketTimeoutException ste) { |
beans.arrival = arrival; |
70 |
logger.warning("Read timed out, station="+station); |
} catch (java.io.IOException ioe) { |
71 |
|
logger.warning("Read failed, station="+station + ". " + ioe.getMessage() ); |
72 |
|
Statistics.getInstance().incrementDepartureErrors(); |
73 |
resp.sendError(500); |
resp.sendError(500); |
74 |
return; |
return; |
75 |
} catch (CircuitBreakerException cbe) { |
} catch (CircuitBreakerException cbe) { |
76 |
logger.warning("Circuitbreaker - failing fast"); |
logger.warning("Circuitbreaker - failing fast"); |
77 |
|
Statistics.getInstance().incrementDepartureErrors(); |
78 |
resp.sendError(500); |
resp.sendError(500); |
79 |
return; |
return; |
80 |
} catch (Exception e) { |
} catch (Exception e) { |
81 |
logger.log(Level.WARNING, "Unknown exception, station=" +station, e); |
logger.log(Level.WARNING, "Unknown exception, station=" +station, e); |
82 |
|
Statistics.getInstance().incrementDepartureErrors(); |
83 |
resp.sendError(500); |
resp.sendError(500); |
84 |
return; |
return; |
85 |
} |
} |
89 |
|
|
90 |
if (format.equalsIgnoreCase("xml")) { |
if (format.equalsIgnoreCase("xml")) { |
91 |
resp.setContentType("text/xml"); |
resp.setContentType("text/xml"); |
92 |
resp.getWriter().print( formatXml(beans, stationName) ); |
resp.getWriter().print( formatXml(beans) ); |
93 |
} else if (format.equalsIgnoreCase("html")) { |
} else if (format.equalsIgnoreCase("html")) { |
94 |
req.setAttribute("stationname", stationName ); |
|
95 |
|
String advStr = req.getParameter("advanced"); |
96 |
|
boolean advanced = advStr != null ? Boolean.parseBoolean(advStr) : false; |
97 |
|
|
98 |
|
req.setAttribute("advanced", advanced); |
99 |
req.setAttribute("departurebeans", beans); |
req.setAttribute("departurebeans", beans); |
100 |
req.setAttribute("stationID", station ); |
req.setAttribute("stationID", station ); |
101 |
getServletContext().getRequestDispatcher("/ViewDepartures.jsp").forward(req,resp); |
getServletContext().getRequestDispatcher("/ViewDepartures.jsp").forward(req,resp); |
102 |
} else { |
} else { |
103 |
throw new ServletException("Unknown format"); |
resp.sendError(400, "Unknown format"); |
104 |
} |
} |
105 |
|
|
106 |
} |
} |
107 |
|
|
108 |
protected String formatXml(List<DepartureBean> beans, String stationName) throws ServletException{ |
protected String formatXml(DepartureBean beans) throws ServletException{ |
109 |
String xml = ""; |
|
110 |
try { |
Serializer serializer = new Persister(); |
|
DocumentBuilder builder = docBuilderFactory.newDocumentBuilder(); |
|
|
DOMImplementation impl = builder.getDOMImplementation(); |
|
|
|
|
|
|
|
|
Document doc = impl.createDocument(null,null,null); |
|
|
Element root = doc.createElement("departureinfo"); |
|
|
root.setAttribute("station", stationName); |
|
|
for (DepartureBean departure : beans) { |
|
|
Element train = doc.createElement("train"); |
|
|
|
|
|
Element time = doc.createElement("time"); |
|
|
time.setTextContent( departure.getTime() ); |
|
|
train.appendChild(time); |
|
|
|
|
|
Element updated = doc.createElement("updated"); |
|
|
updated.setTextContent( String.valueOf(departure.getUpdated()) ); |
|
|
train.appendChild(updated); |
|
|
|
|
|
Element trainNumber = doc.createElement("trainnumber"); |
|
|
trainNumber.setTextContent( departure.getTrainNumber() ); |
|
|
train.appendChild(trainNumber); |
|
|
|
|
|
Element destination = doc.createElement("destination"); |
|
|
destination.setTextContent( departure.getDestination()); |
|
|
train.appendChild(destination); |
|
|
|
|
|
Element origin = doc.createElement("origin"); |
|
|
origin.setTextContent( departure.getOrigin() ); |
|
|
train.appendChild(origin); |
|
|
|
|
|
Element location= doc.createElement("location"); |
|
|
location.setTextContent( departure.getLocation() ); |
|
|
train.appendChild(location); |
|
|
|
|
|
Element status = doc.createElement("status"); |
|
|
status.setTextContent( departure.getStatus() ); |
|
|
train.appendChild(status); |
|
|
|
|
|
Element note = doc.createElement("note"); |
|
|
note.setTextContent( departure.getNote() ); |
|
|
train.appendChild(note); |
|
|
|
|
|
root.appendChild(train); |
|
|
} |
|
|
|
|
|
doc.appendChild(root); |
|
|
|
|
|
|
|
|
DOMSource domSource = new DOMSource(doc); |
|
|
|
|
|
Transformer transformer = transformerFactory.newTransformer(); |
|
|
//transformer.setOutputProperty(OutputKeys.OMIT_XML_DECLARATION, "yes"); |
|
|
transformer.setOutputProperty(OutputKeys.METHOD, "xml"); |
|
|
transformer.setOutputProperty(OutputKeys.ENCODING,"ISO-8859-1"); |
|
|
transformer.setOutputProperty("{http://xml.apache.org/xslt}indent-amount", "4"); |
|
|
transformer.setOutputProperty(OutputKeys.INDENT, "yes"); |
|
|
java.io.StringWriter sw = new java.io.StringWriter(); |
|
|
StreamResult sr = new StreamResult(sw); |
|
|
transformer.transform(domSource, sr); |
|
|
xml = sw.toString(); |
|
111 |
|
|
112 |
|
ByteArrayOutputStream out = new ByteArrayOutputStream(); |
113 |
|
|
114 |
|
try { |
115 |
|
serializer.write(beans, out); |
116 |
} catch (Exception e) { |
} catch (Exception e) { |
117 |
throw new ServletException(e); |
throw new ServletException(e); |
118 |
} |
} |
119 |
return xml; |
|
120 |
} |
return out.toString(); |
|
|
|
|
protected String getStationName(int stationID) { |
|
|
String station = ""; |
|
|
|
|
|
Connection conn = null; |
|
|
try { |
|
|
conn = DBConnection.getConnection(); |
|
|
Statement stmt = conn.createStatement(); |
|
|
ResultSet rs = stmt.executeQuery("SELECT name FROM trainstations WHERE id=" + stationID); |
|
|
if (rs.next()) { |
|
|
station = rs.getString(1); |
|
|
} |
|
|
|
|
|
} catch (Exception e) { |
|
|
} finally { |
|
|
try { |
|
|
if (conn != null && !conn.isClosed()) |
|
|
conn.close(); |
|
|
} catch (Exception e) {} |
|
|
} |
|
|
|
|
|
return station; |
|
121 |
} |
} |
122 |
|
|
123 |
} |
} |