728x90
수업내용
1교시 (09:30-10:20)
- 자습
2교시 (10:30-11:20)
- UNION
SELECT DEPTNO, ENAME, '1' FROM EMP
UNION
SELECT DEPTNO, '1', DNAME FROM DEPT;
SELECT DEPTNO, ENAME, 'DNAME' FROM EMP
UNION
SELECT DEPTNO, 'ENAME', DNAME FROM DEPT;- MINUS & JOIN
-- 232P
-- LEFT OUTER JOIN
SELECT A.DEPTNO, B.DEPTNO
FROM DEPT A LEFT OUTER JOIN EMP B
ON A.DEPTNO = B.DEPTNO;
-- RIGHT OUTER JOIN
SELECT A.DEPTNO, B.DEPTNO
FROM EMP A RIGHT OUTER JOIN DEPT B
ON A.DEPTNO = B.DEPTNO;
-- FULL OUTER JOIN
SELECT A.DEPTNO, B.DEPTNO
FROM EMP A FULL OUTER JOIN DEPT B
ON A.DEPTNO = B.DEPTNO;3교시 (11:30-12:20)
- 게시판과 댓글에 대한 코드 및 기능 설명
4교시 (12:30-13:20)
게시판 구현하기
- spring_board.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="a.b.c.com.kosmo.board.dao.KosmoBoardDAO">
<insert id="kosmoBoardInsert" parameterType="kosmoboardvo" >
INSERT INTO KOSMO_BOARD ( KBNUM, KBSUBJECT, KBNAME,
KBCONTENT, KBFILE, KBPW,
DELETEYN, INSERTDATE, UPDATEDATE)
VALUES( #{kbnum},
#{kbsubject},
#{kbname},
#{kbcontent},
#{kbfile},
#{kbpw},
'Y',
SYSDATE,
SYSDATE)
</insert>
<select id="kosmoBoardSelectAll" parameterType="kosmoboardvo" resultType="kosmoboardvo">
SELECT A.KBNUM KBNUM
,A.KBSUBJECT KBSUBJECT
,A.KBNAME KBNAME
,A.KBCONTENT KBCONTENT
,A.KBFILE KBFILE
,A.KBPW KBPW
,A.DELETEYN DELETEYN
,TO_CHAR(A.INSERTDATE, 'YYYY-MM-DD') INSERTDATE
,TO_CHAR(A.UPDATEDATE, 'YYYY-MM-DD') UPDATEDATE
FROM KOSMO_BOARD A
WHERE A.DELETEYN = 'Y'
ORDER BY 1 DESC
</select>
<select id="kosmoBoardSelect" parameterType="kosmoboardvo" resultType="kosmoboardvo">
SELECT A.KBNUM KBNUM
,A.KBSUBJECT KBSUBJECT
,A.KBNAME KBNAME
,A.KBCONTENT KBCONTENT
,A.KBFILE KBFILE
,A.KBPW KBPW
,A.DELETEYN DELETEYN
,A.INSERTDATE INSERTDATE
,A.UPDATEDATE UPDATEDATE
FROM KOSMO_BOARD A
WHERE A.DELETEYN = 'Y'
AND A.KBNUM = #{kbnum}
</select>
<select id="kosmoBoardPwCheck" parameterType="kosmoboardvo" resultType="kosmoboardvo">
SELECT A.KBNUM KBNUM
,A.KBPW KBPW
FROM KOSMO_BOARD A
WHERE A.DELETEYN = 'Y'
AND A.KBNUM = #{kbnum}
AND A.KBPW = #{kbpw}
</select>
</mapper>- spring_chabun.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="a.b.c.com.kosmo.common.dao.SpringChabunDAO">
<select id="getProductChabun" resultType="kosmoproductvo">
SELECT /*+ INDEX_DESC(A SYS_C0012888) */ NVL(MAX(SUBSTR(A.KPNUM, -4)), 0) + 1 KPNUM FROM KOSMO_PRODUCT A
</select>
<select id="getCartChabun" resultType="kosmocartvo">
SELECT /*+ INDEX_DESC(A SYS_C0011101) */ NVL(MAX(SUBSTR(A.KCNUM, -4)), 0) + 1 KCNUM FROM KOSMO_CART A
</select>
<select id="getMemberChabun" resultType="kosmomembervo">
SELECT /*+ INDEX_DESC(A SYS_C0011102) */ NVL(MAX(SUBSTR(A.KMNUM, -4)), 0) + 1 KMNUM FROM KOSMO_MEMBER A
</select>
<select id="getBoardChabun" resultType="kosmoboardvo">
SELECT /*+ INDEX_DESC(A SYS_C0012694) */ NVL(MAX(SUBSTR(A.KBNUM, -4)), 0) + 1 KBNUM FROM KOSMO_BOARD A
</select>
</mapper>- mybatis-config.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<typeAliases>
<typeAlias type="a.b.c.com.kosmo.product.vo.KosmoProductVO" alias="kosmoproductvo"/>
<typeAlias type="a.b.c.com.kosmo.cart.vo.KosmoCartVO" alias="kosmocartvo" />
<typeAlias type="a.b.c.com.kosmo.mem.vo.KosmoMemberVO" alias="kosmomembervo"/>
<typeAlias type="a.b.c.com.kosmo.board.vo.KosmoBoardVO" alias="kosmoboardvo"/>
</typeAliases>
</configuration>5교시 (14:30-15:20)
- 프로젝트 주제 발표
6교시 (15:30-16:20)
- 프로젝트 주제 발표
7교시 (16:30-17:20)
- 프로젝트 주제 발표
8교시 (17:30-18:30)
- 프로젝트 주제 발표
Notes
728x90