Storing sql null values as "0"

[Eduardo Ponce de Leon]

I am having a problem with the result of a query. My query is resultin in 3 column . Then I add the row toa an arraylist. Sometimes my result will be null, the 3 colums will return nothing, because there is not information available. How can I store those values as '0s' in my arrayList.
Thank you in advance

This is my code.

String[] mes = {"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"};
String[] tipo = {"SM","044","045","01","00","001"};
int año = 2011;
for (int m = 0; m < mes.length; m++) {
	for (int t = 0; t < tipo.length; t++) {
	query = "SELECT SUM (\"LLAMADAS\") AS \"Total Llam\", SUM (\"MIN\") AS \"Total Min\", "+
	"SUM (\"TOTAL\") AS \"Total\" FROM \"public\".\""+año+"\" WHERE \"MES\" LIKE '"
	+ mes[m]
	+ "' AND \"TIPO\" = '"
	+ tipo[t] + "';";
	//conn = toDB.connection("Beneficios_AT");
	rs = toDB.exeQuery(conn,query);
	if (rs!=null)  {
		while (rs.next()) {
			if(rs.wasNull()){
			rowValues.add("0");
			rowValues.add("0");
			rowValues.add("0");
			resultados = (String[]) rowValues.toArray(new String[rowValues.size()]);
		}
		rowValues.add(rs.getString(1));
		rowValues.add(rs.getString(2));
		rowValues.add(rs.getString(3));
		} 
		resultados = (String[]) rowValues.toArray(new String[rowValues.size()]);
	}

}//end of for type loop					

[Eduardo Ponce de Leon]

It is part of JSP!! Where was it moved?

[Bear Bibeault]

This has nothing at all to do with JSP and is now in the JDBC forum. As you have replied, apparently you found it!

[Paul Clapham]

I don't see anything at all in the post which makes it a post about JSP. It's obviously a post about JDBC.

Anyway you seem to have misunderstood the ResultSet.wasNull() method. It returns true if the previous column you read (via getString() or getInt() or whatever method) contained null. The way you use it in that code, it will always return null because there was no previous column read.

Example of how to use it:

String value = rs.getString(1);
if (rs.wasNull()) {
  value="0";
}

However if you had interpreted those columns as numbers -- which they clearly are numbers -- instead of converting them to String, then you wouldn't have this problem. The getInt() method always returns zero when the underlying data is null.