|
![]() |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
<html> <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> 返回类别: 教程 上一教程: 处理表单数据 下一教程: 一个JAVABEAN轻松实现对数据库的各种操作 您可以阅读与"JSP中文留言簿"相关的教程: · 教您配置Web应用环境实现JSP留言簿开发 · 配置WEB应用环境实现JSP留言簿 · 深入剖析JSP和SERVLET对中文的处理 · JSP留言板源代码1 · 我的乱码之路??JSP与MySQL交互的中文乱码解决方案及总结 |
![]() ![]() |
快精灵印艺坊 版权所有 |
首页![]() ![]() ![]() ![]() ![]() ![]() ![]() |