How to Install/Uninstall/Execute MySQL as Windows Service

send me your mail id i’ll send the project..

Hi Guptha,
My task is “list of all users who are currently logged into my project”This should pop up as new page on click of a button with name “logged-in users”. The table should list following columns
1] First Name
2] Last Name
3] user-id
4] email
5] contact number
You already send the code but it is not working i’ll send my files could you please check and tell me how to do this ?
UserPrincipal.java file name
public final class UserPrincipal //implements Serializable, HttpSessionBindingListener {
{

/**
* User Id.
*/
private Integer userId;

/**
* First Name.
*/
private String firstName;

/**
* Last Name.
*/
private String lastName;

/**
* User Email.
*/
private String userEmail;

/**
* User Email Alias.
*/
private String userEmailAlias;

/**
* Role Code.
*/
private Integer roleCode;

/**
* Change Password Flag.
*/
private Boolean changePasswordFlag;

/**
* Company Name.
*/
String companyName;

/**
* successfull login date time.
*/
private Date lastSuccessfulLoginTime;

/**
* UserPrincipal Constructor.
*
* @param userId user id
* @param firstName first name
* @param lastName last name
* @param userEmail user email
* @param userEmailAlias user email alias
* @param roleCode role code
* @param changePasswordFlag change password flag
* @param companyName user company name
*/
public UserPrincipal(Integer userId, String firstName, String lastName,
String userEmail, String userEmailAlias, Integer roleCode,
Boolean changePasswordFlag, String companyName, Date lastLoginDate) {
super();
this.userId = userId;
this.firstName = firstName;
this.lastName = lastName;
this.userEmail = userEmail;
this.userEmailAlias = userEmailAlias;
this.roleCode = roleCode;
this.changePasswordFlag = changePasswordFlag;
this.companyName = companyName;
this.lastSuccessfulLoginTime = lastLoginDate;
}

/**
*
* @return user id
*/
public Integer getUserId() {
return userId;
}

/**
*
* @return first name
*/
public String getFirstName() {
return firstName;
}

/**
*
* @return last name
*/
public String getLastName() {
return lastName;
}

/**
*
* @return user email
*/
public String getUserEmail() {
return userEmail;
}

/**
*
* @return user email alias
*/
public String getUserEmailAlias() {
return userEmailAlias;
}

/**
*
* @return role code
*/
public Integer getRoleCode() {
return roleCode;
}

/**
* @return the changePasswordFlag
*/
public Boolean getChangePasswordFlag() {
return changePasswordFlag;
}

/**
* @return the companyName
*/
public String getCompanyName() {
return companyName;
}

/**
* @return the lastSuccessfulLoginTime
*/
public Date getLastSuccessfulLoginTime() {
return lastSuccessfulLoginTime;
}

/**
* @param lastSuccessfulLoginTime the lastSuccessfulLoginTime to set
*/
public void setLastSuccessfulLoginTime(Date lastSuccessfulLoginTime) {
this.lastSuccessfulLoginTime = lastSuccessfulLoginTime;
}

/**
* This method throw CloneNotSupportedException, whenever anyone try to
* attempt cloning operation.
*
* @see java.lang.Object#clone()
* @return Object
* @throws CloneNotSupportedException clone not supported
*/
@Override
protected Object clone() throws CloneNotSupportedException {
throw new CloneNotSupportedException();
}

/* (non-Javadoc)
* @see javax.servlet.http.HttpSessionBindingListener#valueBound(javax.servlet.http.HttpSessionBindingEvent)
*/
/* @SuppressWarnings(“unchecked”)
@Override
public void valueBound(HttpSessionBindingEvent sessionBindingEvent) {
System.out.println(“in valueBound===================================================================================”);

System.out.println(” added userPrinipal “);
ServletContext appContext = sessionBindingEvent.getSession()
.getServletContext();
Map loggedInUsersMap = new HashMap();

if (appContext.getAttribute(“loggedInUsersMap”) == null) {

appContext.setAttribute(“loggedInUsersMap”, loggedInUsersMap);
} else {
loggedInUsersMap = (Map) appContext
.getAttribute(“loggedInUsersMap”);
}
UserPrincipal userPrincipal = (UserPrincipal) sessionBindingEvent
.getSession().getAttribute(“userPrincipal”);

// add loggedin user into map
if(userPrincipal != null)
loggedInUsersMap.put(userPrincipal.getUserId(), userPrincipal);

}

(non-Javadoc)
* @see javax.servlet.http.HttpSessionBindingListener#valueUnbound(javax.servlet.http.HttpSessionBindingEvent)

@SuppressWarnings(“unchecked”)
@Override
public void valueUnbound(HttpSessionBindingEvent sessionBindingEvent) {
System.out.println(“in valueUnbound===================================================================================”);

// TODO Auto-generated method stub
System.out.println(” remove userPrinipal “);
ServletContext appContext = sessionBindingEvent.getSession()
.getServletContext();
Map loggedInUsersMap = new HashMap();

if (appContext.getAttribute(“loggedInUsersMap”) == null) {

appContext.setAttribute(“loggedInUsersMap”, loggedInUsersMap);
} else {
loggedInUsersMap = (Map) appContext
.getAttribute(“loggedInUsersMap”);
}
UserPrincipal userPrincipal = (UserPrincipal) sessionBindingEvent
.getSession().getAttribute(“userPrincipal”);

// add loggedin user into map
if(userPrincipal != null)
loggedInUsersMap.remove(userPrincipal.getUserId());

}*/

/**
* @return
*/

}
UserController.java:this file specifies the connection form server to UI

// @SuppressWarnings({ “unused”, “unchecked” })
@RequestMapping(“/getLoggedInUser”)
public @ResponseBody String getUserDetails(HttpServletRequest request,
HttpServletResponse response) throws IOException, ServletException {
//logger.trace(“Entering method”);
// Get the session object
//HttpSession session = null;
//session = request.getSession(false);
JSONObject outerObj = new JSONObject();
JSONArray userArray = new JSONArray();
List userlist = new ArrayList();
userlist.add(new UserPrincipal(1, “gfgf”, “gfgfdg”, “gfgfdg”, “gfgfdg”, 2, false, “gfgfdg”, new Date()));
userlist.add(new UserPrincipal(2, “gfgf”, “gfgfdg”, “gfgfdg”, “gfgfdg”, 2, false, “gfgfdg”, new Date()));
userlist.add(new UserPrincipal(3, “gfgf”, “gfgfdg”, “gfgfdg”, “gfgfdg”, 2, false, “gfgfdg”, new Date()));
userlist.add(new UserPrincipal(4, “gfgf”, “gfgfdg”, “gfgfdg”, “gfgfdg”, 2, false, “gfgfdg”, new Date()));

UserPrincipal user = null;
//JSONObject User = new JSONObject();
for (UserPrincipal user1 :userlist ) {
JSONObject userObj = new JSONObject();
userObj.put(“userId”, user1.getUserId());
userObj.put(“userFirstName”, user1.getFirstName());
userObj.put(“userLastName”, user1.getLastName());
userObj.put(“userEmail”, user1.getUserEmail());
//userObj.put(“userPhone”, user1.getUserPhone());
userObj.put(“userCompanyNname”, user1.getCompanyName());
userArray.add(userObj);

}

outerObj.put(“Result”, “OK”);
outerObj.put(“Records”, userArray);
outerObj.put(“TotalRecordCount”, userArray.size());

logger.debug(“getUserDetails method”);
return outerObj.toJSONString();
}
and this is my jtable mange.js
var jTable;
function showLoggedInUsers() {

// start of logged in user jTable.
updateBackgroundHeight();
$(“#LoggedInUserTableContainer”).jtable({
title:’Logged-In Users’,
paging: true, //Enable paging
pageSize: 10, //Set page size
sorting: true, //Enable sorting
//width:700,
defaultSorting: ‘userId ASC’, //Set default sorting
listClass: ‘child-opener-image-column’,
openChildAsAccordion: true,
jqueryuiTheme :true,
recordsLoaded: onRecordsLoaded,
loadingAnimationDelay : 0,
ajaxSettings: {
type: ‘POST’,
dataType: ‘json’
},
actions: {
listAction: ‘getLoggedInUser’
}, //end of actions

messages : {
noDataAvailable : jQuery.i18n.prop(‘userManagement.jtable.noRecords’),
loadingMessage : “wait..Loading data”
},

fields: {
userId: {
key: true,
//title: jQuery.i18n.prop(‘userManagement.jtable.lblUserId’),
create: true,
edit: true,
list: false
},

userFirstName: {
//title: jQuery.i18n.prop(‘userManagement.jtable.lblFirstName’),
create: true,
edit: true,
list: true,
width:’14%’
},
userLastName: {
//title: jQuery.i18n.prop(‘userManagement.jtable.lblLastName’),
create: true,
edit: true,
list: true,
width:’14%’
},
userCompanyNname: {
//title: jQuery.i18n.prop(‘userManagement.jtable.lblCompany’),
create: true,
edit: true,
list: true,
width:’11%’
},
userPhone: {
//title: jQuery.i18n.prop(‘userManagement.jtable.lblPhoneNo’),
create: true,
edit: true,
list: true,
width:’19%’
},
userEmail: {
//title: jQuery.i18n.prop(‘userManagement.jtable.lblEmail’),
create: true,
edit: true,
list: true,
width:’14%’
},
}
});

//end of jtable
//showActionDialog(jTable, “Logged-In Users”);
//showLoader(“Wait. Loading User Data…”);
$(‘#LoggedInUserTableContainer’).jtable(‘load’);
}

Hi Guptha,
I had a doubt.My doubt is there is one login screen,after login screen there is one user management page.In UM page there is one jtable is displayed.So my question is there is one “logged in users” button in toolbar.In table i already predefined some users with the fields of (First name,Last-name,Company,phone-no).when i click that button i have to show logged in users list.How to do this task in session could you please help me in this…?

Since deleting the service wont uninstall MySQL, can we not manually configure MYSqlXY service to not start when windows start ,so that we need not create service again?