一、搭建Mybaits环境的步骤
下面首先介绍创建mybaits环境的基本步骤,以从数据库中取一条数据为例,数据库中数据如下,数据库为mysql数据库。
1、首先创建一个java工程,并创建lib目录,在lib目录下导入mybaits和mysql的jar包,并加入环境中。
mybatis-3.1.1.jar
mysql-connector-java-5.1.7-bin.jar
2、在src目录下创建Mybaits的配置文件conf.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:3306/lzj_database" />
<property name="username" value="root" />
<property name="password" value="lzjlzj" />
</dataSource>
</environment>
</environments>
</configuration>
3、定义表的实体类User
package com.lzj.mybaits.test1;
public class User {
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 "User [id=" + id + ", name=" + name + ", age=" + age + "]";
}
}
4、定义操作数据库表users的sql映射文件userMapper.xml
<?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.lzj.mybaits.test1.userMapper">
<select id="getUser" parameterType="int"
resultType="com.lzj.mybaits.test1.User">
select * from users where id=#{id}
</select>
</mapper>
5、在conf.xml文件中注册userMapper.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:3306/lzj_database" />
<property name="username" value="root" />
<property name="password" value="lzjlzj" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/lzj/mybaits/test1/userMapper.xml"/>
</mappers>
</configuration>
6、编写测试代码,执行select语句
package com.lzj.mybaits.test1;
import java.io.InputStream;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class MybaitsTest {
public static void main(String[] args) throws Exception {
String resource = "conf.xml";
InputStream in = MybaitsTest.class.getClassLoader().getResourceAsStream(resource);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
SqlSession session = factory.openSession();
String statement = "com.lzj.mybaits.test1.userMapper.getUser";
User user = session.selectOne(statement, 2);
System.out.println(user);
}
执行测试类,输出结果如下:
User [id=2, name=Tom, age=10]
执行成功。
二、踩过的坑
踩过的坑1:在定义conf.xml的配置文件时,开头处为mybaits配置命名标准空间。
<?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>
……
</configuration>
如若在配置文件中用mybaits的各种配置标签,需要导入mybaits的标准命名约束,否则conf.xml文件中定义的标签会出错,因为没有约束文件,初建工程一般都要导入约束文件,本工程用的约束文件版本为mybatis-3-config.dtd
。导入过程如下:
Window -> Preference ->XML -> XML Catalog ,然后点击add从文件目录中加入约束文件,key type可以填写约束空间的名字-//mybatis.org//DTD Config 3.0//EN
如图所示
点击OK,之后,如图所示
踩过的坑2:在定义操作users表的sql映射文件userMapper.xml时要导入sql映射的约束。sql映射文件userMapper.xml的命名标准空间如下
<?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">
……
需要先导入-//mybatis.org//DTD Mapper 3.0//EN
约束,否则,映射文件中标签不能用,因为没有约束。本工程导入的约束文件的版本为mybatis-3-mapper.dtd
。导入步骤同上
注意:mybatis-3-config.dtd是配置mybaits的约束文件,mybatis-3-mapper.dtd是sql映射的约束文件,不要弄混了。(坑坏我了)
工程目录