运行显示不出数据，求大神看看。

Question

@Repository("departmentDao")
public class DepartmentDaoImpl implements DepartmentDao{

@Resource
private JdbcTemplate jdbcTemplate;

@Override
public List<Department> find(PageBean pageBean, Department s_department) {
    StringBuffer sb=new StringBuffer("select * from t_department");
    if(s_department!=null){
        if(StringUtil.isNotEmpty(s_department.getDeptName())){
            sb.append(" and deptName like '%"+s_department.getDeptName()+"%'");
        }
    }
    if(pageBean!=null){
        sb.append(" limit "+pageBean.getStart()+","+pageBean.getPageSize());
    }
    final List<Department> departmentList=new ArrayList<Department>();
    jdbcTemplate.query(sb.toString().replaceFirst("and", "where"), new Object[]{}, new RowCallbackHandler() {

        @Override
        public void processRow(ResultSet rs) throws SQLException {
            Department department=new Department();
            department.setId(rs.getInt("id"));
            department.setDeptName(rs.getString("deptName"));
            department.setRemark(rs.getString("remark"));
            departmentList.add(department);
        }
    });
    return departmentList;
}

@Override
public int count(Department s_department) {
    StringBuffer sb=new StringBuffer("select count(*) from t_department");
    if(s_department!=null){
        if(StringUtil.isNotEmpty(s_department.getDeptName())){
            sb.append(" and deptName like '%"+s_department.getDeptName()+"%'");
        }
    }
    return jdbcTemplate.queryForObject(sb.toString().replaceFirst("and", "where"), Integer.class);
}

}

Answer 1

问问题都描述不清楚
第一、没显示数据跟DAO层有关系吗？？？你确定是DAO层的问题吗？
第二、你是说哪个方法去查的时候没显示数据呢？？？