/*
vim:ts=4:nowrap
*/

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class SQLServerDataSerializer extends HttpServlet
{
	final String XML_HDR = "<?xml version=\"1.0\"?>";

	public void doGet(
		HttpServletRequest request, HttpServletResponse response)
		throws IOException, ServletException
	{
		PrintWriter out = response.getWriter();

		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			Connection con = DriverManager.getConnection(
				"jdbc:microsoft:sqlserver://agriya:1433",
				"ssreader", "ssreader");

            Statement select = con.createStatement();
			String cmd = request.getParameter("op");
			String sql = "", usr = "", result = "";

			response.setHeader("Expires", "now");
			response.setHeader("Cache-Control", "no-cache");

			if (cmd.equals("ListUserDetails")) {
				usr = request.getParameter("usr");
				if (usr == null) usr = "";

				sql = "select SSAFENAME, PROJECT, VERSION from VSSLOG where SSUSER='"
					+ usr + "'";

				ResultSet res = select.executeQuery(sql);

				response.setContentType("application/xml"); 
				out.println(XML_HDR + "\n<ListUserDetails>");

	            while( res.next() ) {
					out.println("<detail ssafename=\""
						+ res.getString("SSAFENAME")
						+ "\" project=\"" + res.getString("PROJECT")
						+ "\" version=\"" + res.getString("VERSION")
						+ "\" />");
				}
				out.println("</ListUserDetails>");
			}
            select.close();
            con.close();
        }
        catch ( Exception e ) {
            e.printStackTrace();
        }
	}
}