ORACLE 접속을 위한 build.gradle의 dependencies와 application.properties, mybatis-config.xml

========================= build.gradle  =======================================

runtimeOnly 'com.oracle.database.jdbc:ojdbc8'
implementation 'org.springframework.boot:spring-boot-starter-data-jdbc'
implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.2.2'

 

========================= application.properties =======================================

server.port=9090

#oracle
spring.datasource.url=jdbc:oracle:thin:@127.0.0.1:1521:XE
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.username=user01
spring.datasource.password=1234

#mysql
#spring.datasource.url=jdbc:mysql://localhost:3306/mydb
#spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#spring.datasource.username=user01
#spring.datasource.password=1234

========================= 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>

<!--mapper에서 매칭할 parmeter Type 별칭 설정-->
<typeAliases>
<typeAlias alias="GuestbookDto" 
type="com.goldencrab.demo.guestbook.domain.GuestbookDto" />
</typeAliases>

<mappers>
<mapper resource="mappers/Guestbook.xml"/> 
</mappers>

</configuration>

========================= Guestbook.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="Guestbook">
  
  <select id="Guestbook_list" parameterType="GuestbookDto" resultType="GuestbookDto">
   select * from
   (
   select 
   id,
   title,
   writer,
   contents,
   wdate,
   row_number() over (order by id desc) as rnum,
   ceil( row_number() over (order by id desc) / 10 - 1 ) as pg 
   from guestbook
   ) where pg = #{pg}
  </select>
  
  <select id="Guestbook_totalCnt" parameterType="GuestbookDto" resultType="Integer">
   select count(*) from guestbook  
  </select>
  
</mapper>