站内搜索: 请输入搜索关键词

当前页面: 开发资料首页JSP 专题这是一个用jsp代码出现好多错误--编一个论坛的页面

这是一个用jsp代码出现好多错误--编一个论坛的页面

摘要: 这是一个用jsp代码出现好多错误--编一个论坛的页面



<head>
My First JSP GuestBook

</head>
<body bgcolor="#ccccFF" vlink="#000000" alink="#666666">


Jsp aguestBook

<form method="post" action="index1.jsp">
<table width="75%" align="center" border=1>
<tr>
<td width="30%">


</td>
<td width="70">
<input type="text" name="name">00000
</td>
</tr>
<tr>
<td width="30%">
E-mail:

</td>
<td width="70%">
<input type="text" name="email">
</td>
</tr>
<tr>
<td width="30%">
Site Url:

</td>
<td width="70%">
<input type="text" name="url" value="http://">
</td>
</tr>
<tr>
<td width="30%">

what do you want to


say?


</td>
<td width="70%">
<textarea name="body" rows="5" cols="30"></textarea>
</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td width="70%">&nbsp;</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>



<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java" import="java.sq1.*"%>

<%! String name,email,url,body,sq1; %>
<%! int id; %>

<%
name = null;
name = request.getparameter("name");
%>
<%
if (name != null&&name !=" ")
{
name = new String(request.getparamer("name").getBytes("8859_1"));
email = new Steing(request.getparamer("email").getBytes("8859_1"));
url = new String(request.getparamer("url").getBytes("8859_1"));
body=newSteing(request.getparamer("body").getBytes("8859_1"));sq1="insertintoguestbook(Name,Email,Url,Body)
values('"+name+"','"+email+"','"=url+"','"+body+"')";
sq1bean.executery(sq1);
sq1bean.sq1close();

}else{
out.print("Please enter your name,email and body!!!
");
}
%>

see My Guestbook


&nbsp;


<%
ResultSet RS = sq1bean.executeQuery("SELECT * FRM 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"));
uel =new String (RS.getString("Ual").getBytes("8859_1"));
body =new String (RS.getString("Body").getBytes("8859_1"));
%>
<table border=1>
<tr>
<td>Name:</td><td><%= name %>
</td>
</tr>
<tr>
<td>Email:</td><td>"><%= email %></td>
</tr>
<tr>
<td>SiteUrl;</td><td>"><%= url %></td>
</tr>
<tr>
<td>Body:</td><td><%= body %></td>
</tr>
</table>



<%
}
RS.close();
sq1bean.sq1close();

%>




</body>



↑返回目录
前一篇: Jsp 连接 mySQL、Oracle 数据库备忘(Windows平台)
后一篇: JSP数据库连接池的必要性