10.5　 项目设计

在输入用户资料后，单击【注册】按钮后，将转入到该文件。同时将注册新会员页面中用户资料提出，并将该资料输入到数据库的用户信息数据表中。

程序清单：regok.jsp

<%@ include file="inc/format.jsp"%>

<%@ include file="inc/bytes.jsp"%>

<%

String u_name,u_pass,u_adds,u_tel,u_namec,u_postcode,u_email,u_faq,u_an,u_card,u_chkfaq;

u_name=request.getParameter("user_name");

u_pass=request.getParameter("user_pass");

u_adds=Bytes(request.getParameter("user_adds"));

u_tel=request.getParameter("user_tel");

u_namec=Bytes(request.getParameter("user_namec"));

u_card=request.getParameter("user_card");

u_postcode=request.getParameter("user_postcode");

u_email=request.getParameter("user_email");

u_faq=Bytes(request.getParameter("user_faq"));

u_an=request.getParameter("user_an");

u_chkfaq=request.getParameter("user_chkfaq");

　Statement rgstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

sql="insert into member (user_name,user_pass,user_adds,user_tel,user_namec,user_card,user_postcode,user_email,user_faq,user_an) values ('"+u_name+"','"+u_pass+"','"+u_adds+"','"+u_tel+"','"+u_namec+"','"+u_card+"','"+u_postcode+"','"+u_email+"','"+u_faq+"','"+u_an+"')";

sql=Bytes(sql);

sql=format(sql);

rgstmt.executeUpdate(sql);

rgstmt.close();

out.print("<script>alert('用户注册成功，现在就可返回主页或登录查询更多内容。');</script>");

%>