MyBatis初探之环境的配置

很早之前就想学习mybatis,据说很多公司都使用这个框架。以前我都使用老掉牙的DBCP，Hibernate感觉太大，现在来学学这个中性的框架。

首先是环境的配置，我使用maven创建项目，pom.xml文件如下

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
4.0.0

com.bird
concursey
0.0.1-SNAPSHOT
jar

concursey
http://maven.apache.org

UTF-8

junit
junit
3.8.1
test

org.mybatis
mybatis
3.2.7



mysql
mysql-connector-java
5.1.32

还得创建一个数据库和对应的一张表做示范，这里就不写了，直接上对应的JavaBean

package com.bird.mybatis.bean;

public class Users {

private int id;
private String name;
private int age;

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 int getAge() {
return age;
}

public void setAge(int age) {
this.age = age;
}

@Override
public String toString() {
return "Users [id=" + id + ", name=" + name + ", age=" + age + "]";
}

}

然后要给对应的JavaBean创建对应的mapper.xml文件，内容如下

< xml version="1.0" encoding="UTF-8" >
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">



select * from users where id = #{id}

当然还有mybatis的全局文件，conf.xml内容如下

< xml version="1.0" encoding="UTF-8" >
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">

最后是测试代码

package com.bird.mybatis.bean;

import java.io.Reader;

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 Test {

public static void main(String[] args) throws Exception {
String resource = "conf.xml";
Reader reader = Resources.getResourceAsReader(resource);
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sessionFactory.openSession();
String statement = "com.bird.mybatis.bean.userMapper.getUser";
Users user = session.selectOne(statement, 1);
System.out.println(user);
}
}

总体来说还是非常简单的。