package com.songyan.dao;

import com.songyan.pojo.Student;

public interface StudentDao {

    public void insertStudent(Student student);

    public void deleteStudent(String id);

    public void updateStudent(Student student);

    public Student selectStudent(Integer id);

}

package com.songyan.dao;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import com.songyan.pojo.Student;

public class StudentDaoImpl implements StudentDao{

    private SqlSessionFactory sqlSessionFactory;

    public StudentDaoImpl(SqlSessionFactory sqlSessionFactory) {

        super();

        this.sqlSessionFactory = sqlSessionFactory;

    }

    public void insertStudent(Student student) {

    }

    public void deleteStudent(String id) {

    }

    public void updateStudent(Student student) {

    }

    public Student selectStudent(Integer id) {

        SqlSession session=sqlSessionFactory.openSession();

        Student student=session.selectOne("test.findStudentById",10);

        return student;

    }

}

<?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="test">

    <select id="findStudentById" parameterType="Integer"

        resultType="com.songyan.pojo.Student">

        select * from student where STU_ID= #{value}

    </select>

</mapper>

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

    <!--配置环境，默认的环境id为oracle -->

    <environments default="oracle">

        <!-- 配置环境为oracle的环境 -->

        <environment id="oracle">

            <!--使用JDBC的事务处理 -->

            <transactionManager type="JDBC" />

            <!--数据库连接池 -->

            <dataSource type="POOLED">

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

                <property name="url" value="jdbc:oracle:thin:@localhost:1521:inspur"></property>

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

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

            </dataSource>

        </environment>

    </environments>

    <!--配置mapper的位置 -->

    <mappers>

        <mapper resource="com/songyan/dao/test.xml" />

    </mappers>

</configuration>

package com.songyan.client;

import java.io.IOException;

import java.io.InputStream;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import org.junit.Before;

import org.junit.Test;

import com.songyan.dao.StudentDao;

import com.songyan.dao.StudentDaoImpl;

import com.songyan.pojo.Student;

public class Test1 {

    SqlSessionFactory sqlSessionFactory;

    @Before

    public void test1() throws IOException

    {

        String resource="applicationContext.xml";

        InputStream in=Resources.getResourceAsStream(resource);

        sqlSessionFactory=new SqlSessionFactoryBuilder().build(in);

    }

    @Test

    public void test()

    {

        StudentDao studentDao=new StudentDaoImpl(sqlSessionFactory);

        Student student=studentDao.selectStudent(1);

        System.out.println(student);

    }

}