---

driver=

url=

username=

password=

---

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

<!DOCTYPE mapper

PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"

"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">

<mapper namespace="conf.BlogMapper">

<select id="selectBlog" parameterType="int" resultType="ArrayList">

select *

from blog where id = ${id}

</select>

</mapper>

---

import java.io.IOException;

import java.io.Reader;

import java.util.List;

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 conf.Blog;

public class Main {

public static void main(String[] args) throws IOException {

String resource = "conf/Configuration.xml";

Reader reader = Resources.getResourceAsReader(resource);

SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder()

.build(reader);

SqlSession session = sqlSessionFactory.openSession();

List<Blog> blogList = null;

try {

blogList = session.selectList("conf.BlogMapper.selectBlog", 1);

} finally {

for (Blog blog : blogList) {

System.out.println(blog.getId());

System.out.println("Hello");

session.close();

}

}

}

}