@Test public void getGroupsByUserId() throws Exception { List<DasGroup> list = groupDao.getGroupsByUserId(46L); System.out.println("getGroupsByUserId :-------> " + list); Assert.assertTrue(list.size() > 0); }
public List<DasGroup> getGroupsByUserId(Long user_id) throws SQLException { String sql = "select t1.id, t1.group_name, t1.group_comment, t1.update_user_no, t1.insert_time from dal_group t1 " + "INNER JOIN user_group t2 on t1.id = t2.group_id " + "where t2.user_id = ? and t1.id != " + PermissionService.getADMINGROUPID() + " order by group_name"; return this.queryBySql(sql, DasGroup.class, Parameter.integerOf(StringUtils.EMPTY, user_id)); }
GroupDao extends BaseDao { public List<DasGroup> getGroupsByUserId(Long user_id) throws SQLException { String sql = "select t1.id, t1.group_name, t1.group_comment, t1.update_user_no, t1.insert_time from dal_group t1 " + "INNER JOIN user_group t2 on t1.id = t2.group_id " + "where t2.user_id = ? and t1.id != " + PermissionService.getADMINGROUPID() + " order by group_name"; return this.queryBySql(sql, DasGroup.class, Parameter.integerOf(StringUtils.EMPTY, user_id)); } }
GroupDao extends BaseDao { public List<DasGroup> getGroupsByUserId(Long user_id) throws SQLException { String sql = "select t1.id, t1.group_name, t1.group_comment, t1.update_user_no, t1.insert_time from dal_group t1 " + "INNER JOIN user_group t2 on t1.id = t2.group_id " + "where t2.user_id = ? and t1.id != " + PermissionService.getADMINGROUPID() + " order by group_name"; return this.queryBySql(sql, DasGroup.class, Parameter.integerOf(StringUtils.EMPTY, user_id)); }  }
GroupDao extends BaseDao { public List<DasGroup> getGroupsByUserId(Long user_id) throws SQLException { String sql = "select t1.id, t1.group_name, t1.group_comment, t1.update_user_no, t1.insert_time from dal_group t1 " + "INNER JOIN user_group t2 on t1.id = t2.group_id " + "where t2.user_id = ? and t1.id != " + PermissionService.getADMINGROUPID() + " order by group_name"; return this.queryBySql(sql, DasGroup.class, Parameter.integerOf(StringUtils.EMPTY, user_id)); }  Long insertDasGroup(DasGroup group); int initAdminGroup(DasGroup group); int updateDalGroup(DasGroup group); int deleteDalGroup(Long groupId); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); List<DasGroup> getGroupsByUserId(Long user_id); DasGroup getGroupsByDbSetId(Long dbsetId); DasGroup getDalGroupById(Long id); DasGroup getGroupByName(String name); List<DasGroup> getAllGroups(); List<DasGroup> getAllGroupsByAppoid(String appid); List<DasGroup> getAllGroupsWithNotAdmin(); Long getTotalCount(Paging<DasGroup> paging); List<DalGroupView> findGroupPageList(Paging<DasGroup> paging); }
GroupDao extends BaseDao { public List<DasGroup> getGroupsByUserId(Long user_id) throws SQLException { String sql = "select t1.id, t1.group_name, t1.group_comment, t1.update_user_no, t1.insert_time from dal_group t1 " + "INNER JOIN user_group t2 on t1.id = t2.group_id " + "where t2.user_id = ? and t1.id != " + PermissionService.getADMINGROUPID() + " order by group_name"; return this.queryBySql(sql, DasGroup.class, Parameter.integerOf(StringUtils.EMPTY, user_id)); }  Long insertDasGroup(DasGroup group); int initAdminGroup(DasGroup group); int updateDalGroup(DasGroup group); int deleteDalGroup(Long groupId); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); List<DasGroup> getGroupsByUserId(Long user_id); DasGroup getGroupsByDbSetId(Long dbsetId); DasGroup getDalGroupById(Long id); DasGroup getGroupByName(String name); List<DasGroup> getAllGroups(); List<DasGroup> getAllGroupsByAppoid(String appid); List<DasGroup> getAllGroupsWithNotAdmin(); Long getTotalCount(Paging<DasGroup> paging); List<DalGroupView> findGroupPageList(Paging<DasGroup> paging);  }