Thursday, April 30, 2015

mysql active status show as Active and Inactive

mysql active status show as Active and Inactive :

rbs_user this table active_status Coloumn Default=N

SELECT user_id,user_name,e_mail,designation,CASE WHEN active_status ='Y' THEN 'Active' ELSE 'Inactive' END activestatus FROM rbs_user


activestatus is allias name 

java code:
public String userStatus(){
   
        System.out.println("kaniz");
       
         if(statusVal.equalsIgnoreCase("inactive")){
                status ="Y";
            } else {
                status ="N";
            }
       
   
       
         UsersSQL usersSQL = new UsersSQL();
         usersSQL.getUpdateTable(status,unikId); // use for update query
         
       
            //userDataList = usersSQL.selectUsersDate();// use for select query
           
        return "userStatus";       
       
    }

No comments:

Post a Comment