import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class InfoServlet extends HttpServlet {
private String userName;
private String userPassword;
private static final String dbDriverName =
"sun.jdbc.odbc.JdbcOdbcDriver";
private static final String dbURL =
"jdbc:odbc:MembersOnly";
private Connection dbConnection;
private void connectToDatabase() {
try {
Class.forName (dbDriverName);
dbConnection = DriverManager.getConnection(
dbURL,
userName, userPassword);
dbConnection.setAutoCommit(false);
}
catch(Exception e) {
System.out.println("InfoServlet - failed to connect to database");
System.out.println(e.toString());
}
}
public void init() {
// System.out.println("Infoservlet initializing");
userName = getInitParameter("User");
userPassword = getInitParameter("Password");
connectToDatabase();
// System.out.println("Infoservlet initialized");
}
public void destroy() {
if(dbConnection != null) {
try {
dbConnection.close();
} catch(Exception e) { }
}
}
private void sendRetryResponse( HttpServletResponse response,
SubscriberRecord aRecord ) throws ServletException, IOException
{
String tempStr = null;
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("" +
"Please re-enter data" );
out.println("You need to resubmit your form
");
out.println("Some of the data that you sent was incomplete or invalid");
out.println("
");
if(aRecord.getGivenName() == null)
out.println("You didn't supply your 'Given name'");
if(aRecord.getFamilyName() == null)
out.println("You didn't supply your 'Family name'");
if(aRecord.getEMail() == null)
out.println("You didn't supply an 'eMail'");
if(aRecord.getSex() == null)
out.println("You didn't supply your gender");
if(aRecord.getAge() == 0) {
out.println("Either you did not supply your age or");
out.println(" the value you entered was outside our limits");
}
out.println("
");
out.println("