ibatis

//////////////////////////////////////////////////////////////////////////////////////////

/////////////// iBatisDBConnector.java /////////////////////////////////////////////

//////////////////////////////////////////////////////////////////////////////////////////

public final class IBatisDBConnector {

private static SqlMapClient sqlMapClient;

static {

try{

//접속설정 파일로드

String resource = "board/db/sqlconfig/SqlMapConfig.xml";

Reader reader = Resources.getResourceAsReader(resource);

sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);

}catch(Exception e){

e.printStackTrace();

}

} 

 public static SqlMapClient getSqlMapInstance(){

//인스턴스 반환 메소드

return sqlMapClient;

} 

}

//////////////////////////////////////////////////////////////////////////////////////////

/////////////// SqlMapConfig.properties /////////////////////////////////////////////

//////////////////////////////////////////////////////////////////////////////////////////

driver=oracle.jdbc.driver.OracleDriver

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

username=board 

password=1234

//////////////////////////////////////////////////////////////////////////////////////////

/////////////// SqlMapConfig.xml /////////////////////////////////////////////

//////////////////////////////////////////////////////////////////////////////////////////

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd">

 

<sqlMapConfig> 

    <properties resource="board/db/sqlconfig/SqlMapConfig.properties" />

    <!-- 접속정보를 저장한 properties파일을 지정합니다. -->

    <settings

        cacheModelsEnabled="true"

        enhancementEnabled="true"

        lazyLoadingEnabled="true"

        maxRequests="20"

        maxSessions="10"

        maxTransactions="10"

        useStatementNamespaces="true"

    />

 

    <transactionManager type="JDBC">

        <dataSource type="DBCP">

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

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

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

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

            <property name="Pool.MaximumActiveConnections" value="10"/>

            <property name="Pool.MaximumIdleConnections" value="10"/>

            <property name="Pool.MaximumWait" value="60000"/>

            <property name="Pool.ValidationQuery" value="select 1 from dual"/>

            <property name="Pool.LogAbandoned" value="false"/>

            <property name="Pool.RemoveAbandoned" value="false"/>

            <property name="Pool.RemoveAbandonedTimeout" value="60000"/>

        </dataSource>

    </transactionManager>

 

    <sqlMap resource="board/db/sqlmaps/Board.xml"/>

 

</sqlMapConfig>

//////////////////////////////////////////////////////////////////////////////////////////

/////////////// Board.xml /////////////////////////////////////////////

//////////////////////////////////////////////////////////////////////////////////////////

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="Board">

<typeAlias alias="map" type="java.util.Map" />

<typeAlias alias="str" type="java.lang.String" />

<typeAlias alias="int" type="java.lang.Integer" />

<typeAlias alias="board" type="board.beans.Board" />

<select id="getArticleList" resultClass="board">

select * from board order by idx desc

</select>

<select id="getArticle" parameterClass="int" resultClass="board">

select * from board where idx=#value#

</select>

<insert id="insert" parameterClass="board">

insert into board (idx, title, writer, content, regdate, cnt, filename) 

values (seq_board.nextval, #title#, #writer#, #content#, #regdate#, 0, #filename#)

</insert>

<update id="update" parameterClass="board">

update board set title=#title#, content=#content# where idx=#idx#

</update>

<update id="cntUpdate" parameterClass="int">

update board set cnt=cnt+1 where idx=#value#

</update>

<delete id="delete" parameterClass="int">

delete from board where idx=#value#

</delete>

</sqlMap>