在运行jdbc spring mvc登录时获得不正确的结果大小异常

Question

@Override
public int getData(String username, String password) {
    // TODO Auto-generated method stub
    int Status = 1;
    String sql = "select UserId from UserRegister where UserName=? and Password=? and Status=?;";
    int userid = jdbcTemplate.queryForObject(sql, new Object[] { username,
            password, Status }, Integer.class);
    if (userid != 0) {
        return userid;
    } else {
        userid = 0;
        return userid;
    }

}

例外情况：

org.springframework.web.util.NestedServletException: Request
processing failed; nested exception is
org.springframework.dao.EmptyResultDataAccessException: Incorrect
result size: expected 1, actual 0
    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
    org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
    org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

Answer 1

一旦它可能对你有帮助，就试试看。

String sql = "select UserId from UserRegister where UserName=? and Password=?  and Status=?";
int userid = (Integer)jdbcTemplate.queryForInt(sql, new Object[] { username,
        password, Status }, Integer.class);