mysql illegal operation on empty result set 错误。在线急等

[walkman_22]

关键代码如下：

	public boolean matchNamePwd(User u){
		if(u == null) {
			return false;
		}
		String name = u.getName();
		String pwd = u.getPwd();

		String nameSql = "select id from user where name=?";
		String pwdSql = "select id from login where pwd=?";
		
		try {
			conn = JdbcUtils.getConn();
			pstmt = conn.prepareStatement(nameSql);
			pstmt.setString(1, name);
			rs = pstmt.executeQuery();
			rs.next();
			int idByName = rs.getInt(1);
			System.out.println("idByName = " + idByName);
			
			pstmt = conn.prepareStatement(pwdSql);
			pstmt.setString(1, pwd);
			rs = pstmt.executeQuery();
			rs.next();
			
			int idByPwd = rs.getInt(1);
			System.out.println("idByPwd = " + idByPwd);
			if(idByName == idByPwd) {
				return true;
			}else {
				System.out.println("用户名 / 密码不匹配");
				return false;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		return false;
	}

大家看看有什么问题。急等。

[亲努力啊]

你的查询没有值时int idByPwd = rs.getInt(1);
出错

[亲努力啊]

int idByPwd = 0;
if(rs.next()){
idByPwd = rs.getInt(1);
}

[LMAOhuaNL]

int idByPwd = 0;
if(rs.next()){
idByPwd = rs.getInt(1);
}
一般都必须判断是否为空的，这个是必须要的

[caixuanbin]

也帮楼主顶顶

[Jeelon]

结果集为空！请LZ判断传进来的值是否为空 或者数据库是否有值?debug下吧?

[安心逍遥]

你的查询没有值时int idByPwd = rs.getInt(1);
出错
int idByPwd = 0;
if(rs.next()){
idByPwd = rs.getInt(1);
}

[walkman_22]

问题已解决。送分。

[whatstudio]

小问题，大麻烦