<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="sqlbean" scope="session" class="org.zhengmao.soft.sqlcon" />
<jsp:useBean id="mychar" scope="session" class="org.zhengmao.soft.gb_unicode" />
<script language=javascript src="mouse.js"></script>

<%
String name		= sqlbean.to_8859_1(request.getParameter("name"));
String password	= sqlbean.to_8859_1(request.getParameter("password"));
String username	= sqlbean.to_8859_1(request.getParameter("username"));
String question	= sqlbean.to_8859_1(request.getParameter("question"));
String answer	= sqlbean.to_8859_1(request.getParameter("answer"));
String email	= sqlbean.to_8859_1(request.getParameter("email"));
String mobile	= sqlbean.to_8859_1(request.getParameter("mobile"));
String tel		= sqlbean.to_8859_1(request.getParameter("tel"));
String depart	= sqlbean.to_8859_1(request.getParameter("company"));
String ip		= request.getRemoteAddr();
String pagesize	= request.getParameter("pagesize");
//request.getParameter("admin")

Calendar now = Calendar.getInstance();
String sj = now.get(Calendar.YEAR)+"-"+(now.get(Calendar.MONTH)+1)+"-"+now.get(Calendar.DAY_OF_MONTH)+" "+now.get(Calendar.HOUR_OF_DAY)+":"+now.get(Calendar.MINUTE)+":"+now.get(Calendar.SECOND);
String sql = "select * from myuser where username='"+ username +"' or name='"+ name +"'";
sqlbean.executeQuery(sql);
if(sqlbean.next()){
	out.println(sqlbean.showMsg("javascript:history.back()","賬戶已經存在！請重新選擇名稱！","注冊提示"));
}else{
	
	sql ="insert into myuser(username,pwd,email,part,wenti,daang,time,IP,phone,name,mobile,pagesize) values('"
		+ username + "','"
		+ password + "','"
		+ email + "','"
		+ depart + "','"
		+ question + "','"
		+ answer + "','"
		+ sj + "','"
		+ ip + "','"
		+ tel + "','"
		+ name + "','"
		+ mobile + "','"
		+ pagesize + "')";
	sqlbean.executeUpdate(sql);
	//out.println(sql);
	
	sql ="select ID from myuser where username=\""+username+"\"";
	sqlbean.executeQuery(sql);
	if(sqlbean.next()){
		sql ="insert into userinfo(userid,Uname,email,phone,mobile,Ltime) values('"
			+ sqlbean.getString("ID") + "','"
			+ username + "','"
			+ email + "','"
			+ tel + "','"
			+ mobile + "','"
			+ sj +"')";
		sqlbean.executeUpdate(sql);
	}	
	
//	
	out.println(sqlbean.showMsg("javascript:window.close()","您已經成功申請帳戶，等待管理員批準以后就可以登陸了!","系統提示"));		
	//out.println(sql);
}
sqlbean.close();
%>