Spring Legacy Project 활용하여 기본적인 페이지의 기본기능인 회원가입 그리고 로그인 기능을 구현해 보려한다. 다음과 같은 과정을 통해 프로젝트가 진행이된다.
1. 프로젝트의 생성
프로젝트는 File → New → Spring Lagacy Project → Project Name 입력 → Spring MVC Project 선택 → 여기서 프로젝트 topLevelPackage를 입력하게되는데 우리는 “com.ssafy.cafe”로 진행
다음과 같이 프로젝트가 완성이되면 기본적인 웹 사이트의 구조를 갖추기위해 적당한 웹 템플릿을 가져와 추가하게된다. 우리는 부트스트랩을 사용하여 webapp아래에 index, css, js 파일을 그대로 복사하여 사용했다.
이제 기본적은 프로젝트 생성은 완료되었다. 여기서 프로젝트를 처음 생성한다면 톰캣이 설정안되어있을수도 있으므로 프로젝트를 실행할때 따로 지정해주면 된다.
2. 프로젝트 작성
2-1. 프론트 설정
먼저 회원가입과 로그인을 진행하기 위해서는 해당 form이 필요하다. index.html에 적당한 위치를 지정하여 form을 삽입해야한다. 회원가입은 팝업형식으로 외부 html을 활용하여 진행하고, 로그인은 본 html 파일에서 진행을 하게된다. 로그인에 성공을 하게된다면 로그인 이후에 해당 바운더리가 로그아웃과 같은 부분으로 교체되어야 하므로 특정 div로 묶게 된다.
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
<meta name="description" content="" />
<meta name="author" content="" />
<title>Shop Homepage - Start Bootstrap Template</title>
<!-- Favicon-->
<link rel="icon" type="image/x-icon" href="assets/favicon.ico" />
<!-- Bootstrap icons-->
<link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.5.0/font/bootstrap-icons.css" rel="stylesheet" />
<!-- Core theme CSS (includes Bootstrap)-->
<link href="css/styles.css" rel="stylesheet" />
</head>
<body>
<!-- Navigation-->
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<div class="container px-4 px-lg-5">
<a class="navbar-brand" href="#!">Start Bootstrap</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation"><span class="navbar-toggler-icon"></span></button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<ul class="navbar-nav me-auto mb-2 mb-lg-0 ms-lg-4">
<li class="nav-item"><a class="nav-link active" aria-current="page" href="#!">Home</a></li>
<li class="nav-item"><a class="nav-link" href="#!">About</a></li>
<li class="nav-item dropdown">
<a class="nav-link dropdown-toggle" id="navbarDropdown" href="#" role="button" data-bs-toggle="dropdown" aria-expanded="false">Shop</a>
<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
<li><a class="dropdown-item" href="#!">All Products</a></li>
<li><hr class="dropdown-divider" /></li>
<li><a class="dropdown-item" href="#!">Popular Items</a></li>
<li><a class="dropdown-item" href="#!">New Arrivals</a></li>
</ul>
</li>
</ul>
<div class="navbar-brand" href="#">
**<div id="msgDiv">
ID<input size="5" id="id">
PW<input size="5" id="pw" type="password">
<input type="button" id="loginBtn" value="login">
</div>**
</div>
<!-- 회원가입 추가 -->
**<a class="nav-link" href="#" onclick="window.open('html/memberInsertForm.html', '_blank', 'toolbar=yes,scrollbars=yes,resizable=yes,top=50,left=500,width=400,height=750');">회원가입</a>**
<form class="d-flex">
<button class="btn btn-outline-dark" type="submit">
<i class="bi-cart-fill me-1"></i>
Cart
<span class="badge bg-dark text-white ms-1 rounded-pill">0</span>
</button>
</form>
</div>
</div>
</nav>
<!-- Header-->
<header class="bg-dark py-5">
<div class="container px-4 px-lg-5 my-5">
<div class="text-center text-white">
<h1 class="display-4 fw-bolder">Shop in style</h1>
<p class="lead fw-normal text-white-50 mb-0">With this shop hompeage template</p>
</div>
</div>
</header>
<!-- Section-->
<section class="py-5">
<div class="container px-4 px-lg-5 mt-5">
<div class="row gx-4 gx-lg-5 row-cols-2 row-cols-md-3 row-cols-xl-4 justify-content-center">
<div class="col mb-5">
<div class="card h-100">
<!-- Product image-->
<img class="card-img-top" src="https://dummyimage.com/450x300/dee2e6/6c757d.jpg" alt="..." />
<!-- Product details-->
<div class="card-body p-4">
<div class="text-center">
<!-- Product name-->
<h5 class="fw-bolder">Fancy Product</h5>
<!-- Product price-->
$40.00 - $80.00
</div>
</div>
<!-- Product actions-->
<div class="card-footer p-4 pt-0 border-top-0 bg-transparent">
<div class="text-center"><a class="btn btn-outline-dark mt-auto" href="#">View options</a></div>
</div>
</div>
</div>
<div class="col mb-5">
<div class="card h-100">
<!-- Sale badge-->
<div class="badge bg-dark text-white position-absolute" style="top: 0.5rem; right: 0.5rem">Sale</div>
<!-- Product image-->
<img class="card-img-top" src="https://dummyimage.com/450x300/dee2e6/6c757d.jpg" alt="..." />
<!-- Product details-->
<div class="card-body p-4">
<div class="text-center">
<!-- Product name-->
<h5 class="fw-bolder">Special Item</h5>
<!-- Product reviews-->
<div class="d-flex justify-content-center small text-warning mb-2">
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
</div>
<!-- Product price-->
<span class="text-muted text-decoration-line-through">$20.00</span>
$18.00
</div>
</div>
<!-- Product actions-->
<div class="card-footer p-4 pt-0 border-top-0 bg-transparent">
<div class="text-center"><a class="btn btn-outline-dark mt-auto" href="#">Add to cart</a></div>
</div>
</div>
</div>
<div class="col mb-5">
<div class="card h-100">
<!-- Sale badge-->
<div class="badge bg-dark text-white position-absolute" style="top: 0.5rem; right: 0.5rem">Sale</div>
<!-- Product image-->
<img class="card-img-top" src="https://dummyimage.com/450x300/dee2e6/6c757d.jpg" alt="..." />
<!-- Product details-->
<div class="card-body p-4">
<div class="text-center">
<!-- Product name-->
<h5 class="fw-bolder">Sale Item</h5>
<!-- Product price-->
<span class="text-muted text-decoration-line-through">$50.00</span>
$25.00
</div>
</div>
<!-- Product actions-->
<div class="card-footer p-4 pt-0 border-top-0 bg-transparent">
<div class="text-center"><a class="btn btn-outline-dark mt-auto" href="#">Add to cart</a></div>
</div>
</div>
</div>
<div class="col mb-5">
<div class="card h-100">
<!-- Product image-->
<img class="card-img-top" src="https://dummyimage.com/450x300/dee2e6/6c757d.jpg" alt="..." />
<!-- Product details-->
<div class="card-body p-4">
<div class="text-center">
<!-- Product name-->
<h5 class="fw-bolder">Popular Item</h5>
<!-- Product reviews-->
<div class="d-flex justify-content-center small text-warning mb-2">
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
</div>
<!-- Product price-->
$40.00
</div>
</div>
<!-- Product actions-->
<div class="card-footer p-4 pt-0 border-top-0 bg-transparent">
<div class="text-center"><a class="btn btn-outline-dark mt-auto" href="#">Add to cart</a></div>
</div>
</div>
</div>
<div class="col mb-5">
<div class="card h-100">
<!-- Sale badge-->
<div class="badge bg-dark text-white position-absolute" style="top: 0.5rem; right: 0.5rem">Sale</div>
<!-- Product image-->
<img class="card-img-top" src="https://dummyimage.com/450x300/dee2e6/6c757d.jpg" alt="..." />
<!-- Product details-->
<div class="card-body p-4">
<div class="text-center">
<!-- Product name-->
<h5 class="fw-bolder">Sale Item</h5>
<!-- Product price-->
<span class="text-muted text-decoration-line-through">$50.00</span>
$25.00
</div>
</div>
<!-- Product actions-->
<div class="card-footer p-4 pt-0 border-top-0 bg-transparent">
<div class="text-center"><a class="btn btn-outline-dark mt-auto" href="#">Add to cart</a></div>
</div>
</div>
</div>
<div class="col mb-5">
<div class="card h-100">
<!-- Product image-->
<img class="card-img-top" src="https://dummyimage.com/450x300/dee2e6/6c757d.jpg" alt="..." />
<!-- Product details-->
<div class="card-body p-4">
<div class="text-center">
<!-- Product name-->
<h5 class="fw-bolder">Fancy Product</h5>
<!-- Product price-->
$120.00 - $280.00
</div>
</div>
<!-- Product actions-->
<div class="card-footer p-4 pt-0 border-top-0 bg-transparent">
<div class="text-center"><a class="btn btn-outline-dark mt-auto" href="#">View options</a></div>
</div>
</div>
</div>
<div class="col mb-5">
<div class="card h-100">
<!-- Sale badge-->
<div class="badge bg-dark text-white position-absolute" style="top: 0.5rem; right: 0.5rem">Sale</div>
<!-- Product image-->
<img class="card-img-top" src="https://dummyimage.com/450x300/dee2e6/6c757d.jpg" alt="..." />
<!-- Product details-->
<div class="card-body p-4">
<div class="text-center">
<!-- Product name-->
<h5 class="fw-bolder">Special Item</h5>
<!-- Product reviews-->
<div class="d-flex justify-content-center small text-warning mb-2">
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
</div>
<!-- Product price-->
<span class="text-muted text-decoration-line-through">$20.00</span>
$18.00
</div>
</div>
<!-- Product actions-->
<div class="card-footer p-4 pt-0 border-top-0 bg-transparent">
<div class="text-center"><a class="btn btn-outline-dark mt-auto" href="#">Add to cart</a></div>
</div>
</div>
</div>
<div class="col mb-5">
<div class="card h-100">
<!-- Product image-->
<img class="card-img-top" src="https://dummyimage.com/450x300/dee2e6/6c757d.jpg" alt="..." />
<!-- Product details-->
<div class="card-body p-4">
<div class="text-center">
<!-- Product name-->
<h5 class="fw-bolder">Popular Item</h5>
<!-- Product reviews-->
<div class="d-flex justify-content-center small text-warning mb-2">
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
<div class="bi-star-fill"></div>
</div>
<!-- Product price-->
$40.00
</div>
</div>
<!-- Product actions-->
<div class="card-footer p-4 pt-0 border-top-0 bg-transparent">
<div class="text-center"><a class="btn btn-outline-dark mt-auto" href="#">Add to cart</a></div>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- Footer-->
<footer class="py-5 bg-dark">
<div class="container"><p class="m-0 text-center text-white">Copyright © Your Website 2022</p></div>
</footer>
<!-- Bootstrap core JS-->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
<!-- Core theme JS-->
<script src="js/scripts.js"></script>
<!-- jQuery library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<!-- Latest compiled JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
<script type="text/javascript" src="js/my.js"></script>
</body>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-cookie/1.4.1/jquery.cookie.min.js"></script>
**<script>
$(function(){
var login=$.cookie('logined');
$("#msgDiv").html(login);
});
</script>**
</html>2-2. pom.xml 필요기능 추가
Mysql, JDBC등 필요기능을 수행하기위한 코드들을 mvn repository 사이트에서 복사해서 붙여넣는다.
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.ssafy</groupId>
<artifactId>cafe</artifactId>
<name>1018_HW</name>
<packaging>war</packaging>
<version>1.0.0-BUILD-SNAPSHOT</version>
<properties>
<java-version>1.8</java-version>
<org.springframework-version>5.3.23</org.springframework-version>
<org.aspectj-version>1.9.9.1</org.aspectj-version>
<org.slf4j-version>1.7.36</org.slf4j-version>
</properties>
<dependencies>
<!-- Spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${org.springframework-version}</version>
<exclusions>
<!-- Exclude Commons Logging in favor of SLF4j -->
<exclusion>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<!-- AspectJ -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjrt</artifactId>
<version>${org.aspectj-version}</version>
</dependency>
<!-- Logging -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${org.slf4j-version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>jcl-over-slf4j</artifactId>
<version>${org.slf4j-version}</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${org.slf4j-version}</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.15</version>
<exclusions>
<exclusion>
<groupId>javax.mail</groupId>
<artifactId>mail</artifactId>
</exclusion>
<exclusion>
<groupId>javax.jms</groupId>
<artifactId>jms</artifactId>
</exclusion>
<exclusion>
<groupId>com.sun.jdmk</groupId>
<artifactId>jmxtools</artifactId>
</exclusion>
<exclusion>
<groupId>com.sun.jmx</groupId>
<artifactId>jmxri</artifactId>
</exclusion>
</exclusions>
<scope>runtime</scope>
</dependency>
<!-- @Inject -->
<dependency>
<groupId>javax.inject</groupId>
<artifactId>javax.inject</artifactId>
<version>1</version>
</dependency>
<!-- Servlet -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.1</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- Test -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.7</version>
<scope>test</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.23</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.30</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-beanutils/commons-beanutils -->
<dependency>
<groupId>commons-beanutils</groupId>
<artifactId>commons-beanutils</artifactId>
<version>1.8.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.2.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/cglib/cglib -->
<dependency>
<groupId>cglib</groupId>
<artifactId>cglib</artifactId>
<version>2.2</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.1.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.1.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.googlecode.json-simple/json-simple -->
<dependency>
<groupId>com.googlecode.json-simple</groupId>
<artifactId>json-simple</artifactId>
<version>1.1.1</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<artifactId>maven-eclipse-plugin</artifactId>
<version>2.9</version>
<configuration>
<additionalProjectnatures>
<projectnature>org.springframework.ide.eclipse.core.springnature</projectnature>
</additionalProjectnatures>
<additionalBuildcommands>
<buildcommand>org.springframework.ide.eclipse.core.springbuilder</buildcommand>
</additionalBuildcommands>
<downloadSources>true</downloadSources>
<downloadJavadocs>true</downloadJavadocs>
</configuration>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>2.5.1</version>
<configuration>
<source>1.6</source>
<target>1.6</target>
<compilerArgument>-Xlint:all</compilerArgument>
<showWarnings>true</showWarnings>
<showDeprecation>true</showDeprecation>
</configuration>
</plugin>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>exec-maven-plugin</artifactId>
<version>1.2.1</version>
<configuration>
<mainClass>org.test.int1.Main</mainClass>
</configuration>
</plugin>
</plugins>
</build>
</project>2-3. url-pattern 수정
web.xml 파일에서 pattern을 수정하게되는데 기본적으로는 *.do로 설정이 되어있을것이다. do부분은 프로젝트의 성향에따라 자유롭게 설정해도된다.
<servlet>
<servlet-name>appServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring/appServlet/servlet-context.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>appServlet</servlet-name>
<url-pattern>*.shop</url-pattern> <!-- 해당부분-->
</servlet-mapping>2-4. Javascript 파일 수정
index 페이지와 memberInsert 페이지에서 진행되는 이벤트처리와 정보 전송을 위해 my.js 파일을 작성해주어야한다. 코드별 상세 설명은 아래 주석을 확인하면 될 것 같다.
/**
* script 태그가 head 에 선언 되어있는 경우 모두 로드한 후 element 를 찾는 onload 의 기능이
* jQuery 에서 $(document).ready(); 과 같다 !
*/
$(document).ready(function(){ // 파일이 준비상태가 되면 콜백함수를 실행하자!
$("#memberInsertBtn").click(function(){ //회원가입 part!
let name = $("#name").val(); //form에서 받아온 회원정보
let id = $("#id").val();
let pw = $("#pw").val();
// 해당정보를 사용하여
$.get("../memberInsert.shop", {name, id, pw}, function(data){ // get방식으로 아까 설정한 .shop을 활용해 전달
alert(data);
window.close();
});
});
$("#loginBtn").click(function(){// 로그인 part
let id=$("#id").val(); //form에서 받아온 회원정보
let pw=$("#pw").val();
//alert(id+":"+pw);
$.post("login.shop",
{
id:id,
pw:pw
},
function(data, status){
var obj=JSON.parse(data);
if(obj.name){ // 로그인을 성송하게되면 해당 데이터에 로그인 폼을 대신할 html 코드를 세팅
data = obj.name+ "<input type='button' value='logout' id='logoutBtn' class='btn btn-primary'>";
$.cookie("logined",data);
$("#msgDiv").html(data);
} else{
alert(obj.msg);
location.reload();
}
} // end function
);//end post()
});//end 로그인 처리
});
$(document).on("click", "#logoutBtn", function(event) { //로그아웃 part
$.post("logout.shop",{}, function(data, status){
$.removeCookie("logined"); // 로그인을 통해 생성된 쿠키를 삭제
location.reload();
}
);//end post()
});//end 로그아웃 처리2-5. Controller 수정
자바스크립트에서 요청한 기능을 수행하고 처리하는 곳이다. 해당 부분을 적당히 수정해주어야 한다. MemberService 객체를 통하여 진행이되고 회원가입 파트는 “memberInsert.shop” 정보가 들어오게되면 들어온 회원정보를 알아서 적용하여 멤버 객체를 만들어 memberInsert를 진행하게된다. 이게 가능하려면 일단 MemberDto에 getter, setter그리고 default 생성자가 필요하다.
로그인의 경우는 불러온 회원의 id와 pw를 기준으로 디비에 존재한다면 세선을 주고처리되는구조, 로그아웃은 해당 세션을 사용종료 시키는 구조이다.
@Controller : 컨트롤러에 해당하는 부분에 작성한다.
@Autowired : 자동으로 객체에 정보를 넣어주는 역할을한다.
@RequestMapping : “memberInsert.shop”과 같이 value에 해당하는 url이 요청으로 들어올 때 해당 함수를 수행하게 된다.
@ResponseBody : 객체를 바로 받아서 사용을 가능하게 해준다. getParameter 없이 진행이 가능하다.
@Controller
public class HomeController {
@Autowired
MemberService memberService;
@RequestMapping(value = "logout.shop", method= {RequestMethod.POST}, produces = "application/text; charset=utf8")
@ResponseBody
public String logout(HttpServletRequest request, HttpServletResponse response){
HttpSession session=request.getSession(false);
session.invalidate();
return "";
}
@RequestMapping(value = "login.shop", method= {RequestMethod.POST}, produces = "application/text; charset=utf8")
@ResponseBody
public String login(HttpServletRequest request, HttpServletResponse response){
String id=request.getParameter("id");
String pw=request.getParameter("pw");
JSONObject json=new JSONObject();
try {
Member m=new Member(id,pw);
String name=memberService.login(m);
if(name!=null) {
HttpSession session=request.getSession();
session.setAttribute("member", m);
json.put("name", name);
}else {
json.put("msg", "로그인 실패");
}
}catch(Exception e) {
json.put("msg", e.getMessage());
}
return json.toJSONString();
}
@RequestMapping(value = "memberInsert.shop", method = RequestMethod.GET, produces = "application/text; charset=utf8")
@ResponseBody
public String home(Member m) throws Exception {
System.out.println("HomeController : "+m);
// service ..
memberService.memberInsert(m);
return m.getName() + "님 가입되셨습니다!";
}
}2-6. MemberDto 설정
해당 에서 생성자의 설정은 반드시 this가 아닌 set으로 바꿔주어야한다.
package com.ssafy.cafe.dto;
public class Member {
private String name, id, pw;
@Override
public String toString() {
return "Member [name=" + name + ", id=" + id + ", pw=" + pw + "]";
}
public Member() {
super();
// TODO Auto-generated constructor stub
}
public Member(String name, String id, String pw) { // set 으로 바꿨다고 치고 ...
super();
this.name = name;
this.id = id;
this.pw = pw;
}
public Member(String id, String pw) {
this.id = id;
this.pw = pw;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getPw() {
return pw;
}
public void setPw(String pw) {
this.pw = pw;
}
}2-7 MemberDao 설정
@Repository는 DB와 연관된, DB를 사용하는 부분에 붙여주는 표시이다. 다른부분에도 마찬가지이이지만 혹시라도 해당 부분이 @Service인지 @Repository 인지 헷갈린다면 @Component를 사용하면 된다.
여기서 사용되는 SqlSession sqlSession 은 mybatis 사용을 위한 객체다.
package com.ssafy.cafe.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import com.ssafy.cafe.dto.Member;
@Repository
public class MemberDao {
@Autowired
SqlSession sqlSession;
public void memberInsert(Member m) throws Exception {
System.out.println("MemberDAO : "+ m);
System.out.println("MemberDAO : "+ sqlSession);
sqlSession.insert("mapper.member.memberInsert", m);
}
public String login(Member m) {
return sqlSession.selectOne("mapper.member.login",m);
}
}2-8 MemberService 설정
해당부분은 service 파트이기에 @Service이 사용되는데 위에서 언급했다시피 @Repository 인지 헷갈린다면 @Component를 사용하면 된다.
package com.ssafy.cafe.service;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ssafy.cafe.dao.MemberDao;
import com.ssafy.cafe.dto.Member;
@Service
public class MemberService {
@Autowired
MemberDao memberDao;
public void memberInsert(Member m) throws Exception {
System.out.println("MemberSerivce : "+m);
memberDao.memberInsert(m);
}
public String login(Member m) {
return memberDao.login(m);
}
}3. Mybatis setting
mybatis 사용을 위해 다음과같이 xml 파일의 설정이 필요하다.
각각의 파일 경로는 다음과 같다.
1) scr/main/resouces/mappers
2) scr/main/resouces/model
3) WEB-INF/config/jdbc/jdbc.properties
3-1 member.xml 파일설정
현재 우리가 구현하고자하는 기능중 로그인 그리고 회원가입과정속에서 진행되는 쿼리문을 작성해두는 곳이다. 회원가입은 insert, 로그인은 select 그냥 우리가 알고있는 과정과 별 다를바 없다.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="mapper.member">
<insert id="memberInsert" parameterType="member">
Insert into member(name, id, pw) values(#{name},#{id},#{pw})
</insert>
<select id="login" resultType="String" parameterType="member">
select name from member where id=#{id} and pw=#{pw}
</select>
</mapper>3-2 modelconfig.xml 파일설정
해당 부분은 mybatis에서 이용할 alias를 설정하는 부분이다.
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<typeAliases>
<typeAlias type="com.ssafy.cafe.dto.Member" alias="member"/>
</typeAliases>
</configuration>3-3 jdbc.properties 파일설정
우리가 사용하고 연결할 정보를 설정하는 부분이다.
jdbc.driverClassName=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/temp
jdbc.username=ssafy
jdbc.password=00004. XML setting
각각의 파일 경로는 다음과 같다.
1) WEB-INF/appServlet/root-context.xml
2) WEB-INF/spring/root-context.xml
4-1 servlet-context.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:beans="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.1.xsd">
<!-- DispatcherServlet Context: defines this servlet's request-processing infrastructure -->
<!-- Enables the Spring MVC @Controller programming model -->
<annotation-driven />
<!-- Handles HTTP GET requests for /resources/** by efficiently serving up static resources in the ${webappRoot}/resources directory -->
<resources mapping="/resources/**" location="/resources/" />
<!-- Resolves views selected for rendering by @Controllers to .jsp resources in the /WEB-INF/views directory -->
<beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<beans:property name="prefix" value="/WEB-INF/views/" />
<beans:property name="suffix" value=".jsp" />
</beans:bean>
<context:component-scan base-package="com.ssafy.cafe" />
<!--
<beans:bean class="org.springframework.jdbc.datasource.SimpleDriverDataSource" id="ds">
<beans:property name="driverClass" value="com.mysql.cj.jdbc.Driver"></beans:property>
<beans:property name="url" value="jdbc:mysql://localhost:3306/temp"></beans:property>
<beans:property name="username" value="ssafy"></beans:property>
<beans:property name="password" value="ssafy"></beans:property>
</beans:bean> -->
</beans:beans>4-2 root-context.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:c="http://www.springframework.org/schema/c"
xmlns:cache="http://www.springframework.org/schema/cache"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:jdbc="http://www.springframework.org/schema/jdbc"
xmlns:jee="http://www.springframework.org/schema/jee"
xmlns:lang="http://www.springframework.org/schema/lang"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:p="http://www.springframework.org/schema/p"
xmlns:task="http://www.springframework.org/schema/task"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:util="http://www.springframework.org/schema/util"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.1.xsd
http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache-3.1.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.3.xsd
http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.1.xsd
http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang-3.1.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd
http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-3.1.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.1.xsd">
<bean id="propertyPlaceholderConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
>
<property name="locations">
<list>
<value>/WEB-INF/config/jdbc/jdbc.properties</value>
</list>
</property>
</bean>
<bean id="dataSource" class="org.apache.ibatis.datasource.pooled.PooledDataSource">
<property name="driver" value="${jdbc.driverClassName}"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="configLocation" value="classpath:mybatis/model/modelConfig.xml"></property>
<property name="mapperLocations" value="classpath:mybatis/mappers/*.xml"></property>
</bean>
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="sqlSessionFactoryBean"></constructor-arg>
</bean>
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<tx:annotation-driven transaction-manager="txManager" />
</beans>
나태지옥