내맘대로 블로그.

ORM DB 연동

카테고리 없음2016. 12. 29. 16:36

db.properties

driver=oracle.jdbc.OracleDriver

url=jdbc:oracle:thin:@localhost:1521:orcl

username=DB명

password=DB비밀번호


SqlMapConfig.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>

<properties resource="db.properties"/>

<typeAliases>

<typeAlias alias="emp" type="test.Emp"/>

</typeAliases>

<environments default="development">

<environment id="development">

<transactionManager type="JDBC"/>

<dataSource type="POOLED">

      <property name="driver" value="${driver}"/>

      <property name="url" value="${url}"/>

      <property name="username" value="${username}"/>

      <property name="password" value="${password}"/>

    </dataSource>

</environment>

</environments>


<mappers>

<mapper resource="Employee.xml"/>

</mappers>

</configuration>