loginaccess.java

airline reservation system is a simple jsp application through which users can reserve tickets onlin

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package com.foreapps.common.user;

import com.foreapps.common.Connector;
import com.foreapps.common.InputManager;
import com.foreapps.common.PasswordService;
import com.foreapps.common.Utility;
import com.foreapps.session.SessionManager;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 *
 * @author sailen.kumar
 */
public class LoginAccess {
    private String losgSql=" Select count(*) from usermaster where userid=? and password=?";
    private String losgUserData= " Select m.nickname ,d.lastname,d.firstname,d.emailid,d.dob,d.gender,d.city,d.state,d.country,d.area,d.address,d.landmark,m.type from usermaster m,userdetails d where m.userid = d.userid and m.userid=? ";
    
    public boolean validateUser(String userId,String password) throws PasswordService.EncryptionException,SQLException {
        boolean isloginsuccess=false;
        PasswordService ps =new PasswordService();
        Connector con=new Connector();
        Utility objUtl=new Utility(); 
        con.Connect();
        con.setStatement(losgSql);
        con.setString(1,userId);
        
        
        con.setString(2,ps.encrypt(password));
        
        ResultSet rs=con.execute();
        while(rs.next()){
            int usercnt=rs.getInt(1);
            if(usercnt==1) isloginsuccess=true;
        }
        con.closeStatement();
        con.close();
        
        return isloginsuccess;
    }
 
  public void setUserSessionData(InputManager objInp,String userid)throws SQLException{
        Connector con=new Connector();
        Utility objUtl=new Utility(); 
        con.Connect();
             
            con.setStatement(losgUserData);
            con.setString(1,userid);
            System.out.println(losgUserData);
            ResultSet userRs=con.execute();
            while(userRs.next()){
                System.out.println(objUtl.trim(userRs.getString(1)));
                String userNickName = objUtl.trim(userRs.getString(1));
                String userLastName  = objUtl.trim(userRs.getString(2));
                String userFirstName = objUtl.trim(userRs.getString(3));
                String userEmailId = objUtl.trim(userRs.getString(4));
                String userDob = objUtl.trim(userRs.getString(5));
                String userGender = objUtl.trim(userRs.getString(6));
                String userCity = objUtl.trim(userRs.getString(7));
                String userState = objUtl.trim(userRs.getString(8));
                String userCountry = objUtl.trim(userRs.getString(9));
                String userArea = objUtl.trim(userRs.getString(10));
                String userAdress = objUtl.trim(userRs.getString(11));
                String userLandmark= objUtl.trim(userRs.getString(12));
                String userType=objUtl.trim(userRs.getString(13));
                SessionManager sesMan=new SessionManager();
                sesMan.createSession(objInp.getSerreq());
                sesMan.AddItemToSession("USERID", userid);
                 sesMan.AddItemToSession("NICKNAME", userNickName);
                sesMan.AddItemToSession("LASTNAME", userLastName);
                sesMan.AddItemToSession("FIRSTNAME", userFirstName);
                sesMan.AddItemToSession("EMAILID", userEmailId);
                sesMan.AddItemToSession("DOB", userDob);
                sesMan.AddItemToSession("GENDER", userGender.equalsIgnoreCase("F")? "Female":"Male");
                sesMan.AddItemToSession("CITY", userCity);
                sesMan.AddItemToSession("STATE", userState);
                sesMan.AddItemToSession("COUNTRY", userCountry);
                sesMan.AddItemToSession("AREA", userArea);
                sesMan.AddItemToSession("ADDRESS", userAdress);
                sesMan.AddItemToSession("LANDMARK", userLandmark);
                sesMan.AddItemToSession("USERTYPE", userType);
        }     
            con.closeStatement();
            con.close();
  }
}