KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > forum > AddUser


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 JavaDoc;
8 import java.sql.Statement JavaDoc;
9 import java.sql.ResultSet JavaDoc;
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                     //Cookie[] cookies = request.getCookies();
20
//String username = Cookies.getCookies(cookies,"username","null");
21
//String password = Cookies.getCookies(cookies,"password","null");
22
//String type = Cookies.getCookies(cookies,"type","null");
23

24                     String JavaDoc RegUser = request.getParameter("user");
25                     String JavaDoc RegEmail = request.getParameter("email");
26                     String JavaDoc RegPass = request.getParameter("password");
27                     String JavaDoc RegPass2 = request.getParameter("password2");
28                                         
29                     db.connect();
30                     ResultSet JavaDoc rs = db.selectQuery(
31                         "SELECT * "+
32                         "FROM forum_users "+
33                         "WHERE user_name=\""+ RegUser + "\"");
34                         
35                     String JavaDoc 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 JavaDoc 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