# MemberMapper.xml select * from member where id = #{id} where name = #{name} select * from member #{name} select * from member id = #{id} AND name = #{name} UPDATE member password = #{password}, name = #{name} password = #{password}, name = #{name} WHERE id = #{id}

#1 mybatis-config.xml #2 boardMapper.xml SELECT MAX(num) FROM board INSERT INTO board (num, name, pass, subject, content, filename, re_ref, re_lev, re_seq, readcount, ip, reg_date) VALUES (#{num}, #{name}, #{pass}, #{subject}, #{content}, #{filename}, #{re_ref}, #{re_lev}, #{re_seq}, #{readcount}, #{ip}, CURRENT_TIMESTAMP) SELECT * FROM board subject LIKE #{search} ORDER BY re_ref DESC, re_seq A..

*** 작동방식 #1 mybaits-config.xml #2 MemberMapper.xml select id as id from member where id = #{id} SELECT * FROM member ORDER BY id SELECT COUNT(*) FROM member WHERE id = #{id} SELECT password FROM member WHERE id = #{id} INSERT INTO member (id,password,name,birthday,gender,email,address,tel,mtel,reg_date) VALUES (#{id}, #{password}, #{name}, #{birthday}, #{gender}, #{email}, #{address}, #{tel}, #{..

#1 Mybatis를 사용하기 위해 라이브러리 설치 1) Google에서 mybatis download로 검색 후 상위 사이트에 접속 2) zip 파일을 다운로드 3) 압축을 풀면 jar 파일들을 lib에 추가 #2 xml 에서의 빌드하기 -mybatis-config.xml #3 Mapper 작성 -MemberMapper.xml => 사용될 sql 구문을 삽입하는 공간이다. select id as id from member where id = #{id} SELECT * FROM member ORDER BY id INSERT INTO member (id,password,name,birthday,gender,email,address,tel,mtel,reg_date) VALUES (#{id}, #{passwo..