From d26dbab8f789d787d5c39f8700b4ac19701f286f Mon Sep 17 00:00:00 2001
From: Julien Sere <jsere>
Date: Sat, 22 Jan 2011 17:22:13 +0000
Subject: initial check out java

git-svn-id: file:///var/svn/2011-usi/trunk@13 db941bf7-0cb3-4dda-9634-87faf64f93a7
---
 app/v2_java/src/org/usi2011/Question.java | 67 +++++++++++++++++++++++++++++++
 1 file changed, 67 insertions(+)
 create mode 100644 app/v2_java/src/org/usi2011/Question.java

(limited to 'app/v2_java/src/org/usi2011/Question.java')

diff --git a/app/v2_java/src/org/usi2011/Question.java b/app/v2_java/src/org/usi2011/Question.java
new file mode 100644
index 0000000..0c391d3
--- /dev/null
+++ b/app/v2_java/src/org/usi2011/Question.java
@@ -0,0 +1,67 @@
+package org.usi2011;
+
+import java.io.IOException;
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+
+import javax.servlet.ServletException;
+import javax.servlet.ServletOutputStream;
+import javax.servlet.http.HttpServlet;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+
+/**
+ * Servlet implementation class question
+ */
+public class Question extends HttpServlet {
+	private static final long serialVersionUID = 1L;
+	private Connection connection;
+	/**
+	 * Default constructor.
+	 */
+	public Question() {
+		super();
+		connection = Database.getConnection();
+	}
+
+	/**
+	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
+	 *      response)
+	 */
+	protected void doGet(HttpServletRequest request,
+			HttpServletResponse response) throws ServletException, IOException {
+		ServletOutputStream out = response.getOutputStream();
+		
+		try {
+			String query = "INSERT INTO game VALUES (1, 2, 3, 4, 5)";
+			Statement statement = connection.createStatement();
+			ResultSet resultset = statement.executeQuery(query);
+			query = "SELECT * FROM game";
+			statement = connection.createStatement();
+			resultset = statement.executeQuery(query);
+			while (resultset.next()) {
+				out.println(resultset.getString(1));
+			}
+		} catch (SQLException e) {
+			response.sendError(400);
+		}
+		
+		
+		out.println("hello world");
+		out.println(request.getRequestURI());
+		
+	}
+
+	/**
+	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
+	 *      response)
+	 */
+	protected void doPost(HttpServletRequest request,
+			HttpServletResponse response) throws ServletException, IOException {
+		// TODO Auto-generated method stub
+	}
+
+}
-- 
cgit v1.2.3