<%@page contentType="text/html; charset=gb2312"%>
<%@page language="java" import="java.sql.*"%>

<jsp:useBean id="workM" scope="page" class="test.faq" type="test.faq"/>

<%!
  public String getStr(String str)
  {
	   try 
	  {
		   String temp_p=str;
		   byte[] temp_t=temp_p.getBytes("GBK");
		   String temp = new String(temp_t,"ISO8859_1");
		   return temp;
	  }
	  catch(Exception e)
	  {
		  e.printStackTrace();
	  }
	  return "null";
  }
%>
<%!
   String logname,  password;

%>
<%
	 logname=request.getParameter("loginname");    
	 password=request.getParameter("password");	
 
 %>
 <%
    String sql="select autoid from userinfo where loginname='"+logname+"'";
	ResultSet rs=workM.executeQuery(sql);
	out.println(sql);
	int rowscount=0;
	try
	{
		while(rs.next())
		{
			rowscount++;
		}
	}
	catch(Exception e){
		e.printStackTrace();
	}
	if(rowscount==0)
	{
		String sqlinsert;
		sqlinsert="insert into userinfo(loginname,password) Values('"+logname+"','"+password+"')";
		workM.executeQuery(sqlinsert);
		response.sendRedirect("reg_success.jsp");
	}
	else {
	%>
	  <table width="50%" align=center>
	  <tr><td bgColor=#3399ff>用戶名已經存在，請重新注冊！<a href="index.jsp">返回</a></td><tr>
	  </table>
	<%
	}
	%>