<head>
<title>my first jsp guestbook</title>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#ccccff" vlink="#000000" alink="#666666">
<div align="center">
<p><font size="7"><b><font size="+6">jsp guestbook</font></b></font></p>
<form method="post" action="index.jsp">
<table width="75%" align="center" border=1>
<tr>
<td width="30%">
<div align="right">name:</div>
</td>
<td width="70%">
<input type="text" name="name">
</td>
</tr>
<tr>
<td width="30%">
<div align="right">e-mail:</div>
</td>
<td width="70%">
<input type="text" name="email">
</td>
</tr>
<tr>
<td width="30%">
<div align="right">site url:</div>
</td>
<td width="70%">
<input type="text" name="url" value="http://">
</td>
</tr>
<tr>
<td width="30%">
<p>what do you want to</p>
<p>say?</p>
</td>
<td width="70%">
<textarea name="body" rows="5" cols="30"></textarea>
</td>
</tr>
<tr>
<td width="30%"> </td>
<td width="70%"> </td>
</tr>
<tr>
<td width="30%"> </td>
<td width="70%">
<table width="75%">
<tr>
<td>
<input type="submit" name="send" value="send" >
</td>
<td>
<input type="reset" name="reset" value="reset">
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<hr>
<%@ page contenttype="text/html;charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<jsp:usebean id="sqlbean" scope="page" class="jsp.sql_data" />
<%! string name,email,url,body,sql; %>
<%! int id; %>
<%
name = null;
name = request.getparameter("name");
//name = new string(request.getparameter("name").getbytes("8859_1"));
%>
<%= name%>
<%
if (name != null&&name !="")
{
name = new string(request.getparameter("name").getbytes("8859_1"));
email = new string(request.getparameter("email").getbytes("8859_1"));
url = new string(request.getparameter("url").getbytes("8859_1"));
body = new string(request.getparameter("body").getbytes("8859_1"));
resultset rset = sqlbean.executequery("select * from guestbook");
rset.last();
id = rset.getrow()+1;
rset.close();
sqlbean.sqlclose();
sql = "insert into guestbook (recordid,name,email,url,body) values("+id+","+name+","+email+","+url+","+body+")";
sqlbean.executequery(sql);
sqlbean.sqlclose();
}else{
out.print("<b><font color=red> please enter your name,email and body!!!</font></b>");
}
%>
<p><font size="4"><b><a href="./index.jsp#see">see my guestbook</a></b></font></p>
<p> </p>
<%
resultset rs = sqlbean.executequery("select * from guestbook order by recordid desc");
while (rs.next()){
name = new string(rs.getstring("name").getbytes("8859_1"));
email = new string(rs.getstring("email").getbytes("8859_1"));
url = new string(rs.getstring("url").getbytes("8859_1"));
body = new string(rs.getstring("body").getbytes("8859_1"));
%>
<table border=1 width=80%>
<tr>
<td width=30%>name:</td><td width=70%><%= name %>
</tr>
<tr>
<td width=30%>email:</td><td width=70%><a href="mailto:<%= email %>"><%= email %></a></td>
</tr>
<tr>
<td width=30%>siteurl:</td><td width=70%><a href="<%= url %>"><%= url %></a></td>
</tr>
<tr>
<td width=30%>body:</td><td width=70%><%= body %></td>
</tr>
</table>
<hr>
<%
}
rs.close();
sqlbean.sqlclose();
%>
</div>
</body>
</html>
文章整理：站长天空 网址：http://www.z6688.com/
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!
