gform2.jsp

一个简短的留言簿

<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="db.ConnOracle"/>


<%!
ResultSet rs = null;
String sql = "";
String str = "";
%>

<%
request.setCharacterEncoding("GBK");
String name     = request.getParameter("name");
String sex      = request.getParameter("sex");
String email    = request.getParameter("email");
String homepage = request.getParameter("homepage");
String subject  = request.getParameter("subject");
String memo     = request.getParameter("content");

// 将英文转为中文显示
if(sex.equals("man"))
   sex = "男";
else
   sex = "女";

sql = "Insert Into gbook Values (";
sql += "'" +  name+ "', ";
sql += "'" + sex + "', ";
sql += "'" + email + "', ";
sql += "'" + homepage + "', ";
sql += "'" + subject  + "', ";
sql += "'" + memo     + "',sysdate)";
conn.update( sql );
response.sendRedirect("index2.jsp");		// 跳转到『留言观看』的页面
%>