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";
}
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