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

    <!-- 对事务的管理和连接池的配置 -->

    <environments default="development">

        <environment id="development">

            <transactionManager type="JDBC" />

            <dataSource type="POOLED">

                <property name="driver" value="oracle.jdbc.driver.OracleDriver" />

                <property name="url"

                    value="jdbc:oracle:thin:@192.168.0.131:1521:portal" />

                <property name="username" value="mybatis" />

                <property name="password" value="mybatis" />

            </dataSource>

        </environment>

    </environments>

    <!-- mapping 文件路径配置 -->

    <mappers>

        <mapper resource="com/myOrg/deptUseMapper.xml" />

    </mappers>

</configuration>

<?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="com.myOrg.deptUseMapper">

    <select id="getDeptUserByID"  resultType="com.myOrg.DeptUserDomain">

        select * from deptUser where id='46df5041-5fe2-4bce-aaa1-9031ab929df4'

    </select>

    <insert id="save" parameterType="com.myOrg.DeptUserDomain">

        insert into deptUser value(,,)

    </insert>

</mapper>

package com.myOrg;

import java.sql.Date;

public class DeptUserDomain {

    String name;

    Date hireDate;

    float salary;

    String id;

    public void setId(String id) {

        this.id = id;

    }

    public String getId() {

        return id;

    }

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

    public Date getHireDate() {

        return hireDate;

    }

    public void setHireDate(Date hireDate) {

        this.hireDate = hireDate;

    }

    public float getSalary() {

        return salary;

    }

    public void setSalary(float salary) {

        this.salary = salary;

    }

}

package com.myOrg;

import org.apache.ibatis.session.SqlSession;

public class DeptUserOpt {

    public static void main(String[] args) {

        // TODO Auto-generated method stub

        SqlSession session=DeptUserUtil.getSession();

        DeptUserDomain domain=session.selectOne("com.myOrg.deptUseMapper.getDeptUserByID");

        System.out.println(domain.getName());

        session.commit();

        session.close();

    }

}

package com.myOrg;

import org.apache.ibatis.session.SqlSession;

public class DeptUserOpt {

    public static void main(String[] args) {

        // TODO Auto-generated method stub

        SqlSession session=DeptUserUtil.getSession();

        DeptUserDomain domain=session.selectOne("com.myOrg.deptUseMapper.getDeptUserByID");

        System.out.println(domain.getName());

        session.commit();

        session.close();

    }

}