Websphere Portal personalization

Portal personalization can be achieved on a particular portal page or even on a particular portlet with a portal page.Following are the 2 links of different blogs to achieve personalization on portlets

Link 1
http://absolutebrain.blogspot.in/2011/06/personalizing-page-portlet-using.html
Link2
http://wpcertification.blogspot.in/2011/01/how-to-show-or-hide-portal-or-portlet.html 

Following link is an excellent tutorial from IBM developer works to create personalization

Link3 (Pdf is also available in backup email Id)
http://www.ibm.com/developerworks/websphere/tutorials/0702_brunn2/0702_brunn2-pdf.pdf

Above 3 links are enough to help you create the personalization rules and apply them to a portlet

I have used the code from link 3 and have modified it to fetch the data from DB (My Sql) and based on the data fetched from DB,I have returned the value "Pass" or "Fail" which can be used in the personalization rules to show/hide portlet or Portal page.

Sample application which will be put in portal server as a jar is available in backup email.Following is the code for reference from application

package com.ibm.websphere.personalization.examples;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import com.ibm.websphere.personalization.RequestContext;
import com.ibm.websphere.personalization.applicationObjects.
SelfInitializingApplicationObject;
import java.io.Serializable;
public class MySampleObject implements
SelfInitializingApplicationObject,
Serializable {
private String userName;
public void init(RequestContext context) {
userName = context.getRequestUsername();
context.setSessionAttribute("mysampleobject", this);
}
public String getMySampleString() {
return "Hello " + userName;
}
public int getMySampleInt() {return 1;
}
public Date getMySampleDate() {
return new Date();
}

public String getMohitSampleString() {
    return "Hello " + userName;
    }
// Method to fetch the data from DB and return corresponding value to be used in personalization rules.

public String getMyVal()
{
String output="fail";
String nm=null;
int ag;
    try {
        Class.forName("com.mysql.jdbc.Driver");
    } catch (ClassNotFoundException e) {
        System.out.println("Please include Classpath  Where your DB2 Driver is located");
        e.printStackTrace();
       
    }
    System.out.println("DB2 driver is loaded successfully");
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rset = null;
    boolean found = false;
    try {
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/personalization", "root", "root");
        if (conn != null) {
            System.out.println("DB2 Database Connected");
        } else {
            System.out.println("Db2 connection Failed ");
        }
        pstmt = conn.prepareStatement("Select * from person");
        rset = pstmt.executeQuery();
       
       
        if (rset != null) {
            while (rset.next()) {
                found = true;
               
               
                ag=rset.getInt("Age");
                nm=rset.getString("Name");
                if(nm.equalsIgnoreCase("mohit") || ag>25)
                    {output="pass"; }
                System.out.println("Name: " + rset.getString("Name")+output);
            }
        }
        if (found == false) {
            System.out.println("No Information Found");
        }
    } catch (SQLException e) {
        System.out.println("DB2 Database connection Failed");
        e.printStackTrace();
       
    }

    return output;
}}


Note : Apart from putting this java project as jar in portal server,we need to put mysql connector jar as well into portal server at following locations

D:\IBM\WebSphere\PortalServer\pzn\prereq.pzn\lib
D:\IBM\WebSphere\PortalServer\pzn\prereq.pzn\collections

Note: While creating personalization rule based on parameters of portal,like (if userid of portal user is wpsadmin show the portlet) we need to select attribute (Portal Users-->uid).Value has to be hard coded in value textbox.