package xml;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
//import xml.test;
import xml.trong;
public class sqlcatch extends HttpServlet {
private static final String CONTENT_TYPE = "text/xml";
/**Initialize global variables*/
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
/**Process the HTTP Post request*/
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
Enumeration element = request.getParameterNames();
String param = null,sqlstring=null;
sqlstring="\n";
sqlstring+="\n";
// out = new OutputStreamWriter(System.out, "UTF8");
PrintWriter out = response.getWriter();
/* out.println("");
out.println("
");*/
String[] colname,tablename;
colname=request.getParameterValues("colname");
sqlstring+=" ";
sqlstring+="";
tablename=request.getParameterValues("tablename");
sqlstring+=" ";
if (tablename.length==0) ;
else {
for (int i=0;i"+tablename[i]+"";
};
sqlstring+=" ";
sqlstring+=" ";
boolean flag=false;
String name = request.getParameter("name");
if (name==null) ;
else{
if (name.length()==0) ;
else {
flag=true;
sqlstring+=""+"ename"+"";
sqlstring+="";
sqlstring+=" %"+name+"% ";
sqlstring+="";
};
};
String[] job=request.getParameterValues("job");
if (job==null) ;
else{
if (job.length==0) ;
else {
flag=true;
for (int i=0;i"+"job"+"";
sqlstring+="";
sqlstring+=" %"+job[i]+"% ";
sqlstring+="";
};
};
};
String[] sal = request.getParameterValues("sal");
if (sal==null) ;
else{
if (sal.length==0) ;
else {
flag=true;
for (int i=0;i"+"sal"+"";
sqlstring+="";
sqlstring+=" "+sal[i]+" ";
sqlstring+="";
};
};
};
if (flag) sqlstring=sqlstring.substring(0,sqlstring.length()-6);
sqlstring+=" ";
sqlstring+="";
// out.println(sqlstring);
trong test = new trong();
test.abc(sqlstring);
// out.println(a.bbb);*/
out.println("");
out.println(test.finalSQL);
out.println("");
}
/**Clean up resources*/
public void destroy() {
}
}