@Override
public UserRole getRoleByName(String sessID, String roleName)
throws RemoteException, SessionExpiredException, SQLException {
String thisDatabase = SessionManager.getInstance().getDatabaseForSession(sessID);
TableSchema roleTable = MedSavantDatabase.UserRoleTableSchema;
SelectQuery sq = new SelectQuery();
sq.addFromTable(roleTable.getTable());
sq.addAllColumns();
sq.addCondition(
BinaryCondition.equalTo(
roleTable.getDBColumn(MedSavantDatabase.UserRoleTableSchema.COLUMNNAME_OF_ROLENAME),
roleName));
ResultSet rs = null;
try {
rs = ConnectionController.executeQuery(sessID, sq.toString());
if (rs.next()) {
int roleId = rs.getInt(1);
String name = rs.getString(2);
String roleDescription = rs.getString(3);
return new UserRole(roleId, name, roleDescription, thisDatabase);
}
return null;
} finally {
if (rs != null) {
rs.close();
}
}
}
