<%@ page
    language="java"
    contentType="text/html;charset=utf-8"
%>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.ResultSetMetaData"%>
<%@ page import="java.net.URLEncoder"%>

<%

                Class.forName("com.mysql.jdbc.Driver").newInstance();
                Connection connection = DriverManager.getConnection(
		"jdbc:mysql://intf/vmr?autoReconnect=true",
		"troy_griffitts",
		"pizza");

            String sql = "SELECT * FROM DOCUMENT WHERE DOCUMENTID=10046";
                try {
                    PreparedStatement stmt = connection.prepareStatement(sql);
                    ResultSet rs = stmt.executeQuery();
	        while (rs.next()) {
	        ResultSetMetaData meta = rs.getMetaData();
	        int colCount = meta.getColumnCount();
	              for (int i = 0; i < colCount; i++) {
	                  Object o = rs.getObject(i + 1);
	                  String colVal = (o != null) ? o.toString() : "";
	                  colVal = URLEncoder.encode(colVal, "UTF-8");
                      out.write(colVal);
	                  if (i + 1 < colCount) out.write("|");
	              }
	              out.write("\n");
	          }
			out.println("OK");
                }
                catch (Exception e) {
                        out.print("Failure to execute basic query: " + e + " SQL: " + sql);
                        e.printStackTrace();
                }
                finally {
                        connection.close();
                }

%>