Query Embed In JAVA Returns NULL

I have embed a query in the JAVA to retrieve the data from the back end and I use Oracle for back end. What I'm trying to do is in my query has been shown below. The issue here is that result set returns the NULL. But fine when I change the query "SELECT 5 FROM DUAL" and it returns 5 for me which right. When I try to run the same at the back end as a query I'm getting proper result.
 
public String getReturnPart(String partNumberIn) {
//int returnPartNumber = 0;
  String query =
"SELECT COUNT(*) AS CHECK1 FROM PART_MASTER PM,UNITS_OF_MEASURE UOM WHERE PM.PART_NUMBER = '" +  partNumberIn
  + "' AND PM.UNIT_OF_ISSUE = UOM.UNIT_OF_MEASURE AND UOM.UNIT_TYPE = 0 ";
  //String query = "SELECT 5 AS CHECK1  FROM DUAL"; This returns fine as "5"
  ResultSet result = null;

[Code] ....