<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%
request.setCharacterEncoding("gb2312");
String name="";
String password="";
String sex="";
String age="0";
String phone="";
String email="";
String address="";
int id=10000;
//若username不為null，則將輸入信息存到變量name中
if(request.getParameter("name")!=null)
	name=request.getParameter("name");
if(request.getParameter("password")!=null)
	password=request.getParameter("password");
if(request.getParameter("sex")!=null)
	sex=request.getParameter("sex");
if((request.getParameter("age")!=null)&&!(request.getParameter("age").equals("")))
	age=request.getParameter("age");
if(request.getParameter("phone")!=null)
	phone=request.getParameter("phone");
if(request.getParameter("email")!=null)
	email=request.getParameter("email");
if(request.getParameter("address")!=null)
	address=request.getParameter("address");
	ResultSet rs=null;
	//讀取user表中id號最大的記錄的id地段值
	rs=conn.executeQuery("select max(id) from user");
	//若存在此記錄
	if(rs.next())
		//將最大的id值存儲在變量id中
		id=rs.getInt(1);
	//id自動增1
	id++;
	rs.close();
	//生成插入新記錄的SQL語句
	String sql="insert into user values("+id+",'"+name+"','"+password+"','"+sex+"',"+age+",'"+phone+"','"+email+"','"+address+"')";
	//執(zhí)行插入語句
	conn.executeUpdate(sql);
	out.println("恭喜您，注冊成功！<br>");
	out.println("<a href='login.htm'>返回登錄頁面</a>");
	conn.close();
%>