java in 绑定变量,java – 在PreparedStatement中绑定一个空值变量

我发誓这个以前工作,但不是这种情况.我正在尝试匹配col1,col2和col3,即使其中一个或多个为null.我知道在某些语言中,我不得不诉诸于((？为空,col1为空)OR col1 =？).这是需要的吗？

PreparedStatement selStmt = getConn().prepareStatement(

"SELECT * " +

"FROM tbl1 " +

"WHERE col1 = ? AND col2 = ? and col3 = ?");

try

{

int col = 1;

setInt(selStmt, col++, col1);

setInt(selStmt, col++, col2);

setInt(selStmt, col++, col3);

ResultSet rs = selStmt.executeQuery();

try

{

while (rs.next())

{

// process row

}

}

finally

{

rs.close();

}

}

finally

{

selStmt.close();

}

// Does the equivalient of stmt.setInt(col, i) but preserves nullness.

protected static void setInt(PreparedStatement stmt, int col, Integer i)

throws SQLException

{

if (i == null)

stmt.setNull(col, java.sql.Types.INTEGER);

else

stmt.setInt(col, i);

}