DAO中,rs.next 结果集里是空值,请大家帮看下,谢谢!有贴代码

public boolean isExists(Operator operator) {
Connection conn = null;
PreparedStatement stmt = null;
boolean tmp = false;
try {
conn = OracleDAOFactory.getConnection();
//conn = OracleDAOFactory.getConnection();
stmt = conn.prepareStatement(GET_AN_OPERATOR);
stmt.setString(1, operator.getOperator_ID());
stmt.setString(2, operator.getOperator_Pwd());
System.out.println(operator.getOperator_ID() + " && "
+ operator.getOperator_Pwd());
ResultSet rs = stmt.executeQuery();

        if (rs.next()) {

                   [color=red]//执行不到这里...[/color]
tmp = true;

}

    }

    catch (SQLException e) {
        tmp = false;
    } finally {
        OracleDAOFactory.closeStatement(stmt);
        OracleDAOFactory.closeConnection(conn);
    }

    return tmp;
}

代码没看出有什么毛病,可能是SQL语句的事,请楼主检查下[code="java"]stmt = conn.prepareStatement(GET_AN_OPERATOR); [/code]在创建PreparedStatement对象时传入的sql语句(不知道GET_AN_OPERATOR是个什么常量),在看下[code="java"]stmt.setString(1, operator.getOperator_ID());
stmt.setString(2, operator.getOperator_Pwd());[/code] 设置值的时候顺序是否正确

sql文单独执行过,并确认有结果么?
debug状态下结果集当中有数据么??
重新编译、发布一下