9. TEAM 프로젝트: 캘린더 기능 구현

상세한 개발 내역을 작성할려고 했으나, 여러 번의 디버그가 있었고 개발 단계에서 변경되는 점 또한 많았다.

때문에 완성된 캘린더를 기능 별로 정리하고, 개선점을 작성하려고 한다.

(TimeLine에 작성해 봤으나 글이 한눈에 들어오지 않는다는 단점이 있어서 방법을 바꿨다.)

1. 그룹 기능 구현

그룹에 관련된 전반적인 기능은 삭제 및 추가를 비롯하여 스케줄에 대한 권한 부여와 그룹 원을 삭제하는 기능이다.

DB 또한 GroupData의 고유키를 기반으로 구조화된 상태이며, 수정자나 그룹원 삭제 또한 각각의 테이블을 기반으로 기능을 작동한다.

그룹 기능에 필요한 세부 기능은 다음과 같다.

그룹 추가, 수정, 삭제, 보기 기능
그룹 멤버(그룹에 속한 자신을 제외한)를 추방하는 기능
그룹 멤버가 그룹을 탈퇴하는 기능

2. 기본 레이아웃

그룹들의 데이터, 보기 버튼을 누르면 해당 그룹의 스케줄이 안보이거나 보이게할 수 있다.

해당 그룹의 권한자는 연필 아이콘을 누르면 그룹 컬러와 멤버 데이터를 수정할 수 있다.

3. DTO

1) GroupDTO

package DTO;

public class GroupDTO {

	private String groupnum;
	private String groupname;
	private String groupcolor;
	private String searchable;
	private String master;
	
	// DB에는 아래 항목이 필요 없음 
	private String[] members;
	private String[] modifiers;
	
	public String getGroupnum() {
		return groupnum;
	}
	public void setGroupnum(String groupnum) {
		this.groupnum = groupnum;
	}
	
	public String getGroupname() {
		return groupname;
	}
	public void setGroupname(String groupname) {
		this.groupname = groupname;
	}
	public String getGroupcolor() {
		return groupcolor;
	}
	public void setGroupcolor(String groupcolor) {
		this.groupcolor = groupcolor;
	}
	public String getSearchable() {
		return searchable;
	}
	public void setSearchable(String searchable) {
		this.searchable = searchable;
	}
	public String getMaster() {
		return master;
	}
	public void setMaster(String master) {
		this.master = master;
	}
	public String[] getMembers() {
		return members;
	}
	public void setMembers(String[] membesr) {
		this.members = membesr;
	}
	public String[] getModifiers() {
		return modifiers;
	}
	public void setModifiers(String[] modifiers) {
		this.modifiers = modifiers;
	}
	
}

2) GroupMemberDTO

package DTO;

public class GroupMemberDTO {
	private String num;
	private String groupnum;
	private String id;
	private String invite;
	//DB 에는 없음 
	private String name;
	
	public String getNum() {
		return num;
	}
	public void setNum(String num) {
		this.num = num;
	}
	public String getGroupnum() {
		return groupnum;
	}
	public void setGroupnum(String groupnum) {
		this.groupnum = groupnum;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getInvite() {
		return invite;
	}
	public void setInvite(String invite) {
		this.invite = invite;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
}

3) GroupModifierDTO

package DTO;

public class GroupModifierDTO {
	private String num;
	private String groupnum;
	private String id;
	// db에는 없음
	private String name;
	
	public String getNum() {
		return num;
	}
	public void setNum(String num) {
		this.num = num;
	}
	public String getGroupnum() {
		return groupnum;
	}
	public void setGroupnum(String groupnum) {
		this.groupnum = groupnum;
	}
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
}

4. DAO

package DAO;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import DTO.GroupDTO;
import DTO.GroupMemberDTO;
import DTO.GroupModifierDTO;
import DTO.MemberDTO;

public class GroupDAO {

	private static GroupDAO instance = new GroupDAO();
	
	public static GroupDAO getInstance(){
		return instance;
	}
	
	public Connection getConnection(){
		Connection conn=null;
		String url="jdbc:mysql://127.0.0.1:3306/status200";
		String db_id="root";
		String db_pw="iotiot";
		//String db_pw="iotiot12*";
		//지애 :: 제 db 비밀번호가 달라서 잠깐 수정합니다.
		
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
			conn=DriverManager.getConnection(url, db_id, db_pw);
		} catch (Exception e) {
			
			e.printStackTrace();
			System.out.println("Schedule DAO Error **********"+e);	
		}

		return conn;
	}
	public static void close(Connection conn, Statement stmt, ResultSet rs){
		try{
			if(rs!=null){
				rs.close();
			}
			if(stmt!=null){
				stmt.close();
			}
			if(conn!=null){
				conn.close();
			}
		}
		catch(Exception e){
			System.out.println("Close Error(val ==3) : "+ e);
		}
	}
	
	public static void close(Connection conn, Statement stmt){
		try{
			if(stmt!=null){
				stmt.close();
			}
			if(conn!=null){
				conn.close();
			}
		}
		catch(Exception e){
			System.out.println("Close Error(val == 2) : "+ e);
		}
	}

	// 그룹 정보를 가져옴 
	public List<GroupDTO> groupList(String userKey){
		List<GroupDTO> temp= new ArrayList<GroupDTO>();
		List<GroupDTO> list= new ArrayList<GroupDTO>();
	
		String sql="select groupnum from groupMember where id = ? and invite = 'accept'";
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
	
		try
		{
			conn = getConnection();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, userKey);
			
			System.out.println(pstmt);
			rs = pstmt.executeQuery();
			
			while(rs.next()){
				GroupDTO gDTO = new GroupDTO();
				gDTO.setGroupnum(rs.getString("groupnum"));
				temp.add(gDTO);
			}
			

			for(int i = 0; i<temp.size(); i++) {
				List<String> members = new ArrayList<String>();
				List<String> modifiers = new ArrayList<String>();
				GroupDTO gDTO = new GroupDTO();
				sql = "select * from groupdata where groupnum = ?";
				pstmt = conn.prepareStatement(sql);
				pstmt.setString(1, temp.get(i).getGroupnum());
				rs = pstmt.executeQuery();
				
				while(rs.next()){
					gDTO.setGroupnum(rs.getString("groupnum"));
					gDTO.setGroupname(rs.getString("groupname"));
					gDTO.setGroupcolor(rs.getString("groupcolor"));
					gDTO.setSearchable(rs.getString("searchable"));
					gDTO.setMaster(rs.getString("master"));
				}
				pstmt.clearParameters();
				
				sql = "select groupmember.id, groupmember.invite, member.name from groupmember left join member on groupmember.id = member.id where groupmember.groupnum = ?";
				pstmt = conn.prepareStatement(sql);
				pstmt.setString(1, temp.get(i).getGroupnum());
				rs = pstmt.executeQuery();
				
				while(rs.next()) {
					GroupMemberDTO gmDTO = new GroupMemberDTO();
					gmDTO.setId(rs.getString("id"));
					gmDTO.setName(rs.getString("name"));
					gmDTO.setInvite(rs.getString("invite"));

					if(gmDTO.getInvite().equals("accept")) {
						String tempstr = gmDTO.getName() + "("+gmDTO.getId()+")";
						members.add(tempstr);
					}
				}
				pstmt.clearParameters();
				
				sql = "select groupmodifier.id, member.name from groupmodifier left join member on groupmodifier.id = member.id where groupnum = ?";
				pstmt = conn.prepareStatement(sql);
				pstmt.setString(1, temp.get(i).getGroupnum());
				rs = pstmt.executeQuery();

				while(rs.next()) {
					GroupModifierDTO gdDTO = new GroupModifierDTO();
					gdDTO.setId(rs.getString("id"));
					gdDTO.setName(rs.getString("name"));
					String tempstr = gdDTO.getName() + "("+gdDTO.getId()+")";
					modifiers.add(tempstr);	
				}

				pstmt.clearParameters();
				gDTO.setMembers(members.toArray(new String[members.size()]));
				gDTO.setModifiers(modifiers.toArray(new String[modifiers.size()]));
				list.add(gDTO);
			}
		}
		catch(Exception e){
			System.out.println("Group DAO> ::Select Error(val == 1) : "+ e);
		}
		finally{
			close(conn, pstmt, rs);
		}
		return list;
	}
	
	public void groupInsert(GroupDTO gDTO){
		
		String sql="insert into groupData (groupname, groupcolor, searchable, master) values(?,?,?,?)";
		Connection conn=null;
		PreparedStatement pstmt=null;
		ResultSet rs=null;
		
		try{
			conn=getConnection();
			pstmt=conn.prepareStatement(sql);
			pstmt.setString(1, gDTO.getGroupname());
			pstmt.setString(2, gDTO.getGroupcolor());
			pstmt.setString(3, gDTO.getSearchable());
			pstmt.setString(4, gDTO.getMaster());

			System.out.println(pstmt);
			pstmt.executeUpdate();
			pstmt.clearParameters();
			
			sql = "select groupnum from groupData where master = ? order by groupnum asc";
			pstmt=conn.prepareStatement(sql);
			pstmt.setString(1, gDTO.getMaster());
			System.out.println(pstmt);
			rs = pstmt.executeQuery();
			
			while(rs.next()) {
				gDTO.setGroupnum(rs.getString("groupnum"));
			}
			pstmt.clearParameters();
		
			sql = "insert into groupMember(groupnum, id, invite) values(?,?,?)";
			pstmt=conn.prepareStatement(sql);
			pstmt.setString(1, gDTO.getGroupnum());
			pstmt.setString(2, gDTO.getMaster());
			pstmt.setString(3, "accept");
			System.out.println(pstmt);
			pstmt.executeUpdate();
			pstmt.clearParameters();
			
			sql = "insert into groupModifier(groupnum, id) values (?,?)";
			pstmt=conn.prepareStatement(sql);
			pstmt.setString(1, gDTO.getGroupnum());
			pstmt.setString(2, gDTO.getMaster());
			System.out.println(pstmt);
			pstmt.executeUpdate();
			pstmt.clearParameters();
		}
		catch(Exception e)
		{
			System.out.println("GroupDAO> groupData Insert Error: "+e);
		}
		finally
		{
			close(conn, pstmt);
		}
	}
	// 그룹 삭제 
	public void groupDelete(GroupDTO gDTO)
	{
		String sql ="delete from data, member, modifier, sc using groupdata data inner join groupmember member inner join groupmodifier modifier inner join schedule sc where data.groupnum = member.groupnum and member.groupnum = modifier.groupnum and data.groupnum = sc.groupnum and data.groupnum = ?";
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		// 그룹 삭제에 대한 알고리즘은 서블렛에 구현 
		
		try
		{
			conn = getConnection();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, gDTO.getGroupnum());
			System.out.println(pstmt);
			pstmt.executeUpdate();
			
		}
		catch(Exception e){
			System.out.println("ScheduleDAO> groupData Delete Error : "+ e);
		}
		finally{
			close(conn, pstmt);
		}
	}
	
	public void groupUpdate(GroupDTO gDTO){
		String sql="update groupData set groupname=?, groupcolor=?, searchable=? where groupnum=?";
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		
		try{
			conn = getConnection();
			pstmt = conn.prepareStatement(sql);
			
			pstmt.setString(1, gDTO.getGroupname());
			pstmt.setString(2, gDTO.getGroupcolor());
			pstmt.setString(3, gDTO.getSearchable());
			pstmt.setString(4, gDTO.getGroupnum());
			
			pstmt.executeUpdate();
		}
		catch(Exception e){
			System.out.println("ScheduleDAO > groupData UPDATE Error : "+ e);
		}
		finally{
			close(conn, pstmt);
		}
	}
	
	public void insertModifier(GroupModifierDTO gdDTO){

		String sql="insert into groupmodifier(groupnum, id) value (?,?)";
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		
		try{
			conn = getConnection();
			
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, gdDTO.getGroupnum());
			pstmt.setString(2, gdDTO.getId());
			System.out.println(pstmt);
			pstmt.executeUpdate();
		}
		catch(Exception e){
			System.out.println("ScheduleDAO > groupData UPDATE Error : "+ e);
		}
		finally{
			close(conn, pstmt);
		}
	}
	
	public void deleteModifier(GroupModifierDTO gdDTO){

		String sql="select num, id, groupnum from groupmodifier where id = ? and groupnum = ?";
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try{
			conn = getConnection();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, gdDTO.getId());
			pstmt.setString(2, gdDTO.getGroupnum());
			System.out.println(pstmt);
			rs = pstmt.executeQuery();
			
			while(rs.next()) {
				gdDTO.setNum(rs.getString("num"));
			}
			pstmt.clearParameters();
			
			sql="delete from groupmodifier where num = ?";
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, gdDTO.getNum());
			System.out.println(pstmt);
			pstmt.executeUpdate();
		}
		catch(Exception e){
			System.out.println("ScheduleDAO > groupData UPDATE Error : "+ e);
		}
		finally{
			close(conn, pstmt);
		}
	}
	
	public void insertMember(GroupMemberDTO gmDTO){

		String sql="select count(*) from groupmember where groupnum = ? and id = ? ";
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try{
			conn = getConnection();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, gmDTO.getGroupnum());
			pstmt.setString(2, gmDTO.getId());
			System.out.println(pstmt);
			rs = pstmt.executeQuery();
			int temp = 0;
			
			while(rs.next()) {
				temp = rs.getInt("count(*)");
			}
			pstmt.clearParameters();
			
			if(temp==0) {
				sql="insert into groupmember(groupnum, id) value (?,?)";
				pstmt = conn.prepareStatement(sql);
				pstmt.setString(1, gmDTO.getGroupnum());
				pstmt.setString(2, gmDTO.getId());
				pstmt.executeUpdate();
			}
		}
		catch(Exception e){
			System.out.println("GroupDAO > insertMember Error : "+ e);
		}
		finally{
			close(conn, pstmt);
		}
	}
	
	public void deleteMember(GroupMemberDTO gmDTO){

		String sql="select num from groupmember where id = ? and groupnum = ?";
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try{
			conn = getConnection();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, gmDTO.getId());
			pstmt.setString(2, gmDTO.getGroupnum());
			System.out.println(pstmt);
			rs = pstmt.executeQuery();
			
			while(rs.next()) {
				gmDTO.setNum(rs.getString("num"));
			}
			pstmt.clearParameters();
			
			sql="delete from groupmember where num = ?";
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, gmDTO.getNum());
			System.out.println(pstmt);
			pstmt.executeUpdate();
		}
		catch(Exception e){
			System.out.println("GroupDAO > deleteMember  Error : "+ e);
		}
		finally{
			close(conn, pstmt);
		}
	}
	//
	public List<GroupMemberDTO> selctInvite(String userKey) {
		List<GroupMemberDTO> list= new ArrayList<GroupMemberDTO>();
		String sql="select groupmember.num, groupmember.id, groupmember.groupnum, groupdata.groupname, groupmember.invite from groupmember left join groupdata on groupdata.groupnum = groupmember.groupnum where groupmember.id = ? and groupmember.invite='notaccept'";
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		
		try{
			conn = getConnection();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, userKey);
			System.out.println(pstmt);
			rs = pstmt.executeQuery();
			
			while(rs.next()) {
				GroupMemberDTO gmDTO = new GroupMemberDTO();
				gmDTO.setGroupnum(rs.getString("groupnum"));
				gmDTO.setId(rs.getString("id"));
				gmDTO.setInvite(rs.getString("invite"));
				gmDTO.setNum(rs.getString("num"));
				gmDTO.setName(rs.getString("groupname"));
				list.add(gmDTO);
			}
		}
		catch(Exception e){
			System.out.println("GroupDAO > checkHaveInvite Error : "+ e);
		}
		finally{
			close(conn, pstmt);
		}
		return list;
	}
	// 그룹 멤버 초대 수락 
	public void inviteAccept(GroupMemberDTO gmDTO) {
		String sql="update groupmember set invite = 'accept' where num = ?";
		
		Connection conn = null;
		PreparedStatement pstmt = null;
	
		try{
			conn = getConnection();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, gmDTO.getNum());
			System.out.println(pstmt);
			pstmt.executeUpdate();
		}
		catch(Exception e){
			System.out.println("GroupDAO > inviteAccept Error : "+ e);
		}
		finally{
			close(conn, pstmt);
		}
	}
	
	// 그룹 멤버 초대 거부 
	public void inviteDenied(GroupMemberDTO gmDTO) {
		String sql="delete from groupmember where num = ?";
		
		Connection conn = null;
		PreparedStatement pstmt = null;
	
		try{
			conn = getConnection();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, gmDTO.getNum());
			System.out.println(pstmt);
			pstmt.executeUpdate();
		}
		catch(Exception e){
			System.out.println("GroupDAO > inviteDenied Error : "+ e);
		}
		finally{
			close(conn, pstmt);
		}
	}
	
	// 멤버 정보를 리스트로 뽑아옴 
	// 멤버 초대 기능에 사용함 
	public List<MemberDTO> memberList(String word){
		
		String searchword = "%"+word+"%";
		List<MemberDTO> list = new ArrayList<MemberDTO>();
		
		String sql="select * from member where id like ? or name like ? limit 10";
	
		Connection conn=null;
		PreparedStatement pstmt = null;
		ResultSet rs=null;
		
		try
		{
			conn=getConnection();
			pstmt=conn.prepareStatement(sql);
			pstmt.setString(1, searchword);
			pstmt.setString(2, searchword);
			
			System.out.println(pstmt);
			rs = pstmt.executeQuery();
			
			while(rs.next())
			{
				MemberDTO mDTO = new MemberDTO();
			
				mDTO.setNum(rs.getInt("num"));
				mDTO.setId(rs.getString("id"));
				mDTO.setName(rs.getString("name"));
				mDTO.setEmail(rs.getString("email"));
				mDTO.setAuthority(rs.getString("authority"));
				
				list.add(mDTO);	
			}
		}
		catch(Exception e)
		{
			System.out.println("GroupDAO > MemberSearch (val == 2) ERROR "+e);
		}
		finally
		{
			close(conn, pstmt, rs);
		}
		
		return list;
	}
	
	public boolean checkHaveInvite(String userKey) {
		boolean alert = false;
		String sql="select count(*) from groupmember where id = ? and invite = 'notaccept'";
		int total = 0;
		
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try{
			conn = getConnection();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, userKey);
			System.out.println(pstmt);
			rs = pstmt.executeQuery();
			
			while(rs.next()) {
				total = rs.getInt("count(*)");
			}
			
			if(total>0) {
				alert = true;
			}
			else {
				alert = false;
			}

		}
		catch(Exception e){
			System.out.println("GroupDAO > checkHaveInvite Error : "+ e);
		}
		finally{
			close(conn, pstmt);
		}
		return alert;
	}
}

Select를 위한 메서드에선, DTO를 다수 사용하기 때문에 JOIN 문을 사용하여 각 메서드를 호출했다.

'프로젝트 개발기 > Status 200 ( Team Project )' 카테고리의 다른 글

11. TEAM 프로젝트: 캘린더 기능 구현 - TO DO List (0)	2021.11.15
10. TEAM 프로젝트: 캘린더 기능 구현 - 그룹 (2) (0)	2021.11.15
8. TEAM 프로젝트: 캘린더 기능 구현 - 스케줄 (2) (0)	2021.11.11
7. TEAM 프로젝트: 캘린더 기능 구현 - 스케줄 (1) (0)	2021.11.11
6. TEAM 프로젝트: 캘린더 기능 구현 - 레이아웃 기능 (0)	2021.11.11

Hyun's Developer Note

9. TEAM 프로젝트: 캘린더 기능 구현 - 그룹 (1)

1. 그룹 기능 구현

2. 기본 레이아웃

3. DTO

4. DAO

'프로젝트 개발기 > Status 200 ( Team Project )' 카테고리의 다른 글

티스토리툴바

9. TEAM 프로젝트: 캘린더 기능 구현 - 그룹 (1)

1. 그룹 기능 구현

2. 기본 레이아웃

3. DTO

4. DAO

'프로젝트 개발기 > Status 200 ( Team Project )' 카테고리의 다른 글

'프로젝트 개발기/Status 200 ( Team Project )' Related Articles

티스토리툴바