spring MVC，JDBC在项目中的应用及出现的小问题
最近做项目中需要根据输入的各个信息判断是否完善个人资料，如果8个信息：基本信息，履历，头像，风采，行业信息，个人简介，荣誉中有一项没填的话就展示完善个人资料。
?
// home页面样式，如果基本信息的6个模块有一个模块全为空就显示完善个人资料AccountUser accountuser = userDao.getUserByUidForAccount(uid);boolean idcard = StringUtils.isEmptyOrWhitespaceOnly(accountuser.getIdcard());boolean qualifyid = StringUtils.isEmptyOrWhitespaceOnly(accountuser.getQualifyid());boolean agencyid = StringUtils.isEmptyOrWhitespaceOnly(accountuser.getAgencyid());boolean photo = StringUtils.isEmptyOrWhitespaceOnly(accountuser.getPhoto());List<ExtInfo> honor = userDao.getListExtinfoForAccount(uid);List<Resume> listresume = userDao.getListResumeByUidForAccount(uid);List<SelfStyle> listself = userDao.getListSelfByUidForAccount(uid);if ((idcard && qualifyid && agencyid) || photo || honor .size()==0|| listresume .size()==0 || listself.size()==0) {this.model.get().addAttribute("styledisplay","style='display: block'");}else {this.model.get().addAttribute("styledisplay","style='display: none'");}?
dao:只列出一个dao
?
/** * * 获取用户id获取个人风采相关信息 * * @param uid * @return list */public List<SelfStyle> getListSelfByUidForAccount(int uid) {if (uid <= 0) {return new ArrayList<SelfStyle>();}// 获取当前用户的所有个人风采(selfstyle)信息String sql = "select * from " + AppConstant.DATABASE_SCHEMA_UDB_BB_USER+ "." + AppConstant.DATABASE_TABLE_UDB_SELFSTYLE+ " where uid = :uid order by id desc";SqlParameterSource paramSource = new MapSqlParameterSource("uid", uid);List<SelfStyle> selfstyle = new ArrayList<SelfStyle>();try {selfstyle = this.namedJdbcTemplate.query(sql, paramSource,new BeanPropertyRowMapper(SelfStyle.class));} catch (EmptyResultDataAccessException e) {// do nothing}return selfstyle;}?
原来 我是判断查询出来的list是否为空，但是发现查询出来的不为Null 而是 [] ，原来spring jdbc
?
selfstyle = this.namedJdbcTemplate.query(sql, paramSource,new BeanPropertyRowMapper(SelfStyle.class));
?
这个查询方式返回 了一个 对象，所以导致上述情况，注意判断List有没有值要根据 list.size 进行判断这样就不会出现问题了。以后可不能犯这低级错误了 。。。