Question

数据库中明明有数据 但是ResultSet遍历的时候确实空的 急救 在线等待

public String execute() throws Exception {
rs = Manager.getInstance().selectUser(getUsername());
while (rs.next()) {
id = rs.getInt(1);
pwd1 = rs.getString(3);
mark = rs.getInt(15);
}
if (getPwd().equals(pwd1)) {
ActionContext.getContext().getSession().put("USER_NAME",
getUsername().trim());
Vector<allorder> purchaselist = new Vector<allorder>();
ActionContext ctx = ActionContext.getContext();
ctx.getSession().put("shopCart", purchaselist);
ActionContext.getContext().getSession().put("USER_ID", id);
ActionContext.getContext().getSession().put("MARK", mark);
if ("1".equals(mark)||1==mark) {
rs1 = Manager.getInstance().selectShopId(id
if(!rs1.next()){
while (rs1.next()) {
shopId = rs.getInt(1);
}}
ActionContext.getContext().getSession().put("SHOP_ID", shopId);

这句根本没有打印出来 System.out.println("userLoginAction++shopId" + shopId);
}

return SUCCESS;
} else {
return INPUT;
}
}

Answer 1

Answer 2

Answer 3

if改为while