<jsp:useBean id="status" scope="page" class="com.javaprofessionals.tools.jspDataBean" />

<%
boolean ffwd = false;

if (request.getParameter("Submit")!=null) {
ffwd=true;
String db ="vc89lab";
String server = "jdbc:mysql://dev-1.javaprofessionals.com:3306/";
String use ="vc89";
String pas ="java";
status.reset(db,use,pas,server);
String str="";
String Qry = "Insert Into chat(";
String qpt = ")values(";
java.util.Enumeration e = request.getParameterNames();
boolean first = true;
while (e.hasMoreElements()) {
str = (String)e.nextElement();
if(!str.equalsIgnoreCase("Submit")){
if (!first) {
Qry+=",";
qpt+=",";
}
first=false;
Qry+=str;
String strstuff = request.getParameter(str);
com.javaprofessionals.lang.Macro mc = new com.javaprofessionals.lang.Macro(strstuff);
// strstuff= mc.replace("'", "\'");
// mc = new com.javaprofessionals.lang.Macro(strstuff);
strstuff= mc.replace("\"", "&Quote123");
// mc = new com.javaprofessionals.lang.Macro(strstuff);
// strstuff= mc.replace( "quote123","\"");
// System.out.println(" replaced " +strstuff );
qpt+="\""+strstuff+"\"";

}
}
qpt+=")";
try{
Qry+=qpt;
System.out.println( Qry );
status.UpdateQuery(Qry);
}catch(Throwable t){
System.out.println("Error "+t );
}
}
if (ffwd) {
%>
<jsp:forward page=ChatRoom.jsp/>
<%
} else {
if (request.getParameter("response")!=null) {
%>

<FORM METHOD=POST ACTION="chat.jsp">
<INPUT TYPE="TEXT" NAME="Email" ALIGN=LEFT>Email Please<p>
<INPUT TYPE="TEXT" NAME="Name" ALIGN=LEFT>Your Name<p>
<INPUT TYPE="TEXT" NAME="Subject" ALIGN=LEFT value="RE: <%=request.getParameter("subject")%>"><p>
<TEXTAREA NAME="Body" ROWS="16" COLS="100" ALIGN=LEFT>Whats the story</textarea><p>

<input type="hidden" name="UplinkID" value='<%=request.getParameter("response")%>'>
<INPUT TYPE="Submit" NAME="Submit" VALUE="Submit" ALIGN="LEFT">
</FORM>
<%

} else {

%>

<FORM METHOD=POST ACTION="chat.jsp">
<INPUT TYPE="TEXT" NAME="Email" ALIGN=LEFT>Email Please<p>
<INPUT TYPE="TEXT" NAME="Name" ALIGN=LEFT>Your Name<p>
<INPUT TYPE="TEXT" NAME="Subject" ALIGN=LEFT>Whats the beef :)<p>
<TEXTAREA NAME="Body" ROWS="16" COLS="100" ALIGN=LEFT>Whats the story</textarea><p>

<INPUT TYPE="Submit" NAME="Submit" VALUE="Submit" ALIGN="LEFT">
</FORM>
<%
} // endif
} // endif
%>