traininfoservice/banedk/DepartureServlet.java

package dk.thoerup.traininfoservice.banedk;

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.transform.OutputKeys;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;

import org.w3c.dom.DOMImplementation;
import org.w3c.dom.Document;
import org.w3c.dom.Element;

import dk.thoerup.curcuitbreaker.CircuitBreakerException;
import dk.thoerup.traininfoservice.DBConnection;

/**
 * Servlet implementation class DepartureServlet
 */
public class DepartureServlet extends HttpServlet {
        private static final long serialVersionUID = 1L;
        
        Logger logger = Logger.getLogger( DepartureServlet.class.getName() );

        DepartureFetcher fetcher = new DepartureFetcher();
    TransformerFactory transformerFactory = TransformerFactory.newInstance();
        DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory.newInstance();
        

        @Override
        protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
                int station = Integer.parseInt( req.getParameter("station") );
                String format = req.getParameter("format");

                List<DepartureBean> beans;

                String stationName = getStationName(station);

                try {
                        beans = fetcher.cachedLookupDepartures(station);
                } catch (java.net.SocketTimeoutException ste) {
                        logger.warning("Read timed out, station="+station);
                        resp.sendError(500);
                        return;
                } catch (CircuitBreakerException cbe) {
                        logger.warning("Circuitbreaker - failing fast");
                        resp.sendError(500);
                        return;
                } catch (Exception e) {                 
                        logger.log(Level.WARNING, "Unknown exception, station=" +station, e);
                        resp.sendError(500);
                        return;
                }
                
                resp.setDateHeader("Expires", 0);
                resp.setHeader("Cache-Control", "no-cache, must-revalidate");
                
                if (format.equalsIgnoreCase("xml")) {
                        resp.setContentType("text/xml");
                        resp.getWriter().print( formatXml(beans, stationName) );
                } else if (format.equalsIgnoreCase("html")) {
                        req.setAttribute("stationname", stationName );
                        req.setAttribute("departurebeans", beans);
                        req.setAttribute("stationID", station );
                        getServletContext().getRequestDispatcher("/ViewDepartures.jsp").forward(req,resp);
                } else {
                        throw new ServletException("Unknown format");
                }

        }

        protected String formatXml(List<DepartureBean> beans, String stationName) throws ServletException{
                String xml = "";
                try {
                        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();


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

        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;
        }

}
1	package dk.thoerup.traininfoservice.banedk;
2
3	import java.io.IOException;
4	import java.sql.Connection;
5	import java.sql.ResultSet;
6	import java.sql.Statement;
7	import java.util.List;
8	import java.util.logging.Level;
9	import java.util.logging.Logger;
10
11	import javax.servlet.ServletException;
12	import javax.servlet.http.HttpServlet;
13	import javax.servlet.http.HttpServletRequest;
14	import javax.servlet.http.HttpServletResponse;
15	import javax.xml.parsers.DocumentBuilder;
16	import javax.xml.parsers.DocumentBuilderFactory;
17	import javax.xml.transform.OutputKeys;
18	import javax.xml.transform.Transformer;
19	import javax.xml.transform.TransformerFactory;
20	import javax.xml.transform.dom.DOMSource;
21	import javax.xml.transform.stream.StreamResult;
22
23	import org.w3c.dom.DOMImplementation;
24	import org.w3c.dom.Document;
25	import org.w3c.dom.Element;
26
27	import dk.thoerup.curcuitbreaker.CircuitBreakerException;
28	import dk.thoerup.traininfoservice.DBConnection;
29
30	/**
31	* Servlet implementation class DepartureServlet
32	*/
33	public class DepartureServlet extends HttpServlet {
34	private static final long serialVersionUID = 1L;
35
36	Logger logger = Logger.getLogger( DepartureServlet.class.getName() );
37
38	DepartureFetcher fetcher = new DepartureFetcher();
39	TransformerFactory transformerFactory = TransformerFactory.newInstance();
40	DocumentBuilderFactory docBuilderFactory = DocumentBuilderFactory.newInstance();
41
42
43	@Override
44	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
45	int station = Integer.parseInt( req.getParameter("station") );
46	String format = req.getParameter("format");
47
48	List<DepartureBean> beans;
49
50	String stationName = getStationName(station);
51
52	try {
53	beans = fetcher.cachedLookupDepartures(station);
54	} catch (java.net.SocketTimeoutException ste) {
55	logger.warning("Read timed out, station="+station);
56	resp.sendError(500);
57	return;
58	} catch (CircuitBreakerException cbe) {
59	logger.warning("Circuitbreaker - failing fast");
60	resp.sendError(500);
61	return;
62	} catch (Exception e) {
63	logger.log(Level.WARNING, "Unknown exception, station=" +station, e);
64	resp.sendError(500);
65	return;
66	}
67
68	resp.setDateHeader("Expires", 0);
69	resp.setHeader("Cache-Control", "no-cache, must-revalidate");
70
71	if (format.equalsIgnoreCase("xml")) {
72	resp.setContentType("text/xml");
73	resp.getWriter().print( formatXml(beans, stationName) );
74	} else if (format.equalsIgnoreCase("html")) {
75	req.setAttribute("stationname", stationName );
76	req.setAttribute("departurebeans", beans);
77	req.setAttribute("stationID", station );
78	getServletContext().getRequestDispatcher("/ViewDepartures.jsp").forward(req,resp);
79	} else {
80	throw new ServletException("Unknown format");
81	}
82
83	}
84
85	protected String formatXml(List<DepartureBean> beans, String stationName) throws ServletException{
86	String xml = "";
87	try {
88	DocumentBuilder builder = docBuilderFactory.newDocumentBuilder();
89	DOMImplementation impl = builder.getDOMImplementation();
90
91
92	Document doc = impl.createDocument(null,null,null);
93	Element root = doc.createElement("departureinfo");
94	root.setAttribute("station", stationName);
95	for (DepartureBean departure : beans) {
96	Element train = doc.createElement("train");
97
98	Element time = doc.createElement("time");
99	time.setTextContent( departure.getTime() );
100	train.appendChild(time);
101
102	Element updated = doc.createElement("updated");
103	updated.setTextContent( String.valueOf(departure.getUpdated()) );
104	train.appendChild(updated);
105
106	Element trainNumber = doc.createElement("trainnumber");
107	trainNumber.setTextContent( departure.getTrainNumber() );
108	train.appendChild(trainNumber);
109
110	Element destination = doc.createElement("destination");
111	destination.setTextContent( departure.getDestination());
112	train.appendChild(destination);
113
114	Element origin = doc.createElement("origin");
115	origin.setTextContent( departure.getOrigin() );
116	train.appendChild(origin);
117
118	Element location= doc.createElement("location");
119	location.setTextContent( departure.getLocation() );
120	train.appendChild(location);
121
122	Element status = doc.createElement("status");
123	status.setTextContent( departure.getStatus() );
124	train.appendChild(status);
125
126	Element note = doc.createElement("note");
127	note.setTextContent( departure.getNote() );
128	train.appendChild(note);
129
130	root.appendChild(train);
131	}
132
133	doc.appendChild(root);
134
135
136	DOMSource domSource = new DOMSource(doc);
137
138	Transformer transformer = transformerFactory.newTransformer();
139	//transformer.setOutputProperty(OutputKeys.OMIT_XML_DECLARATION, "yes");
140	transformer.setOutputProperty(OutputKeys.METHOD, "xml");
141	transformer.setOutputProperty(OutputKeys.ENCODING,"ISO-8859-1");
142	transformer.setOutputProperty("{http://xml.apache.org/xslt}indent-amount", "4");
143	transformer.setOutputProperty(OutputKeys.INDENT, "yes");
144	java.io.StringWriter sw = new java.io.StringWriter();
145	StreamResult sr = new StreamResult(sw);
146	transformer.transform(domSource, sr);
147	xml = sw.toString();
148
149
150	} catch (Exception e) {
151	throw new ServletException(e);
152	}
153	return xml;
154	}
155
156	protected String getStationName(int stationID) {
157	String station = "";
158
159	Connection conn = null;
160	try {
161	conn = DBConnection.getConnection();
162	Statement stmt = conn.createStatement();
163	ResultSet rs = stmt.executeQuery("SELECT name FROM trainstations WHERE id=" + stationID);
164	if (rs.next()) {
165	station = rs.getString(1);
166	}
167
168	} catch (Exception e) {
169	} finally {
170	try {
171	if (conn != null && !conn.isClosed())
172	conn.close();
173	} catch (Exception e) {}
174	}
175
176	return station;
177	}
178
179	}