Java resultset errors when encountering a null
I have some code that is putting the resultset from a query into a 2 dimensional array. However when the array encounters a null from the resultset, it errors. How do I fix this?
query = "SELECT * FROM E_CMS WHERE BOXADDR_AREA IS NULL ORDER BY CBOXID ASC ";
rs = stmt.executeQuery(query);
//insert the table into the 2 dimensio开发者_高级运维nal array
while (rs.next()) {
e_cms_Array[count][0] = rs.getString("CBOXID");
e_cms_Array[count][1] = rs.getString("CBOXADD").replace("'","");
e_cms_Array[count][2] = rs.getString("MFLPU");
e_cms_Array[count][3] = rs.getString("SATLPU");
e_cms_Array[count][4] = rs.getString("BOXTYPE");
e_cms_Array[count][5] = rs.getString("SVCCLASS");
e_cms_Array[count][6] = rs.getString("LOCATION_TYPE").replace("'","");
e_cms_Array[count][7] = rs.getString("CHANGE_DATE");
e_cms_Array[count][8] = rs.getString("DEL_FLAG");
e_cms_Array[count][9] = rs.getString("DECAL_PRINT_DT");
e_cms_Array[count][10] = rs.getString("BOXADDR_AREA").replace("'","");
e_cms_Array[count][11] = rs.getString("LASTMF_AREA_O");
e_cms_Array[count][12] = rs.getString("LASTSAT_AREA_O");
System.out.println(count + " :: " +
e_cms_Array[count][0]+"|"+
e_cms_Array[count][1]+"|"+
e_cms_Array[count][2]+"|"+
e_cms_Array[count][3]+"|"+
e_cms_Array[count][4]+"|"+
e_cms_Array[count][5]+"|"+
e_cms_Array[count][6]+"|"+
e_cms_Array[count][7]+"|"+
e_cms_Array[count][8]+"|"+
e_cms_Array[count][9]+"|"+
e_cms_Array[count][10]+"|"+
e_cms_Array[count][11]+"|"+
e_cms_Array[count][12]);
count++;
}
There's no reason for the error, except for you doing things like
e_cms_Array[count][1] = rs.getString("CBOXADD").replace("'","");
Just replace it by
String s = rs.getString("CBOXADD");
e_cms_Array[count][1] = s==null ? s : s.replace("'","");
or better write a null-tolerant method for this replacement.
精彩评论