Untitled

<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.sql.*"%>

<html>
<body>

<%
String m_strUserID= request.getParameter("UserID");
String m_strPWD= request.getParameter("Password");
String m_strPWD2= request.getParameter("Password2");
String m_strName= request.getParameter("Name");
String m_strTel= request.getParameter("Tel");
String m_strEmail= request.getParameter("Email");

String m_str="";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;

boolean insertMark= true;

try{

   Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   String url ="jdbc:mysql://localhost/member";
   conn= DriverManager.getConnection(url,"root","");
   stmt=conn.createStatement();
   String sql="select * from member where userid='"+m_strUserID+"'";
   rs=stmt.executeQuery(sql);
   if(rs.next()){
      m_str= "此帳號 "+m_strUserID+ " 已有人申請過了，請按上一頁重新申請。<br>";
      insertMark=false;
   }
   rs.close();
   sql="select * from member where email='"+m_strEmail+"'";
   rs=stmt.executeQuery(sql);

   if(rs.next()){
      m_str+= "此 Email信箱 "+m_strEmail+ " 已有人申請過了，請按上一頁重新申請。<br>";
      insertMark=false;
   }

   if(!m_strPWD.equals(m_strPWD2)){
      m_str+= "您前後兩次輸入的密碼不相同，請按上一頁重新申請。";
      insertMark=false;
   }

   if(insertMark){
      sql="Insert into member(userid,password,name,tel,email)  values('"+m_strUserID+"','"+m_strPWD+"','"+m_strName+"','"+m_strTel+"','"+m_strEmail+"')";
      if (rs != null)   rs.close();
      if (stmt != null) stmt.close();
      stmt = conn.createStatement();
      stmt.executeUpdate(sql);

      m_str="註冊完畢。";
   }
}

catch (ClassNotFoundException e1) {
   m_str="資料庫驅動失敗，請通知網站管理員: "+"<br>" + e1.getMessage();
}

catch (SQLException e2) {
   m_str="SQL指令錯誤，請參考以下訊息:" +"<br>"+ e2.getMessage();
}

finally {
  try {
     if (rs != null)    rs.close();
     if (stmt != null)  stmt.close();
     if (conn != null)  conn.close();
  }
  catch (SQLException ignored) {}
}

%>

<%= m_str%>

</body>
</html>