[정리] 기능별 개념 정리/스프링 부트

스프링 부트 Mybatis

kok202 2019. 1. 22. 23:27

DTO.Member class

 

@Data

public class Member {

    public @NotNull String name;

    public @NotNull int age;

}






Mapper.MemberMapper Interface


@Repository

public interface MemberMapper {

    public String insertMember(String name, int age) throws Exception;

    public List<Member> selectMember(String name) throws Exception;

}

 






MemberMapper.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="com.example.projectName.Mapper.MemberMapper">


    <insert id="insertMember" parameterType="com.example.projectName.DTO.Member">

        INSERT INTO MEMBER (NAME, AGE) VALUES(#{name},#{age})

    </insert>



    <select id="selectMember" parameterType="string" resultType="com.example.projectName.DTO.Member">

        SELECT * FROM MEMBER WHERE NAME=#{name}

    </select>


</mapper>