Mybatis...2

Mybatis...2

회원등록

<insert id="insert" parameterType="day_12_15_mybatis.MemberVo"> >
        insert into
        member(no,name,tel,intro,addr)
        values(#{no},#{name},#{tel},#{intro},#{addr})
</insert>

• 상기 코드를 member.xml의 mapper 태그 안에 집어넣고
• 위에 보이는 insert 태그 같은 경우엔 꼭 insert가 될 필요는 없다

try (SqlSession session = sqlSessionFactory.openSession(true)) {
            MemberVo vo =new MemberVo(20,"홍1","010-221","홍1유저","서울1");
            session.insert("member.insert",vo);
            System.out.println("등록성공");
}

• main 메서드 아래에 해당 코드를 집어넣으면 된다.

회원삭제

<delete id="delete" parameterType="day_12_15_mybatis.MemberVo">
        delete from member where no =
        #{no}
</delete>

try (SqlSession session = sqlSessionFactory.openSession(true)) {
            MemberVo vo = session.selectOne("member.selectOne", 20);
            session.delete("member.delete",vo);
            System.out.println("삭제성공");
}

등록 회원 전부 출력

<select id="selectAll" resultType="day_12_15_mybatis.MemberVo">
        select * from member order by
        no desc
</select>

try (SqlSession session = sqlSessionFactory.openSession(true)) {
            List<MemberVo> memList = session.selectList("member.selectAll");
            memList.forEach(System.out::println);
}

등록 회원 수

<select id="count" resultType="int">
        select count(*) from member
</select>

try (SqlSession session = sqlSessionFactory.openSession()) {
              int cnt = session.selectOne("member.count");
              System.out.println(cnt);
}

회원검색

<select id="selectOne" resultType="day_12_15_mybatis.MemberVo">
        select * from member where no
        = #{no}
</select>

try (SqlSession session = sqlSessionFactory.openSession()) {
              int cnt = session.selectOne("member.count");
              System.out.println(cnt);
}

조건검색

<select id="find" resultType="day_12_15_mybatis.MemberVo">
        select * from member where name
        like
        #{name}
</select>
<select id="findname" resultType="day_12_15_mybatis.MemberVo" parameterType="map" >
        select * from member where
        ${col} like #{val}
</select>

try (SqlSession session = sqlSessionFactory.openSession()) {
            HashMap<String,String> m =new HashMap<>();
            m.put("col", "tel");
            m.put("val", "%112%");
            List<MemberVo> memList = session.selectList("member.find",m);
            memList.forEach(System.out::println);
}

회원수정

<select id="update" resultType="day_12_15_mybatis.MemberVo">
        UPDATE member set name =#{name}, tel = #{tel},intro = #{intro}, addr =#{addr}
        where no = #{no}
</select>

try (SqlSession session = sqlSessionFactory.openSession(true)) {
            MemberVo vo = new MemberVo(1, "홍1", "010-221", "홍1유저", "서울1");
            session.update("member.update", vo);
            System.out.println(vo);
}