datamanagerservlet.java

Java Servlet to capture data from a Java Mobile appication and save the data in Mysql database

/*--------------------------------------------------
* DataManagerServlet.java
*
* Use GET to communicate with a Java servlet. 
* The servlet will Submit Data to a database 
* 
* BIT-001-0141/2006 NJERU NGANATHA ANDREW
*-------------------------------------------------*/

package com.servlets;

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

public class DataManagerServlet extends HttpServlet
{
  protected void doGet(HttpServletRequest req, HttpServletResponse res) 
                       throws ServletException, IOException
  {
    // Same code appears in doPost()
    // Shown both places to emphasize that data is received thru
    // different means (environment variable vs stream), 
    // yet processed the same inside the servlet
    String sur = req.getParameter("surname"), 
	     fst = req.getParameter("firstname"), 
	     age = req.getParameter("age"), 
	     gdr = req.getParameter("gender"),
	     rst = req.getParameter("results");           

    String balance = submitUpload(sur, fst, age, gdr, rst);

    if (balance == null)
    {
      res.sendError(res.SC_BAD_REQUEST, "Data Has been Uploaded Successfully.");            
      return;
    }

    res.setContentType("text/plain");    
    PrintWriter out = res.getWriter();
    out.print(balance);
    out.close();
  }


  /*--------------------------------------------------
  * Insert Data into database
  *-------------------------------------------------*/
  private String submitUpload(String sur, String fst, String age, String gdr, String rst)
  {
    Connection con = null;
    Statement st = null;
    StringBuffer msgb = new StringBuffer("");

    try
    {
      // These will vary depending on your server/database      
      Class.forName("com.mysql.jdbc.Driver");  
      con = DriverManager.getConnection("jdbc:mysql://localhost:3306/datamanager","root","pass");

      Statement stmt = con.createStatement();
      int add = stmt.executeUpdate("insert into data values (null,'"+sur+"','"+fst+"','"+age+"','"+gdr+"','"+rst+"')");      
      if (add != 1)
       return null;
	else
       return null;
    }
    catch (Exception e)
    {
      return e.toString();
    }
  }
  /*--------------------------------------------------
  * Information about servlet
  *-------------------------------------------------*/     
  public String getServletInfo()
  {
    return "DataManagerServlet 1.0 - Andrew N. Njeru";
  }
}