[20210722] Spring + MyBatis를 이용한 로그인 및 게시판 5 - mapper

데이터베이스의 boardc 테이블에 접근하기 위한 mapper와 customer 테이블에 접근하기 위한 mapper이다.

<!-- boardMapper.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="bbsMapper">
  
  	<select id="bbs_all" resultType="bbs">
  		select b.*, (select c_id from customer c where c.c_no=b.b_user) b_ownernick from boardc b
  	</select>
  	
  	<select id="get_bbs" resultType="bbs">
  		select b.*, (select c_id from customer c where c.c_no=b.b_user) b_ownernick from boardc b
  		where b.b_no = #{b_no}
  	</select>
  	
  	<insert id="write_bbs">
  		insert into boardc(b_no, b_user, b_title, b_content ,b_date)
  		values(bbsc_seq.nextval, #{b_user}, #{b_title}, #{b_content}, sysdate)
  	</insert>
  	
  </mapper>

<!-- customerMapper.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="customerMapper">
  
  	<select id="Login" resultType="int">
	  	select count(*) from customer c
	  	where c.c_id = #{c_id} and c.c_pw = #{c_pw}  
	</select>
	  
	<select id="Login_Info" resultType="customer">
	  	select * from customer c
	  	where c.c_id = #{c_id} and c.c_pw = #{c_pw}  
	</select>
	  
	<select id="Id_Check" resultType="int">
	  	select count(*) from customer c
	  	where c.c_id = #{c_id}
	</select>
	  
	<insert id="Register">
		insert into customer (c_no, c_id, c_pw)
	  	values(cus_seq.nextval, #{c_id}, #{c_pw})
	</insert>
  
  </mapper>