Jsp GuestBook

<%@ page contentType="text/html;charset=gb2312"%>

<%@ page language="java" import="java.sql.*"%>

<%! 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(" Please enter your name,email and body!!!");

}

%>

See My Guestbook

<%

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"));

%>

Name:	<%= name %>
Email:	<%= email %>
SiteUrl:	<%= url %>
Body:	<%= body %>

<%

}

RS.close();

sqlbean.sqlclose();

%>