HTMLViewHandler2

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
//DBDataHandler dbData;

public class HTMLViewHandler2 extends HttpServlet {
public void init (ServletConfig srvCfg) throws ServletException {
super.init(srvCfg);    
}

public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
    DBDataHandler dbData = new DBDataHandler();
    String myURL = "U:\\Orion\\view1.xml";
    FileWriter file = new FileWriter(myURL);
    PrintWriter out1 = new PrintWriter(file);
    String mySql = getReqInfo(req, out1);
    System.out.println(mySql);
    dbData.makeXML(mySql, out1, myURL);	
    
res.setContentType("text/html"); //must be before first ref to PrintWriter
PrintWriter out = res.getWriter();
out.println("<HTML><TITLE>HTMLViewHandler2</TITLE></BODY>");
out.println("<H2>Servlet API Example - HTMLViewHandler</H2><HR>");
//Retrieving the single-value parameters
out.println("Hi <B>" + "You got it !" + ",</B><P>");
out.println("<HR>");
out.println("</BODY></HTML>");

/*
//try{
    System.out.println("\nInside the try");    
	} catch (SQLException se) {
	System.out.println(se);
 	} */
out.close();
}

public String getReqInfo(HttpServletRequest req, PrintWriter out)
throws ServletException, IOException{
	StringBuffer prepareSql = new StringBuffer();
	prepareSql.append("Select");	
		
	if(req.getParameter("firstname") != null){		
		prepareSql.append(" name,");
	} 	
	if(req.getParameter("city") != null){		
		prepareSql.append(" city,");
	}
	if(req.getParameter("zip") != null){		
		prepareSql.append(" zip,");
	}
	if(req.getParameter("country") != null){		
		prepareSql.append(" country,");
	}
	if(req.getParameter("email") != null){		
		prepareSql.append(" email,");
	} 
	// Deleting the Coma at the end of an entity.
	int sbLength = prepareSql.length();	
	prepareSql.deleteCharAt(sbLength - 1);
		
	prepareSql.append(" from Personal where immat = " + Integer.parseInt(req.getParameter("immat")));	
	
	return prepareSql.toString();
	}
} //end of class