calculating the % of votes

sameerkumar · **Joined:** Tue Jan 29, 2008 4:54 pm **Posts:** 1

Hi,

I have a results table which has answers n questions sent in by the user.i need to calcute the % of v otes for submissions by user...I have wriiten some thin like this..but it keeps on thrwoing null pointer..can ne1 suggest somethhing or better way for doing this.
Session session = null;
Query query = session.createQuery("select count(*) from poll_results where asnwer_id like '%'");
int count = ((Number) query.list()).intValue();

Query query1 = session.createQuery("select count(*) from poll_results where question_id like '%");
int count1 = ((Number) query.list()).intValue();

int result = (count/count1)*100;

return result;

mimi_tan1985 · **Posted:** Tue Jan 29, 2008 11:55 pm

Code:

Session session = null;
// -> the session is null here.. that's why it throw null pointer exception
// -> you should create a session with SessionFactory
Query query = session.createQuery("select count(*) from poll_results where asnwer_id like '%'");
//you should do this instead:
//int count = ((Number)query.list().get(0).intValue();
int count = ((Number) query.list()).intValue();

Query query1 = session.createQuery("select count(*) from poll_results where question_id like '%");
//int count1 = ((Number)query.list().get(0)).intValue();
int count1 = ((Number) query.list()).intValue();

int result = (count/count1)*100;

return result;