KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > forum > Login


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 import java.util.*;
11
12 public class Login extends HttpServlet {
13
14         DBConnectie db = new DBConnectie(Variable.getDb(),Variable.getDbLogin(),Variable.getDbPassword());
15
16         public void doPost (HttpServletRequest request, HttpServletResponse response)
17         throws ServletException, IOException{
18             
19         PrintWriter out = response.getWriter();
20         
21                 try{
22                  
23                     String JavaDoc loginUser = request.getParameter("username");
24                     String JavaDoc loginPass = request.getParameter("password");
25                     
26                     db.connect();
27                     
28                     String JavaDoc password = "null";
29                     String JavaDoc password2 = "zero";
30                     String JavaDoc type = "null";
31                     
32                     ResultSet JavaDoc rs = db.selectQuery(
33                         "SELECT * "+
34                         "FROM forum_users "+
35                         "WHERE user_name =\"" + loginUser + "\"");
36                     while(rs.next()){
37                         password = rs.getString("password");
38                         type = rs.getString("type");
39                     }
40                     
41                     
42                     ResultSet JavaDoc rs2 = db.selectQuery(
43                         "SELECT "+
44                         "password(\""+ loginPass +"\") password");
45                     while(rs2.next()){
46                         password2 = rs2.getString("password");
47                     }
48
49                     
50                     if(password2.equals(password)){
51                         HttpSession session = request.getSession(true);
52                         
53                         //Cookie cookie = new Cookie("username",loginUser);
54 session.setAttribute("username",loginUser);
55                         //cookie.setMaxAge(60*60*24*365);
56 //cookie.setPath("/");
57 //response.addCookie(cookie);
58 //cookie = new Cookie("password",password);
59 session.setAttribute("password",password);
60                         //cookie.setMaxAge(60*60*24*365);
61 //cookie.setPath("/");
62 //response.addCookie(cookie);
63 //cookie = new Cookie("type",type);
64 session.setAttribute("type",type);
65                         //cookie.setMaxAge(60*60*24*365);
66 //cookie.setPath("/");
67 //response.addCookie(cookie);
68
69                         response.sendRedirect(Variable.getForumPath() + "index.jsp");
70                     }else{
71                         response.sendRedirect(Variable.getForumPath() + "info.jsp?action=wrongpass");
72                     }
73                     
74                     
75                     db.close();
76                     
77                 }catch(Exception JavaDoc e){out.println(e);}
78                 
79              
80         }
81         public void doGet (HttpServletRequest request, HttpServletResponse response)
82         throws ServletException, IOException{
83                 doPost(request, response);
84         }
85
86 }
Popular Tags