@Override public User mapRow(ResultSet rs, int index) throws SQLException { User u = new User(); u.setId(rs.getLong("id")); u.setType(rs.getInt("type")); u.setUsername(rs.getString("username")); u.setPassword(rs.getString("password")); u.setWxuid(rs.getLong("wxuid")); u.setNickname(rs.getString("nickname")); u.setHeadimgurl(rs.getString("headimgurl")); u.setCreatetime(rs.getTimestamp("createtime")); u.setUpdatetime(rs.getTimestamp("updatetime")); return u; }