📄 0084.htm
字号:
<html>
<head>
<title>新时代软件教程:操作系统 主页制作 服务器 设计软件 网络技术 编程语言 文字编辑</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
body, table {font-size: 9pt; font-family: 宋体}
a {text-decoration:none}
a:hover {color: red;text-decoration:underline}
.1 {background-color: rgb(245,245,245)}
-->
</style>
</head>
<p align="center"><script src="../../1.js"></script></a>
<p align="center"><big><strong>JSP中文留言簿</strong></big></p>
<div align="right">摘自互联网</div>
<p>
<html><br>
<head><br>
<title>My First Jsp GuestBook</title><br>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><br>
</head><br>
<body bgcolor="#CCCCFF" vlink="#000000" alink="#666666"><br>
<br>
<div align="center"><br>
<p><font size="7"><b><font size="+6">Jsp GuestBook</font></b></font></p><br>
<form method="post" action="index.jsp"><br>
<table width="75%" align="center" border=1><br>
<tr><br>
<td width="30%"><br>
<div align="right">Name:</div><br>
</td><br>
<td width="70%"><br>
<input type="text" name="name"><br>
</td><br>
</tr><br>
<tr><br>
<td width="30%"><br>
<div align="right">E-mail:</div><br>
</td><br>
<td width="70%"><br>
<input type="text" name="email"><br>
</td><br>
</tr><br>
<tr><br>
<td width="30%"><br>
<div align="right">Site Url:</div><br>
</td><br>
<td width="70%"><br>
<input type="text" name="url" value="http://"><br>
</td><br>
</tr><br>
<tr><br>
<td width="30%"><br>
<p>What do you want to</p><br>
<p>say?</p><br>
</td><br>
<td width="70%"><br>
<textarea name="body" rows="5" cols="30"></textarea><br>
</td><br>
</tr><br>
<tr><br>
<td width="30%"> </td><br>
<td width="70%"> </td><br>
</tr><br>
<tr><br>
<td width="30%"> </td><br>
<td width="70%"><br>
<table width="75%"><br>
<tr><br>
<td><br>
<input type="submit" name="send" value="Send" ><br>
</td><br>
<td><br>
<input type="reset" name="reset" value="Reset"><br>
</td><br>
</tr><br>
</table><br>
</td><br>
</tr><br>
</table><br>
</form><br>
<hr><br>
<%@ page contentType="text/html;charset=gb2312"%><br>
<%@ page language="java" import="java.sql.*"%><br>
<jsp:useBean id="sqlbean" scope="page" class="jsp.sql_data" /><br>
<%! String name,email,url,body,sql; %><br>
<%! int id; %><br>
<br>
<%<br>
name = null;<br>
name = request.getParameter("name");<br>
//name = new String(request.getParameter("name").getBytes("8859_1"));<br>
%><br>
<%= name%><br>
<%<br>
if (name != null&&name !="")<br>
{<br>
<br>
name = new String(request.getParameter("name").getBytes("8859_1"));<br>
email = new String(request.getParameter("email").getBytes("8859_1"));<br>
url = new String(request.getParameter("url").getBytes("8859_1"));<br>
body = new String(request.getParameter("body").getBytes("8859_1"));<br>
ResultSet RSet = sqlbean.executeQuery("SELECT * FROM guestbook");<br>
RSet.last();<br>
id = RSet.getRow()+1;<br>
RSet.close();<br>
sqlbean.sqlclose();<br>
sql = "insert into guestbook (Recordid,Name,Email,Url,Body) values('"+id+"','"+name+"','"+email+"','"+url+"','"+body+"')";<br>
sqlbean.executeQuery(sql); <br>
sqlbean.sqlclose();<br>
<br>
}else{<br>
out.print("<b><font color=red> Please enter your name,email and body!!!</font></b>");<br>
}<br>
%><br>
<p><font size="4"><b><a href="./index.jsp#see">See My Guestbook</a></b></font></p><br>
<p> </p><br>
<% <br>
ResultSet RS = sqlbean.executeQuery("SELECT * FROM guestbook ORDER BY RecordID DESC");<br>
<br>
while (RS.next()){<br>
name = new String(RS.getString("Name").getBytes("8859_1"));<br>
email = new String(RS.getString("Email").getBytes("8859_1"));<br>
url = new String(RS.getString("Url").getBytes("8859_1"));<br>
body = new String(RS.getString("Body").getBytes("8859_1"));<br>
%><br>
<table border=1 width=80%><br>
<tr><br>
<td width=30%>Name:</td><td width=70%><%= name %><br>
</tr><br>
<tr><br>
<td width=30%>Email:</td><td width=70%><a href="mailto:<%= email %>"><%= email %></a></td><br>
</tr><br>
<tr><br>
<td width=30%>SiteUrl:</td><td width=70%><a href="<%= url %>"><%= url %></a></td><br>
</tr><br>
<tr><br>
<td width=30%>Body:</td><td width=70%><%= body %></td><br>
</tr><br>
</table><br>
<hr><br>
<%<br>
}<br>
RS.close();<br>
sqlbean.sqlclose();<br>
<br>
%><br>
<br>
<br>
</div><br>
</body><br>
</html></p>
</table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -