쌍용교육(JAVA)

카카오션 sql파일  시내버스 sql파일

웹소켓 방식을 쓰는 채팅기능kr.spring.websocket => SoctketHandler.java    package kr.spring.websocket;import java.util.Map;import java.util.concurrent.ConcurrentHashMap;import org.springframework.web.socket.CloseStatus;import org.springframework.web.socket.TextMessage;import org.springframework.web.socket.WebSocketSession;import org.springframework.web.socket.handler.TextWebSocketHandler;import lombok.extern..

TalkMapper.java //채팅 메시지 번호 생성 @Select("SELECT sptalk_seq.nextval FROM dual") public Integer selectTalkNum(); //채팅 메시지 등록 @Insert("INSERT INTO sptalk (talk_num,talkroom_num,mem_num,message)VALUES (#{talk_num},#{talkroom_num},#{mem_num},#{message})") public void insertTalk(TalkVO talkVO); //읽지않은 채팅 기록 저장 @Insert("INSERT INTO sptalk_read (talkroom_num,talk_num,mem_num) VALUES (#{talkroom_num},#{ta..

TalkController.java//전송된 데이터 처리 @PostMapping("/talk/talkRoomWrite") public String talkRoomSubmit(TalkRoomVO vo, HttpSession session) { log.debug("> :" + vo); MemberVO user = (MemberVO)session.getAttribute("user"); //채팅 멤버 초대 문구 설정 vo.setTalkVO(new TalkVO()); vo.getTalkVO().setMem_num(user.getMem_num()); vo.getTalkVO().setMessage(user.getId()+"님이 "); talkService.insertTalkRoom(vo);..

message.talk.js/*-------------------- * 채팅 회원 저장 *--------------------*/ let member_list = []; //채팅 회원을 저장하는 배열 //채팅방 멤버를 저장하는 배열에 정보 셋팅 //채팅방 또는 채팅 페이지를 인식해서 채팅방 멤버를 초기 셋팅 if($('#talkWrite').length>0){ //채팅방 생성 페이지 member_list = [$('#user').attr('data-id')]; console.log(member_list); }else if($('#talkDetail').length>0){ connectWebSocket(); //웹소켓 생성 member_list = $('#chat_member').text()...

채팅기능 만들기tabel.sql/*그룹채팅*/create table sptalkroom( talkroom_num number not null, basic_name varchar2(900) not null, -- 채팅 멤버를 추가할 때 채팅방 이름를 basic_name에서 가져다 씀 talkroom_date date default sysdate not null, constraint sptalkroom_pk primary key (talkroom_num));create sequence sptalkroom_seq;create table sptalk_member( talkroom_num number not null, mem_num number not null, room_name varchar2(90..