<! -- Add_message.jsp -->
<% @ Page import = "java. SQL. *" %>
<HTML>
<HEAD>
<TITLE> add message into table </TITLE>
</HEAD>
<BODY>
<%
String name = request. getParameter ("name ");
String mail = request. getParameter ("mail ");
String title = request. getParameter ("title ");
String content = request. getParameter ("content ");
If (name = null)
Name = "";
If (title = null)
Title = "";
If (content = null)
Content = "";
If (mail = null)
Mail = "";
If (name. length () = 0)
Out. println ("the contact name cannot be blank! ");
Else if (title. length () = 0)
Out. println ("The message subject cannot be blank! ");
Else if (content. Length () = 0)
Out. println ("The message content cannot be blank! ");
Else
{
Java. util. Date = new java. util. Date ();
String datetime = new timestamp (date. gettime (). tostring ();
Try
{
Class. forname ("Sun. JDBC. ODBC. jdbcodbcdriver ");
String url = "JDBC: ODBC: user_db ";
Connection con = drivermanager. getconnection (URL, "insher", "insher ");
Preparedstatement STM = con. preparestatement ("insert into message values (?,?,?,?,?) ");
STM. setstring (1, title );
STM. setstring (2, name );
If (mail. Length () = 0)
STM. setstring (3, null );
Else STM. setstring (3, mail );
STM. setstring (4, datetime );
STM. setstring (5, content );
Try
{
Cmd.exe cutequery ();
} Catch (exception E)
{}
Con. Close ();
}
Catch (exception E)
{}
%>
<JSP: Forward page = "view_message.jsp"/>
<%
}
%>
</Body>
</Html>
<! -- Add_message.jsp --
<% @ Page import = "Java. SQL. *" %>
<HTML>
<Head>
<Title> Add message into Table </title>
</Head>
<Body>
<%
String name = request. getparameter ("name ");
String mail = request. getparameter ("mail ");
String title = request. getparameter ("title ");
String content = request. getparameter ("content ");
If (name = NULL)
Name = "";
If (title = null)
Title = "";
If (content = null)
Content = "";
If (mail = null)
Mail = "";
If (name. length () = 0)
Out. println ("the contact name cannot be blank! ");
Else if (title. length () = 0)
Out. println ("The message subject cannot be blank! ");
Else if (content. length () = 0)
Out. println ("The message content cannot be blank! ");
Else
{
Java. util. Date date = new java. util. Date ();
String datetime = new Timestamp (date. getTime (). toString ();
Try
{
Class. forName ("sun. jdbc. odbc. JdbcOdbcDriver ");
String url = "jdbc: odbc: user_db ";
Connection con = DriverManager. getConnection (url, "insher", "insher ");
PreparedStatement stm = con. prepareStatement ("insert into message values (?,?,?,?,?) ");
Stm. setString (1, title );
Stm. setString (2, name );
If (mail. length () = 0)
Stm. setString (3, null );
Else stm. setString (3, mail );
Stm. setString (4, datetime );
Stm. setString (5, content );
Try
{
Cmd.exe cuteQuery ();
} Catch (Exception e)
{}
Con. close ();
}
Catch (Exception e)
{}
%>
<Jsp: forward page = "view_message.jsp"/>
<%
}
%>
</Body>
</Html>
<! -- Index.html -->
<HTML>
<HEAD>
<TITLE> message board </TITLE>
</HEAD>
<BODY>
<TABLE width = "90%" align = "center" border = 1 cellspacing = "0" cellpadding = "0" bordercolordark = "# 88a6dd" bordercolorlight = "# 88a6dd">
<TR>
<TD align = "center" bgcolor = "# 88a6dd"> guest message board </TD>
</TR>
<TR>
<TD> <TABLE align = "center" border = 1 cellspacing = "0" cellpadding = "0" bordercolordark = "# 88a6dd" bordercolorlight = "# 88a6dd">
<Form action = "add_message.jsp">
<TR>
<TD> name: </TD>
<TD bgcolor = "# 88a6dd"> <input type = "text" name = "name" size = 25> </TD>
</TR>
<TR>
<TD bgcolor = "# 88a6dd"> Email: </TD>
<TD bgcolor = "# 88a6dd"> <input type = "text" name = "mail" size = 25> </TD>
</TR>
<TR>
<TD> topic: </TD>
<TD bgcolor = "# 88a6dd"> <input type = "text" name = "title" size = 25> </TD>
</TR>
<TR>
<TD valign = "top" bgcolor = "# 88a6dd"> message: </TD>
<TD> <textarea name = "content" rows = 7 cols = 25> </textarea> </TD>
</TR>
<TR>
<TD colspan = 3> <TABLE align = "center" width = "100%" cellspacing = "0" cellpadding = "0" bordercolordark = "# 88a6dd" bordercolorlight = "# 88a6dd">
<TR>
<TD align = "center" bgcolor = "# 88a6dd"> <input type = "submit" value = "submit message"> </TD>
<TD align = "center"> <a href = "view_message.jsp"> <font size = 2> View comments </font> </a> </TD>
<TD align = "center" bgcolor = "# 88a6dd"> <input type = "reset" value = "Refill"> </TD>
</TR>
</TABLE> </TD>
</TR>
</FORM>
</TABLE> </TD>
</TR>
</TABLE>
</BODY>
</HTML>
<HTML>
<HEAD>
<TITLE> message board </TITLE>
</HEAD>
<BODY>
<TABLE width = "60%" align = "center" border = 1 cellspacing = "0" cellpadding = "0" bordercolordark = "# 88a6dd" bordercolorlight = "# 88a6dd">
<TR>
<TD align = "center" bgcolor = "# 88a6dd"> guest message board </TD>
</TR>
<TR>
<TD> <TABLE align = "center" border = 1 cellspacing = "0" cellpadding = "0" bordercolordark = "# 88a6dd" bordercolorlight = "# 88a6dd">
<Form action = "add_message.jsp">
<TR>
<TD> name: </TD>
<TD bgcolor = "# 88a6dd"> <input type = "text" name = "name" size = 25> </TD>
</TR>
<TR>
<TD bgcolor = "# 88a6dd"> Email: </TD>
<TD bgcolor = "# 88a6dd"> <input type = "text" name = "mail" size = 25> </TD>
</TR>
<TR>
<TD> topic: </TD>
<TD bgcolor = "# 88a6dd"> <input type = "text" name = "title" size = 25> </TD>
</TR>
<TR>
<TD valign = "top" bgcolor = "# 88a6dd"> message: </TD>
<TD> <textarea name = "content" rows = 7 cols = 25> </textarea> </TD>
</TR>
<TR>
<TD colspan = 3> <TABLE align = "center" width = "100%" cellspacing = "0" cellpadding = "0" bordercolordark = "# 88a6dd" bordercolorlight = "# 88a6dd">
<TR>
<TD align = "center" bgcolor = "# 88a6dd"> <input type = "submit" value = "submit message"> </TD>
<TD align = "center"> <a href = "view_message.jsp"> <font size = 2> View comments </font> </a> </TD>
<TD align = "center" bgcolor = "# 88a6dd"> <input type = "reset" value = "Refill"> </TD>
</TR>
</TABLE> </TD>
</TR>
</FORM>
</TABLE> </TD>
</TR>
</TABLE>
</BODY>
</HTML>
<! -- View_message.jsp -->
<% @ Page import = "java. SQL. *" %>
<HTML>
<Head>
<Title> show the message in the table </title>
</Head>
<Body>
<P align = "center"> all guest messages </P>
<HR>
<%
Try
{
Class. forname ("Sun. JDBC. ODBC. jdbcodbcdriver ");
String url = "JDBC: ODBC: user_db ";
Connection con = drivermanager. getconnection (URL, "insher", "insher ");
Statement STM = con. createstatement ();
Resultset result=cmd.exe cutequery ("select count (*) from message ");
Int message_count = 0;
If (result. Next ())
{
Message_count = result. getint (1 );
Result. Close ();
}
If (message_count> 0)
{
Result=stm.exe cuteQuery ("select * from message order by time desc ");
While (result. next ())
{
String title = result. getString ("title ");
String name = result. getString ("name ");
String mail = result. getString ("mail ");
Timestamp time = result. getTimestamp ("time ");
Date date_time = new Date (time. getTime ());
Time time_time = new Time (time. getTime ());
String content = result. getString ("content ");
%>
<TABLE width = "100%" align = "center" border = 1 cellspacing = "0" cellpadding = "0" bordercolordark = "#000000" bordercolorlight = "# 88a6dd">
<Tr> <td bgcolor = "# 88a6dd"> <font size = 2> subject: </font> </td>
<Td colspan = 3> <% = title %> </td> </tr>
<Tr> <td bgcolor = "# 88a6dd"> <font size = 2> contact: </font> </td>
<Td> <% = name %> </td> <td bgcolor = "# 88a6dd"> <font size = 2> Email: </font> </td>
<Td>
<%
Out. println ("<a href = mailto:" + mail + ">" + mail + "</a> ");
%>
</Td> </tr>
<Tr> <td bgcolor = "# 88a6dd"> <font size = 2> message time: </font> </td> <td colspan = 3>
<%
Out. println ("<font size = 2>" + date_time + "" + time_time + "</font> ");
%>
</Td> </tr>
<Tr> <td align = "center">
<%
Out. println ("(" + message_count + ")");
%>
</Td>
<Td colspan = 3> <% = content %>
</TD> </tr>
</Table>
<%
Out. println ("<HR> ");
Message_count --;
}
Result. Close ();
Con. Close ();
}
Else
{
Out. println ("no message left! ");
Con. Close ();
}
} Catch (exception E)
{Out. println (E );}
%>
<P align = "center"> <a href = "../message/index.html"> Leave a message </a> </P>
</Body>
</Html>
<! -- View_message.jsp -->
<% @ Page import = "Java. SQL. *" %>
<HTML>
<Head>
<Title> show the message in the table </title>
</Head>
<BODY>
<P align = "center"> all guest messages </p>
<Hr>
<%
Try
{
Class. forName ("sun. jdbc. odbc. JdbcOdbcDriver ");
String url = "jdbc: odbc: user_db ";
Connection con = DriverManager. getConnection (url, "insher", "insher ");
Statement stm = con. createStatement ();
ResultSet result=cmd.exe cuteQuery ("select count (*) from message ");
Int message_count = 0;
If (result. next ())
{
Message_count = result. getInt (1 );
Result. close ();
}
If (message_count> 0)
{
Result=stm.exe cuteQuery ("select * from message order by time desc ");
While (result. next ())
{
String title = result. getString ("title ");
String name = result. getString ("name ");
String mail = result. getString ("mail ");
Timestamp time = result. getTimestamp ("time ");
Date date_time = new Date (time. getTime ());
Time time_time = new Time (time. getTime ());
String content = result. getString ("content ");
%>
<TABLE width = "100%" align = "center" border = 1 cellspacing = "0" cellpadding = "0" bordercolordark = "#000000" bordercolorlight = "# 88a6dd">
<Tr> <td bgcolor = "# 88a6dd"> <font size = 2> subject: </font> </td>
<Td colspan = 3> <% = title %> </td> </tr>
<Tr> <td bgcolor = "# 88a6dd"> <font size = 2> contact: </font> </td>
<Td> <% = name %> </td> <td bgcolor = "# 88a6dd"> <font size = 2> Email: </font> </td>
<Td>
<%
Out. println ("<a href = mailto:" + mail + ">" + mail + "</a> ");
%>
</Td> </tr>
<Tr> <td bgcolor = "# 88a6dd"> <font size = 2> message time: </font> </td> <td colspan = 3>
<%
Out. println ("<font size = 2>" + date_time + time_time + "</font> ");
%>
</Td> </tr>
<Tr> <td align = "center">
<%
Out. println ("(" + message_count + ")");
%>
</Td>
<Td colspan = 3> <% = content %>
</Td> </tr>
</Table>
<%
Out. println ("Message_count --;
}
Result. close ();
Con. close ();
}
Else
{
Out. println ("no message left! ");
Con. Close ();
}
} Catch (exception E)
{Out. println (E );}
%>
<P align = "center"> <a href = "../message/index.html"> Leave a message </a> </P>
</Body>
</Html>