1、下载并解压MyBatis
https://github.com/mybatis/mybatis-3/releases
2、解压取出mybatis-3.4.1.jar(压缩文件中有参考文档mybatis-3.4.1.pdf)
3、在工程中引入mybatis-3.4.1.jar和mysql驱动包mysql-connector-java-5.1.31-bin.jar
(MySql驱动下载请参考:http://blog.csdn.net/laozhou243/article/details/52419974)
4、创建mybatis的配置文件mybatis-config.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>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost/zjrtest" />
<property name="username" value="abc" />
<property name="password" value="cba" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/zjr/test/mybatis/conf/BlogMapper.xml" />
</mappers>
</configuration>
其中mapper中配的BlogMapper.xml在下面步骤中创建
5、 创建测试表tbl_blog,并插入数据
create table tbl_blog
(
id int(4) not null primary key;
name char(20) not null,
sex char(1) not null default '0',
email char(64)
);
insert into tbl_blog values(1,'zjr','m','test@zjr.com');
insert into tbl_blog values(2,'Rose','f','rose@zjr.com');
6、 创建测试表对应的Java类Blog.java
<pre name="code" class="java">/**
* 文件名:Blog.java
* 版本信息:Version 1.0
* 日期:2016年9月3日
* 版权所有
*/
package com.zjr.test.mybatis;
public class Blog
{
int id;
String name;
char sex;
String email;
public int getId()
{
return id;
}
public void setId(int id)
{
this.id = id;
}
public String getName()
{
return name;
}
public void setName(String name)
{
this.name = name;
}
public char getSex()
{
return sex;
}
public void setSex(char sex)
{
this.sex = sex;
}
public String getEmail()
{
return email;
}
public void setEmail(String email)
{
this.email = email;
}
}
7、
创建映射文件BlogMapper.xml(步骤4中的配置)
<?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.zjr.test.mybatis.BlogMapper">
<select id="selectBlog" resultType="com.zjr.test.mybatis.Blog">
select * from tbl_blog where id = #{id}
</select>
</mapper>
8、 创建测试类MyBatisSamples.java
/**
* 文件名:MyBatisSamples.java
* 版本信息:Version 1.0
* 日期:2016年9月3日
* 版权所有
*/
package com.zjr.test.mybatis;
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;
public class MyBatisSamples
{
/**
* 方法描述:
*
* @param:
* @return:
* @version: 1.0
* @author: Administrator
* @version: 2016年9月3日 上午11:42:18
* @throws IOException
*/
public static void main(String[] args) throws IOException
{
String resource = "com/zjr/test/mybatis/conf/mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession session = sqlSessionFactory.openSession();
try
{
Blog blog = session.selectOne("com.zjr.test.mybatis.BlogMapper.selectBlog", 1);
System.out.println(blog.getName());
blog = session.selectOne("com.zjr.test.mybatis.BlogMapper.selectBlog", 2);
System.out.println(blog.getName());
}
finally
{
session.close();
}
}
}
9、执行main查看结果