CRUD 게시판(기초)_피드백수정본

SG Jang·2021년 2월 25일
crudboard
0

길잡이를 자바보자

목록 보기
9/12
post-thumbnail

이번 시간에는 지난 시간에 했던 "CRUD 게시판(기초)"에 대한 피드백을 적용한 프로젝트를 보여드리겠습니다.

피드백 내용

  • 입력값을 받지 않는 단순 CRUD(입력받을때 requestParam/ requestBody를 사용하는 방법을 알아보자.)
  • HTTP METHOD를 모두 GET으로 한점
  • 번외: mapper를 어노테이션말구 xml롤 작성해보자!

프로젝트 구조

TestController

package controller;

import domain.TestUser;
import mapper.TestMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;


import java.util.List;

@Controller
public class TestController {
    @Autowired //빈주입해주는 어노테이션
    private TestMapper testMapper;

    @ResponseBody
    @RequestMapping(value = "/test", method = RequestMethod.GET)
    public String test() {
        return "good working";
    }

    @ResponseBody
    @RequestMapping(value = "/users", method = RequestMethod.GET)
    public List<TestUser> select() {
        return testMapper.select();
    }

    @ResponseBody
    @RequestMapping(value = "/users", method = RequestMethod.POST)
    public String insert(@RequestBody TestUser user) {
        testMapper.insert(user);
        return "Successful Insert Data";
    }

    @ResponseBody
    @RequestMapping(value = "/users", method = RequestMethod.PUT)
    public String update(@RequestBody TestUser user) {
        testMapper.update(user);
        return "Successful Update Data";
    }

    @ResponseBody
    @RequestMapping(value = "/users", method = RequestMethod.DELETE)
    public String delete(@RequestBody TestUser user) {
        testMapper.delete(user);
        return "Successful Delete Data";
    }
}

TestUser

package domain;

public class TestUser {
    private int id;
    private String name;
    private int age;
    private String sex;
    private int studentID;

    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }

    public int getStudentID() {
        return studentID;
    }
    public void setStudentID(int studentID) {
        this.studentID = studentID;
    }
}

TestMapper

package mapper;


import domain.TestUser;
import java.util.List;

public interface TestMapper {

    List<TestUser> select();
    void insert(TestUser user);
    void update(TestUser user);
    void delete(TestUser user);

}

mapper.xml

<?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.TestMapper">

    <select id="select" resultType="domain.TestUser">
        select * from test.user;
    </select>

    <insert id="insert" parameterType="domain.TestUser">
        insert into test.user (name, age, sex, studentID) values(#{name}, #{age}, #{sex}, #{studentID});
    </insert>

    <update id="update" parameterType="domain.TestUser">
        update test.user set name = '틀딱' where age >= #{age};
    </update>

    <delete id="delete" parameterType="domain.TestUser">
        delete from test.user where studentID = #{studentID};
    </delete>
</mapper>

config.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:mybatis="http://mybatis.org/schema/mybatis-spring"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://mybatis.org/schema/mybatis-spring
       http://mybatis.org/schema/mybatis-spring.xsd">

    <mybatis:scan base-package="mapper"/>


    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Seoul"/>
        <property name="username" value="root"/>
        <property name="password" value="비밀번호"/>
    </bean> <!--데이터소스객체만듬(1)-->

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="mapperLocations" value="classpath:mappers/*.xml"/>
    </bean> <!--공장만듬(2)-->

    <bean id="session" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg index="0" ref="sqlSessionFactory"/>
    </bean> <!--공장에서 데이터소스자재를 갖고 만든 제품(3)-->
</beans>

dispatcher-servlet.xml

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.2.xsd">

    <context:component-scan base-package="controller"/>
    <mvc:annotation-driven/>
</beans>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>
            /WEB-INF/applicationContext.xml
            classpath*:mybatis/config.xml <!-- config.xml을 연결해주기 위해 써줌 -->
        </param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <servlet>
        <servlet-name>dispatcher</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>dispatcher</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
</web-app>

index.jsp

<%--
  Created by IntelliJ IDEA.
  User: djgjd
  Date: 2021-02-23
  Time: 오후 4:40
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" %>
<html>
  <head>
    <title>Harry's Board</title>
  </head>
  <body>
  HIBoard<br><br>
  /users, HTTP method는 GET -> db에 있는 유저정보조회<br><br>
  /users, HTTP method는 POST -> name, age, sex, studentID를 입력하여 데이터 생성<br><br>
  /users, HTTP method는 PUT -> 나이 값을 입력하면 입력한 값보다 크거나 같으면 데이터 이름변경 <br><br>
  /users, HTTP method는 DELETE -> 학번 값을 입력하면 입력한 학번의 데이터 삭제 <br><br>
  </body>
</html>

pom.xml

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>Connect</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <org.springframework-version>3.2.18.RELEASE</org.springframework-version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.6.10</version>
        </dependency>
        <!-- servlet -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope>
        </dependency>
        <!-- mysql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
        </dependency>
        <!-- mybtis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.5</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${org.springframework-version}</version>
        </dependency>
        <dependency>
            <groupId>commons-dbcp</groupId>
            <artifactId>commons-dbcp</artifactId>
            <version>1.4</version>
        </dependency>
        <!-- json -->
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-core</artifactId>
            <version>2.9.3</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-annotations</artifactId>
            <version>2.9.3</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>2.9.3</version>
        </dependency>
        <dependency>
            <groupId>com.googlecode.json-simple</groupId>
            <artifactId>json-simple</artifactId>
            <version>1.1.1</version>
        </dependency>
    </dependencies>
</project>

결과화면

profile
SG Jang
이전 포스트

Spring_DB연동 및 CRUD 게시판(기초)

다음 포스트

Mybatis_#{}, ${} 차이

0개의 댓글