查询时遇到null怎么办
我有一段代码
tmpSQL = "select spsx2,sum(xssl),sum(xsje) from rspsx2xsb where day='" + Rq + "'and spsx2 like '%" + n2U(Spsxz) + "%'group by spsx2";
ResultSet rs = stmt.executeQuery(tmpSQL);
m_Count = 0;
Vector tmp = new Vector();
while (rs.next()) {
if ((m_Count >= Pagesize * (CurrPage - 1)) && (m_Count - (Pagesize * (CurrPage - 1)) < Pagesize))
popData(tmp, rs.getString(1).trim(), rs.getString(2).trim(), rs.getString(3));
m_Count++;
}
当spsx2为null时就会出错,如何解决?