Lee Munkyeong · @lee-mk · Kim Peace · Lee Munkyeong · Lee Munkyeong · Lee Munkyeong
--- a/ABVJE_BL/src/jp/agentec/abook/abv/bl/data/dao/ChatGroupDao.java 0 → 100644
+++ b/ABVJE_BL/src/jp/agentec/abook/abv/bl/data/dao/ChatGroupDao.java 0 → 100644
+
+	public ChatGroupDto getGroup(int groupId) {
+		return rawQueryGetDto("select * from m_chat_group where group_id = " + groupId, null, ChatGroupDto.class);
+	}
+
+	public List<ChatGroupDto> getFavoriteGroup() {
+		return rawQueryGetDtoList("select * from m_chat_group where favorite_register_date IS NOT NULL ORDER BY favorite_register_date ", null, ChatGroupDto.class);
+	}
+
+	public List<ChatGroupDto> getGroupByName(String[] keywords) {
+		StringBuffer sql = new StringBuffer();
+		sql.append(" SELECT *  ");
+		sql.append(" FROM m_chat_group ");
+		ArrayList<String> whereSqlList = new ArrayList<String>();
+		for (String keyword : keywords) {
+			if(StringUtil.isNullOrEmpty(keyword)){