<%
// Written by Brad Simonin.
// This Java Server Page reads in information from an HTML Form and then
// loads the data into an Access 97 database using the JDBC:ODBC Bridge.
%>
<%@ page language="java" import="java.sql.*,java.io.*, java.util.*,BradsJavaPackages.GuestBook" %>
<% response.setContentType("text/html"); %>
<%
String userAgent = request.getHeader("User-Agent");
String UserName = request.getRemoteUser();
String IPAddress = request.getRemoteAddr();
if (IPAddress.equals(""))
IPAddress = null;
else
IPAddress = "'" + IPAddress + "'";
String AuthorizationType = request.getAuthType();
String SqlString = null;
String MyCookie = null;
Cookie[] cookies = request.getCookies();
if (cookies != null)
{
for (int i = 0; i < cookies.length; i++)
{
if (cookies[i].getName().equals("MyCookie"))
{
MyCookie = cookies[i].getValue();
break;
}
}
}
if (MyCookie == null)
{
Cookie c = new Cookie("MyCookie","BradSimonin");
response.addCookie(c);
}
%>
Brad Simonin's GuestBook Processor
<%
GuestBook AppletData = new GuestBook();
Enumeration PostData = request.getParameterNames();
while (PostData.hasMoreElements())
{
String PostDataCheck = (String)PostData.nextElement();
PostDataCheck.trim();
String PostDataValue = request.getParameter(PostDataCheck);
if (PostDataCheck.equals("strName"))
{
AppletData.setName(request.getParameter("strName"));
}
if (PostDataCheck.equals("strEmail"))
{
AppletData.setEmail(request.getParameter("strEmail"));
}
if (PostDataCheck.equals("strWebSite"))
{
AppletData.setWebPage(request.getParameter("strWebSite"));
}
if (PostDataCheck.equals("strCompanyOccupation"))
{
AppletData.setOccupation(request.getParameter("strCompanyOccupation"));
}
if (PostDataCheck.equals("strCity"))
{
AppletData.setCity(request.getParameter("strCity"));
}
if (PostDataCheck.equals("strState"))
{
AppletData.setState( request.getParameter("strState"));
}
if (PostDataCheck.equals("strComment"))
{
AppletData.setComments( request.getParameter("strComment"));
}
} // end while loop
PostData = null;
SqlString = "INSERT INTO Brads_GuestBook " +
"(Name, Company_Occupation, City, State, E_Mail, Web_Page, " +
"Comments, Users_IP_Address, Time_Stamp, Type) " +
"VALUES (" + AppletData.getName() + ", " + AppletData.getOccupation() +
", " + AppletData.getCity() + ", " + AppletData.getState() +
", " + AppletData.getEmail() + ", " + AppletData.getWebPage() +
", " + AppletData.getComments() + ", " + IPAddress + ", Now(), " +
"'JSP')";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Brad2000"; // Brad is the name of my ODBC DSN
Connection con;
Statement stmt;
con = DriverManager.getConnection(url);
stmt = con.createStatement();
stmt.executeUpdate(SqlString);
stmt.close();
con.close();
}
catch(SQLException SQL_ex)
{
out.println("SQLException: " + SQL_ex.getMessage());
}
catch(ClassNotFoundException Class_ex)
{
out.println("ClassException: " + Class_ex.getMessage());
}
%>
Thank You <%= AppletData.getDisplayName() %> for signing my Guest Book.
Cookie was: <%= MyCookie %>
Or to view the source code of this JavaServer Page click on the
following hyperlink: LoadBradsGuestBook.jsp