/*
*
Main Entry Point J204 Java API Test Servlet
*/
package registration;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.math.*;
import java.net.*;
import java.io.*;
import java.sql.*;
import sun.net.smtp.*;
/**
* Servlet Registration
application
*
* @author Mark Larocca
* @version 1.00 10/07/2004
*
* Simple servlet
to register users on the Web
*
* This project requires
to have Tomcat and ANT installed.
*
*/
public final class reg
extends HttpServlet {
Connection jdbcConnect
= null;
public String s;
public String CompanyIn;
public String ExtensionIn;
public String CommentsIn;
public String SalutationIn;
public String FirstNameIn;
public String LastNameIn;
public String AddressIn;
public String Line2In;
public String Line3In;
public String CityIn;
public String StateIn;
public String ZipcodeIn;
public String CountryIn;
public String EmailIn;
public String PhoneIn;
public String MorningIn;
public String AfternoonIn;
public String FaxIn;
public String TitleIn;
public String HarborsideHotelIn;
public String ReceptionIn;
public String AttendingDateIn;
public String TrainingSessionIn;
public String RefresherIn;
public String PartyIn;
public String MondayIn;
public String TuesdayIn;
public String WednesdayIn;
public String TrackerIn;
public HttpSession
session;
public String strHTTPRedirectTo
= new String("https://insight.cca-int.com/registration/register05.html");
public void
doGet( HttpServletRequest request,
HttpServletResponse
response )
throws ServletException, IOException
{
// This method receives and responds to any GET request.
PrintWriter output;
response.setContentType( "text/html" ); // content
type
output = response.getWriter(); // get writer
// create and send HTML page to client
StringBuffer buf = new StringBuffer();
buf.append( "<HTML><HEAD>\n" );
buf.append( "<META http-equiv=refresh" );
buf.append( " content='1;URL=" + strHTTPRedirectTo
+ "'>\n" );
buf.append( "<TITLE>\n" );
buf.append( "Insight 2005 Registration\n" );
buf.append( "</TITLE></HEAD>\n"
);
buf.append( "</HTML>\n");
output.println( buf.toString() );
output.close(); // close PrintWriter stream
}
public void doPost(
HttpServletRequest request,
HttpServletResponse
response )
throws ServletException, IOException
{
// This method receives and responds to any POST request.
PrintWriter output;
response.setContentType( "text/html" ); // content
type
StringBuffer buf = new StringBuffer();
output = response.getWriter(); // get writer
// read current page
response
CompanyIn = request.getParameter(
"Company" );
SalutationIn = request.getParameter( "Salutation"
);
FirstNameIn = request.getParameter( "FirstName"
);
LastNameIn = request.getParameter( "LastName"
);
AddressIn = request.getParameter( "Address"
);
Line2In = request.getParameter( "Line2" );
Line3In = request.getParameter( "Line3" );
CityIn = request.getParameter( "City" );
StateIn = request.getParameter( "State" );
ZipcodeIn = request.getParameter( "Zipcode"
);
CountryIn = request.getParameter( "Country"
);
PhoneIn = request.getParameter( "Phone" );
ExtensionIn = request.getParameter( "Extension"
);
FaxIn = request.getParameter( "Fax" );
EmailIn = request.getParameter( "Email" );
MorningIn = request.getParameter( "Morning"
);
AfternoonIn = request.getParameter( "Afternoon"
);
CommentsIn = request.getParameter( "Comments"
);
TitleIn = request.getParameter( "Title" );
HarborsideHotelIn = request.getParameter( "harborsidehotel"
);
ReceptionIn = request.getParameter( "reception"
);
MondayIn = request.getParameter( "Monday"
);
TuesdayIn = request.getParameter( "Tuesday"
);
WednesdayIn = request.getParameter( "Wednesday"
);
if (MondayIn == null) {MondayIn = " ";}
if (TuesdayIn == null) {TuesdayIn = " ";}
if (WednesdayIn == null) {WednesdayIn = " ";}
AttendingDateIn = MondayIn + ", " + TuesdayIn
+ ", " + WednesdayIn;
TrainingSessionIn = request.getParameter( "trainingsession"
);
RefresherIn = request.getParameter( "refresher"
);
PartyIn = request.getParameter( "party" );
CompanyIn.trim();
SalutationIn.trim();
FirstNameIn.trim();
LastNameIn.trim();
AddressIn.trim();
Line2In.trim();
Line3In.trim();
CityIn.trim();
StateIn.trim();
ZipcodeIn.trim();
PhoneIn.trim();
ExtensionIn.trim();
FaxIn.trim();
EmailIn.trim();
CommentsIn.trim();
TitleIn.trim();
if (MorningIn == null) {MorningIn = " ";}
if (AfternoonIn == null) {AfternoonIn = " ";}
if (HarborsideHotelIn == null) {HarborsideHotelIn =
" ";}
if (ReceptionIn == null) {ReceptionIn = " ";}
if (AttendingDateIn == null) {AttendingDateIn = "
";}
if (TrainingSessionIn == null) {TrainingSessionIn =
" ";}
if (RefresherIn == null) {RefresherIn = " ";}
if (PartyIn == null) {PartyIn = " ";}
// Check to see
if customer already registered
// If so, a session will already exist
session = request.getSession(true);
if ((!session.isNew()) && (TrackerIn == session.getAttribute("tracker.name")))
{
// this session already registered
response.sendRedirect(strHTTPRedirectTo);
output.close(); // close PrintWriter stream
return;
}
TrackerIn = FirstNameIn + " " + LastNameIn;
session.setAttribute("tracker.name", TrackerIn);
String valueDsn = "com.cca.j204.J204Driver";
String valueConn = "JDBC:J204://ccamvs1:2455/SQL/admin/admin";
// create and send HTML page to client
buf.append( "<HTML><HEAD>\n<TITLE>\n"
);
buf.append( "Insight 2005 Registration\n" );
buf.append( "</TITLE></HEAD>\n<BODY><FORM
METHOD='GET'>\n" );
buf.append( "<H1> Insight 2005 Registration
</H1>" );
Random generator
= new Random (System.currentTimeMillis());
int i = generator.nextInt();
if (i < 0)
i = i * -1;
s = Integer.toString(i);
while (s.length() < 10)
s = "0" + s;
if (loadDriver(valueDsn,
buf)) // if driver loaded
{
if(doConnect(valueConn, buf)) // if connection valid
{
// execute SQL request
execInsert(buf);
shutDownServlet(buf);
}
}
buf.append( "</FORM></BODY></HTML>"
);
output.println( buf.toString() );
output.close(); // close PrintWriter stream
}
public void shutDownServlet(StringBuffer
buf)
{
try {
jdbcConnect.close();
jdbcConnect = null;
}
catch ( SQLException eSQL ) {
buf.append( "<br>
Dissconnect error: " + eSQL.getMessage() );
buf.append( "<br>
Your registration may be complete. \n" );
buf.append( "<br>
See previous messages. \n" );
}
}
protected boolean loadDriver(String szDriver, StringBuffer
buf)
{
boolean bRet = true;
try {
Class.forName(szDriver);
} catch(ClassNotFoundException
eClass)
{
bRet
= false;
buf.append("<br>Class
Not Found Error: <b>" + eClass.getMessage()
+ " </b>While Trying to Load Class: <b>"
+ szDriver + "</b> \n");
session.invalidate();
// erase session
}
return(bRet);
}
protected boolean doConnect(String szConnect, StringBuffer
buf)
{
boolean bRet
= true;
if(szConnect
!= null)
{
try
{
jdbcConnect
= DriverManager.getConnection(szConnect);
}
catch(SQLException
eSQL)
{
buf.append("<br>Connection error:
<b>" + eSQL.getMessage() + "</b>
Connect String: <b>" + szConnect + "</b>
\n");
buf.append( "<br>Please try again
later, or Call CCA Support \n" );
jdbcConnect = null;
bRet = false;
session.invalidate(); // erase session
}
}
return(bRet);
}
protected void emailReply(StringBuffer buf)
{
try {
SmtpClient mailer
= new SmtpClient("xyz.yourcompany.com");
mailer.from("xyz@yourcompany.com");
mailer.to(EmailIn);
java.io.PrintStream ps = mailer.startMessage();
ps.println("From: " + "xyz@yourcompany.com");
ps.println("To: " + EmailIn);
ps.println("Subject: " + "Insight 2005
Registration");
ps.println("\n Thank you for registering for CCA's
Insight 204 Symposium");
ps.println("\n being held in Boston, MA., June
5-8,2005.");
ps.println("\n Your Registration ID number is "
+ s + ".");
ps.println("\n If you have any questions or need
to make changes, please contact");
ps.println("\n Cheryl Hanlin at (508) 270-6666,
ext 567.");
ps.println("\n We look forward to seeing you in
Boston in June!");
mailer.closeServer();
mailer = new SmtpClient("xyz.yourcompany.com");
mailer.from(EmailIn);
mailer.to("xyz@yourcompany.com");
ps = mailer.startMessage();
String Body = "\n";;
ps.println("From: " + EmailIn);
ps.println("To:
" + "xyz@yourcompany.com");
ps.println("Subject:
" + "Insight 2005 Registration");
Body = Body + "\nCompany: \t" + CompanyIn;
Body = Body + "\nName: \t" + SalutationIn
+ " " + FirstNameIn + " " + LastNameIn;
Body = Body + "\nAddress: \t" + AddressIn;
Body = Body + "\n \t" + Line2In;
Body = Body + "\n \t" + Line3In;
Body = Body + "\n \t" + CityIn + ", "
+ StateIn + " " + ZipcodeIn;
Body = Body + "\nCountry: \t" + CountryIn;
Body = Body + "\nEmail: \t" + EmailIn;
Body = Body + "\nPhone: \t" + PhoneIn + "
Ext: " + ExtensionIn;
Body = Body + "\nFax: \t" + FaxIn;
Body = Body + "\nTitle: \t" + TitleIn;
Body = Body + "\nHarborside Hotel: \t" + HarborsideHotelIn;
Body = Body + "\nReception: \t" + ReceptionIn;
Body = Body + "\nAttending Dates:\t" + AttendingDateIn;
Body = Body + "\nDinner Party: \t" + PartyIn;
Body = Body + "\nTraining Session:\t" + TrainingSessionIn;
Body = Body + "\nRefresher course: \t" + RefresherIn;
Body = Body + "\nMorning Class: \t" + MorningIn;
Body = Body + "\nAfternoon Class:\t" + AfternoonIn;
Body = Body + "\nComments:";
Body = Body + "\n\t" + CommentsIn;
ps.println(Body);
mailer.closeServer();
}
catch (Exception ex) {
buf.append( "<br>There was an error sending
your email response! \n" );
buf.append( "<br>Please Call CCA Support. \n"
);
}
}
protected void execInsert(StringBuffer buf)
{
try {
String query = "INSERT INTO reg.register
(" +
"regid, co_cd,
ext, comments, salutation," +
"fname, lname, addr1, addr2, addr3, " +
" city, state, zip, country, " +
"email, phone, checked_in, morning_session, afternoon_session,
fax, " +
"harborside_hotel, reception, attending_date, dinner_party,
" +
"training_session, refresher, title" +
") VALUES ('" +
s + " ', '" +
CompanyIn + " ', '" +
ExtensionIn + " ', '" +
CommentsIn + " ', '" +
SalutationIn + " ', '" +
FirstNameIn + " ', '" +
LastNameIn + " ', '" +
AddressIn + " ', '" +
Line2In + " ', '" +
Line3In + " ', '" +
CityIn + " ', '" +
StateIn + " ', '" +
ZipcodeIn + " ', '" +
CountryIn + " ', '" +
EmailIn + " ', '" +
PhoneIn + " ', '" +
" ', '" +
MorningIn + " ', '" +
AfternoonIn + " ', '" +
FaxIn + " ', '" +
HarborsideHotelIn + " ', '" +
ReceptionIn + " ', '" +
AttendingDateIn + " ', '" +
PartyIn + " ', '" +
TrainingSessionIn + " ', '" +
RefresherIn + " ', '" +
TitleIn + " ')";
Statement statement =
jdbcConnect.createStatement();
int result = statement.executeUpdate( query );
if ( result == 1 ){
buf.append( "<big><br>Thank
you for registering for CCA's Insight 204 Symposium,"
);
buf.append( "<br>being held in Boston, MA.,
June 5-8, 2005." );
buf.append( "<br><br>Your Registration
ID is <b>" + s + "</b> <br>
<br>" );
buf.append( "<br>If you have any questions
or need to make changes, please contact Cheryl Hanlin
\n" );
buf.append( "<br>at (508) 270-6666, ext 567.
<br> <br>" );
buf.append( "<br>We look forward to seeing
you in Boston in June! </big>" );
buf.append( "<br><br><a href='http://www.cca-int.com'>Click
here to go to CCA's main page</a>");
emailReply(buf);
}
else {
session.invalidate();
// erase session
buf.append( "<br>Registration
Failed! \n" );
buf.append( "<br>Please
try again later, or Call CCA Support \n" );
}
}
catch ( SQLException
sqlex ) {
session.invalidate();
// erase session
buf.append( "<br>Registration
Failed! \n" );
buf.append( "<br>Please
try again later, or Call CCA Support \n" );
}
}
}
|
