https://nowonbun.tistory.com/285
[Java] Servlet에서 사용하는 웹 소켓 (WebSocket)
안녕하세요. 명월입니다. 이 글은 Java의 Servlet에서 사용하는 웹 소켓 (WebSocket) 에 대한 글입니다. 보통의 웹 환경은 브라우저(클라이언트)에서 웹 서버에 Html 문서를 요청하면, 웹 서버는 Html를 작
nowonbun.tistory.com
| 200625 (0) | 2020.06.25 |
|---|---|
| ajax 데이터 전송할 때 자바에서 받는 방법 (0) | 2020.06.19 |
| 블로그에 네이버 로그인 api 넣기 (0) | 2020.06.18 |
| 카카오 로그인 api (0) | 2020.06.17 |
| 야구 선수 게시판 예제 만들기 (2) | 2020.06.16 |
<div class="container-fluid">
<h3>기존 데이터 미리보기</h3>
<table class="table table-bordered">
<thead>
<tr>
<th>과정명</th>
<th>일자</th>
<th>요일</th>
<th>교시</th>
<th>수업시작</th>
<th>수업종료</th>
<th>과목</th>
<th>부과목</th>
<th>교사</th>
<th>호실</th>
</tr>
</thead>
<tbody>
<c:forEach var="pt" items="${pts }">
<tr>
<td>${pt.className }</td>
<td>${pt.classDate }</td>
<td>${pt.dayWeek }</td>
<td>${pt.classTime }</td>
<td>${pt.startTime }</td>
<td>${pt.endTime }</td>
<td>${pt.subject1 }</td>
<td>${pt.subject2 }</td>
<td>${pt.prof }</td>
<td>${pt.room }</td>
</tr>
</c:forEach>
</tbody>
</table>
</div>| 자바 웹소켓 기초 (0) | 2020.06.25 |
|---|---|
| ajax 데이터 전송할 때 자바에서 받는 방법 (0) | 2020.06.19 |
| 블로그에 네이버 로그인 api 넣기 (0) | 2020.06.18 |
| 카카오 로그인 api (0) | 2020.06.17 |
| 야구 선수 게시판 예제 만들기 (2) | 2020.06.16 |
ajax
get방식으로 보낼 때
1. 주소에 값 넣어서 보내기(getParameter)
2. data에자바스크립트객체를 담아서 보내기(getParameter)
3. data에 "key=value&key=value"로 보내기(getParameter)
post방식으로 보낼 때
1. 주소에 값 넣어서 보내기(getParameter)
2. data에 자바스크립트객체를 담아서 보내기(getParameter)
3. data에 JSON.stringify(자바스크립트객체)를 보내기(버퍼)
4. data에 문자열 보내기(버퍼)
| 자바 웹소켓 기초 (0) | 2020.06.25 |
|---|---|
| 200625 (0) | 2020.06.25 |
| 블로그에 네이버 로그인 api 넣기 (0) | 2020.06.18 |
| 카카오 로그인 api (0) | 2020.06.17 |
| 야구 선수 게시판 예제 만들기 (2) | 2020.06.16 |
https://developers.naver.com/products/login/api/
네이버 아이디로 로그인 소개
네이버 아이디로 로그인 별도의 아이디, 비밀번호없이 네이버 아이디로 간편하게 외부 서비스에 로그인 할 수 있도록 하는 서비스입니다. 이용자는 복잡하고 번거로운 회원 가입 절차 없이 편��
developers.naver.com
버튼 다운로드
https://developers.naver.com/docs/login/bi/
네이버아이디로로그인 로그인 버튼 사용 가이드
NAVER Developers - 네이버아이디로로그인 로그인 버튼 사용 가이드
developers.naver.com
Web 애플리케이션
Web 애플리케이션
developers.naver.com
https://developers.naver.com/docs/login/profile/
네이버아이디로로그인 회원 프로필 조회 가이드
NAVER Developers - 네이버아이디로로그인 회원 프로필 조회 가이드
developers.naver.com
| 200625 (0) | 2020.06.25 |
|---|---|
| ajax 데이터 전송할 때 자바에서 받는 방법 (0) | 2020.06.19 |
| 카카오 로그인 api (0) | 2020.06.17 |
| 야구 선수 게시판 예제 만들기 (2) | 2020.06.16 |
| 이클립스 eclipse sts툴 java / html / javascript / jsp 자동완성 (2) | 2020.06.16 |
카카오 로그인 목적
1. 인증
블로그 만드는 것보다 인증절차가 더 복잡한데, 그런 것을 카카오 로그인에서 대신해준다.
2.인증 + 사용자 정보
1. 유저가 블로그 서버에 카카오 로그인 요청
2. 카카오 로그인창에서 로그인
3. 카카오 api서버(+리소스서버)에서 인증을 하여 블로그 서버로 인증결과(코드)를 반환
4. 유저가 정보를 제공하지 않겠다면 코드를 블로그 서버로 주고 과정이 끝나고,
5. 유저 정보를 제공하겠다고 체크하면 다시 카카오 서버로 통신하여 토큰을 받아온다.
6. 토큰을 이용하면 블로그 서버에서 바로 리소스 서버로 유저정보 요청이 가능해진다.
7. 리소스 서버에서 가져온 회원정보가 블로그 회원가입 테이블 조건에 부적합하다면
인증만 된 상태에서 회원가입을 따로 시켜야한다.
적합하다면 바로 로그인 시키면 된다.
-----------------카카오 입장에서 보았을 때------------------
유저(웹브라우저) = 리소스 오너
블로그 = 클라이언트
카카오api = api 인터페이스 서버
리소스 서버
카카오 개발자 사이트 접속
내 애플리케이션에서 애플리케이션 추가를 클릭
앱키의 종류
내 사이트 주소 설정
웹
주소입력
카카오 로그인 활성화
요청주소 등록
주소를 설정해준다
로그아웃 요청
동의항목 설정
문서를 읽어본다
https://developers.kakao.com/docs/latest/ko/kakaologin/rest-api#request-code
Kakao Developers
카카오 API를 활용하여 다양한 어플리케이션을 개발해보세요. 카카오 로그인, 메시지 보내기, 친구 API, 인공지능 API 등을 제공합니다.
developers.kakao.com
GET /oauth/authorize?client_id={app_key}&redirect_uri={redirect_uri}&response_type=code HTTP/1.1
Host: kauth.kakao.com
app_key
redirect_uri
https://kauth.kakao.com/oauth/authorize?client_id=아이디&redirect_uri=http://localhost:8000/blog/oauth/kakao?cmd=callback&response_type=code
결과가 뜸
보내면
클라이언트ID
콜백주소
response_type : code
eamil
profile (사진, 닉네임)
유저ID, 비밀번호
package com.cos.blog.controller;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.cos.blog.action.Action;
import com.cos.blog.action.kakao.KakaoCallbackAction;
// http://localhost:8000/blog/board
@WebServlet("/oauth/kakao")
public class KakaoController extends HttpServlet {
private final static String TAG = "BoardController : ";
private static final long serialVersionUID = 1L;
public KakaoController() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doProcess(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doProcess(request, response);
}
protected void doProcess(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// http://localhost:8000/blog/user?cmd=join
String cmd = request.getParameter("cmd");
System.out.println(TAG+"router : "+cmd);
Action action = router(cmd);
action.execute(request, response);
}
public Action router(String cmd) {
if(cmd.equals("callback")) {
return new KakaoCallbackAction();
}
return null;
}
}
package com.cos.blog.action.kakao;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.cos.blog.action.Action;
public class KakaoCallbackAction implements Action{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String code = request.getParameter("code");
System.out.println("카카오 인증 완료됨");
System.out.println(code);
}
}
POST /oauth/token HTTP/1.1
Host: kauth.kakao.com
Content-type: application/x-www-form-urlencoded;charset=utf-8kauth.kakao.com/oauth/token 포스트타입
HTTP 1.1 = get post put delete 다가능
Content-type: application/x-www-form-urlencoded;charset=utf-8 타입으로 보내라는 뜻
body에 담겨야할 값
grant_type=authorization_code
client_id=내 restapi 키
redirect_uri=http://localhost:8000/blog/oauth/kakao?cmd=callback
code=리턴받은 코드
-------------------------------
리턴받은 내용을 자동으로 파싱해주는 라이브러리
resttemplate - object wrapper
retrofit2 - gson - 인기 많음
okhttp
volly
-----------------------
httpurlconnection
--------------------------
유저정보 가져오기
https://developers.kakao.com/docs/latest/ko/user-mgmt/rest-api
Kakao Developers
카카오 API를 활용하여 다양한 어플리케이션을 개발해보세요. 카카오 로그인, 메시지 보내기, 친구 API, 인공지능 API 등을 제공합니다.
developers.kakao.com
| ajax 데이터 전송할 때 자바에서 받는 방법 (0) | 2020.06.19 |
|---|---|
| 블로그에 네이버 로그인 api 넣기 (0) | 2020.06.18 |
| 야구 선수 게시판 예제 만들기 (2) | 2020.06.16 |
| 이클립스 eclipse sts툴 java / html / javascript / jsp 자동완성 (2) | 2020.06.16 |
| product 페이지 예제 만들기 (0) | 2020.06.15 |
팀목록 테이블
CREATE TABLE TEAMLIST
(
ID NUMBER NOT NULL
, TEAMNAME VARCHAR2(50)
, CONSTRAINT TEAMLIST_PK PRIMARY KEY
(
ID
)
ENABLE
);
ALTER TABLE TEAMLIST
ADD CONSTRAINT TEAMLIST_UK1 UNIQUE
(
TEAMNAME
)
ENABLE;
선수목록 테이블
CREATE TABLE PLAYERLIST
(
ID NUMBER NOT NULL
, PLAYERNUM NUMBER
, PLAYERNAME VARCHAR2(20)
, POSITION VARCHAR2(20)
, TEAMNAME VARCHAR2(50)
, CONSTRAINT PLAYERLIST_PK PRIMARY KEY
(
ID
)
ENABLE
);
ALTER TABLE PLAYERLIST
ADD CONSTRAINT PLAYERLIST_FK1 FOREIGN KEY
(
TEAMNAME
)
REFERENCES TEAMLIST
(
TEAMNAME
)
ON DELETE SET NULL ENABLE;
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
response.sendRedirect("/baseball/team?cmd=home");
%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html lang="en">
<head>
<title>야구선수 정보</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-sm-3">
<h2>팀 목록</h2>
<table class="table table-hover">
<thead>
<tr>
<th>번호</th>
<th>팀 이름</th>
</tr>
</thead>
<tbody>
<c:forEach var="team" items="${teamList}">
<tr>
<td>${team.id}</td>
<td onclick="getPlayer('${team.teamName}')" style="cursor: pointer;">${team.teamName}</td>
</tr>
</c:forEach>
</tbody>
</table>
</div>
<div class="col-sm-3">
<h2>선수 목록</h2>
<table class="table table-success">
<thead>
<tr>
<th>선수 번호</th>
<th>선수 이름</th>
</tr>
</thead>
<tbody id="player__list">
</tbody>
</table>
</div>
<div class="col-sm-6">
<h2>선수 상세</h2>
<table class="table table-info">
<thead>
<tr>
<th>선수 번호</th>
<th>선수 이름</th>
<th>포지션</th>
</tr>
</thead>
<tbody id="player__desc">
</tbody>
</table>
</div>
</div>
</div>
<script type="text/javascript">
function getPlayer(teamName) {
$.ajax({
type: "get",
url: "/baseball/player?cmd=getPlayer&teamName="+teamName,
dataType: "json"
}).done(function(result) {
$("#player__list").empty();
for (let player of result) {
var string =
" <tr>\r\n" +
" <td>"+player.playerNum+"</td>\r\n" +
" <td onclick=\"getDesc('"+player.playerNum+"','"+teamName+"')\" style=\"cursor: pointer;\">"+player.playerName+"</td>\r\n" +
" </tr>";
$("#player__list").append(string);
}
$("#player__desc").empty();
}).fail(function(result) {
alert("검색에 실패하였습니다.");
});
}
function getDesc(playerNum, teamName) {
$.ajax({
type: "get",
url: "/baseball/player?cmd=getDesc&teamName="+teamName+"&playerNum="+playerNum,
dataType: "json"
}).done(function(result) {
$("#player__desc").empty();
var string =
" <tr>\r\n" +
" <td>"+result.playerNum+"</td>\r\n" +
" <td>"+result.playerName+"</td>\r\n" +
" <td>"+result.position+"</td>\r\n" +
" </tr>";
$("#player__desc").append(string);
}).fail(function(result) {
alert("검색에 실패하였습니다.");
});
}
</script>
</body>
</html>
package com.jaybon.baseball.db;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class DBConn {
public static Connection getConnection() {
try {
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/env");
DataSource ds = (DataSource) envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
PreparedStatement pstmt;
ResultSet rs;
System.out.println("DBConn : 데이터베이스 연결성공");
return conn;
} catch (Exception e) {
e.printStackTrace();
System.out.println("DBConn : 데이터베이스 연결실패");
System.out.println("DBConn : Message : " + e.getMessage());
}
return null;
}
public static void close(Connection conn, PreparedStatement pstmt) {
try {
conn.close();
pstmt.close();
} catch (Exception e) {
System.out.println("DB종료시 오류가 발생 : " + e.getMessage());
}
}
public static void close(Connection conn, PreparedStatement pstmt, ResultSet rs) {
try {
conn.close();
pstmt.close();
rs.close();
} catch (Exception e) {
System.out.println("DB종료시 오류가 발생 : " + e.getMessage());
}
}
}
package com.jaybon.baseball.model;
import lombok.Builder;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class Player {
int id;
int playerNum;
String playerName;
String position;
String teamName;
}
package com.jaybon.baseball.model;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class Team {
int id;
String teamName;
}
package com.jaybon.baseball.repository;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.jaybon.baseball.db.DBConn;
import com.jaybon.baseball.model.Team;
public class TeamRepository {
private static final String TAG = "TeamListRepository : "; // TAG 생성 (오류 발견시 용이)
private static TeamRepository instance = new TeamRepository();
private TeamRepository() {
}
public static TeamRepository getInstance() {
return instance;
}
private Connection conn = null;
private PreparedStatement pstmt = null;
private ResultSet rs = null;
public List<Team> findAll() { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "SELECT id, teamname FROM teamlist ORDER BY id asc";
List<Team> teamList = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
rs = pstmt.executeQuery();
if(rs.next()) {
teamList = new ArrayList<>();
Team team = Team.builder()
.id(rs.getInt(1))
.teamName(rs.getString(2))
.build();
teamList.add(team);
while (rs.next()) {
Team team1 = Team.builder()
.id(rs.getInt(1))
.teamName(rs.getString(2))
.build();
teamList.add(team1);
}
}
return teamList;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "findAll : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return null; // 실패시
}
}
package com.jaybon.baseball.repository;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.jaybon.baseball.db.DBConn;
import com.jaybon.baseball.model.Player;
public class PlayerRepository {
private static final String TAG = "PlayerListRepository : "; // TAG 생성 (오류 발견시 용이)
private static PlayerRepository instance = new PlayerRepository();
private PlayerRepository() {
}
public static PlayerRepository getInstance() {
return instance;
}
private Connection conn = null;
private PreparedStatement pstmt = null;
private ResultSet rs = null;
public List<Player> findPlayerNumNameFromTeam(String teamName) { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "SELECT playernum, playername FROM playerlist WHERE teamname like ? ORDER BY playernum asc";
List<Player> playerList = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
pstmt.setString(1, teamName);
rs = pstmt.executeQuery();
if(rs.next()) {
playerList = new ArrayList<>();
Player player = Player.builder()
.playerNum(rs.getInt(1))
.playerName(rs.getString(2))
.build();
playerList.add(player);
while (rs.next()) {
Player player1 = Player.builder()
.playerNum(rs.getInt(1))
.playerName(rs.getString(2))
.build();
playerList.add(player1);
}
}
return playerList;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "findPlayerNumNameFromTeam : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return null; // 실패시
}
public Player findPlayerDesc(String teamName, int playerNum) { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "SELECT playernum, playername, position FROM playerlist WHERE teamname like ? and playernum = ?";
Player player = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
pstmt.setString(1, teamName);
pstmt.setInt(2, playerNum);
rs = pstmt.executeQuery();
if(rs.next()) {
player = Player.builder()
.playerNum(rs.getInt(1))
.playerName(rs.getString(2))
.position(rs.getString(3))
.build();
}
return player;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "findDesc : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return null; // 실패시
}
}
package com.jaybon.baseball.action;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public interface Action {
public void execute(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException;
}
package com.jaybon.baseball.action.team;
import java.io.IOException;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.google.gson.Gson;
import com.jaybon.baseball.action.Action;
import com.jaybon.baseball.model.Team;
import com.jaybon.baseball.repository.TeamRepository;
public class TeamHomeAction implements Action{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
TeamRepository teamRepository = TeamRepository.getInstance();
List<Team> teamList = teamRepository.findAll();
request.setAttribute("teamList", teamList);
RequestDispatcher rd = request.getRequestDispatcher("home.jsp");
rd.forward(request, response);
}
}
package com.jaybon.baseball.action.player;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.google.gson.Gson;
import com.jaybon.baseball.action.Action;
import com.jaybon.baseball.model.Player;
import com.jaybon.baseball.repository.PlayerRepository;
public class PlayerGetPlayerAction implements Action{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String teamName = request.getParameter("teamName");
PlayerRepository playerRepository = PlayerRepository.getInstance();
List<Player> playerList = playerRepository.findPlayerNumNameFromTeam(teamName);
Gson gson = new Gson();
String playerListJson = gson.toJson(playerList);
response.setCharacterEncoding("utf-8");
response.setContentType("application/json; charset=utf-8");
PrintWriter pw = response.getWriter();
pw.println(playerListJson);
}
}
package com.jaybon.baseball.action.player;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.google.gson.Gson;
import com.jaybon.baseball.action.Action;
import com.jaybon.baseball.model.Player;
import com.jaybon.baseball.repository.PlayerRepository;
public class PlayerGetDescAction implements Action{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String teamName = request.getParameter("teamName");
int playerNum = Integer.parseInt(request.getParameter("playerNum"));
PlayerRepository playerRepository = PlayerRepository.getInstance();
Player player = playerRepository.findPlayerDesc(teamName, playerNum);
Gson gson = new Gson();
String playerJson = gson.toJson(player);
response.setCharacterEncoding("utf-8");
response.setContentType("application/json; charset=utf-8");
PrintWriter pw = response.getWriter();
pw.println(playerJson);
}
}
package com.jaybon.baseball.controller;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.jaybon.baseball.action.Action;
import com.jaybon.baseball.action.team.TeamHomeAction;
// http://localhost:8000/blog/user
@WebServlet("/team")
public class TeamController extends HttpServlet {
private final static String TAG = "BaseballController : ";
private static final long serialVersionUID = 1L;
public TeamController() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doProcess(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doProcess(request, response);
}
protected void doProcess(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// http://localhost:8000/product/user?cmd=test
String cmd = request.getParameter("cmd");
System.out.println(TAG + "router : " + cmd);
Action action = router(cmd);
action.execute(request, response);
}
public Action router(String cmd) {
if (cmd.equals("home")) {
return new TeamHomeAction();
}
return null;
}
}
package com.jaybon.baseball.controller;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.jaybon.baseball.action.Action;
import com.jaybon.baseball.action.player.PlayerGetDescAction;
import com.jaybon.baseball.action.player.PlayerGetPlayerAction;
// http://localhost:8000/blog/user
@WebServlet("/player")
public class PlayerController extends HttpServlet {
private final static String TAG = "PlayerController : ";
private static final long serialVersionUID = 1L;
public PlayerController() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doProcess(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doProcess(request, response);
}
protected void doProcess(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// http://localhost:8000/product/user?cmd=test
String cmd = request.getParameter("cmd");
System.out.println(TAG + "router : " + cmd);
Action action = router(cmd);
action.execute(request, response);
}
public Action router(String cmd) {
if (cmd.equals("getPlayer")) {
return new PlayerGetPlayerAction();
} else if (cmd.equals("getDesc")) {
return new PlayerGetDescAction();
}
return null;
}
}
| 블로그에 네이버 로그인 api 넣기 (0) | 2020.06.18 |
|---|---|
| 카카오 로그인 api (0) | 2020.06.17 |
| 이클립스 eclipse sts툴 java / html / javascript / jsp 자동완성 (2) | 2020.06.16 |
| product 페이지 예제 만들기 (0) | 2020.06.15 |
| 블로그 댓글 지우기 (0) | 2020.06.15 |
1. 자바
Auto Activation에서
딜레이를 0으로
triggers를 마침표(.)와 모든 영어 소문자를 넣어준다
그리고 엔터를 칠 경우에만 자동완성 해주도록 세팅
2. HTML
자바와 비슷하게 세팅
(제이쿼리를 사용하려면 $ . 등을 더 추가하고 대문자도 넣고 싶으면 넣어도 된다)
3. 자바스크립트
위와 같이 세팅해주고
마켓에서
Eclipse Enterprise Java Developer Tools
인스톨 해준다.(설치가 완료되고도 오른쪽 하단에 백그라운드로 설치되는 경우가 있다. 기다리자.)
이것만 설치해도 function() 등 기본적인 템플레이트가 뜬다
http://blog.naver.com/njw1204/221654918683
이클립스에서 자바스크립트 및 jQuery 자동 완성 사용하기 (Tern Eclipse IDE)
이클립스에서 웹 프론트엔드 개발을 할 때 불편한 점이 몇 개 있는데요.그것 중에 하나가 자바스크립트의 ...
blog.naver.com
위의 링크내용대로tern 도 설치해준다.
github.com/angelozerr/tern.java/releases/download/tern.java-1.2.1/tern.repository-1.2.1.zip
프로젝트를 Tern Project로 변경한다
프로젝트 프로퍼티스에서 아래와같이 체크해준다
툴 프리퍼런스에서 자바스크립트 설정을 추가적으로 해준다
자바스크립트 자동완성 추천 세팅
결과
tern이 안될 경우 아래 사이트 참고
https://blog.naver.com/sulin00/221733387006
이클립스에서 자바스크립트 자동완성 플러그인(무료): Wild Web Developer (구 Tern)
이클립스에서 자바스크립트 자동완성 기능 사용하기. --------------------------------------------- 결론...
blog.naver.com
| 카카오 로그인 api (0) | 2020.06.17 |
|---|---|
| 야구 선수 게시판 예제 만들기 (2) | 2020.06.16 |
| product 페이지 예제 만들기 (0) | 2020.06.15 |
| 블로그 댓글 지우기 (0) | 2020.06.15 |
| get / post 방식 (0) | 2020.06.12 |
기본 구조 세팅은 blog 만들기에서 가져왔다
물건 타입을 설정하는 테이블
CREATE TABLE PRODUCTTYPE
(
PTYPE VARCHAR2(100) NOT NULL
, CONSTRAINT PRODUCTTYPE_PK PRIMARY KEY
(
PTYPE
)
ENABLE
);
product테이블
CREATE TABLE PRODUCT
(
ID NUMBER NOT NULL
, NAME VARCHAR2(100)
, TYPE VARCHAR2(100)
, PRICE NUMBER
, COUNT NUMBER
, CONSTRAINT PRODUCT_PK PRIMARY KEY
(
ID
)
ENABLE
);
ALTER TABLE PRODUCT
ADD CONSTRAINT PRODUCT_FK1 FOREIGN KEY
(
TYPE
)
REFERENCES PRODUCTTYPE
(
PTYPE
)
ON DELETE SET NULL ENABLE;type는 producttype의 값을 외래키로 가진다
(producttype 튜플이 삭제되면 해당 타입은 널값이된다)
시퀀스
CREATE SEQUENCE PRODUCT_SEQ INCREMENT BY 1 START WITH 1;
package com.jaybon.product.db;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class DBConn {
public static Connection getConnection() {
try {
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/env");
DataSource ds = (DataSource) envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
PreparedStatement pstmt;
ResultSet rs;
System.out.println("DBConn : 데이터베이스 연결성공");
return conn;
} catch (Exception e) {
e.printStackTrace();
System.out.println("DBConn : 데이터베이스 연결실패");
System.out.println("DBConn : Message : " + e.getMessage());
}
return null;
}
public static void close(Connection conn, PreparedStatement pstmt) {
try {
conn.close();
pstmt.close();
} catch (Exception e) {
System.out.println("DB종료시 오류가 발생 : " + e.getMessage());
}
}
public static void close(Connection conn, PreparedStatement pstmt, ResultSet rs) {
try {
conn.close();
pstmt.close();
rs.close();
} catch (Exception e) {
System.out.println("DB종료시 오류가 발생 : " + e.getMessage());
}
}
}
package com.jaybon.product.model;
public enum ProductType {
과일, 문구, 옷
}
action 인터페이스
package com.jaybon.product.action;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public interface Action {
public void execute(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException;
}
ProductTestAction
package com.jaybon.product.action.product;
import java.io.IOException;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.jaybon.product.action.Action;
import com.jaybon.product.model.Product;
import com.jaybon.product.repository.ProductRepository;
public class ProductTestAction implements Action{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
System.out.println("ProductTestAction");
ProductRepository productRepository = ProductRepository.getInstance();
List<Product> products = productRepository.findAll();
request.setAttribute("products", products);
System.out.println("홈페이지 이동합니다.");
RequestDispatcher rd = request.getRequestDispatcher("home.jsp");
rd.forward(request, response);
}
}
ProductGoFirstProcAction
package com.jaybon.product.action.product;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.google.gson.Gson;
import com.jaybon.product.action.Action;
import com.jaybon.product.model.Product;
import com.jaybon.product.repository.ProductRepository;
public class ProductGoFirstProcAction implements Action{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Gson gson = new Gson();
ProductRepository productRepository = ProductRepository.getInstance();
List<Product> products = productRepository.findAll();
String productsJson = gson.toJson(products);
response.setCharacterEncoding("utf-8");
response.setContentType("application/json; charser=utf-8");
PrintWriter pw = response.getWriter();
pw.println(productsJson);
}
}
ProductPriceAscProcAction
package com.jaybon.product.action.product;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.google.gson.Gson;
import com.jaybon.product.action.Action;
import com.jaybon.product.model.Product;
import com.jaybon.product.repository.ProductRepository;
public class ProductPriceAscProcAction implements Action{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Gson gson = new Gson();
ProductRepository productRepository = ProductRepository.getInstance();
List<Product> products = productRepository.findAllPriceAsc();
String productsJson = gson.toJson(products);
response.setCharacterEncoding("utf-8");
response.setContentType("application/json; charser=utf-8");
PrintWriter pw = response.getWriter();
pw.println(productsJson);
}
}
ProductPriceDescProcAction
package com.jaybon.product.action.product;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.google.gson.Gson;
import com.jaybon.product.action.Action;
import com.jaybon.product.model.Product;
import com.jaybon.product.repository.ProductRepository;
public class ProductPriceDescProcAction implements Action{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Gson gson = new Gson();
ProductRepository productRepository = ProductRepository.getInstance();
List<Product> products = productRepository.findAllPriceDesc();
String productsJson = gson.toJson(products);
response.setCharacterEncoding("utf-8");
response.setContentType("application/json; charser=utf-8");
PrintWriter pw = response.getWriter();
pw.println(productsJson);
}
}
ProductCountDescProcAction
package com.jaybon.product.action.product;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.google.gson.Gson;
import com.jaybon.product.action.Action;
import com.jaybon.product.model.Product;
import com.jaybon.product.repository.ProductRepository;
public class ProductCountDescProcAction implements Action{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Gson gson = new Gson();
ProductRepository productRepository = ProductRepository.getInstance();
List<Product> products = productRepository.findAllCountDesc();
String productsJson = gson.toJson(products);
response.setCharacterEncoding("utf-8");
response.setContentType("application/json; charser=utf-8");
PrintWriter pw = response.getWriter();
pw.println(productsJson);
}
}
ProductDeleteProcAction
package com.jaybon.product.action.product;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.google.gson.Gson;
import com.jaybon.product.action.Action;
import com.jaybon.product.model.Product;
import com.jaybon.product.repository.ProductRepository;
public class ProductDeleteProcAction implements Action{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int productId = Integer.parseInt(request.getParameter("productId"));
ProductRepository productRepository = ProductRepository.getInstance();
int result = productRepository.deleteById(productId);
if(result == 1) {
List<Product> products = productRepository.findAll();
Gson gson = new Gson();
String productsJson = gson.toJson(products);
response.setCharacterEncoding("utf-8");
response.setContentType("application/json; charser=utf-8");
PrintWriter pw = response.getWriter();
pw.println(productsJson);
}
}
}
package com.jaybon.product.controller;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.jaybon.product.action.Action;
import com.jaybon.product.action.product.ProductCountDescProcAction;
import com.jaybon.product.action.product.ProductDeleteProcAction;
import com.jaybon.product.action.product.ProductGoFirstProcAction;
import com.jaybon.product.action.product.ProductPriceAscProcAction;
import com.jaybon.product.action.product.ProductPriceDescProcAction;
import com.jaybon.product.action.product.ProductTestAction;
// http://localhost:8000/blog/user
@WebServlet("/test")
public class ProductController extends HttpServlet {
private final static String TAG = "ProductController : ";
private static final long serialVersionUID = 1L;
public ProductController() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doProcess(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doProcess(request, response);
}
protected void doProcess(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// http://localhost:8000/product/user?cmd=test
String cmd = request.getParameter("cmd");
System.out.println(TAG + "router : " + cmd);
Action action = router(cmd);
action.execute(request, response);
}
public Action router(String cmd) {
if (cmd.equals("home")) {
return new ProductTestAction();
} else if (cmd.equals("goFirstProc")) {
return new ProductGoFirstProcAction();
} else if (cmd.equals("priceAscProc")) {
return new ProductPriceAscProcAction();
} else if (cmd.equals("priceDescProc")) {
return new ProductPriceDescProcAction();
} else if (cmd.equals("countDescProc")) {
return new ProductCountDescProcAction();
} else if (cmd.equals("deleteProc")) {
return new ProductDeleteProcAction();
}
return null;
}
}
package com.jaybon.product.repository;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.jaybon.product.db.DBConn;
import com.jaybon.product.model.Product;
import com.jaybon.product.model.ProductType;
public class ProductRepository {
private static final String TAG = "ProductRepository : "; // TAG 생성 (오류 발견시 용이)
private static ProductRepository instance = new ProductRepository();
private ProductRepository() {
}
public static ProductRepository getInstance() {
return instance;
}
private Connection conn = null;
private PreparedStatement pstmt = null;
private ResultSet rs = null;
public int deleteById(int id) {
final String SQL = "DELETE FROM product WHERE id =?";
List<Product> products = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
pstmt.setInt(1, id);
int result = pstmt.executeUpdate();
return result;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "deleteById : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return -1; // 실패시
}
// product 다찾기
public List<Product> findAll() { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "SELECT id, name, type, price, count FROM product ORDER BY id asc";
List<Product> products = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
rs = pstmt.executeQuery();
if(rs.next()) {
products = new ArrayList<>();
Product product = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product);
while (rs.next()) {
Product product1 = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product1);
}
}
return products;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "findAll : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return null; // 실패시
}
public List<Product> findAllPriceAsc() { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "SELECT id, name, type, price, count FROM product ORDER BY Price ASC";
List<Product> products = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
rs = pstmt.executeQuery();
if(rs.next()) {
products = new ArrayList<>();
Product product = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product);
while (rs.next()) {
Product product1 = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product1);
}
}
return products;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "findAll : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return null; // 실패시
}
public List<Product> findAllPriceDesc() { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "SELECT id, name, type, price, count FROM product ORDER BY Price DESC";
List<Product> products = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
rs = pstmt.executeQuery();
if(rs.next()) {
products = new ArrayList<>();
Product product = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product);
while (rs.next()) {
Product product1 = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product1);
}
}
return products;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "findAll : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return null; // 실패시
}
public List<Product> findAllCountDesc() { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "SELECT id, name, type, price, count FROM product ORDER BY count DESC";
List<Product> products = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
rs = pstmt.executeQuery();
if(rs.next()) {
products = new ArrayList<>();
Product product = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product);
while (rs.next()) {
Product product1 = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product1);
}
}
return products;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "findAll : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return null; // 실패시
}
}
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
response.sendRedirect("/product/test?cmd=home");
%>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bootstrap Example</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<h2>Product</h2>
<p>The .table-striped class adds zebra-stripes to a table:</p>
<div class="btn-group">
<button onclick="goFirst()" type="button" class="btn btn-primary">처음으로</button>
<button onclick="priceAsc()" type="button" class="btn btn-success">가격 오름차순</button>
<button onclick="priceDesc()" type="button" class="btn btn-warning">가격 내림차순</button>
<button onclick="countDesc()" type="button" class="btn btn-danger">판매순</button>
</div>
<table class="table table-striped">
<thead>
<tr>
<th>번호</th>
<th>이름</th>
<th>종류</th>
<th>가격</th>
<th>판매수</th>
<th> </th>
</tr>
</thead>
<tbody id="my__tbody">
<c:forEach var="product" items="${products}">
<tr id="product-${product.id}">
<td>${product.id}</td>
<td>${product.name}</td>
<td>${product.type}</td>
<td>${product.price}</td>
<td>${product.count}</td>
<td><i class="large material-icons" onclick="deleteItem(${product.id})" style="cursor:pointer;">delete_forever</i></td>
</tr>
</c:forEach>
</tbody>
</table>
</div>
<script>
function append(result) {
for (var product of result){
var string =
" <tr id=\"product-"+product.id+"\">\r\n" +
" <td>"+product.id+"</td>\r\n" +
" <td>"+product.name+"</td>\r\n" +
" <td>"+product.type+"</td>\r\n" +
" <td>"+product.price+"</td>\r\n" +
" <td>"+product.count+"</td>\r\n" +
" <td><i class=\"large material-icons\" onclick=\"deleteItem("+product.id+")\" style=\"cursor:pointer;\">delete_forever</i></td>" +
" </tr>";
$('#my__tbody').append(string);
}
}
function deleteItem(productId) {
console.log(productId);
$.ajax({
type : "get",
url : "/product/test?cmd=deleteProc&productId="+productId,
dataType : "json"
}).done(function (result) {
$("#my__tbody").empty();
alert("삭제에 성공하였습니다.");
append(result);
}).fail(function (result) {
alert("삭제에 실패하였습니다.");
});
}
function goFirst() {
$.ajax({
type : "get",
url : "/product/test?cmd=goFirstProc",
dataType : "json"
}).done(function (result) {
$("#my__tbody").empty();
append(result);
}).fail(function (result) {
});
}
function priceAsc() {
$.ajax({
type : "get",
url : "/product/test?cmd=priceAscProc",
dataType : "json"
}).done(function (result) {
$("#my__tbody").empty();
append(result);
}).fail(function (result) {
});
}
function priceDesc() {
$.ajax({
type : "get",
url : "/product/test?cmd=priceDescProc",
dataType : "json"
}).done(function (result) {
$("#my__tbody").empty();
append(result);
}).fail(function (result) {
});
}
function countDesc() {
$.ajax({
type : "get",
url : "/product/test?cmd=countDescProc",
dataType : "json"
}).done(function (result) {
$("#my__tbody").empty();
append(result);
}).fail(function (result) {
});
}
</script>
</body>
</html>
home.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Product</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<h2>Product</h2>
<form action="/product/test?cmd=insertItem" method="post">
<div class="input-group mb-3">
<div class="input-group-prepend">
<span class="input-group-text">아이템 추가</span>
</div>
<input name="productName" type="text" class="form-control" placeholder="이름" required="required">
<select name='productType' size='1' required="required">
<option value='' selected>종류선택</option>
<option value='옷'>옷</option>
<option value='과일'>과일</option>
<option value='문구'>문구</option>
</select>
<input name="productPrice" type="text" class="form-control" placeholder="가격" required="required">
<input name="productCount" type="text" class="form-control" placeholder="판매수" required="required">
<button type="submit">추가하기</button>
</div>
</form>
<div class="btn-group">
<button onclick="goFirst()" type="button" class="btn btn-primary">처음으로</button>
<button onclick="priceAsc()" type="button" class="btn btn-success">가격 오름차순</button>
<button onclick="priceDesc()" type="button" class="btn btn-warning">가격 내림차순</button>
<button onclick="countDesc()" type="button" class="btn btn-danger">판매순</button>
</div>
<table class="table table-striped">
<thead>
<tr>
<th>번호</th>
<th>이름</th>
<th>종류</th>
<th>가격</th>
<th>판매수</th>
<th> </th>
</tr>
</thead>
<tbody id="my__tbody">
<c:forEach var="product" items="${products}">
<tr id="product-${product.id}">
<td>${product.id}</td>
<td>${product.name}</td>
<td>${product.type}</td>
<td>${product.price}</td>
<td>${product.count}</td>
<td><i class="large material-icons" onclick="deleteItem(${product.id}, 'goFirst')" style="cursor:pointer;">delete_forever</i></td>
</tr>
</c:forEach>
</tbody>
</table>
</div>
<script>
function append(result, listType) {
for (var product of result){
var string =
" <tr id=\"product-"+product.id+"\">\r\n" +
" <td>"+product.id+"</td>\r\n" +
" <td>"+product.name+"</td>\r\n" +
" <td>"+product.type+"</td>\r\n" +
" <td>"+product.price+"</td>\r\n" +
" <td>"+product.count+"</td>\r\n" +
" <td><i class=\"large material-icons\" onclick=\"deleteItem("+product.id+")\" style=\"cursor:pointer;\">delete_forever</i></td>" +
" </tr>";
$('#my__tbody').append(string);
}
}
function deleteItem(productId) {
console.log(productId);
$.ajax({
type : "get",
url : "/product/test?cmd=deleteProc&productId="+productId,
dataType : "json"
}).done(function (result) {
if(result == "1"){
$("#product-"+productId).remove();
alert("삭제에 성공하였습니다.");
} else{
alert("삭제에 실패하였습니다.");
}
// $("#my__tbody").empty();
// append(result);
}).fail(function (result) {
alert("삭제에 실패하였습니다.");
});
}
function goFirst() {
$.ajax({
type : "get",
url : "/product/test?cmd=goFirstProc",
dataType : "json"
}).done(function (result) {
$("#my__tbody").empty();
append(result);
}).fail(function (result) {
});
}
function priceAsc() {
$.ajax({
type : "get",
url : "/product/test?cmd=priceAscProc",
dataType : "json"
}).done(function (result) {
$("#my__tbody").empty();
append(result);
}).fail(function (result) {
});
}
function priceDesc() {
$.ajax({
type : "get",
url : "/product/test?cmd=priceDescProc",
dataType : "json"
}).done(function (result) {
$("#my__tbody").empty();
append(result, "priceDesc");
}).fail(function (result) {
});
}
function countDesc() {
$.ajax({
type : "get",
url : "/product/test?cmd=countDescProc",
dataType : "json"
}).done(function (result) {
$("#my__tbody").empty();
append(result);
}).fail(function (result) {
});
}
</script>
</body>
</html>
폼으로 데이터 전송
ProductController
ProductInsertItemProcAction
package com.jaybon.product.action.product;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.jaybon.product.action.Action;
import com.jaybon.product.model.Product;
import com.jaybon.product.model.ProductType;
import com.jaybon.product.repository.ProductRepository;
import jdk.nashorn.internal.ir.RuntimeNode.Request;
public class ProductInsertItemProcAction implements Action{
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
System.out.println(request.getParameter("productType"));
Product product = Product.builder()
.name(request.getParameter("productName"))
.type(ProductType.valueOf(request.getParameter("productType")))
.price(Integer.parseInt(request.getParameter("productPrice")))
.count(Integer.parseInt(request.getParameter("productCount")))
.build();
ProductRepository productRepository = ProductRepository.getInstance();
int result = productRepository.insertItem(product);
if(result ==1 ) {
RequestDispatcher rd = request.getRequestDispatcher("index.jsp");
rd.forward(request, response);
}
}
}
ProductRepository
package com.jaybon.product.repository;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.jaybon.product.db.DBConn;
import com.jaybon.product.model.Product;
import com.jaybon.product.model.ProductType;
public class ProductRepository {
private static final String TAG = "ProductRepository : "; // TAG 생성 (오류 발견시 용이)
private static ProductRepository instance = new ProductRepository();
private ProductRepository() {
}
public static ProductRepository getInstance() {
return instance;
}
private Connection conn = null;
private PreparedStatement pstmt = null;
private ResultSet rs = null;
public int insertItem(Product product) { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "INSERT INTO product(id, name, type, price, count) "
+ "VALUES(PRODUCT_SEQ.nextval,?,?,?,?)";
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
pstmt.setString(1, product.getName());
pstmt.setString(2, product.getType().toString());
pstmt.setInt(3, product.getPrice());
pstmt.setInt(4, product.getCount());
return pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "insertItem : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return -1; // 실패시
}
public int deleteById(int id) {
final String SQL = "DELETE FROM product WHERE id =?";
List<Product> products = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
pstmt.setInt(1, id);
int result = pstmt.executeUpdate();
return result;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "deleteById : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return -1; // 실패시
}
// product 다찾기
public List<Product> findAll() { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "SELECT id, name, type, price, count FROM product ORDER BY id asc";
List<Product> products = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
rs = pstmt.executeQuery();
if(rs.next()) {
products = new ArrayList<>();
Product product = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product);
while (rs.next()) {
Product product1 = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product1);
}
}
return products;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "findAll : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return null; // 실패시
}
public List<Product> findAllPriceAsc() { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "SELECT id, name, type, price, count FROM product ORDER BY Price ASC";
List<Product> products = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
rs = pstmt.executeQuery();
if(rs.next()) {
products = new ArrayList<>();
Product product = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product);
while (rs.next()) {
Product product1 = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product1);
}
}
return products;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "findAll : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return null; // 실패시
}
public List<Product> findAllPriceDesc() { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "SELECT id, name, type, price, count FROM product ORDER BY Price DESC";
List<Product> products = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
rs = pstmt.executeQuery();
if(rs.next()) {
products = new ArrayList<>();
Product product = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product);
while (rs.next()) {
Product product1 = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product1);
}
}
return products;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "findAll : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return null; // 실패시
}
public List<Product> findAllCountDesc() { // object 받기(안에 내용 다 받아야 하니까)
final String SQL = "SELECT id, name, type, price, count FROM product ORDER BY count DESC";
List<Product> products = null;
try {
conn = DBConn.getConnection(); // DB에 연결
pstmt = conn.prepareStatement(SQL);
rs = pstmt.executeQuery();
if(rs.next()) {
products = new ArrayList<>();
Product product = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product);
while (rs.next()) {
Product product1 = Product.builder()
.id(rs.getInt(1))
.name(rs.getString(2))
.type(ProductType.valueOf(rs.getString(3)))
.price(rs.getInt(4))
.count(rs.getInt(5))
.build();
products.add(product1);
}
}
return products;
} catch (SQLException e) {
e.printStackTrace();
System.out.println(TAG + "findAll : " + e.getMessage());
} finally {
DBConn.close(conn, pstmt, rs);
}
return null; // 실패시
}
}
테스트 결과
| 야구 선수 게시판 예제 만들기 (2) | 2020.06.16 |
|---|---|
| 이클립스 eclipse sts툴 java / html / javascript / jsp 자동완성 (2) | 2020.06.16 |
| 블로그 댓글 지우기 (0) | 2020.06.15 |
| get / post 방식 (0) | 2020.06.12 |
| 블로그 댓글쓰기 (0) | 2020.06.12 |