1 package forum; 2 3 import java.io.*; 4 import javax.servlet.*; 5 import javax.servlet.http.*; 6 import java.sql.*; 7 import java.sql.Connection ; 8 import java.sql.Statement ; 9 import java.sql.ResultSet ; 10 11 public class AddUser extends HttpServlet { 12 13 DBConnectie db = new DBConnectie(Variable.getDb(),Variable.getDbLogin(),Variable.getDbPassword()); 14 15 public void doPost (HttpServletRequest request, HttpServletResponse response) 16 throws ServletException, IOException{ 17 PrintWriter out = response.getWriter(); 18 try{ 19 24 String RegUser = request.getParameter("user"); 25 String RegEmail = request.getParameter("email"); 26 String RegPass = request.getParameter("password"); 27 String RegPass2 = request.getParameter("password2"); 28 29 db.connect(); 30 ResultSet rs = db.selectQuery( 31 "SELECT * "+ 32 "FROM forum_users "+ 33 "WHERE user_name=\""+ RegUser + "\""); 34 35 String DBUsername = null; 36 while(rs.next()){ 37 DBUsername = rs.getString("user_name"); 38 } 39 40 if(DBUsername == null){ 41 42 if(RegPass.equals(RegPass2)){ 43 44 db.query( 45 "INSERT INTO "+ 46 "forum_users(user_name,password,email,registerdate,type) "+ 47 "VALUES(\""+ RegUser + "\",password(\"" + RegPass +"\"),\""+ RegEmail + "\",\"SYSDATE()\",\"user\")"); 48 db.close(); 49 response.sendRedirect(Variable.getForumPath() + "info.jsp?action=regcomplete"); 50 }else{ 51 response.sendRedirect(Variable.getForumPath() + "info.jsp?action=wrongpass"); 52 } 53 }else{ 54 response.sendRedirect(Variable.getForumPath() + "info.jsp?action=userexists"); 55 } 56 }catch(Exception e){out.println(e);} 57 58 59 } 60 public void doGet (HttpServletRequest request, HttpServletResponse response) 61 throws ServletException, IOException{ 62 doPost(request, response); 63 } 64 65 } | Popular Tags |