package com.petetwitt; import java.io.*; import java.util.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; import java.sql.ResultSet; public class UIMain extends HttpServlet { String allTwitts; Connection conn = null; public void init(ServletConfig config) throws ServletException { super.init(config); System.out.println("******************** Start PeteTwitt *****************"); // Put any initializations here allTwitts = ""; } public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { try { PrintWriter out = response.getWriter(); BufferedReader reader = request.getReader(); String command = request.getParameter("command"); String user = request.getParameter("user"); System.out.println("command: "+command); System.out.println("user: "+user); if (command==null) { // No command response.setContentType("text/html"); out.println(""); out.println("No command

"); out.println(""); return; } if (command.equals("submitTwitt")) { String twittText = request.getParameter("twittText"); //response.setContentType("document/text"); response.setContentType("text/html"); //response.setContentType("application/xml"); //out.println(""); allTwitts += twittText + "|"; out.println(allTwitts); // Uncomment when you have DB // accessDB(); } } catch(Exception e) { e.printStackTrace(); } } /* MySQL/J2EE communication example. Uncomment when you have MySQL and connector running and you have created and initialized your DB with name, login. password. email etc void accessDB() { try { conn = DriverManager.getConnection("jdbc:mysql://localhost/users?" + "user=root&password=xxxx"); // Do something with the Connection System.out.println("Connection ready."); } catch (SQLException ex) { // handle any errors System.out.println("SQLException: " + ex.getMessage()); System.out.println("SQLState: " + ex.getSQLState()); System.out.println("VendorError: " + ex.getErrorCode()); } Statement stmt = null; ResultSet rs = null; try { stmt = conn.createStatement(); rs = stmt.executeQuery("SELECT * FROM user"); // or alternatively, if you don't know ahead of time that // the query will be a SELECT... if (stmt.execute("SELECT * FROM user WHERE login='grr'")) { rs = stmt.getResultSet(); } while (rs.next()) { String name = rs.getString(1); String login = rs.getString(2); String password = rs.getString(3); String email = rs.getString(4); //int age = rs.getInt(3); System.out.println("name=" + name); System.out.println("login=" + login); System.out.println("password=" + password); System.out.println("email=" + email); System.out.println("---------------"); } // Now do something with the ResultSet .... System.out.println("ResultSet here"); } catch (SQLException ex){ // handle any errors System.out.println("SQLException: " + ex.getMessage()); System.out.println("SQLState: " + ex.getSQLState()); System.out.println("VendorError: " + ex.getErrorCode()); } finally { // it is a good idea to release // resources in a finally{} block // in reverse-order of their creation // if they are no-longer needed if (rs != null) { try { rs.close(); } catch (SQLException sqlEx) { } // ignore rs = null; } if (stmt != null) { try { stmt.close(); } catch (SQLException sqlEx) { } // ignore stmt = null; } } } */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { PrintWriter out = response.getWriter(); BufferedReader reader = request.getReader(); String command = request.getParameter("command"); } }