@Test public void findUserPageList() throws Exception { List<LoginUserView> list = loginUserDao.findUserPageList(paging); System.out.println("findUserPageList :-------> " + list); Assert.assertTrue(list.size() > 0); }
public List<LoginUserView> findUserPageList(Paging<LoginUser> paging) throws SQLException { String sql = "SELECT t1.id, t1.user_no, t1.user_name, t1.user_email, t1.user_real_name , t2.user_real_name as update_user_name, t4.group_name FROM login_users t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + "left join user_group t3 on t3.user_id = t1.id " + "left join dal_group t4 on t3.group_id= t4.id " + appenCondition(paging); return this.queryBySql(sql, LoginUserView.class); }
LoginUserDao extends BaseDao { public List<LoginUserView> findUserPageList(Paging<LoginUser> paging) throws SQLException { String sql = "SELECT t1.id, t1.user_no, t1.user_name, t1.user_email, t1.user_real_name , t2.user_real_name as update_user_name, t4.group_name FROM login_users t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + "left join user_group t3 on t3.user_id = t1.id " + "left join dal_group t4 on t3.group_id= t4.id " + appenCondition(paging); return this.queryBySql(sql, LoginUserView.class); } }
LoginUserDao extends BaseDao { public List<LoginUserView> findUserPageList(Paging<LoginUser> paging) throws SQLException { String sql = "SELECT t1.id, t1.user_no, t1.user_name, t1.user_email, t1.user_real_name , t2.user_real_name as update_user_name, t4.group_name FROM login_users t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + "left join user_group t3 on t3.user_id = t1.id " + "left join dal_group t4 on t3.group_id= t4.id " + appenCondition(paging); return this.queryBySql(sql, LoginUserView.class); }  }
LoginUserDao extends BaseDao { public List<LoginUserView> findUserPageList(Paging<LoginUser> paging) throws SQLException { String sql = "SELECT t1.id, t1.user_no, t1.user_name, t1.user_email, t1.user_real_name , t2.user_real_name as update_user_name, t4.group_name FROM login_users t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + "left join user_group t3 on t3.user_id = t1.id " + "left join dal_group t4 on t3.group_id= t4.id " + appenCondition(paging); return this.queryBySql(sql, LoginUserView.class); }  Long insertUser(LoginUser user); int initAdmin(LoginUser user); int updateUserPassword(LoginUser user); List<LoginUser> getAllUsers(); LoginUser getUserById(Long userId); LoginUser getUserByNo(String userNo); LoginUser getUserByUserName(String userName); List<LoginUsersView> getUserByGroupId(Long groupId); int updateUser(LoginUser user); int deleteUser(Long userId); Long getTotalCount(Paging<LoginUser> paging); List<LoginUserView> findUserPageList(Paging<LoginUser> paging); }
LoginUserDao extends BaseDao { public List<LoginUserView> findUserPageList(Paging<LoginUser> paging) throws SQLException { String sql = "SELECT t1.id, t1.user_no, t1.user_name, t1.user_email, t1.user_real_name , t2.user_real_name as update_user_name, t4.group_name FROM login_users t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + "left join user_group t3 on t3.user_id = t1.id " + "left join dal_group t4 on t3.group_id= t4.id " + appenCondition(paging); return this.queryBySql(sql, LoginUserView.class); }  Long insertUser(LoginUser user); int initAdmin(LoginUser user); int updateUserPassword(LoginUser user); List<LoginUser> getAllUsers(); LoginUser getUserById(Long userId); LoginUser getUserByNo(String userNo); LoginUser getUserByUserName(String userName); List<LoginUsersView> getUserByGroupId(Long groupId); int updateUser(LoginUser user); int deleteUser(Long userId); Long getTotalCount(Paging<LoginUser> paging); List<LoginUserView> findUserPageList(Paging<LoginUser> paging);  }