<meta http-equiv="refresh" content="1;url=default.htm">
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>

<jsp:useBean id="j" scope="application" class="jdbc.jdbc"/>
<jsp:useBean id="m" scope="application" class="MD5.MD5"/>

<%
String user_name=new String(request.getParameter("name").getBytes("ISO8859_1"), "GBK");
String user_key=new String(request.getParameter("key").getBytes("ISO8859_1"), "GBK");
String key_confirm=new String(request.getParameter("key_confirm").getBytes("ISO8859_1"), "GBK");
String user_enterprise_name=new String(request.getParameter("enterprise").getBytes("ISO8859_1"), "GBK");
String s="0";
int count=0;
user_key=m.getMD5ofStr(user_key);
try{
Connection con=j.getConnection();

Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String checksql="select user_name from user_info where user_name='"+user_name+"'";

ResultSet r=statement.executeQuery(checksql);

while(r.next())
{
 count++;
}

if(count!=0)
{
out.print("對不起，該用戶名以存在！請重新注冊！");
}
else
{
String upsql="insert into user_info (user_name,user_key,user_enterprise_name,s) values ('"+user_name+"','"+user_key+"','"+user_enterprise_name+"','"+s+"')";


statement.executeUpdate(upsql);

}
j.releaseConnection(con);

out.print("注冊成功！");
}


catch(SQLException ee){out.print("對不起！和以注冊企業名稱重復");}

%>